public MES_SY_LANGUAGE_TABLEZD_SELECT SELECT_TABLEZD(MES_SY_LANGUAGE_TABLEZD model, string ptoken) { return(client.SELECT_TABLEZD(model, ptoken)); }
public string EXPORT_RWQD(string datastring) { string token = AppClass.GetSession("token").ToString(); MES_RETURN_UI rst = new MES_RETURN_UI(); try { MES_SY_LANGUAGE_TABLEZD model_MES_SY_LANGUAGE_TABLEZD = new MES_SY_LANGUAGE_TABLEZD(); model_MES_SY_LANGUAGE_TABLEZD.YMAREA = "MES"; model_MES_SY_LANGUAGE_TABLEZD.YMCONTROLLER = "PD"; model_MES_SY_LANGUAGE_TABLEZD.YMVIEW = "RW_SELECT_ALL"; model_MES_SY_LANGUAGE_TABLEZD.TABLEDM = "dc_tb_PDRW"; model_MES_SY_LANGUAGE_TABLEZD.YMXM = "SONLUKPC"; model_MES_SY_LANGUAGE_TABLEZD.LB = 1; MES_SY_LANGUAGE_TABLEZD_SELECT rst_MES_SY_LANGUAGE_TABLEZD_SELECT = mesModels.SY_LANGUAGE_YM.SELECT_TABLEZD(model_MES_SY_LANGUAGE_TABLEZD, token); if (rst_MES_SY_LANGUAGE_TABLEZD_SELECT.MES_RETURN.TYPE != "S") { return(Newtonsoft.Json.JsonConvert.SerializeObject(rst_MES_SY_LANGUAGE_TABLEZD_SELECT.MES_RETURN)); } if (rst_MES_SY_LANGUAGE_TABLEZD_SELECT.MES_SY_LANGUAGE_TABLEZD.Length > 0) { AppClass.SetSession("EXPORT_RWQD", rst_MES_SY_LANGUAGE_TABLEZD_SELECT.MES_SY_LANGUAGE_TABLEZD[0].TABLENAME); } else { AppClass.SetSession("EXPORT_RWQD", "NO HEAD"); } MES_PD_SCRW_LIST[] model = Newtonsoft.Json.JsonConvert.DeserializeObject <MES_PD_SCRW_LIST[]>(datastring); //FileStream file = new FileStream(Server.MapPath("~") + @"/Areas/MES/ExportFile/生产任务导出.xls", FileMode.Open, FileAccess.Read); 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; IRow rowtt = sheet.CreateRow(rowcount++); int cellIndex = 0; for (int a = 0; a < rst_MES_SY_LANGUAGE_TABLEZD_SELECT.MES_SY_LANGUAGE_TABLEZD.Length; a++) { rowtt.CreateCell(cellIndex++).SetCellValue(rst_MES_SY_LANGUAGE_TABLEZD_SELECT.MES_SY_LANGUAGE_TABLEZD[a].TABLEZDNAME); } //IWorkbook workbook = new HSSFWorkbook(file); //ISheet sheet = workbook.GetSheetAt(0); //int rowcount = 1; for (int i = 0; i < model.Length; i++) { cellIndex = 0; IRow row = sheet.CreateRow(rowcount++); row.CreateCell(cellIndex++).SetCellValue(model[i].RWBH); row.CreateCell(cellIndex++).SetCellValue(model[i].WLH); row.CreateCell(cellIndex++).SetCellValue(model[i].WLMS); row.CreateCell(cellIndex++).SetCellValue(model[i].GC); row.CreateCell(cellIndex++).SetCellValue(model[i].GZZXBH); row.CreateCell(cellIndex++).SetCellValue(model[i].GZZXNAME); row.CreateCell(cellIndex++).SetCellValue(model[i].SBH); row.CreateCell(cellIndex++).SetCellValue((double)model[i].SL); row.CreateCell(cellIndex++).SetCellValue(model[i].UNITSNAME); row.CreateCell(cellIndex++).SetCellValue(model[i].PFDH); row.CreateCell(cellIndex++).SetCellValue(model[i].PLDH); row.CreateCell(cellIndex++).SetCellValue(model[i].TH); row.CreateCell(cellIndex++).SetCellValue(model[i].XFCDNAME); row.CreateCell(cellIndex++).SetCellValue(model[i].PC); row.CreateCell(cellIndex++).SetCellValue(model[i].GDDH); row.CreateCell(cellIndex++).SetCellValue(model[i].ERPNO); row.CreateCell(cellIndex++).SetCellValue(model[i].JLRMS); row.CreateCell(cellIndex++).SetCellValue(model[i].JLTIME); row.CreateCell(cellIndex++).SetCellValue(model[i].TLSJ); row.CreateCell(cellIndex++).SetCellValue(model[i].CCSJ); } string now = DateTime.Now.ToString("yyyyMMddHHmmss.fff"); FileStream file1 = new FileStream(string.Format(@"{0}/Areas/MES/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)); }