public StringBuilder GetData() { StringBuilder sb = new StringBuilder(); string sql = @"select AA.APPLY_NO,AA.YS_NAME,AA.APPLY_DISPLAYNAME,AA.PAY_AMOUNT,AA.APPLY_DATE,AA.APPLY_DEPT from DABAN_BPM_DICS.dbo.YSJE_SQ_H AA LEFT JOIN BPMDB.DBO.SAP_COMPANYFUNDS_LINKS_QUEUE BB ON AA.APPLY_NO = BB.APPLY_NO where BB.ISLINK = 0"; DataTable dt = SQLHelper.ExecuteDataset(connStr, System.Data.CommandType.Text, sql).Tables[0]; LogInfo.Log.Info("《扩贩申请》获取需处理数量:" + dt.Rows.Count + "条"); for (int i = 0; i < dt.Rows.Count; i++) { AccVouch acc = new AccVouch(); acc.I_KOKRS = "1000"; //控制范围(I_KOKRS) acc.I_AUART = "ZZT1"; //订单类型(I_AUART) acc.I_AUFNR = dt.Rows[i]["APPLY_NO"].ToString(); //订单(I_AUFNR) acc.I_KTEXT = dt.Rows[i]["YS_NAME"].ToString(); //描述(I_KTEXT) acc.I_BUKRS = Code; //公司代码(I_BUKRS) acc.I_SCOPE = "OC"; //对象类(I_SCOPE) acc.I_USER0 = dt.Rows[i]["APPLY_DISPLAYNAME"].ToString(); //申请人(I_USER0) acc.I_USER1 = ""; //电话(I_USER1) acc.I_USER2 = ""; //负责人(I_USER2) acc.I_USER3 = ""; //电话1(I_USER3) acc.I_USER4 = dt.Rows[i]["PAY_AMOUNT"].ToString(); //估算成本(I_USER4) acc.I_USER5 = Convert.ToDateTime(dt.Rows[i]["APPLY_DATE"]).ToString("yyyyMMdd"); //申请日期(I_USER5) acc.I_USER6 = dt.Rows[i]["APPLY_DEPT"].ToString(); //部门(I_USER6) queue.Add(dt.Rows[i]["APPLY_NO"].ToString()); sb.AppendLine(acc.ToVouchString()); } return(sb); }
protected override List <AccVouch> DoLoad() { List <AccVouch> list = new List <AccVouch>(); for (int i = 0; i < context.KpsqEntitys.Count; i++) { KPSQEntity kpsqEntity = context.KpsqEntitys[i]; AccVouch accVouch = new AccVouch(); accVouch.XBLNR = context.ApplyNoEntity.ApplyNo; //参照号(XBLNR) accVouch.BLDAT = context.ApplyNoEntity.FinishAt; //凭证日期(BLDAT) accVouch.BUDAT = accVouch.BLDAT; //记账日期(BUDAT) string ywlx = string.Empty; //支付类型(取明细第一个) if (context.FKTZSZYDEntitys.Count != 0) { ywlx = context.FKTZSZYDEntitys[0].Z_YWLX; } accVouch.BKTXT = string.Format("{0}-{1}-{2}/{3}付{4}", context.Fktzs_C_HEntitys.PayObjId.Substring(2, 1), context.Fktzs_C_HEntitys.ApplyDept, ywlx, context.Fktzs_C_HEntitys.ApplyDisplayName, context.Fktzs_C_HEntitys.PayObjName); //抬头摘要(BKTXT) accVouch.WAERS = "CNY"; //币种(WAERS) accVouch.KURSF = "1"; //汇率(KURSF) accVouch.NEWKO = "F55555555"; //客户 / 供应商 / 会计科目代码(NEWKO) //金额小于0记账码为,大于等于0为25 if (kpsqEntity.WBCS < 0) { accVouch.NEWBS = "31";//记账码(NEWBS) } else { accVouch.NEWBS = "25"; //记账码(NEWBS) } accVouch.NEWUM = ""; //特殊总账标识(NEWUM) accVouch.NEWBW = ""; //資産取引タイプ(NEWBW) accVouch.KOSTL = ""; //成本中心(KOSTL) accVouch.PRCTR = ""; //利润中心(PRCTR) accVouch.PROJK = ""; //WBS要素(PROJK) accVouch.AUFNR = ""; //内部订单号(AUFNR) accVouch.WRBTR = kpsqEntity.WBCS.ToString().Abs(); //凭证货币金额(WRBTR) accVouch.DMBTR = ""; //本地货币金额(DMBTR) accVouch.MWSKZ = ""; //税码(MWSKZ) accVouch.ZUONR = kpsqEntity.XBLNR; //分配(ZUONR) accVouch.SGTXT = accVouch.BKTXT; //明細テキスト(SGTXT) accVouch.XREF1 = ""; //取引先参照キー1(XREF1) accVouch.XREF2 = ""; //取引先参照キー2(XREF2) accVouch.XREF3 = ""; //取引先参照キー3(XREF3) accVouch.ZFBDT = accVouch.BLDAT; //支払基準日(ZFBDT) accVouch.ZTERM = ""; //支払条件(ZTERM) accVouch.ZLSCH = ""; //支払方法(ZLSCH) accVouch.ZLSPR = ""; //支払保留(ZLSPR) accVouch.ZBD1T = ""; //日数(ZBD1T) accVouch.HBKID = ""; //取引銀行ID(HBKID) accVouch.BVTYP = ""; //銀行タイプ(BVTYP) accVouch.VALUT = ""; //起算日(VALUT) accVouch.WDATE = ""; //手形振出日(WDATE) accVouch.WBANK = ""; //銀行住所(WBANK) list.Add(accVouch); } return(list); }