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