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);
}
