public string DELETE_TP_TPZHNO(string datastring) { ZSL_BCT012 model_ZSL_BCT012 = Newtonsoft.Json.JsonConvert.DeserializeObject <ZSL_BCT012>(datastring); ZBCFUN_TP_ZHM_GL res = mesModels.MES_TPM.DELETE_TP_TPZHNO(model_ZSL_BCT012); return(Newtonsoft.Json.JsonConvert.SerializeObject(res)); }
public string INSERT_TM_ZHM(string datastring) { ZSL_BCT012[] model_ZSL_BCT012 = Newtonsoft.Json.JsonConvert.DeserializeObject <ZSL_BCT012[]>(datastring); ZSL_BCT011 model_ZSL_BCT011 = new ZSL_BCT011(); ZBCFUN_TP_ZHM_GL res = mesModels.MES_TPM.INSERT_TP_ZHM(model_ZSL_BCT011, model_ZSL_BCT012); return(Newtonsoft.Json.JsonConvert.SerializeObject(res)); }
public string INSERT_TM_WZHM(string datastring) { int STAFFID = Convert.ToInt32(AppClass.GetSession("STAFFID")); string STAFFNAME = AppClass.GetSession("NAME").ToString(); ZSL_BCT011 model_ZSL_BCT011 = new ZSL_BCT011(); model_ZSL_BCT011.CJR = STAFFID; model_ZSL_BCT011.CJRNAME = STAFFNAME; ZSL_BCT012[] model_ZSL_BCT012 = Newtonsoft.Json.JsonConvert.DeserializeObject <ZSL_BCT012[]>(datastring); ZBCFUN_TP_ZHM_GL res = mesModels.MES_TPM.INSERT_TP_WZHM(model_ZSL_BCT011, model_ZSL_BCT012); return(Newtonsoft.Json.JsonConvert.SerializeObject(res)); }
public string INSERT_TM_ZHM(string datastring) { TokenINFO rst_TokenINFO = GET_TokenINFO(); int STAFFID = rst_TokenINFO.STAFFID; string STAFFNAME = rst_TokenINFO.STAFFNAME; ZSL_BCT011 model_ZSL_BCT011 = new ZSL_BCT011(); model_ZSL_BCT011.CJR = STAFFID; model_ZSL_BCT011.CJRNAME = STAFFNAME; ZSL_BCT012[] model_ZSL_BCT012 = Newtonsoft.Json.JsonConvert.DeserializeObject <ZSL_BCT012[]>(datastring); ZBCFUN_TP_ZHM_GL res = mesmodels.MES_TPM.INSERT_TP_WZHM(model_ZSL_BCT011, model_ZSL_BCT012); return(Newtonsoft.Json.JsonConvert.SerializeObject(res)); }
public ActionResult TPM_ZHNO_PRINT() { string token = AppClass.GetSession("token").ToString(); List <MODEL_RWQD_PRINT> rst = new List <MODEL_RWQD_PRINT>(); ZSL_BCT011[] model_ZSL_BCT011 = (ZSL_BCT011[])Session["ZSL_BCT011"]; for (int i = 0; i < model_ZSL_BCT011.Length; i++) { MODEL_RWQD_PRINT child_MODEL_RWQD_PRINT = new MODEL_RWQD_PRINT(); child_MODEL_RWQD_PRINT.ZSL_BCT011 = model_ZSL_BCT011[i]; ZBCFUN_TP_ZHM_GL res = mesModels.MES_TPM.SELECT_TP_ZHNOb(model_ZSL_BCT011[i].TPZHNO); child_MODEL_RWQD_PRINT.Zsl_bct012 = res.IT_TPZHNO_GL; rst.Add(child_MODEL_RWQD_PRINT); } return(View(rst)); }
public string EXPOST_TPZHNOSELECT(string alldata, string TPCOUNT) { MES_RETURN_UI rst = new MES_RETURN_UI(); try { ZSL_BCT011[] model = Newtonsoft.Json.JsonConvert.DeserializeObject <ZSL_BCT011[]>(alldata); FileStream file = new FileStream(Server.MapPath("~") + @"/Areas/MES/ExportFile/托盘组合码信息查询导出.xls", FileMode.Open, FileAccess.Read); IWorkbook workbook = new HSSFWorkbook(file); ISheet sheet = workbook.GetSheetAt(0); int rowcount = 1; for (int i = 0; i < model.Length; i++) { int cellIndex = 0; IRow row = sheet.CreateRow(rowcount++); row.CreateCell(cellIndex++).SetCellValue(model[i].TPZHNO); row.CreateCell(cellIndex++).SetCellValue(model[i].CJRNAME); row.CreateCell(cellIndex++).SetCellValue(model[i].CJRQ); ZBCFUN_TP_ZHM_GL res = mesModels.MES_TPM.SELECT_TP_ZHNOb(model[i].TPZHNO); TPCOUNT = ""; for (int j = 0; j < res.IT_TPZHNO_GL.Length; j++) { TPCOUNT += res.IT_TPZHNO_GL[j].TPNO + ";"; } row.CreateCell(cellIndex++).SetCellValue(TPCOUNT); } string now = DateTime.Now.ToString("yyyyMMddHHmmss.fff"); FileStream file1 = new FileStream(string.Format(@"{0}/Areas/MES/ExportFile/{1}.xls", 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 DELETE_TP_TPNO(string TPZHNO) { ZBCFUN_TP_ZHM_GL res = mesModels.MES_TPM.DELETE_TP_TPNO(TPZHNO); return(Newtonsoft.Json.JsonConvert.SerializeObject(res)); }
public string SELECT_TP_ZHNOa(string TPZHNO, string CJRQKS, string CJRQJS, string CJRNAME) { ZBCFUN_TP_ZHM_GL res = mesModels.MES_TPM.SELECT_TP_ZHNOa(TPZHNO, CJRQKS, CJRQJS, CJRNAME); return(Newtonsoft.Json.JsonConvert.SerializeObject(res)); }
public string SELECT_TP_ZHNOb(string TPZHNO) { ZBCFUN_TP_ZHM_GL res = mesmodels.MES_TPM.SELECT_TP_ZHNOb(TPZHNO); return(Newtonsoft.Json.JsonConvert.SerializeObject(res)); }