private void GetSqlByList(string companyCode, DataRow[] drs, ref Dictionary <string, List <RecList> > dic, ref Dictionary <string, T_SAP_COMPANYFUNDS_LINKS_QUEUE> dicQ) { T_SAP_COMPANYFUNDS_LINKS_QUEUE queue = new T_SAP_COMPANYFUNDS_LINKS_QUEUE(); //companyCode = "1020"; string filePath = "DICS_Path_Rec".ToAppSetting(); string fileName = "DICS_Name_Rec".ToAppSetting() + "_" + companyCode + "_" + DateTime.Now.ToString("yyyyMMdd"); string fileExt = "DICS_Ext_Rec".ToAppSetting(); //string sql = @"SELECT * FROM DABAN_BPM_DICS.DBO.V_EmptyAndClearSale_Post A // INNER JOIN SAP_COMPANYFUNDS_LINKS_QUEUE B // ON A.SN = B.APPLY_NO AND ISLINK = 0"; //DataTable dt = SQLHelper.ExecuteDataset("BPMDB".ToConnectionString(), System.Data.CommandType.Text, sql).Tables[0]; List <RecList> recList = new List <RecList>(); if (dic.ContainsKey(companyCode)) { recList = dic[companyCode]; } if (dicQ.ContainsKey(companyCode)) { queue = dicQ[companyCode]; } for (int i = 0; i < drs.Length; i++) { queue.Add(Convert.ToString(drs[i]["SN"])); getDtFor40(drs[i], recList); getDtFor19(drs[i], recList); } if (dic.ContainsKey(companyCode)) { dic[companyCode] = recList; } else { dic.Add(companyCode, recList); } if (dicQ.ContainsKey(companyCode)) { dicQ[companyCode] = queue; } else { dicQ.Add(companyCode, queue); } //AccvouchEntityConvertStreamBaseManager accvouchEntityConvertStreamBaseManager = new AccvouchEntityConvertStreamBaseManager(); //SapLinksQueueEntity sapLinksQueue = new SapLinksQueueEntity("BPMDB".ToConnectionString(), queue.GetSql_ISLINK1()); //StringBuilder sb = new StringBuilder(); //foreach (RecList item in recList) //{ // sb.AppendLine(item.ToVouchString()); //} //SAPLinks.Helper.SaveFile.ISaveFileProvider saveFileProvider = SapSaveFileProviderFactory.CreateSaveProvider(sapLinksQueue); //saveFileProvider.AddFileInfo(new SapSaveFileInfo(filePath, fileName + fileExt, sb)); //saveFileProvider.SaveFile(); }
public void Start() { //T_SAP_COMPANYFUNDS_LINKS_QUEUE queue = new T_SAP_COMPANYFUNDS_LINKS_QUEUE(); Dictionary <string, List <RecList> > dic = new Dictionary <string, List <RecList> >(); Dictionary <string, T_SAP_COMPANYFUNDS_LINKS_QUEUE> dicQ = new Dictionary <string, T_SAP_COMPANYFUNDS_LINKS_QUEUE>(); //MLog.Log.Info("aaa").Info("11111"); try { LogInfo.Log.Info("职工机购买-收据开具SAP连携"); RecEntity recEntity = new RecEntity(); recEntity.GetSqlByList(ref dic, ref dicQ); } catch (Exception ex) { LogInfo.Log.Info("职工机购买-收据开具SAP连携——异常:" + ex.Message); } try { LogInfo.Log.Info("限时特卖-收据开具SAP连携"); SpecialSaleEntity sse = new SpecialSaleEntity(); sse.SyncSap(ref dic, ref dicQ); } catch (Exception ex) { LogInfo.Log.Info("限时特卖-收据开具SAP连携——异常:" + ex.Message); } try { LogInfo.Log.Info("解限SAP连携"); JXBatchListEntity jx = new JXBatchListEntity(); jx.SyncSap(ref dic, ref dicQ); } catch (Exception ex) { LogInfo.Log.Info("解限SAP连携——异常:" + ex.Message); } foreach (var item in dic) { string filePath = "DICS_Path_Rec".ToAppSetting(); string fileName = "DICS_Name_Rec".ToAppSetting() + "_" + item.Key + "_" + DateTime.Now.ToString("yyyyMMdd"); string fileExt = "DICS_Ext_Rec".ToAppSetting(); List <RecList> recList = dic[item.Key]; T_SAP_COMPANYFUNDS_LINKS_QUEUE queue = dicQ[item.Key]; AccvouchEntityConvertStreamBaseManager accvouchEntityConvertStreamBaseManager = new AccvouchEntityConvertStreamBaseManager(); SapLinksQueueEntity sapLinksQueue = new SapLinksQueueEntity("BPMDB".ToConnectionString(), queue.GetSql_ISLINK1()); StringBuilder sb = new StringBuilder(); foreach (RecList rl in recList) { sb.AppendLine(rl.ToVouchString()); } SAPLinks.Helper.SaveFile.ISaveFileProvider saveFileProvider = SapSaveFileProviderFactory.CreateSaveProvider(sapLinksQueue); saveFileProvider.AddFileInfo(new SapSaveFileInfo(filePath, fileName + fileExt, sb)); saveFileProvider.SaveFile(); } }
private string GetUpdateSapLinkQueue(ApplyNoEntityCollection applyNoEntityCollection) { T_SAP_COMPANYFUNDS_LINKS_QUEUE tquere = new T_SAP_COMPANYFUNDS_LINKS_QUEUE(); foreach (ApplyNoEntity applyNoEntity in applyNoEntityCollection) { tquere.Add(applyNoEntity.ApplyNo); } return(tquere.GetSql_ISLINK1()); }
private void GetSqlByList(string companyCode, DataRow[] drs, ref Dictionary <string, List <RecList> > dic, ref Dictionary <string, T_SAP_COMPANYFUNDS_LINKS_QUEUE> dicQ) { T_SAP_COMPANYFUNDS_LINKS_QUEUE queue = new T_SAP_COMPANYFUNDS_LINKS_QUEUE(); string filePath = "DICS_Path_Rec".ToAppSetting(); string fileName = "DICS_Name_Rec".ToAppSetting() + "_" + companyCode + "_" + DateTime.Now.ToString("yyyyMMdd"); string fileExt = "DICS_Ext_Rec".ToAppSetting(); List <RecList> recList = new List <RecList>(); if (dic.ContainsKey(companyCode)) { recList = dic[companyCode]; } if (dicQ.ContainsKey(companyCode)) { queue = dicQ[companyCode]; } for (int i = 0; i < drs.Length; i++) { queue.Add(Convert.ToString(drs[i]["BATCH_NO"])); getDtFor40(drs[i], recList); getDtFor50(drs[i], recList); } if (dic.ContainsKey(companyCode)) { dic[companyCode] = recList; } else { dic.Add(companyCode, recList); } if (dicQ.ContainsKey(companyCode)) { dicQ[companyCode] = queue; } else { dicQ.Add(companyCode, queue); } //AccvouchEntityConvertStreamBaseManager accvouchEntityConvertStreamBaseManager = new AccvouchEntityConvertStreamBaseManager(); //SapLinksQueueEntity sapLinksQueue = new SapLinksQueueEntity("BPMDB".ToConnectionString(), queue.GetSql_ISLINK1()); //StringBuilder sb = new StringBuilder(); //foreach (RecList item in recList) //{ // sb.AppendLine(item.ToVouchString()); //} //SAPLinks.Helper.SaveFile.ISaveFileProvider saveFileProvider = SapSaveFileProviderFactory.CreateSaveProvider(sapLinksQueue); //saveFileProvider.AddFileInfo(new SapSaveFileInfo(filePath, fileName + fileExt, sb)); //saveFileProvider.SaveFile(); }