private void zupiduoche(string cj, String wl, string zyd, int dtmax, string type) { int k = 0; int dyid = 0; DbEntityTable <QC_Sample_Veh> xks = new DbEntityTable <QC_Sample_Veh>(); string zpwpcode = ""; object result = DbContext.ExecuteScalar("select NextWPCode from QC_WpRoute where WpCode='" + zyd + "'"); if (result != null && result != DBNull.Value) { zpwpcode = Convert.ToString(result); //NC到货单 } if (type == "抽样") { xks.LoadDataBySql("select * from QC_Sample_Veh where SUPPLIERCODE=@SUPPLIERCODE and MATCODE=@MATCODE and WPCODE=@WPCODE and sample_mix_id=0 and sample_tbzd=1 and SAMPLESTATE=@SAMPLESTATE and WLLX='煤'", cj, wl, zyd, SampleState.开始组批); } if (type == "正常样") { xks.LoadDataByWhere("main.SUPPLIERCODE=@SUPPLIERCODE and main.MATCODE=@MATCODE and main.WPCODE=@WPCODE and main.sample_mix_id=0 and (main.sample_jy is null or main.sample_jy<>1) and main.sample_tbzd<>1 and main.SAMPLESTATE=@SAMPLESTATE and WLLX='煤'", cj, wl, zyd, SampleState.开始组批); // xks.LoadDataBySql("select * from QC_Sample_Veh where SUPPLIERCODE=@SUPPLIERCODE and MATCODE=@MATCODE and WPCODE=@WPCODE and sample_mix_id=0 and (sample_jy is null or sample_jy<>1) and sample_tbzd<>1 and SAMPLESTATE=@SAMPLESTATE ", cj, wl, zyd, SampleState.开始组批); xks.Sort((v1, v2) => v1.Pxsl.CompareTo(v2.Pxsl)); } foreach (var xk in xks) { k = k + 1; if ((k + dtmax - 1) % dtmax == 0 && wl == xk.MatCode && cj == xk.SupplierCode && zyd == xk.WpCode) { DbEntityTable <QC_Sample_Mix> dty = new DbEntityTable <QC_Sample_Mix>(); dty.LoadDataByWhere("main.SampleState=@SampleState and main.WpCode=@WpCode and main.WLLX='煤'", SampleState.初始状态, zpwpcode); int cishu = 1; if (dty.Count == 0) { label6.Text = "大桶不够了"; return; } foreach (var hy in dty) { //只取一个大桶 cishu = cishu + 1; if (cishu == 2) { hy.MatPK = xk.MatPK; //物料主键 hy.Mix_Time = System.DateTime.Now; //混样时间 hy.SupplierCode = xk.SupplierCode; //供应商 hy.MatCode = xk.MatCode; //物料编码 hy.MixUser = LocalInfo.Current.user.ID; //混样人 hy.Sample_TBZD = xk.SAMPLE_TBZD; hy.SampleType = xk.SampleType; //样品类型 hy.SampleState = SampleState.开始组批; //样品状态 hy.Save(); dyid = hy.Sample_Mix_ID; } } } if (dyid > 0) { xk.Sample_Mix_ID = dyid; xk.SampleState = SampleState.组批完成; xk.Save(); label6.Text = "组批完成"; } DbEntityTable <QC_Sample_Mix> jhplans = new DbEntityTable <QC_Sample_Mix>(); jhplans.LoadDataByWhere("main.sample_mix_id=@sample_mix_id", dyid); foreach (var hy in jhplans) { object result1 = DbContext.ExecuteScalar("select count(*) as num from QC_Sample_Veh where sample_mix_id=@sample_mix_id", hy.Sample_Mix_ID); if (result1 != null && result1 != DBNull.Value) { hy.MixPlanCount = Convert.ToInt32(result1); //桶个数 } hy.Save(); } } isfangtong = false; }