public JsonResult SearchPlastictBySpecNumAction(string specNum) { var retData = new VM_Result_Data(); retData.Content = "搜索塑料表失败"; var bllPls = new MesWeb.BLL.T_Report_Plastic(); var bllHeader = new MesWeb.BLL.T_Report_Header(); var bllFooter = new MesWeb.BLL.T_Report_Footer(); var header = bllHeader.GetModelList("SpecNum = '" + specNum + "'").First(); if (header != null) { try { var pls = bllPls.GetModelList("ReportHeaderId = " + header.Id).First(); if (pls != null) { var vmPls = new VM_Report_Plastic(); var footer = bllFooter.GetModel(pls.ReportFooterId.Value); ReportPlasticUpdate(out vmPls, pls, header, footer); retData.Appendix = vmPls; retData.Content = "查询塑料报表成功"; retData.Code = RESULT_CODE.OK; } } catch (Exception e) { log = LogFactory.GetLogger(MethodBase.GetCurrentMethod().DeclaringType.FullName + ":" + MethodBase.GetCurrentMethod().Name); log.Error(e); } } return(Json(retData)); }
public JsonResult SerachPlasticAction(VM_Repoprt_Plastic_Cond cond) { var retData = new VM_Result_Data(); retData.Content = "查询失败"; var bllPs = new MesWeb.BLL.T_Report_Header(); var bllRs = new MesWeb.BLL.T_Report_Plastic(); List <T_Report_Header> pdList = new List <T_Report_Header>(); bool isFirstSearch = true; //列表信息 var pdBrefList = new List <VM_Report_Plastic_Bref>(); try { //录入时间 if (cond.startDate.HasValue && cond.endDate.HasValue) { isFirstSearch = false; pdList = bllPs.GetModelList("InputDate >= '" + cond.startDate + "' and InputDate <= '" + cond.endDate + "'"); } //规格型号 if (!string.IsNullOrEmpty(cond.specNum)) { if (isFirstSearch) { isFirstSearch = false; pdList = bllPs.GetModelList("SpecNum = '" + cond.specNum + "'"); } else { pdList = (from p in pdList where p.SpecNum == cond.specNum select p).ToList(); } } //批次号(表单编号) if (!string.IsNullOrEmpty(cond.batchNum)) { if (isFirstSearch) { isFirstSearch = false; pdList = bllPs.GetModelList("BatchNum = '" + cond.batchNum + "'"); } else { pdList = (from p in pdList where p.BatchNum == cond.batchNum select p).ToList(); } } //供应商 if (!string.IsNullOrEmpty(cond.supplier)) { if (isFirstSearch) { pdList = bllPs.GetModelList("Supplier = '" + cond.supplier + "'"); } else { pdList = (from p in pdList where p.Supplier == cond.supplier select p).ToList(); } } foreach (var pd in pdList) { var rs = bllRs.GetModelList("ReportHeaderId = " + pd.Id).FirstOrDefault(); var id = 0; if (rs != null) { id = rs.Id; } pdBrefList.Add(new VM_Report_Plastic_Bref { SpecNum = pd.SpecNum, InputDate = pd.InputDate.HasValue ? pd.InputDate.Value.ToString("yyyy-MM-dd") :"", Supplier = pd.Supplier, Detail = "<a onclick='showRPDetail(" + id + ")'>报表详情</a>" }); } }catch (Exception e) { log = LogFactory.GetLogger(MethodBase.GetCurrentMethod().DeclaringType.FullName + ":" + MethodBase.GetCurrentMethod().Name); log.Error(e); } if (pdBrefList.Count > 0) { retData.Code = RESULT_CODE.OK; retData.Appendix = pdBrefList; retData.Content = "查询成功"; } return(Json(retData)); }