/*
*
* 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);
}
}
