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