public static void PreInOut()
{
List <TaskDetail> list = GetUnTask();
if (list != null && list.Count > 0)
{
using (Entities entity = new Entities())
{
foreach (var detail in list)
{
INF_JOBDOWNLOAD load = new INF_JOBDOWNLOAD();
load.ID = entity.ExecuteStoreQuery <decimal>("select S_INF_JOBDOWNLOAD.nextval from dual").First() + "";
load.JOBID = load.ID;
load.JOBTYPE = 55;
load.BRANDID = ItemService.GetItemByCode(detail.CIGARETTDECODE).BIGBOX_BAR;
load.CREATEDATE = DateTime.Now;
load.PLANQTY = detail.qty;
load.PRIORITY = 50;
load.SOURCE = AtsCellOutService.getCellNo(detail.CIGARETTDECODE, (int)detail.qty); //out cell
load.TARGET = InfJobDownLoadService.GetTargetOutAddress(load.SOURCE, load.PLANQTY ?? 0); //立库出口
load.STATUS = 0;
entity.INF_JOBDOWNLOAD.AddObject(load);
INF_JOBDOWNLOAD load1 = new INF_JOBDOWNLOAD();
load1.ID = entity.ExecuteStoreQuery <decimal>("select S_INF_JOBDOWNLOAD.nextval from dual").First() + "";
load1.JOBID = load1.ID;
load1.JOBTYPE = 70;
load1.BRANDID = load.BRANDID;
load1.CREATEDATE = DateTime.Now;
load1.PLANQTY = detail.qty;
load1.PRIORITY = 50;
load1.SOURCE = load.TARGET; //out cell
load1.TARGET = ""; //立库出口
load1.STATUS = 2; //拆垛完成下返库
entity.INF_JOBDOWNLOAD.AddObject(load1);
T_WMS_STORAGEAREA_INOUT outTask1 = new T_WMS_STORAGEAREA_INOUT();
outTask1.ID = entity.ExecuteStoreQuery <decimal>("select S_wms_storagearea_inout.nextval from dual").First();
outTask1.AREAID = 6; //异型烟分拣区
outTask1.TASKNO = load.JOBID;
outTask1.CELLNO = ""; // querySource.TROUGHNUM;
outTask1.CIGARETTECODE = detail.CIGARETTDECODE;
outTask1.CIGARETTENAME = detail.CIGARETTDENAME;
outTask1.BARCODE = load.BRANDID + "";
outTask1.INOUTTYPE = 20;//入
outTask1.QTY = detail.qty * ItemService.GetItemByCode(detail.CIGARETTDECODE).JT_SIZE;
outTask1.STATUS = 10;
outTask1.CREATETIME = DateTime.Now;
entity.AddToT_WMS_STORAGEAREA_INOUT(outTask1);
}
entity.SaveChanges();
}
}
}
public void GetAllOrder(decimal packageNo)
{
int allCount = 0;
using (Entities entity = new Entities())
{
DateTime TIEM = new DateTime();
DateTime TIEM2 = new DateTime();
DateTimeFormatInfo format = new DateTimeFormatInfo();
format.ShortDatePattern = "yyyy-MM-dd";
TIEM = Convert.ToDateTime("2019-03-21", format);
TIEM2 = Convert.ToDateTime("2019-03-21", format);
//var query = (from item in entity.T_UN_TASK_H
// where item.BILLCODE =="CS10429225" && item.PACKAGEMACHINE == packageNo //&& item.ORDERDATE >= TIEM && item.ORDERDATE <= TIEM2 //&& item.TASKNUM == 799261
// orderby item.TASKNUM
// select item).ToList();
var query = (from item in entity.V_PRODUCE_PACKAGEINFO
where
//item.EXPORT == packageNo &&
item.BILLCODE == "CS10429225"
//&& item.ALLOWSORT=="非标"
// && (item.TASKNUM == 664692 || item.TASKNUM == 663143)
group item by new { item.BILLCODE, item.TASKNUM } into allcode
select new { allcode.Key.BILLCODE, allcode.Key.TASKNUM }).OrderBy(x => x.TASKNUM).ToList();
ptid = entity.T_PACKAGE_TASK.Count() > 0 ? entity.T_PACKAGE_TASK.Max(x => x.PTID) + 1 : 1;
if (query != null)
{
int i = 0;
//decimal maxSeq = GetSeq("select decode(max(ptid),null,0,max(ptid)) from t_package_task ");
foreach (var v in query)
{
i++;
int pcount = 0;
List <T_PACKAGE_TASK> task = new List <T_PACKAGE_TASK>();
var query2 = (from item2 in entity.V_PRODUCE_PACKAGEINFO where item2.BILLCODE == v.BILLCODE && item2.ALLOWSORT == "非标" orderby item2.SENDTASKNUM, item2.MACHINESEQ, item2.TROUGHNUM select item2).ToList();
if (query2 != null)
{
foreach (var v2 in query2)
{
allCount = allCount + 1;
pcount = pcount + 1;
T_PACKAGE_TASK temp = new T_PACKAGE_TASK();
temp.PTID = ptid;
temp.CIGARETTECODE = v2.CIGARETTECODE;
T_WMS_ITEM tempItem = ItemService.GetItemByCode(v2.CIGARETTECODE);
temp.CIGARETTENAME = tempItem.ITEMNAME;
temp.CIGHIGH = tempItem.IHEIGHT;
temp.CIGWIDTH = tempItem.IWIDTH;
temp.CIGWIDTH = tempItem.IWIDTH;
temp.CIGLENGTH = tempItem.ILENGTH;
temp.BILLCODE = v2.BILLCODE;
temp.SORTNUM = v2.TASKNUM;
temp.CIGNUM = allCount;
temp.CIGSEQ = pcount;
//temp.PACKAGESEQ = v2.EXPORT;
temp.ALLPACKAGESEQ = 0;
//temp.PACKAGENO = v2.PACKAGEMACHINE;
temp.PACKAGENO = 1;//v2.EXPORT;
//temp.CIGTYPE = "2";
temp.CIGTYPE = v2.ALLOWSORT == "非标" ? "2" : "1";
temp.STATE = 0; //0 新增 10 确定
temp.NORMAILSTATE = 0; //0 新增 10 确定
temp.NORMALQTY = 1;
temp.UNIONPACKAGETAG = 0;
temp.DOUBLETAKE = "0";
////temp.ORDERSEQ = v2.PRIORITY;
////temp.ORDERQTY = v2.ORDERQUANTITY;
temp.CIGSTATE = 10;
task.Add(temp);
ptid++;
}
allpackagenum++;
GenPackageInfo(task, entity);
foreach (var item in task)
{
item.PACKTASKNUM = item.ALLPACKAGESEQ;
entity.T_PACKAGE_TASK.AddObject(item);
}
if (i == 5)
{
entity.SaveChanges();
i = 0;
}
}
}
entity.SaveChanges();
}
}
}
