public string UPDATE_SHOWTIME_part(string TIME, string data) { token = appClass.CRM_Gettoken(); FIVES_CHECK_INFO model = Newtonsoft.Json.JsonConvert.DeserializeObject <FIVES_CHECK_INFO>(data); FIVES_CHECK_INFOList CXmodel = new FIVES_CHECK_INFOList(); CXmodel.OPINTID = model.OPINTID; CXmodel.DEPARTID = model.DEPARTID; CXmodel.TYPEID = model.TYPEID; FIVES_CHECK_INFOList[] CXdata = fivesmodels.CHECK_INFO.Read(CXmodel, token); string temp = TIME.Substring(0, 10); var query = (from c in CXdata where c.SHOWTIME.Substring(0, 10) == temp select c).ToList(); if (query.Count > 0) { MES_RETURN_UI CXRES = new MES_RETURN_UI(); CXRES.TYPE = "E"; CXRES.MESSAGE = TIME.Substring(0, 10) + "已经有点检记录,不允许修改"; return(Newtonsoft.Json.JsonConvert.SerializeObject(CXRES)); } model.SHOWTIME = TIME; MES_RETURN_UI RES = fivesmodels.CHECK_INFO.Update(model, token); if (RES.TYPE == "S") { RES.MESSAGE = "修改成功"; } return(Newtonsoft.Json.JsonConvert.SerializeObject(RES)); }
public string CheckInfo_Select(string data, string KSTIME, string JSTIME) { token = appClass.CRM_Gettoken(); FIVES_CHECK_INFOList model = Newtonsoft.Json.JsonConvert.DeserializeObject <FIVES_CHECK_INFOList>(data); FIVES_CHECK_INFOList[] rst = fivesmodels.CHECK_INFO.Read(model, token); return(Newtonsoft.Json.JsonConvert.SerializeObject(rst)); }
public string UPDATE_SHOWTIME(string TIME, string data) { token = appClass.CRM_Gettoken(); FIVES_CHECK_INFO[] model = Newtonsoft.Json.JsonConvert.DeserializeObject <FIVES_CHECK_INFO[]>(data); for (int i = 0; i < model.Length; i++) { FIVES_CHECK_INFOList CXmodel = new FIVES_CHECK_INFOList(); CXmodel.OPINTID = model[i].OPINTID; CXmodel.DEPARTID = model[i].DEPARTID; CXmodel.TYPEID = model[i].TYPEID; FIVES_CHECK_INFOList[] CXdata = fivesmodels.CHECK_INFO.Read(CXmodel, token); string temp = TIME.Substring(0, 10); // var query = (from c in CXdata where c.SHOWTIME.Substring(0, 10) == temp select c).ToList(); List <FIVES_CHECK_INFOList> query = new List <FIVES_CHECK_INFOList>(from c in CXdata where c.SHOWTIME.Substring(0, 10) == temp select c); if (query.Count > 0) { //MES_RETURN_UI CXRES = new MES_RETURN_UI(); //CXRES.TYPE = "E"; //CXRES.MESSAGE = query[0].OPINTMS + TIME.Substring(0, 10) + "已经有点检记录,不允许修改"; //return Newtonsoft.Json.JsonConvert.SerializeObject(CXRES); webmsg.KEY = 0; webmsg.MSG = query[0].OPINTMS + TIME.Substring(0, 10) + "已经有点检记录,不允许修改";; return(Newtonsoft.Json.JsonConvert.SerializeObject(webmsg)); } } int Temp_Minutes = 0, Temp_Seconds = 0; for (int i = 0; i < model.Length; i++) { if (i == 0) { model[i].SHOWTIME = TIME; } else { Temp_Minutes = Temp_Minutes + new Random().Next(3, 6); Temp_Seconds = new Random().Next(0, 59); model[i].SHOWTIME = Convert.ToDateTime(TIME).AddMinutes(Temp_Minutes).AddSeconds(Temp_Seconds).ToString();//随机时间 } // model[i].SHOWTIME = TIME; MES_RETURN_UI RES = fivesmodels.CHECK_INFO.Update(model[i], token); if (RES.TYPE != "S") { webmsg.KEY = 0; webmsg.MSG = "修改失败!"; return(Newtonsoft.Json.JsonConvert.SerializeObject(webmsg)); } } webmsg.KEY = 1; webmsg.MSG = "修改成功!"; return(Newtonsoft.Json.JsonConvert.SerializeObject(webmsg)); }
public string CheckInfo_Head(string data) { token = appClass.CRM_Gettoken(); FIVES_CHECK_INFOList model = Newtonsoft.Json.JsonConvert.DeserializeObject <FIVES_CHECK_INFOList>(data); //FIVES_CHECK_INFOList model = new FIVES_CHECK_INFOList(); try { FIVES_CHECK_INFOList[] rst = fivesmodels.CHECK_INFO.Read(model, token); return(Newtonsoft.Json.JsonConvert.SerializeObject(rst)); } catch (Exception e) { return(e.Message); } }
public string EXPORT_CHeck_SELECT(string data, int type, string KSTIME, string JSTIME) { int STAFFID = Convert.ToInt32(AppClass.GetSession("STAFFID")); MES_RETURN_UI rst = new MES_RETURN_UI(); token = appClass.CRM_Gettoken(); try { if (type == 1) { #region checkinfo FIVES_CHECK_INFOList model = Newtonsoft.Json.JsonConvert.DeserializeObject <FIVES_CHECK_INFOList>(data); // model.HG = 1; //FIVES_CHECK_INFOList model = new FIVES_CHECK_INFOList(); FIVES_CHECK_INFOList[] checkinfolist = fivesmodels.CHECK_INFO.Read(model, token); FileStream file = new FileStream(Server.MapPath("~") + @"/Areas/FIVES/ExcelTemplate/5S不合格点检报表导出.xlsx", FileMode.Open, FileAccess.Read); IWorkbook workbook = new XSSFWorkbook(file); ISheet sheet = workbook.GetSheetAt(0); int rowcount = 1; for (int i = 0; i < checkinfolist.Length; i++) { int cellIndex = 0; IRow row = sheet.CreateRow(rowcount++); row.CreateCell(cellIndex++).SetCellValue(checkinfolist[i].OPINTMS); row.CreateCell(cellIndex++).SetCellValue(checkinfolist[i].DEPARTMS); row.CreateCell(cellIndex++).SetCellValue(checkinfolist[i].SHOWNAMEMS); if (checkinfolist[i].HG == 0) { row.CreateCell(cellIndex++).SetCellValue("合格"); } else if (checkinfolist[i].HG == 1) { row.CreateCell(cellIndex++).SetCellValue("不合格"); } row.CreateCell(cellIndex++).SetCellValue(checkinfolist[i].SHOWTIME); row.CreateCell(cellIndex++).SetCellValue(checkinfolist[i].REMARK); row.CreateCell(cellIndex++).SetCellValue(checkinfolist[i].POSITION); } //获取当前列的宽度,然后对比本列的长度,取最大值 for (int columnNum = 0; columnNum <= checkinfolist.Length; columnNum++) { int columnWidth = sheet.GetColumnWidth(columnNum) / 256; for (int rowNum = 1; rowNum <= sheet.LastRowNum; rowNum++) { IRow currentRow; //当前行未被使用过 if (sheet.GetRow(rowNum) == null) { currentRow = sheet.CreateRow(rowNum); } else { currentRow = sheet.GetRow(rowNum); } if (currentRow.GetCell(columnNum) != null) { ICell currentCell = currentRow.GetCell(columnNum); int length = Encoding.Default.GetBytes(currentCell.ToString()).Length; if (columnWidth < length) { columnWidth = length; } } } sheet.SetColumnWidth(columnNum, columnWidth * 256); } string now = DateTime.Now.ToString("yyyyMMddHHmmss.fff"); FileStream file1 = new FileStream(string.Format(@"{0}/Areas/FIVES/ExcelTemplate/{1}.xlsx", Server.MapPath("~"), now + STAFFID + "13"), FileMode.Create); workbook.Write(file1); file1.Close(); rst.TYPE = "S"; rst.MESSAGE = now + STAFFID + "13"; #endregion } else if (type == 2) { #region checkinfomx FIVES_CHECK_INFOList model = Newtonsoft.Json.JsonConvert.DeserializeObject <FIVES_CHECK_INFOList>(data); // model.HG = 1; //FIVES_CHECK_INFOList model = new FIVES_CHECK_INFOList(); FIVES_CHECK_INFOList[] checkinfolist = fivesmodels.CHECK_INFO.Read(model, token); List <FIVES_CHECK_INFODETAILList> checkinfomxlist = new List <FIVES_CHECK_INFODETAILList>(); for (int i = 0; i < checkinfolist.Length; i++) { FIVES_CHECK_INFODETAIL mxmodel = new FIVES_CHECK_INFODETAIL(); mxmodel.INFOID = checkinfolist[i].INFOID; checkinfomxlist.AddRange(fivesmodels.CHECK_INFODETAIL.Read(mxmodel, token)); } FileStream file = new FileStream(Server.MapPath("~") + @"/Areas/FIVES/ExcelTemplate/5S不合格点检报表明细导出.xlsx", FileMode.Open, FileAccess.Read); IWorkbook workbook = new XSSFWorkbook(file); ISheet sheet = workbook.GetSheetAt(0); int rowcount = 1; for (int i = 0; i < checkinfomxlist.Count; i++) { int cellIndex = 0; IRow row = sheet.CreateRow(rowcount++); FIVES_CHECK_INFOList checkinfo = checkinfolist.Where(p => p.INFOID == checkinfomxlist[i].INFOID).ToList()[0]; row.CreateCell(cellIndex++).SetCellValue(checkinfo.OPINTMS); row.CreateCell(cellIndex++).SetCellValue(checkinfo.DEPARTMS); row.CreateCell(cellIndex++).SetCellValue(checkinfo.SHOWNAMEMS); row.CreateCell(cellIndex++).SetCellValue(checkinfo.SHOWTIME); row.CreateCell(cellIndex++).SetCellValue(checkinfo.REMARK); row.CreateCell(cellIndex++).SetCellValue(checkinfomxlist[i].TYPEMS); row.CreateCell(cellIndex++).SetCellValue(checkinfomxlist[i].REMARK); } //获取当前列的宽度,然后对比本列的长度,取最大值 for (int columnNum = 0; columnNum <= checkinfolist.Length; columnNum++) { int columnWidth = sheet.GetColumnWidth(columnNum) / 256; for (int rowNum = 1; rowNum <= sheet.LastRowNum; rowNum++) { IRow currentRow; //当前行未被使用过 if (sheet.GetRow(rowNum) == null) { currentRow = sheet.CreateRow(rowNum); } else { currentRow = sheet.GetRow(rowNum); } if (currentRow.GetCell(columnNum) != null) { ICell currentCell = currentRow.GetCell(columnNum); int length = Encoding.Default.GetBytes(currentCell.ToString()).Length; if (columnWidth < length) { columnWidth = length; } } } sheet.SetColumnWidth(columnNum, columnWidth * 256); } string now = DateTime.Now.ToString("yyyyMMddHHmmss.fff"); FileStream file1 = new FileStream(string.Format(@"{0}/Areas/FIVES/ExcelTemplate/{1}.xlsx", Server.MapPath("~"), now + STAFFID + "13"), FileMode.Create); workbook.Write(file1); file1.Close(); rst.TYPE = "S"; rst.MESSAGE = now + STAFFID + "13"; #endregion } else if (type == 3) { FIVES_CHECK_INFOList model = Newtonsoft.Json.JsonConvert.DeserializeObject <FIVES_CHECK_INFOList>(data); //FIVES_CHECK_INFOList model = new FIVES_CHECK_INFOList(); FIVES_CHECK_INFOList[] hzarr = fivesmodels.CHECK_INFO.Read_HZINFO(model, token); FileStream file = new FileStream(Server.MapPath("~") + @"/Areas/FIVES/ExcelTemplate/点检汇总导出.xlsx", FileMode.Open, FileAccess.Read); IWorkbook workbook = new XSSFWorkbook(file); ISheet sheet = workbook.GetSheetAt(0); ISheet sheet1 = workbook.GetSheetAt(1); ISheet sheet2 = workbook.GetSheetAt(2); int rowcount = 1; int rowsecond = 1; int rowsthird = 1; // FIVES_CHECK_INFOList[] TTdata = new FIVES_CHECK_INFOList[]; for (int i = 0; i < hzarr.Length; i++) { int Index = 0; IRow row = sheet.CreateRow(rowcount++); row.CreateCell(Index++).SetCellValue(hzarr[i].OPINTMS); row.CreateCell(Index++).SetCellValue(hzarr[i].DEPARTMS); row.CreateCell(Index++).SetCellValue(hzarr[i].FREQUENCYNAME); row.CreateCell(Index++).SetCellValue(hzarr[i].CHECKCOUNT); row.CreateCell(Index++).SetCellValue(hzarr[i].BHGCOUNT); decimal d = hzarr[i].BHGCOUNT == 0 ? 100.0M : Math.Round(100 - (decimal)(hzarr[i].BHGCOUNT * 100) / hzarr[i].CHECKCOUNT, 1); row.CreateCell(Index++).SetCellValue(d.ToString("##.0") + "%"); FIVES_CHECK_INFOList TTmodel = new FIVES_CHECK_INFOList(); TTmodel.OPINTID = hzarr[i].OPINTID; TTmodel.KSTIME = KSTIME; TTmodel.JSTIME = JSTIME; TTmodel.HG = 2; TTmodel.ISDELETE = true; FIVES_CHECK_INFOList[] TTdata = fivesmodels.CHECK_INFO.Read(TTmodel, token); for (int x = 0; x < TTdata.Length; x++) { string str = ""; int cellIndex = 0; IRow second = sheet1.CreateRow(rowsecond++); second.CreateCell(cellIndex++).SetCellValue(TTdata[x].OPINTMS); second.CreateCell(cellIndex++).SetCellValue(TTdata[x].DEPARTMS); if (TTdata[x].HG == 1) { str = "不合格"; } else { str = "合格"; } second.CreateCell(cellIndex++).SetCellValue(str); second.CreateCell(cellIndex++).SetCellValue(TTdata[x].SHOWNAMEMS); second.CreateCell(cellIndex++).SetCellValue(TTdata[x].SHOWTIME); second.CreateCell(cellIndex++).SetCellValue(TTdata[x].REMARK); FIVES_CHECK_INFODETAIL MXmodel = new FIVES_CHECK_INFODETAIL(); MXmodel.INFOID = TTdata[x].INFOID; FIVES_CHECK_INFODETAILList[] MXdata = fivesmodels.CHECK_INFODETAIL.Read(MXmodel, token); for (int j = 0; j < MXdata.Length; j++) { int cellIthird = 0; IRow third = sheet2.CreateRow(rowsthird++); third.CreateCell(cellIthird++).SetCellValue(TTdata[x].OPINTMS); third.CreateCell(cellIthird++).SetCellValue(TTdata[x].DEPARTMS); third.CreateCell(cellIthird++).SetCellValue(TTdata[x].SHOWNAMEMS); third.CreateCell(cellIthird++).SetCellValue(TTdata[x].SHOWTIME); third.CreateCell(cellIthird++).SetCellValue(MXdata[j].TYPEMS); third.CreateCell(cellIthird++).SetCellValue(MXdata[j].REMARK); } } for (int columnNum = 0; columnNum <= TTdata.Length; columnNum++) { int columnWidth = sheet1.GetColumnWidth(columnNum) / 256; for (int rowNum = 1; rowNum <= sheet.LastRowNum; rowNum++) { IRow currentRow; //当前行未被使用过 if (sheet1.GetRow(rowNum) == null) { currentRow = sheet1.CreateRow(rowNum); } else { currentRow = sheet1.GetRow(rowNum); } if (currentRow.GetCell(columnNum) != null) { ICell currentCell = currentRow.GetCell(columnNum); int length = Encoding.Default.GetBytes(currentCell.ToString()).Length; if (columnWidth < length) { columnWidth = length; } } } sheet.SetColumnWidth(columnNum, columnWidth * 256); } } //获取当前列的宽度,然后对比本列的长度,取最大值 for (int columnNum = 0; columnNum <= hzarr.Length; columnNum++) { int columnWidth = sheet.GetColumnWidth(columnNum) / 256; for (int rowNum = 1; rowNum <= sheet.LastRowNum; rowNum++) { IRow currentRow; //当前行未被使用过 if (sheet.GetRow(rowNum) == null) { currentRow = sheet.CreateRow(rowNum); } else { currentRow = sheet.GetRow(rowNum); } if (currentRow.GetCell(columnNum) != null) { ICell currentCell = currentRow.GetCell(columnNum); int length = Encoding.Default.GetBytes(currentCell.ToString()).Length; if (columnWidth < length) { columnWidth = length; } } } sheet.SetColumnWidth(columnNum, columnWidth * 256); } sheet.ForceFormulaRecalculation = true; sheet1.ForceFormulaRecalculation = true; sheet2.ForceFormulaRecalculation = true; string now = DateTime.Now.ToString("yyyyMMddHHmmss.fff"); FileStream file1 = new FileStream(string.Format(@"{0}/Areas/FIVES/ExcelTemplate/{1}.xlsx", Server.MapPath("~"), now + STAFFID + "13"), FileMode.Create); workbook.Write(file1); file1.Close(); rst.TYPE = "S"; rst.MESSAGE = now + STAFFID + "13"; } } catch (Exception e) { rst.TYPE = "E"; rst.MESSAGE = e.Message; } return(Newtonsoft.Json.JsonConvert.SerializeObject(rst)); }
public FIVES_CHECK_INFOList[] Read_HZINFO(FIVES_CHECK_INFOList model, string ptoken) { return(client.Read_HZINFO(model, ptoken)); }