public bool NewStockIn(string UserID, ToDoListStockinOrderData data) { bool ret = true; OracleDBObj obj = new OracleDBObj(); obj.CreateConnection(); obj.CreateTransaction(); try { StockInDAL _DAL = new StockInDAL(); _DAL.OnDB = false; _DAL.ACCCODE = data.ACCCODE; _DAL.DOCTYPE = data.DOCTYPE; _DAL.RECEIVEDATE = data.RECEIVEDATE; _DAL.RECEIVER = data.RECEIVER; _DAL.SENDER = data.SENDER; _DAL.STATUS = data.STATUS; ret = _DAL.InsertCurrentData(UserID, obj.zTrans); if (!ret) { throw new ApplicationException(_DAL.ErrorMessage); } StockInItemDAL _DALItem = new StockInItemDAL(); for (int i = 0; i < data.ITEM.Count; ++i) { _DALItem.OnDB = false; ToDoListStockInOrderItemData itemData = (ToDoListStockInOrderItemData)data.ITEM[i]; _DALItem.LOTNO = itemData.LOTNO; _DALItem.PRICE = itemData.PRICE; _DALItem.PRODUCT = itemData.PRODUCT; _DALItem.QTY = itemData.QTY; _DALItem.REFLOID = itemData.REFLOID; _DALItem.REFTABLE = itemData.REFTABLE; _DALItem.STATUS = itemData.STATUS; _DALItem.STOCKIN = _DAL.LOID; _DALItem.UNIT = itemData.UNIT; ret = _DALItem.InsertCurrentData(UserID, obj.zTrans); if (!ret) { throw new ApplicationException(_DALItem.ErrorMessage); } } _LOID = _DAL.LOID; obj.zTrans.Commit(); obj.CloseConnection(); } catch (Exception ex) { obj.zTrans.Rollback(); obj.CloseConnection(); ret = false; _error = ex.Message; } return ret; }
public double InsertStockIn(string UserId, StockInData data) { Boolean ret = true; StockInDAL oDAL = new StockInDAL(); oDAL.SENDER = Convert.ToDouble(data.SENDER); oDAL.DOCTYPE = Constz.DocType.RetShop.LOID; oDAL.RECEIVEDATE = DateTime.Now.Date; oDAL.STATUS = Constz.Requisition.Status.Waiting.Code; oDAL.GRANDTOT = 0.00; oDAL.RECEIVER = data.RECEIVER; ret = oDAL.InsertCurrentData(UserId, null); if (ret == false) { _error = oDAL.ErrorMessage; return 0; } else return oDAL.LOID; }