/* * * select k.billcode,r.customername, k.packtasknum,k.cigtype,k.cigseq,k.cigarettename, * k.normalqty,k.cigstate,k.state,k.normailstate * from t_package_task k join t_produce_order r on k.billcode = r.billcode * order by k.packtasknum,k.cigtype,k.cigseq * */ /// <summary> /// 最小的任务号 /// </summary> /// <param name="str"></param> /// <returns></returns> public static decimal GetPackTaskNum(EFModle.Entities et, string str) { var data = (from item in et.T_PRODUCE_ORDER where item.CUSTOMERNAME.IndexOf(str) >= 0 group item by item.BILLCODE into bill select bill.Key).ToList(); List <decimal> vs = new List <decimal>(); foreach (var item in data) { var MinBillcode = (from it in et.T_PACKAGE_TASK where it.BILLCODE.IndexOf(item) >= 0 && it.PACKAGENO == PubFunction.GlobalPara.PackageNo group it by it.PACKTASKNUM into val orderby val.Key select val.Key).FirstOrDefault(); if (MinBillcode != null) { vs.Add(MinBillcode.Value); } } if (!(vs.Count > 0)) { return(0); } else { return(vs.Min()); } }
private void button4_Click(object sender, EventArgs e) { using (EFModle.Entities et = new EFModle.Entities()) { BillResolution br = new BillResolution(); List <TobaccoInfo> list = br.GetTobaccoInfoss(index, cigrShow1.Height); cigrShow1.UpdateValue(list); } }
private void btn_search_Click(object sender, EventArgs e) { string str = textBox1.Text.ToString(); int values = 10; switch (cmb_status.SelectedIndex) { case 1: values = vs1mer[0]; break; case 2: values = vs1mer[1]; break; case 3: values = vs1mer[2]; break; default: break; } List <EFModle.Model.StatusModel> list = new List <EFModle.Model.StatusModel>(); switch (cmb_type.SelectedIndex) { case 1: list = Functions.BLL.DataStatusSearch.GetJQRTask(str, values); break; case 2: list = Functions.BLL.DataStatusSearch.GetBSLTask(str, values); break; case 3: list = Functions.BLL.DataStatusSearch.GetFBTask(str, values); break; default: list = Functions.BLL.DataStatusSearch.GetDefultTask(str); break; } EFModle.Entities et = new EFModle.Entities(); dataGridView1.DataSource = list; }
/// <summary> /// 默认状态 /// </summary> /// <param name="status"></param> /// <returns></returns> public static List <EFModle.Model.StatusModel> GetDefultTask(string str) { using (EFModle.Entities et = new EFModle.Entities()) { decimal packtasknum = GetPackTaskNum(et, str); var data = (from item in et.T_PACKAGE_TASK join item2 in et.T_PRODUCE_ORDER on item.BILLCODE equals item2.BILLCODE where item.PACKAGENO == PubFunction.GlobalPara.PackageNo && item.PACKTASKNUM >= packtasknum orderby item.PACKTASKNUM, item.CIGTYPE, item.CIGSEQ select new EFModle.Model.StatusModel { billcode = item.BILLCODE, customername = item2.CUSTOMERNAME, packtasknum = item.PACKTASKNUM, cigtype = item.CIGTYPE == "1" ? "常规烟" : "异型烟", cigseq = item.CIGSEQ, cigarettename = item.CIGARETTENAME, normalqty = item.NORMALQTY, cigstate = item.CIGSTATE, state = item.STATE, normailstate = item.NORMAILSTATE, doubletask = item.DOUBLETAKE == "0" ? "" : "双抓" } ).Take(500).ToList(); return(data); } }