public void quYang(string type) { if (sample_selected.Count < 1) { MessageBox.Show("没有勾选物料"); return; } int jq = 0, sq = 0; sampleNum sm = new sampleNum(); sm.showDialogEx(type); if (sm.DialogResult != DialogResult.OK) { MessageBox.Show("没有确认取样的个数"); return; } else { jq = sm.autoNum; sq = sm.manuNum; //cq = sm.chouNum; } if ((jq == 0) && (sq == 0)) { MessageBox.Show("没有确认取样的个数"); return; } int mixid = 0; IDbConnection conn = DbContext.GetDefaultConnection(); conn.Open(); IDbTransaction trans = conn.BeginTransaction(); try { for (int i = 0; i < jq; 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); mix.MainSampleMixId = mixid; mix.Save(trans); if (mixid == 0) { foreach (var veh in sample_selected) { veh.Sample_Mix_ID = mix.Sample_Mix_ID; veh.Mix_Time = DateTime.Now; veh.SampleState = SampleState.组批完成; veh.SampleType = SampleType.机器取样; veh.Save(trans); } mixid = mix.Sample_Mix_ID; } } for (int i = 0; i < sq; 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); mix.MainSampleMixId = mixid; mix.Save(trans); if (mixid == 0) { foreach (var veh in sample_selected) { veh.Sample_Mix_ID = mix.Sample_Mix_ID; veh.Mix_Time = DateTime.Now; veh.SampleState = SampleState.组批完成; veh.SampleType = SampleType.人工取样; veh.Save(trans); } mixid = mix.Sample_Mix_ID; } } trans.Commit(); conn.Close(); } catch (Exception ex) { trans.Rollback(); conn.Close(); MessageBox.Show("出现异常,重新操作:" + ex.ToString()); return; } print(); }
//抽取 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(); }