public static void InsertEntity(T_WMS_ATSCELL_CJ_HIS 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_atscell_cj_his.nextval from dual").First(); //decimal.Parse(dt.Rows[0][0].ToString()); //entity = id + ""; entity.ID = id; entity.CREATETIME = DateTime.Now; // entity.STATUS = 10; dataEntity.T_WMS_ATSCELL_CJ_HIS.AddObject(entity); dataEntity.SaveChanges(); } }
private void button1_Click(object sender, EventArgs e) { if (cbAdress.SelectedIndex == -1) { MessageBox.Show("请选择出库口"); return; } if (tbChooseName.Tag == null) { MessageBox.Show("请选择出库品牌"); return; } INF_JOBDOWNLOAD job = new INF_JOBDOWNLOAD(); job.TARGET = address[cbAdress.SelectedIndex]; job.SOURCE = ((List <String>)tbChooseName.Tag)[2].ToString(); job.BARCODE = AtsCellInfoService.GetCellInfo(job.SOURCE).PALLETNO; job.PLANQTY = int.Parse(((List <String>)tbChooseName.Tag)[1].ToString()); job.JOBTYPE = 50;//搬运任务 job.PRIORITY = 50; job.CREATEDATE = DateTime.Now; job.BRANDID = ((List <String>)tbChooseName.Tag)[0].ToString(); job.TUTYPE = 4; job.INPUTTYPE = 10; using (TransactionScope ts = new TransactionScope()) { InfJobDownLoadService.InsertEntity(job); T_WMS_ATSCELL_CJ_HIS his = new T_WMS_ATSCELL_CJ_HIS(); his.CELLNO = job.SOURCE; his.QTY = job.PLANQTY; his.INBOUNDTIME = AtsCellInfoService.GetCellInfo(his.CELLNO).CREATETIME; his.CIGARETTECODE = job.BRANDID; his.CIGARETTENAME = ItemService.GetItemByCode(his.CIGARETTECODE).ITEMNAME; his.INBOUNDID = AtsCellInfoService.GetCellInfo(his.CELLNO).INBOUNDID; his.BARCODE = ItemService.GetItemByCode(his.CIGARETTECODE).BIGBOX_BAR; AtsCellCJService.InsertEntity(his); AtsCellService.UpdateAtsCell(job.SOURCE, 30);//更新cellno状态 ts.Complete(); } MessageBox.Show("出库完成"); }