private static UserRole getUserRole(this HttpRequest request, IDatabase database) { var id = request.GetInt("id"); var userRole = database.UserRoles.SingleOrDefault(d => d.RoleID == 3 && d.CollegeID == id); if (userRole != null) return userRole; var newuserRole = new UserRole(); return newuserRole; }
/// <summary> /// 导入专家 /// </summary> /// <param name="httpContext"></param> /// <param name="postedFile"></param> /// <param name="request"></param> /// <param name="user"></param> /// <returns></returns> public static string ImportExpert(this HttpContext httpContext, HttpPostedFile postedFile, HttpRequest request, User user) { IDatabase database = Database.New(); string logName = "ExpertImportLog" + DateTime.Now.ToLongDateString().ToString() + Guid.NewGuid().ToString(); var writer = httpContext.GetLogWriter(logName); string fileName = "Expert"; DataSet ds = postedFile.GetDataFromUploadFile(httpContext, fileName); StringBuilder ExpertImportLog = new StringBuilder(); StringBuilder ExpertImportId = new StringBuilder(); StringBuilder ExpertUpdateLog = new StringBuilder(); StringBuilder ExpertDepartmentNotMatchLog = new StringBuilder(); StringBuilder ExpertNumberAndNameNotMatchLog = new StringBuilder(); int importExpertCount = 0;//导入专家个数 int updateExpertCount = 0;//更新专家个数 foreach (DataRow row in ds.Tables[fileName].Rows) { database = Database.New(); string expertNumber = row[0].ToString().Trim(); string expertName = row[1].ToString().Trim(); string expertNameSpell = row[2].ToString().Trim(); string expertSex = row[3].ToString().Trim(); string expertIDCardNumber = row[4].ToString().Trim(); string expertCollege = row[5].ToString().Trim(); string expertPost = row[6].ToString().Trim(); string IsDoctorDirector = row[7].ToString().Trim(); string IsAcademician = row[8].ToString().Trim(); string expertMobilePhone = row[9].ToString().Trim(); try { //保存专家信息 Expert expert = database.Experts.FirstOrDefault(q => q.ExpertNumber == expertNumber); if (expert == null) expert = new Expert(); bool expertIsNew = expert.IsNew; if (!expert.IsNew) { if (expert.Name != expertName) { ExpertNumberAndNameNotMatchLog.AppendFormat("专家姓名和工作证号不一致,工作证号为:{0},原专家姓名为:{1},现在专家姓名为:{2}\n", expert.ExpertNumber, expert.Name, expertName); //continue; } } expert.ExpertNumber = expertNumber; expert.Name = expertName; expert.NameSpell = expertNameSpell; expert.Sex = expert.IsNew ? expertSex.GetSexType() : string.IsNullOrEmpty(expertSex) ? expert.Sex : expertSex.GetSexType(); expert.IDCardNumber = expertIDCardNumber.ConfirmValue(expert.IDCardNumber, expert.IsNew); expert.College = expertCollege.ConfirmValue(expert.College == null ? string.Empty : expert.College.Name, expert.IsNew).GetCollege(database); expert.Post = expertPost; expert.IsAcademician = IsAcademician.GetIsTrueOrFalse(); expert.IsDoctorDirector = IsDoctorDirector.GetIsTrueOrFalse(); expert.MobilePhone = expertMobilePhone == null ? expert.MobilePhone : expertMobilePhone; //保存专家 expert.Save(database); if (!string.IsNullOrEmpty(expert.ExpertNumber) && expertIsNew) { var importUser = database.Users.FirstOrDefault(u => u.LoginID == expert.ExpertNumber); if (importUser == null) { var newUser = new User(); newUser.Name = expert.Name; newUser.NameSpell = expert.NameSpell == null ? expert.Name : expert.NameSpell; newUser.LoginID = expert.ExpertNumber; newUser.Password = "******"; newUser.CreateTime=DateTime.Now; newUser.ModifyTime = DateTime.Now; //保存用户 newUser.Save(database); expert.User = newUser; expert.Save(database); var userRole = database.UserRoles.FirstOrDefault(ur => ur.User == newUser); if (userRole == null) userRole = new UserRole(); userRole.User = newUser; var role = database.Roles.FirstOrDefault(r => r.TypeCode == "Expert"); userRole.Role = role; userRole.College = expert.College; userRole.CreateTime = DateTime.Now; userRole.ModifyTime = DateTime.Now; //保存用户角色 userRole.Save(database); } } if (expertIsNew) { importExpertCount++; ExpertImportId.AppendFormat("Id为:{0},职工号为:{1}\n;", expert.ID, expert.ExpertNumber); } else { updateExpertCount++; ExpertUpdateLog.AppendFormat("更新专家职工号为:{0}。\n", expert.ExpertNumber); } } catch (Exception e) { writer.WriteLine(string.Format("导入专家发生错误,专家职工号为{0},错误信息为:{1}", expertNumber, e.Message)); } } ExpertImportLog.AppendFormat("成功更新和导入专家{0}位:其中更新专家{1}位;添加专家{2}位。\n", importExpertCount + updateExpertCount, updateExpertCount, importExpertCount); ExpertImportLog.AppendFormat("添加专家ID为:\n{0}\n", ExpertImportId.ToString()); ExpertImportLog.AppendFormat("更新专家详细信息为:\n{0}", ExpertUpdateLog.ToString()); ExpertImportLog.AppendFormat("以下专家对应所属部门不匹配,请检查写法是否规范。\n{0}", ExpertDepartmentNotMatchLog.ToString()); ExpertImportLog.AppendFormat("以下专家工作证号和姓名不匹配的信息\n{0}", ExpertNumberAndNameNotMatchLog.ToString()); //注释 写入导入日志 //Log.Write(user.Name, (int)(LogType.ExpertImport), ExpertImportLog.ToString(), request.UserHostAddress, "专家导入", database); writer.WriteLine("成功更新和导入专家{0}位:其中更新专家{1}位;添加专家{2}位。\n", importExpertCount + updateExpertCount, updateExpertCount, importExpertCount); writer.WriteLine(); writer.WriteLine(); writer.WriteLine("添加专家ID为:\n{0}\n", ExpertImportId.ToString()); writer.WriteLine(); writer.WriteLine(); writer.WriteLine("更新专家详细信息为:\n{0}", ExpertUpdateLog.ToString()); writer.WriteLine("以下专家对应所属部门不匹配,请检查写法是否规范。\n{0}", ExpertDepartmentNotMatchLog.ToString()); writer.WriteLine("以下专家工作证号和姓名不匹配的信息。\n{0}", ExpertNumberAndNameNotMatchLog.ToString()); httpContext.DeleteFile(postedFile.FileName); writer.Close(); return logName; }
public void saveUserRole(User user,Role role,bool isCollege) { var userRole = new UserRole(); userRole.User = user; userRole.Role = role; var expert=Database.Experts.FirstOrDefault(e=>e.User==user); if (expert != null) { if (isCollege) { userRole.College = expert.College; } else { userRole.College = expert.College2; } } userRole.Save(Database); }