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));
}
private VM_Report_Plastic getPlasticReportById(int id)
{
var retData = new VM_Result_Data();
var vmPls = new VM_Report_Plastic();
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 pls = bllPls.GetModel(id);
if (pls == null)
{
return(null);
}
var header = bllHeader.GetModel(pls.ReportHeaderId.Value);
if (header != null)
{
try {
var footer = bllFooter.GetModel(pls.ReportFooterId.Value);
ReportPlasticUpdate(out vmPls, pls, header, footer);
} catch (Exception e) {
log = LogFactory.GetLogger(MethodBase.GetCurrentMethod().DeclaringType.FullName + ":" + MethodBase.GetCurrentMethod().Name);
log.Error(e);
}
}
return(vmPls);
}
/// <summary>
/// 将前端塑料报告数据转换成持久层模型
/// </summary>
/// <param name="vmPlastic"></param>
/// <returns></returns>
private T_Report_Plastic toPlasticModel(VM_Report_Plastic vmPlastic)
{
T_Report_Plastic rp = null;
var bllRvalue = new MesWeb.BLL.T_Report_Value();
var bllRheader = new MesWeb.BLL.T_Report_Header();
var bllFooter = new MesWeb.BLL.T_Report_Footer();
try {
var headerId = bllRheader.Add(vmPlastic.toReportHeader());
var footerId = bllFooter.Add(vmPlastic.toReportFooter());
var elecRateId = bllRvalue.Add(vmPlastic.toElecRateValue());
var elecStrengthId = bllRvalue.Add(vmPlastic.toElecStrengthValue());
var mpaBeforeId = bllRvalue.Add(vmPlastic.toMpaAfterValue());
var elongBeforeId = bllRvalue.Add(vmPlastic.toElongBeforeValue());
var agingConditionId = bllRvalue.Add(vmPlastic.toAgingConditionValue());
var mpaAfterId = bllRvalue.Add(vmPlastic.toMpaAfterValue());
var elongAfterId = bllRvalue.Add(vmPlastic.toElongAfterValue());
var mpaRateMaxId = bllRvalue.Add(vmPlastic.toMpaRateMaxValue());
var elongRateMaxId = bllRvalue.Add(vmPlastic.toElongRateMaxValue());
var agingQualityLossId = bllRvalue.Add(vmPlastic.toAgingQualityLossValue());
var thermalStablityTimeId = bllRvalue.Add(vmPlastic.toThermalStablityTimeValue());
var bittleImpactTestId = bllRvalue.Add(vmPlastic.toBittleImpactTestValue());
var thermalDeformationId = bllRvalue.Add(vmPlastic.toThermalDeformationValue());
var oxyIndexId = bllRvalue.Add(vmPlastic.toOxyIndexValue());
var specGravityId = bllRvalue.Add(vmPlastic.toSpecGravityValue());
var shoreHBTestId = bllRvalue.Add(vmPlastic.toShoreHBTestValue());
var apperanceQualityId = bllRvalue.Add(vmPlastic.toApperanceQualityValue());
var pkgAndLabeId = bllRvalue.Add(vmPlastic.toPkgAndLabelValue());
rp = new T_Report_Plastic();
rp.AgingConditionId = agingConditionId;
rp.AgingQualityLossId = agingQualityLossId;
rp.ApperanceQualityId = apperanceQualityId;
rp.BittleImpactTestId = bittleImpactTestId;
rp.Code = vmPlastic.Code;
rp.ElecRateId = elecRateId;
rp.ElecStrengthId = elecStrengthId;
rp.ElongAfterId = elongAfterId;
rp.ElongBeforeId = elongBeforeId;
rp.ElongRateMaxId = elongRateMaxId;
rp.MpaAfterId = mpaAfterId;
rp.MpaBeforeId = mpaBeforeId;
rp.MpaRateMaxId = mpaRateMaxId;
rp.OxyIndexId = oxyIndexId;
rp.PkgAndLabelId = pkgAndLabeId;
rp.ReportFooterId = footerId;
rp.ReportHeaderId = headerId;
rp.ShoreHBTestId = shoreHBTestId;
rp.SpecGravityId = specGravityId;
rp.ThermalDeformationId = thermalDeformationId;
rp.ThermalStablityTimeId = thermalStablityTimeId;
} catch (Exception e) {
log = LogFactory.GetLogger(MethodBase.GetCurrentMethod().DeclaringType.FullName + ":" + MethodBase.GetCurrentMethod().Name);
log.Error(e);
}
return(rp);
}
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));
}
public JsonResult SaveReportPlasticAction(VM_Report_Plastic plastic)
{
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 bllValue = new MesWeb.BLL.T_Report_Value();
try {
var oldPls = bllPls.GetModel(plastic.Id);
if (oldPls != null)
{
//更新header
var oldHeader = bllHeader.GetModel(oldPls.ReportHeaderId.Value);
var newHeader = plastic.toReportHeader();
newHeader.Id = oldHeader.Id;
bllHeader.Update(newHeader);
//更新footer
var oldFooter = bllFooter.GetModel(oldPls.ReportFooterId.Value);
var newFooter = plastic.toReportFooter();
newFooter.Id = oldFooter.Id;
bllFooter.Update(newFooter);
//更新plastic
oldPls.Code = plastic.Code;
bllPls.Update(oldPls);
//更新具体值
var oldElecRate = bllValue.GetModel(oldPls.ElecRateId.Value);
var newElecRate = plastic.toElecRateValue();
newElecRate.Id = oldElecRate.Id;
bllValue.Update(newElecRate);
var oldElecStrength = bllValue.GetModel(oldPls.ElecStrengthId.Value);
var newElecStrength = plastic.toElecStrengthValue();
newElecStrength.Id = oldElecStrength.Id;
bllValue.Update(newElecStrength);
var oldMpaBefore = bllValue.GetModel(oldPls.MpaBeforeId.Value);
var newMpaBefore = plastic.toMpaBeforeValue();
newMpaBefore.Id = oldMpaBefore.Id;
bllValue.Update(newMpaBefore);
var oldElongBefore = bllValue.GetModel(oldPls.ElongBeforeId.Value);
var newElongBefore = plastic.toElongBeforeValue();
newElongBefore.Id = oldElongBefore.Id;
bllValue.Update(newElongBefore);
var oldAgingCondition = bllValue.GetModel(oldPls.AgingConditionId.Value);
var newAgingCondition = plastic.toAgingConditionValue();
newAgingCondition.Id = oldAgingCondition.Id;
bllValue.Update(newAgingCondition);
var oldMpaAfter = bllValue.GetModel(oldPls.MpaAfterId.Value);
var newMpaAfter = plastic.toMpaAfterValue();
newMpaAfter.Id = oldMpaAfter.Id;
bllValue.Update(newMpaAfter);
var oldElongAfter = bllValue.GetModel(oldPls.ElongAfterId.Value);
var newElongAfter = plastic.toElongAfterValue();
newElongAfter.Id = oldElongAfter.Id;
bllValue.Update(newElongAfter);
var oldMpaRateMax = bllValue.GetModel(oldPls.MpaRateMaxId.Value);
var newMpaRateMax = plastic.toMpaRateMaxValue();
newMpaRateMax.Id = oldMpaRateMax.Id;
bllValue.Update(newMpaRateMax);
var oldElongRateMax = bllValue.GetModel(oldPls.ElongRateMaxId.Value);
var newElongRateMax = plastic.toElongRateMaxValue();
newElongRateMax.Id = oldElongRateMax.Id;
bllValue.Update(newElongRateMax);
var oldAgingQualityLoss = bllValue.GetModel(oldPls.AgingQualityLossId.Value);
var newAgingQualityLoss = plastic.toAgingQualityLossValue();
newAgingQualityLoss.Id = oldAgingQualityLoss.Id;
bllValue.Update(newAgingQualityLoss);
var oldThermalStablityTime = bllValue.GetModel(oldPls.ThermalStablityTimeId.Value);
var newThermalStablityTime = plastic.toThermalStablityTimeValue();
newThermalStablityTime.Id = oldThermalStablityTime.Id;
bllValue.Update(newThermalStablityTime);
var oldBittleImpactTest = bllValue.GetModel(oldPls.BittleImpactTestId.Value);
var newBittleImpactTest = plastic.toBittleImpactTestValue();
newBittleImpactTest.Id = oldBittleImpactTest.Id;
bllValue.Update(newBittleImpactTest);
var oldThermalDeformation = bllValue.GetModel(oldPls.ThermalDeformationId.Value);
var newThermalDeformation = plastic.toThermalDeformationValue();
newThermalDeformation.Id = oldThermalDeformation.Id;
bllValue.Update(newThermalDeformation);
var oldOxyIndex = bllValue.GetModel(oldPls.OxyIndexId.Value);
var newOxyIndex = plastic.toOxyIndexValue();
newOxyIndex.Id = oldOxyIndex.Id;
bllValue.Update(newOxyIndex);
var oldSpecGravity = bllValue.GetModel(oldPls.SpecGravityId.Value);
var newSpecGravity = plastic.toSpecGravityValue();
newSpecGravity.Id = oldSpecGravity.Id;
bllValue.Update(newSpecGravity);
var oldShoreHBTest = bllValue.GetModel(oldPls.ShoreHBTestId.Value);
var newShoreHBTest = plastic.toShoreHBTestValue();
newShoreHBTest.Id = oldShoreHBTest.Id;
bllValue.Update(newShoreHBTest);
var oldApperanceQuality = bllValue.GetModel(oldPls.ApperanceQualityId.Value);
var newApperanceQuality = plastic.toApperanceQualityValue();
newApperanceQuality.Id = oldApperanceQuality.Id;
bllValue.Update(newApperanceQuality);
var oldPkgAndLabel = bllValue.GetModel(oldPls.PkgAndLabelId.Value);
var newPkgAndLabel = plastic.toPkgAndLabelValue();
newPkgAndLabel.Id = oldPkgAndLabel.Id;
bllValue.Update(newPkgAndLabel);
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));
}
