/// <summary>
/// 获取物料组成信息
/// </summary>
/// <param name="condition">获取条件</param>
/// <returns>物料组成信息</returns>
public List <TraceMaterial> GetTraceMaterial(TraceGood condition)
{
List <TraceMaterial> list = null;
string sql = @"select pt.PID,pt.MatBarCode,pt.MatID,ml.MatCode,ml.MatName,pt.CREATETIME,ml.ProductPlace
from T_FP_ProduceTrack pt
left outer join T_WH_Mat ml on pt.MatID=ml.ID
where BatchNumber = @BatchNumber and pt.WPID = 'start'
order by pt.CREATETIME";
List <DataParameter> parameters = new List <DataParameter>();
parameters.Add(new DataParameter("BatchNumber", condition.BatchNumber));
using (IDataSession session = AppDataFactory.CreateMainSession())
{
list = session.GetList <TraceMaterial>(sql, parameters.ToArray()).ToList();
}
return(list);
}
/// <summary>
/// 获取加工工序信息
/// </summary>
/// <param name="condition">获取条件</param>
/// <returns>加工工序信息</returns>
public List <TraceProcess> GetTraceProcess(TraceGood condition)
{
List <TraceProcess> list = null;
string sql = @"select pt.PID,pi.PCODE as ProcessCode,pi.PNAME as ProcessName,pt.WorkingStartTime,pt.WorkingEndTime,
equ.ECODE as EquCode,equ.ENAME as EquName
from T_FP_ProduceTrack pt
left outer join T_FP_PROCESSINFO pi on pt.WPID=pi.PID
left outer join T_FP_EQUIPMENT equ on pt.EQUID=equ.PID
where BatchNumber = @BatchNumber and pt.WPID <> 'start' and STATUS = '1'
order by pi.PCODE";
List <DataParameter> parameters = new List <DataParameter>();
parameters.Add(new DataParameter("BatchNumber", condition.BatchNumber));
using (IDataSession session = AppDataFactory.CreateMainSession())
{
list = session.GetList <TraceProcess>(sql, parameters.ToArray()).ToList();
}
return(list);
}
/// <summary>
/// 获取产品基本信息
/// </summary>
/// <param name="PID">产品主键</param>
/// <returns>产品基本信息</returns>
public TraceGood GetTraceGood(string PID)
{
string sql = null;
TraceGood info = null;
sql = @"select g.PID,p.PNAME as ProductName,p.SPECIFICATION,g.PLANDATE as ProduceDate,g.BatchNumber,
f.PNAME as FactoryName,l.PLNAME as LineName,pf.PNAME as FlowName,wg.PNAME as WorkGroupName
from T_FP_GoodInfo g
left outer join T_FP_PRODUCTINFO p on g.ProductionID=p.PID
left outer join T_FP_FACTORYINFO f on g.FACTORYPID=f.PID
left outer join T_FP_PRODUCTLINE l on g.PRID=l.PID
left outer join T_FP_PROCESSFLOW pf on p.PRID=pf.PID
left outer join T_FP_WORKGROUP wg on g.WOID=wg.PID
where g.PID=@PID
";
using (IDataSession session = AppDataFactory.CreateMainSession())
{
info = session.Get <TraceGood>(sql, new DataParameter("PID", PID));
}
return(info);
}
private void BindData()
{
TraceGood good = null;
string pid = Request.QueryString["pid"];
//绑定产品基本信息
good = new QualityTraceQueryBLL().GetTraceGood(pid);
UIBindHelper.BindForm(this.Page, good);
//绑定物料组成信息
List <TraceMaterial> materialList = new QualityTraceQueryBLL().GetTraceMaterial(new TraceGood {
BatchNumber = good.BatchNumber
});
this.HiMaterial.Value = LAF.Common.Serialization.JsonConvertHelper.GetSerializes(materialList);
//绑定加工工序信息
List <TraceProcess> processList = new QualityTraceQueryBLL().GetTraceProcess(new TraceGood {
BatchNumber = good.BatchNumber
});
this.HiProcess.Value = LAF.Common.Serialization.JsonConvertHelper.GetSerializes(processList);
}
private void BindData()
{
string batchNumber = "2017111401";
string barCode = Request.QueryString["BarCode"];
TraceGood good = null;
batchNumber = new GoodPackingBLL().GetBatchNumberByBarCode(barCode);
if (string.IsNullOrEmpty(batchNumber) == true)
{
this.ProduceName.Text = "追溯码无效";
return;
}
//绑定产品基本信息
good = new QualityTraceQueryBLL().GetTraceGoodByBN(batchNumber);
if (good == null)
{
this.ProduceName.Text = "追溯码无效";
return;
}
this.ProduceName.Text = good.ProductName;
this.SPECIFICATION.Text = good.SPECIFICATION;
this.ProductionAddress.Text = good.ProductionAddress;
this.Manufacturer.Text = good.Manufacturer;
this.QualityPeriod.Text = good.QualityPeriod;
this.ProduceDate.Text = good.ProduceDate.ToString("yyyy年MM月dd日");
this.ProduceBatchNumber.Text = good.BatchNumber;
this.ProductionLicense.Text = good.ProductionLicense;
this.ProductStandard.Text = good.ProductStandard;
//绑定物料组成信息
List <TraceMaterial> materialList = new QualityTraceQueryBLL().GetTraceMaterial(new TraceGood {
BatchNumber = good.BatchNumber
});
materialList = materialList.GroupBy(x => new
{
x.MatName,
x.ProductPlace
}).Select(g => new TraceMaterial
{
MatName = g.Key.MatName,
ProductPlace = g.Key.ProductPlace
})
.ToList();
int seq1 = 1;
foreach (TraceMaterial tm in materialList)
{
this.lblMaterials.Text += string.Format("<tr><td align=center>{0}</td><td align=center>{1}</td><td align=center><a href=\"#\">{2}</a></td></tr>", seq1.ToString(), tm.MatName, tm.ProductPlace);
seq1++;
}
//绑定加工工序信息
List <TraceProcess> processList = new QualityTraceQueryBLL().GetTraceProcess(new TraceGood {
BatchNumber = good.BatchNumber
});
int seq2 = 1;
foreach (TraceProcess tp in processList)
{
this.tblProcess.Text += string.Format("<tr><td align=center>{0}</td><td align=center>{1}</td><td align=center>{2}</td></tr>", seq2.ToString(), tp.ProcessName, tp.EquName);
seq2++;
}
}
public List <TraceProcess> GetTraceProcess(TraceGood condition)
{
return(new QualityTraceQueryDAL().GetTraceProcess(condition));
}
public List <TraceMaterial> GetTraceMaterial(TraceGood condition)
{
return(new QualityTraceQueryDAL().GetTraceMaterial(condition));
}
