using System;

using System.Collections.Generic;

using System.Linq;

using System.Text;

using System.Threading.Tasks;

using Kingdee.BOS;

using Kingdee.BOS.Contracts;

using Kingdee.BOS.Core;

using Kingdee.BOS.ServiceHelper;

using System.Data;

using System.Diagnostics;

[Description("采购申请单上的要货日期自动从询价单下推比价单自动提交比价单审批流程")]

public class FQuoteSumIScheduleService : IScheduleService

{

int FID = 0;

public void Run(Context ctx, Schedule schedule)

{

//查找要的要货日期FAPPLYDATE T_PUR_ReqEntry

string sql = "select FID,FAPPLYDATE from T_PUR_ReqEntry ";

string date = DateTime.Now.AddDays(3).ToString("yyyy-MM-dd");

DataSet ds = DBServiceHelper.ExecuteDataSet(ctx, string.Format(sql));

//doPush(ctx);T_PUR_Requisition

if (ds.Tables[0].Rows.Count > 0)

{

foreach (DataRow row in ds.Tables[0].Rows)

{

string dt = row["FAPPLYDATE"].ToString();//

int FID = (int)row["FID"];//

if (dt.Contains(date))

{

string FBILLNO="";

string sql1 = "select FBILLNO from T_PUR_Requisition where FID = {0}";// FBILLNO单据编号

DataSet d = DBServiceHelper.ExecuteDataSet(ctx, string.Format(sql1,FID));

for (int i=0;i<d.Tables[0].Rows.Count;i++) {

FBILLNO = d.Tables[0].Rows[i]["FBILLNO"].ToString();//

}

//询价单fid

string sql2 = "select FID from T_SVM_INQUIRYENTRY where FSOURCEBILLNO = '{0}' ";//T_SVM_INQUIRYENTRY

DataSet SVM = DBServiceHelper.ExecuteDataSet(ctx, string.Format(sql2, FBILLNO));

for (int i = 0; i < SVM.Tables[0].Rows.Count; i++)

{

FID = (int)SVM.Tables[0].Rows[i]["FID"];//100016 100012

}

doPush(ctx);

}

}

}

}

public void doPush(Context ctx)

{

FormMetadata targetBill = MetaDataServiceHelper.Load(ctx, "SVM_ComparePrice") as FormMetadata;//SVM_ComparePrice

var rule = ConvertServiceHelper.GetConvertRule(ctx, "SVM_InquiryBill-SVM_ComparePrice");

ListSelectedRow[] selectedRowsBill = GenerateListSelectedRowsBill(FID.ToString(), "SVM_InquiryBill"); //选择下推的单据 SVM_InquiryBill

ConvertOperationResult operationResult = null;

Dictionary<string, object> custParams = new Dictionary<string, object>();

try

{

PushArgs pushArgs = new PushArgs(rule.Rule, selectedRowsBill)

{

TargetBillTypeId = "570cd65be7a1b8",//单据类型

TargetOrgId = 1,

CustomParams = custParams,

};

var opt = OperateOption.Create();

opt.SetVariableValue("ValidatePermission", true);//取消权限校验

operationResult = ConvertServiceHelper.Push(ctx, pushArgs, opt);

}

catch (Exception ex)

{

string message = ex.Message;

}

if (operationResult != null)

{

DynamicObject[] objs = (from p in operationResult.TargetDataEntities select p.DataEntity).ToArray();

foreach (DynamicObject obj in objs)

{

//obj就是下推之后产生的单据数据包：

OperateOption saveOption = OperateOption.Create();

saveOption.SetVariableValue("IgnoreWarning", true);

saveOption.SetVariableValue("_IgnoreInteraction_", true);

IOperationResult rs2 = BusinessDataServiceHelper.Save(ctx, targetBill.BusinessInfo, obj, saveOption);

}

}

}

/// <summary>

/// 选择整单下推

/// </summary>

/// <param name="fid"></param>

/// <param name="strFormId"></param>

/// <returns></returns>

private ListSelectedRow[] GenerateListSelectedRowsBill(string fid, string strFormId)

{

IList<ListSelectedRow> source = new List<ListSelectedRow>();

ListSelectedRow singleRow = new ListSelectedRow(fid, "0", 0, strFormId);

source.Add(singleRow);

return source.ToArray<ListSelectedRow>();

}

}

产品问题执行计划进行自动下推单据，执行成功，但是没有下推的单据

100 产品问题 执行计划进行自动下推单据，执行成功，但是没有下推的单据

恭喜您！

产品问题
执行计划进行自动下推单据，执行成功，但是没有下推的单据

100 产品问题执行计划进行自动下推单据，执行成功，但是没有下推的单据