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