public ActionResult ReadXls() { AjaxMsgModel amm = new Message().NewAmm; amm.Msg = "导入文件格式不正确!"; #region 第一步EXCEL转DT int rowindex = 2; //开始行 int sheetindex = 0; //工作表索引 amm = new ExcelHelper().ToDataTable(System.Web.HttpContext.Current.Request.Files, sheetindex, rowindex, amm); if (amm.Statu == AjaxStatu.err) //如果转DT不成功 { return(ObjToJson.GetToJson(amm, true)); } DataTable dt = amm.Data as DataTable; amm.Data = null; #endregion #region 第二步DT转LIST amm = DataTableToList <SYS_MEMBER> .ConvertToList(dt, rowindex, amm); //转换为LIST集合 if (amm.Statu == AjaxStatu.err) //如果转LIST不成功 { return(ObjToJson.GetToJson(amm, true)); } List <SYS_MEMBER> list_SYS_MEMBER = amm.Data as List <SYS_MEMBER>; amm.Data = null; #endregion #region 第三步业务判断并插入数据库 //错误集合 List <TableToListErrorModel> errorList = new List <TableToListErrorModel>(); int rowline = 0; foreach (SYS_MEMBER member in list_SYS_MEMBER) { rowline++; if (member.NAME == "")//如果没有姓名 { amm.Statu = AjaxStatu.err; errorList.Add( new TableToListErrorModel() { rowIndex = rowindex + rowline, columnIndex = 0,//dt.Columns.IndexOf(tempName) + 1 errorInfo = "姓名必须输入", errorCause = "姓名必须输入" }); } } if (amm.Statu == AjaxStatu.err)//如果不存在 { amm.Data = errorList; return(ObjToJson.GetToJson(amm, true)); } //业务判断并插入数据库 return(ObjToJson.GetToJson(Model_SYS_MEMBER.AddList(list_SYS_MEMBER), true)); #endregion }
public AjaxMsgModel Save(VIEW_SYS_MEMBER data) { try { Mapper.CreateMap <VIEW_SYS_MEMBER, SYS_MEMBER>(); SYS_MEMBER u = Mapper.Map <VIEW_SYS_MEMBER, SYS_MEMBER>(data); u.UPDATE_DATE = DateTime.Now; u.UPDATE_USER = oc.CurrentUser.USER_NAME; u.DEL_FLAG = "0"; u.LOCATION_FLAG = data.LOCATION_FLAG_EXT ? "1" : "0"; if (u.MEMBER_ID == null || u.MEMBER_ID == "") { u.MEMBER_ID = DateTime.Now.ToString("yyyyMMddHHmmssfff"); u.MOBILE_STATE = "0";//新增手机默认正常状态 return(Model_SYS_MEMBER.Add(u)); } else { return(Model_SYS_MEMBER.Edit(u)); } } catch (Exception) { return(new Message().NewAmm); } }
public ActionResult GetORGMemberIntelligenceCheckedTree() { bool isCheckAll = false; isCheckAll = Model_SYS_MENU.HasPermission("Scripts", "SYS_MEMBER_POS2", "List", HttpMethod.Get); return(Content(Model_SYS_MEMBER.GetORGMemberIntelligenceCheckedTree(oc.CurrentUser.SYS_DEPT.DEPT_CODE, oc.CurrentUser.SYS_DEPT.PARENT_CODE, isCheckAll))); }
public AjaxMsgModel Del(VIEW_SYS_MEMBER data) { return(Model_SYS_MEMBER.Del(data.MEMBER_ID)); }