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]); } } } }
public static DbEntityTable <QC_CardUseType> LoadCardUseType() { DbEntityTable <QC_CardUseType> result = new DbEntityTable <QC_CardUseType>(); QC_CardUseType cut1 = new QC_CardUseType(); cut1.CUTCode = QC_IC_Info.CardUseType_Veh; cut1.CUTName = "车取样扣"; result.Add(cut1); QC_CardUseType cut2 = new QC_CardUseType(); cut2.CUTCode = "CUT002"; cut2.CUTName = "组批样扣"; result.Add(cut2); DbEntityTable <QC_CheckGroup> groups = new DbEntityTable <QC_CheckGroup>(); groups.LoadData(); foreach (var item in groups) { QC_CardUseType cut = new QC_CardUseType(); cut.CUTCode = "CUT_" + item.CheckGroupCode; cut.CUTName = item.CheckGroupName + "扣"; result.Add(cut); } return(result); }
public void HandleCardMessage(Device.CardReader device, string cardId) { QC_IC_Info icCard = QC_IC_Info.FindByCardId(cardId); if (icCard == null) { MessageBox.Show("此卡未注册"); return; } if (!icCard.CardType.StartsWith("CUT_")) { MessageBox.Show("磁扣类型不对"); return; } if (icCard.SampleId <= 0) { MessageBox.Show("此卡没有业务信息"); return; } QC_Sample_Lab_Jy tempLab = QC_Sample_Lab_Jy.GetById(icCard.SampleId); if (tempLab == null) { MessageBox.Show("没有找到单据"); return; } tempLab.JyCode = DbContext.GetSeq("JY" + DateTime.Now.Date.ToString("yyyyMMdd"), 2); tempLab.Billtype = "开始检验"; tempLab.LabState = "开始检验"; tempLab.JyUser = LocalInfo.Current.user.ID; tempLab.JyTime = DateTime.Now; icCard.SampleId = 0; IDbConnection conn = DbContext.GetDefaultConnection(); conn.Open(); IDbTransaction trans = conn.BeginTransaction(); icCard.Save(trans); tempLab.Save(trans); trans.Commit(); conn.Close(); this.curLab = QC_Sample_Lab_Jy.GetById(tempLab.Sample_Lab_ID); lableiji.Add(curLab); DbContext.ExeSql("insert into QC_LabLog(zycode,jycode,jytime) values('" + this.curLab.StoreCode + "','" + this.curLab.JyCode + "',getDate())"); labTable1.LoadDataByWhere("labstate='送检' and checkgroupname like '化验样%' and maketime>=@maketime", DateTime.Today.AddDays(-1)); // labTable2.LoadDataByWhere("labstate='送检' and checkgroupname like '角质层%' and maketime>=@maketime", DateTime.Today.AddDays(-1)); label2.Text = labTable1.Count.ToString(); // label4.Text = labTable2.Count.ToString(); SetGridViewFocuse(); this.printDocument1.Print(); //自动打印 //this.printPreviewDialog1.ShowDialog(); }
private void 查询组批_Click(object sender, EventArgs e) { mixs.LoadDataByWhere("main.WLLX='熔剂' and main.SampleState=@SampleState", SampleState.初始状态); ches.LoadDataByWhere("main.WLLX='熔剂' and main.SampleState=@SampleState", SampleState.初始状态); if (ches.Count > 0) { for (int j = 0; j < ches.Count; j++) { if (ches[j].Sample_Mix_ID == 0) { bool cunzai = false; if (mixs.Count > 0) { for (int m = 0; m < mixs.Count; m++) { if (ches[j].SupplierCode == mixs[m].SupplierCode && ches[j].MatCode == mixs[m].MatCode && mixs[m].MixPlanCount > mixs[m].MixCount) { cunzai = true; ches[j].Sample_Mix_ID = mixs[m].Sample_Mix_ID; ches[j].Save(); mixs[m].MixCount++; mixs[m].Save(); } } } if (cunzai == false) { QC_Material matInfo = QC_Material.GetByID(ches[j].MatPK); QC_Sample_Mix mix = new QC_Sample_Mix(); mix.WpCode = "0087"; mix.FangTong_Time = DateTime.Now; mix.FangTong_User = LocalInfo.Current.user.ID; mix.MatCode = ches[j].MatCode; mix.MatPK = ches[j].MatPK; mix.MixCount = 1; mix.MixPlanCount = matInfo.BatchNum; mix.SupplierCode = ches[j].SupplierCode; mix.MixUser = LocalInfo.Current.user.ID; mix.SampleState = SampleState.初始状态; mix.SampleType = SampleType.普通样; mix.WLLX = ches[j].WLLX; mix.CardID = Zhc.Data.DbContext.GetSeq("RJ" + DateTime.Now.Date.ToString("yyyyMMdd"), 2); mix.Save(); mixs.Add(mix); ches[j].Sample_Mix_ID = mix.Sample_Mix_ID; ches[j].Save(); } } } } }
public DlgChe(string cph, DateTime quyangTime) { InitializeComponent(); vehs.LoadDataByWhere(string.Format("vehno like '%{0}%' order by Sample_Veh_id desc ", cph)); //, quyangTime.AddHours(12), quyangTime.AddHours(-12)and InTime<=@SamTime1 and (OutTime>=@SamTime2 or OutTime is null) and OutTime<>'null' if (vehs.Count > 0) { vehs1.Add(vehs[0]); } this.qCSampleVehBindingSource.DataSource = vehs1; }
public static QC_NoticeDhdItem_View GetByIcNo(string icno) { DbEntityTable <QC_NoticeDhdItem_View> noticeDhd = new DbEntityTable <QC_NoticeDhdItem_View>(); noticeDhd.LoadDataByWhere("icno=@icno and status = 0", icno); DbEntityTable <QC_NoticeDhdItem_View> noticeDhddui = new DbEntityTable <QC_NoticeDhdItem_View>(); DbEntityTable <TB_TaskFlow> tt = new DbEntityTable <TB_TaskFlow>(); for (int i = 0; i < noticeDhd.Count; i++) { bool chumen = false; tt.LoadDataByWhere("NoticeId=@NoticeId", noticeDhd[i].NoticeId); for (int j = 0; j < tt.Count; j++) { if (tt[j].Result == "出门") { chumen = true; } } if (chumen == false) { noticeDhddui.Add(noticeDhd[i]); } } if (noticeDhddui.Count > 1) { QC_NoticeDhdItem_View noticeDhd1 = new QC_NoticeDhdItem_View(); Xuanze dlg = new Xuanze(noticeDhddui); if (dlg.ShowDialog() == DialogResult.OK) { noticeDhd1 = dlg.SelectedDhdItem; } return(noticeDhd1); } else if (noticeDhddui.Count == 1) { return(noticeDhddui[0]); } else { return(null); } }
private void timer1_Tick(object sender, EventArgs e) { mixs.LoadDataByWhere("main.WLLX='外矿' and main.SampleState=@SampleState", SampleState.初始状态); vehs.LoadDataByWhere("main.WLLX='外矿' and main.SampleState=@SampleState", SampleState.初始状态); for (int j = 0; j < vehs.Count; j++) { if (vehs[j].Sample_Mix_ID == 0) { bool cunzai = false; for (int m = 0; m < mixs.Count; m++) { if (vehs[j].SupplierCode == mixs[m].SupplierCode && vehs[j].MatCode == mixs[m].MatCode && mixs[m].MixPlanCount > mixs[m].MixCount) { cunzai = true; vehs[j].Sample_Mix_ID = mixs[m].Sample_Mix_ID; vehs[j].Save(); mixs[m].MixCount++; mixs[m].Save(); } } if (cunzai == false) { QC_Material matInfo = QC_Material.GetByID(vehs[j].MatPK); QC_Sample_Mix mix = new QC_Sample_Mix(); mix.WpCode = "0090"; mix.MatCode = vehs[j].MatCode; mix.MatPK = vehs[j].MatPK; mix.MixCount = 1; mix.MixPlanCount = matInfo.BatchNum; mix.SupplierCode = vehs[j].SupplierCode; mix.MixUser = LocalInfo.Current.user.ID; mix.SampleState = SampleState.初始状态; mix.SampleType = SampleType.普通样; mix.WLLX = vehs[j].WLLX; mix.CardID = "WK" + Zhc.Data.DbContext.GetSeq(DateTime.Now.Date.ToString("yyyyMMdd"), 2); mix.Save(); mixs.Add(mix); vehs[j].Sample_Mix_ID = mix.Sample_Mix_ID; vehs[j].Save(); } } } }
/// <summary> /// 从视图读取集中计量火车信息,保存到QC_Sample_Veh表中 /// </summary> public void initdata() { trainData = new DbEntityTable <View_train_to_sample>(); trainData.LoadData(); //没有数据时,返回 if (trainData.Count < 1) { return; } DbEntityTable <QC_Sample_Veh> veh = new DbEntityTable <QC_Sample_Veh>(); foreach (var item in trainData) { QC_Sample_Veh sample = new QC_Sample_Veh(); //物流的主键 sample.FetchPlace = item.matchid; //发站 sample.zpdh = item.FAZHAN; //物料名称 sample.rwdh = item.WLMC; sample.VehNo = item.CPH; sample.CardID = item.HCPH; sample.begintime = item.GROSSTIME; sample.SampleState = Xg.Lab.Sample.SampleState.初始状态; //加入noticebillid sample.NoticeBillId = System.Guid.NewGuid().ToString(); sample.WLLX = "火运"; veh.Add(sample); } veh.Save(); //trans_train_sample = new DbEntityTable<QC_Sample_Veh>(); //foreach (var item in trainData) //{ // QC_Sample_Veh sample = new QC_Sample_Veh(); // sample.Sample_Veh_ID = item.matchid; // sample.FAZHAN = item.FAZHAN; // sample.WLMC = item.WLMC; // sample.VehNo = item.CPH; // sample.CardID = item.HCPH; // sample.begintime = item.GROSSTIME.ToString("yyyy-MM-dd HH:mm:ss"); // sample.SampleState = Xg.Lab.Sample.SampleState.初始状态; // trans_train_sample.Add(sample); //} //trans_train_sample.Save(); }
private void btnImportJudgeRule_Click(object sender, EventArgs e) { if (this.openFileDialog1.ShowDialog() == DialogResult.OK) { DbEntityTable <QC_QualityRule> rules = new DbEntityTable <QC_QualityRule>(); DataTable dt = Xg.Tools.ExcelHelper.ImportExcelFile(this.openFileDialog1.FileName); DbEntityTable <QC_Material> mats = new DbEntityTable <QC_Material>(); mats.LoadData(); for (int i = 1; i < dt.Rows.Count; i++) { string matCode = dt.Rows[i][0].ToString().Trim(); var mat = from m in mats where m.MatCode == matCode select m; QC_QualityRule rule = new QC_QualityRule(); rule.MatNcId = mat.First <QC_Material>().MatNcId; rule.LocalQcLevel = dt.Rows[i][2].ToString().Trim(); switch (rule.LocalQcLevel) { case "一级": rule.RuleOrder = 1; break; case "二级": rule.RuleOrder = 2; break; case "三级": rule.RuleOrder = 3; break; default: rule.RuleOrder = 4; break; } string ruleContent = dt.Rows[i][3].ToString().Trim(); rule.RuleStr2Contents(ruleContent); rule.QualityLevelID = "1001NC100000002GF3MN"; rules.Add(rule); } rules.Save(); } }
private void 添加物料_Click(object sender, EventArgs e) { QC_Material_wl wl = new QC_Material_wl(); DlgMaterial dlg = new DlgMaterial(); if (dlg.ShowDialog() == DialogResult.OK) { if (dlg.SelectedMaterial != null) { wl.MatNcId = dlg.SelectedMaterial.PK_INVBASDOC; wl.MatCode = dlg.SelectedMaterial.InvCode; wl.MatName = dlg.SelectedMaterial.InvName; wl.InUse = dlg.SelectedMaterial.InUse; } wls.Add(wl); wls.Save(); } }
public void CopyData(QC_Sample_Mix original) { head.MatPK = original.MatPK; head.MatCode = original.MatCode; head.MatName = original.MatName; body2.Empty(); DbEntityTable <QC_Sample_Value> orignalSample_CheckVals = new DbEntityTable <QC_Sample_Value>(); orignalSample_CheckVals.LoadDataByWhere("Sample_Mix_ID=@Sample_Mix_ID", original.Sample_Mix_ID); foreach (var item in orignalSample_CheckVals) { QC_Sample_Value sv = new QC_Sample_Value(); sv.Sample_Lab_ID = -1; sv.CheckItemNcId = item.CheckItemNcId; sv.CheckItemCode = item.CheckItemCode; sv.CheckItemName = item.CheckItemName; sv.CheckItemUnit = item.CheckItemUnit; sv.CheckUser = item.CheckUser; sv.CheckTime = item.CheckTime; body2.Add(sv); } }
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); } } }
void LabTabs() { QC_SampleMix_ZhiYang_Table zyMix = new QC_SampleMix_ZhiYang_Table(); zyMix.LoadDataByWhere("SampleState=@SampleState and Mix_time>=@mixtime", 2, DateTime.Today); // label4.Text = zyMix.Count.ToString(); List <string> tabs = new List <string>(); foreach (var item in zyMixSamples.LabTable) { if ((item.CheckGroupType == "立刻检验" || item.CheckGroupType == "后续检验")) { if (!tabs.Contains(item.CheckGroupName)) { tabs.Add(item.CheckGroupName); } } } List <string> tabs2 = new List <string>(); foreach (XtraTabPage tabPage in xtraTabControl1.TabPages) { tabs2.Add(tabPage.Text); } bool xiangdeng = false; tabs.Sort(); tabs2.Sort(); if (tabs.Count == tabs2.Count) { xiangdeng = true; for (int i = 0; i < tabs.Count; i++) { if (tabs[i] != tabs2[i]) { xiangdeng = false; break; } } } if (!xiangdeng) { int oldIdx = xtraTabControl1.SelectedTabPageIndex; xtraTabControl1.TabPages.Clear(); foreach (var item in tabs) { xtraTabControl1.TabPages.Add(item); } int selIdx = 0; if (oldIdx >= 0 && oldIdx < xtraTabControl1.TabPages.Count) { selIdx = oldIdx; } xtraTabControl1.SelectedTabPageIndex = selIdx; } labTable.Empty(); if (xtraTabControl1.SelectedTabPage != null) { foreach (var item in zyMixSamples.LabTable) { if (item.CheckGroupName == xtraTabControl1.SelectedTabPage.Text) { labTable.Add(item); } } if (labTable.Count > 0) { this.gridView3.FocusedRowHandle = 0; } } }
private void 组批_Click(object sender, EventArgs e) { this.hjvehs.Save(); if (MessageBox.Show("确实要组批吗?", "提示", MessageBoxButtons.OKCancel) == DialogResult.OK) { Dictionary <string, List <QC_Sample_Veh> > vehFenzu = new Dictionary <string, List <QC_Sample_Veh> >(); vehFenzu.Clear(); foreach (var veh in hjvehs) { if (veh.zp) { string key = veh.MatPK + "_" + veh.SupplierCode; if (vehFenzu.ContainsKey(key)) { vehFenzu[key].Add(veh); } else { vehFenzu.Add(key, new List <QC_Sample_Veh>() { veh }); } } } foreach (var item in vehFenzu) { int xiaotongshu = item.Value.Count; int datongshu = 1; QC_Sample_Veh tempVeh = item.Value[0]; QC_Material matInfo = QC_Material.GetByCode(tempVeh.MatCode); if (matInfo != null) { if (xiaotongshu <= matInfo.BatchNum) { datongshu = 1; } else if (xiaotongshu % matInfo.BatchNum == 0) { datongshu = item.Value.Count / matInfo.BatchNum; } else if (xiaotongshu % matInfo.BatchNum != 0) { datongshu = item.Value.Count / matInfo.BatchNum + 1; } } if (datongshu > xiaotongshu) { datongshu = xiaotongshu; } Dictionary <int, List <int> > fp = FenZu(xiaotongshu, datongshu); foreach (var fpItem in fp) { List <QC_Sample_Veh> vehs = new List <QC_Sample_Veh>(); foreach (var xtHao in fpItem.Value) { QC_Sample_Veh tempVeh2 = item.Value[xtHao]; vehs.Add(tempVeh2); } if (vehs.Count > 0) { QC_Sample_Mix mix = new QC_Sample_Mix(); mix.WpCode = "0083"; mix.MatCode = vehs[0].MatCode; mix.MatPK = vehs[0].MatPK; mix.Mix_Time = DateTime.Now; mix.FangTong_Time = DateTime.Now; mix.ShouTong_Time = DateTime.Now; mix.ShouTong_User = LocalInfo.Current.user.ID; mix.FangTong_User = LocalInfo.Current.user.ID; mix.MixCount = vehs.Count; mix.MixPlanCount = vehs.Count; mix.SupplierCode = vehs[0].SupplierCode; mix.MixUser = LocalInfo.Current.user.ID; mix.SampleState = SampleState.组批完成; mix.SampleType = SampleType.普通样; mix.WLLX = vehs[0].WLLX; mix.CardID = Zhc.Data.DbContext.GetSeq("HB" + DateTime.Now.Date.ToString("yyyyMMdd"), 2); mix.Save(); hjmixs.Add(mix); foreach (var veh in vehs) { veh.Sample_Mix_ID = mix.Sample_Mix_ID; veh.Mix_Time = DateTime.Now; veh.SampleState = SampleState.组批完成; veh.Save(); } QC_Sample_Mix mixpb = new QC_Sample_Mix(); mixpb.MatCode = vehs[0].MatCode; mixpb.MatPK = vehs[0].MatPK; mixpb.WpCode = "0083"; mixpb.WLLX = vehs[0].WLLX; mixpb.Mix_Time = DateTime.Now; mixpb.FangTong_Time = DateTime.Now; mixpb.ShouTong_Time = DateTime.Now; mixpb.ShouTong_User = LocalInfo.Current.user.ID; mixpb.FangTong_User = LocalInfo.Current.user.ID; mixpb.MixCount = vehs.Count; mixpb.MixPlanCount = vehs.Count; mixpb.SupplierCode = vehs[0].SupplierCode; mixpb.MixUser = LocalInfo.Current.user.ID; mixpb.CardID = "PB" + mix.CardID.Remove(0, 2); mixpb.MainSampleMixId = mix.Sample_Mix_ID; mixpb.SampleType = SampleType.破包样; mixpb.SampleState = SampleState.组批完成; mixpb.Save(); } } } PrintZupi(); } }
//抽取 private void button8_Click(object sender, EventArgs e) { initTaskbill(); if (sample_selected.Count > 0) { MessageBox.Show("已勾选其他物料,请先处理"); return; } int cq = 0; long vehno = 0; sampleNum sm = new sampleNum(); sm.showDialogEx("ChouQu"); if (sm.DialogResult != DialogResult.OK) { MessageBox.Show("没有确认取样的个数"); return; } else { cq = sm.chouNum; vehno = sm.vehno; } if ((cq == 0)) { MessageBox.Show("没有确认取样的个数"); return; } if ((vehno == 0)) { MessageBox.Show("没有输入车号"); return; } sample_selected.LoadDataByWhere("vehno=@vehno order by fetchtime desc", vehno.ToString()); if (sample_selected.Count < 1) { MessageBox.Show("输入的车号不存在!!"); return; } DbEntityTable <QC_Sample_Mix> qc = new DbEntityTable <QC_Sample_Mix>(); for (int i = 0; i < cq; i++) { QC_Sample_Mix mix = new QC_Sample_Mix(); mix.WpCode = "Huoyun"; mix.MatCode = sample_selected[0].MatCode; mix.MatPK = sample_selected[0].MatPK; mix.Mix_Time = DateTime.Now; mix.FangTong_Time = DateTime.Now; mix.ShouTong_Time = DateTime.Now; mix.ShouTong_User = LocalInfo.Current.user.ID; mix.FangTong_User = LocalInfo.Current.user.ID; mix.MixCount = sample_selected.Count; mix.MixPlanCount = sample_selected.Count; mix.SupplierCode = sample_selected[0].SupplierCode; mix.MixUser = LocalInfo.Current.user.ID; mix.SampleState = SampleState.开始组批; mix.SampleType = SampleType.抽查样; mix.WLLX = sample_selected[0].WLLX; mix.StoreCode = Zhc.Data.DbContext.GetSeq("HY" + DateTime.Now.Date.ToString("yyyyMMdd"), 2); //记住主样id mix.MainSampleMixId = sample_selected[0].Sample_Mix_ID; //记住车id mix.NoticeBillId = sample_selected[0].Sample_Veh_ID.ToString(); qc.Add(mix); } qc.Save(); print(); //sample_selected[0].Sample_Mix_ID = mix.Sample_Mix_ID; //sample_selected[0].Mix_Time = DateTime.Now; //sample_selected[0].SampleType = SampleType.抽查样; //sample_selected[0].SampleState = SampleState.组批完成; //sample_selected[0].Save(); }
private void timer1_Tick(object sender, EventArgs e) { mixs.LoadDataByWhere("main.WLLX='石子' and main.SampleState=@SampleState", SampleState.初始状态); qvs.LoadDataByWhere("WLLX='石子' and status=7 order by begintime desc"); for (int j = 0; j < qvs.Count; j++) { bool cunzai = false; for (int m = 0; m < mixs.Count; m++) { if (qvs[j].CUSTCODE == mixs[m].SupplierCode && qvs[j].INVCODE == mixs[m].MatCode) { cunzai = true; QC_Sample_Veh sm = new QC_Sample_Veh(); sm.begintime = qvs[j].begintime; sm.WpCode = FrmMain.localinfo.workpoint.Code; //作业点编码 sm.FetchPerson = LocalInfo.Current.user.ID; //取样人ID sm.VehNo = qvs[j].Cph; //车牌号 sm.NoticeBillId = qvs[j].NoticeId; //磁卡作业单号 // sm.Sample_Mix_ID = 0; //混样ID sm.FetchTime = System.DateTime.Now; //取样时间 // sm.KouShui = StringTool.FNumVal(koushui.Text); // sm.KouZa = StringTool.FNumVal(kouza.Text); sm.WLLX = "石子"; sm.NcDhdBodyId = qvs[j].NcDhdBodyId; //车辆作业单主键 sm.MatCode = qvs[j].INVCODE; //物料编码 sm.MatName = qvs[j].INVNAME; sm.SupplierCode = qvs[j].CUSTCODE; //供应商编码 sm.SupplierName = qvs[j].CUSTNAME; sm.MatPK = qvs[j].PK_INVBASDOC; //物料主键 sm.NcDhdHeadNo = qvs[j].NcDhdHeadNo; //NC到货单 sm.Sample_Mix_ID = mixs[m].Sample_Mix_ID; sm.zpdh = mixs[m].CardID; sm.SampleState = SampleState.初始状态; sm.zptime = DateTime.Now.ToString(); vehs.Add(sm); DbContext.ExeSql("update tb_noticebill_head set status=8 where status=7 and noticebillid=@noticebillid", qvs[j].NoticeId); vehs.Save(); } } if (cunzai == false) { QC_Sample_Mix mix = new QC_Sample_Mix(); mix.WpCode = "0091"; mix.MatCode = qvs[j].INVCODE; mix.MatPK = qvs[j].PK_INVBASDOC; // mix.MixCount = vehs.Count; // mix.MixPlanCount = vehs.Count; mix.SupplierCode = qvs[j].CUSTCODE; mix.MixUser = LocalInfo.Current.user.ID; mix.SampleState = SampleState.初始状态; mix.SampleType = SampleType.普通样; mix.WLLX = qvs[j].WLLX; mix.CardID = Zhc.Data.DbContext.GetSeq("SZ" + DateTime.Now.Date.ToString("yyyyMMdd"), 2); mix.Save(); mixs.Add(mix); QC_Sample_Veh sm = new QC_Sample_Veh(); sm.begintime = qvs[j].begintime; sm.WpCode = FrmMain.localinfo.workpoint.Code; //作业点编码 sm.FetchPerson = LocalInfo.Current.user.ID; //取样人ID sm.VehNo = qvs[j].Cph; //车牌号 sm.NoticeBillId = qvs[j].NoticeId; //磁卡作业单号 // sm.Sample_Mix_ID = 0; //混样ID sm.FetchTime = System.DateTime.Now; //取样时间 // sm.KouShui = StringTool.FNumVal(koushui.Text); // sm.KouZa = StringTool.FNumVal(kouza.Text); sm.WLLX = "石子"; sm.NcDhdBodyId = qvs[j].NcDhdBodyId; //车辆作业单主键 sm.MatCode = qvs[j].INVCODE; //物料编码 sm.MatName = qvs[j].INVNAME; sm.SupplierCode = qvs[j].CUSTCODE; //供应商编码 sm.SupplierName = qvs[j].CUSTNAME; sm.MatPK = qvs[j].PK_INVBASDOC; //物料主键 sm.NcDhdHeadNo = qvs[j].NcDhdHeadNo; //NC到货单 sm.Sample_Mix_ID = mix.Sample_Mix_ID; sm.zpdh = mix.CardID; sm.SampleState = SampleState.初始状态; sm.zptime = DateTime.Now.ToString(); vehs.Add(sm); DbContext.ExeSql("update tb_noticebill_head set status=8 where status=7 and noticebillid=@noticebillid", qvs[j].NoticeId); vehs.Save(); } } }
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; }
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 { } }
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(); 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(); 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; } } }
private void 采集_Click(object sender, EventArgs e) { object JQCode = DbContext.ExecuteScalar("select max(JQCode) from QC_Sample_Jyjg where JYShebei='" + DeviceConfigManager.Instance.config.Jysb.ToString() + "'"); // object time = DbContext.ExecuteScalar("select max(date) from QC_Sample_Jyjg where JYShebei='" + DeviceConfigManager.Instance.config.Jysb.ToString() + "'"); // string str; if (DeviceConfigManager.Instance.config.Jysbsjk.EndsWith("AutoMac.mdb")) { if (!(JQCode is DBNull)) { str = "SELECT * FROM testresult where SerialNumber>'" + Convert.ToString(JQCode) + "'"; } else { str = "SELECT * FROM testresult where date>#" + DateTime.Now.AddHours(-24).ToString() + "#"; } } else { if (!(JQCode is DBNull)) { str = "SELECT * FROM SDS212 where AutoNmb>'" + Convert.ToString(JQCode) + "'"; } else { str = "SELECT * FROM SDS212 where testdate>#" + DateTime.Now.AddHours(-48).ToString() + "#"; } } string password = ""; if (DeviceConfigManager.Instance.config.Jysbsjk.EndsWith("AutoMac.mdb")) { password = "******"; } else { password = "******"; } OleDbConnection cn = new OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0; Data Source=" + DeviceConfigManager.Instance.config.Jysbsjk + ";Jet OLEDB:Database Password="******";Persist Security Info=False"); cn.Open(); OleDbCommand comm = new OleDbCommand(str, cn); OleDbDataReader dr = comm.ExecuteReader(); // test.Clear(); bool tuichu = true; int i = 0; foreach (var item in System.Diagnostics.Process.GetProcesses()) { if (item.ProcessName.StartsWith("AutoMac")) { tuichu = false; MessageBox.Show("请先退出工业分析仪程序"); return; } else if (item.ProcessName.StartsWith("SDS")) { tuichu = false; MessageBox.Show("请先退出硫分仪程序"); return; } } if (tuichu) { while (dr.Read()) { if (DeviceConfigManager.Instance.config.Jysbsjk.EndsWith("AutoMac.mdb")) { QC_Sample_Jyjg t = new QC_Sample_Jyjg(); t.CheckItemCode = "10011"; t.CheckItemName = "灰分"; t.JQCode = dr["SerialNumber"].ToString(); t.Date = Convert.ToDateTime(dr["Date"]).ToString("yyyy-MM-dd HH:mm:ss"); t.JYShebei = DeviceConfigManager.Instance.config.Jysb; t.SampleName = dr["SampleName"].ToString(); t.Value = dr["Ad"].ToString(); QC_Sample_Jyjg t1 = new QC_Sample_Jyjg(); t1.CheckItemCode = "10012"; t1.CheckItemName = "挥发分"; t1.JQCode = dr["SerialNumber"].ToString(); t1.Date = Convert.ToDateTime(dr["Date"]).ToString("yyyy-MM-dd HH:mm:ss"); t1.JYShebei = DeviceConfigManager.Instance.config.Jysb; t1.SampleName = dr["SampleName"].ToString(); t1.Value = Convert.ToDecimal(dr["Vdaf"]).ToString("0.0"); QC_Sample_Jyjg t2 = new QC_Sample_Jyjg(); t2.CheckItemCode = "10016"; t2.CheckItemName = "固定碳"; t2.JQCode = dr["SerialNumber"].ToString(); t2.Date = Convert.ToDateTime(dr["Date"]).ToString("yyyy-MM-dd HH:mm:ss"); t2.JYShebei = DeviceConfigManager.Instance.config.Jysb; t2.SampleName = dr["SampleName"].ToString(); t2.Value = dr["Fcad"].ToString(); test.Add(t); test.Add(t1); test.Add(t2); i += 3; } else { QC_Sample_Jyjg t = new QC_Sample_Jyjg(); t.CheckItemCode = "10002"; t.CheckItemName = "S"; t.JQCode = dr["AutoNmb"].ToString(); t.Date = Convert.ToDateTime(dr["TestDate"]).ToString("yyyy-MM-dd") + " " + Convert.ToDateTime(dr["TestTime"]).ToString("HH:mm:ss"); t.JYShebei = DeviceConfigManager.Instance.config.Jysb; t.SampleName = dr["Name"].ToString(); t.Value = dr["Stad"].ToString(); test.Add(t); i++; } } } test.Save(); cn.Close(); test.LoadDataByWhere("shangchuan=0 and JYShebei='" + DeviceConfigManager.Instance.config.Jysb + "' and Date>'" + DateTime.Now.AddHours(-24).ToString("yyyy-MM-dd HH:mm:ss") + "' order by CheckItemCode asc,date desc"); MessageBox.Show(i.ToString() + "条数据采集完成"); this.gridControl1.DataSource = test; }
private void gridView1_FocusedRowObjectChanged(object sender, DevExpress.XtraGrid.Views.Base.FocusedRowObjectChangedEventArgs e) { if (SelectedMixSample != null && SelectedMixSample.DataState != DataRowState.Unchanged) { DialogResult result = MessageBox.Show("当前数据已修改,是否保存?", "询问", MessageBoxButtons.YesNoCancel); if (result == DialogResult.Yes) { SaveSample(); } else if (result == DialogResult.No) { this.SelectedMixSample.VehSamples.RejectChanges(); this.SelectedMixSample.CheckVals.RejectChanges(); this.SelectedMixSample.RejectChanges(); } else { return; } } SelectedMixSample = e.Row as QC_Sample_Mix; if (SelectedMixSample != null) { DbEntityTable <QC_QualityRule_View> quality = new DbEntityTable <QC_QualityRule_View>(); quality.LoadDataByWhere("MATNCID=@MATNCID and LocalQcLevel='一级' and suppliercode=@suppliercode", SelectedMixSample.MatPK, SelectedMixSample.SupplierCode); if (quality.Count == 0) { quality.LoadDataByWhere("MATNCID=@MATNCID and QualityLevelName='合格' and suppliercode=@suppliercode", SelectedMixSample.MatPK, SelectedMixSample.SupplierCode); } if (quality.Count == 0) { quality.LoadDataByWhere("MATNCID=@MATNCID and LocalQcLevel='一级'", SelectedMixSample.MatPK); if (quality.Count == 0) { quality.LoadDataByWhere("MATNCID=@MATNCID and QualityLevelName='合格'", SelectedMixSample.MatPK); } } foreach (var it in SelectedMixSample.CheckVals) { DbEntityTable <QC_QualityRule_View> qualityhege = new DbEntityTable <QC_QualityRule_View>(); if (it.CheckVal != "") { foreach (var item in quality) { if (item.CheckItemCode == it.CheckItemCode) { qualityhege.Add(item); } } if (qualityhege.Count == 1 && !GetBool(it.CheckVal + qualityhege[0].Relation + qualityhege[0].ConstraintVal)) { it.VisIdx = 100000; } else if (qualityhege.Count == 2 && (!GetBool(it.CheckVal + qualityhege[0].Relation + qualityhege[0].ConstraintVal) || !GetBool(it.CheckVal + qualityhege[1].Relation + qualityhege[1].ConstraintVal))) { it.VisIdx = 100000; } } } } }
private void 新增_Click(object sender, EventArgs e) { QC_Sample_zdpdyj i = new QC_Sample_zdpdyj(); yjs.Add(i); }