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 insertMoveAction()
{
T_WMS_STORAGEAREA_INOUT entity = new T_WMS_STORAGEAREA_INOUT();
entity.BOXQTY = int.Parse(tbNum.Text);
entity.CIGARETTECODE = ((List <String>)tbChooseName.Tag)[0];
entity.CIGARETTENAME = tbChooseName.Text.ToString();
entity.AREAID = 1;
entity.INOUTTYPE = 20;
StroageInOutService.InsertEntity(entity);
//searchTask();
}
private void button1_Click(object sender, EventArgs e)
{
T_WMS_STORAGEAREA_INOUT entity = new T_WMS_STORAGEAREA_INOUT();
entity.BOXQTY = int.Parse(tbNum.Text);
entity.CIGARETTECODE = tbChooseName.Tag.ToString();
entity.CIGARETTENAME = tbChooseName.Text.ToString();
entity.AREAID = 1;
entity.INOUTTYPE = 20;
StroageInOutService.InsertEntity(entity);
searchTask();
}
public static void InsertEntity(T_WMS_STORAGEAREA_INOUT entity)
{
using (Entities dataEntity = new Entities())
{
decimal id = 0;
// DataTable dt = Query("select S_wms_storagearea_inout.nextval from dual", null);
id = dataEntity.ExecuteStoreQuery <decimal>("select S_wms_storagearea_inout.nextval from dual").First(); //decimal.Parse(dt.Rows[0][0].ToString());
entity.TASKNO = id + "";
entity.ID = id;
entity.CREATETIME = DateTime.Now;
entity.STATUS = 10;
dataEntity.T_WMS_STORAGEAREA_INOUT.AddObject(entity);
dataEntity.SaveChanges();
}
}
