public static void EmployeeInsertForDingTalk(SqlSugarClient Edb, SqlSugarClient Ddb, List <V_EmployeeToDingTalk> ESB_EmployeeList)
{
LogHelper log = LogFactory.GetLogger("EmployeeInsertForDingTalk");
List <V_OperationObject> OperationList = new List <V_OperationObject>();
List <V_EmployeeToDingTalk> EmpList = new List <V_EmployeeToDingTalk>();
OperationList = Tbiz_OperationTempBll.GetOperationList(Edb, 1, 1);
List <V_EmployeeToDingTalk> EmployeeList = ESB_EmployeeList.Where(p => OperationList.Exists(q => q.UserId == p.UserId)).ToList();
log.Info("\r\n------------------------------------------------ESB人员数据导入到钉钉------------------------------------------------\r\n");
#region 循环插入到钉钉
foreach (var item in EmployeeList)
{
if (item.Enabled == 1)
{
InsertForDingTalk(Edb, Ddb, EmpList, item);
}
else
{
DeleteForDingTalk(Ddb, EmpList, item);
}
}
int d = 0;
foreach (var item in EmpList)
{
d = Edb.Deleteable <Tbiz_OperationTemp>().Where(it => it.ObjectId.Equals(item.UserId)).ExecuteCommand();
}
#endregion
}
public static void EmployeeUpdateForDingTalk(SqlSugarClient Edb, SqlSugarClient Ddb, List <V_EmployeeToDingTalk> ESB_EmployeeList)
{
LogHelper log = LogFactory.GetLogger("EmployeeUpdateForDingTalk");
List <V_EmployeeToDingTalk> EmpList = new List <V_EmployeeToDingTalk>();
//获取ESB中目前已经更新的数据
List <V_OperationObject> OperationList = Tbiz_OperationTempBll.GetOperationList(Edb, 1, 0);
//根据ESB操作记录中更新的ID，查出目前的用户信息
List <V_EmployeeToDingTalk> EmployeeList = ESB_EmployeeList.Where(p => OperationList.Exists(q => q.UserId == p.UserId)).ToList();
log.Info("\r\n------------------------------------------------根据ESB更新钉钉中的人员信息------------------------------------------------\r\n");
#region 循环更新到钉钉
foreach (var item in EmployeeList)
{
if (item.Enabled == 1)
{
string EmployeeJson = GetEmployee(item.UserId);
//用户ID在钉钉中不存在，即：离职用户重新录用时，应将该用户重新添加进钉钉
if (EmployeeJson.Equals("-1"))
{
AddEmployee(Edb, Ddb, item);
EmpList.Add(item);
continue;
}
else
{
EmployeeEntity model = Newtonsoft.Json.JsonConvert.DeserializeObject <EmployeeEntity>(EmployeeJson);
string oldMobile = model.mobile;
string DD_DepartmentId = "1";
DepartmentResult DD_DepModel = Ddb.Queryable <DepartmentResult>().With(SqlWith.NoLock).Where(it => it.ESB_DepartmentID.Equals(item.ESB_DepartmentId)).First();
if (DD_DepModel == null)
{
try
{
DD_DepartmentId = DepartmentForDingTalkBll.DD_DepartmentIsNullForDingTalk(Edb, Ddb, item.ESB_DepartmentId);
}
catch (Exception ex)
{
DD_DepartmentId = DepartmentForDingTalkBll.DD_DepartmentIsNullForDingTalk(Edb, Ddb, item.ESB_DepartmentId);
}
}
else
{
DD_DepartmentId = DD_DepModel.id;
}
model.userid = item.UserId;
model.name = item.Name;
model.department = new List <int>(new int[] { Convert.ToInt32(DD_DepartmentId) });
model.position = item.PositionName;
model.mobile = item.Mobile;
model.tel = item.Telephone;
model.email = item.Email;
model.jobnumber = item.UserId;
string param = model.ToJson();
Result Result = EmployeeBll.Update(param);
if (Result != null)
{
if (Result.errcode == "0")
{
EmpList.Add(item);
//Console.Write("更新成功," + Result.errmsg);
}
else
{
//UserID不存在
if (Result.errcode == "60111")
{
AddEmployee(Edb, Ddb, item);
EmpList.Add(item);
continue;
}
//更新手机号出错时
else if (Result.errcode == "40022" || Result.errcode == "40021" || Result.errcode == "60104" || Result.errcode == "60121")
{
//40021 更换的号码已注册过钉钉，无法使用该号码
//40022 企业中的手机号码和登陆钉钉的手机号码不一致,暂时不支持修改用户信息,可以删除后重新添加
//60104 手机号码在公司中已存在
//60121 找不到该用户
string Deletecode = EmployeeBll.Delete(model.userid).errcode;
string Createcode = EmployeeBll.Create(model.ToJson()).errcode;
if (Createcode != "0")
{
Createcode = EmployeeBll.Create(model.ToJson()).errcode;
if (Createcode != "0" && Createcode != "40021")
{
log.Error("\r\n EmployeeUpdateForDingTalk - 行号135 更新钉钉人员信息时，成功删除员工信息，但是创建员工信息时报错，错误编码如下：" + Createcode + ", 员工编号为：" + model.userid);
}
}
EmpList.Add(item);
Task.Factory.StartNew(() =>
{
InsertErroUpdateEmployee(Ddb, model.userid, oldMobile, item.Mobile, Result.errcode);
if (Deletecode != "0")
{
InsertErroUpdateEmployee(Ddb, model.userid, oldMobile, item.Mobile, "删除失败，错误编号：" + Deletecode);
}
if (Createcode != "0")
{
InsertErroUpdateEmployee(Ddb, model.userid, oldMobile, item.Mobile, "执行删除后创建失败，错误编号：" + Createcode);
}
});
//Console.Write("更新成功\r\n");
}
else
{
//手机号码不合法
if (Result.errcode == "60103")
{
model.mobile = oldMobile;
Result = EmployeeBll.Update(model.ToJson());
if (Result.errcode == "0")
{
EmpList.Add(item);
}
else
{
log.Error("\r\n EmployeeForDingTalkBll-EmployeeUpdateForDingTalk() 失败后不更新手机号，还是失败，具体信息： " + Result.errmsg + "; UserId=" + item.UserId);
}
}
//部门在钉钉中不存在的时候
else if (Result.errcode == "60003")
{
model.department = new List <int>(new int[] { 1 });
param = model.ToJson();
Result r = EmployeeBll.Update(param);
if (r.errcode == "0")
{
EmpList.Add(item);
}
else if (r.errcode == "40022" || r.errcode == "40021" || r.errcode == "60104" || r.errcode == "60121")
{
//40021 更换的号码已注册过钉钉，无法使用该号码
//40022 企业中的手机号码和登陆钉钉的手机号码不一致,暂时不支持修改用户信息,可以删除后重新添加
//60104 手机号码在公司中已存在
//60121 找不到该用户
string Deletecode = EmployeeBll.Delete(model.userid).errcode;
string Createcode = EmployeeBll.Create(model.ToJson()).errcode;
if (Createcode != "0")
{
Createcode = EmployeeBll.Create(model.ToJson()).errcode;
if (Createcode != "0" && Createcode != "40021")
{
log.Error("\r\n EmployeeUpdateForDingTalk - 行号199 更新钉钉人员信息时，成功删除员工信息，但是创建员工信息时报错，错误编码如下：" + Createcode);
}
}
EmpList.Add(item);
Task.Factory.StartNew(() =>
{
InsertErroUpdateEmployee(Ddb, model.userid, oldMobile, item.Mobile, r.errcode);
if (Deletecode != "0")
{
InsertErroUpdateEmployee(Ddb, model.userid, oldMobile, item.Mobile, "删除失败，错误编号：" + Deletecode);
}
if (Createcode != "0")
{
InsertErroUpdateEmployee(Ddb, model.userid, oldMobile, item.Mobile, "执行删除后创建失败，错误编号：" + Createcode);
}
});
//Console.Write("更新成功\r\n");
}
else
{
log.Debug("\r\n EmployeeForDingTalkBll-EmployeeUpdateForDingTalk() 钉钉中部，部门id=" + DD_DepartmentId + ",已将该人员挂在公司下，" + Result.errmsg + "; UserId=" + item.UserId);
Task.Factory.StartNew(() =>
{
InsertErroUpdateEmployee(Ddb, model.userid, oldMobile, item.Mobile, "更新用户时失败，错误编号：" + Result.errcode);
});
}
}
else
{
log.Error("\r\n EmployeeForDingTalkBll-EmployeeUpdateForDingTalk() " + Result.errmsg + "; UserId=" + item.UserId);
Task.Factory.StartNew(() =>
{
InsertErroUpdateEmployee(Ddb, model.userid, oldMobile, item.Mobile, "更新用户时失败，错误编号：" + Result.errcode);
});
}
}
}
}
else
{
//Console.Write("无返回数据");
}
}
}
else
{
Result Result = EmployeeBll.Delete(item.UserId);
if (Result != null)
{
//找不到该用户
if (Result.errcode == "0" || Result.errcode == "60121")
{
EmpList.Add(item);
//Console.Write("删除成功," + Result.errmsg + "\r\n");
}
else
{
log.Error("\r\n EmployeeForDingTalkBll-EmployeeUpdateForDingTalk() " + Result.errmsg + "; UserId=" + item.UserId);
//Console.Write("\r\n" + Result.errmsg + "; UserId=" + item.UserId);
}
}
else
{
//Console.Write("无返回数据");
}
}
}
int d = 0;
foreach (var item in EmpList)
{
d = Edb.Deleteable <Tbiz_OperationTemp>().Where(it => it.ObjectId.Equals(item.UserId)).ExecuteCommand();
}
#endregion
}
