public void LoadHotData(int HotMixId, int SampleMixId, String HotMat) { this.LoadDataBySql("Select * from QC_MixSampleValue_V Where (Sample_Mix_ID=@Sample_Mix_ID or (MainSampleMixId=@Sample_Mix_ID and SampleType=1)) or (Sample_Mix_ID=@HotMixId and checkitemname=@checkitemname)", SampleMixId, HotMixId, HotMat); foreach (var item in this) { QC_Sample_Value_Table recheckvals = new QC_Sample_Value_Table(); recheckvals.LoadDataBySql("Select * from QC_MixSampleValue_V Where MainSampleMixId=@ZhengSampleMixId and SampleType=3", SampleMixId); if (item.Sample_Mix_ID == SampleMixId) { item.ValSource = "正样"; } else { item.ValSource = "抽样"; } if (item.CheckItemCode == "30093") { item.ValSource = ""; } if (item.ValSource == "正样") { foreach (var it in recheckvals) { if (it.CheckItemCode == item.CheckItemCode) { item.RecheckVal = it.CheckVal; } } } } }
public void LoadZhengSampleAllData(int ZhengSampleMixId) { this.LoadDataBySql("Select * from QC_MixSampleValue_V Where (Sample_Mix_ID=@ZhengSampleMixId or (MainSampleMixId=@ZhengSampleMixId and (SampleType=1 or SampleType=4))) and SampleType<>3", ZhengSampleMixId); QC_Sample_Value_Table recheckvals = new QC_Sample_Value_Table(); recheckvals.LoadDataBySql("Select * from QC_MixSampleValue_V Where MainSampleMixId=@ZhengSampleMixId and SampleType=3", ZhengSampleMixId); foreach (var item in this) { if (item.Sample_Mix_ID == ZhengSampleMixId) { item.ValSource = "正样"; } else { item.ValSource = "抽样"; } if (item.ValSource == "正样") { foreach (var it in recheckvals) { if (it.CheckItemCode == item.CheckItemCode) { item.RecheckVal = it.CheckVal; } } } } }
public void CopyData(QC_Sample_Mix original) { this.MatPK = original.MatPK; this.MatCode = original.MatCode; this.MatName = original.MatName; this.CheckItems.Empty(); QC_Sample_Value_Table orignalSample_CheckVals = new QC_Sample_Value_Table(); orignalSample_CheckVals.LoadDataBySampleMixId(original.Sample_Mix_ID); foreach (var item in orignalSample_CheckVals) { QC_MixCheckItem sv = new QC_MixCheckItem(); sv.CheckItemNcId = item.CheckItemNcId; sv.CheckItemCode = item.CheckItemCode; sv.CheckItemName = item.CheckItemName; sv.CheckItemUnit = item.CheckItemUnit; sv.ActualVal = item.CheckVal; this.CheckItems.Add(sv); } }