/// <summary>
/// 获取气象监测组织机构树
/// </summary>
/// <param name="DEPT_CODE"></param>
/// <param name="PARENT_CODE"></param>
/// <param name="isCheckAll"></param>
/// <returns></returns>
public static string GetWeatherDeptTree(string DEPT_CODE, string PARENT_CODE, bool isCheckAll)
{
string strJson = string.Empty;
List <SYS_DEPTANDMEMBER_TEMP> listOrgRy = new List <SYS_DEPTANDMEMBER_TEMP>();
List <SYS_DEPT> listMenu = oc.BllSession.ISYS_DEPTService.Entities.Where(m => m.DEL_FLAG == "0" && m.DEPT_CODE.Length <= 8 && (m.PARENT_CODE.StartsWith(DEPT_CODE) || m.DEPT_CODE == DEPT_CODE))
.OrderBy(m => m.DEPT_ORDER).ThenBy(m => m.DEPT_CODE).ToList();
if (listMenu.Count > 0)
{
foreach (SYS_DEPT org in listMenu)
{
listOrgRy.Add(new SYS_DEPTANDMEMBER_TEMP()
{
ORGRY_CODE = org.DEPT_CODE,
PARENT_CODE = org.PARENT_CODE,
ORGRY_NAME = org.DEPT_NAME,
ICO = org.C_ICO,
RYMOBILE = "",
STATE = org.STATUS_FLAG//0关闭
});
}
}
List <ZTreeNode> listTreeNodes = SYS_DEPTANDMEMBER_TEMP.ConvertZTreeNodes(listOrgRy, PARENT_CODE, DEPT_CODE, isCheckAll);
strJson = ObjToJson.GetToJson(listTreeNodes).Replace("Checked", "checked");
return(strJson);
}
/********************************************************
* 获取用户签到状态
* date：查询日期 可以为null
* rate：出勤率，全勤1，非全勤0，所有null
* ******************************************************/
private void GetSignStatus(HttpContext context)
{
//登录账号的ID
string empID = UsrAuth.GetempID(context.Session);
FeedBackMsg <CheckInInfo> feedBackMsg = new FeedBackMsg <CheckInInfo>();
//获取当前的考勤信息
CheckInInfo checkInInfo = CheckInInfoService.Instance.GetCurrentCheckInInfo(int.Parse(empID));
if (checkInInfo != null)
{
//已经签过到
feedBackMsg.Code = 1;
feedBackMsg.Msg = "已经签到";
feedBackMsg.Obj = checkInInfo;
}
else
{
//还没有签到
feedBackMsg.Code = 1;
feedBackMsg.Msg = "还没签到";
feedBackMsg.Obj = null;
}
string json = ObjToJson.ToJson(feedBackMsg);
context.Response.Write(json);
}
public static string GetMyORGNoZsTree(string DEPT_CODE, string PARENT_CODE, int DEPT_FLAG = 0)
{
string strJson = string.Empty;
//获得组织
List <SYS_DEPTANDMEMBER> listOrgMenu = oc.BllSession.ISYS_DEPTService.Entities.Where(m => m.DEL_FLAG == "0" && m.DEPT_FLAG == DEPT_FLAG && (m.PARENT_CODE.StartsWith(DEPT_CODE) || m.DEPT_CODE == DEPT_CODE))
.OrderBy(m => m.DEPT_ORDER).ThenBy(m => m.DEPT_CODE)
.Select(org => new SYS_DEPTANDMEMBER
{
ORGRY_CODE = org.DEPT_CODE,
PARENT_CODE = org.PARENT_CODE,
ORGRY_NAME = org.DEPT_NAME,
ICO = org.C_ICO,
RYMOBILE = "",
STATE = org.STATUS_FLAG //0关闭
})
.ToList();
if (DEPT_FLAG == 1)
{
listOrgMenu = GetDeptTree(listOrgMenu);
}
List <EasyUITreeNode> listTreeNodes = SYS_DEPTANDMEMBER.ConvertTreeNodes(listOrgMenu, PARENT_CODE, DEPT_CODE, false);
strJson = ObjToJson.GetToJson(listTreeNodes).Replace("Checked", "checked");
return(strJson);
}
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
}
/// *******************************************************
/// <summary>
/// 获取当前的工作时间设置
/// </summary>
/// <param name="context"></param>
/// *******************************************************
private void GetInfo(HttpContext context)
{
int code = 0;
string msg = "";
string json = "";
#region 验证管理员权限
if (!UsrAuth.IsAdminister(context.Session))
{
code = 0;
msg = "没有管理员权限";
json = "{\"Code\":\"" + code + "\",\"Msg\":\"" + msg + "\"}";
context.Response.Write(json);
return;
}
#endregion
WorkDuration workDuration = WorkDurationService.Instance.GetWorkDuration();
FeedBackMsg <WorkDuration> feedBack = new FeedBackMsg <WorkDuration>();
if (WorkDurationService.Instance != null)
{
feedBack.Code = 1;
feedBack.Msg = "当前的工作时间设置";
feedBack.Obj = workDuration;
}
json = ObjToJson.ToJson(feedBack);
context.Response.Write(json);
}
[HttpPost]//查询
public ViewModel List(VIEW_SYS_ROLE data)
{
int pageSize = int.Parse(data.rows);
int pageIndex = int.Parse(data.page);
string sort = data.sort;
string order = data.order;
//查询条件
IQueryable <SYS_ROLE> SYS_ROLEEntity = oc.BllSession.ISYS_ROLEService.Entities;
if (data.NAME != null && data.NAME != "")
{
SYS_ROLEEntity = SYS_ROLEEntity.Where(u => u.NAME.IndexOf(data.NAME) > -1);
}
int total = 0;
total = SYS_ROLEEntity.Count();
var listROLE = SYS_ROLEEntity.OrderBy(u => u.ROLE_ID)
.Skip(pageSize * (pageIndex - 1)).Take(pageSize)
.Select(mb => new
{
ROLE_ID = mb.ROLE_ID,
name = mb.NAME,
note = mb.NOTE
}).ToList();
return(ObjToJson.ViewModelToJson(listROLE, total));
}
public ActionResult GetSysOrderByMenuID(string id)
{
var list = oc.BllSession.ISYS_MENU_HELPCONTENTService.Entities
.Where(s => s.MENU_ID.Equals(id))
.Select(s => new { id = s.CONTENT_ORDER, text = s.CONTENT_ORDER }).Distinct();
return(Content(ObjToJson.GetToJson(list)));
}
[HttpPost]//查询
public ViewModel List(VIEW_SYS_USER data)
{
int pageSize = int.Parse(data.rows);
int pageIndex = int.Parse(data.page);
string sort = data.sort;
string order = data.order;
//查询条件
Expression <Func <SYS_USER, bool> > slamda = u => u.DEPT_CODE.StartsWith(oc.CurrentUser.SYS_DEPT.DEPT_CODE);
if (data.DEPT_CODE != null && data.DEPT_CODE != "")
{
slamda = u => u.DEPT_CODE.StartsWith(data.DEPT_CODE);
}
int total = 0;
total = oc.BllSession.ISYS_USERService.Entities.Where(slamda).Count();
var listMenus = oc.BllSession.ISYS_USERService.Entities.Include("SYS_USER_ROLE_MAP").Where(slamda).OrderBy(u => u.DEPT_CODE)
.Skip(pageSize * (pageIndex - 1)).Take(pageSize).Select(mb =>
new
{
deptcode = mb.DEPT_CODE,
deptname = mb.SYS_DEPT.DEPT_NAME,
depticon = mb.SYS_DEPT.C_ICO,
username = mb.USER_NAME,
zsname = mb.ZSNAME,
uptime = mb.UPDATE_DATE,
upuser = mb.UPDATE_USER,
mb.SYS_USER_ROLE_MAP
}
).ToList();
List <UserRoleModel> listMenu = new List <UserRoleModel>();
foreach (var item in listMenus)
{
string rolename = string.Empty;
foreach (var itemx in item.SYS_USER_ROLE_MAP)
{
if (rolename != "")
{
rolename += ",";
}
rolename += itemx.SYS_ROLE.NAME;
}
listMenu.Add(new UserRoleModel
{
deptcode = item.deptcode,
deptname = item.deptname,
USER_NAME = item.username,
ZSNAME = item.zsname,
uptime = item.uptime,
upuser = item.upuser,
rolename = rolename,
depticon = item.depticon
});
}
return(ObjToJson.ViewModelToJson(listMenu, total));
}
/**************************************************
* 获取员工信息列表
* MODIFY
* ************************************************/
private void GetList(HttpContext context)
{
string currentEmpName = UsrAuth.GetempName(context.Session);
string searchName = context.Request["searchName"];
string searchDepID = context.Request["searchDepID"];
string isDepList = context.Request["isDepList"];
if (string.IsNullOrEmpty(searchDepID))
{
searchDepID = "0";
}
FeedBackMsg <DepartmentAndEmployee> feedBack = new FeedBackMsg <DepartmentAndEmployee>();
List <EmployeeInfo> empList = new List <EmployeeInfo>();
if (UsrAuth.IsAdminister(context.Session))
{
//管理员或总经理
empList = EmployeeService.Instance.GetList(searchName, int.Parse(searchDepID));
}
else if (UsrAuth.IsDepManager(context.Session))
{
//部门经理
string depID = UsrAuth.GetdepID(context.Session);
empList = EmployeeService.Instance.GetEmployee(int.Parse(depID), searchName);
}
else
{
feedBack.Code = 0;
feedBack.Msg = "没有相应的权限";
feedBack.Obj = null;
}
DepartmentAndEmployee depAndEmp;
if (!string.IsNullOrEmpty(isDepList) && isDepList.Equals("1"))
{
List <Department> depList = DepartmentService.Instance.GetDepartment();
depAndEmp = new DepartmentAndEmployee()
{
DepList = depList,
EmpList = empList
};
}
else
{
depAndEmp = new DepartmentAndEmployee()
{
EmpList = empList
};
}
feedBack.Code = 1;
feedBack.Msg = "员工和部门列表";
feedBack.Obj = depAndEmp;
string json = ObjToJson.ToJson(feedBack);
context.Response.Write(json);
}
/********************************************************
* 描述：获取当前登录账户的月签到统计
* 参数：month 查询月份
* depName 部门名称
* empName 员工姓名
* rate 出勤率，全勤1，非全勤0，所有null
* ******************************************************/
//月考勤记录查询
private void GetMonthAttendanceList(HttpContext context)
{
string empID = UsrAuth.GetempID(context.Session);
string searchMonth = context.Request["searchMonth"];
string searchRate = context.Request["searchRate"];
string searchEmpName = context.Request["searchName"];
//MODIFY
string isSelf = context.Request["isSelf"];
if (string.IsNullOrEmpty(searchEmpName))
{
searchEmpName = null;
}
if (string.IsNullOrEmpty(searchRate))
{
searchRate = null;
}
string depID = "";
List <MonthAttendance> list = new List <MonthAttendance>();
FeedBackMsg <List <MonthAttendance> > feedBack = new FeedBackMsg <List <MonthAttendance> >();
if (!string.IsNullOrEmpty(isSelf) && isSelf.Equals("1"))
{
list = MonthAttendanceService.Instance.GetAttendanceStatistics(empID, searchMonth, searchRate);
}
else
{
if (UsrAuth.IsTopManager(context.Session) || UsrAuth.IsAdminister(context.Session))
{
depID = null;
list = MonthAttendanceService.Instance.GetAttendanceStatistics(searchMonth, depID, searchEmpName, searchRate);
}
else if (UsrAuth.IsDepManager(context.Session))
{
//部门经理
depID = UsrAuth.GetdepID(context.Session);
list = MonthAttendanceService.Instance.GetAttendanceStatistics(searchMonth, depID, searchEmpName, searchRate);
}
}
if (list != null && list.Count > 0)
{
feedBack.Code = 1;
feedBack.Msg = "月考勤信息";
feedBack.Obj = list;
}
else
{
feedBack.Code = 1;
feedBack.Msg = "沒有数据";
feedBack.Obj = null;
}
string json = ObjToJson.ToJson(feedBack);
context.Response.Write(json);
}
/// <summary>
/// 获取用户对应部门组织树
/// </summary>
/// <returns></returns>
public static string GetMyORGandRYTree(string DEPT_CODE, string PARENT_CODE, bool isCheckAll)
{
string strJson = string.Empty;
List <SYS_DEPTANDMEMBER_TEMP> listOrgRy = new List <SYS_DEPTANDMEMBER_TEMP>();
//获取人员
List <SYS_MEMBER> listRyMenu = oc.BllSession.ISYS_MEMBERService.GetListByCondition <string>(m => m.DEL_FLAG == "0" && m.LOCATION_FLAG == "1" && m.DEPT_CODE.StartsWith(DEPT_CODE), m => m.MOBILE).Select(mb => mb.ToPOCO()).ToList();
if (listRyMenu.Count > 0)
{
foreach (SYS_MEMBER ry in listRyMenu)
{
string icon = "icon-Off-line";
if (ry.MOBILE_STATE == "1")
{
icon = "icon-status_busy";
}
listOrgRy.Add(new SYS_DEPTANDMEMBER_TEMP()
{
ORGRY_CODE = ry.MOBILE,
PARENT_CODE = ry.DEPT_CODE,
ORGRY_NAME = ry.NAME,
ICO = icon,
RYMOBILE = ry.MOBILE,
STATE = "0"//关闭
});
}
}
//获得组织
//List<SYS_ORG> listMenu = oc.BllSession.ISYS_ORGService.GetListByCondition<string>(m => m.DEL_FLAG == "0", m => m.DEPT_CODE).Select(mb => mb.ToPOCO()).ToList();
List <SYS_DEPT> listMenu = oc.BllSession.ISYS_DEPTService.Entities.Where(m => m.DEL_FLAG == "0" && (m.PARENT_CODE.StartsWith(DEPT_CODE) || m.DEPT_CODE == DEPT_CODE))
.OrderBy(m => m.DEPT_ORDER).ThenBy(m => m.DEPT_CODE).ToList();
if (listMenu.Count > 0)
{
foreach (SYS_DEPT org in listMenu)
{
listOrgRy.Add(new SYS_DEPTANDMEMBER_TEMP()
{
ORGRY_CODE = org.DEPT_CODE,
PARENT_CODE = org.PARENT_CODE,
ORGRY_NAME = org.DEPT_NAME,
ICO = org.C_ICO,
RYMOBILE = "",
STATE = org.STATUS_FLAG//0关闭
});
}
}
//List<EasyUITreeNode> listTreeNodes = SYS_DEPTANDMEMBER.ConvertTreeNodes(listOrgRy, PARENT_CODE, DEPT_CODE, isCheckAll);
List <ZTreeNode> listTreeNodes = SYS_DEPTANDMEMBER_TEMP.ConvertZTreeNodes(listOrgRy, PARENT_CODE, DEPT_CODE, isCheckAll);
strJson = ObjToJson.GetToJson(listTreeNodes).Replace("Checked", "checked");
return(strJson);
}
public ActionResult GetMyMenuListTree()
{
List <string> listMuenId = oc.UserMenuPermission
.Where(u => string.IsNullOrEmpty(u.GIS_ORDER)).Select(u => u.MENU_ID).ToList();
List <SYS_MENU> listMenu = oc.BllSession.ISYS_MENUService.Entities
.Where(m => listMuenId.Contains(m.MENU_ID) && m.MENU_LEVEL < 3
)
.OrderBy(m => m.MENU_ID).OrderBy(m => m.MENU_ORDER).ToList();
return(Content(ObjToJson.GetToJson(SYS_MENU.ConvertTreeNodes(listMenu, "0"))));
}
[HttpPost]//查询
public ViewModel List(VIEW_SYS_MEMBER data)
{
int pageSize = int.Parse(data.rows);
int pageIndex = int.Parse(data.page);
string sort = data.sort;
string order = data.order;
//查询条件
IQueryable <SYS_MEMBER> SYS_MEMBEREntity = oc.BllSession.ISYS_MEMBERService.Entities;
if (!string.IsNullOrEmpty(data.MOBILE))
{
SYS_MEMBEREntity = SYS_MEMBEREntity.Where(u => u.MOBILE.Contains(data.MOBILE) && u.DEL_FLAG == "0");
}
else
{
if (data.DEPT_CODE != null && data.DEPT_CODE != "")
{
SYS_MEMBEREntity = SYS_MEMBEREntity.Where(u => u.DEPT_CODE.StartsWith(data.DEPT_CODE) && u.DEL_FLAG == "0");
}
else
{
SYS_MEMBEREntity = SYS_MEMBEREntity.Where(u => u.DEPT_CODE.StartsWith(oc.CurrentUser.SYS_DEPT.DEPT_CODE) && u.DEL_FLAG == "0");
}
}
int total = 0;
total = SYS_MEMBEREntity.Count();
var listMEMBER = SYS_MEMBEREntity.OrderBy(u => u.DEPT_CODE)
.Skip(pageSize * (pageIndex - 1)).Take(pageSize).Select(mb =>
new
{
MEMBER_ID = mb.MEMBER_ID,
deptname = mb.SYS_DEPT.DEPT_NAME,
depticon = mb.SYS_DEPT.C_ICO,
deptcode = mb.SYS_DEPT.DEPT_CODE,
name = mb.NAME,
mobile = mb.MOBILE,
update = mb.UPDATE_DATE,
upuser = mb.UPDATE_USER,
job = mb.JOB,
phone = mb.PHONE,
loctionflag = mb.LOCATION_FLAG,
intelligence = mb.SYS_INTELLIGENCE_DIC.DIC_NAME,
poslevel = mb.SYS_POSLEVEL_DIC.DIC_NAME,
state = mb.MOBILE_STATE
}
).ToList();
//return ObjToJson.GetToJson(listMenu, total, true);
return(ObjToJson.ViewModelToJson(listMEMBER, total));
}
private static void RequestWithPostObject()
{
var postObj = new ObjToJson {
Job = "leader", Name = "morpheus"
};
var response = RestWrapper.CreateWithHttpClient(_client)
.Url($"https://reqres.in/api/users/2")
.Build()
.SendPost <JsonElement, ObjToJson>(postObj)
.GetAwaiter().GetResult();
Console.WriteLine($"\n>>> Id from response is: {response.GetProperty("id")}");
}
private static int RequestWithWrongUrl()
{
var postObj = new ObjToJson {
Job = "leader", Name = "morpheus"
};
return((int)RestWrapper.CreateWithHttpClient(_client)
.Url($"raasdasdasdsdasdasdeqres.in/users/2")
.AddHeaders("Custom", "Test")
.AddHeaders("Custom2", "Test2")
.Build()
.SendPost <ObjToJson>(postObj)
.GetAwaiter().GetResult().StatusCode);
}
public ActionResult GetMyOneMenu()
{
string strJson = "[]";
//获取用户默认子系统menuid
string defuMenuID = GetDefuMenu();
if (!string.IsNullOrEmpty(defuMenuID))
{
SYS_MENU parMenu = oc.BllSession.ISYS_MENUService.Entities.Where(u => u.MENU_ID.Equals(defuMenuID)).FirstOrDefault();
string defuMenu = string.Empty;
try
{
if (!string.IsNullOrEmpty(parMenu.DEFMENU_ID))
{
defuMenu = parMenu.DEFMENU_ID.Substring(0, 4);
}
}
catch
{
defuMenu = string.Empty;
}
List <SYS_MENU> listMenu = oc.UserMenuPermission.Where(m => m.PARENT_ID.Equals(defuMenuID)
//&& !Constant.PersonLocationMenuID.Split(',').Contains(m.MENU_ID)
&& string.IsNullOrEmpty(m.GIS_ORDER)).OrderBy(m => m.MENU_ORDER).ToList();
//.OrderByDescending(m => m.GIS_ORDER).ThenBy(m => m.MENU_ORDER).ToList();
if (listMenu.Count > 0)
{
if (string.IsNullOrEmpty(defuMenu))
{
defuMenu = listMenu[0].MENU_ID;
}
List <EasyUITreeNode> listTreeNodes = SYS_MENU.ConvertTreeNodes(listMenu, defuMenuID);
foreach (EasyUITreeNode node in listTreeNodes)
{
if (node.id.Equals(defuMenu))
{
node.isdefuopen = "Y";
}
else
{
node.isdefuopen = "N";
}
}
strJson = ObjToJson.GetToJson(listTreeNodes).Replace("Checked", "checked");
}
}
return(Content(strJson));
}
public static string GetCarTree_TWO(string DEPT_CODE, string PARENT_CODE, bool isCheckAll)
{
string strJson = string.Empty;
List <SYS_DEPTANDMEMBER_TEMP> listOrgRy = new List <SYS_DEPTANDMEMBER_TEMP>();
//获取人员
List <CAR_BDATA_CAR> listCarMenu = oc.BllSession.ICAR_BDATA_CARService.GetListByCondition <string>(m => m.DEPT_CODE.StartsWith(DEPT_CODE), m => m.CAR_NO).Select(mb => mb.ToPOCO()).ToList();
if (listCarMenu.Count > 0)
{
foreach (CAR_BDATA_CAR ry in listCarMenu)
{
listOrgRy.Add(new SYS_DEPTANDMEMBER_TEMP()
{
ORGRY_CODE = ry.CAR_NO,
PARENT_CODE = ry.DEPT_CODE,
ORGRY_NAME = ry.CAR_LICENSENO,
ICO = "car-Off-line",
RYMOBILE = ry.CAR_NO,
STATE = "0"//关闭
});
}
}
//获得组织
//List<SYS_ORG> listMenu = oc.BllSession.ISYS_ORGService.GetListByCondition<string>(m => m.DEL_FLAG == "0", m => m.DEPT_CODE).Select(mb => mb.ToPOCO()).ToList();
List <SYS_DEPT> listMenu = oc.BllSession.ISYS_DEPTService.Entities.Where(m => m.DEL_FLAG == "0" && (m.PARENT_CODE.StartsWith(DEPT_CODE) || m.DEPT_CODE == DEPT_CODE))
.OrderBy(m => m.DEPT_ORDER).ThenBy(m => m.DEPT_CODE).ToList();
if (listMenu.Count > 0)
{
foreach (SYS_DEPT org in listMenu)
{
listOrgRy.Add(new SYS_DEPTANDMEMBER_TEMP()
{
ORGRY_CODE = org.DEPT_CODE,
PARENT_CODE = org.PARENT_CODE,
ORGRY_NAME = org.DEPT_NAME,
ICO = org.C_ICO,
RYMOBILE = "",
STATE = org.STATUS_FLAG//0关闭
});
}
}
List <ZTreeNode> listTreeNodes = SYS_DEPTANDMEMBER_TEMP.ConvertZTreeNodes(listOrgRy, PARENT_CODE, DEPT_CODE, isCheckAll);
//return ObjToJson.GetToJson(listTreeNodes, true);
strJson = ObjToJson.GetToJson(listTreeNodes).Replace("Checked", "checked");
return(strJson);
}
private void GetInfo(HttpContext context)
{
int selectedCheckInInfoID = int.Parse(context.Request["id"]);
CheckInInfo checkInInfo = CheckInInfoService.Instance.GetCheckInInfo(selectedCheckInInfoID);
FeedBackMsg <CheckInInfo> feedBack = new FeedBackMsg <CheckInInfo>()
{
Code = 1,
Msg = "选中的签到项的具体信息",
Obj = checkInInfo
};
string json = ObjToJson.ToJson(feedBack);
context.Response.Write(json);
}
/// <summary>
/// 获取所有组织与人员树
/// </summary>
/// <returns></returns>
public static string GetORGandRYTree()
{
string strJson = string.Empty;
List <SYS_DEPTANDMEMBER> listOrgRy = new List <SYS_DEPTANDMEMBER>();
//获取人员
List <SYS_MEMBER> listRyMenu = oc.BllSession.ISYS_MEMBERService.GetListByCondition <string>(m => m.DEL_FLAG == "0" && m.LOCATION_FLAG == "1", m => m.MOBILE).Select(mb => mb.ToPOCO()).ToList();
if (listRyMenu.Count > 0)
{
foreach (SYS_MEMBER ry in listRyMenu)
{
listOrgRy.Add(new SYS_DEPTANDMEMBER()
{
ORGRY_CODE = ry.MOBILE,
PARENT_CODE = ry.DEPT_CODE,
ORGRY_NAME = ry.NAME,
ICO = "icon-Off-line",
RYMOBILE = ry.MOBILE,
STATE = "0"//关闭
});
}
}
//获得组织
List <SYS_DEPT> listMenu = oc.BllSession.ISYS_DEPTService.GetListByCondition <string>(m => m.DEL_FLAG == "0", m => m.DEPT_CODE)
.OrderBy(m => m.DEPT_ORDER).ThenBy(m => m.DEPT_CODE).Select(mb => mb.ToPOCO()).ToList();
if (listMenu.Count > 0)
{
foreach (SYS_DEPT org in listMenu)
{
listOrgRy.Add(new SYS_DEPTANDMEMBER()
{
ORGRY_CODE = org.DEPT_CODE,
PARENT_CODE = org.PARENT_CODE,
ORGRY_NAME = org.DEPT_NAME,
ICO = org.C_ICO,
RYMOBILE = "",
STATE = org.STATUS_FLAG//0关闭
});
}
}
List <EasyUITreeNode> listTreeNodes = SYS_DEPTANDMEMBER.ConvertTreeNodes(listOrgRy, "0", "", false);
//return ObjToJson.GetToJson(listTreeNodes, true);
strJson = ObjToJson.GetToJson(listTreeNodes).Replace("Checked", "checked");
return(strJson);
}
private void GetInfo(HttpContext context)
{
int selectedEmpID = int.Parse(context.Request["id"]);
EmployeeInfo empInfo = EmployeeService.Instance.GetEmployee(selectedEmpID);
FeedBackMsg <EmployeeInfo> feedBack = new FeedBackMsg <EmployeeInfo>()
{
Code = 1,
Msg = "选中员工信息",
Obj = empInfo
};
string json = ObjToJson.ToJson(feedBack);
context.Response.Write(json);
}
public ActionResult GetMyZeroMenu()
{
string strJson = "[]";
List <SYS_MENU> listMenu = oc.BllSession.ISYS_MENUService.Entities
.Where(m => m.PARENT_ID.Equals(Constant.systemParID)).OrderBy(m => m.MENU_ORDER).ToList();// oc.BllSession.ISYS_MENUService.Entities.ToList();//.GetListByCondition<decimal?>(null, ma => ma.MENU_LEVEL).Select(mb => mb.ToPOCO()).ToList();
//2015-11-06 新增不显示菜单
listMenu = listMenu.Where(u => string.IsNullOrEmpty(u.ISSHOW_FLAG) || (!string.IsNullOrEmpty(u.ISSHOW_FLAG) && !u.ISSHOW_FLAG.Equals("0"))).ToList();
//List<string> showlistMenu=listMenu.Select(u=>u.MENU_ID).ToList();
if (listMenu.Count > 0)
{
List <EasyUITreeNode> listTreeNodes = SYS_MENU.ConvertTreeNodes(listMenu, Constant.systemParID);
//获取用户拥有权限的子系统
List <string> hasPermissionSyss = oc.UserMenuPermission.Where(u => u.PARENT_ID.Equals(Constant.systemParID)).OrderBy(u => u.MENU_ORDER)
.Select(u => u.MENU_ID).ToList();
//获取用户默认子系统
string defuMenuID = GetDefuMenu();
foreach (EasyUITreeNode node in listTreeNodes)
{
if (node.id.Equals(defuMenuID))
{
node.isdefu = "Y";
}
else
{
node.isdefu = "N";
}
if (hasPermissionSyss.Contains(node.id))
{
node.haspermission = "Y";
}
else
{
node.haspermission = "N";
}
}
strJson = ObjToJson.GetToJson(listTreeNodes.OrderByDescending(m => m.haspermission)).Replace("Checked", "checked");
}
return(Content(strJson));
}
public void GetInfo(HttpContext context)
{
string json = "";
int depId = int.Parse(context.Request["id"]);
DepartmentService departmentService = new DepartmentService();
Department dep = departmentService.GetInfo(depId);
FeedBackMsg <Department> feedBack = new FeedBackMsg <Department>();
if (dep != null)
{
feedBack.Code = 1;
feedBack.Msg = "部门列表";
feedBack.Obj = dep;
}
else
{
feedBack.Code = 0;
feedBack.Msg = "没有数据";
feedBack.Obj = null;
}
json = ObjToJson.ToJson(feedBack);
context.Response.Write(json);
}
/**************************************************
* 部门列表
* 可用于查询、点击部门管理时显示部门列表
* 页面参数：depName 部门名称，当为空是获取部门列表
* ***********************************************/
public void GetList(HttpContext context)
{
int code = 0;
string msg = "";
string json = "";
string depName = context.Request["searchName"];
#region 验证操作权限
if (!UsrAuth.IsAdminister(context.Session))
{//无管理员权限
code = 0;
msg = "无‘管理员’权限";
json = "{\"Code\":\"" + code + "\",\"Msg\":\"" + msg + "\"}";
context.Response.Write(json);
return;
}
#endregion
DepartmentService departmentService = new DepartmentService();
List <Department> depList = departmentService.GetDepartment(depName);
FeedBackMsg <List <Department> > feedBack = new FeedBackMsg <List <Department> >();
if (depList != null && depList.Count > 0)
{
feedBack.Code = 1;
feedBack.Msg = "部门列表";
feedBack.Obj = depList;
}
else
{
feedBack.Code = 0;
feedBack.Msg = "没有数据";
feedBack.Obj = null;
}
json = ObjToJson.ToJson(feedBack);
context.Response.Write(json);
}
/// <summary>
/// 获取气象监测线名树
/// </summary>
/// <param name="DEPT_CODE"></param>
/// <param name="PARENT_CODE"></param>
/// <returns></returns>
public static string GetWeatherLineTree(string DEPT_CODE, string PARENT_CODE)
{
Dictionary <string, string> deptDict = new Dictionary <string, string>();
if (DEPT_CODE.Length == 2)
{
IQueryable <SYS_DEPT> dic = oc.BllSession.ISYS_DEPTService.Entities.Where(m => m.DEL_FLAG == "0" && m.DEPT_CODE.Length <= 4);
foreach (var item in dic)
{
deptDict.Add(item.DEPT_CODE, item.DEPT_NAME);
}
}
string strJson = string.Empty;
List <SYS_DEPTANDMEMBER_TEMP> listorgHost = new List <SYS_DEPTANDMEMBER_TEMP>();
//获取主机
List <BROKENRAIL_BDATA_SECTION> listHost = oc.BllSession.IBROKENRAIL_BDATA_SECTIONService
.GetListByCondition <string>(g => g.DEPT_CODE.StartsWith(DEPT_CODE), g => g.SECTION_ID).ToList();
listHost = listHost.OrderBy(o => o.START_MILE).ToList();
//cwb
List <BROKENRAIL_BDATA_DEVICE> listDevice = oc.BllSession.IBROKENRAIL_BDATA_DEVICEService.Entities.Where(o => o.TYPE == "主机").ToList();
if (listHost.Count > 0)
{
foreach (BROKENRAIL_BDATA_SECTION host in listHost)
{
string head = string.Empty;
if (DEPT_CODE.Length == 2)
{
head = deptDict[host.DEPT_CODE];
}
listorgHost.Add(new SYS_DEPTANDMEMBER_TEMP
{
ORGRY_CODE = host.SECTION_ID,
PARENT_CODE = host.LINE_NAME,
ORGRY_NAME = host.SECTION_NAME,
ICO = "icon-drive",
RYMOBILE = head + "(" + GetToKDESC(host.START_MILE) + "~" + GetToKDESC(host.END_MILE) + ")",
STATE = "0",
//cwb
// PHONE = host.SECTION_ID//oc.BllSession.IBROKENRAIL_BDATA_DEVICEService.Entities.Where(o => o.SECTION_ID == host.SECTION_ID && o.TYPE == "主机").FirstOrDefault().POINT_NO
PHONE = listDevice.Where(o => o.SECTION_ID == host.SECTION_ID).FirstOrDefault().POINT_NO
});
}
}
List <string> line = oc.BllSession.IBROKENRAIL_BDATA_SECTIONService.Entities.Select(o => o.LINE_NAME).Distinct().ToList();
IQueryable <T_JOB_LINE> listLineMenu = oc.BllSession.IT_JOB_LINEService.Entities.Where(o => o.LINE_DEPTCODE.Contains(DEPT_CODE));
foreach (var item in listLineMenu)
{
if (!line.Contains(item.LINE_NAME))
{
line.Insert(line.Count, item.LINE_NAME);
}
}
SYS_DEPT dept = oc.BllSession.ISYS_DEPTService.Entities.Where(m => m.DEL_FLAG == "0" && m.DEPT_CODE == DEPT_CODE).FirstOrDefault();
//List<SYS_DEPT> listMenu = oc.BllSession.ISYS_DEPTService.Entities
// .Where(m => m.DEL_FLAG == "0" && (m.PARENT_CODE.StartsWith(DEPT_CODE) || m.DEPT_CODE == DEPT_CODE))
// .OrderBy(m => m.DEPT_ORDER).ThenBy(m => m.DEPT_CODE).ToList();
if (dept != null)
{
listorgHost.Add(new SYS_DEPTANDMEMBER_TEMP()
{
ORGRY_CODE = dept.DEPT_CODE,
PARENT_CODE = dept.PARENT_CODE,
ORGRY_NAME = dept.DEPT_NAME,
ICO = "icon-DepartMent",
RYMOBILE = "",
STATE = "0"//0关闭
});
if (listLineMenu.Count() > 0)
{
foreach (var org in line)
{
listorgHost.Add(new SYS_DEPTANDMEMBER_TEMP()
{
ORGRY_CODE = org,
PARENT_CODE = DEPT_CODE,
ORGRY_NAME = org,
ICO = "icon-DepartMent",
RYMOBILE = "",
STATE = "0"//0关闭
});
}
}
}
List <ZTreeNode> listTreeNodes = SYS_DEPTANDMEMBER_TEMP.ConvertZTreeNodes(listorgHost, PARENT_CODE, DEPT_CODE, true);
strJson = ObjToJson.GetToJson(listTreeNodes).Replace("Checked", "checked");
return(strJson);
}
public ActionResult ReadXls()
{
//本功能只支持一次全部部门和人员导入，不适合追加和修改
AjaxMsgModel amm = new Message().NewAmm;
amm.Msg = "导入文件格式不正确！";
#region 第一步EXCEL转DT
int rowindex = 2; //开始行
int sheetindex = 0; //工作表索引
amm = new ExcelExtHelper().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 <VIEW_SYS_DEPT> .ConvertToList(dt, rowindex, amm); //转换为LIST集合
if (amm.Statu == AjaxStatu.err) //如果转LIST不成功
{
return(ObjToJson.GetToJson(amm, true));
}
List <VIEW_SYS_DEPT> list_VIEW_SYS_DEPT = amm.Data as List <VIEW_SYS_DEPT>;
amm.Data = null;
#endregion
#region 第三步业务判断并插入数据库
List <SYS_DEPT> list_SYS_DEPT = new List <SYS_DEPT>();
List <SYS_MEMBER> list_SYS_MEMBER = new List <SYS_MEMBER>();
Dictionary <string, string> DeptCodeMap = new Dictionary <string, string>();
Dictionary <string, string> MemberIntelligenceMap = new Dictionary <string, string>();
List <SYS_INTELLIGENCE_DIC> lisMI = oc.BllSession.ISYS_INTELLIGENCE_DICService.Entities.ToList();
foreach (SYS_INTELLIGENCE_DIC item in lisMI)
{
MemberIntelligenceMap.Add(item.DIC_NAME, item.DIC_ID);
}
//错误集合
//List<TableToListErrorModel> errorList = new List<TableToListErrorModel>();
//int rowline = 0;
if (list_VIEW_SYS_DEPT.Count > 0)
{
try
{
//局
List <VIEW_SYS_DEPT> listDEPT = list_VIEW_SYS_DEPT.Where(u => u.DEPT_NAME != "" && u.DEPT_CODE != "").GroupBy(u => new { u.DEPT_NAME, u.DEPT_CODE })
.Select(g => new VIEW_SYS_DEPT {
DEPT_CODE = g.Key.DEPT_CODE, DEPT_NAME = g.Key.DEPT_NAME
}).ToList();
if (listDEPT.Count > 0)
{
foreach (VIEW_SYS_DEPT jgs in listDEPT)
{
if (oc.BllSession.ISYS_DEPTService.Entities.Where(u => u.DEPT_CODE == jgs.DEPT_CODE).Count() == 0)
{ //如果数据库无此部门编码则添加
list_SYS_DEPT.Add(new SYS_DEPT() //局
{
DEPT_CODE = jgs.DEPT_CODE,
DEPT_NAME = jgs.DEPT_NAME,
PARENT_CODE = "0",
DEPT_ORDER = 0,
DEL_FLAG = "0",
STATUS_FLAG = "0",
C_ICO = "icon-DepartMent",
DEPT_FLAG = 0
});
}
DeptCodeMap.Add(jgs.DEPT_NAME, jgs.DEPT_CODE);
}
}
//工务段
List <VIEW_SYS_DEPT> listDEPT_GWD = list_VIEW_SYS_DEPT.Where(u => u.DEPT_NAME != "" && u.DEPT_CODE != "" && u.GWD_NAME != "" && u.GWD_CODE != "")
.GroupBy(u => new { u.DEPT_NAME, u.DEPT_CODE, u.GWD_NAME, u.GWD_CODE })
.Select(g => new VIEW_SYS_DEPT {
DEPT_NAME = g.Key.DEPT_NAME, GWD_NAME = g.Key.GWD_NAME, GWD_CODE = g.Key.GWD_CODE
}).ToList();
if (listDEPT_GWD.Count > 0)
{
foreach (VIEW_SYS_DEPT gwd in listDEPT_GWD)
{
if (oc.BllSession.ISYS_DEPTService.Entities.Where(u => u.DEPT_CODE == gwd.GWD_CODE).Count() == 0)
{ //如果数据库无此部门编码则添加
list_SYS_DEPT.Add(new SYS_DEPT() //段
{
DEPT_CODE = gwd.GWD_CODE,
DEPT_NAME = gwd.GWD_NAME,
PARENT_CODE = gwd.GWD_CODE.Substring(0, 2),
DEPT_ORDER = 0,
DEL_FLAG = "0",
STATUS_FLAG = "0",
C_ICO = "icon-DepartMent",
DEPT_FLAG = 0
});
}
DeptCodeMap.Add(gwd.DEPT_NAME + "_" + gwd.GWD_NAME, gwd.GWD_CODE);
}
}
//虚拟目录列
List <VIEW_SYS_DEPT> listDEPT_XN = list_VIEW_SYS_DEPT.Where(u => u.DEPT_NAME != "" && u.DEPT_CODE != "" && u.GWD_NAME != "" && u.GWD_CODE != "" && u.XN_NAME != "")
.OrderBy(u => u.GWD_CODE).GroupBy(u => new { u.DEPT_NAME, u.DEPT_CODE, u.GWD_NAME, u.GWD_CODE, u.XN_NAME })
.Select(g => new VIEW_SYS_DEPT {
DEPT_NAME = g.Key.DEPT_NAME, GWD_NAME = g.Key.GWD_NAME, XN_NAME = g.Key.XN_NAME, GWD_CODE = g.Key.GWD_CODE
}).ToList();
if (listDEPT_XN.Count > 0)
{
string gwdcode = "";
int i = 1;
foreach (VIEW_SYS_DEPT xn in listDEPT_XN)
{
if (gwdcode != xn.GWD_CODE)//如果是新父级，则重新编号
{
i = 1;
gwdcode = xn.GWD_CODE;
}
string xnNum = i < 10 ? "0" + i.ToString() : i.ToString();
string xncode = xn.GWD_CODE + xnNum;
if (oc.BllSession.ISYS_DEPTService.Entities.Where(u => u.DEPT_CODE == xncode).Count() == 0)
{ //如果数据库无此部门编码则添加
list_SYS_DEPT.Add(new SYS_DEPT() //虚拟目录列
{
DEPT_CODE = xn.GWD_CODE + xnNum,
DEPT_NAME = xn.XN_NAME,
PARENT_CODE = xn.GWD_CODE,
DEPT_ORDER = 0,
DEL_FLAG = "0",
STATUS_FLAG = "0",
C_ICO = "icon-DepartMent",
DEPT_FLAG = 0
});
}
DeptCodeMap.Add(xn.DEPT_NAME + "_" + xn.GWD_NAME + "_" + xn.XN_NAME, xn.GWD_CODE + xnNum);
i++;
}
}
//车间
List <VIEW_SYS_DEPT> listDEPT_CJ = list_VIEW_SYS_DEPT.Where(u => u.DEPT_NAME != "" && u.DEPT_CODE != "" && u.GWD_NAME != "" && u.GWD_CODE != "" && u.XN_NAME != "" && u.CJ_NAME != "")
.OrderBy(u => u.XN_NAME).GroupBy(u => new { u.DEPT_NAME, u.DEPT_CODE, u.GWD_NAME, u.GWD_CODE, u.XN_NAME, u.CJ_NAME })
.Select(g => new VIEW_SYS_DEPT {
DEPT_NAME = g.Key.DEPT_NAME, GWD_NAME = g.Key.GWD_NAME, XN_NAME = g.Key.XN_NAME, CJ_NAME = g.Key.CJ_NAME
}).ToList();
if (listDEPT_CJ.Count > 0)
{
string xnname = "";
int j = 1;
foreach (VIEW_SYS_DEPT cj in listDEPT_CJ)
{
try
{
if (xnname != cj.XN_NAME)//如果是新父级，则重新编号
{
j = 1;
xnname = cj.XN_NAME;
}
string cjNum = j < 10 ? "0" + j.ToString() : j.ToString();
string cjcode = DeptCodeMap[cj.DEPT_NAME + "_" + cj.GWD_NAME + "_" + cj.XN_NAME] + cjNum;
if (oc.BllSession.ISYS_DEPTService.Entities.Where(u => u.DEPT_CODE == cjcode).Count() == 0)
{ //如果数据库无此部门编码则添加
list_SYS_DEPT.Add(new SYS_DEPT() //车间
{
DEPT_CODE = DeptCodeMap[cj.DEPT_NAME + "_" + cj.GWD_NAME + "_" + cj.XN_NAME] + cjNum,
DEPT_NAME = cj.CJ_NAME,
PARENT_CODE = DeptCodeMap[cj.DEPT_NAME + "_" + cj.GWD_NAME + "_" + cj.XN_NAME],
DEPT_ORDER = 0,
DEL_FLAG = "0",
STATUS_FLAG = "0",
C_ICO = "icon-DepartMent",
DEPT_FLAG = 0
});
}
DeptCodeMap.Add(cj.DEPT_NAME + "_" + cj.GWD_NAME + "_" + cj.XN_NAME + "_" + cj.CJ_NAME, DeptCodeMap[cj.DEPT_NAME + "_" + cj.GWD_NAME + "_" + cj.XN_NAME] + cjNum);
j++;
}
catch (Exception ex)
{
string a = cj.CJ_NAME;
throw ex;
}
}
}
//工区
List <VIEW_SYS_DEPT> listDEPT_GQ = list_VIEW_SYS_DEPT.Where(u => u.DEPT_NAME != "" && u.DEPT_CODE != "" && u.GWD_NAME != "" && u.GWD_CODE != "" && u.XN_NAME != "" && u.GQ_NAME != "" && u.CJ_NAME != "")
.OrderBy(u => u.CJ_NAME).GroupBy(u => new { u.DEPT_NAME, u.DEPT_CODE, u.GWD_NAME, u.GWD_CODE, u.XN_NAME, u.GQ_NAME, u.CJ_NAME })
.Select(g => new VIEW_SYS_DEPT {
DEPT_NAME = g.Key.DEPT_NAME, GWD_NAME = g.Key.GWD_NAME, XN_NAME = g.Key.XN_NAME, GQ_NAME = g.Key.GQ_NAME, CJ_NAME = g.Key.CJ_NAME
}).ToList();
if (listDEPT_GQ.Count > 0)
{
string cjname = "";
int m = 1;
foreach (VIEW_SYS_DEPT gq in listDEPT_GQ)
{
if (cjname != gq.CJ_NAME)//如果是新父级，则重新编号
{
m = 1;
cjname = gq.CJ_NAME;
}
string gqNum = m < 10 ? "0" + m.ToString() : m.ToString();
string gqcode = DeptCodeMap[gq.DEPT_NAME + "_" + gq.GWD_NAME + "_" + gq.XN_NAME + "_" + gq.CJ_NAME] + gqNum;
if (oc.BllSession.ISYS_DEPTService.Entities.Where(u => u.DEPT_CODE == gqcode).Count() == 0)
{ //如果数据库无此部门编码则添加
list_SYS_DEPT.Add(new SYS_DEPT() //车间
{
DEPT_CODE = DeptCodeMap[gq.DEPT_NAME + "_" + gq.GWD_NAME + "_" + gq.XN_NAME + "_" + gq.CJ_NAME] + gqNum,
DEPT_NAME = gq.GQ_NAME,
PARENT_CODE = DeptCodeMap[gq.DEPT_NAME + "_" + gq.GWD_NAME + "_" + gq.XN_NAME + "_" + gq.CJ_NAME],
DEPT_ORDER = 0,
DEL_FLAG = "0",
STATUS_FLAG = "0",
C_ICO = "icon-org",
DEPT_FLAG = 0
});
}
DeptCodeMap.Add(gq.DEPT_NAME + "_" + gq.GWD_NAME + "_" + gq.XN_NAME + "_" + gq.CJ_NAME + "_" + gq.GQ_NAME, DeptCodeMap[gq.DEPT_NAME + "_" + gq.GWD_NAME + "_" + gq.XN_NAME + "_" + gq.CJ_NAME] + gqNum);
m++;
}
}
//人员
List <VIEW_SYS_DEPT> listDEPT_RY = list_VIEW_SYS_DEPT.Where(u => u.NAME != null && u.MOBILE != null && u.NAME != "" && u.MOBILE != "").ToList();
int n = 0;
foreach (VIEW_SYS_DEPT member in listDEPT_RY)
{
if (oc.BllSession.ISYS_MEMBERService.Entities.Where(u => u.MOBILE == member.MOBILE).Count() == 0)
{ //如果数据库无此手机号则添加
list_SYS_MEMBER.Add(new SYS_MEMBER() //车间
{
MEMBER_ID = DateTime.Now.ToString("yyyyMMddHHmmssfff") + n.ToString(),
DEPT_CODE = DeptCodeMap[getCode(member)],
NAME = member.NAME,
MOBILE = member.MOBILE,
INTELLIGENCE = member.INTELLIGENCE == ""?"": MemberIntelligenceMap[member.INTELLIGENCE],
UPDATE_DATE = DateTime.Now,
UPDATE_USER = oc.CurrentUser.USER_NAME,
DEL_FLAG = "0",
LOCATION_FLAG = "1",
JOB = member.JOB
});
}
n++;
}
}
catch (Exception e)
{
amm.Msg = "解析错误或资质名称不匹配";
amm.Statu = AjaxStatu.err;
}
}
if (amm.Statu == AjaxStatu.err)//如果不存在
{
//amm.Data = errorList;
return(ObjToJson.GetToJson(amm, true));
}
//业务判断并插入数据库
int returnValue = 0;
using (TransactionScope ts = new TransactionScope())
{
returnValue = oc.BllSession.ISYS_DEPTService.AddListEntity(list_SYS_DEPT);
returnValue = returnValue + oc.BllSession.ISYS_MEMBERService.AddListEntity(list_SYS_MEMBER);
ts.Complete();
}
if (list_SYS_DEPT.Count == 0 && list_SYS_MEMBER.Count == 0)
{
returnValue = 1;
}
if (returnValue > 0)
{
amm.Statu = AjaxStatu.ok;
amm.Msg = "导入成功部门" + list_SYS_DEPT.Count + "-人员" + list_SYS_MEMBER.Count;
}
else
{
amm.Statu = AjaxStatu.err;
amm.Msg = "导入失败";
}
return(ObjToJson.GetToJson(amm, true));
#endregion
}
/********************************************************
* 获取签到信息
* date：查询日期 可以为null
* rate：出勤率，全勤1，非全勤0，所有null
* empName：员工姓名
* ******************************************************/
private void GetDetailList(HttpContext context)
{
string json = "";
//验证操作权限
string empID = UsrAuth.GetempID(context.Session);
string searchStartDate = context.Request["searchStartDate"];
string searchEndDate = context.Request["searchEndDate"];
string searchRate = context.Request["searchRate"];
string searchName = context.Request["searchName"];
//MODIFY
string isSelf = context.Request["isSelf"];
int searchEmpID = int.Parse(context.Request["searchEmpID"]);
FeedBackMsg <List <CheckInInfo> > feedBack = new FeedBackMsg <List <CheckInInfo> >();
if (string.IsNullOrEmpty(searchStartDate))
{
searchStartDate = null;
}
if (string.IsNullOrEmpty(searchRate))
{
searchRate = null;
}
if (string.IsNullOrEmpty(searchName))
{
searchName = null;
}
string depID = UsrAuth.GetdepID(context.Session);
string depName = UsrAuth.GetdepName(context.Session);
if (searchEmpID > 0)
{
List <CheckInInfo> checkInInfoList = CheckInInfoService.Instance.GetCheckInInfoList(searchEmpID.ToString(), searchStartDate, searchEndDate, searchRate);
feedBack.Code = 1;
feedBack.Msg = "员工签到信息";//获取某个员工记录
feedBack.Obj = checkInInfoList;
}
else
{
if (!string.IsNullOrEmpty(isSelf) && isSelf.Equals("1")) //获取登录人记录
{
List <CheckInInfo> checkInInfoList = CheckInInfoService.Instance.GetCheckInInfoList(empID, searchStartDate, searchEndDate, searchRate);
feedBack.Code = 1;
feedBack.Msg = "我的签到信息";
feedBack.Obj = checkInInfoList;
}
else
{
if (UsrAuth.IsAdminister(context.Session) || UsrAuth.IsTopManager(context.Session))
{
//总经理或者管理员
List <CheckInInfo> allCheckInInfoList = CheckInInfoService.Instance.GetCheckInInfoList(0, searchName, searchStartDate, searchEndDate, searchRate);
feedBack.Code = 1;
feedBack.Msg = "所有员工的签到信息";
feedBack.Obj = allCheckInInfoList;
}
else if (UsrAuth.IsDepManager(context.Session))
{
//部门经理
List <CheckInInfo> allCheckInInfoList = CheckInInfoService.Instance.GetCheckInInfoList(int.Parse(depID), searchName, searchStartDate, searchEndDate, searchRate);
feedBack.Code = 1;
feedBack.Msg = "部门" + depName + "员工列表";
feedBack.Obj = allCheckInInfoList;
}
else
{
feedBack.Code = 0;
feedBack.Msg = "无相应权限";
feedBack.Obj = null;
}
}
}
json = ObjToJson.ToJson(feedBack);
context.Response.Write(json);
}
//
// 摘要:
// 在过程请求授权时调用。
//
// 参数:
// filterContext:
// 筛选器上下文，它封装有关使用 System.Web.Mvc.AuthorizeAttribute 的信息。
//
// 异常:
// System.ArgumentNullException:
// filterContext 参数为 null。
public override void OnAuthorization(AuthorizationContext filterContext)
{
/**
* 如果请求的区域包含area并且area的名称等于SYSs
* 那么就进行权限验证
* */
if (filterContext.RouteData.DataTokens.Keys.Contains("area") &&
(filterContext.RouteData.DataTokens["area"].ToString().ToLower() == "sys" ||
filterContext.RouteData.DataTokens["area"].ToString().ToLower() == "gate" ||
filterContext.RouteData.DataTokens["area"].ToString().ToLower() == "gis" ||
filterContext.RouteData.DataTokens["area"].ToString().ToLower() == "job" ||
filterContext.RouteData.DataTokens["area"].ToString().ToLower() == "material" ||
filterContext.RouteData.DataTokens["area"].ToString().ToLower() == "rule" ||
filterContext.RouteData.DataTokens["area"].ToString().ToLower() == "scripts" ||
filterContext.RouteData.DataTokens["area"].ToString().ToLower() == "rain" ||
filterContext.RouteData.DataTokens["area"].ToString().ToLower() == "tool" ||
filterContext.RouteData.DataTokens["area"].ToString().ToLower() == "rail" ||
filterContext.RouteData.DataTokens["area"].ToString().ToLower() == "car" ||
filterContext.RouteData.DataTokens["area"].ToString().ToLower() == "repair"
))
{
///**
// * 验证用户是否登录
// * */
if (!Model_SYS_USER.IsLogin())
{ ///如果没有登录那么就跳转到登录页面
filterContext.Result = new BaseController().Redirect("/Home/Login?msg=noLogin", filterContext.ActionDescriptor, AjaxStatu.nologin);
}
else
{
if (!AuthorizeIs(filterContext.HttpContext))
{
filterContext.Result = new BaseController().Redirect("/Home/Login?msg=noLogin", filterContext.ActionDescriptor, AjaxStatu.none);
}
else
{
/**
* Action方法本身及它所属控制器都没有定义Skip特性
* 那么就可以进行权限验证
* */
if (!filterContext.ActionDescriptor.AttributeExists <Common.Attributes.SkipAttribute>(false) &&
!filterContext.ActionDescriptor.ControllerDescriptor.IsDefined(typeof(Common.Attributes.SkipAttribute), false))
{
//验证该登录用户是否有访问该页面的权限
string strAreaName = filterContext.RouteData.DataTokens["area"].ToString().ToLower();
string strControllerName = filterContext.ActionDescriptor.ControllerDescriptor.ControllerName.ToLower();
string strActionName = filterContext.ActionDescriptor.ActionName.ToLower();
if (strActionName == "index")
{
string[] url = filterContext.HttpContext.Request.FilePath.Split('/');
if (url.Length > 4)
{
for (int i = 4; i < url.Length; i++)
{
strActionName = strActionName + "/" + url[i];
}
}
}
string strHttpMethod = filterContext.HttpContext.Request.HttpMethod;
HttpMethod httpMethod = strHttpMethod.ToLower().Equals("get") ? HttpMethod.Get
: strHttpMethod.ToLower().Equals("post") ? HttpMethod.Post : HttpMethod.HEAD;
if (!Model_SYS_MENU.HasPermission(strAreaName, strControllerName, strActionName, httpMethod))
{
filterContext.Result = new BaseController().Redirect("/Home/Login?msg=noPermission", filterContext.ActionDescriptor, AjaxStatu.noperm);
}
else
{
if (strActionName.ToLower() == "list" && filterContext.HttpContext.Request["page"] != null && filterContext.HttpContext.Request["rows"] != null)
{
string pageIndex = filterContext.HttpContext.Request["page"].ToString();
string pageSize = filterContext.HttpContext.Request["rows"].ToString();
if (pageIndex == "0" && pageSize == "0")
{
filterContext.Result = ObjToJson.GetToJson(null, 0, true);
}
}
}
}
}
}
}
}
public ActionResult GetMyMenu(string id)
{
string strJson = "[]";
//if (Constant.GISMenuID.Split(',').Contains(id))
//{
// //如果是获取GIS二级菜单
// List<SYS_MENU> listMenu = oc.BllSession.ISYS_MENUService.Entities
// .Where(m => m.MENU_LEVEL != Constant.MyMenuLevel && m.PARENT_ID.StartsWith(id))
// .OrderBy(m => m.MENU_ORDER).ToList();// oc.BllSession.ISYS_MENUService.Entities.ToList();//.GetListByCondition<decimal?>(null, ma => ma.MENU_LEVEL).Select(mb => mb.ToPOCO()).ToList();
// if (listMenu.Count > 0)
// {
// List<EasyUITreeNode> listTreeNodes = SYS_MENU.ConvertTreeNodes(listMenu, id);
// strJson = ObjToJson.GetToJson(listTreeNodes).Replace("Checked", "checked");
// }
//}
//else
//{
//根据选择的一级菜单找对应模块默认打开的三级页面
string parID = id.Substring(0, 2);
SYS_MENU parMenu = oc.BllSession.ISYS_MENUService.Entities.Where(u => u.MENU_ID.Equals(parID)).FirstOrDefault();
string twoMenuID = string.Empty;
string threeMenuID = string.Empty;
try
{
if (!string.IsNullOrEmpty(parMenu.DEFMENU_ID))
{
twoMenuID = parMenu.DEFMENU_ID.Substring(0, 6);
threeMenuID = parMenu.DEFMENU_ID.Substring(0, 8);
}
}
catch
{
twoMenuID = string.Empty;
threeMenuID = string.Empty;
}
List <SYS_MENU> listMenu = oc.UserMenuPermission.Where(m => m.MENU_LEVEL != Constant.MyMenuLevel && m.PARENT_ID.StartsWith(id)).OrderBy(m => m.MENU_LEVEL)
.ThenBy(m => m.MENU_ORDER).ToList();// oc.BllSession.ISYS_MENUService.Entities.ToList();//.GetListByCondition<decimal?>(null, ma => ma.MENU_LEVEL).Select(mb => mb.ToPOCO()).ToList();
if (listMenu.Count > 0)
{
if (string.IsNullOrEmpty(twoMenuID))
{
SYS_MENU firstThreeMenu = listMenu.Where(u => u.MENU_LEVEL == 3).FirstOrDefault();
if (firstThreeMenu != null)
{
twoMenuID = firstThreeMenu.MENU_ID.Substring(0, 6);
threeMenuID = firstThreeMenu.MENU_ID;
}
}
List <EasyUITreeNode> listTreeNodes = SYS_MENU.ConvertTreeNodes(listMenu, id);
foreach (EasyUITreeNode node in listTreeNodes)
{
if (node.id.Equals(twoMenuID))
{
node.isdefuopen = "Y";
}
else
{
node.isdefuopen = "N";
}
foreach (EasyUITreeNode Childnode in node.children)
{
if (Childnode.id.Equals(threeMenuID))
{
Childnode.isdefuopen = "Y";
}
else
{
Childnode.isdefuopen = "N";
}
}
}
strJson = ObjToJson.GetToJson(listTreeNodes).Replace("Checked", "checked");
}
//}
return(Content(strJson));
}
public static string GetPosLevelCheckedTree(string DEPT_CODE, string PARENT_CODE, bool isCheckAll)
{
string strJson = string.Empty;
List <SYS_DEPTANDMEMBER_TEMP> listOrgRy = new List <SYS_DEPTANDMEMBER_TEMP>();
//获取人员
List <SYS_MEMBER> listRyMenu = oc.BllSession.ISYS_MEMBERService.GetListByCondition <string>(m => m.DEL_FLAG == "0" &&
m.LOCATION_FLAG == "1" && m.DEPT_CODE.StartsWith(DEPT_CODE), m => m.MOBILE)
.Select(mb => mb.ToPOCO()).ToList();
//级别
List <SYS_POSLEVEL_DIC> PosLevellist = oc.BllSession.ISYS_POSLEVEL_DICService.Entities.OrderBy(u => u.DIC_ORDER).ToList();
if (listRyMenu.Count > 0)
{
foreach (SYS_MEMBER ry in listRyMenu)
{
string icon = "icon-Off-line";
if (ry.MOBILE_STATE == "1")
{
icon = "icon-status_busy";
}
listOrgRy.Add(new SYS_DEPTANDMEMBER_TEMP()
{
ORGRY_CODE = ry.MOBILE,
PARENT_CODE = (ry.DEPT_CODE.Length >= 4 ? ry.DEPT_CODE.Substring(0, 4) : ry.DEPT_CODE) +
(!PosLevellist.Select(u => u.DIC_ID).Contains(ry.POS_LEVEL) ? "1A" : ry.POS_LEVEL), //如果没有归类(空或者在字典表不存在)，则默认到其他
ORGRY_NAME = ry.NAME,
ICO = icon,
RYMOBILE = ry.MOBILE,
STATE = "0"//关闭
});
}
}
//获取资质
List <SYS_DEPTANDMEMBER_TEMP> listTemp = new List <SYS_DEPTANDMEMBER_TEMP>();
List <string> parList = listOrgRy.Select(u => u.PARENT_CODE).Distinct().ToList();
if (PosLevellist.Count > 0)
{
foreach (string parcode in parList)
{
string deptcode = parcode.Substring(0, parcode.Length - 2);
string diccode = parcode.Substring(parcode.Length - 2);
if (PosLevellist.Where(u => u.DIC_ID.Equals(diccode)).Count() > 0)
{
SYS_POSLEVEL_DIC dic = PosLevellist.Where(u => u.DIC_ID.Equals(diccode)).FirstOrDefault();
listTemp.Add(new SYS_DEPTANDMEMBER_TEMP()
{
ORGRY_CODE = parcode,
PARENT_CODE = deptcode,
ORGRY_NAME = dic.DIC_NAME,
ICO = dic.DIC_ICON,
ORDER = dic.DIC_ORDER,
RYMOBILE = string.Empty, //parcode,
STATE = "0" //关闭
});
}
}
}
listOrgRy.AddRange(listTemp.OrderBy(u => u.ORDER));
//获得组织
List <SYS_DEPT> listMenu = oc.BllSession.ISYS_DEPTService.Entities.Where(m => m.DEL_FLAG == "0" &&
(m.PARENT_CODE.StartsWith(DEPT_CODE) || m.DEPT_CODE == DEPT_CODE) &&
m.DEPT_CODE.Length <= 4)
.OrderBy(m => m.DEPT_ORDER).ThenBy(m => m.DEPT_CODE).ToList();
if (listMenu.Count > 0)
{
foreach (SYS_DEPT org in listMenu)
{
listOrgRy.Add(new SYS_DEPTANDMEMBER_TEMP()
{
ORGRY_CODE = org.DEPT_CODE,
PARENT_CODE = org.PARENT_CODE,
ORGRY_NAME = org.DEPT_NAME,
ICO = org.C_ICO,
RYMOBILE = "",
STATE = org.STATUS_FLAG//0关闭
});
}
}
List <ZTreeNode> listTreeNodes = SYS_DEPTANDMEMBER_TEMP.ConvertZTreeNodes(listOrgRy, PARENT_CODE, DEPT_CODE, isCheckAll);
strJson = ObjToJson.GetToJson(listTreeNodes).Replace("Checked", "checked");
return(strJson);
}
