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));
}
