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