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