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 DEPT_DELETE(string datastring) { string token = AppClass.GetSession("token").ToString(); HR_SY_DEPT model_HR_SY_DEPT = Newtonsoft.Json.JsonConvert.DeserializeObject <HR_SY_DEPT>(datastring); MES_RETURN_UI rst = hrmodels.SY_DEPT.DELETE(model_HR_SY_DEPT, token); return(Newtonsoft.Json.JsonConvert.SerializeObject(rst)); }
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 MES_RETURN_UI DELETE(HR_SY_DEPT model, string ptoken) { MES_RETURN mr = client.DELETE(model, ptoken); MES_RETURN_UI mrui = new MES_RETURN_UI(); mrui.TYPE = mr.TYPE; mrui.MESSAGE = mr.MESSAGE; return(mrui); }
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 DEPT_UPDATE(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.XGR = STAFFID; MES_RETURN_UI rst = hrmodels.SY_DEPT.UPDATE(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 HR_SY_DEPT_SELECT SELECT_BY_ROLE_LD(HR_SY_DEPT model, string ptoken) { return(client.SELECT_BY_ROLE_LD(model, ptoken)); }
public HR_SY_DEPT_SELECT SELECT_BY_ROLE(HR_SY_DEPT model, int LB, string ptoken) { return(client.SELECT_BY_ROLE(model, LB, ptoken)); }
public HR_SY_DEPT_SELECT SELECT(HR_SY_DEPT model, string ptoken) { return(client.SELECT(model, ptoken)); }