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