public ActionResult Create(MemberViewModel model) { ServiceResult result = new ServiceResult(); TempData["Service_Result"] = result; if (ModelState.IsValid) { try { MemberService.Create(model); result.Message = "添加会员信息成功!"; LogHelper.WriteLog("添加会员信息成功"); return RedirectToAction("index"); } catch (Exception ex) { result.Message = Utilities.GetInnerMostException(ex); result.AddServiceError(result.Message); LogHelper.WriteLog("添加会员信息错误", ex); } } else { result.Message = "请检查表单是否填写完整!"; result.AddServiceError("请检查表单是否填写完整!"); } ViewBag.Data_GroupID = Utilities.GetSelectListData(GroupService.GetALL() , x => x.ID, x => x.Name, true); ViewBag.Data_DepartmentID = Utilities.GetSelectListData(DepartmentService.GetALL() , x => x.ID, x => x.Name, true); ViewBag.Data_JobTitleID = Utilities.GetSelectListData( JobTitleCateService.GetALL() , x => x.ID, x => x.CateName, true); return View(model); }
public ActionResult Create(MemberClerkViewModel model) { ServiceResult result = new ServiceResult(); TempData["Service_Result"] = result; if (ModelState.IsValid) { try { //groupID 6 指的是基本业务功能的会员群组 var entity = new MemberViewModel() { Address = model.Address, BirthDay = model.BirthDay, DepartmentID = model.DepartmentID, Description = model.Description, Email = model.Email, IsLeader = model.IsLeader, IsLeap = model.IsLeap, Mobile = model.Mobile, Mobile1 = model.Mobile1, NickName = model.NickName, Password = model.Password, QQ = model.QQ, Sex = model.Sex, GroupID = 6, FamilySituation = model.FamilySituation, IDNumber = model.IDNumber, JobExp = model.JobExp, AvtarUrl = model.AvtarUrl, StudyExp = model.StudyExp }; MemberService.Create(entity); result.Message = "添加业务人员成功!"; LogHelper.WriteLog("添加业务人员成功"); return RedirectToAction("index"); } catch (Exception ex) { result.Message = Utilities.GetInnerMostException(ex); result.AddServiceError(result.Message); LogHelper.WriteLog("添加业务人员错误", ex); } } else { result.Message = "请检查表单是否填写完整!"; result.AddServiceError("请检查表单是否填写完整!"); } var member = MemberService.GetALL().Include(x => x.Department) .Single(x => x.MemberID == CookieHelper.MemberID); var departCode = member.Department.Code; var maxCode = Utilities.GetMaxCode(departCode, member.Department.Level); ViewBag.Data_DepartmentID = Utilities.GetSelectListData( DepartmentService.GetALL().Where(x => x.Code >= departCode && x.Code <= maxCode) , x => x.ID, x => x.Name, true); return View(model); }
public ActionResult Import(ImportViewModel model) { ServiceResult result = new ServiceResult(); TempData["Service_Result"] = result; var savePath = Server.MapPath("~/" + model.FilePath); string strConn; strConn = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + savePath + ";" + "Extended Properties=Excel 8.0"; OleDbConnection conn = new OleDbConnection(strConn); conn.Open(); OleDbDataAdapter myCommand = new OleDbDataAdapter("select * from [Sheet1$]", strConn); DataSet myDataSet = new DataSet(); try { myCommand.Fill(myDataSet, "ExcelInfo"); } catch (Exception ex) { result.Message = Utilities.GetInnerMostException(ex); result.AddServiceError(result.Message); LogHelper.WriteLog("上传会员信息错误", ex); return View(); } DataTable table = myDataSet.Tables["ExcelInfo"].DefaultView.ToTable(); var departlist = DepartmentService.GetALL().ToList(); var jobtitlelist = JobTitleCateService.GetALL().ToList(); using (TransactionScope transaction = new TransactionScope()) { for (int i = 0; i < table.Rows.Count; i++) { var row = table.Rows[i]; var member = new MemberViewModel(); if (string.IsNullOrEmpty(row[1].ToString()) || string.IsNullOrEmpty(row[2].ToString()) || string.IsNullOrEmpty(row[3].ToString()) || string.IsNullOrEmpty(row[4].ToString()) || string.IsNullOrEmpty(row[6].ToString()) || string.IsNullOrEmpty(row[7].ToString()) ) { continue; } if (departlist.Count(x => x.Name == row[2].ToString()) == 0) { result.Message = "上传数据部门格式错误"; result.AddServiceError(result.Message); } else { member.DepartmentID = departlist.Single(x => x.Name == row[2].ToString()).ID; } if (jobtitlelist.Count(x => x.CateName == row[3].ToString()) == 0) { result.Message = "上传数据职称类别格式错误"; result.AddServiceError(result.Message); } else { member.JobTitleID = jobtitlelist.Single(x => x.CateName == row[3].ToString()).ID; } member.NickName = row[1].ToString().Replace(" ", ""); member.Mobile = row[4].ToString(); member.QQ = row[5].ToString(); member.Email = row[6].ToString(); member.Password = "******"; member.GroupID = 6; if (row[7].ToString() == "是") { member.IsLeader = true; } else { member.IsLeader = false; } if (row[8].ToString() == "男") { member.Sex = false; } else { member.Sex = true; } MemberService.Create(member); } transaction.Complete(); } System.Threading.Thread.Sleep(2000); result.Message = "批量导入用户数据成功!"; LogHelper.WriteLog("批量导入用户数据成功!"); return RedirectToAction("Index"); }