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