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