protected void grvItem_RowUpdating(object sender, GridViewUpdateEventArgs e) { TextBox txtBarCode = (TextBox)this.grvItem.Rows[e.RowIndex].Cells[2].FindControl("txtBarCode"); DropDownList cmbProduct = (DropDownList)this.grvItem.Rows[e.RowIndex].Cells[3].FindControl("cmbProduct"); DropDownList cmbLotNo = (DropDownList)this.grvItem.Rows[e.RowIndex].Cells[4].FindControl("cmbLotNo"); TextBox txtQty = (TextBox)this.grvItem.Rows[e.RowIndex].Cells[5].FindControl("txtQty"); TextBox txtUnit = (TextBox)this.grvItem.Rows[e.RowIndex].Cells[6].FindControl("txtUnit"); BasketItemData data = new BasketItemData(); data.BARCODE = txtBarCode.Text; data.PDNAME = cmbProduct.SelectedItem.Text; data.PRODUCT = Convert.ToDouble(cmbProduct.SelectedItem.Value); data.LOTNO = cmbLotNo.SelectedItem.Text; data.QTY = Convert.ToDouble(txtQty.Text == "" ? "0" : txtQty.Text); data.UNITNAME = txtUnit.Text; data.PRODUCTSTOCK = Convert.ToDouble(cmbLotNo.SelectedItem.Value); e.NewValues["BARCODE"] = data.BARCODE; e.NewValues["PDNAME"] = data.PDNAME; e.NewValues["PRODUCT"] = data.PRODUCT.ToString(); e.NewValues["LOTNO"] = data.LOTNO; e.NewValues["QTY"] = data.QTY.ToString(); e.NewValues["UNITNAME"] = data.UNITNAME; e.NewValues["PRODUCTSTOCK"] = data.PRODUCTSTOCK; }
protected void grvItem_RowCommand(object sender, GridViewCommandEventArgs e) { TextBox txtBarCode = (TextBox)this.grvItem.FooterRow.Cells[2].FindControl("txtNewBarCode"); DropDownList cmbProduct = (DropDownList)this.grvItem.FooterRow.Cells[3].FindControl("cmbNewProduct"); DropDownList cmbLotNo = (DropDownList)this.grvItem.FooterRow.Cells[4].FindControl("cmbNewLotNo"); TextBox txtQty = (TextBox)this.grvItem.FooterRow.Cells[5].FindControl("txtNewQty"); TextBox txtUnit = (TextBox)this.grvItem.FooterRow.Cells[6].FindControl("txtNewUnit"); if (e.CommandName == "Insert") { BasketItemData data = new BasketItemData(); data.BARCODE = txtBarCode.Text; data.PRODUCT = Convert.ToDouble(cmbProduct.SelectedItem.Value); data.LOTNO = cmbLotNo.SelectedItem.Text; data.QTY = Convert.ToDouble(txtQty.Text == "" ? "0" : txtQty.Text); data.UNITNAME = txtUnit.Text; data.UNIT = Convert.ToDouble(this.grvItem.FooterRow.Cells[9].Text); data.PACKAGE = Convert.ToDouble(this.grvItem.FooterRow.Cells[11].Text); data.PRODUCTSTOCK = Convert.ToDouble(cmbLotNo.SelectedItem.Value); if (ItemObj.InsertBasketItem(data)) { SetGrvItem(this.txtStatus.Text); } else Appz.ClientAlert(this, ItemObj.ErrorMessage); } }
public ArrayList GetItemList() { DataTable dt = (DataTable)System.Web.HttpContext.Current.Session[sessionName]; ArrayList arr = new ArrayList(); if (dt != null) { foreach (DataRow dRow in dt.Rows) { BasketItemData data = new BasketItemData(); data.LOID = Convert.ToDouble(dRow["LOID"]); data.PRODUCT = Convert.ToDouble(dRow["PRODUCT"]); data.LOTNO = dRow["LOTNO"].ToString(); data.QTY = Convert.ToDouble(dRow["QTY"]); data.UNIT = Convert.ToDouble(dRow["UNIT"]); data.PACKAGE = Convert.ToDouble(dRow["PACKAGE"]); data.PRODUCTSTOCK = Convert.ToDouble(dRow["PRODUCTSTOCK"]); arr.Add(data); } } return arr; }
//0 LOID, 0 PRODUCT, '' BARCODE, '' PDNAME, '' LOTNO, 0 QTY, 0 UNIT, '' UNITNAME, 0 PACKAGE, 0 PRODUCTSTOCK public bool InsertBasketItem(BasketItemData data) { bool ret = true; ret = VerifyData(data); if (ret) { DataTable dt = (DataTable)System.Web.HttpContext.Current.Session[sessionName]; if (dt != null) { ReOrder(dt); DataRow dRow = dt.NewRow(); dRow["LOID"] = Convert.ToDouble(dt.Rows.Count) + 1; dRow["RANK"] = Convert.ToDouble(dRow["LOID"]); dRow["PRODUCT"] = data.PRODUCT; dRow["BARCODE"] = data.BARCODE; dRow["PDNAME"] = data.PDNAME; dRow["LOTNO"] = data.LOTNO; dRow["QTY"] = data.QTY; dRow["UNIT"] = data.UNIT; dRow["UNITNAME"] = data.UNITNAME; dRow["PACKAGE"] = data.PACKAGE; dRow["PRODUCTSTOCK"] = data.PRODUCTSTOCK; dt.Rows.Add(dRow); System.Web.HttpContext.Current.Session[sessionName] = dt; } } return ret; }
private bool VerifyData(BasketItemData data) { bool ret = true; DataTable dt; if (data.PRODUCT == 0) { ret = false; _error = "¡ÃسÒàÅ×Í¡ÊÔ¹¤éÒ"; } else if (data.QTY == 0) { ret = false; _error = "¡ÃسÒÃкبӹǹ"; } else if (data.LOTNO == "àÅ×Í¡") { ret = false; _error = "¡ÃسÒÃÐºØ Lot No"; } else { dt = (DataTable)System.Web.HttpContext.Current.Session[sessionName]; foreach (DataRow dRow in dt.Rows) { if ((Convert.ToDouble(dRow["PRODUCT"]) == data.PRODUCT) && (dRow["LOTNO"].ToString() == data.LOTNO) && (Convert.ToDouble(dRow["LOID"]) != data.LOID)) { _error = "ÃÒ¡ÒÃÊÔ¹¤éÒ¹ÕéÁÕÍÂÙèã¹ÃÒ¡ÒÃáÅéÇ"; ret = false; break; } } dt = FlowObj.GetSYSQTY(data.PRODUCT.ToString(), data.LOTNO); double sysQty = Convert.ToDouble(dt.Rows[0][0]); if (data.QTY > sysQty) { _error = "¨Ó¹Ç¹ÊÔ¹¤éÒã¹ " + data.LOTNO + " äÁè¾Í"; ret = false; } } return ret; }
public bool UpdateBasketItem(decimal LOID, decimal PRODUCT, string BARCODE, string PDNAME, string LOTNO, decimal QTY, decimal UNIT, string UNITNAME, decimal PACKAGE, decimal PRODUCTSTOCK, decimal RANK) { BasketItemData data = new BasketItemData(); data.LOID = Convert.ToDouble(LOID); data.PRODUCT = Convert.ToDouble(PRODUCT); data.LOTNO = LOTNO; data.QTY = Convert.ToDouble(QTY); bool ret = true; ret = VerifyData(data); if (ret) { DataTable dt = (DataTable)System.Web.HttpContext.Current.Session[sessionName]; if (dt != null) { DataRow[] dRows = dt.Select("LOID = " + data.LOID.ToString()); DataRow dRow = dRows[0]; dRow["PRODUCT"] = PRODUCT; dRow["BARCODE"] = BARCODE; dRow["PDNAME"] = PDNAME; dRow["LOTNO"] = LOTNO; dRow["QTY"] = QTY; dRow["UNIT"] = UNIT; dRow["UNITNAME"] = UNITNAME; dRow["PACKAGE"] = PACKAGE; dRow["PRODUCTSTOCK"] = PRODUCTSTOCK; ReOrder(dt); System.Web.HttpContext.Current.Session[sessionName] = dt; } } else throw new ApplicationException(_error); return ret; }