public async Task <Sys_UserInfo> GetUser(string Id)
{
return(await Task.Run(() =>
{
var user = BLLFactory <Sys_User> .Instance.FindByID(Id);
if (user != null)
{
Sys_OrganizeInfo organizeInfo = BLLFactory <Sys_Organize> .Instance.FindByID(user.F_OrganizeId);
Sys_OrganizeInfo DepInfo = BLLFactory <Sys_Organize> .Instance.FindByID(user.F_DepartmentId);
Sys_RoleInfo roleInfo = BLLFactory <Sys_Role> .Instance.FindByID(user.F_RoleId);
Sys_DutyInfo dutyInfo = BLLFactory <Sys_Duty> .Instance.FindByID(user.F_DutyId);
Mst_WarehouseInfo warehouseInfo = BLLFactory <Mst_Warehouse> .Instance.FindByID(user.F_WarehouseId);
user.F_OrganizeName = organizeInfo == null ? "" : organizeInfo.F_FullName;
user.F_DepartmentName = DepInfo == null ? "" : DepInfo.F_FullName;
user.F_RoleName = roleInfo == null ? "" : roleInfo.F_FullName;
user.F_DutyName = dutyInfo == null ? "" : dutyInfo.F_FullName;
user.F_WarehouseName = warehouseInfo == null ? "" : warehouseInfo.F_FullName;
}
return user;
}));
}
protected override ResultModel DoAfterUploadFile(string fullFileName)
{
ResultModel result = new ResultModel();
result.message = "";
//读取文件 excel
DataTable dt = KGMFramework.WebApp.Library.ExcelHelper.ExcelImport(fullFileName, 0);
if (dt == null || dt.Rows.Count == 0)
{
result.bSuccess = false;
result.message = "未读取到文件";
return(result);
}
List <Sys_UserInfo> userlist = BLLFactory <Sys_User> .Instance.GetAll();
for (int i = 0; i < dt.Rows.Count; i++)
{
Sys_UserInfo uinfo = new Sys_UserInfo();
string cname = dt.Rows[i]["公司主体"].ToString();
SearchCondition condition0 = new SearchCondition();
condition0.AddCondition("F_FullName", cname, SqlOperator.Equal);
condition0.AddCondition("F_CategoryId", "Company", SqlOperator.Equal);
Sys_OrganizeInfo coinfo = BLLFactory <Sys_Organize> .Instance.FindSingle(GetConditionStr(condition0));
if (coinfo == null)
{
result.message += "第" + (i + 1) + "行员工公司不存在,该条数据导入失败,";
continue;
}
uinfo.F_OrganizeId = coinfo.F_Id;
uinfo.F_Account = dt.Rows[i]["工号"].ToString();
uinfo.F_RealName = dt.Rows[i]["姓名"].ToString();
string oid = dt.Rows[i]["BU"].ToString();
SearchCondition condition = new SearchCondition();
condition.AddCondition("F_Id", oid, SqlOperator.Equal);
Sys_OrganizeInfo oinfo = BLLFactory <Sys_Organize> .Instance.FindSingle(GetConditionStr(condition));
if (oinfo == null)
{
result.message += "第" + (i + 1) + "行员工部门不存在,该条数据导入失败,";
continue;
}
uinfo.F_DepartmentId = oid;
uinfo.F_EnabledMark = true;
uinfo.F_UserPassword = "******";
uinfo.F_UserPassword = DESEncrypt.Encrypt(uinfo.F_UserPassword);
uinfo.F_RoleId = "fb5873ff-58ca-4d97-859d-945bedc52866";
SearchCondition condition1 = new SearchCondition();
condition1.AddCondition("F_Account", uinfo.F_Account, SqlOperator.Equal);
Sys_UserInfo oooinfo = BLLFactory <Sys_User> .Instance.FindSingle(GetConditionStr(condition1));
if (oooinfo == null)
{
BLLFactory <Sys_User> .Instance.Insert(uinfo);
}
else
{
BLLFactory <Sys_User> .Instance.Update(uinfo, oooinfo.F_Id);
}
}
result.bSuccess = true;
return(result);
}
