public FileResult ExportExcel(string keywords = "") { HSSFWorkbook book = new HSSFWorkbook(); ISheet sheet1 = book.CreateSheet("Sheet1"); MembersService ShipServ = new MembersService(); var DataLists = ShipServ.Reposity.GetAllList(); IRow rowhead = sheet1.CreateRow(0); string[] colums = ("编号|姓名|关系|性别|民族|出生年月|年龄|楼盘|单元|门牌号|身份证号|现户籍地址|原户籍地址|是否兴塘社区户籍|服务处所|职务|联系电话1|联系电话2|政治面貌|党员所在支部|是否楼道组长|是否户代表|是否居民代表|是否居民组长|是否愿意参加公益|是否愿意从事居民事务|调查时间|特长备注").Split('|'); for (int i = 0; i < colums.Length; i++) { rowhead.CreateCell(i).SetCellValue(colums[i]); } int RowNum = 0; foreach (var item in DataLists) { IRow row = sheet1.CreateRow(RowNum + 1); row.CreateCell(0).SetCellValue(RowNum + 1); row.CreateCell(1).SetCellValue(item.TrueName); row.CreateCell(2).SetCellValue(item.Relations); row.CreateCell(3).SetCellValue(item.Sex); row.CreateCell(4).SetCellValue(item.Nation); row.CreateCell(5).SetCellValue(item.Birthday); row.CreateCell(6).SetCellValue(item.Age); row.CreateCell(7).SetCellValue(item.Apartment); row.CreateCell(8).SetCellValue(item.UnitNum); row.CreateCell(9).SetCellValue(item.DoorCard); row.CreateCell(10).SetCellValue(item.UserID); row.CreateCell(11).SetCellValue(item.Address); row.CreateCell(12).SetCellValue(item.Address2); row.CreateCell(13).SetCellValue(item.HhdRegister); row.CreateCell(14).SetCellValue(item.ServiceAddr); row.CreateCell(15).SetCellValue(item.Duties); row.CreateCell(16).SetCellValue(item.Phone); row.CreateCell(17).SetCellValue(item.Phone2); row.CreateCell(18).SetCellValue(item.PoliticalRole); row.CreateCell(19).SetCellValue(item.PartyBranch); row.CreateCell(20).SetCellValue(item.CorridorLeader); row.CreateCell(21).SetCellValue(item.HouseLeader); row.CreateCell(22).SetCellValue(item.ResidentRepresentative); row.CreateCell(23).SetCellValue(item.ResidentLeader); row.CreateCell(24).SetCellValue(item.Pipwa); row.CreateCell(25).SetCellValue(item.Eira); row.CreateCell(26).SetCellValue(item.CreationTime.ToString()); row.CreateCell(27).SetCellValue(item.Speciality); RowNum++; } MemoryStream ms = new MemoryStream(); book.Write(ms); ms.Seek(0, SeekOrigin.Begin); ShipServ.Dispose(); return(File(ms, "application/vnd.ms-excel", "Members" + DateTime.Now.ToString("yyyyMMddhhmmss") + ".xls")); }
public JsonResult GetMemberList() { MembersService ObjServ = new MembersService(); var result = ObjServ.Reposity.GetPageList(1, 8, o => o.TenantId == tenant.Id); result.datas = result.datas.OrderByDescending(o => o.CreationTime).ToList(); ObjServ.Dispose(); return(Json(result)); }
public JsonResult DoRegist(Core.Members input) { ResultDto <int> result = new ResultDto <int>(); try { MembersService ObjServ = new MembersService(); var item1 = ObjServ.Reposity.GetAllList(o => o.UserName == input.UserName).Count(); var item2 = ObjServ.Reposity.GetAllList(o => o.Mobile == input.Mobile && o.Mobile != null).Count(); var item3 = ObjServ.Reposity.GetAllList(o => o.UserID == input.UserID && o.UserID != "00").Count(); if (item1 > 0) { result.code = 500; result.message = "用户名已经存在"; } else if (item2 > 0) { result.code = 500; result.message = "手机号已经存在"; } else if (item3 > 0) { result.code = 500; result.message = "身份证号已经存在"; } else if (input.Phone2 != Session["VeryCode"].ToString()) { result.code = 500; result.message = "手机验证码错误"; } else { Random rand = new Random(); int rank = rand.Next(1, 8); input.Photo = "/Content/dist/img/user" + rank.ToString() + ".jpg"; input.Password = MD5(input.Password); input.CreationTime = DateTime.Now; input.TenantId = tenant.Id; input.Phone2 = ""; ObjServ.Reposity.Insert(input); result.code = 100; result.message = "ok"; } ObjServ.Dispose(); } catch (Exception ex) { result.code = 500; result.message = ex.Message; } return(Json(result)); }
public JsonResult DoSignIn(long id) { ResultDto <int> result = new ResultDto <int>(); try { MembersService userServ = new MembersService(); SignUpBespeakService signupServ = new SignUpBespeakService(); var model = signupServ.Reposity.Get(id); if (model != null) { if (!model.SignIn) { var user = userServ.Reposity.GetAllList(o => o.Mobile == model.Telphone && o.TenantId == TenantId).FirstOrDefault(); if (user != null) { result.code = 100; result.message = "ok"; user.Points += 10; userServ.Reposity.Update(user); model.SignIn = true; signupServ.Reposity.Update(model); } else { result.code = 500; result.message = "签到失败!签到手机号与用户注册手机号不符!"; } } else { result.code = 500; result.message = "对不起,已经签到过了!"; } } else { result.code = 500; result.message = "签到失败!未找到预约信息!"; } userServ.Dispose(); signupServ.Dispose(); } catch (Exception ex) { result.code = 500; result.message = ex.Message; } return(Json(result)); }
public JsonResult InsertOrUpdate(Members input) { ResultDto <int> result = new ResultDto <int>(); try { using (MembersService Member = new MembersService()) { if (input.Id == 0) { input.CreationTime = DateTime.Now; } else { input.UpdateTime = DateTime.Now; } MembersService ObjRead = new MembersService(); var obj = ObjRead.Reposity.GetAllList(o => o.UserID == input.UserID && o.Id != input.Id && o.UserID != "00" && o.UserID != "").FirstOrDefault(); if (obj != null) { result.code = 500; result.message = "身份证号已存在"; } else { input.TenantId = TenantId; BirthdayAgeSex user = AppBase.GetBirthdayAgeSex(input.UserID); if (user != null) { input.Age = user.Age; input.Birthday = user.Birthday; input.Sex = user.Sex; } Member.Reposity.InsertOrUpdate(input); result.code = 100; result.datas = input.Id; result.message = "ok"; } ObjRead.Dispose(); } } catch (Exception ex) { result.code = 500; result.message = ex.Message; } return(Json(result)); }
public JsonResult GetbackPsw(string UserName, string Mobile, string VeryCode) { ResultDto <int> result = new ResultDto <int>(); try { MembersService ObjServ = new MembersService(); var model = ObjServ.Reposity.GetAllList(o => o.UserName == UserName).FirstOrDefault(); if (model != null) { if (model.Mobile != Mobile) { result.code = 500; result.message = "用户名和手机号码不匹配"; } else { if (VeryCode != Session["VeryCode"].ToString()) { result.code = 500; result.message = "验证码输入错误"; } else { var entity = model; entity.Password = MD5(VeryCode); ObjServ.Reposity.Update(entity); result.code = 100; result.message = "密码已重置为验证码,请妥善保存!"; } } } else { result.code = 500; result.message = "用户不存在"; } ObjServ.Dispose(); } catch (Exception ex) { result.code = 500; result.message = ex.Message; } return(Json(result)); }
public JsonResult GetMember(int id = 0) { Core.Members model = new Core.Members(); MembersService ObjServ = new MembersService(); var result = ObjServ.Reposity.Get(id); if (result != null) { model = result; } else { model.TenantId = tenant.Id; } ObjServ.Dispose(); return(Json(model)); }
public JsonResult Update(Core.Members input) { ResultDto <int> result = new ResultDto <int>(); try { MembersService ObjServ = new MembersService(); MembersService ObjServRead = new MembersService(); var item1 = ObjServ.Reposity.GetAllList(o => o.UserName == input.UserName && o.Id != MemberId).Count(); var item2 = ObjServ.Reposity.GetAllList(o => o.Mobile == input.Mobile && o.Id != MemberId).Count(); var item3 = ObjServ.Reposity.GetAllList(o => o.UserID == input.UserID && o.Id != MemberId && o.UserID != "00").Count(); if (item1 > 0) { result.code = 500; result.message = "用户名已经存在"; } else if (item2 > 0) { result.code = 500; result.message = "手机号已经存在"; } else if (item3 > 0) { result.code = 500; result.message = "身份证号已经存在"; } else { var model = ObjServRead.Reposity.Get(input.Id); input.Password = model.Password; input.CreationTime = model.CreationTime; ObjServ.Reposity.Update(input); result.code = 100; result.message = "ok"; } ObjServ.Dispose(); ObjServRead.Dispose(); } catch (Exception ex) { result.code = 500; result.message = ex.Message; } return(Json(result)); }
public JsonResult Del(int id) { ResultDto <string> result = new ResultDto <string>(); try { MembersService Member = new MembersService(); Member.Reposity.Delete(id); result.code = 100; result.message = "success"; Member.Dispose(); } catch (Exception ex) { result.code = 500; result.message = ex.Message; } return(Json(result)); }
public JsonResult GetModel() { Core.Members model = new Core.Members(); MembersService ObjServ = new MembersService(); var result = ObjServ.Reposity.Get(MemberId); if (result != null) { model = result; } else { model.TenantId = tenant.Id; } var entity = Mapper.Map <Dto.MemberDto>(model); ObjServ.Dispose(); return(Json(model)); }
public JsonResult GetCount() { Dto.SiteDto result = new Dto.SiteDto(); ArticlesService ArtServ = new ArticlesService(); MembersService MembServ = new MembersService(); SignUpBespeakService SignServ = new SignUpBespeakService(); ProductsService ProdServ = new ProductsService(); result.ArticleCount = ArtServ.Reposity.GetAllList(o => o.TenantId == TenantId).Count; result.MemberCount = MembServ.Reposity.GetAllList(o => o.TenantId == TenantId).Count; result.SignCount = SignServ.Reposity.GetAllList(o => o.TenantId == TenantId).Count; result.ProductCount = ProdServ.Reposity.GetAllList(o => o.TenantId == TenantId).Count; ArtServ.Dispose(); MembServ.Dispose(); SignServ.Dispose(); ProdServ.Dispose(); return(Json(result)); }
private ResultDto <List <Dto.MemberOutDto> > GetDatas(int page = 1, int pageSize = 0, string keywords = "", bool IsReger = true, string sort = "", string order = "") { ResultDto <List <Dto.MemberOutDto> > result = new ResultDto <List <Dto.MemberOutDto> >(); try { ResultDto <List <Members> > items = new ResultDto <List <Members> >(); MembersService Member = new MembersService(); var predicate = PredicateBuilder.True <Members>(); predicate = o => o.TenantId == TenantId && o.IsReger == IsReger; items = Member.GetListOrderByTime(page, pageSize, predicate, keywords, sort, order); result = Mapper.Map <ResultDto <List <Dto.MemberOutDto> > >(items); Member.Dispose(); } catch (Exception ex) { result.code = 500; result.message = ex.Message; } return(result); }
public JsonResult DoLogin(string UserName, string Password) { ResultDto <int> result = new ResultDto <int>(); try { MembersService ObjServ = new MembersService(); var model = ObjServ.Reposity.GetAllList(o => o.UserName == UserName || o.UserID == UserName || o.Mobile == UserName || o.Email == UserName).FirstOrDefault(); if (model != null) { if (model.Password != MD5(Password)) { result.code = 500; result.message = "密码错误"; } else { result.code = 100; result.message = "ok"; SetCookie("MemberId", model.Id.ToString(), 5); SetCookie("UserName", model.UserName, 5); } } else { result.code = 500; result.message = "用户不存在"; } ObjServ.Dispose(); } catch (Exception ex) { result.code = 500; result.message = ex.Message; } return(Json(result)); }
public JsonResult DelPatch(string ids) { ResultDto <string> result = new ResultDto <string>(); try { MembersService Member = new MembersService(); string[] idarr = ids.Split(','); foreach (string val in idarr) { int id = Convert.ToInt32(val); Member.Reposity.Delete(id); } result.code = 100; result.message = "success"; Member.Dispose(); } catch (Exception ex) { result.code = 500; result.message = ex.Message; } return(Json(result)); }
private void UploadMember() { toolBtnUpload.Enabled = false; Task.Run(() => { MembersService ObjServ = new MembersService(); MembersService ObjServRead = new MembersService(); errorRow = 0; compRow = 0; List <Members> members = new List <Members>(); try { members = ObjServRead.Reposity.GetAllList(o => o.TenantId == TenantId); } catch (Exception ex) { this.BeginInvoke(new Action(() => { textBoxError.Text = "获取数据错误:" + ex.Message + "\r\n"; })); } ObjServRead.Dispose(); foreach (DataGridViewRow row in dgvMain.Rows) { if (row != null) { string userid = row.Cells["身份证号"].Value != null ? row.Cells["身份证号"].Value.ToString() : ""; try { var obj = members.Where(o => o.UserID == userid && o.UserID != "0").FirstOrDefault(); if (obj != null) { #region update obj.TrueName = row.Cells["姓名"].Value.ToString(); obj.Relations = row.Cells["关系"].Value.ToString(); obj.Sex = row.Cells["性别"].Value.ToString(); obj.Nation = row.Cells["民族"].Value.ToString(); //obj.Birthday = row.Cells["出生年月"].Value.ToString(); obj.Age = AppBase.CInt(row.Cells["年龄"].Value); obj.Apartment = row.Cells["楼盘"].Value.ToString(); obj.UnitNum = row.Cells["单元"].Value.ToString(); obj.DoorCard = row.Cells["门牌号"].Value.ToString(); obj.UserID = row.Cells["身份证号"].Value.ToString(); obj.Address = row.Cells["现户籍地址"].Value.ToString(); obj.Address2 = row.Cells["原户籍地址"].Value.ToString(); obj.HhdRegister = row.Cells["是否兴塘社区户籍"].Value.ToString() == "是"; obj.ServiceAddr = row.Cells["服务处所"].Value.ToString(); obj.Duties = row.Cells["职务"].Value.ToString(); obj.Phone = row.Cells["联系电话1"].Value.ToString(); obj.Phone2 = row.Cells["联系电话2"].Value.ToString(); obj.PoliticalRole = row.Cells["政治面貌"].Value.ToString(); obj.PartyBranch = row.Cells["党员所在支部"].Value.ToString(); obj.CorridorLeader = row.Cells["是否楼道组长"].Value.ToString() == "是"; obj.HouseLeader = row.Cells["是否户代表"].Value.ToString() == "是"; obj.ResidentRepresentative = row.Cells["是否居民代表"].Value.ToString() == "是"; obj.ResidentLeader = row.Cells["是否居民组长"].Value.ToString() == "是"; obj.Pipwa = row.Cells["是否愿意参加公益"].Value.ToString() == "是"; obj.Eira = row.Cells["是否愿意从事居民事务"].Value.ToString() == "是"; obj.UpdateTime = DateTime.Now; obj.Speciality = row.Cells["特长备注"].Value.ToString(); obj.TenantId = TenantId; obj.Community = Community; obj.IsReger = false; ObjServ.Reposity.Update(obj); #endregion } else { #region insert Members entity = new Members(); entity.TrueName = row.Cells["姓名"].Value.ToString(); entity.Relations = row.Cells["关系"].Value.ToString(); entity.Nation = row.Cells["民族"].Value.ToString(); entity.Apartment = row.Cells["楼盘"].Value.ToString(); entity.UnitNum = row.Cells["单元"].Value.ToString(); entity.DoorCard = row.Cells["门牌号"].Value.ToString(); entity.UserID = row.Cells["身份证号"].Value.ToString(); entity.Address = row.Cells["现户籍地址"].Value.ToString(); entity.Address2 = row.Cells["原户籍地址"].Value.ToString(); entity.HhdRegister = row.Cells["是否兴塘社区户籍"].Value.ToString() == "是"; entity.ServiceAddr = row.Cells["服务处所"].Value.ToString(); entity.Duties = row.Cells["职务"].Value.ToString(); entity.Phone = row.Cells["联系电话1"].Value.ToString(); entity.Phone2 = row.Cells["联系电话2"].Value.ToString(); entity.PoliticalRole = row.Cells["政治面貌"].Value.ToString(); entity.PartyBranch = row.Cells["党员所在支部"].Value.ToString(); entity.CorridorLeader = row.Cells["是否楼道组长"].Value.ToString() == "是"; entity.HouseLeader = row.Cells["是否户代表"].Value.ToString() == "是"; entity.ResidentRepresentative = row.Cells["是否居民代表"].Value.ToString() == "是"; entity.ResidentLeader = row.Cells["是否居民组长"].Value.ToString() == "是"; entity.Pipwa = row.Cells["是否愿意参加公益"].Value.ToString() == "是"; entity.Eira = row.Cells["是否愿意从事居民事务"].Value.ToString() == "是"; entity.UpdateTime = DateTime.Now; entity.Speciality = row.Cells["特长备注"].Value.ToString(); entity.UserName = AppBase.GetRndCode(6); entity.Password = "******"; entity.Email = "-"; entity.CreationTime = DateTime.Now; entity.TenantId = TenantId; entity.Community = Community; entity.IsReger = false; BirthdayAgeSex user = AppBase.GetBirthdayAgeSex(entity.UserID); if (user != null) { entity.Age = user.Age; entity.Birthday = user.Birthday; entity.Sex = user.Sex; } else { entity.UserID = "no valid"; } ObjServ.Reposity.Insert(entity); #endregion } } catch (Exception ex) { errorRow++; this.BeginInvoke(new Action(() => { textBoxError.Text += "导入[" + userid + "]发生错误:" + ex.Message + " "; })); } compRow++; this.BeginInvoke(new Action(() => { progressBarM.Value = compRow > progressBarM.Maximum ? progressBarM.Maximum : compRow; labelCount.Text = "完成:" + progressBarM.Value + "/" + totalRow; labelError.Text = "错误:" + (errorRow > progressBarM.Maximum ? progressBarM.Maximum : errorRow); toolBtnUpload.Enabled = progressBarM.Value == totalRow; if (totalRow == progressBarM.Value) { MessageBox.Show("导入完毕!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information); } })); } } ObjServ.Dispose(); }); }
public JsonResult ImportExcel(HttpPostedFileBase file) { ResultDto <string> result = new ResultDto <string>(); try { if (file == null) { result.code = 101; result.message = "请选择上传的Excel文件"; } else { Stream inputStream = file.InputStream; HSSFWorkbook hssfworkbook = new HSSFWorkbook(inputStream); ISheet sheet = hssfworkbook.GetSheetAt(0); IRow headerRow = sheet.GetRow(0); int cellCount = headerRow.LastCellNum; int rowCount = sheet.LastRowNum; string[] CellArr = ("姓名|关系|性别|民族|年龄|楼盘|单元|门牌号|身份证号|现户籍地址|原户籍地址|是否兴塘社区户籍|服务处所|职务|联系电话1|联系电话2|政治面貌|党员所在支部|是否楼道组长|是否户代表|是否居民代表|是否居民组长|是否愿意参加公益|是否愿意从事居民事务|调查时间|特长备注").Split('|'); bool isValid = true; foreach (string item in CellArr) { ICell cell = headerRow.Cells.Where(o => o.StringCellValue == item).FirstOrDefault(); if (cell == null) { result.code = 500; result.message = "导入出错,缺少必要字段 “" + item + "”!"; isValid = false; break; } } if (isValid) { MembersService ObjServ = new MembersService(); MembersService ObjServRead = new MembersService(); TenantsService ObjTenant = new TenantsService(); string community = ""; var tent = ObjTenant.Reposity.Get(TenantId); if (tent != null) { community = tent.TenantName; } string msgs = ""; int nums = 0; for (int i = (sheet.FirstRowNum + 1); i <= rowCount; i++) { IRow row = sheet.GetRow(i); if (row != null) { string userid = CellVal(headerRow, "身份证号", row); try { var obj = ObjServRead.Reposity.GetAllList(o => o.UserID == userid && o.UserID != "0" && o.HhdRegister).FirstOrDefault(); if (obj != null) { obj.TrueName = CellVal(headerRow, "姓名", row); obj.Relations = CellVal(headerRow, "关系", row); obj.Sex = CellVal(headerRow, "性别", row); obj.Nation = CellVal(headerRow, "民族", row); //obj.Birthday = CellVal(headerRow, "出生年月", row); obj.Age = int.Parse(CellVal(headerRow, "年龄", row)); obj.Apartment = CellVal(headerRow, "楼盘", row); obj.UnitNum = CellVal(headerRow, "单元", row); obj.DoorCard = CellVal(headerRow, "门牌号", row); obj.UserID = CellVal(headerRow, "身份证号", row); obj.Address = CellVal(headerRow, "现户籍地址", row); obj.Address2 = CellVal(headerRow, "原户籍地址", row); obj.HhdRegister = CellVal(headerRow, "是否兴塘社区户籍", row) == "是"; obj.ServiceAddr = CellVal(headerRow, "服务处所", row); obj.Duties = CellVal(headerRow, "职务", row); obj.Phone = CellVal(headerRow, "联系电话1", row); obj.Phone2 = CellVal(headerRow, "联系电话2", row); obj.PoliticalRole = CellVal(headerRow, "政治面貌", row); obj.PartyBranch = CellVal(headerRow, "党员所在支部", row); obj.CorridorLeader = CellVal(headerRow, "是否楼道组长", row) == "是"; obj.HouseLeader = CellVal(headerRow, "是否户代表", row) == "是"; obj.ResidentRepresentative = CellVal(headerRow, "是否居民代表", row) == "是"; obj.ResidentLeader = CellVal(headerRow, "是否居民组长", row) == "是"; obj.Pipwa = CellVal(headerRow, "是否愿意参加公益", row) == "是"; obj.Eira = CellVal(headerRow, "是否愿意从事居民事务", row) == "是"; obj.UpdateTime = DateTime.Now; obj.Speciality = CellVal(headerRow, "特长备注", row); obj.TenantId = TenantId; obj.Community = community; obj.IsReger = false; ObjServ.Reposity.Update(obj); } else { Members entity = new Members(); entity.TrueName = CellVal(headerRow, "姓名", row); entity.Relations = CellVal(headerRow, "关系", row); entity.Sex = CellVal(headerRow, "性别", row); entity.Nation = CellVal(headerRow, "民族", row); //entity.Birthday = CellVal(headerRow, "出生年月", row); //entity.Age = int.Parse(CellVal(headerRow, "年龄", row)); entity.Apartment = CellVal(headerRow, "楼盘", row); entity.UnitNum = CellVal(headerRow, "单元", row); entity.DoorCard = CellVal(headerRow, "门牌号", row); entity.UserID = CellVal(headerRow, "身份证号", row); entity.Address = CellVal(headerRow, "现户籍地址", row); entity.Address2 = CellVal(headerRow, "原户籍地址", row); entity.HhdRegister = CellVal(headerRow, "是否兴塘社区户籍", row) == "是"; entity.ServiceAddr = CellVal(headerRow, "服务处所", row); entity.Duties = CellVal(headerRow, "职务", row); entity.Phone = CellVal(headerRow, "联系电话1", row); entity.Phone2 = CellVal(headerRow, "联系电话2", row); entity.PoliticalRole = CellVal(headerRow, "政治面貌", row); entity.PartyBranch = CellVal(headerRow, "党员所在支部", row); entity.CorridorLeader = CellVal(headerRow, "是否楼道组长", row) == "是"; entity.HouseLeader = CellVal(headerRow, "是否户代表", row) == "是"; entity.ResidentRepresentative = CellVal(headerRow, "是否居民代表", row) == "是"; entity.ResidentLeader = CellVal(headerRow, "是否居民组长", row) == "是"; entity.Pipwa = CellVal(headerRow, "是否愿意参加公益", row) == "是"; entity.Eira = CellVal(headerRow, "是否愿意从事居民事务", row) == "是"; entity.UpdateTime = DateTime.Now; entity.Speciality = CellVal(headerRow, "特长备注", row); entity.UserName = GetRndCode(6); entity.Password = "******"; entity.Email = "-"; entity.CreationTime = DateTime.Now; entity.TenantId = TenantId; entity.Community = community; entity.IsReger = false; BirthdayAgeSex user = AppBase.GetBirthdayAgeSex(entity.UserID); if (user != null) { entity.Age = user.Age; entity.Birthday = user.Birthday; entity.Sex = user.Sex; } else { entity.UserID = "身份证号码不合法"; } ObjServ.Reposity.Insert(entity); } nums++; } catch (Exception ex) { msgs += userid + "错误:" + ex.Message + ","; continue; } } } result.code = 100; result.message = "上传成功" + nums + "条。发生错误条目:" + msgs; ObjServ.Dispose(); ObjServRead.Dispose(); ObjTenant.Dispose(); } } } catch (Exception ex) { result.code = 101; result.message = "导入失败,错误原因:" + ex.Message; } return(Json(result)); }