public override void GetData() { ConnectFile.connectState(folderPath_Queue, "NisMail_UserName".ToAppSetting(), "NisMail_PWD".ToAppSetting()); DirectoryInfo TheFolder = new DirectoryInfo(folderPath_Queue); foreach (FileInfo NextFile in TheFolder.GetFiles("*_SECTION_?_????????.TSV"))//*_SECTION_?_????????.TSV //DSC_SECTION_C_20180202 { string sql = AggData(NextFile); Execute(sql, NextFile); } }
public override void GetData() { ConnectFile.connectState(folderPath_Queue, "NisMail_UserName".ToAppSetting(), "NisMail_PWD".ToAppSetting()); DirectoryInfo TheFolder = new DirectoryInfo(folderPath_Queue); foreach (FileInfo NextFile in TheFolder.GetFiles("ZACF*")) { string sql = AggData(NextFile); Execute(sql, NextFile); } }
public override void GetData() { aIncomePurchaseUpdate = AIncomePurchaseUpdate.Create(context.connStr, new IncomePurchaseUpdateType(IncomePurchaseUpdateType.Purchase)); ConnectFile.connectState(folderPath_Queue, "NisMail_UserName".ToAppSetting(), "NisMail_PWD".ToAppSetting()); DirectoryInfo TheFolder = new DirectoryInfo(folderPath_Queue); foreach (FileInfo NextFile in TheFolder.GetFiles("ZACF*")) { string sql = AggData(NextFile); Execute(sql, NextFile); } //回调 aIncomePurchaseUpdate.ExecuteQuery(IsExecuteQuery); }
public override void GetData() { LogInfo.Log.Info("执行SAP2成本中心主数据同步"); StringBuilder errMsg = new StringBuilder(); StringBuilder successMsg = new StringBuilder(); SQLHelper.ExecuteNonQuery(context.connStr, "DELETE FROM MAIN_COSTCENTER WHERE COMPANY IN (" + filter + ")"); //获得表结构和数据 DataTable costcenter = SQLHelper.ExecuteDataset(context.connStr, CommandType.Text, "SELECT COMPANY, CODE, NAME, DEPARTMENT, DEPARTMENT_TYPE, DEL_FLG FROM [DBO].[MAIN_COSTCENTER] WHERE COMPANY IN (" + filter + ")").Tables[0];//GetColumnNames_MAIN_COSTCENTER(); //向表中添加数据 DataRow dr; ConnectFile.connectState(filePath, "NisMail_UserName".ToAppSetting(), "NisMail_PWD".ToAppSetting()); using (StreamReader sr = new StreamReader(filePath, Encoding.UTF8)) { string str = sr.ReadToEnd(); string[] strlist = str.Split("\r\n".ToCharArray(), StringSplitOptions.RemoveEmptyEntries); for (int i = 0; i < strlist.Length; i++) { string[] strs = strlist[i].Split('\t'); if (!dic.ContainsKey(strs[0])) { errMsg.AppendLine(string.Format("第{0}行公司编码:{1}编码:{2}名称:{3}不存在于MAIN_COMPANY表中", (i + 1), strs[0], strs[1].TrimStart('0'), strs[2])); errorCount++; continue; } dr = costcenter.NewRow(); dr["COMPANY"] = dic[strs[0]]; dr["CODE"] = strs[1]; dr["NAME"] = strs[2]; dr["DEPARTMENT"] = strs[3]; dr["DEPARTMENT_TYPE"] = strs[4]; dr["DEL_FLG"] = strs[5].ToUpper() == "X" ? 1 : 0; costcenter.Rows.Add(dr); successMsg.AppendLine(string.Format("第{0}行公司:{1}编码:{2}名称:{3}部门:{4}部门类型:{5}成功", i + 1, dic[strs[0]], strs[1].TrimStart('0'), strs[2], strs[3], strs[4])); successCount++; } } try { ExecuteMainData(costcenter, "MAIN_COSTCENTER"); } catch (Exception ex) { //LogInfo.Log.Error(ex); //exception = ex; throw ex; } Log(); }
public override void GetData() { ConnectFile.connectState(folderPath_Queue, "NisMail_UserName".ToAppSetting(), "NisMail_PWD".ToAppSetting()); DirectoryInfo TheFolder = new DirectoryInfo(folderPath_Queue); foreach (FileInfo NextFile in TheFolder.GetFiles("PAY*.TSV")) { if (!FileCheck(NextFile, "PAY")) { context.MessageQueue(NextFile.FullName + "文件校验错误", NextFile.FullName + "文件校验错误"); FileMove(NextFile, folderPath_Faild); break; } string sql = AggData(NextFile); Execute(sql, NextFile); } }
public override void GetData() { //LogInfo.Log.Info("执行凭证数据回传"); StringBuilder errMsg = new StringBuilder(); StringBuilder successMsg = new StringBuilder(); //SQLHelper.ExecuteNonQuery(context.connStr, "DELETE FROM MAIN_SUPPLIER WHERE SUPP_TYPE=0 AND COMPANY IN(" + filter + ")"); StringBuilder sb_sql = new StringBuilder(); //向表中添加数据 ConnectFile.connectState(filePath, "NisMail_UserName".ToAppSetting(), "NisMail_PWD".ToAppSetting()); using (StreamReader sr = new StreamReader(filePath, Encoding.UTF8)) { string str = sr.ReadToEnd(); string[] strlist = str.Split("\r\n".ToCharArray(), StringSplitOptions.RemoveEmptyEntries); for (int i = 0; i < strlist.Length; i++) { string[] strs = strlist[i].Split('\t'); if (strs.Length < 4) { errMsg.AppendLine("第" + (i + 1) + "行数据完整性异常"); errorCount++; continue; } if (!dic.ContainsKey(strs[0])) { errMsg.AppendLine(string.Format("第{0}行公司编码:{1}不存在于MAIN_COMPANY表中", (i + 1), strs[0])); errorCount++; continue; } sb_sql.AppendLine(string.Format(@"insert into MAIN_SAP_FIN_ACCVOUCH(company,apply_no,voucher_no,account_date) values ('{0}','{1}','{2}','{3}');", dic[strs[0]], strs[2], strs[1], SplitDate(strs[3]))); successMsg.AppendLine(string.Format("第{0}行公司:{1}凭证组装成功", i + 1, dic[strs[0]])); successCount++; } } try { SQLHelper.ExecuteNonQuery(context.connStr, sb_sql.ToString()); } catch (Exception ex) { throw ex; } Log(); }
//时间 美元 欧元 日元 港币 泰铢 马币 public override void GetData() { string sql = "insert into MAIN_FOREIGN_EXCHANGE(DATE,USD,EUR,JPY,HKD,THB,MYR) values ('{0}','{1}','{2}','{3}','{4}','{5}','{6}');"; ConnectFile.connectState(folderPath_Queue, "NisMail_UserName".ToAppSetting(), "NisMail_PWD".ToAppSetting()); DirectoryInfo TheFolder = new DirectoryInfo(this.folderPath_Queue); foreach (FileInfo NextFile in TheFolder.GetFiles("dabanhl_*.txt")) { StringBuilder sb = new StringBuilder(); try { using (StreamReader sr = new StreamReader(NextFile.FullName, Encoding.UTF8)) { string str = sr.ReadToEnd(); string[] strlist = str.Split("\r\n".ToCharArray(), StringSplitOptions.RemoveEmptyEntries); for (int i = 0; i < strlist.Length; i++) { string[] strs = strlist[i].Split(','); if (strs.Length != 5) { continue; } DateTime date = Convert.ToDateTime(strs[0]); decimal USD = Convert.ToDecimal(strs[1]); decimal EUR = Convert.ToDecimal(strs[2]); decimal JPY = Convert.ToDecimal(strs[3]); decimal HKD = Convert.ToDecimal(strs[4]); decimal THB = Convert.ToDecimal(strs[5]); decimal MYR = Convert.ToDecimal(strs[6]); sb.AppendLine(string.Format(sql, date.ToShortDateString(), USD, EUR, JPY, HKD, THB, MYR)); } } Execute(sb.ToString(), NextFile); } catch (Exception ex) { LogInfo.Log.Error(ex); //发送邮件并移至错误文件夹中 context.MessageQueue("SAP联携异常", NextFile.FullName + "文件处理异常:" + ex.Message); FileMove(NextFile, folderPath_Faild); } } }
//公司代码 发票号 金额 会计凭证号 过帐日期 客户采购订单编号 public override void GetData() { string sql = "insert into DABAN_BPM_{0}.dbo.MAIN_KPSQ_INVOICE(CD,INVOICECODE,AMOUNT,ACCVOUCHCODE,DATE,APPLY_NO) values ('{0}','{1}','{2}','{3}','{4}','{5}');"; ConnectFile.connectState(folderPath_Queue, "NisMail_UserName".ToAppSetting(), "NisMail_PWD".ToAppSetting()); DirectoryInfo TheFolder = new DirectoryInfo(this.folderPath_Queue); foreach (FileInfo NextFile in TheFolder.GetFiles("INV_*.TSV")) { StringBuilder sb = new StringBuilder(); try { using (StreamReader sr = new StreamReader(NextFile.FullName, Encoding.UTF8)) { string str = sr.ReadToEnd(); string[] strlist = str.Split("\r\n".ToCharArray(), StringSplitOptions.RemoveEmptyEntries); for (int i = 1; i < strlist.Length; i++) { string[] strs = strlist[i].Split('\t'); if (strs.Length != 6) { continue; } string cd = main_Company_dic[strs[0]];//公司编码转换 string invoiceCode = strs[1]; decimal amount = Convert.ToDecimal(strs[2]); string accvouchCode = strs[3]; DateTime date = Convert.ToDateTime(strs[4]);// Convert.ToDateTime(SplitDate(strs[4]));//20180904格式化2018-09-04 string apply_no = strs[5]; sb.AppendLine(string.Format(sql, cd, invoiceCode, amount, accvouchCode, date, apply_no)); } } Execute(sb.ToString(), NextFile); } catch (Exception ex) { LogInfo.Log.Error(ex); //发送邮件并移至错误文件夹中 context.MessageQueue("SAP联携异常", NextFile.FullName + "文件处理异常:" + ex.Message); FileMove(NextFile, folderPath_Faild); } } }
public override void GetData() { LogInfo.Log.Info("执行SAP1供应商行主数据同步"); StringBuilder errMsg = new StringBuilder(); StringBuilder successMsg = new StringBuilder(); SQLHelper.ExecuteNonQuery(context.connStr, "DELETE FROM MAIN_SUPPLIER WHERE SUPP_TYPE=0 AND COMPANY IN(" + filter + ")"); DataTable mainsupplier = SQLHelper.ExecuteDataset(context.connStr, CommandType.Text, "SELECT COMPANY,SUPP_ID,SUPP_NAME,SUPP_ABB,SUPP_TYPE,BANK_NAME,BANK_SUB_NAME,BANK_ACCOUNT,DEL_FLG,SUPP_CODE FROM MAIN_SUPPLIER WHERE COMPANY IN(" + filter + ")").Tables[0]; //向表中添加数据 DataRow dr; ConnectFile.connectState(filePath, "NisMail_UserName".ToAppSetting(), "NisMail_PWD".ToAppSetting()); using (StreamReader sr = new StreamReader(filePath, Encoding.UTF8)) { string str = sr.ReadToEnd(); string[] strlist = str.Split("\r\n".ToCharArray(), StringSplitOptions.RemoveEmptyEntries); for (int i = 0; i < strlist.Length; i++) { string[] strs = strlist[i].Split('\t'); if (strs.Length < 76) { errMsg.AppendLine("第" + (i + 1) + "行数据完整性异常"); errorCount++; continue; } if (!dic.ContainsKey(strs[47])) { errMsg.AppendLine(string.Format("第{0}行公司编码:{1}供应商编码:{2}供应商名称:{3}不存在于MAIN_COMPANY表中", (i + 1), strs[47], strs[0], strs[2])); errorCount++; continue; } string key = dic[strs[47]] + strs[0]; dr = mainsupplier.NewRow(); dr["COMPANY"] = dic[strs[47]]; dr["SUPP_ID"] = strs[0]; dr["SUPP_NAME"] = strs[2]; dr["SUPP_ABB"] = strs[4]; if (string.IsNullOrEmpty(strs[0])) { dr["SUPP_TYPE"] = 1;//零星供应商 } else { dr["SUPP_TYPE"] = 0;//固定供应商 } dr["BANK_NAME"] = strs[76]; dr["BANK_SUB_NAME"] = strs[71]; dr["BANK_ACCOUNT"] = (strs[68] + strs[70]); //删除数据不插入 if (strs[51].ToUpper() == "X") { continue; } dr["DEL_FLG"] = strs[51].ToUpper() == "X" ? 1 : 0; dr["SUPP_CODE"] = strs[53]; mainsupplier.Rows.Add(dr); successMsg.AppendLine(string.Format("第{0}行公司:{1}供应商编码:{2}供应商名称:{3}银行账号:{4}成功", i + 1, dic[strs[47]], strs[0], strs[2], (strs[68] + strs[70]))); successCount++; } } try { ExecuteMainData(mainsupplier, "MAIN_SUPPLIER"); } catch (Exception ex) { //LogInfo.Log.Error(ex); //exception = ex; throw ex; } Log(); }
//经销商编码 禀议号 红字发票信息表编号 金额 预定结算方式 地区 public override void GetData() { /*ID 自增主键 * ACCOUNT 支付经销商代码 * BY_NO 禀议号 * INV_NO 发票号 * AMOUNT 金额 * TYPE 支付经销商 * AREA 地区 * APPLY_NO 采贩号 * DURATION 区间 * FLAG 冻结标志*/ string sql = "insert into BPMDB.dbo.MAIN_DIST_HP(FLAG,ACCOUNT,BY_NO,APPLY_NO,AMOUNT,TYPE,AREA,DURATION,ORDER_NO,ABSTRACT,CD) values (0,'{0}','{1}','{2}','{3}','{4}','{5}','{6}','{7}','{8}','{9}');"; ConnectFile.connectState(folderPath_Queue, "NisMail_UserName".ToAppSetting(), "NisMail_PWD".ToAppSetting()); //this.folderPath_Queue = @"D:\SourceCode\Files\Success"; DirectoryInfo TheFolder = new DirectoryInfo(this.folderPath_Queue); foreach (FileInfo NextFile in TheFolder.GetFiles("SF_Discount_Certificates_TO_DABAN*.TSV")) { bool IsError = false; StringBuilder sb = new StringBuilder(); try { using (StreamReader sr = new StreamReader(NextFile.FullName, Encoding.UTF8)) { string str = sr.ReadToEnd(); string[] strlist = str.Split("\r\n".ToCharArray(), StringSplitOptions.RemoveEmptyEntries); List <string> APPLY_NOS = new List <string>(); for (int i = 1; i < strlist.Length; i++) { string[] strs = strlist[i].Split('\t'); if (strs.Length != 10) { continue; } string ACCOUNT = strs[0].Trim(); string BY_NO = strs[1].Trim(); string APPLY_NO = strs[2].Trim(); if (APPLY_NOS.Contains(APPLY_NO)) { continue; } else { APPLY_NOS.Add(APPLY_NO); } decimal AMOUNT = Convert.ToDecimal(strs[3].Trim()); string TYPE = strs[4].Trim();// 需检查是否为1,2,3其中一个 if (TYPE != "1" && TYPE != "2" && TYPE != "3") { LogInfo.Log.Error(string.Format("红字发票信息表编号【{0}】的预定结算方式(汇款/转货款)非1, 2, 3其中一个", APPLY_NO)); IsError = true; continue; } string AREA = strs[5].Trim(); string DURATION = strs[6].Trim(); string ORDER_NO = strs[7].Trim(); string ABSTRACT = strs[8].Trim(); string COMPANY = strs[9].Trim(); sb.AppendLine(string.Format(sql, ACCOUNT, BY_NO, APPLY_NO, AMOUNT, TYPE, AREA, DURATION, ORDER_NO, ABSTRACT, COMPANY)); } } Execute(sb.ToString(), NextFile); } catch (Exception ex) { LogInfo.Log.Error(ex); IsError = true; //发送邮件并移至错误文件夹中 context.MessageQueue("SAP联携异常", NextFile.FullName + "文件处理异常:" + ex.Message); FileMove(NextFile, folderPath_Faild); } finally { if (IsError) { context.MessageQueue("折扣折让回传处理异常", "折扣折让回传处理异常,详情请查看Log记录!"); } } } }
//红字发票信息表编号 public override void GetData() { /*ID 数据表主键 * APPLY_NO 编号 * FLAG 标识 * TYPE 付款方式 * CAT 类型 * INV_NO 发票号码 * PAY_DATE 支付日期*/ //MAIN_DIST_HP // string sql = "insert into DABAN_BPM_DICS.dbo.MAIN_DIST_HPTYPE(CAT,APPLY_NO,FLAG,TYPE,INV_NO,PAY_DATE) values ({0},{1},{2},{3},{4},{5});"; string u_sql = "update BPMDB.dbo.MAIN_DIST_HP set FLAG='{0}',TYPE='{1}' where ORDER_NO='{2}'; "; //本地测试注释,正式环境释放(文件服务器连接) ConnectFile.connectState(folderPath_Queue, "NisMail_UserName".ToAppSetting(), "NisMail_PWD".ToAppSetting()); DirectoryInfo TheFolder = new DirectoryInfo(this.folderPath_Queue); foreach (FileInfo NextFile in TheFolder.GetFiles("SFD*.TSV")) { bool IsError = false; StringBuilder sb = new StringBuilder(); try { using (StreamReader sr = new StreamReader(NextFile.FullName, Encoding.UTF8)) { string str = sr.ReadToEnd(); string[] strlist = str.Split("\r\n".ToCharArray(), StringSplitOptions.RemoveEmptyEntries); for (int i = 1; i < strlist.Length; i++) { string[] strs = strlist[i].Split('\t'); if (strs.Length != 6) { continue; } string CAT = "'" + strs[0].Trim() + "'"; string ORDER_NO = "'" + strs[1].Trim() + "'"; //if (!IsExisit(strs[1].Trim())) { // LogInfo.Log.Error(string.Format("红字发票信息表编号【{0}】在 DABAN_BPM_DICS.dbo.MAIN_DIST_HP 中不存在!", strs[1].Trim())); // IsError = true; // continue; //} int FLAG = strs[2].Trim().ToUpper() == "X" ? 1 : 0; string TYPE = "'" + strs[3].Trim() + "'"; string INV_NO = "'" + strs[4].Trim() + "'"; string PAY_DATE = ""; if (string.IsNullOrEmpty(strs[5].Trim())) { PAY_DATE = "NULL"; } else { DateTime dt = DateTime.MinValue; PAY_DATE = "'" + DateTime.TryParse(strs[5], out dt).ToString() + "'"; } sb.AppendLine(string.Format(u_sql, FLAG, TYPE, ORDER_NO)); } } Execute(sb.ToString(), NextFile); } catch (Exception ex) { LogInfo.Log.Error(ex); IsError = true; //发送邮件并移至错误文件夹中 context.MessageQueue("供应商红票状态回传", NextFile.FullName + "文件处理异常:" + ex.Message); FileMove(NextFile, folderPath_Faild); } finally { if (IsError) { context.MessageQueue("折扣折让状态回传处理异常", "折扣折让状态回传处理异常,详情请查看Log记录!"); } } } }
public override void GetData() { LogInfo.Log.Info("执行SAP1客户行主数据同步"); StringBuilder errMsg = new StringBuilder(); StringBuilder successMsg = new StringBuilder(); SQLHelper.ExecuteNonQuery(context.connStr, "DELETE FROM MAIN_CUSTOMER WHERE COMPANY IN(" + filter + ")"); DataTable mainsupplier = SQLHelper.ExecuteDataset(context.connStr, CommandType.Text, "SELECT COMPANY, CSR_ID, CSR_NAME, CSR_ABB,FINCODE, DEL_FLG, KNA1KUNNR, KNA1LAND1, KNA1NAME1, KNA1NAME2, KNA1SORTL, KNA1ADRNR, KNA1ERDAT, KNA1ERNAM, KNA1KONZS, KNA1KTOKD, KNA1LIFNR, KNA1LOEVM, KNA1SPERR, KNA1SPRAS, KNA1STCD1, KNA1VBUND, KNA1STCEG, KNA1ZZDESTINATION, KNA1ZZPREFECTURE, KNA1ZZCITY, KNA1ZZAREACODE, KNA1ZZBIZMINUNIT, KNA1ZZCONCLASS, KNA1ZZRACUSTTYPE, KNA1ZZDEVDATE, KNA1ZZGRINOUTFLG, KNA1ZZVKBUR, KNA1ZKAIPIAO, KNA1ZHUISHOU, KNA1ZZGSQSEC_CUST, ADRCDATE_FROM, ADRCNATION, ADRCDATE_TO, ADRCTITLE, ADRCNAME1, ADRCNAME2, ADRCNAME3,ADRCNAME4, ADRCNAME_CO, ADRCCITY1, ADRCPOST_CODE1, ADRCPO_BOX, ADRCTRANSPZONE, ADRCSTREET, ADRCHOUSE_NUM1, ADRCSTR_SUPPL1,ADRCSTR_SUPPL2, ADRCSTR_SUPPL3, ADRCLOCATION, ADRCBUILDING, ADRCFLOOR, ADRCROOMNUMBER, ADRCCOUNTRY, ADRCLANGU, ADRCREGION, ADRCSORT1, ADRCSORT2, ADRCTEL_NUMBER, ADRCFAX_NUMBER, KNB1BUKRS, KNB1PERNR, KNB1ERDAT, KNB1ERNAM, KNB1SPERR, KNB1LOEVM,KNB1AKONT, KNB1ZTERM, KNVVVKORG, KNVVVTWEG, KNVVSPART, KNVVERNAM, KNVVERDAT, KNVVLOEVM, KNVVKALKS, KNVVKONDA, KNVVINCO1, KNVVINCO2, KNVVVSBED, KNVVWAERS, KNVVZTERM, KNVVVWERK, KNBKBANKS, KNBKBANKL, KNBKBANKN, KNBKBKONT, KNBKBKREF, KNBKKOINH, KNVKNAMEV, KNVKNAME1, KNVKTELF1, BNKABANKA FROM MAIN_CUSTOMER WHERE COMPANY IN(" + filter + ")").Tables[0]; //向表中添加数据 DataRow dr; ConnectFile.connectState(filePath, "NisMail_UserName".ToAppSetting(), "NisMail_PWD".ToAppSetting()); using (StreamReader sr = new StreamReader(filePath, Encoding.UTF8)) { string str = sr.ReadToEnd(); string[] strlist = str.Split("\r\n".ToCharArray(), StringSplitOptions.RemoveEmptyEntries); for (int i = 1; i < strlist.Length; i++) { string[] strs = strlist[i].Split('\t'); if (strs.Length < 92) { errMsg.AppendLine("第" + (i + 1) + "行数据完整性异常"); errorCount++; continue; } if (!dic.ContainsKey(strs[59])) { errMsg.AppendLine(string.Format("第{0}行公司编码:{1}客户行编码:{2}客户行名称:{3}不存在于MAIN_COMPANY表中", (i + 1), strs[59], strs[0], strs[2])); errorCount++; continue; } //string key = dic[strs[47]] + strs[0]; dr = mainsupplier.NewRow(); dr["COMPANY"] = dic[strs[59]]; dr["CSR_ID"] = strs[0]; dr["CSR_NAME"] = strs[2]; dr["CSR_ABB"] = strs[4]; dr["FINCODE"] = strs[65]; dr["DEL_FLG"] = strs[63].ToUpper() == "X" ? 1 : 0; dr["KNA1KUNNR"] = strs[0]; dr["KNA1LAND1"] = strs[1]; dr["KNA1NAME1"] = strs[2]; dr["KNA1NAME2"] = strs[3]; dr["KNA1SORTL"] = strs[4]; dr["KNA1ADRNR"] = strs[5]; if (strs[6] != "") { if (strs[6].Length == 8) { dr["KNA1ERDAT"] = SplitDate(strs[6]);//date } else { dr["KNA1ERDAT"] = DBNull.Value; } } else { dr["KNA1ERDAT"] = DBNull.Value; } dr["KNA1ERNAM"] = strs[7]; dr["KNA1KONZS"] = strs[8]; dr["KNA1KTOKD"] = strs[9]; dr["KNA1LIFNR"] = strs[10]; dr["KNA1LOEVM"] = strs[11]; dr["KNA1SPERR"] = strs[12]; dr["KNA1SPRAS"] = strs[13]; dr["KNA1STCD1"] = strs[14]; dr["KNA1VBUND"] = strs[15]; dr["KNA1STCEG"] = strs[16]; dr["KNA1ZZDESTINATION"] = strs[17]; dr["KNA1ZZPREFECTURE"] = strs[18]; dr["KNA1ZZCITY"] = strs[19]; dr["KNA1ZZAREACODE"] = strs[20]; dr["KNA1ZZBIZMINUNIT"] = strs[21]; dr["KNA1ZZCONCLASS"] = strs[22]; dr["KNA1ZZRACUSTTYPE"] = strs[23]; dr["KNA1ZZDEVDATE"] = strs[24]; dr["KNA1ZZGRINOUTFLG"] = strs[25]; dr["KNA1ZZVKBUR"] = strs[26]; dr["KNA1ZKAIPIAO"] = strs[27]; dr["KNA1ZHUISHOU"] = strs[28]; dr["KNA1ZZGSQSEC_CUST"] = strs[29]; if (strs[30] != "") { if (strs[30].Length == 8) { dr["ADRCDATE_FROM"] = SplitDate(strs[30]);//date } else { dr["ADRCDATE_FROM"] = DBNull.Value; } } else { dr["ADRCDATE_FROM"] = DBNull.Value; } dr["ADRCNATION"] = strs[31]; if (strs[32] != "") { if (strs[32].Length == 8) { dr["ADRCDATE_TO"] = SplitDate(strs[32]);//date } else { dr["ADRCDATE_TO"] = DBNull.Value; } } else { dr["ADRCDATE_TO"] = DBNull.Value; } dr["ADRCTITLE"] = strs[33]; dr["ADRCNAME1"] = strs[34]; dr["ADRCNAME2"] = strs[35]; dr["ADRCNAME3"] = strs[36]; dr["ADRCNAME4"] = strs[37]; dr["ADRCNAME_CO"] = strs[38]; dr["ADRCCITY1"] = strs[39]; dr["ADRCPOST_CODE1"] = strs[40]; dr["ADRCPO_BOX"] = strs[41]; dr["ADRCTRANSPZONE"] = strs[42]; dr["ADRCSTREET"] = strs[43]; dr["ADRCHOUSE_NUM1"] = strs[44]; dr["ADRCSTR_SUPPL1"] = strs[45]; dr["ADRCSTR_SUPPL2"] = strs[46]; dr["ADRCSTR_SUPPL3"] = strs[47]; dr["ADRCLOCATION"] = strs[48]; dr["ADRCBUILDING"] = strs[49]; dr["ADRCFLOOR"] = strs[50]; dr["ADRCROOMNUMBER"] = strs[51]; dr["ADRCCOUNTRY"] = strs[52]; dr["ADRCLANGU"] = strs[53]; dr["ADRCREGION"] = strs[54]; dr["ADRCSORT1"] = strs[55]; dr["ADRCSORT2"] = strs[56]; dr["ADRCTEL_NUMBER"] = strs[57]; dr["ADRCFAX_NUMBER"] = strs[58]; dr["KNB1BUKRS"] = strs[59];//COMPANY dr["KNB1PERNR"] = strs[60]; if (strs[61] != "") { if (strs[61].Length == 8) { dr["KNB1ERDAT"] = SplitDate(strs[61]);//date } else { dr["KNB1ERDAT"] = DBNull.Value; } } else { dr["KNB1ERDAT"] = DBNull.Value; } dr["KNB1ERNAM"] = strs[62]; dr["KNB1SPERR"] = strs[63]; dr["KNB1LOEVM"] = strs[64]; dr["KNB1AKONT"] = strs[65]; dr["KNB1ZTERM"] = strs[66]; dr["KNVVVKORG"] = strs[67]; dr["KNVVVTWEG"] = strs[68]; dr["KNVVSPART"] = strs[69]; dr["KNVVERNAM"] = strs[70]; if (strs[71] != "") { if (strs[71].Length == 8 && strs[71] != "00000000") { dr["KNVVERDAT"] = SplitDate(strs[71]);//date } else { dr["KNVVERDAT"] = DBNull.Value; } } else { dr["KNVVERDAT"] = DBNull.Value; } dr["KNVVLOEVM"] = strs[72]; dr["KNVVKALKS"] = strs[73]; dr["KNVVKONDA"] = strs[74]; dr["KNVVINCO1"] = strs[75]; dr["KNVVINCO2"] = strs[76]; dr["KNVVVSBED"] = strs[77]; dr["KNVVWAERS"] = strs[78]; dr["KNVVZTERM"] = strs[79]; dr["KNVVVWERK"] = strs[80]; dr["KNBKBANKS"] = strs[81]; dr["KNBKBANKL"] = strs[82]; dr["KNBKBANKN"] = strs[83]; dr["KNBKBKONT"] = strs[84]; dr["KNBKBKREF"] = strs[85]; dr["KNBKKOINH"] = strs[86]; dr["KNVKNAMEV"] = strs[87]; dr["KNVKNAME1"] = strs[88]; dr["KNVKTELF1"] = strs[89]; dr["BNKABANKA"] = strs[90];//97 个字段 mainsupplier.Rows.Add(dr); successMsg.AppendLine(string.Format("第{0}行公司:{1}客户行编码:{2}客户行名称:{3}成功", i + 1, dic[strs[59]], strs[0], strs[2])); successCount++; } } try { ExecuteMainData(mainsupplier, "MAIN_CUSTOMER"); } catch (Exception ex) { //LogInfo.Log.Error(ex); //exception = ex; throw ex; } Log(); }