public JsonResult AddProductReportAction(VM_Report_Product product)
{
var retData = new VM_Result_Data();
retData.Content = "添加成品失败";
var bllPd = new MesWeb.BLL.T_Report_Product();
var bllPdStd = new MesWeb.BLL.T_Report_Product_Standard();
var bllPdActual = new MesWeb.BLL.T_Report_Product_Actual();
try {
var stdId = bllPdStd.Add(product.ReportProductStd);
var actualId = bllPdActual.Add(product.ReportProductActual);
if (stdId > 0 && actualId > 0)
{
var pd = product.ReportProduct;
pd.StandardId = stdId;
pd.ActualId = actualId;
if (bllPd.Add(pd) > 0)
{
retData.Code = RESULT_CODE.OK;
retData.Content = "添加成品表成功";
}
}
} catch (Exception e) {
log = LogFactory.GetLogger(MethodBase.GetCurrentMethod().DeclaringType.FullName + ":" + MethodBase.GetCurrentMethod().Name);
log.Error(e);
}
return(Json(retData));
}
/// <summary>
/// 通过成品Id获取成品报表详情
/// </summary>
/// <param name="id"> 成品 Id</param>
/// <returns></returns>
private VM_Report_Product getProductDetailById(int id)
{
var vmPd = new VM_Report_Product();
var bllPd = new MesWeb.BLL.T_Report_Product();
var bllReportStd = new MesWeb.BLL.T_Report_Product_Standard();
var bllReportActual = new MesWeb.BLL.T_Report_Product_Actual();
var pd = bllPd.GetModel(id);
if (pd != null)
{
try {
vmPd.updateReportProduct(pd);
if (pd.StandardId.Value > 0)
{
var std = bllReportStd.GetModel(pd.StandardId.Value);
vmPd.updateReportStd(std);
}
if (pd.ActualId.Value > 0)
{
var actual = bllReportActual.GetModel(pd.ActualId.Value);
vmPd.updateReportActual(actual);
}
} catch (Exception e) {
log = LogFactory.GetLogger(MethodBase.GetCurrentMethod().DeclaringType.FullName + ":" + MethodBase.GetCurrentMethod().Name);
log.Error(e);
}
}
return(vmPd);
}
public JsonResult SaveReportProductAction(VM_Report_Product product)
{
var retData = new VM_Result_Data();
retData.Content = "更新成品表失败";
var bllPd = new MesWeb.BLL.T_Report_Product();
var bllRpStd = new MesWeb.BLL.T_Report_Product_Standard();
var bllRpActual = new MesWeb.BLL.T_Report_Product_Actual();
var oldPd = bllPd.GetModel(product.Id);
if (oldPd != null)
{
try {
//更新主表
var oldPdId = oldPd.Id;
var rpStdId = oldPd.StandardId;
var rpActualId = oldPd.ActualId;
var newPd = product.ReportProduct;
newPd.Id = oldPd.Id;
newPd.ActualId = rpActualId;
newPd.StandardId = rpStdId;
bllPd.Update(newPd);
//更新标准值表
if (rpStdId.HasValue)
{
var rpStd = product.ReportProductStd;
rpStd.Id = rpStdId.Value;
bllRpStd.Update(rpStd);
}
//更新实际值表
if (rpActualId.HasValue)
{
var rpActual = product.ReportProductActual;
rpActual.Id = rpActualId.Value;
bllRpActual.Update(rpActual);
}
retData.Code = RESULT_CODE.OK;
retData.Content = "更新成品表成功";
} catch (Exception e) {
log = LogFactory.GetLogger(MethodBase.GetCurrentMethod().DeclaringType.FullName + ":" + MethodBase.GetCurrentMethod().Name);
log.Error(e);
}
}
return(Json(retData));
}
public ActionResult SearchProductByVolNumAction(string volNum)
{
var retData = new VM_Result_Data();
var vmPd = new VM_Report_Product();
var bllReportStd = new MesWeb.BLL.T_Report_Product_Standard();
var bllReportActual = new MesWeb.BLL.T_Report_Product_Actual();
retData.Content = "查询成品报表失败";
var bllPd = new MesWeb.BLL.T_Report_Product();
var pd = bllPd.GetModelList("VolNum = '" + volNum + "'").FirstOrDefault();
if (pd != null)
{
try {
vmPd.updateReportProduct(pd);
if (pd.StandardId.Value > 0)
{
var std = bllReportStd.GetModel(pd.StandardId.Value);
vmPd.updateReportStd(std);
}
if (pd.ActualId.Value > 0)
{
var actual = bllReportActual.GetModel(pd.ActualId.Value);
vmPd.updateReportActual(actual);
}
retData.Code = RESULT_CODE.OK;
retData.Content = "查询成功";
retData.Appendix = vmPd;
} catch (Exception e) {
log = LogFactory.GetLogger(MethodBase.GetCurrentMethod().DeclaringType.FullName + ":" + MethodBase.GetCurrentMethod().Name);
log.Error(e);
}
}
return(Json(retData));
}
public JsonResult SearchProduct(VM_Repoprt_Plastic_Cond cond)
{
var retData = new VM_Result_Data();
retData.Content = "查询失败";
var bllPd = new MesWeb.BLL.T_Report_Product();
List <T_Report_Product> pdList = new List <T_Report_Product>();
bool isFirstSearch = true;
//列表信息
var pdBrefList = new List <VM_Report_Product_Bref>();
try {
//录入时间
if (cond.startDate.HasValue && cond.endDate.HasValue)
{
isFirstSearch = false;
pdList = bllPd.GetModelList("InputDate >= '" + cond.startDate + "' and InputDate <= '" + cond.endDate + "'");
}
//规格型号
if (!string.IsNullOrEmpty(cond.specNum))
{
if (isFirstSearch)
{
isFirstSearch = false;
pdList = bllPd.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 = bllPd.GetModelList("Code = '" + cond.batchNum + "'");
}
else
{
pdList = (from p in pdList where p.Code == cond.batchNum select p).ToList();
}
}
//供应商
if (!string.IsNullOrEmpty(cond.supplier))
{
if (isFirstSearch)
{
pdList = bllPd.GetModelList("Supplier = '" + cond.supplier + "'");
}
else
{
pdList = (from p in pdList where p.Supplier == cond.supplier select p).ToList();
}
}
foreach (var pd in pdList)
{
pdBrefList.Add(new VM_Report_Product_Bref {
VolNum = pd.VolNum,
InputDate = pd.InputDate.HasValue? pd.InputDate.Value.ToString("yyyy-MM-dd"):"",
Supplier = pd.Supplier,
Detail = "<a onclick='showRPDetail(" + pd.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));
}
