public bool InsertData(string UserID, CustomerData cusData) { Boolean ret = true; CustomerDAL oDAL = new CustomerDAL(); SetDataToDAL(oDAL, cusData); ret = oDAL.InsertCurrentData(UserID, null); if (ret == false) _error = oDAL.ErrorMessage; return ret; }
public bool UpdateData(string UserID, CustomerData cusData) { Boolean ret = true; CustomerDAL oDAL = new CustomerDAL(); //double LOID = 0; //LOID = GetLOID(cusData.CODE); oDAL.GetDataByLOID(cusData.LOID, null); SetDataToDAL(oDAL, cusData); ret = oDAL.UpdateCurrentData(UserID, null); if (ret == false) _error = oDAL.ErrorMessage; return ret; }
public bool GetCustomerDiscount(double customer, double totalPrice) { bool ret = true; _DISCOUNT = 0; OracleDBObj obj = new OracleDBObj(); obj.CreateConnection(); obj.CreateTransaction(); try { CustomerDAL cDAL = new CustomerDAL(); cDAL.GetDataByLOID(customer, obj.zTrans); if (cDAL.OnDB) { if (cDAL.EFDATE.Date <= DateTime.Today && DateTime.Today <= cDAL.EPDATE.Date) _DISCOUNT = DALObj.GetMemberDiscount(cDAL.MEMBERTYPE, totalPrice, obj.zTrans); } obj.zTrans.Commit(); obj.CloseConnection(); } catch (Exception ex) { obj.zTrans.Rollback(); obj.CloseConnection(); ret = false; _error = ex.Message; } return ret; }
public bool DeleteData(ArrayList arrLOID) { bool ret = true; OracleDBObj objDB = new OracleDBObj(); objDB.CreateConnection(); objDB.CreateTransaction(); try { foreach (double LOID in arrLOID) { CustomerDAL oDAL = new CustomerDAL(); oDAL.GetDataByLOID(LOID, objDB.zTrans); oDAL.DeleteCurrentData(objDB.zTrans); } objDB.zTrans.Commit(); ret = true; } catch(Exception ex) { objDB.zTrans.Rollback(); _error = ex.Message; ret = false; } objDB.CloseConnection(); return ret; }
public CustomerData GetCustomerData(double loid) { CustomerDAL dal = new CustomerDAL(); CustomerData data = new CustomerData(); dal.GetDataByLOID(loid, null); data.ACTIVE = dal.ACTIVE; data.BILLADDRESS = dal.BILLADDRESS; data.BILLAMPHUR = dal.BILLAMPHUR; data.BILLEMAIL = dal.BILLEMAIL; data.BILLFAX = dal.BILLFAX; data.BILLPROVINCE = dal.BILLPROVINCE; data.BILLROAD = dal.BILLROAD; data.BILLTAMBOL = dal.BILLTAMBOL; data.BILLTEL = dal.BILLTEL; data.BILLZIPCODE = dal.BILLZIPCODE; data.CADDRESS = dal.CADDRESS; data.CAMPHUR = dal.CAMPHUR; data.CEMAIL = dal.CEMAIL; data.CFAX = dal.CFAX; data.CLASTNAME = dal.CLASTNAME; data.CMOBILE = dal.CMOBILE; data.CNAME = dal.CNAME; data.CODE = dal.CODE; data.CPROVINCE = dal.CPROVINCE; data.CREDITAMOUNT = dal.CREDITAMOUNT; data.CREDITDAY = dal.CREDITDAY; data.CROAD = dal.CROAD; data.CTAMBOL = dal.CTAMBOL; data.CTEL = dal.CTEL; data.CTITLE = dal.CTITLE; data.CUSTOMERTYPE = dal.CUSTOMERTYPE; data.CZIPCODE = dal.CZIPCODE; data.DELIVERTYPE = dal.DELIVERTYPE; data.EFDATE = dal.EFDATE; data.EPDATE = dal.EPDATE; data.IDENTITY = dal.IDENTITY; data.LASTNAME = dal.LASTNAME; data.MEMBERTYPE = dal.MEMBERTYPE; data.NAME = dal.NAME; data.PAYMENT = dal.PAYMENT; data.REMARK = dal.REMARK; data.SENDADDRESS = dal.SENDADDRESS; data.SENDAMPHUR = dal.SENDAMPHUR; data.SENDEMAIL = dal.SENDEMAIL; data.SENDFAX = dal.SENDFAX; data.SENDPLACE = dal.SENDPLACE; data.SENDPROVINCE = dal.SENDPROVINCE; data.SENDROAD = dal.SENDROAD; data.SENDTAMBOL = dal.SENDTAMBOL; data.SENDTEL = dal.SENDTEL; data.SENDZIPCODE = dal.SENDZIPCODE; data.TITLE = dal.TITLE; return data; }
private void SetDataToDAL(CustomerDAL oDAL, CustomerData cusData) { oDAL.ACTIVE = "1"; //-------------------- ª×èͺÃÔÉÑ·/ÅÙ¡¤éÒ --------------------------------------- oDAL.CODE = cusData.CODE; oDAL.CUSTOMERTYPE = cusData.CUSTOMERTYPE; oDAL.IDENTITY = cusData.IDENTITY; oDAL.TITLE = cusData.TITLE; oDAL.NAME = cusData.NAME; oDAL.LASTNAME = cusData.LASTNAME; oDAL.MEMBERTYPE = cusData.MEMBERTYPE; oDAL.EFDATE = cusData.EFDATE; oDAL.EPDATE = cusData.EPDATE; //-------------------- à§×è͹䢡ÒêÓÃÐà§Ô¹ --------------------------------------- oDAL.PAYMENT = cusData.PAYMENT; oDAL.CREDITDAY = cusData.CREDITDAY; oDAL.CREDITAMOUNT = cusData.CREDITAMOUNT; //-------------------- ·ÕèÍÂÙèºÃÔÉÑ·/ÅÙ¡¤éÒ/ÊÁÒªÔ¡ --------------------------------------- oDAL.BILLADDRESS = cusData.BILLADDRESS; oDAL.BILLROAD = cusData.BILLROAD; oDAL.BILLPROVINCE = cusData.BILLPROVINCE; oDAL.BILLAMPHUR = cusData.BILLAMPHUR; oDAL.BILLTAMBOL = cusData.BILLTAMBOL; oDAL.BILLZIPCODE = cusData.BILLZIPCODE; oDAL.BILLTEL = cusData.BILLTEL; oDAL.BILLFAX = cusData.BILLFAX; oDAL.BILLEMAIL = cusData.BILLEMAIL; //-------------------- ª×èͼÙéµÔ´µèÍ --------------------------------------- oDAL.CTITLE = cusData.CTITLE; oDAL.CNAME = cusData.CNAME; oDAL.CLASTNAME = cusData.CLASTNAME; oDAL.CTEL = cusData.CTEL; oDAL.CMOBILE = cusData.CMOBILE; oDAL.CEMAIL = cusData.CEMAIL; oDAL.CADDRESS = cusData.CADDRESS; oDAL.CROAD = cusData.CROAD; oDAL.CPROVINCE = cusData.CPROVINCE; oDAL.CAMPHUR = cusData.CAMPHUR; oDAL.CTAMBOL = cusData.CTAMBOL; oDAL.CZIPCODE = cusData.CZIPCODE; //-------------------- ʶҹ·ÕèÊè§ÊÔ¹¤éÒ --------------------------------------- oDAL.SENDPLACE = cusData.SENDPLACE; oDAL.DELIVERTYPE = cusData.DELIVERTYPE; oDAL.SENDADDRESS = cusData.SENDADDRESS; oDAL.SENDROAD = cusData.SENDROAD; oDAL.SENDPROVINCE = cusData.SENDPROVINCE; oDAL.SENDAMPHUR = cusData.SENDAMPHUR; oDAL.SENDTAMBOL = cusData.SENDTAMBOL; oDAL.SENDZIPCODE = cusData.SENDZIPCODE; oDAL.SENDTEL = cusData.SENDTEL; oDAL.SENDFAX = cusData.SENDFAX; oDAL.SENDEMAIL = cusData.SENDEMAIL; //-------------------- ËÁÒÂà赯 --------------------------------------- oDAL.REMARK = cusData.REMARK; }
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; 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; obj.zTrans.Commit(); obj.CloseConnection(); } catch (Exception ex) { obj.zTrans.Rollback(); obj.CloseConnection(); _error = ex.Message; } return data; }
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; }
public StockOutFGReqData GetcustomerData(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; } catch (Exception ex) { obj.zTrans.Rollback(); obj.CloseConnection(); _error = ex.Message; } return data; }