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(); } } }