private void 查询检验单_Click(object sender, EventArgs e)
{
cxs.Clear();
if (comboBox1.Text == "全部" && comboBox2.Text == "全部")
{
lab.LoadDataByWhere("main.JyTime>=@Ksdate and main.JyTime<=@Jsdate order by main.JyCode ", DateTime.Parse(this.dateEdit1.Text.Trim()), DateTime.Parse(this.dateEdit2.Text.Trim()));
}
else if (comboBox2.Text == "全部")
{
lab.LoadDataByWhere("main.JyTime>=@Ksdate and main.JyTime<=@Jsdate and main.CheckGroupName=@CheckGroupName order by main.JyCode ", DateTime.Parse(this.dateEdit1.Text.Trim()), DateTime.Parse(this.dateEdit2.Text.Trim()), comboBox1.Text);
}
else if (comboBox1.Text == "全部")
{
lab.LoadDataByWhere("main.JyTime>=@Ksdate and main.JyTime<=@Jsdate and main.MatName=@MatName order by main.JyCode ", DateTime.Parse(this.dateEdit1.Text.Trim()), DateTime.Parse(this.dateEdit2.Text.Trim()), comboBox2.Text);
}
else
{
lab.LoadDataByWhere("main.JyTime>=@Ksdate and main.JyTime<=@Jsdate and main.CheckGroupName=@CheckGroupName and main.MatName=@MatName order by main.JyCode ", DateTime.Parse(this.dateEdit1.Text.Trim()), DateTime.Parse(this.dateEdit2.Text.Trim()), comboBox1.Text, comboBox2.Text);
}
for (int i = 0; i < lab.Count; i++)
{
QC_Shcx cx = new QC_Shcx();
lab[i].CheckVals.LoadDataByWhere("main.Sample_Lab_ID=@Sample_Lab_ID", lab[i].Sample_Lab_ID);
cx.Sample_Shcx_ID = i + 1;
cx.Yplx = lab[i].CheckGroupName;
cx.Lybm = lab[i].JyCode;
cx.Jyr = lab[i].JyUser;
cx.Jysj = lab[i].JyTime;
if (lab[i].MatName == "")
{
mcg.LoadDataByWhere("main.Sample_Lab_ID=@Sample_Lab_ID", lab[i].Sample_Lab_ID);
mix.LoadDataByWhere("main.Sample_Mix_ID=@Sample_Lab_ID", mcg[0].Sample_Mix_ID);
wl.LoadDataByWhere("PK_INVBASDOC=@PK_INVBASDOC", mix[0].MatPK);
cx.Wlmc = wl[0].INVNAME;
}
else
{
cx.Wlmc = lab[i].MatName;
}
for (int j = 0; j < lab[i].CheckVals.Count; j++)
{
if (lab[i].CheckVals[j].CheckUser != "")
{
cx.Fxry = lab[i].CheckVals[j].CheckUser;
cx.Fxsj = lab[i].CheckVals[j].CheckTime;
}
if (lab[i].CheckVals[j].CheckItemName.Equals("灰分"))
{
cx.Hf = lab[i].CheckVals[j].CheckVal;
}
else if (lab[i].CheckVals[j].CheckItemName.Equals("挥发分"))
{
cx.Hff = lab[i].CheckVals[j].CheckVal;
}
else if (lab[i].CheckVals[j].CheckItemName.Equals("S"))
{
cx.S = lab[i].CheckVals[j].CheckVal;
}
else if (lab[i].CheckVals[j].CheckItemName.Equals("固定碳"))
{
cx.Gdt = lab[i].CheckVals[j].CheckVal;
}
else if (lab[i].CheckVals[j].CheckItemName.Equals("G"))
{
cx.G = lab[i].CheckVals[j].CheckVal;
}
else if (lab[i].CheckVals[j].CheckItemName.Equals("Y"))
{
cx.Y = lab[i].CheckVals[j].CheckVal;
}
else if (lab[i].CheckVals[j].CheckItemName.Equals("P"))
{
cx.P = lab[i].CheckVals[j].CheckVal;
}
else if (lab[i].CheckVals[j].CheckItemName.Equals("MgO"))
{
cx.MgO = lab[i].CheckVals[j].CheckVal;
}
else if (lab[i].CheckVals[j].CheckItemName.Equals("SiO2"))
{
cx.SiO2 = lab[i].CheckVals[j].CheckVal;
}
else if (lab[i].CheckVals[j].CheckItemName.Equals("CaO"))
{
cx.CaO = lab[i].CheckVals[j].CheckVal;
}
else if (lab[i].CheckVals[j].CheckItemName.Equals("Al2O3"))
{
cx.Al2O3 = lab[i].CheckVals[j].CheckVal;
}
else if (lab[i].CheckVals[j].CheckItemName.Equals("TFe"))
{
cx.TFe = lab[i].CheckVals[j].CheckVal;
}
else if (lab[i].CheckVals[j].CheckItemName.Equals("TiO2"))
{
cx.TiO2 = lab[i].CheckVals[j].CheckVal;
}
else if (lab[i].CheckVals[j].CheckItemName.Equals("Cu"))
{
cx.Cu = lab[i].CheckVals[j].CheckVal;
}
else if (lab[i].CheckVals[j].CheckItemName.Equals("MnO"))
{
cx.MnO = lab[i].CheckVals[j].CheckVal;
}
else if (lab[i].CheckVals[j].CheckItemName.Equals("K2O"))
{
cx.K2O = lab[i].CheckVals[j].CheckVal;
}
else if (lab[i].CheckVals[j].CheckItemName.Equals("Na2O"))
{
cx.Na2O = lab[i].CheckVals[j].CheckVal;
}
else if (lab[i].CheckVals[j].CheckItemName.Equals("V2O5"))
{
cx.V2O5 = lab[i].CheckVals[j].CheckVal;
}
else if (lab[i].CheckVals[j].CheckItemName.Equals("Pb"))
{
cx.Pb = lab[i].CheckVals[j].CheckVal;
}
else if (lab[i].CheckVals[j].CheckItemName.Equals("Zn"))
{
cx.Zn = lab[i].CheckVals[j].CheckVal;
}
else if (lab[i].CheckVals[j].CheckItemName.Equals("As"))
{
cx.As = lab[i].CheckVals[j].CheckVal;
}
else if (lab[i].CheckVals[j].CheckItemName.Equals("Sn"))
{
cx.Sn = lab[i].CheckVals[j].CheckVal;
}
else if (lab[i].CheckVals[j].CheckItemName.Equals("Sb"))
{
cx.Sb = lab[i].CheckVals[j].CheckVal;
}
else if (lab[i].CheckVals[j].CheckItemName.Equals("硫分"))
{
cx.Lf = lab[i].CheckVals[j].CheckVal;
}
}
bool cunzai = false;
foreach (var item in cxs)
{
if (item.Sample_Shcx_ID == cx.Sample_Shcx_ID)
{
cunzai = true;
}
}
if (cunzai == false)
{
cxs.Add(cx);
}
}
this.gridControl1.DataSource = cxs;
}
private void 查询_Click(object sender, EventArgs e)
{
cxs.Clear();
mix.Clear();
mcg.Clear();
mcgzong.Clear();
lab.Clear();
labzong.Clear();
veh.Clear();
if (comboBox1.Text == "全部" && comboBox2.Text == "全部")
{
mix.LoadDataByWhere("main.mix_time>=@Ksdate and main.mix_time<=@Jsdate and main.wllx='煤'", DateTime.Parse(this.dateEdit1.Text.Trim()), DateTime.Parse(this.dateEdit2.Text.Trim()));
}
else if (comboBox2.Text == "全部")
{
mix.LoadDataByWhere("main.mix_time>=@Ksdate and main.mix_time<=@Jsdate and supplier.CUSTSHORTNAME=@SupplierName and main.wllx='煤'", DateTime.Parse(this.dateEdit1.Text.Trim()), DateTime.Parse(this.dateEdit2.Text.Trim()), comboBox1.Text);
}
else if (comboBox1.Text == "全部")
{
mix.LoadDataByWhere("main.mix_time>=@Ksdate and main.mix_time<=@Jsdate and mat.INVNAME=@MatName and main.wllx='煤'", DateTime.Parse(this.dateEdit1.Text.Trim()), DateTime.Parse(this.dateEdit2.Text.Trim()), comboBox2.Text);
}
else
{
mix.LoadDataByWhere("main.mix_time>=@Ksdate and main.mix_time<=@Jsdate and supplier.CUSTSHORTNAME=@SupplierName and mat.INVNAME=@MatName and main.wllx='煤'", DateTime.Parse(this.dateEdit1.Text.Trim()), DateTime.Parse(this.dateEdit2.Text.Trim()), comboBox1.Text, comboBox2.Text);
}
foreach (var item in mix)
{
mcg.LoadDataByWhere("main.Sample_Mix_ID=@Sample_Mix_ID and checkgroupname='化验样'", item.Sample_Mix_ID);
mcgzong.Add(mcg[0]);
}
foreach (var item in mcgzong)
{
lab.LoadDataByWhere("main.Sample_Lab_ID=@Sample_Lab_ID and labstate='审核通过' and billtype='审核通过'", item.Sample_Lab_ID);
if (lab.Count > 0)
{
labzong.Add(lab[0]);
}
}
for (int i = 0; i < labzong.Count; i++)
{
labzong[i].CheckVals.LoadDataByWhere("main.Sample_Lab_ID=@Sample_Lab_ID", labzong[i].Sample_Lab_ID);
mcg.LoadDataByWhere("main.Sample_Lab_ID=@Sample_Lab_ID", labzong[i].Sample_Lab_ID);
mix.LoadDataByWhere("main.Sample_Mix_ID=@Sample_Lab_ID", mcg[0].Sample_Mix_ID);
wl.LoadDataByWhere("PK_INVBASDOC=@PK_INVBASDOC", mix[0].MatPK);
veh.LoadDataByWhere("Sample_Mix_ID=@Sample_Mix_ID", mcg[0].Sample_Mix_ID);
foreach (var item in veh)
{
QC_Shcx cx = new QC_Shcx();
// cx.Sample_Shcx_ID = i + 1;
cx.Yplx = labzong[i].CheckGroupName;
cx.Lybm = labzong[i].JyCode;
cx.Jyr = labzong[i].JyUser;
cx.Jysj = labzong[i].JyTime;
cx.Gys = mix[0].SupplierName;
if (labzong[i].MatName == "")
{
cx.Wlmc = wl[0].INVNAME;
}
else
{
cx.Wlmc = labzong[i].MatName;
}
cx.Cph = item.VehNo;
cx.Qysj = item.FetchTime;
for (int j = 0; j < labzong[i].CheckVals.Count; j++)
{
if (labzong[i].CheckVals[j].CheckItemName.Equals("灰分"))
{
cx.Hf = labzong[i].CheckVals[j].CheckVal;
}
else if (labzong[i].CheckVals[j].CheckItemName.Equals("挥发分"))
{
cx.Hff = labzong[i].CheckVals[j].CheckVal;
}
else if (labzong[i].CheckVals[j].CheckItemName.Equals("S"))
{
cx.S = labzong[i].CheckVals[j].CheckVal;
}
else if (labzong[i].CheckVals[j].CheckItemName.Equals("固定碳"))
{
cx.Gdt = labzong[i].CheckVals[j].CheckVal;
}
else if (labzong[i].CheckVals[j].CheckItemName.Equals("硫分"))
{
cx.Lf = labzong[i].CheckVals[j].CheckVal;
}
else if (labzong[i].CheckVals[j].CheckItemName.Equals("发热量1"))
{
cx.Frl = labzong[i].CheckVals[j].CheckVal;
}
}
cxs.Add(cx);
this.gridControl1.DataSource = cxs;
}
}
}
