private void SetData(StockoutBasketData data) { this.txtLOID.Text = data.LOID.ToString(); this.txtStatus.Text = data.STATUS; this.txtPDLOID.Text = data.PRODUCT.ToString(); this.txtWareHouse.Text = data.WAREHOUSE.ToString(); this.cmbBasketType.SelectedIndex = this.cmbBasketType.Items.IndexOf(this.cmbBasketType.Items.FindByValue(data.TYPE)); if (this.txtPDLOID.Text != "") SetProductPackage(this.txtPDLOID.Text); this.txtBasketQty.Text = data.QTY.ToString(); this.txtBasketCode.Text = data.CODE; this.ctlCheckDate.DateValue = data.CHECKDATE; this.txtStatusName.Text = (data.STATUS == Constz.Basket.Status.Approved.Code ? Constz.Basket.Status.Approved.Name : Constz.Basket.Status.Waiting.Name); if (data.STATUS == Constz.Basket.Status.Approved.Code) { this.cmbBasketType.Enabled = false; this.txtBasketQty.Enabled = false; } this.txtLotNo.Text = data.LOTNO; this.txtRemark.Text = data.REMARK; calPrice(); SetGrvItem(data.STATUS); if (data.STATUS == Constz.Basket.Status.Approved.Code) { this.ctlToolbar.BtnSaveShow = false; this.ctlToolbar.BtnSubmitShow = false; } }
public StockoutBasketData GetData(double loid) { StockoutBasketData data = new StockoutBasketData(); if (DALObj.GetDataByLOID(loid, null)) { data.LOID = DALObj.LOID; data.CODE = DALObj.CODE; data.CHECKDATE = DALObj.CHECKDATE; data.PRODUCT = DALObj.PRODUCT; data.QTY = DALObj.QTY; data.STATUS = DALObj.STATUS; data.STOCKINDATE = DALObj.STOCKINDATE; data.REMARK = DALObj.REMARK; data.TYPE = DALObj.TYPE; data.UNIT = DALObj.UNIT; data.LOTNO = DALObj.LOTNO; data.WAREHOUSE = DALObj.WAREHOUSE; } return data; }
public bool ValidateData(StockoutBasketData data) { bool ret = true; if (data.PRODUCT == 0) { ret = false; _error = "¡ÃسÒÃкءÃÐàªéÒ"; } if (data.ITEM.Count == 0) { ret = false; _error = "¡ÃسÒÃкØÃÒ¡ÒÃÊÔ¹¤éÒ"; } if (data.QTY == 0) { ret = false; _error = "¡ÃسÒÃкبӹǹ¡ÃÐàªéÒ"; } string sql = "SELECT PK.SUBPRODUCT, PK.QTY, PD.NAME PDNAME FROM PACKAGE PK INNER JOIN PRODUCT PD ON PD.LOID = PK.SUBPRODUCT WHERE PK.MAINPRODUCT = '" + data.PRODUCT.ToString() + "'"; DataTable tb = OracleDB.ExecListCmd(sql); for (Int16 i = 0; i < tb.Rows.Count; ++i) { double Product = Convert.ToDouble(tb.Rows[i]["SUBPRODUCT"]); double Qty = Convert.ToDouble(tb.Rows[i]["QTY"]) * data.QTY; double AllQty = 0; for (Int16 j = 0; j < data.ITEM.Count; ++j) { BasketItemData itemCompare = (BasketItemData)data.ITEM[j]; if (Product == itemCompare.PRODUCT) { AllQty += itemCompare.QTY; } } if (AllQty != Qty) { _error = "¨Ó¹Ç¹¢Í§ " + tb.Rows[i]["PDNAME"].ToString() + " äÁè¶Ù¡µéͧ"; return false; } } return ret; }
public bool UpdateData(string userID, StockoutBasketData data) { bool ret = true; if (ValidateData(data)) { OracleDBObj obj = new OracleDBObj(); obj.CreateConnection(); obj.CreateTransaction(); try { DALObj.OnDB = false; DALObj.GetDataByLOID(data.LOID, obj.zTrans); DALObj.CODE = data.CODE; DALObj.CHECKDATE = data.CHECKDATE; DALObj.PRODUCT = data.PRODUCT; DALObj.QTY = data.QTY; if (data.STOCKINDATE.Year != 1) { DALObj.STOCKINDATE = data.STOCKINDATE; } DALObj.REMARK = data.REMARK; DALObj.TYPE = data.TYPE; DALObj.UNIT = data.UNIT; DALObj.STATUS = data.STATUS; DALObj.LOTNO = data.LOTNO; DALObj.WAREHOUSE = data.WAREHOUSE; if (DALObj.OnDB) { ret = DALObj.UpdateCurrentData(userID, obj.zTrans); if (!ret) throw new ApplicationException(DALObj.ErrorMessage); } else { DALObj.STATUS = data.STATUS; ret = DALObj.InsertCurrentData(userID, obj.zTrans); if (!ret) throw new ApplicationException(DALObj.ErrorMessage); } _LOID = DALObj.LOID; BasketItemDAL itemDAL = new BasketItemDAL(); itemDAL.DeleteDataByBasket(data.LOID, obj.zTrans); for (Int16 i = 0; i < data.ITEM.Count; ++i) { BasketItemData item = (BasketItemData)data.ITEM[i]; itemDAL.BASKET = DALObj.LOID; itemDAL.PRODUCT = item.PRODUCT; itemDAL.UNIT = item.UNIT; itemDAL.LOTNO = item.LOTNO; itemDAL.PACKAGE = item.PACKAGE; itemDAL.QTY = item.QTY; itemDAL.PRODUCTSTOCK = item.PRODUCTSTOCK; itemDAL.OnDB = false; ret = itemDAL.InsertCurrentData(userID, obj.zTrans); if (!ret) throw new ApplicationException(itemDAL.ErrorMessage); } if (data.STATUS == Constz.Requisition.Status.Approved.Code) { ret = DALObj.CutStockBasket(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; }
protected void SubmitClick(object sender, EventArgs e) { StockoutBasketData data = new StockoutBasketData(); data = GetData(); data.STATUS = Constz.Basket.Status.Approved.Code; data.STOCKINDATE = DateTime.Now.Date; if (FlowObj.UpdateData(Authz.CurrentUserInfo.UserID, data)) { ResetState(FlowObj.LOID); Appz.ClientAlert(this, "Â×¹Âѹ¢éÍÁÙÅàÃÕºÃéÍÂáÅéÇ"); } else Appz.ClientAlert(this, FlowObj.ErrorMessage); }
private StockoutBasketData GetData() { StockoutBasketData data = new StockoutBasketData(); data.LOID = Convert.ToDouble(this.txtLOID.Text == "" ? "0" : this.txtLOID.Text); data.CODE = this.txtBasketCode.Text.Trim(); data.CHECKDATE = this.ctlCheckDate.DateValue; data.PRODUCT = Convert.ToDouble(this.txtPDLOID.Text == "" ? "0" : this.txtPDLOID.Text); data.QTY = Convert.ToDouble(this.txtBasketQty.Text == "" ? "0" : this.txtBasketQty.Text); data.STATUS = this.txtStatus.Text.Trim(); data.REMARK = this.txtRemark.Text.Trim(); data.TYPE = this.cmbBasketType.SelectedItem.Value; data.UNIT = Convert.ToDouble(this.txtUnit.Text == "" ? "0" : this.txtUnit.Text); data.LOTNO = this.txtLotNo.Text.Trim(); data.WAREHOUSE = Convert.ToDouble(this.txtWareHouse.Text == "" ? "0" : this.txtWareHouse.Text); data.ITEM = ItemObj.GetItemList(); return data; }