/// <summary> /// 添加检验项目 /// </summary> private void tsmBtnAddCheckItem_Click(object sender, EventArgs e) { DlgCheckItem dlg = new DlgCheckItem(); if (dlg.ShowDialog() == DialogResult.OK) { if (dlg.SelectedCheckItem != null) { var ck = from c in curData.CheckItems where c.CheckItemCode == dlg.SelectedCheckItem.CheckItemNcId select c; if (ck.Count <QC_MixCheckItem>() > 0) { MessageBox.Show("已有此检验项目"); return; } QC_MixCheckItem sv = new QC_MixCheckItem(); sv.CheckItemNcId = dlg.SelectedCheckItem.CheckItemNcId; sv.CheckItemCode = dlg.SelectedCheckItem.CheckItemCode; sv.CheckItemName = dlg.SelectedCheckItem.CheckItemName; sv.CheckItemUnit = dlg.SelectedCheckItem.CheckItemUnit; sv.Source = "检验样"; curData.CheckItems.Add(sv); } } }
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; } }
private void 除检验项目ToolStripMenuItem_Click(object sender, EventArgs e) { QC_MixCheckItem selData = this.checkItemsBindingSource.Current as QC_MixCheckItem; if (selData != null) { if (MessageBox.Show("确实要删除吗?", "提示", MessageBoxButtons.OKCancel) == DialogResult.OK) { this.checkItemsBindingSource.RemoveCurrent(); } } else { MessageBox.Show("没有选中数据", "提示"); } }
/// <summary> /// 添加检验项目 /// </summary> private void tsmBtnAddCheckItem_Click(object sender, EventArgs e) { DlgCheckItem dlg = new DlgCheckItem(); if (dlg.ShowDialog() == DialogResult.OK) { if (dlg.SelectedCheckItem != null) { QC_MixCheckItem sv = new QC_MixCheckItem(); sv.CheckItemNcId = dlg.SelectedCheckItem.CheckItemNcId; sv.CheckItemCode = dlg.SelectedCheckItem.CheckItemCode; sv.CheckItemName = dlg.SelectedCheckItem.CheckItemName; sv.CheckItemUnit = dlg.SelectedCheckItem.CheckItemUnit; sv.Source = "检验样"; currentData.CheckItems.Add(sv); } } }
public void CopyData(QC_Sample_Mix original) { this.MatPK = original.MatPK; this.MatCode = original.MatCode; this.MatName = original.MatName; this.CheckItems.Empty(); QC_Sample_Value_Table orignalSample_CheckVals = new QC_Sample_Value_Table(); orignalSample_CheckVals.LoadDataBySampleMixId(original.Sample_Mix_ID); foreach (var item in orignalSample_CheckVals) { QC_MixCheckItem sv = new QC_MixCheckItem(); sv.CheckItemNcId = item.CheckItemNcId; sv.CheckItemCode = item.CheckItemCode; sv.CheckItemName = item.CheckItemName; sv.CheckItemUnit = item.CheckItemUnit; sv.ActualVal = item.CheckVal; this.CheckItems.Add(sv); } }
private void 添加检验项目ToolStripMenuItem_Click(object sender, EventArgs e) { if (this.curData != null) { List <string> filterIds = new List <string>(); foreach (var item in curData.CheckItems) { filterIds.Add(item.CheckItemNcId); } DlgCheckItem dlg = null; if (string.IsNullOrEmpty(this.curData.MatPK)) { dlg = new DlgCheckItem(filterIds); } else { dlg = new DlgCheckItem(filterIds, this.curData.MatPK); } if (dlg.ShowDialog() == DialogResult.OK) { if (dlg.SelectedCheckItem != null) { QC_MixCheckItem qrc = new QC_MixCheckItem(); qrc.CheckItemNcId = dlg.SelectedCheckItem.CheckItemNcId; qrc.CheckItemCode = dlg.SelectedCheckItem.CheckItemCode; qrc.CheckItemName = dlg.SelectedCheckItem.CheckItemName; qrc.CheckItemUnit = dlg.SelectedCheckItem.CheckItemUnit; qrc.CheckGroupCode = dlg.SelectedCheckItem.CheckGroupCode; qrc.SetDataStateAsAdded(); this.curData.CheckItems.Add(qrc); } } } else { MessageBox.Show("没有选中数据", "提示"); } }
private void 除检验项目ToolStripMenuItem_Click(object sender, EventArgs e) { QC_MixCheckItem checkVal = checkValsBindingSource.Current as QC_MixCheckItem; if (checkVal != null) { //int[] selIds = this.gridView_CheckVal.GetSelectedRows(); //if (selIds.Length > 0) //{ if (MessageBox.Show("你确实要删除此数据吗?", "提示", MessageBoxButtons.OKCancel) == DialogResult.OK) { //QC_Sample_Value checkVal = this.gridView_CheckVal.GetRow(selIds[0]) as QC_Sample_Value; //if (checkVal != null) //{ this.currentData.CheckItems.Remove(checkVal); //} } } else { MessageBox.Show("没有选中的行"); } }
private void 制样_Click(object sender, EventArgs e) { if (!comboBox1.Text.StartsWith("RJ")) { MessageBox.Show("请选择正确单号"); return; } DbEntityTable <QC_Sample_Mix> mix = new DbEntityTable <QC_Sample_Mix>(); int mixid = 100000000; mix.LoadDataByWhere("main.CardID=@CardID", QC_Sample_Mix.FullStoreCode(comboBox1.Text)); if (mix.Count > 0) { mixid = mix[0].Sample_Mix_ID; } QC_SampleMix_ZhiYang zySample = QC_SampleMix_ZhiYang.GetById(mixid); if (zySample == null) { MessageBox.Show("找不到单据"); return; } if (zySample.SampleState < SampleState.组批完成) { MessageBox.Show("磁卡所对大桶还未组批完成"); return; } if (zySample.WLLX != "熔剂") { MessageBox.Show("物料不是熔剂请选择其他制样点"); return; } zySample.ZyDanHao = mix[0].CardID; zySample.SampleState = SampleState.开始制样; zySample.ZyWpCode = workpointCode; zySample.ZyRecvUser = LocalInfo.Current.user.ID; zySample.ZyRecvTime = DateTime.Now; if (zySample.SampleType == SampleType.普通样 || zySample.SampleType == SampleType.破包样) { DbEntityTable <QC_MatAllCheckItem> bjCheckItem = new DbEntityTable <QC_MatAllCheckItem>(); bjCheckItem.LoadDataByWhere("MATNCID=@MATNCID and JYLX='必检'", zySample.MatPK); foreach (var stdCheckItem in bjCheckItem) { QC_MixCheckItem ckItem = zySample.CheckItems.FirstOrDefault <QC_MixCheckItem>((ck) => ck.CheckItemNcId == stdCheckItem.CheckItemNcId); if (ckItem == null) { QC_MixCheckItem item = new QC_MixCheckItem(); item.CheckItemNcId = stdCheckItem.CheckItemNcId; item.CheckItemCode = stdCheckItem.CheckItemCode; item.CheckItemName = stdCheckItem.CheckItemName; item.CheckItemUnit = stdCheckItem.CheckItemUnit; item.CheckGroupCode = stdCheckItem.CheckGroupCode; item.CheckGroupName = stdCheckItem.CheckGroupName; item.CheckGroupType = stdCheckItem.CheckGroupType; item.CkgShortWord = stdCheckItem.CkgShortWord; item.Sample_Mix_ID = item.Sample_Mix_ID; item.CheckGroupVisIdx = stdCheckItem.CheckGroupVisIdx; item.Source = "检验标准-必检"; zySample.CheckItems.Add(item); } } DbEntityTable <QC_MatAllCheckItem> myCheckItem = new DbEntityTable <QC_MatAllCheckItem>(); myCheckItem.LoadDataByWhere("MATNCID=@MATNCID and JYLX='每月'", zySample.MatPK); DateTime yue = new DateTime(DateTime.Now.Year, DateTime.Now.Month, 1); foreach (var stdCheckItem in myCheckItem) { object cntObj = DbContext.ExecuteScalar("SELECT count(*) FROM QC_MixCheckItem mck inner join qc_sample_mix mix on mix.SAMPLE_MIX_ID=mck.SAMPLE_MIX_ID where mix.Mix_Time>=@MixTime and mix.SampleType=" + (int)SampleType.普通样 + " and mix.SupplierCode=@SupplierCode and mix.MatPK=@MatPK and mck.CheckItemNcId=@CheckItemNcId", yue, zySample.SupplierCode, zySample.MatPK, stdCheckItem.CheckItemNcId); if (cntObj != null) { int cnt = Convert.ToInt32(cntObj); if (cnt == 0) { QC_MixCheckItem ckItem = zySample.CheckItems.FirstOrDefault <QC_MixCheckItem>((ck) => ck.CheckItemNcId == stdCheckItem.CheckItemNcId); if (ckItem == null) { QC_MixCheckItem item = new QC_MixCheckItem(); item.CheckItemNcId = stdCheckItem.CheckItemNcId; item.CheckItemCode = stdCheckItem.CheckItemCode; item.CheckItemName = stdCheckItem.CheckItemName; item.CheckItemUnit = stdCheckItem.CheckItemUnit; item.CheckGroupCode = stdCheckItem.CheckGroupCode; item.CheckGroupName = stdCheckItem.CheckGroupName; item.CheckGroupType = stdCheckItem.CheckGroupType; item.CkgShortWord = stdCheckItem.CkgShortWord; item.Sample_Mix_ID = item.Sample_Mix_ID; item.CheckGroupVisIdx = stdCheckItem.CheckGroupVisIdx; item.Source = "检验标准-每月"; zySample.CheckItems.Add(item); } } } } int wd2 = (int)DateTime.Now.DayOfWeek - 1; if (wd2 == -1) { wd2 = 6; } DateTime zhou1 = DateTime.Today.AddDays(0 - wd2); DbEntityTable <QC_MatAllCheckItem> meizhouCheckItem = new DbEntityTable <QC_MatAllCheckItem>(); meizhouCheckItem.LoadDataByWhere("MATNCID=@MATNCID and JYLX='每周'", zySample.MatPK); foreach (var stdCheckItem in meizhouCheckItem) { object cntObj = DbContext.ExecuteScalar("SELECT count(*) FROM QC_MixCheckItem mck inner join qc_sample_mix mix on mix.SAMPLE_MIX_ID=mck.SAMPLE_MIX_ID where mix.Mix_Time>=@MixTime and mix.SampleType=" + (int)SampleType.普通样 + " and mix.SupplierCode=@SupplierCode and mix.MatPK=@MatPK and mck.CheckItemNcId=@CheckItemNcId", zhou1, zySample.SupplierCode, zySample.MatPK, stdCheckItem.CheckItemNcId); if (cntObj != null) { int cnt = Convert.ToInt32(cntObj); if (cnt == 0) { QC_MixCheckItem ckItem = zySample.CheckItems.FirstOrDefault <QC_MixCheckItem>((ck) => ck.CheckItemNcId == stdCheckItem.CheckItemNcId); if (ckItem == null) { QC_MixCheckItem item = new QC_MixCheckItem(); item.CheckItemNcId = stdCheckItem.CheckItemNcId; item.CheckItemCode = stdCheckItem.CheckItemCode; item.CheckItemName = stdCheckItem.CheckItemName; item.CheckItemUnit = stdCheckItem.CheckItemUnit; item.CheckGroupCode = stdCheckItem.CheckGroupCode; item.CheckGroupName = stdCheckItem.CheckGroupName; item.CheckGroupType = stdCheckItem.CheckGroupType; item.CkgShortWord = stdCheckItem.CkgShortWord; item.Sample_Mix_ID = item.Sample_Mix_ID; item.CheckGroupVisIdx = stdCheckItem.CheckGroupVisIdx; item.Source = "检验标准-每周"; zySample.CheckItems.Add(item); } } } } DateTime tian1 = DateTime.Today; DbEntityTable <QC_MatAllCheckItem> meitianCheckItem = new DbEntityTable <QC_MatAllCheckItem>(); meizhouCheckItem.LoadDataByWhere("MATNCID=@MATNCID and JYLX='每天'", zySample.MatPK); foreach (var stdCheckItem in meizhouCheckItem) { object cntObj = DbContext.ExecuteScalar("SELECT count(*) FROM QC_MixCheckItem mck inner join qc_sample_mix mix on mix.SAMPLE_MIX_ID=mck.SAMPLE_MIX_ID where mix.Mix_Time>=@MixTime and mix.SampleType=" + (int)SampleType.普通样 + " and mix.SupplierCode=@SupplierCode and mix.MatPK=@MatPK and mck.CheckItemNcId=@CheckItemNcId", tian1, zySample.SupplierCode, zySample.MatPK, stdCheckItem.CheckItemNcId); if (cntObj != null) { int cnt = Convert.ToInt32(cntObj); if (cnt == 0) { QC_MixCheckItem ckItem = zySample.CheckItems.FirstOrDefault <QC_MixCheckItem>((ck) => ck.CheckItemNcId == stdCheckItem.CheckItemNcId); if (ckItem == null) { QC_MixCheckItem item = new QC_MixCheckItem(); item.CheckItemNcId = stdCheckItem.CheckItemNcId; item.CheckItemCode = stdCheckItem.CheckItemCode; item.CheckItemName = stdCheckItem.CheckItemName; item.CheckItemUnit = stdCheckItem.CheckItemUnit; item.CheckGroupCode = stdCheckItem.CheckGroupCode; item.CheckGroupName = stdCheckItem.CheckGroupName; item.CheckGroupType = stdCheckItem.CheckGroupType; item.CkgShortWord = stdCheckItem.CkgShortWord; item.Sample_Mix_ID = item.Sample_Mix_ID; item.CheckGroupVisIdx = stdCheckItem.CheckGroupVisIdx; item.Source = "检验标准-每天"; zySample.CheckItems.Add(item); } } } } } else if (zySample.SampleType == SampleType.校验样) { //加载校验样项目 QC_MixCheckItem_Table table = new QC_MixCheckItem_Table(); table.LoadDataByWhere("main.SAMPLE_VEH_ID=(select SAMPLE_VEH_ID from QC_Sample_Veh veh where veh.SAMPLE_MIX_ID=@SAMPLE_MIX_ID)", zySample.Sample_Mix_ID); foreach (var item in table) { item.Sample_Mix_ID = zySample.Sample_Mix_ID; item.Source = "校验样"; zySample.CheckItems.Add(item); } //DbContext.ExeSql("update t1 set t1.SAMPLE_MIX_ID =(select SAMPLE_MIX_ID from QC_Sample_Veh t2 where t2.SAMPLE_VEH_ID=t1.SAMPLE_VEH_ID) from QC_MIXCHECKITEM t1 where ISnull(t1.SAMPLE_VEH_ID,0)>0 and ISnull(t1.SAMPLE_MIX_ID,0)<=0"); } //生成样品分类 foreach (var item in zySample.CheckItems) { QC_MixCheckGroup mixCG = zySample.CheckGroups.FirstOrDefault <QC_MixCheckGroup>((mcg) => mcg.CheckGroupCode == item.CheckGroupCode); if (mixCG == null) { mixCG = new QC_MixCheckGroup(); mixCG.CheckGroupCode = item.CheckGroupCode; mixCG.CheckGroupName = item.CheckGroupName; mixCG.CheckGroupType = item.CheckGroupType; mixCG.CkgShortWord = item.CkgShortWord; mixCG.VisIdx = item.CheckGroupVisIdx; mixCG.StoreCode = zySample.ZyDanHao + item.CkgShortWord; mixCG.MatPK = zySample.MatPK; mixCG.SupplierCode = zySample.SupplierCode; mixCG.Sample_TBZD = zySample.Sample_TBZD; mixCG.Sample_Mix_ID = zySample.Sample_Mix_ID; mixCG.ZySample = zySample; zySample.CheckGroups.Add(mixCG); } mixCG.MixCheckItem.Add(item); } //加载物料设置样品分类 DbEntityTable <QC_MatCheckGroup> MatCheckGroup = new DbEntityTable <QC_MatCheckGroup>(); MatCheckGroup.LoadDataByWhere("MatNcId=@MatNcId", zySample.MatPK); for (int i = 0; i < MatCheckGroup.Count; i++) { QC_MixCheckGroup item = new QC_MixCheckGroup(); item.CheckGroupCode = MatCheckGroup[i].CheckGroupCode; item.CheckGroupName = MatCheckGroup[i].CheckGroupName; item.CheckGroupType = MatCheckGroup[i].CheckGroupType; item.CkgShortWord = MatCheckGroup[i].ShortWord; item.VisIdx = MatCheckGroup[i].CheckGroupVisIdx; item.StoreCode = zySample.ZyDanHao + MatCheckGroup[i].ShortWord; item.MatPK = zySample.MatPK; item.SupplierCode = zySample.SupplierCode; item.Sample_TBZD = zySample.Sample_TBZD; item.Sample_Mix_ID = zySample.Sample_Mix_ID; item.ZySample = zySample; zySample.CheckGroups.Add(item); } zySample.CheckGroups.Sort((tx, ty) => tx.VisIdx.CompareTo(ty.VisIdx)); foreach (var item in zySample.CheckGroups) { item.MatPK = zySample.MatPK; item.SupplierCode = zySample.SupplierCode; item.Sample_TBZD = zySample.Sample_TBZD; item.ZySample = zySample; item.Billtype = "未绑定样品扣"; item.LabState = "制样"; } zySample.SaveCheckGroups = true; zySample.SaveCheckItems = true; zySample.Save(); //生成Lab foreach (var ckg in zySample.CheckGroups) { if (!ckg.CheckGroupName.Contains("角质层") && (ckg.CheckGroupType == "立刻检验" || ckg.CheckGroupType == "后续检验")) { QC_Sample_Lab lb = new QC_Sample_Lab(); lb.MixCheckGroup.Add(ckg); lb.StoreCode = ckg.StoreCode; lb.WpCode = workpointCode; lb.Billtype = "未绑定样品扣"; lb.LabState = "制样"; lb.WLLX = zySample.WLLX; lb.CheckGroupCode = ckg.CheckGroupCode; lb.CheckGroupName = ckg.CheckGroupName; lb.CheckGroupType = ckg.CheckGroupType; lb.Sample_Mix_ID = ckg.Sample_Mix_ID; foreach (var ck in ckg.MixCheckItem) { QC_Sample_Value qcVal = new QC_Sample_Value(); qcVal.CheckItemNcId = ck.CheckItemNcId; qcVal.CheckItemCode = ck.CheckItemCode; qcVal.CheckItemName = ck.CheckItemName; qcVal.ActualVal = ck.ActualVal; lb.CheckVals.Add(qcVal); } lb.SaveCheckVals = true; zyMixSamples.LabTable.Add(lb); } } zyMixSamples.LabTable.Save(); zyMixSamples.Add(zySample); //lblRecvDanHao.Text = zySample.ZyShortDanHao; this.gridView1.FocusedRowHandle = this.gridView1.GetRowHandle(zyMixSamples.Count - 1); 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)); } this.printDocument1.Print(); }
/// <summary> /// 加载车辆信息 /// </summary> /// <param name="cph"></param> /// <param name="sampleTime"></param> public void LoadBy() { QC_Sample_Veh selectedVeh = null; if (string.IsNullOrEmpty(txtCph.Text.Trim())) { MessageBox.Show("车牌号不能为空"); return; } string cph = txtCph.Text.Trim(); if (dateEdit_SampleTime.EditValue == DBNull.Value) { DlgChe dlg = new DlgChe(cph, DateTime.Now.AddMinutes(-10)); if (dlg.ShowDialog() == DialogResult.OK) { selectedVeh = dlg.SelectedVeh; curData.FetchTime = selectedVeh.FetchTime; } else { return; } } else { DateTime sampleTime = dateEdit_SampleTime.DateTime; if (sampleTime > DateTime.MinValue && sampleTime < DateTime.Now) { DbEntityTable <QC_Sample_Veh> noticeVeh = new DbEntityTable <QC_Sample_Veh>(); noticeVeh.LoadDataByWhere(string.Format("vehno like '%{0}%' ", cph)); if (noticeVeh.Count == 1) { selectedVeh = noticeVeh[0]; } else { DlgChe dlg = new DlgChe(cph, sampleTime); if (dlg.ShowDialog() == DialogResult.OK) { selectedVeh = dlg.SelectedVeh; curData.FetchTime = selectedVeh.FetchTime; } else { return; } } } else { MessageBox.Show("取样时间不在合理范围"); } } if (selectedVeh != null) { curData.VehNo = selectedVeh.VehNo; txtCph.Text = curData.VehNo; //if (selectedVeh.WLLX == "火运") //{ curData.NoticeBillId = selectedVeh.Sample_Veh_ID.ToString(); } curData.NoticeBillId = selectedVeh.NoticeBillId; curData.SupplierCode = selectedVeh.SupplierCode; curData.SupplierName = selectedVeh.SupplierName; curData.MatPK = selectedVeh.MatPK; curData.MatCode = selectedVeh.MatCode; curData.MatName = selectedVeh.MatName; curData.CheckItems.Empty(); DbEntityTable <QC_CheckItem> CheckItemView = new DbEntityTable <QC_CheckItem>(); if (selectedVeh.MatCode == "16911" || selectedVeh.MatCode == "16912") { CheckItemView.LoadDataByWhere("CHECKITEMCODE in ('10001','10120','10011','10012')"); } else { CheckItemView.LoadDataByWhere("CHECKITEMCODE in ('10001','10002','10011','10012')"); } //DbEntityTable<QC_MatCheckItem_View> CheckItemView = new DbEntityTable<QC_MatCheckItem_View>(); //CheckItemView.LoadDataByWhere("MatNCid=@MatNCid", curData.MatPK); foreach (var stdCheckItem in CheckItemView) { QC_MixCheckItem item = new QC_MixCheckItem(); item.CheckItemNcId = stdCheckItem.CheckItemNcId; item.CheckItemCode = stdCheckItem.CheckItemCode; item.CheckItemName = stdCheckItem.CheckItemName; item.CheckItemUnit = stdCheckItem.CheckItemUnit; item.CheckGroupCode = stdCheckItem.CheckGroupCode; //item.CheckGroupName = stdCheckItem.CheckGroupName; //item.CheckGroupType = stdCheckItem.CheckGroupType; //item.CkgShortWord = stdCheckItem.CkgShortWord; item.Sample_Mix_ID = item.Sample_Mix_ID; item.Source = "抽查样"; curData.CheckItems.Add(item); } //SetCheckItems(); MessageBox.Show("加载完成"); } else { MessageBox.Show("没有找到作业单信息"); } }