public ActionResult CHECK_INFO() { token = appClass.CRM_Gettoken(); Session["location"] = 209; Sonluk.UI.Model.S5.SY_CHECKPOINTService.FIVES_SY_CHECKPOINT checkpointModel = new Sonluk.UI.Model.S5.SY_CHECKPOINTService.FIVES_SY_CHECKPOINT(); Sonluk.UI.Model.S5.SY_CHECKPOINTService.FIVES_SY_CHECKPOINT[] checkpointRes = fivesmodels.SY_CHECKPOINT.Read(checkpointModel, token); ViewBag.CheckPointArr = checkpointRes; HR_SY_DEPT deptModel = new HR_SY_DEPT(); HR_SY_DEPT_SELECT deptRes = hrmodels.SY_DEPT.SELECT(deptModel, token); ViewBag.DeptArr = deptRes.HR_SY_DEPT_LIST; FIVES_SY_DICT JCLXmodel = new FIVES_SY_DICT(); JCLXmodel.TYPEID = 2; FIVES_SY_DICT[] JCLXRes = fivesmodels.SY_DICT.Read(JCLXmodel, token); ViewBag.JCLXArr = JCLXRes; string datastring = "{\"DEPID\":\"0\",\"STAFFNAME\":\"\",\"STAFFNO\":\"\"}"; MES_SY_STAFF model = Newtonsoft.Json.JsonConvert.DeserializeObject <MES_SY_STAFF>(datastring); MES_SY_STAFF_SELECT rst_MES_SY_STAFF_SELECT = mesModels.SY_STAFF.SELECT(model, token); ViewBag.STAFFArr = rst_MES_SY_STAFF_SELECT.MES_SY_STAFF; JCLXmodel.TYPEID = 1; ViewBag.DFArr = fivesmodels.SY_DICT.Read(JCLXmodel, token); return(View()); }
public string SELECT_DEPT_RYCOUNT(int DEPTID) { string token = AppClass.GetSession("token").ToString(); HR_SY_DEPT_SELECT rst = hrmodels.SY_DEPT.SELECT_RYCOUNT(DEPTID, token); return(Newtonsoft.Json.JsonConvert.SerializeObject(rst)); }
public ActionResult STAFF_DEP_ACCESS() { token = appClass.CRM_Gettoken(); Session["location"] = 216; MODEK_StaffManage model = new MODEK_StaffManage(); HR_SY_DEPT_SELECT res = hrmodels.SY_DEPT.SELECT(new HR_SY_DEPT(), token); if (res.MES_RETURN.TYPE == "S") { } ViewData.Model = res; FIVES_SY_DICT cxmodel = new FIVES_SY_DICT(); FIVES_SY_TYPE TYPEmodel2 = new FIVES_SY_TYPE(); TYPEmodel2.TYPENAME = "检查类型"; FIVES_SY_TYPE[] TYPEDATA2 = fivesmodels.SY_TYPE.Read(TYPEmodel2, token); cxmodel.TYPEID = TYPEDATA2[0].TYPEID; FIVES_SY_DICT[] JCRES = fivesmodels.SY_DICT.Read(cxmodel, token); List <FIVES_SY_DICT> JCLIST = JCRES.ToList(); FIVES_SY_DICT CXMODEL2 = new FIVES_SY_DICT(); CXMODEL2.DICNAME = "通知"; FIVES_SY_DICT[] JCRES2 = fivesmodels.SY_DICT.Read(CXMODEL2, token); JCLIST.Add(JCRES2[0]); FIVES_SY_DICT[] JCRESULT = JCLIST.ToArray(); ViewBag.JCRESULT = JCRESULT; return(View()); }
public string DEPT_SELECT(string datastring) { string token = AppClass.GetSession("token").ToString(); HR_SY_DEPT model_HR_SY_DEPT = new HR_SY_DEPT(); HR_SY_DEPT_SELECT rst = hrmodels.SY_DEPT.SELECT(model_HR_SY_DEPT, token); return(Newtonsoft.Json.JsonConvert.SerializeObject(rst)); }
public string EXPOST_DEPT() { string token = AppClass.GetSession("token").ToString(); HR_SY_DEPT model_HR_SY_DEPT = new HR_SY_DEPT(); HR_SY_DEPT_SELECT model_rst = hrmodels.SY_DEPT.SELECT(model_HR_SY_DEPT, token); MES_RETURN_UI rst = new MES_RETURN_UI(); try { FileStream file = new FileStream(Server.MapPath("~") + @"/Areas/HR/ExportFile/部门导出.xlsx", FileMode.Open, FileAccess.Read); IWorkbook workbook = new XSSFWorkbook(file); ISheet sheet = workbook.GetSheetAt(0); int rowcount = 1; List <HR_SY_DEPT_LIST> alldata = new List <HR_SY_DEPT_LIST>(); for (int i = 0; i < model_rst.HR_SY_DEPT_LIST.Length; i++) { if (model_rst.HR_SY_DEPT_LIST[i].FID != 0) { alldata.Add(model_rst.HR_SY_DEPT_LIST[i]); } } for (int i = 0; i < alldata.Count; i++) { int cellIndex = 0; IRow row = sheet.CreateRow(rowcount++); row.CreateCell(cellIndex++).SetCellValue(Convert.ToString(alldata[i].GS)); row.CreateCell(cellIndex++).SetCellValue(Convert.ToString(alldata[i].GSNAME)); row.CreateCell(cellIndex++).SetCellValue(Convert.ToString(alldata[i].DEPTNAME)); row.CreateCell(cellIndex++).SetCellValue(Convert.ToString(alldata[i].DEPTBZRS)); row.CreateCell(cellIndex++).SetCellValue(Convert.ToString(alldata[i].DEPTBMLBNAME)); row.CreateCell(cellIndex++).SetCellValue(Convert.ToString(alldata[i].DEPTFZRNAME)); row.CreateCell(cellIndex++).SetCellValue(Convert.ToString(alldata[i].DEPTNO)); row.CreateCell(cellIndex++).SetCellValue(Convert.ToString(alldata[i].DEPTCBZX)); if (alldata[i].ISACTION == 1) { row.CreateCell(cellIndex++).SetCellValue("启用"); } else { row.CreateCell(cellIndex++).SetCellValue("关闭"); } row.CreateCell(cellIndex++).SetCellValue(Convert.ToString(alldata[i].FDEPTNAME)); } string now = DateTime.Now.ToString("yyyyMMddHHmmss.fff"); FileStream file1 = new FileStream(string.Format(@"{0}/Areas/HR/ExportFile/{1}.xlsx", Server.MapPath("~"), now), FileMode.Create); workbook.Write(file1); file1.Close(); rst.TYPE = "S"; rst.MESSAGE = now; } catch { rst.TYPE = "E"; rst.MESSAGE = "生成文件失败!"; } return(Newtonsoft.Json.JsonConvert.SerializeObject(rst)); }
public string DEPT_SELECT() { token = appClass.CRM_Gettoken(); //HR_SY_DEPT model = Newtonsoft.Json.JsonConvert.DeserializeObject<HR_SY_DEPT>(data); HR_SY_DEPT model = new HR_SY_DEPT(); HR_SY_DEPT_SELECT res = hrmodels.SY_DEPT.SELECT(model, token); return(Newtonsoft.Json.JsonConvert.SerializeObject(res)); }
public string SELECT_BY_ROLE_LD(string datastring) { string token = AppClass.GetSession("token").ToString(); int STAFFID = Convert.ToInt32(AppClass.GetSession("STAFFID")); HR_SY_DEPT model_HR_SY_DEPT = Newtonsoft.Json.JsonConvert.DeserializeObject <HR_SY_DEPT>(datastring); model_HR_SY_DEPT.STAFFID = STAFFID; HR_SY_DEPT_SELECT rst = hrmodels.SY_DEPT.SELECT_BY_ROLE_LD(model_HR_SY_DEPT, token); return(Newtonsoft.Json.JsonConvert.SerializeObject(rst)); }
public string EXPOST_BZKHREPORT(string datastring, int LB) { MES_RETURN_UI rst = new MES_RETURN_UI(); string token = AppClass.GetSession("token").ToString(); int STAFFID = Convert.ToInt32(AppClass.GetSession("STAFFID")); HR_SY_DEPT model_HR_SY_DEPT = new HR_SY_DEPT(); model_HR_SY_DEPT.STAFFID = STAFFID; HR_SY_DEPT_SELECT result = hrmodels.SY_DEPT.SELECT_LB(model_HR_SY_DEPT, LB, token); if (result.MES_RETURN.TYPE == "E") { return(Newtonsoft.Json.JsonConvert.SerializeObject(result.MES_RETURN)); } try { FileStream file = new FileStream(Server.MapPath("~") + @"/Areas/HR/ExportFile/导出模版.xlsx", FileMode.Open, FileAccess.Read); IWorkbook workbook = new XSSFWorkbook(file); ISheet sheet = workbook.GetSheetAt(0); int rowcount = 0; string tt = "公司,部门,编制人数,"; string[] ttlist = tt.Split(','); IRow rowtt = sheet.CreateRow(rowcount++); int cellIndex = 0; for (int a = 0; a < ttlist.Length; a++) { rowtt.CreateCell(cellIndex++).SetCellValue(ttlist[a]); } DataTable dtinfo = result.DATALIST; for (int i = 0; i < dtinfo.Rows.Count; i++) { cellIndex = 0; IRow row = sheet.CreateRow(rowcount++); row.CreateCell(cellIndex++).SetCellValue(dtinfo.Rows[i]["GSNAME"].ToString()); row.CreateCell(cellIndex++).SetCellValue(dtinfo.Rows[i]["DEPTNAME"].ToString()); row.CreateCell(cellIndex++).SetCellValue(Convert.ToInt32(dtinfo.Rows[i]["DEPTBZRS"].ToString())); row.CreateCell(cellIndex++).SetCellValue(Convert.ToInt32(dtinfo.Rows[i]["GSBMRYCOUNT"].ToString())); } string now = DateTime.Now.ToString("yyyyMMddHHmmss.fff"); FileStream file1 = new FileStream(string.Format(@"{0}/Areas/HR/ExportFile/{1}.xlsx", Server.MapPath("~"), now), FileMode.Create); workbook.Write(file1); file1.Close(); rst.TYPE = "S"; rst.MESSAGE = now; } catch { rst.TYPE = "E"; rst.MESSAGE = "生成文件失败!"; } return(Newtonsoft.Json.JsonConvert.SerializeObject(rst)); }
public ActionResult STAFF_DEP() { token = appClass.CRM_Gettoken(); Session["location"] = 208; MODEK_StaffManage model = new MODEK_StaffManage(); CRM_HG_DEPT[] rst_CRM_HG_DEPT = crmModels.HG_DEPT.Read(token); HR_SY_DEPT_SELECT res = hrmodels.SY_DEPT.SELECT(new HR_SY_DEPT(), token); AppClass.SetSession("five_dep", res); model.CRM_HG_DEPT = rst_CRM_HG_DEPT; ViewData.Model = model; return(View()); }
public ActionResult CheckPoint() { Session["location"] = 206; token = appClass.CRM_Gettoken(); HR_SY_DEPT_SELECT r = hrmodels.SY_DEPT.SELECT(new HR_SY_DEPT(), token); ViewBag.DEPList = r; FIVES_SY_DICT model = new FIVES_SY_DICT(); FIVES_SY_TYPE TYPEmodel = new FIVES_SY_TYPE(); TYPEmodel.TYPENAME = "检查频率"; FIVES_SY_TYPE[] TYPEDATA = fivesmodels.SY_TYPE.Read(TYPEmodel, token); model.TYPEID = TYPEDATA[0].TYPEID; FIVES_SY_DICT[] RES = fivesmodels.SY_DICT.Read(model, token); ViewBag.RES = RES; FIVES_SY_DICT cxmodel = new FIVES_SY_DICT(); FIVES_SY_TYPE TYPEmodel2 = new FIVES_SY_TYPE(); TYPEmodel2.TYPENAME = "检查类型"; FIVES_SY_TYPE[] TYPEDATA2 = fivesmodels.SY_TYPE.Read(TYPEmodel2, token); model.TYPEID = TYPEDATA2[0].TYPEID; FIVES_SY_DICT[] JCRES = fivesmodels.SY_DICT.Read(model, token); List <FIVES_SY_DICT> ListJcres = JCRES.ToList(); for (int i = JCRES.Length - 1; i >= 0; i--) { if (JCRES[i].DICNAME == "抽检") { ListJcres[i].DICID = 0; } if (JCRES[i].DICNAME == "巡检") { ListJcres[i].DICID = 0; } } FIVES_SY_DICT[] JCRES_set = ListJcres.ToArray(); ViewBag.JCRES = JCRES_set; return(View()); }
public string SY_DEPT_SELECT() { HR_SY_DEPT_SELECT res = (HR_SY_DEPT_SELECT)AppClass.GetSession("five_dep"); return(Newtonsoft.Json.JsonConvert.SerializeObject(res)); }