public IActionResult CpcCreate(dynamic model) { var response = ResponseModelFactory.CreateInstance; using (_dbContext) { var entity = new HaikanSmartTownCockpit.Api.Entities.Userinfoty(); string residence = model.residence; string town = model.town; if (!residence.Contains(town)) { response.SetFailed("住址不属于该村镇"); return(Ok(response)); } entity.UserInfoUuid = Guid.NewGuid(); entity.RealName = model.realName; entity.Sex = model.sex; entity.Birth = model.birth; entity.Education = model.education; entity.Category = model.category; entity.Partybranch = model.partybranch; entity.JoinDate = model.joinDate; entity.Phone = model.phone; entity.Residence = model.residence; entity.Work = model.work; entity.DyStaues = "1"; DateTime now = DateTime.Now; DateTime birth = model.birth; int age = now.Year - birth.Year; if (now.Month < birth.Month || (now.Month == birth.Month && now.Day < birth.Day)) { age--; } entity.Age = age < 0 ? 0 : age; entity.AddTime = DateTime.Now.ToString("yyyy-MM-dd"); entity.AddPeople = AuthContextService.CurrentUser.DisplayName; entity.IsDeleted = 0; _dbContext.Userinfoty.Add(entity); int res = _dbContext.SaveChanges(); if (res > 0) { ToLog.AddLog("添加", "成功:添加:党员信息一条数据", _dbContext); } response.SetSuccess("添加成功"); return(Ok(response)); } }
public IActionResult Import(IFormFile excelfile) { var response = ResponseModelFactory.CreateInstance; using (_dbContext) { DateTime beginTime = DateTime.Now; string sWebRootFolder = _hostingEnvironment.WebRootPath + "\\UploadFiles\\ImportBuidingExcel"; //var schoolinfo = _dbContext.SchoolInforManagement.AsQueryable(); string uploadtitle = "适龄青年信息导入" + DateTime.Now.ToString("yyyyMMddHHmmss"); string sFileName = $"{uploadtitle}.xlsx"; FileInfo file = new FileInfo(Path.Combine(sWebRootFolder, sFileName)); //string conStr = ConnectionStrings.DefaultConnection; string responsemsgsuccess = ""; string responsemsgrepeat = ""; string responsemsgdefault = ""; int successcount = 0; int repeatcount = 0; int defaultcount = 0; string today = DateTime.Now.ToString("yyyy-MM-dd"); try { //把excelfile中的数据复制到file中 using (FileStream fs = new FileStream(file.ToString(), FileMode.Create)) //初始化一个指定路径和创建模式的FileStream { excelfile.CopyTo(fs); fs.Flush(); //清空stream的缓存,并且把缓存中的数据输出到file } DataTable dt = Haikan3.Utils.ExcelTools.ExcelToDataTable(file.ToString(), "Sheet1", true); if (dt == null || dt.Rows.Count == 0) { response.SetFailed("表格无数据"); return(Ok(response)); } else { if (!dt.Columns.Contains("姓名")) { response.SetFailed("无‘姓名’列"); return(Ok(response)); } if (!dt.Columns.Contains("性别")) { response.SetFailed("无‘性别’列"); return(Ok(response)); } if (!dt.Columns.Contains("出生日期")) { response.SetFailed("无‘出生日期’列"); return(Ok(response)); } if (!dt.Columns.Contains("身份证号")) { response.SetFailed("无‘身份证号’列"); return(Ok(response)); } if (!dt.Columns.Contains("户籍地")) { response.SetFailed("无‘户籍地’列"); return(Ok(response)); } if (!dt.Columns.Contains("手机号")) { response.SetFailed("无‘手机号’列"); return(Ok(response)); } if (!dt.Columns.Contains("民族")) { response.SetFailed("无‘民族’列"); return(Ok(response)); } if (!dt.Columns.Contains("学历")) { response.SetFailed("无‘学历’列"); return(Ok(response)); } if (!dt.Columns.Contains("参军意愿")) { response.SetFailed("无‘参军意愿’列"); return(Ok(response)); } for (int i = 0; i < dt.Rows.Count; i++) { if (!string.IsNullOrEmpty(dt.Rows[i]["姓名"].ToString())) { var entity = new HaikanSmartTownCockpit.Api.Entities.Userinfoty(); entity.UserInfoUuid = Guid.NewGuid(); if (!string.IsNullOrEmpty(dt.Rows[i]["姓名"].ToString())) { Regex reg = new Regex("^([\\u4e00-\\u9fa5]){2,7}$"); if (reg.IsMatch(dt.Rows[i]["姓名"].ToString())) { entity.RealName = dt.Rows[i]["姓名"].ToString(); } else { responsemsgdefault += "<p style='color:red'>" + "第" + (i + 2) + "行姓名格式不正确" + "</p></br>"; defaultcount++; continue; } } else { responsemsgdefault += "<p style='color:red'>" + "第" + (i + 2) + "行姓名为空" + "</p></br>"; defaultcount++; continue; } if (!string.IsNullOrEmpty(dt.Rows[i]["性别"].ToString())) { if (dt.Rows[i]["性别"].ToString() != "男" && dt.Rows[i]["性别"].ToString() != "女") { responsemsgdefault += "<p style='color:red'>" + "第" + (i + 2) + "行性别不正确" + "</p></br>"; defaultcount++; continue; } else { entity.Sex = dt.Rows[i]["性别"].ToString(); } } if (!string.IsNullOrEmpty(dt.Rows[i]["出生日期"].ToString())) { Regex reg = new Regex("^((((1[6-9]|[2-9]\\d)\\d{2})-(0?[13578]|1[02])-(0?[1-9]|[12]\\d|3[01]))|(((1[6-9]|[2-9]\\d)\\d{2})-(0?[13456789]|1[012])-(0?[1-9]|[12]\\d|30))|(((1[6-9]|[2-9]\\d)\\d{2})-0?2-(0?[1-9]|1\\d|2[0-8]))|(((1[6-9]|[2-9]\\d)(0[48]|[2468][048]|[13579][26])|((16|[2468][048]|[3579][26])00))-0?2-29-))$"); if (reg.IsMatch(dt.Rows[i]["出生日期"].ToString())) { entity.Birth = dt.Rows[i]["出生日期"].ToString(); } else { responsemsgdefault += "<p style='color:red'>" + "第" + (i + 2) + "行出生日期不正确" + "</p></br>"; defaultcount++; continue; } } if (!string.IsNullOrEmpty(dt.Rows[i]["身份证号"].ToString())) { Regex reg = new Regex("^(^[1-9]\\d{7}((0\\d)|(1[0-2]))(([0|1|2]\\d)|3[0-1])\\d{3}$)|(^[1-9]\\d{5}[1-9]\\d{3}((0\\d)|(1[0-2]))(([0|1|2]\\d)|3[0-1])((\\d{4})|\\d{3}[Xx])$)$"); if (reg.IsMatch(dt.Rows[i]["身份证号"].ToString())) { entity.IdentityCard = dt.Rows[i]["身份证号"].ToString(); } else { responsemsgdefault += "<p style='color:red'>" + "第" + (i + 2) + "行身份证号格式不正确" + "</p></br>"; defaultcount++; continue; } } if (!string.IsNullOrEmpty(dt.Rows[i]["户籍地"].ToString())) { entity.Domicile = dt.Rows[i]["户籍地"].ToString(); } if (!string.IsNullOrEmpty(dt.Rows[i]["手机号"].ToString())) { Regex reg = new Regex("^[1][3,4,5,7,8][0-9]{9}$"); if (reg.IsMatch(dt.Rows[i]["手机号"].ToString())) { entity.Phone = dt.Rows[i]["手机号"].ToString(); } else { responsemsgdefault += "<p style='color:red'>" + "第" + (i + 2) + "行手机号格式不正确" + "</p></br>"; defaultcount++; continue; } } if (!string.IsNullOrEmpty(dt.Rows[i]["民族"].ToString())) { Regex reg = new Regex("^(汉族|蒙古族|回族|藏族|维吾尔族|苗族|彝族|壮族|布依族|朝鲜族|满族|侗族|瑶族|白族|土家族|哈尼族|哈萨克族|傣族|黎族|僳僳族|佤族|畲族|高山族|拉祜族|水族|东乡族|纳西族|景颇族|柯尔克孜族|土族|达斡尔族|仫佬族|羌族|布朗族|撒拉族|毛南族|仡佬族|锡伯族|阿昌族|普米族|塔吉克族|怒族|乌孜别克族|俄罗斯族|鄂温克族|德昂族|保安族|京族|独龙族|鄂伦春族|赫哲族|裕固族|门巴族|珞巴族|基诺族)$"); if (reg.IsMatch(dt.Rows[i]["民族"].ToString())) { entity.Nation = dt.Rows[i]["民族"].ToString(); } else { responsemsgdefault += "<p style='color:red'>" + "第" + (i + 2) + "行民族不正确" + "</p></br>"; defaultcount++; continue; } } if (!string.IsNullOrEmpty(dt.Rows[i]["学历"].ToString())) { Regex reg = new Regex("^(小学|初中|中专|大专|本科|硕士|博士)$"); if (reg.IsMatch(dt.Rows[i]["学历"].ToString())) { entity.Education = dt.Rows[i]["学历"].ToString(); } else { responsemsgdefault += "<p style='color:red'>" + "第" + (i + 2) + "行学历类别不正确" + "</p></br>"; defaultcount++; continue; } } if (!string.IsNullOrEmpty(dt.Rows[i]["参军意愿"].ToString())) { entity.JoinArmy = dt.Rows[i]["参军意愿"].ToString(); } entity.Defense = "适龄青年"; entity.AddTime = DateTime.Now.ToString("yyyy-MM-dd"); entity.AddPeople = AuthContextService.CurrentUser.DisplayName; entity.IsDeleted = 0; _dbContext.Userinfoty.Add(entity); _dbContext.SaveChanges(); successcount++; } } } responsemsgsuccess = "<p style='color:green'>导入成功:" + successcount + "条</p></br>" + responsemsgsuccess; responsemsgrepeat = "<p style='color:orange'>重复需手动修改数据:" + repeatcount + "条</p></br>" + responsemsgrepeat; responsemsgdefault = "<p style='color:red'>导入失败:" + defaultcount + "条</p></br>" + responsemsgdefault; ToLog.AddLog("导入", "成功:导入:统一人员信息数据", _dbContext); DateTime endTime = DateTime.Now; TimeSpan useTime = endTime - beginTime; string taketime = "导入时间" + useTime.TotalSeconds.ToString() + "秒 "; response.SetData(JsonConvert.DeserializeObject(JsonConvert.SerializeObject(new { time = taketime, successmsg = responsemsgsuccess , repeatmsg = responsemsgrepeat, defaultmsg = responsemsgdefault }))); return(Ok(response)); } catch (Exception ex) { response.SetFailed(ex.Message); return(Ok(response)); } } }
public IActionResult Import(IFormFile excelfile) { var response = ResponseModelFactory.CreateInstance; using (_dbContext) { DateTime beginTime = DateTime.Now; string sWebRootFolder = _hostingEnvironment.WebRootPath + "\\UploadFiles\\ImportBuidingExcel"; string uploadtitle = "党员考评信息导入" + DateTime.Now.ToString("yyyyMMddHHmmss"); string sFileName = $"{uploadtitle}.xlsx"; FileInfo file = new FileInfo(Path.Combine(sWebRootFolder, sFileName)); //string conStr = ConnectionStrings.DefaultConnection; string responsemsgsuccess = ""; string responsemsgrepeat = ""; string responsemsgdefault = ""; int successcount = 0; int repeatcount = 0; int defaultcount = 0; string today = DateTime.Now.ToString("yyyy-MM-dd"); try { //把excelfile中的数据复制到file中 using (FileStream fs = new FileStream(file.ToString(), FileMode.Create)) //初始化一个指定路径和创建模式的FileStream { excelfile.CopyTo(fs); fs.Flush(); //清空stream的缓存,并且把缓存中的数据输出到file } DataTable dt = Haikan3.Utils.ExcelTools.ExcelToDataTable(file.ToString(), "Sheet1", true); if (dt == null || dt.Rows.Count == 0) { response.SetFailed("表格无数据"); return(Ok(response)); } else { if (!dt.Columns.Contains("姓名")) { response.SetFailed("无‘姓名’列"); return(Ok(response)); } if (!dt.Columns.Contains("性别")) { response.SetFailed("无‘性别’列"); return(Ok(response)); } if (!dt.Columns.Contains("出生日期")) { response.SetFailed("无‘出生日期’列"); return(Ok(response)); } if (!dt.Columns.Contains("学历")) { response.SetFailed("无‘学历’列"); return(Ok(response)); } if (!dt.Columns.Contains("人员类别")) { response.SetFailed("无‘人员类别’列"); return(Ok(response)); } if (!dt.Columns.Contains("所在党支部")) { response.SetFailed("无‘所在党支部’列"); return(Ok(response)); } if (!dt.Columns.Contains("加入党组织时间")) { response.SetFailed("无‘加入党组织时间’列"); return(Ok(response)); } if (!dt.Columns.Contains("联系方式")) { response.SetFailed("无‘联系方式’列"); return(Ok(response)); } if (!dt.Columns.Contains("家庭住址")) { response.SetFailed("无‘家庭住址’列"); return(Ok(response)); } if (!dt.Columns.Contains("工作单位")) { response.SetFailed("无‘工作单位’列"); return(Ok(response)); } for (int i = 0; i < dt.Rows.Count; i++) { var entity = new HaikanSmartTownCockpit.Api.Entities.Userinfoty(); entity.UserInfoUuid = Guid.NewGuid(); if (!string.IsNullOrEmpty(dt.Rows[i]["姓名"].ToString())) { Regex reg = new Regex("^([\\u4e00-\\u9fa5]){2,7}$"); if (reg.IsMatch(dt.Rows[i]["姓名"].ToString())) { entity.RealName = dt.Rows[i]["姓名"].ToString(); } else { responsemsgdefault += "<p style='color:red'>" + "第" + (i + 2) + "行姓名格式不正确" + "</p></br>"; defaultcount++; continue; } } else { responsemsgdefault += "<p style='color:red'>" + "第" + (i + 2) + "行姓名为空" + "</p></br>"; defaultcount++; continue; } if (!string.IsNullOrEmpty(dt.Rows[i]["性别"].ToString())) { if (dt.Rows[i]["性别"].ToString() != "男" && dt.Rows[i]["性别"].ToString() != "女") { responsemsgdefault += "<p style='color:red'>" + "第" + (i + 2) + "行性别不正确" + "</p></br>"; defaultcount++; continue; } else { entity.Sex = dt.Rows[i]["性别"].ToString(); } } if (!string.IsNullOrEmpty(dt.Rows[i]["出生日期"].ToString())) { Regex reg = new Regex("^((((1[6-9]|[2-9]\\d)\\d{2})-(0?[13578]|1[02])-(0?[1-9]|[12]\\d|3[01]))|(((1[6-9]|[2-9]\\d)\\d{2})-(0?[13456789]|1[012])-(0?[1-9]|[12]\\d|30))|(((1[6-9]|[2-9]\\d)\\d{2})-0?2-(0?[1-9]|1\\d|2[0-8]))|(((1[6-9]|[2-9]\\d)(0[48]|[2468][048]|[13579][26])|((16|[2468][048]|[3579][26])00))-0?2-29-))$"); if (reg.IsMatch(dt.Rows[i]["出生日期"].ToString())) { entity.Birth = dt.Rows[i]["出生日期"].ToString(); } else { responsemsgdefault += "<p style='color:red'>" + "第" + (i + 2) + "行出生日期不正确" + "</p></br>"; defaultcount++; continue; } } else { responsemsgdefault += "<p style='color:red'>" + "第" + (i + 2) + "行出生日期为空" + "</p></br>"; defaultcount++; continue; } if (!string.IsNullOrEmpty(dt.Rows[i]["学历"].ToString())) { Regex reg = new Regex("^(小学|初中|高中|中专|大专|本科|硕士|博士)$"); if (reg.IsMatch(dt.Rows[i]["学历"].ToString())) { entity.Education = dt.Rows[i]["学历"].ToString(); } else { responsemsgdefault += "<p style='color:red'>" + "第" + (i + 2) + "行学历类别不正确" + "</p></br>"; defaultcount++; continue; } } if (!string.IsNullOrEmpty(dt.Rows[i]["人员类别"].ToString().Trim())) { Regex reg = new Regex("^(正式党员|预备党员|发展对象|积极分子)$"); if (reg.IsMatch(dt.Rows[i]["人员类别"].ToString().Trim())) { entity.Category = dt.Rows[i]["人员类别"].ToString().Trim(); } else { responsemsgdefault += "<p style='color:red'>" + "第" + (i + 2) + "行人员类别不正确" + "</p></br>"; defaultcount++; continue; } } if (!string.IsNullOrEmpty(dt.Rows[i]["所在党支部"].ToString())) { Regex reg = new Regex("^(机关党组织|村级党支部|企业党支部)$"); if (reg.IsMatch(dt.Rows[i]["所在党支部"].ToString())) { entity.Partybranch = dt.Rows[i]["所在党支部"].ToString(); } else { responsemsgdefault += "<p style='color:red'>" + "第" + (i + 2) + "行所在党支部类别不正确" + "</p></br>"; defaultcount++; continue; } } if (!string.IsNullOrEmpty(dt.Rows[i]["加入党组织时间"].ToString())) { Regex reg = new Regex("^((((1[6-9]|[2-9]\\d)\\d{2})-(0?[13578]|1[02])-(0?[1-9]|[12]\\d|3[01]))|(((1[6-9]|[2-9]\\d)\\d{2})-(0?[13456789]|1[012])-(0?[1-9]|[12]\\d|30))|(((1[6-9]|[2-9]\\d)\\d{2})-0?2-(0?[1-9]|1\\d|2[0-8]))|(((1[6-9]|[2-9]\\d)(0[48]|[2468][048]|[13579][26])|((16|[2468][048]|[3579][26])00))-0?2-29-))$"); if (reg.IsMatch(dt.Rows[i]["迁移时间"].ToString())) { entity.JoinDate = dt.Rows[i]["加入党组织时间"].ToString(); } else { responsemsgdefault += "<p style='color:red'>" + "第" + (i + 2) + "行加入党组织时间不正确" + "</p></br>"; defaultcount++; continue; } } if (!string.IsNullOrEmpty(dt.Rows[i]["联系方式"].ToString())) { Regex reg = new Regex("^[1][3,4,5,7,8][0-9]{9}$"); if (reg.IsMatch(dt.Rows[i]["联系方式"].ToString())) { entity.Phone = dt.Rows[i]["联系方式"].ToString(); } else { responsemsgdefault += "<p style='color:red'>" + "第" + (i + 2) + "行联系方式格式不正确" + "</p></br>"; defaultcount++; continue; } } if (!string.IsNullOrEmpty(dt.Rows[i]["家庭住址"].ToString().Trim())) { entity.Residence = dt.Rows[i]["家庭住址"].ToString().Trim(); } else { responsemsgdefault += "<p style='color:red'>" + "第" + (i + 2) + "行家庭住址为空" + "</p></br>"; defaultcount++; continue; } if (!string.IsNullOrEmpty(dt.Rows[i]["工作单位"].ToString())) { entity.Occupation = dt.Rows[i]["工作单位"].ToString(); } if (!string.IsNullOrEmpty(dt.Rows[i]["考评级别"].ToString())) { entity.Evaluate = dt.Rows[i]["考评级别"].ToString(); } entity.DyStaues = "1"; entity.AddTime = DateTime.Now.ToString("yyyy-MM-dd"); entity.AddPeople = AuthContextService.CurrentUser.DisplayName; entity.IsDeleted = 0; _dbContext.Userinfoty.Add(entity); _dbContext.SaveChanges(); successcount++; } } responsemsgsuccess = "<p style='color:green'>导入成功:" + successcount + "条</p></br>" + responsemsgsuccess; responsemsgrepeat = "<p style='color:orange'>重复需手动修改数据:" + repeatcount + "条</p></br>" + responsemsgrepeat; responsemsgdefault = "<p style='color:red'>导入失败:" + defaultcount + "条</p></br>" + responsemsgdefault; ToLog.AddLog("导入", "成功:导入:统一人员信息数据", _dbContext); DateTime endTime = DateTime.Now; TimeSpan useTime = endTime - beginTime; string taketime = "导入时间" + useTime.TotalSeconds.ToString() + "秒"; response.SetData(JsonConvert.DeserializeObject(JsonConvert.SerializeObject(new { time = taketime, successmsg = responsemsgsuccess, repeatmsg = responsemsgrepeat, defaultmsg = responsemsgdefault }))); return(Ok(response)); } catch (Exception ex) { response.SetFailed(ex.Message); return(Ok(response)); } } }
public IActionResult UserInfoImport(IFormFile excelfile) { var response = ResponseModelFactory.CreateInstance; using (_dbContext) { DateTime beginTime = DateTime.Now; string sWebRootFolder = _hostingEnvironment.WebRootPath + "\\UploadFiles\\ImportUserInfoExcel"; //var schoolinfo = _dbContext.SchoolInforManagement.AsQueryable(); string uploadtitle = " 人员信息导入" + DateTime.Now.ToString("yyyyMMddHHmmss"); string sFileName = $"{uploadtitle}.xlsx"; FileInfo file = new FileInfo(Path.Combine(sWebRootFolder, sFileName)); //string conStr = ConnectionStrings.DefaultConnection; string responsemsgsuccess = ""; string responsemsgrepeat = ""; string responsemsgdefault = ""; int successcount = 0; int repeatcount = 0; int defaultcount = 0; string today = DateTime.Now.ToString("yyyy-MM-dd"); try { //把excelfile中的数据复制到file中 using (FileStream fs = new FileStream(file.ToString(), FileMode.Create)) //初始化一个指定路径和创建模式的FileStream { excelfile.CopyTo(fs); fs.Flush(); //清空stream的缓存,并且把缓存中的数据输出到file } DataTable dt = Haikan3.Utils.ExcelTools.ExcelToDataTable(file.ToString(), "Sheet1", true); if (dt == null || dt.Rows.Count == 0) { response.SetFailed("表格无数据"); return(Ok(response)); } else { if (!dt.Columns.Contains("姓名")) { response.SetFailed("无‘姓名’列"); return(Ok(response)); } for (int i = 0; i < dt.Rows.Count; i++) { var entity = new HaikanSmartTownCockpit.Api.Entities.Userinfoty(); entity.UserInfoUuid = Guid.NewGuid(); //Regex regxm = new Regex("^([\\u4e00-\\u9fa5]){2,7}$"); //if (regxm.IsMatch(dt.Rows[i]["姓名"].ToString())) //{ if (string.IsNullOrEmpty(dt.Rows[i]["姓名"].ToString().Trim())) { continue; } else { entity.RealName = dt.Rows[i]["姓名"].ToString(); } //} //else //{ // responsemsgdefault += "<p style='color:red'>" + "第" + (i + 2) + "行姓名格式不正确" + "</p></br>"; // defaultcount++; // continue; //} //Regex regxb = new Regex("^(男|女)$"); //if (regxb.IsMatch(dt.Rows[i]["性别"].ToString())) //{ //entity.Sex = dt.Rows[i]["性别"].ToString(); //} //else //{ // responsemsgdefault += "<p style='color:red'>" + "第" + (i + 2) + "行性别不正确" + "</p></br>"; // defaultcount++; // continue; //} //Regex regbr = new Regex("^((((1[6-9]|[2-9]\\d)\\d{2})-(0?[13578]|1[02])-(0?[1-9]|[12]\\d|3[01]))|(((1[6-9]|[2-9]\\d)\\d{2})-(0?[13456789]|1[012])-(0?[1-9]|[12]\\d|30))|(((1[6-9]|[2-9]\\d)\\d{2})-0?2-(0?[1-9]|1\\d|2[0-8]))|(((1[6-9]|[2-9]\\d)(0[48]|[2468][048]|[13579][26])|((16|[2468][048]|[3579][26])00))-0?2-29-))$"); //if (regbr.IsMatch(dt.Rows[i]["出生日期"].ToString())) //{ //entity.Birth = dt.Rows[i]["出生日期"].ToString(); //DateTime now = DateTime.Now; //DateTime birth = Convert.ToDateTime(entity.Birth); //int age = now.Year - birth.Year; //if (now.Month < birth.Month || (now.Month == birth.Month && now.Day < birth.Day)) //{ // age--; //} //entity.Age = age < 0 ? 0 : age; //} //else //{ // responsemsgdefault += "<p style='color:red'>" + "第" + (i + 2) + "行出生日期不正确,例:1999-09-09" + "</p></br>"; // defaultcount++; // continue; //} Regex regsfz = new Regex("^(^[1-9]\\d{7}((0\\d)|(1[0-2]))(([0|1|2]\\d)|3[0-1])\\d{3}$)|(^[1-9]\\d{5}[1-9]\\d{3}((0\\d)|(1[0-2]))(([0|1|2]\\d)|3[0-1])((\\d{4})|\\d{3}[Xx])$)$"); if (regsfz.IsMatch(dt.Rows[i]["身份证号"].ToString())) { if (!string.IsNullOrEmpty(dt.Rows[i]["身份证号"].ToString())) { string ddd = dt.Rows[i]["身份证号"].ToString(); entity.IdentityCard = dt.Rows[i]["身份证号"].ToString(); if (ddd != "" && ddd != null) { string sex = ""; //判断身份证是否18位 if (ddd.Length == 18) { entity.Birth = ddd.Substring(6, 4) + "-" + ddd.Substring(10, 2) + "-" + ddd.Substring(12, 2); sex = ddd.Substring(14, 3); if (sex != "" && sex != null) { if (int.Parse(sex) % 2 == 0) { entity.Sex = "女"; } else { entity.Sex = "男"; } } var d1 = ddd.Substring(6, 4) + "-" + ddd.Substring(10, 2) + "-" + ddd.Substring(12, 2); sex = ddd.Substring(14, 3); entity.Birth = DateTime.Parse(d1).ToString("yyyy-MM-dd"); DateTime now = DateTime.Now; DateTime birth = Convert.ToDateTime(d1); int age = now.Year - birth.Year; if (now.Month < birth.Month || (now.Month == birth.Month && now.Day < birth.Day)) { age--; } entity.Age = age < 0 ? 0 : age; } //判断身份证是否15位 if (ddd.Length == 15) { entity.Birth = "19" + ddd.Substring(6, 2) + "-" + ddd.Substring(8, 2) + "-" + ddd.Substring(10, 2); sex = ddd.Substring(12, 3); if (sex != "" && sex != null) { if (int.Parse(sex) % 2 == 0) { entity.Sex = "女"; } else { entity.Sex = "男"; } } var d1 = "19" + ddd.Substring(6, 2) + "-" + ddd.Substring(8, 2) + "-" + ddd.Substring(10, 2); sex = ddd.Substring(12, 3); entity.Birth = DateTime.Parse(d1).ToString("yyyy-MM-dd"); DateTime now = DateTime.Now; DateTime birth = Convert.ToDateTime(d1); int age = now.Year - birth.Year; if (now.Month < birth.Month || (now.Month == birth.Month && now.Day < birth.Day)) { age--; } entity.Age = age < 0 ? 0 : age; } } } } else { responsemsgdefault += "<p style='color:red'>" + "第" + (i + 2) + "行身份证号格式不正确" + "</p></br>"; defaultcount++; continue; } if (dt.Rows[i]["户籍地"] != null) { entity.Residence = dt.Rows[i]["户籍地"].ToString(); } if (!string.IsNullOrEmpty(dt.Rows[i]["地址"].ToString())) { entity.Domicile = dt.Rows[i]["地址"].ToString(); } //Regex reg = new Regex("^(汉族|蒙古族|回族|藏族|维吾尔族|苗族|彝族|壮族|布依族|朝鲜族|满族|侗族|瑶族|白族|土家族|哈尼族|哈萨克族|傣族|黎族|僳僳族|佤族|畲族|高山族|拉祜族|水族|东乡族|纳西族|景颇族|柯尔克孜族|土族|达斡尔族|仫佬族|羌族|布朗族|撒拉族|毛南族|仡佬族|锡伯族|阿昌族|普米族|塔吉克族|怒族|乌孜别克族|俄罗斯族|鄂温克族|德昂族|保安族|京族|独龙族|鄂伦春族|赫哲族|裕固族|门巴族|珞巴族|基诺族)$"); //if (reg.IsMatch(dt.Rows[i]["民族"].ToString())) //{ //entity.Nation = dt.Rows[i]["民族"].ToString(); //} //else //{ // responsemsgdefault += "<p style='color:red'>" + "第" + (i + 2) + "行民族不正确" + "</p></br>"; // defaultcount++; // continue; //} //Regex reg1 = new Regex("^(小学|初中|中专|大专|本科|硕士|博士)$"); //if (reg1.IsMatch(dt.Rows[i]["学历"].ToString())) //{ //entity.Education = dt.Rows[i]["学历"].ToString(); //} //else //{ // responsemsgdefault += "<p style='color:red'>" + "第" + (i + 2) + "行学历类别不正确" + "</p></br>"; // defaultcount++; // continue; //} if (!string.IsNullOrEmpty(dt.Rows[i]["户别"]?.ToString())) { entity.Household = dt.Rows[i]["户别"].ToString(); } if (!string.IsNullOrEmpty(dt.Rows[i]["电话号码"]?.ToString())) { entity.Phone = dt.Rows[i]["电话号码"].ToString(); } if (!string.IsNullOrEmpty(dt.Rows[i]["与户主的关系"]?.ToString())) { entity.Relation = dt.Rows[i]["与户主的关系"].ToString(); } if (!string.IsNullOrEmpty(dt.Rows[i]["户主姓名"]?.ToString())) { entity.HouseholderName = dt.Rows[i]["户主姓名"].ToString(); } if (!string.IsNullOrEmpty(dt.Rows[i]["迁入时间"].ToString())) { entity.QianYiStime = dt.Rows[i]["迁入时间"].ToString(); } if (!string.IsNullOrEmpty(dt.Rows[i]["迁出时间"].ToString())) { entity.QianYiEtime = dt.Rows[i]["迁出时间"].ToString(); } //if (!string.IsNullOrEmpty(dt.Rows[i]["职业"].ToString())) //{ // entity.Occupation = dt.Rows[i]["职业"].ToString(); //} if (!string.IsNullOrEmpty(dt.Rows[i]["政治面貌"].ToString())) { entity.Politics = dt.Rows[i]["政治面貌"].ToString(); if (dt.Rows[i]["政治面貌"].ToString().Contains("党")) { entity.DyStaues = "1"; } } //else //{ // responsemsgdefault += "<p style='color:red'>" + "第" + (i + 2) + "行价格为空" + "</p></br>"; // defaultcount++; // continue; //} entity.AddTime = DateTime.Now.ToString("yyyy-MM-dd"); entity.AddPeople = AuthContextService.CurrentUser.DisplayName; //entity.AddTime = DateTime.Now.ToString("yyyy-MM-dd"); //entity.AddPeople = AuthContextService.CurrentUser.DisplayName; entity.IsDeleted = 0; _dbContext.Userinfoty.Add(entity); _dbContext.SaveChanges(); successcount++; } } responsemsgsuccess = "<p style='color:green'>导入成功:" + successcount + "条</p></br>" + responsemsgsuccess; responsemsgrepeat = "<p style='color:orange'>重复需手动修改数据:" + repeatcount + "条</p></br>" + responsemsgrepeat; responsemsgdefault = "<p style='color:red'>导入失败:" + defaultcount + "条</p></br>" + responsemsgdefault; ToLog.AddLog("导入", "成功:导入:统一人员信息数据", _dbContext); DateTime endTime = DateTime.Now; TimeSpan useTime = endTime - beginTime; string taketime = "导入时间" + useTime.TotalSeconds.ToString() + "秒 "; response.SetData(JsonConvert.DeserializeObject(JsonConvert.SerializeObject(new { time = taketime, successmsg = responsemsgsuccess , repeatmsg = responsemsgrepeat, defaultmsg = responsemsgdefault }))); return(Ok(response)); } catch (Exception ex) { response.SetFailed(ex.Message); return(Ok(response)); } } }
public IActionResult UserInfoCreate(UsreInfoViewModel model) { var response = ResponseModelFactory.CreateInstance; using (_dbContext) { var entity = new HaikanSmartTownCockpit.Api.Entities.Userinfoty(); entity.UserInfoUuid = Guid.NewGuid(); entity.RealName = model.RealName; entity.Sex = model.Sex; entity.Education = model.Education; entity.Politics = model.Politics; entity.Nation = model.Nation; entity.IdentityCard = model.IdentityCard; entity.Occupation = model.Occupation; entity.Residence = model.Residence; entity.Domicile = model.Domicile; entity.Household = model.Household; entity.Relation = model.Relation; entity.HouseholderName = model.HouseholderName; entity.Phone = model.Phone; if (model.Birth != null && model.Birth != "") { entity.Birth = DateTime.Parse(model.Birth).ToString("yyyy-MM-dd"); DateTime now = DateTime.Now; DateTime birth = Convert.ToDateTime(model.Birth); int age = now.Year - birth.Year; if (now.Month < birth.Month || (now.Month == birth.Month && now.Day < birth.Day)) { age--; } entity.Age = age < 0 ? 0 : age; } else { entity.Birth = ""; } if (model.QianYiEtime != null && model.QianYiEtime != "") { entity.QianYiEtime = DateTime.Parse(model.QianYiEtime).ToString("yyyy-MM-dd"); } else { entity.QianYiEtime = ""; } if (model.QianYiStime != null && model.QianYiStime != "") { entity.QianYiStime = DateTime.Parse(model.QianYiStime).ToString("yyyy-MM-dd"); } else { entity.QianYiStime = ""; } entity.AddTime = DateTime.Now.ToString("yyyy-MM-dd"); entity.AddPeople = AuthContextService.CurrentUser.DisplayName; //entity.AddTime = DateTime.Now.ToString("yyyy-MM-dd"); //entity.AddPeople = model.addPeople; entity.IsDeleted = 0; _dbContext.Userinfoty.Add(entity); int res = _dbContext.SaveChanges(); if (res > 0) { ToLog.AddLog("添加", "成功:添加:统一人员信息一条数据", _dbContext); } response.SetSuccess("添加成功"); return(Ok(response)); } }