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