public PointOfSaleData GetData(double loid)
{
PointOfSaleData data = new PointOfSaleData();
if (DALObj.GetDataByLOID(loid, null))
{
data.INVCODE = DALObj.INVCODE;
data.CODE = DALObj.CODE;
data.ACTIVE = DALObj.ACTIVE;
data.CASH = DALObj.CASH;
data.COUPON = DALObj.COUPON;
data.CREDITCARDID = DALObj.CREDITCARDID;
data.CREDITCARDPAY = DALObj.CREDITCARDPAY;
data.CREDITTYPE = DALObj.CREDITTYPE;
data.CUSTOMER = DALObj.CUSTOMER;
data.GRANDTOT = DALObj.GRANDTOT;
data.REFLOID = DALObj.REFLOID;
data.REFNO = DALObj.REFNO;
data.REFTABLE = DALObj.REFTABLE;
data.STATUS = DALObj.STATUS;
data.TOTAL = DALObj.TOTAL;
data.TOTDIS = DALObj.TOTDIS;
data.TOTVAT = DALObj.TOTVAT;
data.VAT = DALObj.VAT;
data.WAREHOUSE = DALObj.WAREHOUSE;
data.REQDATE = DALObj.REQDATE;
data.CREATEBY = DALObj.CREATEBY;
RequisitionItemDAL itemDAL = new RequisitionItemDAL();
DataTable dt = GetRequisitionItem(loid);
foreach (DataRow dRow in dt.Rows)
{
RequisitionItemData itemData = new RequisitionItemData();
itemData.BarCode = dRow["BARCODE"].ToString();
itemData.DISCOUNT = Convert.ToDouble(dRow["DISCOUNT"]);
itemData.ISVAT = dRow["ISVAT"].ToString();
itemData.NETPRICE = Convert.ToDouble(dRow["NETPRICE"]);
itemData.PRICE = Convert.ToDouble(dRow["PRICE"]);
itemData.PRODUCT = Convert.ToDouble(dRow["PRODUCT"]);
itemData.QTY = Convert.ToDouble(dRow["QTY"]);
itemData.ProductName = dRow["NAME"].ToString();
data.REQUISITIONITEM.Add(itemData);
}
}
return data;
}
public bool UpdateData(string userID, PointOfSaleData data, bool setInvoice)
{
bool ret = true;
if (ValidateData(data))
{
OracleDBObj obj = new OracleDBObj();
obj.CreateConnection();
obj.CreateTransaction();
try
{
_dal = new RequisitionDAL();
DALObj.OnDB = false;
DALObj.GetDataByLOID(data.LOID, obj.zTrans);
DALObj.REQUISITIONTYPE = Constz.Requisition.RequisitionType.REQ13;
DALObj.ACTIVE = data.ACTIVE;
DALObj.CASH = data.CASH;
DALObj.COUPON = data.COUPON;
DALObj.CREDITCARDID = data.CREDITCARDID;
DALObj.CREDITCARDPAY = data.CREDITCARDPAY;
DALObj.CREDITTYPE = data.CREDITTYPE;
DALObj.CUSTOMER = data.CUSTOMER;
DALObj.GRANDTOT = data.GRANDTOT;
DALObj.REFLOID = data.REFLOID;
DALObj.REFNO = data.REFNO;
DALObj.REFTABLE = data.REFTABLE;
DALObj.STATUS = data.STATUS;
DALObj.TOTAL = data.TOTAL;
DALObj.TOTDIS = data.TOTDIS;
DALObj.TOTVAT = data.TOTVAT;
DALObj.VAT = data.VAT;
DALObj.WAREHOUSE = data.WAREHOUSE;
DALObj.REQDATE = data.REQDATE;
if (setInvoice && DALObj.INVCODE != "") DALObj.INVCODE = OracleDB.GetRunningCode("REQUISITION_INVCODE", DALObj.REQUISITIONTYPE.ToString(), obj.zTrans);
if (DALObj.OnDB)
ret = DALObj.UpdateCurrentData(userID, obj.zTrans);
else
ret = DALObj.InsertCurrentData(userID, obj.zTrans);
_LOID = DALObj.LOID;
if (!ret)
{
throw new ApplicationException(DALObj.ErrorMessage);
}
RequisitionItemDAL itemDAL = new RequisitionItemDAL();
itemDAL.DeleteDataByRequisition(data.LOID, obj.zTrans);
for (Int16 i = 0; i < data.REQUISITIONITEM.Count; ++i)
{
RequisitionItemData item = (RequisitionItemData)data.REQUISITIONITEM[i];
itemDAL.ACTIVE = item.ACTIVE;
itemDAL.DISCOUNT = item.DISCOUNT;
itemDAL.DUEDATE = item.DUEDATE;
itemDAL.NETPRICE = item.NETPRICE;
itemDAL.PRODUCT = item.PRODUCT;
itemDAL.QTY = item.QTY;
itemDAL.PRICE = item.PRICE;
itemDAL.REQUISITION = DALObj.LOID;
itemDAL.UNIT = item.UNIT;
itemDAL.ISVAT = item.ISVAT;
itemDAL.OnDB = false;
ret = itemDAL.InsertCurrentData(userID, obj.zTrans);
if (!ret) throw new ApplicationException(itemDAL.ErrorMessage);
}
ret = DALObj.CutStockRequisition(DALObj.LOID, userID, obj.zTrans);
if (!ret) throw new ApplicationException(DALObj.ErrorMessage);
obj.zTrans.Commit();
obj.CloseConnection();
}
catch (Exception ex)
{
obj.zTrans.Rollback();
obj.CloseConnection();
ret = false;
_error = ex.Message;
}
}
else
ret = false;
return ret;
}
private void UpdateData(string userID, ProductOrderData data, System.Data.OracleClient.OracleTransaction zTrans)
{
bool ret = true;
DALObj.GetDataByLOID(data.LOID, zTrans);
DALObj.ACTIVE = data.ACTIVE;
DALObj.CODE = data.CODE;
DALObj.REMARK = data.REMARK;
DALObj.REQDATE = data.REQDATE;
DALObj.REQUISITIONTYPE = data.REQUISITIONTYPE;
DALObj.STATUS = data.STATUS;
DALObj.WAREHOUSE = data.WAREHOUSE;
if (DALObj.OnDB)
ret = DALObj.UpdateCurrentData(userID, zTrans);
else
ret = DALObj.InsertCurrentData(userID, zTrans);
_LOID = DALObj.LOID;
if (!ret)
{
throw new ApplicationException(DALObj.ErrorMessage);
}
RequisitionItemDAL itemDAL = new RequisitionItemDAL();
itemDAL.DeleteDataByRequisition(data.LOID, zTrans);
for (Int16 i = 0; i < data.ITEM.Count; ++i)
{
RequisitionItemData item = (RequisitionItemData)data.ITEM[i];
itemDAL.ACTIVE = item.ACTIVE;
itemDAL.DISCOUNT = item.DISCOUNT;
itemDAL.DUEDATE = item.DUEDATE;
itemDAL.NETPRICE = item.NETPRICE;
itemDAL.PRODUCT = item.PRODUCT;
itemDAL.QTY = item.QTY;
itemDAL.PRICE = item.PRICE;
itemDAL.REQUISITION = DALObj.LOID;
itemDAL.UNIT = item.UNIT;
//itemDAL.DUEDATE = data.DUEDATE;
itemDAL.OnDB = false;
ret = itemDAL.InsertCurrentData(userID, zTrans);
if (!ret) throw new ApplicationException(itemDAL.ErrorMessage);
}
}
public bool DeleteData(ArrayList arrData)
{
bool ret = true;
OracleDBObj obj = new OracleDBObj();
obj.CreateConnection();
obj.CreateTransaction();
try
{
RequisitionItemDAL itemDAL = new RequisitionItemDAL();
for (int i = 0; i < arrData.Count; i++)
{
DALObj.OnDB = false;
DALObj.GetDataByLOID(Convert.ToDouble(arrData[i]), obj.zTrans);
if (DALObj.STATUS != Constz.Requisition.Status.Approved.Code)
{
itemDAL.DeleteDataByRequisition(Convert.ToDouble(arrData[i]), obj.zTrans);
ret = DALObj.DeleteCurrentData(obj.zTrans);
if (!ret) throw new ApplicationException(DALObj.ErrorMessage);
}
else throw new ApplicationException("äÁèÊÒÁÒöźÃÒ¡ÒÃàÅ¢·Õè " + DALObj.CODE + " à¹×èͧ¨Ò¡ÍÂÙèã¹Ê¶Ò¹Ð͹ØÁѵÔÃÒ¡ÒÃáÅéÇ");
}
obj.zTrans.Commit();
obj.CloseConnection();
}
catch (Exception ex)
{
obj.zTrans.Rollback();
obj.CloseConnection();
ret = false;
_error = ex.Message;
}
return ret;
}
private bool NewRequisition(string UserID, ToDoListMinimumStockRequestData data)
{
bool ret = true;
OracleDBObj obj = new OracleDBObj();
obj.CreateConnection();
obj.CreateTransaction();
try
{
RequisitionDAL _DAL = new RequisitionDAL();
_DAL.OnDB = false;
_DAL.OFFICER = data.REQUESTBY;
_DAL.REQDATE = DateTime.Now.Date;
_DAL.ACTIVE = data.ACTIVE;
_DAL.STATUS = data.STATUS;
_DAL.WAREHOUSE = data.WAREHOUSE;
_DAL.REQUISITIONTYPE = data.REQUISITIONTYPE;
_DAL.RESERVEDATE = DateTime.Now.Date;
ret = _DAL.InsertCurrentData(UserID, obj.zTrans);
if (!ret)
{
throw new ApplicationException(_DAL.ErrorMessage);
}
RequisitionItemDAL _DALItem = new RequisitionItemDAL();
for (int i = 0; i < data.ITEM.Count; ++i)
{
_DALItem.OnDB = false;
ToDoListMinimumStockRequestItemData itemData = (ToDoListMinimumStockRequestItemData)data.ITEM[i];
_DALItem.ACTIVE = data.ACTIVE;
_DALItem.PRODUCT = itemData.PRODUCT;
_DALItem.QTY = itemData.QTY;
_DALItem.REQUISITION = _DAL.LOID;
_DALItem.UNIT = itemData.UNIT;
_DALItem.DUEDATE = DateTime.Now.Date;
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 DataTable GetRequisitionItem(double requisition)
{
RequisitionItemDAL itemDAL = new RequisitionItemDAL();
return SearchDAL.GetOrderItemList(requisition);
}
public DataTable GetBOMItem(double requisition)
{
RequisitionItemDAL itemDAL = new RequisitionItemDAL();
return SearchDAL.GetProductionItemList(requisition);
}
public RequisitionData GetData(double loid)
{
RequisitionData data = new RequisitionData();
if (DALObj.GetDataByLOID(loid, null))
{
data.CODE = DALObj.CODE;
data.ACTIVE = DALObj.ACTIVE;
data.CUSTOMER = DALObj.CUSTOMER;
data.GRANDTOT = DALObj.GRANDTOT;
data.STATUS = DALObj.STATUS;
data.TOTAL = DALObj.TOTAL;
data.TOTDIS = DALObj.TOTDIS;
data.TOTVAT = DALObj.TOTVAT;
data.VAT = DALObj.VAT;
data.WAREHOUSE = DALObj.WAREHOUSE;
data.RESERVEDATE = DALObj.RESERVEDATE;
data.CREATEBY = DALObj.CREATEBY;
data.REASON = DALObj.REASON;
data.REMARK = DALObj.REMARK;
RequisitionItemDAL itemDAL = new RequisitionItemDAL();
DataTable dt = GetRequisitionItem(loid);
foreach (DataRow dRow in dt.Rows)
{
RequisitionItemData itemData = new RequisitionItemData();
itemData.BarCode = dRow["BARCODE"].ToString();
itemData.DISCOUNT = Convert.ToDouble(dRow["DISCOUNT"]);
itemData.ISVAT = dRow["ISVAT"].ToString();
itemData.NETPRICE = Convert.ToDouble(dRow["NETPRICE"]);
itemData.PRICE = Convert.ToDouble(dRow["PRICE"]);
itemData.PRODUCT = Convert.ToDouble(dRow["PRODUCT"]);
itemData.QTY = Convert.ToDouble(dRow["QTY"]);
itemData.ProductName = dRow["NAME"].ToString();
itemData.UNIT = Convert.ToDouble(dRow["UNIT"]);
itemData.UnitName = dRow["UNITNAME"].ToString();
data.REQUISITIONITEM.Add(itemData);
}
}
return data;
}
public DataTable GetProductLot(double requisition)
{
RequisitionItemDAL itemDAL = new RequisitionItemDAL();
return CompareLot(SearchDAL.GetReserveItemList(requisition));
}
public DataTable GetReqProductLotWH(double requisition, double warehouse)
{
RequisitionItemDAL itemDAL = new RequisitionItemDAL();
return CompareLot(SearchDAL.GetReqProductionItemList(requisition),warehouse);
}
public DataTable GetProductLotWH(double product)
{
RequisitionItemDAL itemDAL = new RequisitionItemDAL();
return CompareLot(SearchDAL.GetProductionItemList(product));
}
private DataTable GetProductLot(double requisition, double warehouse)
{
RequisitionItemDAL itemDAL = new RequisitionItemDAL();
return CompareLot(StockSearchDAL.GetReserveItemList(requisition), warehouse);
}
public StockOutFGReqData GetRequisitionData(double requisition)
{
StockOutFGReqData data = new StockOutFGReqData();
OracleDBObj obj = new OracleDBObj();
obj.CreateConnection();
obj.CreateTransaction();
try
{
ReqDAL.GetDataByLOID(requisition, obj.zTrans);
data.CADDRESS = ReqDAL.CADDRESS;
data.CFAX = ReqDAL.CFAX;
data.CLASTNAME = ReqDAL.CLASTNAME;
data.CNAME = ReqDAL.CNAME;
data.CTEL = ReqDAL.CTEL;
data.CTITLE = ReqDAL.CTITLE;
data.CUSTOMER = ReqDAL.CUSTOMER;
data.WAREHOUSE = ReqDAL.WAREHOUSE;
data.REFWAREHOUSE = ReqDAL.REFWAREHOUSE == 0 ? ReqDAL.WAREHOUSE : ReqDAL.REFWAREHOUSE;
WarehouseDAL wDAL = new WarehouseDAL();
wDAL.GetDataByLOID(data.WAREHOUSE, obj.zTrans);
data.WAREHOUSECODE = wDAL.CODE;
data.WAREHOUSENAME = wDAL.NAME;
CustomerDAL cDAL = new CustomerDAL();
cDAL.GetDataByLOID(data.CUSTOMER, obj.zTrans);
data.CUSTOMERCODE = cDAL.CODE;
data.CUSTOMERNAME = (cDAL.NAME + " " + cDAL.LASTNAME).Trim();
data.REQUISITION = ReqDAL.LOID;
data.REQUISITIONCODE = ReqDAL.CODE;
data.REQUISITIONTYPE = ReqDAL.REQUISITIONTYPE;
data.RESERVEDATE = ReqDAL.RESERVEDATE;
data.REQDATE = ReqDAL.REQDATE;
DocTypeDAL dDAL = new DocTypeDAL();
dDAL.GetDataByRequisitionType(data.REQUISITIONTYPE, obj.zTrans);
data.DOCTYPE = dDAL.LOID;
RequisitionItemDAL reqItemDAL = new RequisitionItemDAL();
DataTable dt = GetProductLot(data.REQUISITION, data.REFWAREHOUSE);
int i = 1;
foreach (DataRow dRow in dt.Rows)
{
dRow["NO"] = i;
i += 1;
}
data.REQUISITIONITEM = dt;
obj.zTrans.Commit();
obj.CloseConnection();
}
catch (Exception ex)
{
obj.zTrans.Rollback();
obj.CloseConnection();
_error = ex.Message;
}
return data;
}
private void UpdateData(string userID, RequisitionData data, OracleTransaction trans)
{
bool ret = true;
DALObj.REQUISITIONTYPE = Constz.Requisition.RequisitionType.REQ04;
DALObj.ACTIVE = data.ACTIVE;
DALObj.CUSTOMER = data.CUSTOMER;
DALObj.GRANDTOT = data.GRANDTOT;
DALObj.STATUS = data.STATUS;
DALObj.TOTAL = data.TOTAL;
DALObj.TOTDIS = data.TOTDIS;
DALObj.TOTVAT = data.TOTVAT;
DALObj.VAT = data.VAT;
DALObj.WAREHOUSE = data.WAREHOUSE;
DALObj.RESERVEDATE = data.RESERVEDATE;
DALObj.REMARK = data.REMARK;
DALObj.REASON = data.REASON;
if (DALObj.OnDB)
ret = DALObj.UpdateCurrentData(userID, trans);
else
{
DALObj.REQDATE = data.RESERVEDATE;
ret = DALObj.InsertCurrentData(userID, trans);
}
if (!ret)
{
throw new ApplicationException(DALObj.ErrorMessage);
}
RequisitionItemDAL itemDAL = new RequisitionItemDAL();
itemDAL.DeleteDataByRequisition(data.LOID, trans);
for (Int16 i = 0; i < data.REQUISITIONITEM.Count; ++i)
{
RequisitionItemData item = (RequisitionItemData)data.REQUISITIONITEM[i];
itemDAL.ACTIVE = item.ACTIVE;
itemDAL.DISCOUNT = item.DISCOUNT;
itemDAL.DUEDATE = item.DUEDATE;
itemDAL.NETPRICE = item.NETPRICE;
itemDAL.PRODUCT = item.PRODUCT;
itemDAL.QTY = item.QTY;
itemDAL.PRICE = item.PRICE;
itemDAL.REQUISITION = DALObj.LOID;
itemDAL.UNIT = item.UNIT;
itemDAL.ISVAT = item.ISVAT;
itemDAL.OnDB = false;
ret = itemDAL.InsertCurrentData(userID, trans);
if (!ret) throw new ApplicationException(itemDAL.ErrorMessage);
}
}
private void UpdateData(string userID, ProductReserveData data, System.Data.OracleClient.OracleTransaction trans)
{
bool ret = true;
if (ValidateData(data))
{
if (SearchObj.GetDataByRefLOID(data.LOID, data.REFLOID, trans).Rows.Count > 0)
throw new ApplicationException("äÁèÊÒÁÒö·ÓÃÒ¡ÒÃä´é à¹×èͧ¨Ò¡ãºàÊÃ稷ÕèàÅ×Í¡ ÍÂÙèÃÐËÇèÒ§´Óà¹Ô¹¡ÒÃŴ˹ÕéËÃ×ÍŴ˹ÕéàÊÃç¨ÊÔé¹áÅéÇ");
DALObj.OnDB = false;
DALObj.GetDataByLOID(data.LOID, trans);
DALObj.CODE = data.CODE;
DALObj.ACTIVE = data.ACTIVE;
DALObj.CADDRESS = data.CADDRESS;
DALObj.CEMAIL = data.CEMAIL;
DALObj.CFAX = data.CFAX;
DALObj.CLASTNAME = data.CLASTNAME;
DALObj.CNAME = data.CNAME;
DALObj.CTEL = data.CTEL;
DALObj.CTITLE = data.CTITLE;
DALObj.CUSTOMER = data.CUSTOMER;
DALObj.DUEDATE = data.DUEDATE;
DALObj.GRANDTOT = data.GRANDTOT;
DALObj.REASON = data.REASON;
DALObj.REFLOID = data.REFLOID;
DALObj.REFTABLE = data.REFTABLE;
DALObj.REMARK = data.REMARK;
DALObj.RESERVEDATE = data.RESERVEDATE;
DALObj.REQUISITIONTYPE = data.REQUISITIONTYPE;
DALObj.STATUS = data.STATUS;
DALObj.TOTAL = data.TOTAL;
DALObj.TOTDIS = data.TOTDIS;
DALObj.TOTVAT = data.TOTVAT;
DALObj.VAT = data.VAT;
DALObj.WAREHOUSE = data.WAREHOUSE;
DALObj.REQDATE = data.REQDATE;
DALObj.INVCODE = data.INVCODE;
if (DALObj.OnDB)
ret = DALObj.UpdateCurrentData(userID, trans);
else
ret = DALObj.InsertCurrentData(userID, trans);
_LOID = DALObj.LOID;
if (!ret)
{
throw new ApplicationException(DALObj.ErrorMessage);
}
RequisitionItemDAL itemDAL = new RequisitionItemDAL();
itemDAL.DeleteDataByRequisition(data.LOID, trans);
for (Int16 i = 0; i < data.ITEM.Count; ++i)
{
RequisitionItemData item = (RequisitionItemData)data.ITEM[i];
itemDAL.ACTIVE = item.ACTIVE;
itemDAL.DISCOUNT = item.DISCOUNT;
itemDAL.DUEDATE = item.DUEDATE;
itemDAL.NETPRICE = item.NETPRICE;
itemDAL.PRODUCT = item.PRODUCT;
itemDAL.QTY = item.QTY;
itemDAL.PRICE = item.PRICE;
itemDAL.REQUISITION = DALObj.LOID;
itemDAL.UNIT = item.UNIT;
itemDAL.DUEDATE = data.DUEDATE;
itemDAL.REFTABLE = item.REFTABLE;
itemDAL.REFLOID = item.REFLOID;
itemDAL.OnDB = false;
ret = itemDAL.InsertCurrentData(userID, trans);
if (!ret) throw new ApplicationException(itemDAL.ErrorMessage);
}
}
else
throw new ApplicationException(_error);
}
public bool DeleteData(string userID, ArrayList arrLOID)
{
bool ret = true;
OracleDBObj obj = new OracleDBObj();
obj.CreateConnection();
obj.CreateTransaction();
try
{
RequisitionItemDAL itemDAL;
for (int i = 0; i < arrLOID.Count; ++i)
{
_dal = new RequisitionDAL();
double loid = Convert.ToDouble(arrLOID[i]);
DALObj.OnDB = false;
DALObj.GetDataByLOID(loid, obj.zTrans);
if (DALObj.STATUS == Constz.Requisition.Status.Waiting.Code)
{
itemDAL = new RequisitionItemDAL();
ret = itemDAL.DeleteDataByRequisition(loid, obj.zTrans);
if (!ret) throw new ApplicationException(itemDAL.ErrorMessage);
ret = DALObj.DeleteCurrentData(obj.zTrans);
if (!ret) throw new ApplicationException(DALObj.ErrorMessage);
}
}
obj.zTrans.Commit();
obj.CloseConnection();
}
catch (Exception ex)
{
obj.zTrans.Rollback();
obj.CloseConnection();
ret = false;
_error = ex.Message;
}
return ret;
}
private DataTable GetRequisitionItem(double requisition)
{
RequisitionItemDAL itemDAL = new RequisitionItemDAL();
return itemDAL.GetDataByRequisition(requisition, null);
}
public bool NewStockOut(string userID, double requisition, double warehouse)
{
bool ret = true;
OracleDBObj obj = new OracleDBObj();
obj.CreateConnection();
obj.CreateTransaction();
try
{
RequisitionDAL reqDAL = new RequisitionDAL();
reqDAL.GetDataByLOID(requisition, obj.zTrans);
RequisitionItemDAL reqItemDAL = new RequisitionItemDAL();
DataTable dt = reqItemDAL.GetDataByRequisition(requisition, obj.zTrans);
DocTypeDAL docDAL = new DocTypeDAL();
docDAL.GetDataByRequisitionType(reqDAL.REQUISITIONTYPE, obj.zTrans);
StockOutDAL _DAL = new StockOutDAL();
_DAL.OnDB = false;
_DAL.ACTIVE = Constz.ActiveStatus.Active;
_DAL.DOCTYPE = docDAL.LOID;
_DAL.RECEIVER = (reqDAL.CUSTOMER != 0 ? reqDAL.CUSTOMER : reqDAL.WAREHOUSE);
_DAL.REFLOID = reqDAL.LOID;
_DAL.REFTABLE = reqDAL.TableName;
_DAL.REQDATE = reqDAL.REQDATE;
_DAL.SENDER = warehouse;
_DAL.STATUS = Constz.Requisition.Status.Waiting.Code;
_DAL.CTITLE = reqDAL.CTITLE;
_DAL.CNAME = reqDAL.CNAME;
_DAL.CLASTNAME = reqDAL.CLASTNAME;
_DAL.CADDRESS = reqDAL.CADDRESS;
_DAL.CFAX = reqDAL.CFAX;
_DAL.CTEL = reqDAL.CTEL;
ret = _DAL.InsertCurrentData(userID, obj.zTrans);
if (!ret)
{
throw new ApplicationException(_DAL.ErrorMessage);
}
StockOutItemDAL _DALItem = new StockOutItemDAL();
foreach (DataRow dRow in dt.Rows)
{
StockFGDAL fgDAL = new StockFGDAL();
double qty = Convert.ToDouble(dRow["QTY"]);
DataTable dtStock = fgDAL.GetProductStock(warehouse, Convert.ToDouble(dRow["PRODUCT"]), obj.zTrans);
foreach (DataRow sRow in dtStock.Rows)
{
_DALItem.OnDB = false;
_DALItem.LOTNO = sRow["LOTNO"].ToString();
_DALItem.PRODUCT = Convert.ToDouble(dRow["PRODUCT"]);
if (qty >= Convert.ToDouble(sRow["QTY"]))
_DALItem.QTY = Convert.ToDouble(sRow["QTY"]);
else
_DALItem.QTY = qty;
_DALItem.REFLOID = Convert.ToDouble(dRow["LOID"]);
_DALItem.REFTABLE = "REQUISITIONITEM";
_DALItem.STATUS = Constz.Requisition.Status.Waiting.Code;
_DALItem.STOCKOUT = _DAL.LOID;
_DALItem.UNIT = Convert.ToDouble(dRow["UNIT"]);
_DALItem.ACTIVE = Constz.ActiveStatus.Active;
_DALItem.PRICE = Convert.ToDouble(dRow["PRICE"]);
double remain = _DALItem.GetRemainQTYStockFG(_DALItem.LOTNO, _DALItem.PRODUCT, obj.zTrans);
_DALItem.REMAIN = remain;
qty -= Convert.ToDouble(sRow["QTY"]);
ret = _DALItem.InsertCurrentData(userID, obj.zTrans);
if (!ret)
{
throw new ApplicationException(_DALItem.ErrorMessage);
}
if (qty <= 0) break;
}
}
_LOID = _DAL.LOID;
obj.zTrans.Commit();
obj.CloseConnection();
}
catch (Exception ex)
{
obj.zTrans.Rollback();
obj.CloseConnection();
ret = false;
_error = ex.Message;
}
return ret;
}
public DataTable GetProductItemList(string popup, string warehouse, string customer, string requisitiontype)
{
RequisitionItemDAL itemDAL = new RequisitionItemDAL();
DataTable dt = SearchDAL.GetProductItemList(popup,warehouse,customer, requisitiontype);
for (int i = 0; i < dt.Rows.Count; ++i)
{
dt.Rows[i]["RANK"] = i + 1;
}
return dt;
}
public bool DeleteData(ArrayList arrData)
{
bool ret = true;
OracleDBObj obj = new OracleDBObj();
obj.CreateConnection();
obj.CreateTransaction();
try
{
RequisitionItemDAL itemDAL = new RequisitionItemDAL();
for (int i = 0; i < arrData.Count; i++)
{
DALObj.GetDataByLOID(Convert.ToDouble(arrData[i]), obj.zTrans);
itemDAL.DeleteDataByRequisition(Convert.ToDouble(arrData[i]), obj.zTrans);
ret = DALObj.DeleteCurrentData(obj.zTrans);
if (!ret) throw new ApplicationException(DALObj.ErrorMessage);
}
obj.zTrans.Commit();
obj.CloseConnection();
}
catch (Exception ex)
{
obj.zTrans.Rollback();
obj.CloseConnection();
ret = false;
_error = ex.Message;
}
return ret;
}
public DataTable GetRequisitionItem(double requisition, string warehouse)
{
RequisitionItemDAL itemDAL = new RequisitionItemDAL();
DataTable dt = SearchDAL.GetPurchaseItemList(requisition, warehouse);
for (int i = 0; i < dt.Rows.Count; ++i)
{
dt.Rows[i]["RANK"] = i + 1;
}
return dt;
}
public DataTable GetRequisitionItemBlank()
{
RequisitionItemDAL itemDAL = new RequisitionItemDAL();
return SearchDAL.GetOrderItemListBlank();
}
private void UpdateData(string userID, ProductReserveData data, System.Data.OracleClient.OracleTransaction zTrans)
{
bool ret = true;
DALObj.GetDataByLOID(data.LOID, zTrans);
DALObj.ACTIVE = data.ACTIVE;
DALObj.CADDRESS = data.CADDRESS;
DALObj.CEMAIL = data.CEMAIL;
DALObj.CFAX = data.CFAX;
DALObj.CLASTNAME = data.CLASTNAME;
DALObj.CNAME = data.CNAME;
// DALObj.CODE = data.CODE;
DALObj.CTEL = data.CTEL;
DALObj.CTITLE = data.CTITLE;
DALObj.CUSTOMER = data.CUSTOMER;
DALObj.DUEDATE = data.DUEDATE;
DALObj.GRANDTOT = data.GRANDTOT;
DALObj.REMARK = data.REMARK;
DALObj.REQDATE = data.REQDATE;
//DALObj.REQUISITIONTYPE = data.REQUISITIONTYPE;
DALObj.REFTYPELOID = data.REFTYPELOID;
DALObj.REFTYPETABLE = data.REFTYPETABLE;
DALObj.STATUS = data.STATUS;
DALObj.TOTAL = data.TOTAL;
DALObj.TOTDIS = data.TOTDIS;
DALObj.TOTVAT = data.TOTVAT;
DALObj.VAT = data.VAT;
DALObj.WAREHOUSE = data.WAREHOUSE;
DALObj.DELIVERYTYPE = data.CDELIVERY;
DALObj.OTHER = data.OTHER;
if (DALObj.INVCODE == "")
DALObj.INVCODE = DALObj.GetInvCode(1, zTrans);
DALObj.PAYMENTCONDITION = data.PAYMENTCONDITION;
DALObj.CREDITDATE = data.CREDITDATE;
DALObj.RESERVEDATE = data.RESERVEDATE;
DALObj.OTHER = data.OTHER;
DALObj.PAYMENT = data.PAYMENT;
DALObj.CREDITCARDID = data.CREDITCARDID;
DALObj.CREDITTYPE = data.CREDITTYPE;
DALObj.BANK = data.BANK;
DALObj.BANKBRANCH = data.BANKBRANCH;
DALObj.CHEQUE = data.CHEQUE;
DALObj.CHEQUEDATE = data.CHEQUEDATE;
DALObj.REASON = data.REASON;
DALObj.REFNO = data.REFNO;
if (DALObj.OnDB)
ret = DALObj.UpdateCurrentData(userID, zTrans);
else
DALObj.REQUISITIONTYPE = 11;
ret = DALObj.InsertCurrentData(userID, zTrans);
_LOID = DALObj.LOID;
if (!ret)
{
throw new ApplicationException(DALObj.ErrorMessage);
}
RequisitionItemDAL itemDAL = new RequisitionItemDAL();
itemDAL.DeleteDataByRequisition(data.LOID, zTrans);
for (Int16 i = 0; i < data.ITEM.Count; ++i)
{
RequisitionItemData item = (RequisitionItemData)data.ITEM[i];
itemDAL.ACTIVE = item.ACTIVE;
itemDAL.DISCOUNT = item.DISCOUNT;
itemDAL.DUEDATE = item.DUEDATE;
itemDAL.NETPRICE = item.NETPRICE;
itemDAL.PRODUCT = item.PRODUCT;
itemDAL.QTY = item.QTY;
itemDAL.PRICE = item.PRICE;
itemDAL.REQUISITION = DALObj.LOID;
itemDAL.UNIT = item.UNIT;
itemDAL.DUEDATE = data.DUEDATE;
itemDAL.OnDB = false;
ret = itemDAL.InsertCurrentData(userID, zTrans);
if (!ret) throw new ApplicationException(DALObj.ErrorMessage);
}
}
public DataTable GetProductLot(double refloid, double pploid)
{
RequisitionItemDAL itemDAL = new RequisitionItemDAL();
return CompareLot(GetReqmaterial(refloid), pploid);
}
private void UpdateData(string userID, ProductReserveData data, System.Data.OracleClient.OracleTransaction zTrans)
{
bool ret = true;
if (ValidateData(data))
{
DALObj.OnDB = false;
DALObj.GetDataByLOID(data.LOID, zTrans);
DALObj.ACTIVE = data.ACTIVE;
DALObj.CADDRESS = data.CADDRESS;
DALObj.CEMAIL = data.CEMAIL;
DALObj.CFAX = data.CFAX;
DALObj.CLASTNAME = data.CLASTNAME;
DALObj.CNAME = data.CNAME;
DALObj.CODE = data.CODE;
DALObj.CTEL = data.CTEL;
DALObj.CTITLE = data.CTITLE;
DALObj.CUSTOMER = data.CUSTOMER;
DALObj.DUEDATE = data.DUEDATE;
DALObj.GRANDTOT = data.GRANDTOT;
DALObj.REMARK = data.REMARK;
DALObj.RESERVEDATE = data.RESERVEDATE;
DALObj.REQUISITIONTYPE = data.REQUISITIONTYPE;
DALObj.STATUS = data.STATUS;
DALObj.TOTAL = data.TOTAL;
DALObj.TOTDIS = data.TOTDIS;
DALObj.TOTVAT = data.TOTVAT;
DALObj.VAT = data.VAT;
DALObj.WAREHOUSE = data.WAREHOUSE;
DALObj.REFTYPELOID = data.REQUISITIONTYPE;
DALObj.REFTYPETABLE = "REQUISITIONTYPE";
if (DALObj.OnDB)
ret = DALObj.UpdateCurrentData(userID, zTrans);
else
ret = DALObj.InsertCurrentData(userID, zTrans);
_LOID = DALObj.LOID;
if (!ret)
{
throw new ApplicationException(DALObj.ErrorMessage);
}
RequisitionItemDAL itemDAL = new RequisitionItemDAL();
itemDAL.DeleteDataByRequisition(data.LOID, zTrans);
for (Int16 i = 0; i < data.ITEM.Count; ++i)
{
RequisitionItemData item = (RequisitionItemData)data.ITEM[i];
itemDAL.ACTIVE = item.ACTIVE;
itemDAL.DISCOUNT = item.DISCOUNT;
itemDAL.DUEDATE = item.DUEDATE;
itemDAL.NETPRICE = item.NETPRICE;
itemDAL.PRODUCT = item.PRODUCT;
itemDAL.QTY = item.QTY;
itemDAL.PRICE = item.PRICE;
itemDAL.REQUISITION = DALObj.LOID;
itemDAL.UNIT = item.UNIT;
itemDAL.DUEDATE = data.DUEDATE;
itemDAL.ISVAT = item.ISVAT;
itemDAL.OnDB = false;
ret = itemDAL.InsertCurrentData(userID, zTrans);
if (!ret) throw new ApplicationException(itemDAL.ErrorMessage);
}
}
}
