//相关客户
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);
}
