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(); }
/// <summary> /// 勾兑火车物料到货单 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void button1_Click(object sender, EventArgs e) { var view3 = gridView3; View_arrivebill bill = view3.GetFocusedRow() as View_arrivebill; if (bill == null) { MessageBox.Show("没有NC到货单!"); return; } if (MessageBox.Show("请确认勾选的是" + bill.custname + "的" + bill.invname, "提示", MessageBoxButtons.YesNo) == DialogResult.No) { return; } initTaskbill(); if (!checkMat()) { MessageBox.Show("请检查物料、到货单,必须是同一物料、同一到货单", "提示", MessageBoxButtons.OK, MessageBoxIcon.Error); return; } //QC_Sample_Veh train = view.GetRow(0) as QC_Sample_Veh; //var hc= train.CardID; //if (hcph != "" && hc != hcph) //{ // MessageBox.Show("请先取样:"+hcph); // return; //} foreach (var item in sample_unselect) { if (item.zp) { //状态 0 改变成1 item.SampleState = Xg.Lab.Sample.SampleState.开始组批; item.WpCode = "HYQY"; item.MatCode = bill.invcode; item.MatPK = bill.cbaseid; item.NcDhdHeadNo = bill.varrordercode; item.SupplierCode = bill.custcode; //取样人 item.FetchPerson = LocalInfo.Current.user.ID; //取样时间 item.FetchTime = DateTime.Now; } } sample_unselect.Save(); initview(); //gridControl1.DataSource = trainData; }
/// <summary> /// 删除磁扣信息 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void tsmBtn_DeleteCard_Click(object sender, EventArgs e) { QC_IC_Info bill = getSelectedBill(); if (bill == null) { MessageBox.Show("没有选定数据"); return; } if (bill.SampleId > 0) { MessageBox.Show("磁扣已经绑定数据,需要先解除绑定,才能删除。"); return; } if (MessageBox.Show("您确实要删除数据吗?", "提示", MessageBoxButtons.OKCancel) == DialogResult.OK) { icInfoDatas.Remove(bill); icInfoDatas.Save(); MessageBox.Show("删除数据完成"); } }
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); }
public void print() { initPrintbill(); //printPreviewDialog1.ShowDialog(); printDocument1.Print(); //打印完成后,大样状态从开始组批变为组批完成 foreach (var mix in printbill) { mix.SampleState = SampleState.组批完成; } printbill.Save(); //刷新任务单 initTaskbill(); }
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("没有可匹配项目"); } }
/// <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(); } }
private void 通过审核_Click(object sender, EventArgs e) { if (curLab != null) { curLab.Billtype = "审核通过"; curLab.LabState = "审核通过"; foreach (var item in curLab.CheckVals) { item.Auditor = FrmMain.localinfo.user.Name; item.AuditTime = DateTime.Now; } curLab.SaveCheckVals = true; pici.Save(); loadData(); } else { MessageBox.Show("没有选择数据"); } }
private void btnOk_Click(object sender, EventArgs e) { data.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(); } } }
/// <summary> /// 重新勾兑 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void button6_Click_1(object sender, EventArgs e) { if (MessageBox.Show("确认要进行重新勾兑吗", "确认", MessageBoxButtons.YesNo) == DialogResult.No) { return; } if (hcph != "") { MessageBox.Show("请先打印已勾选的火车"); return; } if (cmbHCPH.Text.Trim() == "") { MessageBox.Show("请输入火车勾号"); return; } //else //{ // sample_unselect.LoadDataByWhere("wllx='火运' and cardid=@cardid order by begintime", cmbHCPH.Text.Trim()); //} //foreach (var item in sample_unselect) //{ // item.SampleState = Xg.Lab.Sample.SampleState.初始状态; // item.WpCode = ""; // item.MatCode = ""; // item.MatPK = ""; // item.NcDhdHeadNo = ""; // item.SupplierCode = ""; // //取样人 // item.FetchPerson = LocalInfo.Current.user.ID; // //取样时间 // item.FetchTime = DateTime.Now; // item.zp = false; //} //sample_unselect.Save(); //bstrain.DataSource = sample_unselect; if (!checkMat()) { MessageBox.Show("请检查物料、到货单,必须是同一物料、同一到货单"); return; } var view3 = gridView3; View_arrivebill bill = view3.GetFocusedRow() as View_arrivebill; if (bill == null) { MessageBox.Show("没有NC到货单!"); return; } foreach (var item in sample_unselect) { if (item.zp) { //item.SampleState = Xg.Lab.Sample.SampleState.开始组批; //item.WpCode = "HYQY"; item.MatCode = bill.invcode; item.MatPK = bill.cbaseid; item.NcDhdHeadNo = bill.varrordercode; item.SupplierCode = bill.custcode; //取样人 item.FetchPerson = item.FetchPerson + "~~" + LocalInfo.Current.user.ID; //取样时间 item.FetchTime = DateTime.Now; } } sample_unselect.Save(); DbEntityTable <QC_Sample_Mix> dbmix = new DbEntityTable <QC_Sample_Mix>(); dbmix.LoadDataByWhere("main.sample_mix_id in ( select distinct(sample_mix_id) from qc_sample_veh where cardid='" + cmbHCPH.Text.Trim() + "')"); foreach (var item in dbmix) { //item.SampleState = SampleState.处理完成; item.MatCode = bill.invcode; item.MatPK = bill.cbaseid; item.SupplierCode = bill.custcode; } dbmix.Save(); initview(); MessageBox.Show("操作成功!"); }
private void btnSave_Click(object sender, EventArgs e) { checkGroup.Save(); btnSave.Enabled = false; MessageBox.Show("保存完成"); }
private void button1_Click(object sender, EventArgs e) { vehs.Save(); }
private void btnSave_Click(object sender, EventArgs e) { wpRoutes.Save(); btnSave.Enabled = false; }
private void 确定_Click(object sender, EventArgs e) { vehs.Save(); this.Close(); }
/// <summary> /// 绑扣 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void button9_Click(object sender, EventArgs e) { if (CardID == "") { MessageBox.Show("请刷扣"); return; } DbEntityTable <QC_IC_Info> hycrds = new DbEntityTable <QC_IC_Info>(); hycrds.LoadDataByWhere("CardID=@CardID and CardType=@CardType ", CardID, "CUT002"); if (hycrds.Count == 0) { CardID = ""; label2.Text = "该扣类型不对!"; label2.ForeColor = Color.Red; return; } var view = gridView2; if (mixDanHao.Count < 1) { MessageBox.Show("没有大样单号!请刷新"); return; } QC_Sample_Mix bill = view.GetFocusedRow() as QC_Sample_Mix; if (bill == null) { MessageBox.Show("没有大样单号!"); return; } bill.CardID = CardID; bill.StoreCode = QC_Sample_Mix.FullStoreCode(bill.StoreCode); IDbConnection conn = DbContext.GetDefaultConnection(); conn.Open(); IDbTransaction trans = conn.BeginTransaction(); bill.Save(trans); foreach (var qcic in hycrds) { qcic.SampleId = bill.Sample_Mix_ID; } hycrds.Save(trans); trans.Commit(); conn.Close(); label2.Text = ""; CardID = ""; //foreach (var item in mixDanHao) //{ // if (item.Sample_Mix_ID == bill.Sample_Mix_ID) // { // item.CardID = CardID; // item.StoreCode = QC_Sample_Mix.FullStoreCode(bill.StoreCode); // break; // } //} //mixDanHao.Save(); initDanHao(); }
private void btnSave_Click(object sender, EventArgs e) { data.Save(); MessageBox.Show("保存完成"); }
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 保存_Click(object sender, EventArgs e) { yjs.Save(); MessageBox.Show("保存成功"); }
//抽取 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(); }
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 { } }