private void SetData(ProductOrderData data) { if (data.LOID == 0) { data.STATUS = Constz.Requisition.Status.Waiting.Code; this.txtCreateBy.Text = Authz.CurrentUserInfo.UserID; this.ctlReqDate.DateValue = DateTime.Now.Date; this.txtWarehouse.Text = Authz.CurrentUserInfo.Warehouse.ToString(); } else { this.ctlReqDate.DateValue = data.REQDATE; this.txtCreateBy.Text = data.CREATEBY; this.txtWarehouse.Text = data.WAREHOUSE.ToString(); } this.txtLOID.Text = data.LOID.ToString(); this.txtRequisitionCode.Text = data.CODE; this.txtRemark.Text = data.REMARK; this.txtStatus.Text = data.STATUS; this.txtStatusName.Text = Appz.GetStatusName(data.STATUS); SetGrvItem(data.STATUS); if (data.STATUS == Constz.Requisition.Status.Approved.Code || data.STATUS == Constz.Requisition.Status.Void.Code) { this.ctlToolbar.BtnSaveShow = false; this.ctlToolbar.BtnCancelShow = false; this.ctlToolbar.BtnSubmitShow = false; } this.ctlToolbar.ClientClickPrint = ABB.Global.Appz.ReportScript(Constz.Report.ProductOrder, data.LOID) + " return false;"; }
public ProductOrderData GetData(double loid) { ProductOrderData data = new ProductOrderData(); if (DALObj.GetDataByLOID(loid, null)) { data.LOID = DALObj.LOID; data.ACTIVE = DALObj.ACTIVE; data.CODE = DALObj.CODE; data.CREATEBY = DALObj.CREATEBY; data.CUSTOMER = DALObj.CUSTOMER; data.REMARK = DALObj.REMARK; data.RESERVEDATE = DALObj.RESERVEDATE; data.REQUISITIONTYPE = DALObj.REQUISITIONTYPE; data.STATUS = DALObj.STATUS; data.TOTAL = DALObj.TOTAL; data.WAREHOUSE = DALObj.WAREHOUSE; data.REFWAREHOUSE = DALObj.REFWAREHOUSE; data.TOTDIS = DALObj.TOTDIS; data.TOTVAT = DALObj.TOTVAT; data.GRANDTOT = DALObj.GRANDTOT; WarehouseDAL itemDAL = new WarehouseDAL(); itemDAL.GetDataByLOID(DALObj.WAREHOUSE, null); data.WAREHOUSENAME = itemDAL.NAME; } return data; }
public bool ValidateData(ProductOrderData data) { bool ret = true; if (data.ITEM.Count == 0) { ret = false; _error = "¡ÃسÒÃкØÃÒ¡ÒÃÊÔ¹¤éÒ"; } return ret; }
public ProductOrderData GetData(double loid) { ProductOrderData data = new ProductOrderData(); if (DALObj.GetDataByLOID(loid, null)) { data.LOID = DALObj.LOID; data.ACTIVE = DALObj.ACTIVE; data.CODE = DALObj.CODE; data.CREATEBY = DALObj.CREATEBY; data.REMARK = DALObj.REMARK; data.REQDATE = DALObj.REQDATE; data.REQUISITIONTYPE = DALObj.REQUISITIONTYPE; data.STATUS = DALObj.STATUS; data.WAREHOUSE = DALObj.WAREHOUSE; data.CUSTOMER = DALObj.CUSTOMER; } return data; }
private void SetData(ProductOrderData data) { if (data.LOID == 0) { data.STATUS = Constz.Requisition.Status.Waiting.Code; data.CREATEBY = Authz.CurrentUserInfo.UserID; data.WAREHOUSE = Authz.CurrentUserInfo.Warehouse; data.RESERVEDATE = DateTime.Today; data.REFWAREHOUSE = Constz.ReadyMadeDepartment.LOID; WarehouseDAL itemDAL = new WarehouseDAL(); itemDAL.GetDataByLOID(Authz.CurrentUserInfo.Warehouse, null); data.WAREHOUSENAME = itemDAL.NAME; } this.txtLOID.Text = data.LOID.ToString(); this.txtStatus.Text = data.STATUS; this.txtRequisitionCode.Text = data.CODE; this.ctlReqDate.DateValue = data.RESERVEDATE.Year == 1 ? DateTime.Now : data.RESERVEDATE; this.txtTotal.Text = data.TOTAL.ToString(Constz.DblFormat); this.txtRemark.Text = data.REMARK; this.txtCreateBy.Text = data.CREATEBY; this.txtStatusName.Text = Appz.GetStatusName(data.STATUS); this.txtWarehouse.Text = data.WAREHOUSE.ToString(); this.cmbRefWarehouse.SelectedIndex = this.cmbRefWarehouse.Items.IndexOf(this.cmbRefWarehouse.Items.FindByValue(data.REFWAREHOUSE.ToString())); this.txtCustomer.Text = data.CUSTOMER.ToString(); this.txtWarehouseName.Text = data.WAREHOUSENAME; this.txtTotal.Text = data.TOTAL.ToString(Constz.DblFormat); this.txtTotalDiscount.Text = data.TOTDIS.ToString(Constz.DblFormat); this.txtVat.Text = data.VAT.ToString(); this.txtTotalVat.Text = data.TOTVAT.ToString(Constz.DblFormat); this.txtGrandTotal.Text = data.GRANDTOT.ToString(Constz.DblFormat); this.txtNet.Text = data.GRANDTOT.ToString(Constz.IntFormat); //if (this.cmbRefWarehouse.SelectedItem.Value == "0") //{ // data.REFWAREHOUSE = Constz.ReadyMadeDepartment.LOID; // this.cmbRefWarehouse.SelectedIndex = this.cmbRefWarehouse.Items.IndexOf(this.cmbRefWarehouse.Items.FindByValue(data.REFWAREHOUSE.ToString())); //} SetGrvItem(data.STATUS); if (data.STATUS == Constz.Requisition.Status.Approved.Code || data.STATUS == Constz.Requisition.Status.Void.Code) { this.ctlToolbar.BtnSaveShow = false; this.ctlToolbar.BtnCancelShow = false; this.ctlToolbar.BtnSubmitShow = false; } this.grvItem.Columns[indexCHECk].Visible = (data.STATUS == Constz.Requisition.Status.Waiting.Code); this.ctlToolbar.ClientClickPrint = ABB.Global.Appz.ReportScript(Constz.Report.ProductRequestInShop, data.LOID) + " return false; "; this.ctlToolbarItem.Visible = (data.STATUS == Constz.Requisition.Status.Waiting.Code); }
private ProductOrderData GetData() { ProductOrderData data = new ProductOrderData(); data.LOID = Convert.ToDouble(this.txtLOID.Text == "" ? "0" : this.txtLOID.Text); data.ACTIVE = Constz.ActiveStatus.Active; data.CODE = this.txtRequisitionCode.Text.Trim(); // data.CUSTOMER = Constz.ReadyMadeDepartment.LOID; data.CUSTOMER = Convert.ToDouble(this.txtWarehouse.Text == "" ? "0" : this.txtWarehouse.Text); data.ITEM = ItemObj.GetItemList(); data.REMARK = this.txtRemark.Text.Trim(); data.RESERVEDATE = this.ctlReqDate.DateValue; data.REQUISITIONTYPE = Constz.Requisition.RequisitionType.REQ06; data.STATUS = this.txtStatus.Text.Trim(); data.TOTAL = Convert.ToDouble(this.txtTotal.Text == "" ? "0" : this.txtTotal.Text); data.WAREHOUSE = Convert.ToDouble(this.txtWarehouse.Text == "" ? "0" : this.txtWarehouse.Text); data.REFWAREHOUSE = Convert.ToDouble(this.cmbRefWarehouse.SelectedItem.Value); data.CUSTOMER = Convert.ToDouble(this.txtCustomer.Text == "" ? "0" : this.txtCustomer.Text); data.TOTAL = Convert.ToDouble(this.txtTotal.Text == "" ? "0" : this.txtTotal.Text); data.TOTDIS = Convert.ToDouble(this.txtTotalDiscount.Text == "" ? "0" : this.txtTotalDiscount.Text); data.TOTVAT = Convert.ToDouble(this.txtTotalVat.Text == "" ? "0" : this.txtTotalVat.Text); data.VAT = Convert.ToDouble(this.txtVat.Text == "" ? "0" : this.txtVat.Text); data.WAREHOUSENAME = this.txtWarehouseName.Text.Trim(); return data; }
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 UpdateData(string userID, ProductOrderData data) { bool ret = true; if (ValidateData(data)) { OracleDBObj obj = new OracleDBObj(); obj.CreateConnection(); obj.CreateTransaction(); try { UpdateData(userID, data, obj.zTrans); obj.zTrans.Commit(); obj.CloseConnection(); } catch (Exception ex) { obj.zTrans.Rollback(); obj.CloseConnection(); ret = false; _error = ex.Message; } } else ret = false; return ret; }
public bool CommitData(string userID, ProductOrderData data) { bool ret = true; if (ValidateData(data)) { OracleDBObj obj = new OracleDBObj(); obj.CreateConnection(); obj.CreateTransaction(); try { UpdateData(userID, data, obj.zTrans); ret = DALObj.CutStockRequisition(_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 ProductOrderData GetData() { ProductOrderData data = new ProductOrderData(); data.REQUISITIONTYPE = Constz.Requisition.RequisitionType.REQ07; data.LOID = Convert.ToDouble(this.txtLOID.Text == "" ? "0" : this.txtLOID.Text); data.ACTIVE = Constz.ActiveStatus.Active; data.CODE = this.txtRequisitionCode.Text.Trim(); data.ITEM = ItemObj.GetItemList(); data.REMARK = this.txtRemark.Text.Trim(); data.REQDATE = this.ctlReqDate.DateValue; data.STATUS = this.txtStatus.Text.Trim(); data.CUSTOMER = Constz.ProductionDepartment.LOID; data.WAREHOUSE = Convert.ToDouble(this.txtWarehouse.Text == "" ? "0" : this.txtWarehouse.Text); return data; }