/// <summary> /// 删除抽查样 /// </summary> private void tsmBtnDelete_Click(object sender, EventArgs e) { QC_Sample_Mix selData = sourceAllInpsectSamples.Current as QC_Sample_Mix; if (selData != null) { int sampleState = Convert.ToInt32(DbContext.ExecuteScalar("Select SampleState From QC_Sample_Mix where Sample_Mix_ID=" + selData.Sample_Mix_ID)); if (sampleState >= 3) { MessageBox.Show("已经制样,不能再删除"); return; } if (MessageBox.Show("确实要删除此抽查样吗?", "提示", MessageBoxButtons.OKCancel) == DialogResult.OK) { if (selData == curData) { CreateSample(); } sourceAllInpsectSamples.RemoveCurrent(); selData.SaveCheckItems = true; examineSamples.Save(); } } else { MessageBox.Show("没有选中数据", "提示"); } }
private void CreateSample() { curData = new QC_Sample_Mix(); this.sourceCurData.DataSource = curData; // SetCheckItems(); }
private void 查询_Click(object sender, EventArgs e) { string storecode = textBox1.Text.Trim(); if (!string.IsNullOrEmpty(storecode)) { bool find = false; string jydh = QC_Sample_Mix.FullStoreCode(storecode); foreach (var item in this.lableiji) { if (item.JyCode == jydh) { this.curLab = item; find = true; break; } } if (find == false) { MessageBox.Show("未查到数据"); } // curLab.CheckVals.LoadDataByWhere("main.Sample_Lab_ID=@Sample_Lab_ID", curLab.Sample_Lab_ID); SetGridViewFocuse(); } }
private void button1_Click(object sender, EventArgs e) { bool cunzai = false; QC_Sample_Mix curData = GetCurData(); if (curData != null && textBox1.Text != null && textBox2.Text != null) { QC_MixCheckItem a = new QC_MixCheckItem(); a.CheckItemCode = textBox2.Text; a.CheckItemName = textBox1.Text; a.Sample_Mix_ID = curData.Sample_Mix_ID; a.Source = "特殊添加"; a.CheckItemNcId = textBox3.Text; a.CheckItemUnit = textBox4.Text; foreach (var item in curData.AddCheckItems) { if (item.CheckItemCode == textBox2.Text) { cunzai = true; } } if (cunzai == true) { MessageBox.Show("该检验项目已经存在"); } else if (a.CheckItemCode != null && a.CheckItemCode != "" && a.CheckItemName != null && a.CheckItemName != "") { curData.AddCheckItems.Add(a); curData.AddCheckItems.Save(); } textBox1.Text = null; textBox2.Text = null; } }
/// <summary> /// 查找留存样 /// </summary> 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 == "") { MessageBox.Show("对不起,不认识您录入的字符串格式"); return; } QC_Sample_Mix sample = QC_Sample_Mix.GetByZydh(dh); if (sample != null) { curData.CopyData(sample); } else { MessageBox.Show("没有找到"); } }
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 gridView1_FocusedRowObjectChanged(object sender, DevExpress.XtraGrid.Views.Base.FocusedRowObjectChangedEventArgs e) { QC_Sample_Mix mix = e.Row as QC_Sample_Mix; if (mix != null) { vehs.LoadDataByWhere("main.Sample_mix_id=@Sample_mix_id", mix.Sample_Mix_ID); } }
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 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; } }
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 查询组批_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(); } } } } }
private void btnOk_Click(object sender, EventArgs e) { QC_Sample_Mix selectedSample = this.qCSampleMixBindingSource.Current as QC_Sample_Mix; if (selectedSample == null) { MessageBox.Show("没有选择数据"); return; } DialogResult = DialogResult.OK; this.Close(); }
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 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 WP_Zhiyangdan_Load(object sender, EventArgs e) { zyMixSamples.LoadZyAllData(workpointCode); this.qCSampleMixZhiYangBindingSource.DataSource = zyMixSamples; this.qCSampleLabBindingSource1.DataSource = labTable; LabTabs(); 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)); } }
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> /// 保存 /// </summary> private void btnSave_Click(object sender, EventArgs e) { QC_Sample_Mix sample = this.curData; veh.LoadDataByWhere("NoticeBillId=@NoticeBillId", this.curData.NoticeBillId); if (string.IsNullOrEmpty(sample.NoticeBillId)) { MessageBox.Show("没有车辆信息,不能保存。"); return; } if (string.IsNullOrEmpty(sample.CardID)) { MessageBox.Show("还没有刷卡。"); return; } if (veh.Count > 0) { sample.WLLX = veh[0].WLLX; } //if (veh[0].WLLX == "火运") //{ sample.NoticeBillId = veh[0].Sample_Veh_ID.ToString(); } sample.SampleType = SampleType.抽查样; sample.Sample_Cylx = this.Cylx; sample.MixCount = 1; sample.MixPlanCount = 1; sample.SampleState = SampleState.组批完成; sample.Sample_TBZD = true; sample.ShouTong_User = LocalInfo.Current.user.ID; sample.ShouTong_Time = DateTime.Now; if (sample.DataState == DataRowState.Added) { sample.MixUser = LocalInfo.Current.user.ID; sample.Mix_Time = DateTime.Now; examineSamples.Insert(0, sample); } sample.SaveCheckItems = true; sample.Save(); btnUnBindCard.Visible = false; CreateSample(); QC_Sample_Mix.UpdateInspectMainSample(); MessageBox.Show("保存完成"); }
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(); } } } }
//private void SetCheckItems() //{ // allCheckItem.Empty(); // foreach (var item in allCheckItem_back) // { // bool find = false; // foreach (var ci in curData.CheckItems) // { // if (ci.CheckItemNcId == item.CheckItemNcId) // { // find = true; // break; // } // } // if (!find) // { // item.SetDataStateAsAdded(); // allCheckItem.Add(item); // } // } //} /// <summary> /// 修改抽查样 /// </summary> private void tsmBtnUpdate_Click(object sender, EventArgs e) { QC_Sample_Mix selData = sourceAllInpsectSamples.Current as QC_Sample_Mix; if (selData != null) { selData.CheckItems.LoadDataByWhere("Sample_Mix_ID=@Sample_Mix_ID", selData.Sample_Mix_ID); this.curData = selData; this.sourceCurData.DataSource = this.curData; //SetCheckItems(); curData.SaveEnable = false; btnUnBindCard.Visible = false; } else { MessageBox.Show("没有选中数据"); } }
/// <summary> /// 查找留存样 /// </summary> private void btnLoadVehData_Click(object sender, EventArgs e) { QC_Sample_Mix sample = null; DbEntityTable <QC_MixCheckGroup> mixCgrp = new DbEntityTable <QC_MixCheckGroup>(); mixCgrp.LoadDataByWhere("main.StoreCode=@StoreCode", txtStoreCode.Text.Trim()); if (mixCgrp.Count > 0) { sample = QC_Sample_Mix.GetByID(mixCgrp[0].Sample_Mix_ID); } if (sample != null) { currentData.CopyData(sample); } else { MessageBox.Show("没有找到"); } }
private void btnSave_Click(object sender, EventArgs e) { if (string.IsNullOrEmpty(this.curData.CardID)) { MessageBox.Show("还没有刷卡。"); return; } this.curData.Save(); fjdhs1.LoadDataByWhere("fjdh=@fjdh and wc='否'", QC_Sample_Mix.GetZyDanHao(txtStoreCode.Text.Trim())); fjdhs1[0].wc = "是"; fjdhs1.Save(); fjdhs.LoadDataByWhere("wc=@wc", "否"); btnUnBindCard.Visible = false; MessageBox.Show("保存完成"); }
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; // } // ); }
private void gridView1_RowStyle(object sender, DevExpress.XtraGrid.Views.Grid.RowStyleEventArgs e) { int hand = e.RowHandle; if (hand < 0) { return; } QC_Sample_Mix mix = (QC_Sample_Mix)gridView1.GetRow(hand); DbEntityTable <QC_Sample_Mix> mixs = new DbEntityTable <QC_Sample_Mix>(); mixs.LoadDataByWhere("main.SupplierCode=@SupplierCode and Month(main.Mix_Time)=@Mix_Time and Year(main.Mix_Time)=@year and main.MatCode=@MatCode order by Mix_Time", mix.SupplierCode, mix.Mix_Time.Value.Month, mix.Mix_Time.Value.Year, mix.MatCode); if (mixs.Count > 0) { if (mix.Sample_Mix_ID == mixs[0].Sample_Mix_ID) { e.Appearance.ForeColor = Color.Red; } } }
private void printDocument1_PrintPage(object sender, System.Drawing.Printing.PrintPageEventArgs e) { QC_Sample_Mix mix = this.qCSampleMixBindingSource.Current as QC_Sample_Mix; if (mix == null) { MessageBox.Show("请选择任务单"); } else { string qydh = QC_Sample_Mix.ShortStoreCode(mix.CardID); string head = qydh; string body = mix.MatName; string body1 = mix.SupplierName; mix.WCDY = true; mix.Save(); Rectangle rect = new Rectangle(9, 3, 112, 94); Font f1 = new System.Drawing.Font("宋体", 21, FontStyle.Bold); SizeF headSize = e.Graphics.MeasureString(head, f1); Font f2 = new System.Drawing.Font("宋体", 12f, FontStyle.Bold); SizeF bodySize = e.Graphics.MeasureString(body, f2); Font f3 = new System.Drawing.Font("宋体", 12f, FontStyle.Bold); SizeF body1Size = e.Graphics.MeasureString(body1, f2); float topMargin = rect.Top + (rect.Height - headSize.Height - bodySize.Height - body1Size.Height - 6) / 2; float leftMargin = rect.Left + (rect.Width - headSize.Width) / 2; e.Graphics.DrawString(head, f1, Brushes.Black, new PointF(leftMargin, topMargin)); float topMargin2 = topMargin + Math.Max(headSize.Height + 3, 12); float leftMargin2 = rect.Left; e.Graphics.DrawString(body, f2, Brushes.Black, new PointF(leftMargin2, topMargin2)); float topMargin3 = topMargin2 + Math.Max(bodySize.Height + 2, 12); float leftMargin3 = rect.Left; e.Graphics.DrawString(body1, f2, Brushes.Black, new PointF(leftMargin3, topMargin3)); } }
/// <summary> /// 删除校验样 /// </summary> private void tsmBtnVSLDelete_Click(object sender, EventArgs e) { QC_Sample_Mix sampleMix = sourceAllVerifSamples.Current as QC_Sample_Mix; if (sampleMix != null) { if (MessageBox.Show("你确实要删除此数据吗?", "提示", MessageBoxButtons.OKCancel) == DialogResult.OK) { sampleMix.SaveVehSamples = true; sampleMix.SaveCheckItems = true; mixSamples.Remove(sampleMix); mixSamples.Save(); } } else { MessageBox.Show("没有选中的行"); } //int[] selIds = this.gridView1.GetSelectedRows(); //if (selIds.Length > 0) //{ // if (MessageBox.Show("你确实要删除此数据吗?", "提示", MessageBoxButtons.OKCancel) == DialogResult.OK) // { // QC_Sample_Mix sampleMix = this.gridView1.GetRow(selIds[0]) as QC_Sample_Mix; // if (sampleMix != null) // { // sampleMix.SaveVehSamples = true; // mixSamples.Remove(sampleMix); // mixSamples.Save(); // } // } //} //else //{ // MessageBox.Show("没有选中的行"); //} }
private void ReCheck_Load(object sender, EventArgs e) { this.sourceCurData.DataSource = curData; label2.Text = zyzydh; if (zyzydh != "") { QC_Sample_Mix sample = QC_Sample_Mix.GetByZydh(zyzydh); if (sample != null) { if (curData.CheckItems.Count == 0) { curData.CopyData(sample); } curData.SupplierCode = sample.SupplierCode; curData.SupplierName = sample.SupplierName; curData.SampleType = SampleType.检样; curData.SampleState = SampleState.组批完成; curData.WLLX = sample.WLLX; } } }
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) { string storecode = textBox1.Text.Trim(); if (!string.IsNullOrEmpty(storecode)) { string fullCode = QC_Sample_Mix.FullStoreCode(storecode); QC_Sample_Lab sellLab = zyMixSamples.LabTable.FirstOrDefault <QC_Sample_Lab>((lb) => lb.StoreCode == fullCode); if (sellLab != null) { if (xtraTabControl1.SelectedTabPage != null && xtraTabControl1.SelectedTabPage.Text != sellLab.CheckGroupName) { foreach (XtraTabPage tabPage in xtraTabControl1.TabPages) { if (tabPage.Text == sellLab.CheckGroupName) { xtraTabControl1.SelectedTabPage = tabPage; break; } } } int idx = this.labTable.IndexOf(sellLab); this.gridView3.FocusedRowHandle = this.gridView3.GetRowHandle(idx); ; } else { MessageBox.Show("没有找到样品"); } } else { MessageBox.Show("样品编码不能为空"); } }
/// <summary> /// 更新校验样 /// </summary> private void tsmBtnVSLUpdate_Click(object sender, EventArgs e) { QC_Sample_Mix sampleMix = this.sourceAllVerifSamples.Current as QC_Sample_Mix; if (sampleMix != null) { sampleMix.VehSamples.LoadDataBySampleMixId(sampleMix.Sample_Mix_ID); sampleMix.CheckItems.LoadDataBySampleMixId(sampleMix.Sample_Mix_ID); currentData.SaveEnable = false; currentData = sampleMix; this.sourceCurData.DataSource = currentData; } else { MessageBox.Show("没有选中的行"); } //int[] selIds = this.gridView1.GetSelectedRows(); //if (selIds.Length > 0) //{ // QC_Sample_Mix sampleMix = this.gridView1.GetRow(selIds[0]) as QC_Sample_Mix; // if (sampleMix != null) // { // sampleMix.VehSamples.LoadDataBySampleMixId(sampleMix.Sample_Mix_ID); // sampleMix.CheckItems.LoadDataBySampleMixId(sampleMix.Sample_Mix_ID); // currentData.SaveEnable = false; // currentData = sampleMix; // this.sourceCurData.DataSource = currentData; // } //} //else //{ // MessageBox.Show("没有选中的行"); //} }
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; } }