//相关客户 public int UpdateRelatedcustomers(DataRow row, int rowid, string commDB, SqlConnection _connection) { int result = 0; string sNo = row["客户代码"].ToString(); string relatedcustomers = row["相关客户代码"].ToString(); if (!string.IsNullOrEmpty(sNo) && !string.IsNullOrEmpty(relatedcustomers) && relatedcustomers.Trim() != "0") { //1.查询出相关客户代码系统ID string strSql = "select n_ClientID from TCstmr_Client where s_ClientCode='" + sNo + "'"; int Num = _dbHelper.GetbySql(strSql, commDB, _connection); if (Num > 0) { //1.根据客户代码查询出所有客户案件 strSql = "select n_CaseID from TCase_Base where n_ClientID in (select n_ClientID from TCstmr_Client where s_ClientCode='" + sNo + "')"; DataTable table = _dbHelper.GetDataTablebySql(strSql, _connection); strSql = "select n_CaseID from TCase_Applicant where n_ApplicantID in(select n_AppID from TCstmr_Applicant where s_AppCode='" + sNo + "')"; DataTable newtable = _dbHelper.GetDataTablebySql(strSql, _connection); table.Merge(newtable); var _dealingCasePantent = new dealingCasePantent(); for (int k = 0; k < table.Rows.Count; k++) { _dealingCasePantent.InsertTCaseClients(relatedcustomers, int.Parse(table.Rows[k]["n_CaseID"].ToString()), rowid, "相关客户-集团客户代码", commDB, _connection); } result = 1; } else { _dbHelper.InsertLog(0, "", rowid, "相关客户-集团客户代码", "相关客户-集团客户代码-" + rowid, "为查到此客户信息:" + sNo, "", commDB, _connection); } } return(result); }
//案件处理人 public int InsertCaseAttorney(DataTable table, int _rowid, DataRow dr, string commDB, SqlConnection _connection) { int result = 0; string sNo = dr["我方卷号"].ToString().Trim(); int hkNum = _dbHelper.GetIDbyName(sNo, 2, _connection); if (hkNum.Equals(0)) { _dbHelper.InsertLog(0, sNo, _rowid, "国内-OA数据补充导入(辅表)-已翻译代理人", "国内-OA数据补充导入(辅表)-已翻译代理人-" + _rowid, "未找到“我方卷号”为:" + sNo, "", commDB, _connection); return(0); } else { result = 1; if (!string.IsNullOrEmpty(dr["代理人"].ToString().Trim())) { string[] ArryUser = dr["代理人"].ToString().Split(' '); if (ArryUser.Length > 0) { if (!string.IsNullOrEmpty(ArryUser[0])) { var _dealingCasePantent = new dealingCasePantent(); _dealingCasePantent.InsertUser(ArryUser[0].Trim().Replace(" ", ""), hkNum, _rowid, "代理部-OA阶段-办案人", "国内-OA数据补充导入(辅表)-已翻译代理人", commDB, _connection); } } } } return(result); }