public void exceptBill() { initPrintbill(); if (printbill.Count > 0) { return; } DbEntityTable <QC_Sample_Mix> temp = new DbEntityTable <QC_Sample_Mix>(); temp.LoadDataByWhere("main.samplestate = @samplestate and main.wllx=@wllx order by SAMPLE_MIX_ID desc", Xg.Lab.Sample.SampleState.组批完成, "火运"); if (temp.Count < 1) { return; } int sid = temp[0].MainSampleMixId; printbill.Clear(); if (sid == 0) { printbill.Add(temp[0]); } else { for (int i = 0; i < temp.Count; i++) { if (temp[i].Sample_Mix_ID >= sid) { printbill.Add(temp[i]); } } } }
private void _Click(object sender, EventArgs e) { int i = 0; foreach (var item in test) { if (item.Shangchuan) { hyy.LoadDataByWhere("JyCode=@JyCode", QC_Sample_Mix.FullStoreCode(item.SampleName)); if (hyy.Count > 0) { vals.LoadDataByWhere("main.Sample_Lab_ID=@Sample_Lab_ID", hyy[0].Sample_Lab_ID); } else { vals.Clear(); } if (vals.Count > 0) { foreach (var it in vals) { if ((it.CheckItemCode == item.CheckItemCode || (it.CheckItemCode == "10120" && item.CheckItemCode == "10002")) && (it.CheckVal == "" || it.CheckVal == null)) { it.CheckVal = item.Value; item.Shangchuan = true; i++; } } } else { item.Shangchuan = false; } } vals.Save(); } test.Save(); if (i > 0) { MessageBox.Show(i.ToString() + "条数据上传完成"); } else { MessageBox.Show("没有可匹配项目"); } }
private void WP_Zhkcx_Load(object sender, EventArgs e) { this.gridControl1.DataSource = cxs; List <String> wl = new List <String>(); wl.Add("全部"); vehs.LoadDataBySql("select distinct (h.INVNAME) as MatName from QC_Sample_Veh t ,BD_INVBASDOC h where h.PK_INVBASDOC=t.MatPK"); foreach (var item in vehs) { if (!wl.Contains(item.MatName) && item.MatName != "") { wl.Add(item.MatName); } } vehs.Clear(); comboBox2.DataSource = wl; }
private void WP_Shcx_Load(object sender, EventArgs e) { cg.LoadData(); List <String> cgname = new List <String>(); List <String> wl = new List <String>(); cgname.Add("全部"); wl.Add("全部"); foreach (var item in cg) { cgname.Add(item.CheckGroupName); } comboBox1.DataSource = cgname; lab.LoadData(); foreach (var item in lab) { if (!wl.Contains(item.MatName) && item.MatName != "") { wl.Add(item.MatName); } } lab.Clear(); comboBox2.DataSource = wl; }
private void 查询_Click(object sender, EventArgs e) { cxs.Clear(); QC_Sample_Mix mix = new QC_Sample_Mix(); zyMixSamples.LoadDataByWhere("main.Mix_Time>=@Kssj and main.Mix_Time<=@Jssj and main.samplestate=9 and main.WLLX='煤' and main.Mix_Time>@Mix_Time order by main.Mix_Time ", DateTime.Parse(this.dateEdit1.Text.Trim()), DateTime.Parse(this.dateEdit2.Text.Trim()), Convert.ToDateTime("2017-09-30 18:00:00")); for (int i = 0; i < zyMixSamples.Count; i++) { zyMixSamples[i].CheckVals.LoadDataBySampleMixId(zyMixSamples[i].Sample_Mix_ID); bool cunzai = false; for (int j = 0; j < zyMixSamples1.Count; j++) { if (zyMixSamples[i].MatPK == zyMixSamples1[j].MatPK && zyMixSamples[i].SupplierCode == zyMixSamples1[j].SupplierCode && zyMixSamples[i].Riqi == zyMixSamples1[j].Riqi) { cunzai = true; foreach (var item in zyMixSamples1[j].CheckVals) { if (item.CheckItemName == "S" || item.CheckItemName == "硫分") { foreach (var it in zyMixSamples[i].CheckVals) { if (it.CheckItemName == "S" || it.CheckItemName == "硫分") { if (Convert.ToDouble(it.ReportVal) < Convert.ToDouble(item.ReportVal)) { zyMixSamples1.Remove(zyMixSamples1[j]); zyMixSamples1.Add(zyMixSamples[i]); } } } } } } } if (cunzai == false) { zyMixSamples1.Add(zyMixSamples[i]); } } for (int i = 0; i < zyMixSamples1.Count; i++) { QC_Hbcx cx = new QC_Hbcx(); cx.Xh = i + 1; cx.Wlmc = zyMixSamples1[i].MatName; cx.Riqi = zyMixSamples1[i].Mix_Time.Value.ToString("yyyy-MM-dd"); cx.Gysmc = zyMixSamples1[i].SupplierName; cx.Pddj = zyMixSamples1[i].LocalQcLevel; foreach (var item in zyMixSamples1[i].CheckVals) { if (item.CheckItemName == "水分") { cx.Sf = item.ReportVal; } else if (item.CheckItemName == "灰分") { cx.Hf = item.ReportVal; } else if (item.CheckItemName == "挥发分") { cx.Hff = item.ReportVal; } else if (item.CheckItemName == "硫分") { cx.Lf = item.ReportVal; } else if (item.CheckItemName == "S") { cx.Lf = item.ReportVal; } else if (item.CheckItemName == "X") { cx.X = item.ReportVal; } else if (item.CheckItemName == "Y") { cx.Y = item.ReportVal; } else if (item.CheckItemName == "G") { cx.G = item.ReportVal; } else if (item.CheckItemName == "发热量") { cx.Frl = item.ReportVal; } } cxs.Add(cx); } }
private void 查询_Click(object sender, EventArgs e) { cxs.Clear(); QC_Sample_Mix mix = new QC_Sample_Mix(); zyMixSamples.LoadDataByWhere("main.Mix_Time>=@Kssj and main.Mix_Time<=@Jssj and main.samplestate=11 and main.WLLX='煤' order by main.ZyDanHao ", DateTime.Parse(this.dateEdit1.Text.Trim()), DateTime.Parse(this.dateEdit2.Text.Trim())); for (int i = 0; i < zyMixSamples.Count; i++) { if (zyMixSamples[i].SampleType == SampleType.抽查样) { zyMixSamples[i].VehSamples.LoadDataByNoticeBillId(zyMixSamples[i].NoticeBillId); int parentId = InspectSampleParentId(zyMixSamples[i].Sample_Mix_ID); if (zyMixSamples[i].daycheck() == 0) { zyMixSamples[i].CheckVals.LoadInspectSampleAllData(zyMixSamples[i].Sample_Mix_ID, parentId); } else { zyMixSamples[i].CheckVals.LoadInspectHotAllData(zyMixSamples[i].Sample_Mix_ID, parentId, zyMixSamples[i].daycheck(), "发热量1"); } } else if (zyMixSamples[i].SampleType == SampleType.普通样) { zyMixSamples[i].VehSamples.LoadDataBySampleMixId(zyMixSamples[i].Sample_Mix_ID); if (zyMixSamples[i].daycheck() == 0) { zyMixSamples[i].CheckVals.LoadZhengSampleAllData(zyMixSamples[i].Sample_Mix_ID); } else { zyMixSamples[i].CheckVals.LoadHotData(zyMixSamples[i].daycheck(), zyMixSamples[i].Sample_Mix_ID, "发热量1"); } } DbEntityTable <QC_MatAllCheckItem> matcheckitems = new DbEntityTable <QC_MatAllCheckItem>(); matcheckitems.LoadDataByWhere("MATNCID=@MATNCID", zyMixSamples[i].MatPK); if (matcheckitems.Count > 0) { foreach (var item in matcheckitems) { if (item.CheckGroupName == "可磨样") { bool czkm = false; foreach (var it in zyMixSamples[i].CheckGroupLabs) { if (it.CheckGroupName == "可磨样") { czkm = true; } } if (!czkm) { DbEntityTable <QC_Sample_Mix> lishimixs = new DbEntityTable <QC_Sample_Mix>(); string SQL = "select * from QC_Sample_Mix where MatCode='" + zyMixSamples[i].MatCode + "' and SupplierCode='" + zyMixSamples[i].SupplierCode + "' and mix_time>='" + zyMixSamples[i].ZyRecvTime.Value.Date + "' and mix_time<'" + zyMixSamples[i].ZyRecvTime + "' order by ZyRecvTime desc"; lishimixs.LoadDataBySql(SQL); foreach (var li in lishimixs) { bool czkmy = false; DbEntityTable <QC_Sample_Lab> labs = new DbEntityTable <QC_Sample_Lab>(); labs.LoadDataByWhere("main.Sample_Mix_ID=@Sample_Mix_ID", li.Sample_Mix_ID); foreach (var it in labs) { if (it.CheckGroupName == "可磨样") { DbEntityTable <QC_Sample_Value> vals = new DbEntityTable <QC_Sample_Value>(); vals.LoadDataByWhere("main.Sample_Lab_ID=@Sample_Lab_ID", it.Sample_Lab_ID); foreach (var va in vals) { va.ValSource = "前样"; zyMixSamples[i].CheckVals.Add(va); } czkmy = true; break; } } if (czkmy) { break; } } } } } } zyMixSamples[i].CheckVals.DefaultSort(); if (zyMixSamples[i].SampleType == SampleType.普通样) { zyMixSamples[i].CheckVals.DaoxuSort(); } DbEntityTable <QC_MatQualityLevel_View> levels = new DbEntityTable <QC_MatQualityLevel_View>(); levels.LoadDataByWhere("QUALITYLEVELID=@QUALITYLEVELID", zyMixSamples[i].QualityLevelID); for (int j = 0; j < zyMixSamples[i].VehSamples.Count; j++) { QC_SCNCcx cx = new QC_SCNCcx(); cx.VehNo = zyMixSamples[i].VehSamples[j].VehNo; cx.FetchTime = zyMixSamples[i].VehSamples[j].FetchTime; cx.KouShui = zyMixSamples[i].VehSamples[j].KouShui; cx.KouZa = zyMixSamples[i].VehSamples[j].KouZa; cx.SampleType = zyMixSamples[i].SampleType; cx.ZyDanHao = zyMixSamples[i].ZyDanHao; cx.Wlmc = zyMixSamples[i].MatName; // cx.Riqi = zyMixSamples[i].Mix_Time.Value.ToString("yyyy-MM-dd"); cx.Gysmc = zyMixSamples[i].SupplierName; cx.Pddj = levels[0].QUALITYLEVELNAME; foreach (var item in zyMixSamples[i].CheckVals) { if (item.CheckItemName == "水分") { if (cx.Sf == "") { cx.Sf = item.ReportVal; } } if (item.CheckItemName == "哈氏可磨性") { if (cx.KM == "") { cx.KM = item.ReportVal; } } else if (item.CheckItemName == "灰分") { if (cx.Hf == "") { cx.Hf = item.ReportVal; } } else if (item.CheckItemName == "挥发分") { if (cx.Hff == "") { cx.Hff = item.ReportVal; } } else if (item.CheckItemName == "硫分") { if (cx.Lf == "") { cx.Lf = item.ReportVal; } } else if (item.CheckItemName == "S") { if (cx.Lf == "") { cx.Lf = item.ReportVal; } } else if (item.CheckItemName == "X") { if (cx.X == "") { cx.X = item.ReportVal; } } else if (item.CheckItemName == "Y") { if (cx.Y == "") { cx.Y = item.ReportVal; } } else if (item.CheckItemName == "G") { if (cx.G == "") { cx.G = item.ReportVal; } } else if (item.CheckItemName == "发热量1") { if (cx.Frl == "") { cx.Frl = item.ReportVal; } } else if (item.CheckItemName == "标准差S") { if (cx.BzcS == "") { cx.BzcS = item.ReportVal; } } else if (item.CheckItemName == "Rmax") { if (cx.Rmax == "") { cx.Rmax = item.ReportVal; } } else if (item.CheckItemName == "Rran") { if (cx.Rran == "") { cx.Rran = item.ReportVal; } } else if (item.CheckItemName == "固定碳") { if (cx.Gdt == "") { cx.Gdt = item.ReportVal; } } } cxs.Add(cx); } } }
private void 刷新_Click(object sender, EventArgs e) { hjvehs.LoadDataByWhere("main.SAMPLESTATE=@SAMPLESTATE and WLLX='合金'", SampleState.初始状态); hjmixs.Clear(); }
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(); if (this.dateEdit1.Text != "" && this.dateEdit2.Text != "") { if (comboBox2.Text == "全部") { zyMixSamples.LoadDataByWhere("main.ZyRecvTime>=@Kssj and main.ZyRecvTime<=@Jssj order by main.ZyRecvTime", DateTime.Parse(this.dateEdit1.Text.Trim()), DateTime.Parse(this.dateEdit2.Text.Trim())); } else if (comboBox2.Text == "普通样") { zyMixSamples.LoadDataByWhere("main.ZyRecvTime>=@Kssj and main.ZyRecvTime<=@Jssj and main.SampleType=@SampleType order by main.ZyRecvTime", DateTime.Parse(this.dateEdit1.Text.Trim()), DateTime.Parse(this.dateEdit2.Text.Trim()), SampleType.普通样); } else if (comboBox2.Text == "抽查样") { zyMixSamples.LoadDataByWhere("main.ZyRecvTime>=@Kssj and main.ZyRecvTime<=@Jssj and main.SampleType=@SampleType order by main.ZyRecvTime", DateTime.Parse(this.dateEdit1.Text.Trim()), DateTime.Parse(this.dateEdit2.Text.Trim()), SampleType.抽查样); } else if (comboBox2.Text == "快样") { zyMixSamples.LoadDataByWhere("main.ZyRecvTime>=@Kssj and main.ZyRecvTime<=@Jssj and main.SampleType=@SampleType and main.Wpcode=@Wpcode order by main.ZyRecvTime", DateTime.Parse(this.dateEdit1.Text.Trim()), DateTime.Parse(this.dateEdit2.Text.Trim()), SampleType.普通样, ""); } for (int i = 0; i < zyMixSamples.Count; i++) { if (comboBox1.Text == "全部") { zyMixSamples[i].CheckGroups.LoadDataByWhere("main.Sample_Mix_ID=@Sample_Mix_ID", zyMixSamples[i].Sample_Mix_ID); } else { zyMixSamples[i].CheckGroups.LoadDataByWhere("main.Sample_Mix_ID=@Sample_Mix_ID and main.CheckGroupName=@CheckGroupName", zyMixSamples[i].Sample_Mix_ID, comboBox1.Text); } for (int j = 0; j < zyMixSamples[i].CheckGroups.Count; j++) { if (zyMixSamples[i].CheckGroups[j].Sample_Lab_ID != 0) { labs.LoadDataByWhere("main.Sample_Lab_ID=@Sample_Lab_ID", zyMixSamples[i].CheckGroups[j].Sample_Lab_ID); } QC_Zycx cx = new QC_Zycx(); cx.Sample_Shcx_ID = i + 1; cx.Sksj = zyMixSamples[i].ZyRecvTime; cx.Lybm = zyMixSamples[i].ZyDanHao; cx.Jzcph = zyMixSamples[i].ZyJzZuPiHao; if (zyMixSamples[i].SampleType == SampleType.普通样 && zyMixSamples[i].WpCode != "") { cx.Qylx = "普通样"; } else if (zyMixSamples[i].SampleType == SampleType.普通样 && zyMixSamples[i].WpCode == "") { cx.Qylx = "快样"; } else if (zyMixSamples[i].SampleType == SampleType.抽查样) { cx.Qylx = "抽查样"; } cx.Jyr = zyMixSamples[i].ZyRecvUser; cx.Ypbm = zyMixSamples[i].CheckGroups[j].StoreCode; cx.Yplx = zyMixSamples[i].CheckGroups[j].CheckGroupName; if (labs.Count > 0) { if (labs[0].MakeTime == null) { cx.Syr = null; } else { cx.Syr = labs[0].MakeUser; } cx.Sysj = labs[0].MakeTime; } labs.Clear(); cxs.Add(cx); } } } else { MessageBox.Show("请输入时间段"); } }
private void 查询_Click(object sender, EventArgs e) { cxs.Clear(); zyMixSamples.LoadDataByWhere("main.Mix_Time>=@Kssj and main.Mix_Time<=@Jssj and (main.LocalQcLevel<> ''or main.Sample_Cylx='管理抽样' or main.Sample_Cylx='普通抽样' ) order by main.Mix_Time ", DateTime.Parse(this.dateEdit1.Text.Trim()), DateTime.Parse(this.dateEdit2.Text.Trim())); for (int i = 0; i < zyMixSamples.Count; i++) { string cph = txtCph.Text.Trim(); if (comboBox2.Text == "全部") { vehs.LoadDataByWhere(string.Format("VehNo like '%{0}%' and (Sample_Mix_ID=@Sample_Mix_ID or NoticeBillId=@NoticeBillId) ", cph), zyMixSamples[i].Sample_Mix_ID, zyMixSamples[i].NoticeBillId); } else { vehs.LoadDataByWhere(string.Format("VehNo like '%{0}%' and (Sample_Mix_ID=@Sample_Mix_ID or NoticeBillId=@NoticeBillId) and dhd.INVNAME=@MatName ", cph), zyMixSamples[i].Sample_Mix_ID, zyMixSamples[i].NoticeBillId, comboBox2.Text); } zyMixSamples[i].CheckVals.LoadDataBySampleMixId(zyMixSamples[i].Sample_Mix_ID); for (int j = 0; j < vehs.Count; j++) { QC_Zhkcx cx = new QC_Zhkcx(); cx.Tempid = zyMixSamples[i].TempID; cx.Sjsl = vehs[j].Sjsl; cx.Xh = i + 1; cx.Ch = vehs[j].VehNo; cx.Wlmc = zyMixSamples[i].MatName; cx.Qysj = vehs[j].FetchTime; cx.Gysmc = zyMixSamples[i].SupplierName; cx.Pddj = zyMixSamples[i].LocalQcLevel; cx.FetchPlace = zyMixSamples[i].FetchPlace; cx.FetchPerson = zyMixSamples[i].FetchPerson; cx.Zyd = zyMixSamples[i].WpCode; if (zyMixSamples[i].Sample_Cylx == "" || zyMixSamples[i].Sample_Cylx == null) { cx.Yplx = zyMixSamples[i].LeiXing; } else { cx.Yplx = zyMixSamples[i].Sample_Cylx; } cx.Ks = vehs[j].KouShui; cx.Kz = vehs[j].KouZa; foreach (var item in zyMixSamples[i].CheckVals) { if (item.CheckItemName == "水分") { cx.Sf = item.ReportVal; } else if (item.CheckItemName == "灰分") { cx.Hf = item.ReportVal; } else if (item.CheckItemName == "挥发分") { cx.Hff = item.ReportVal; } else if (item.CheckItemName == "硫分") { cx.Lf = item.ReportVal; } else if (item.CheckItemName == "X") { cx.X = item.ReportVal; } else if (item.CheckItemName == "Y") { cx.Y = item.ReportVal; } else if (item.CheckItemName == "G") { cx.G = item.ReportVal; } else if (item.CheckItemName == "标准差S") { cx.Bzc = item.ReportVal; } else if (item.CheckItemName == "Rmax") { cx.Rmax = item.ReportVal; } else if (item.CheckItemName == "可磨性") { cx.Kmx = item.ReportVal; } else if (item.CheckItemName == "发热量") { cx.Rz = item.ReportVal; } else if (item.CheckItemName == "P") { cx.P = item.ReportVal; } else if (item.CheckItemName == "S") { cx.S = item.ReportVal; } } cxs.Add(cx); } } }
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; } } }
public void regexString(string input) { try { string str = ""; Match match = Regex.Match(input, @"Sample:\s+(?<Sample>[^\r\s\t]+)"); if ((match != null) && (match.Groups.Count > 0)) { str = match.Groups["Sample"].Value.Replace(",", ""); } string strTime = ""; //Date: 17,13 28,07,16 match = Regex.Match(input, @"Date:\s+(?<Date>[^\r\n]+)"); if ((match != null) && (match.Groups.Count > 0)) { string str1 = match.Groups["Date"].Value.Replace(",", "").Trim(); strTime = "20" + str1.Substring(9, 2) + "-" + str1.Substring(7, 2) + "-" + str1.Substring(5, 2) + " " + str1.Substring(0, 2) + ":" + str1.Substring(2, 2); } StringBuilder sb = new StringBuilder(); for (match = Regex.Match(input, @"(?<Element>MnO|Ni|As|Sn|Sb|S|P|MgO|SiO2|CaO|Al2O3|TFe|R|TiO2|Mo|Cr|K2O|Na2O|Pb|V2O5|Zn|Cu)\s?:\s?(?<Value>[0-9.+-]+)"); (match != null) && match.Success; match = match.NextMatch()) { QC_Sample_Jyjg t2 = new QC_Sample_Jyjg(); t2.CheckItemCode = ""; t2.CheckItemName = match.Groups["Element"].Value.ToString(); t2.Date = strTime; t2.JYShebei = "荧光"; t2.SampleName = str; if (Convert.ToDouble(match.Groups["Value"].Value) < 0.0) { t2.Value = "0"; } else { t2.Value = match.Groups["Value"].Value.ToString(); } Boolean flag = true; for (int i = 0; i < test.Count && flag; i++) { if (test[i].SampleName == t2.SampleName && test[i].CheckItemName == t2.CheckItemName) { flag = false; sb.Append("单号:" + test[i].SampleName + "," + "检验项目" + test[i].CheckItemName + "已存在"); sb.Append("\r\n"); } } if (flag) { test.Add(t2); } } if ((test.Count > 0) && (str != "")) { test.Save(); } test.Clear(); test.LoadDataByWhere("shangchuan=0 and JYShebei=@JYShebei order by date desc", "荧光"); if (sb.Length > 1) { MessageBox.Show(sb.ToString()); } } catch { } }