private void WP_Kuaikuangqy_Load(object sender, EventArgs e) { vehs.LoadDataByWhere("main.WLLX='石子' and main.SampleState=@SampleState", SampleState.初始状态); mixs.LoadDataByWhere("main.WLLX='石子' and main.SampleState=@SampleState", SampleState.初始状态); this.qC_Sample_VehBindingSource.DataSource = vehs; this.qCSampleMixBindingSource.DataSource = mixs; }
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 添加检验项目_Load(object sender, EventArgs e) { if (MatNcId != null && MatNcId != "") { check.LoadDataByWhere("MatNcId=@MatNcId", MatNcId); this.qCMatAllCheckItemBindingSource.DataSource = check; } }
private void _Click(object sender, EventArgs e) { int i = 0; StringBuilder sb = new StringBuilder(); try { 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); if (vals.Count > 0) { foreach (var it in vals) { if (it.CheckItemName == item.CheckItemName && (it.CheckVal == "" || it.CheckVal == null)) { it.CheckVal = item.Value; item.Shangchuan = true; i++; sb.Append("单号:" + item.SampleName + "," + "检验项目" + item.CheckItemName + "上传成功"); sb.Append("\r\n"); } } vals.Save(); } } } } test.Save(); } catch (Exception ex) { MessageBox.Show(ex.ToString()); } if (i > 0) { MessageBox.Show(i.ToString() + "条数据上传完成" + "\r\n" + sb.ToString()); } else { MessageBox.Show("没有可匹配项目"); } reloadData(); }
private void btnRefresh_Click(object sender, EventArgs e) { rjmixs.LoadDataByWhere("main.SAMPLESTATE=@SAMPLESTATE and main.WLLX='熔剂'", SampleState.组批完成); comboBox1.Items.Clear(); foreach (var item in rjmixs) { comboBox1.Items.Add(QC_Sample_Mix.ShortStoreCode(item.CardID)); } zyMixSamples.LoadZyAllData(workpointCode); LabTabs(); }
private void WP_Jianyan_Load(object sender, EventArgs e) { lableiji.LoadInfo = "CheckVals"; this.qCSampleLabBindingSource.DataSource = lableiji; lableiji.LoadDataByWhere("main.BillType=@BillType and main.WLLX='火运' order by main.JyTime desc", "开始检验"); labTable1.LoadDataByWhere("main.labstate='火运' and main.checkgroupname like '化验样%' and main.maketime>=@maketime and main.WLLX='火运'", 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(); }
private void 查询_Click(object sender, EventArgs e) { if (!(textBox1.Text == "")) { data.LoadDataByWhere("CUSTCODE='" + textBox1.Text + "'"); } else if (!(textBox2.Text == "")) { data.LoadDataByWhere("CUSTSHORTNAME like '%" + textBox2.Text + "%'"); } }
private void simpleButton1_Click(object sender, EventArgs e) { if (this.comboBoxEdit1.SelectedItem.ToString() == "全部") { cxs.LoadDataByWhere("取样时间>=@取样时间小 and 取样时间<=@取样时间大", this.dateEdit1.DateTime, this.dateEdit2.DateTime); } else { cxs.LoadDataByWhere("取样时间>=@组批时间小 and 取样时间<=@取样时间大 and 车牌号 like @车牌号", this.dateEdit1.DateTime, this.dateEdit2.DateTime, "%" + this.comboBoxEdit1.SelectedItem + "%"); } this.bCXGCXBindingSource.DataSource = cxs; }
private void loadData() { pici.LoadInfo = "CheckVals"; pici.LoadDataByWhere("main.BillType=@BillType and main.CheckGroupType='后续检验' order by main.JyCode desc", "检验完成"); foreach (var item in pici) { mcg.LoadDataByWhere("main.Sample_Lab_ID=@Sample_Lab_ID", item.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); item.MatName = wl[0].INVNAME; } }
private void loadData() { pici.LoadInfo = "CheckVals"; // if (FrmMain.localinfo.workpoint.Code == "0077") pici.LoadDataByWhere("main.BillType=@BillType and main.CheckGroupType='后续检验' and main.WLLX='外矿' order by main.JyCode desc", "检验完成"); //else if (FrmMain.localinfo.workpoint.Code == "0078") // pici.LoadDataByWhere("main.BillType=@BillType and main.CheckGroupType='后续检验' and main.WLLX='煤' order by main.JyCode desc", "检验完成"); foreach (var item in pici) { mcg.LoadDataByWhere("main.Sample_Lab_ID=@Sample_Lab_ID", item.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); item.MatName = wl[0].INVNAME; } }
/// <summary> /// 初始化NC到货单 /// </summary> public void initArrivebill() { arrivebill = new DbEntityTable <View_arrivebill>(); arrivebill.LoadDataByWhere(" 1=1 order by vdef5,custname,invname,varrordercode desc"); string[] leibie = cmbHCPH.Text.Trim().Split('_'); if (leibie.Count() != 2) { gridControl3.DataSource = arrivebill; } else { string fazhan = leibie[0].ToString(); if (arrivebill.Where(o => o.vdef5 == fazhan).Count() > 0) { gridControl3.DataSource = arrivebill.Where(o => o.vdef5 == fazhan).ToList(); } else { gridControl3.DataSource = arrivebill; } } // gridControl3.DataSource = arrivebill; }
//收桶 private void simpleButton3_Click(object sender, EventArgs e) { DbEntityTable <QC_Sample_Mix> qcvhs = new DbEntityTable <QC_Sample_Mix>(); qcvhs.LoadDataByWhere("main.WpCode='" + workpointCode + "' and main.SampleState =@SampleState and main.ShouTong_Time is null and main.WLLX='煤'", SampleState.组批完成); foreach (var qcvh in qcvhs) { // qcvh.TempID = 0; qcvh.ShouTong_Time = System.DateTime.Now; // qcvh.SampleState = SampleState.开始制样; qcvh.Save(); //解绑小卡 DbEntityTable <QC_Sample_Veh> vehcrds = new DbEntityTable <QC_Sample_Veh>(); vehcrds.LoadDataByWhere("main.SAMPLE_MIX_ID=@SAMPLE_MIX_ID", qcvh.Sample_Mix_ID); foreach (var veh in vehcrds) { DbEntityTable <QC_IC_Info> hycrds = new DbEntityTable <QC_IC_Info>(); hycrds.LoadDataByWhere("CARDID=@CARDID", veh.CardID); foreach (var qcic in hycrds) { qcic.SampleId = 0; qcic.Save(); } } } // 更新显示信息 DbEntityTable <BC_DT_State> dtwzs = new DbEntityTable <BC_DT_State>(); dtwzs.LoadDataByWhere("WpCode='" + workpointCode + "' and SHOUTONG_TIME IS NULL and WLLX='煤'"); this.bCDTStateBindingSource.DataSource = dtwzs; qyts ts = new qyts("收桶成功!可以送去制样!"); ts.ShowDialog(); }
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) { foreach (var item in mixs) { if (item.WCQY == true) { DbEntityTable <QC_Sample_Veh> itemvehs = new DbEntityTable <QC_Sample_Veh>(); itemvehs.LoadDataByWhere("main.Sample_Mix_ID=@Sample_Mix_ID", item.Sample_Mix_ID); item.Mix_Time = DateTime.Now; item.FangTong_Time = DateTime.Now; item.ShouTong_Time = DateTime.Now; item.ShouTong_User = LocalInfo.Current.user.ID; item.FangTong_User = LocalInfo.Current.user.ID; item.MixCount = itemvehs.Count; item.MixPlanCount = itemvehs.Count; item.MixUser = LocalInfo.Current.user.ID; item.SampleState = SampleState.组批完成; item.Save(); foreach (var it in itemvehs) { it.Mix_Time = DateTime.Now; it.SampleState = SampleState.组批完成; it.Save(); } } } vehs.LoadDataByWhere("main.WLLX='石子' and main.SampleState=@SampleState", SampleState.初始状态); mixs.LoadDataByWhere("main.WLLX='石子' and main.SampleState=@SampleState", SampleState.初始状态); }
private void DlgMaterial_Load(object sender, EventArgs e) { matFlView.LoadDataByWhere("invclasscode like '1%'"); this.treeList1.DataSource = matFlView; this.gridMaterial.DataSource = materialView; }
private void UC_WpRoute_Load(object sender, EventArgs e) { wpRoutes.LoadDataByWhere("wc.WCTypeId='02' or wc.WCTypeId='21'"); selecteRoutes.LoadDataByWhere("wc.WCTypeId='21' or wc.WCTypeId='22' "); this.qCWpRouteBindingSource.DataSource = wpRoutes; this.qCWpRouteBindingSource1.DataSource = selecteRoutes; wpRoutes.ListChanged += wpRoutes_ListChanged; }
private void DlgCheckGroup_Load(object sender, EventArgs e) { checkGroups.LoadDataByWhere("CheckGroupType='留存样' or CheckGroupType='中间样' "); if (curTable != null) { checkGroups.Filter((cg) => !curTable.Contains(cg.CheckGroupCode)); } this.qCCheckGroupBindingSource.DataSource = checkGroups; }
public void initDanHao() { mixDanHao.LoadDataByWhere("main.samplestate = @samplestate and main.wllx=@wllx and main.cardid='' and main.matpk in (SELECT MATNCID FROM QC_Material WHERE WLLX = '煤') ", Xg.Lab.Sample.SampleState.组批完成, "火运"); foreach (var item in mixDanHao) { item.StoreCode = QC_Sample_Mix.ShortStoreCode(item.StoreCode); } gridControl2.DataSource = mixDanHao; }
private void Hunyang_Load(object sender, EventArgs e) { isfangtong = false; DbEntityTable <BC_DT_State> dtwzs = new DbEntityTable <BC_DT_State>(); dtwzs.LoadDataByWhere("WpCode='" + workpointCode + "' and SHOUTONG_TIME IS NULL and WLLX='煤'"); this.bCDTStateBindingSource.DataSource = dtwzs; }
private void printDocument2_PrintPage(object sender, System.Drawing.Printing.PrintPageEventArgs e) { List <ZupiData> printData = new List <ZupiData>(); foreach (var mix in hjmixs) { List <string> vehnos = new List <string>(); DbEntityTable <QC_Sample_Veh> vehs = new DbEntityTable <QC_Sample_Veh>(); vehs.LoadDataByWhere("main.Sample_Mix_ID=@Sample_Mix_ID", mix.Sample_Mix_ID); foreach (var item in vehs) { vehnos.Add(QC_Sample_Mix.ShortStoreCode(item.CardID)); } if (vehnos.Count > 0) { ZupiData zd = new ZupiData(); zd.Head = QC_Sample_Mix.ShortStoreCode(mix.CardID); zd.ZupiItems = vehnos; printData.Add(zd); ZupiData pbzd = new ZupiData(); pbzd.Head = QC_Sample_Mix.ShortStoreCode("PB" + mix.CardID.Remove(0, 2)); pbzd.ZupiItems = vehnos; printData.Add(pbzd); } } int totalPage = 1; foreach (var item in printData) { item.BeginPage = totalPage; totalPage += item.NeadPage; } int printPage = totalPage - curZupiPrintPage; foreach (var item in printData) { if (printPage >= item.BeginPage && printPage < item.EndPage) { item.Print(e.Graphics, printPage); break; } } if (curZupiPrintPage < totalPage - 1) { curZupiPrintPage++; e.HasMorePages = true; } else { curZupiPrintPage = 1; e.HasMorePages = false; } }
/// <summary> /// 初始化任务单 /// </summary> public void initTaskbill() { sample_selected.LoadDataByWhere("samplestate = @samplestate and wllx=@wllx", Xg.Lab.Sample.SampleState.开始组批, "火运"); if (sample_selected.Count > 0) { hcph = sample_selected[0].CardID; matname = sample_selected[0].rwdh; ncdhd = sample_selected[0].NcDhdHeadNo; fazhan = sample_selected[0].zpdh; lbtask.Text = "等待取样的火车:" + hcph; } else { hcph = ""; matname = ""; ncdhd = ""; fazhan = ""; lbtask.Text = "请勾选物料到货单!"; } }
/// <summary> /// 初始化集中计量火车表格 /// </summary> public void initHCgrid() { if (cmbHCPH.Text.Trim() == "") { sample_unselect.LoadDataByWhere("wllx='火运' and samplestate=@samplestate order by begintime ", Xg.Lab.Sample.SampleState.初始状态); } else { string[] leibie = cmbHCPH.Text.Trim().Split('_'); if (leibie.Count() != 2) { return; } string fazhan = leibie[0].ToString(); string wuliao = leibie[1].ToString(); sample_unselect.LoadDataByWhere("wllx='火运' and samplestate=@samplestate and zpdh=@zpdh and rwdh=@rwdh order by fetchplace ", Xg.Lab.Sample.SampleState.初始状态, fazhan, wuliao); } gridControl1.DataSource = sample_unselect; // bstrain.DataSource = sample_unselect; }
private void LoadData() { // QC_Sample_Mix.UpdateSampleState(); //if(FrmMain.localinfo.workpoint.Code=="0075") mixSamples.LoadDataByWhere(string.Format("main.SampleState>={0} and main.SampleState<{1} and main.WLLX='石子' order by main.ZyRecvTime,main.mix_time", (int)SampleState.开始制样, (int)SampleState.NC报检完成)); //else if(FrmMain.localinfo.workpoint.Code=="0076") // mixSamples.LoadDataByWhere(string.Format("main.SampleState>={0} and main.SampleState<{1} and main.WLLX='煤' order by main.ZyRecvTime,main.mix_time", (int)SampleState.开始制样, (int)SampleState.NC报检完成)); // LoadDataByWhere("SampleState>=@BeginSampleState And SampleState<@EndSampleState", SampleState.开始组批, SampleState.上传完成); //mixSamples.Sort((s1, s2) => // { // int result = s1.Riqi.CompareTo(s2.Riqi); // if (result == 0) // result = s1.ZyDanHao.CompareTo(s2.ZyDanHao); // return result; // } // ); }
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; }
private void simpleButton1_Click(object sender, EventArgs e) { zupi(); // 更新显示信息 DbEntityTable <BC_DT_State> dtwzs = new DbEntityTable <BC_DT_State>(); dtwzs.LoadDataByWhere("WpCode='" + workpointCode + "' and SHOUTONG_TIME IS NULL and WLLX='煤'"); this.bCDTStateBindingSource.DataSource = dtwzs; QC_Sample_Mix.UpdateInspectMainSample(); qyts ts = new qyts("组批成功!下一步放小样!"); ts.ShowDialog(); }
private void koushuikouza_Load(object sender, EventArgs e) { vehs.LoadDataByWhere("main.Sample_Mix_ID=@Sample_Mix_ID", samplemixid); mixs.LoadDataByWhere("main.Sample_Mix_ID=@Sample_Mix_ID or main.MainSampleMixId=@MainSampleMixId", samplemixid, samplemixid); foreach (var item in mixs) { item.Memo = textBox1.Text; } mixs.Save(); this.qCSampleVehBindingSource.DataSource = vehs; labelzydh.Text = QC_Sample_Mix.ShortStoreCode(zydanhao); }
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("没有可匹配项目"); } }
public static QC_ChgWater GetByMatCust(string matNcId, string custCode) { DbEntityTable <QC_ChgWater> table = new DbEntityTable <QC_ChgWater>(); table.LoadDataByWhere("MatNcId=@MatNcId and CustCode=@CustCode", matNcId, custCode); if (table.Count > 0) { return(table[0]); } else { return(null); } }
public static QC_NoticeDhdItem_View GetByNoticeId(string noticeId) { DbEntityTable <QC_NoticeDhdItem_View> noticeDhd = new DbEntityTable <QC_NoticeDhdItem_View>(); noticeDhd.LoadDataByWhere("NoticeId=@NoticeId", noticeId); if (noticeDhd.Count > 0) { return(noticeDhd[0]); } else { return(null); } }
private void btnLoadVehData_Click(object sender, EventArgs e) { string code = txtStoreCode.Text.Trim(); if (string.IsNullOrEmpty(code)) { MessageBox.Show("不能为空"); return; } string dh = QC_Sample_Mix.GetZyDanHao(code); if (dh != "") { Samples.LoadDataByWhere("main.ZyDanHao=@ZyDanHao", dh); mixgroups.LoadDataByWhere("main.Sample_mix_id=@Sample_mix_id and main.checkgroupname='角质层Y'", Samples[0].Sample_Mix_ID); if (mixgroups.Count > 0) { int labid = mixgroups[0].Sample_Lab_ID; mixgroups.LoadDataByWhere("main.Sample_lab_id=@Sample_lab_id and main.checkgroupname='角质层Y'", labid); this.qCMixCheckGroupBindingSource.DataSource = mixgroups; } DbEntityTable <QC_Sample_Mix> curDatalist = new DbEntityTable <QC_Sample_Mix>(); curDatalist.LoadDataByWhere("parent.ZyDanHao=@MainSampleZyDanHao and main.Sampletype=@Sampletype", dh, SampleType.检样); if (curDatalist.Count > 0) { this.curData = curDatalist[0]; } this.curData.CheckItems.LoadDataBySampleMixId(this.curData.Sample_Mix_ID); this.sourceCurData.DataSource = curData; } }