Exemplo n.º 1
0
    private PurchaseOrderData GetData()
    {
        PurchaseOrderData data = new PurchaseOrderData();
        data.ACTIVE = Constz.ActiveStatus.Active;
        data.CODE = "";
        data.ORDERDATE = DateTime.Now.Date;
        data.STATUS = Constz.Requisition.Status.Waiting.Code;
        data.VAT = Convert.ToDouble(SysConfigFlow.GetValue(Constz.ConfigName.VAT));

        for (int i = 0; i < this.grvProductPurchase.Rows.Count; ++i)
        {
            CheckBox chk = (CheckBox)this.grvProductPurchase.Rows[i].Cells[indexCheckBox].FindControl("chkItem");
            if (chk.Checked && chk.Enabled && this.grvProductPurchase.Rows[i].Cells[indexCheckBox].CssClass != "zHidden")
            {
                POItemData itemData = new POItemData();
                itemData.PRODUCT = Convert.ToDouble(this.grvProductPurchase.Rows[i].Cells[indexPRODUCT].Text);
                itemData.PRITEM = Convert.ToDouble(this.grvProductPurchase.Rows[i].Cells[indexLOID].Text);
                itemData.QTY = Convert.ToDouble(this.grvProductPurchase.Rows[i].Cells[indexQTY].Text);
                itemData.UNIT = Convert.ToDouble(this.grvProductPurchase.Rows[i].Cells[indexUNIT].Text);
                itemData.PRICE = Convert.ToDouble(this.grvProductPurchase.Rows[i].Cells[indexCURPRICE].Text);
                itemData.DUEDATE = Convert.ToDateTime(this.grvProductPurchase.Rows[i].Cells[indexDUEDATE].Text);
                itemData.ACTIVE = Constz.ActiveStatus.Active;

                data.ITEM.Add(itemData);
            }
        }
        return data;
    }
Exemplo n.º 2
0
    public bool UpdatePOItem(decimal LOID, decimal PRODUCT, decimal QTY, decimal RECEIVEQTY, decimal UNIT, decimal PRICE, decimal DISCOUNT, decimal NETPRICE, DateTime DUEDATE, decimal PRITEM, string BARCODE, string ISVAT, string PRODUCTNAME, string UNITNAME, string CODE, decimal RANK)
    {
        POItemData data = new POItemData();
        data.LOID = Convert.ToDouble(LOID);
        data.PRODUCT = Convert.ToDouble(PRODUCT);
        data.QTY = Convert.ToDouble(QTY);
        data.RECEIVEQTY = Convert.ToDouble(RECEIVEQTY);
        data.PRICE = Convert.ToDouble(PRICE);
        data.DISCOUNT = Convert.ToDouble(DISCOUNT);
        data.DUEDATE = DUEDATE;

        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["BARCODE"] = BARCODE;
                dRow["PRODUCTNAME"] = PRODUCTNAME;
                dRow["PRODUCT"] = data.PRODUCT;
                dRow["QTY"] = data.QTY;
                dRow["RECEIVEQTY"] = data.RECEIVEQTY;
                dRow["UNITNAME"] = UNITNAME;
                dRow["UNIT"] = UNIT;
                dRow["PRICE"] = data.PRICE;
                dRow["DISCOUNT"] = data.DISCOUNT;
                dRow["NETPRICE"] = (data.QTY * data.PRICE) - data.DISCOUNT;
                dRow["DUEDATE"] = data.DUEDATE;
                dRow["CODE"] = CODE;
                dRow["PRITEM"] = PRITEM;
       //         dRow["ISVAT"] = ISVAT;

                ReOrder(dt);
                System.Web.HttpContext.Current.Session[sessionName] = dt;
            }
        }
        else throw new ApplicationException(_error);
        return ret;
    }
Exemplo n.º 3
0
 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)
         {
             POItemData data = new POItemData();
             data.LOID = Convert.ToDouble(dRow["LOID"]);
             data.PRODUCT = Convert.ToDouble(dRow["PRODUCT"]);
             data.QTY = Convert.ToDouble(dRow["QTY"]);
             data.RECEIVEQTY = Convert.ToDouble(dRow["RECEIVEQTY"]);
             data.UNIT = Convert.ToDouble(dRow["UNIT"]);
             data.PRICE = Convert.ToDouble(dRow["PRICE"]);
             data.DISCOUNT = Convert.ToDouble(dRow["DISCOUNT"]);
             data.DUEDATE = Convert.ToDateTime(dRow["DUEDATE"]);
             data.PRITEM = Convert.ToDouble(dRow["PRITEM"]);
             data.ACTIVE = Constz.ActiveStatus.Active;
             data.ISVAT = dRow["ISVAT"].ToString();
             arr.Add(data);
         }
     }
     return arr;
 }
Exemplo n.º 4
0
    //0 LOID, 0 PRODUCT, 0 QTY, 0 UNIT, 0 PRICE, 0 DISCOUNT, NULL DUEDATE, 0 PRITEM, '' BARCODE, '' UNITNAME , '' CODE, 0 NETPRICE, '' ISVAT
    public bool InsertPOItem(POItemData 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["BARCODE"] = data.BARCODE;
                dRow["PRODUCTNAME"] = data.PRODUCTNAME;
                dRow["PRODUCT"] = data.PRODUCT;
                dRow["QTY"] = data.QTY;
                dRow["RECEIVEQTY"] = data.QTY;
                dRow["UNITNAME"] = data.UNITNAME;
                dRow["UNIT"] = data.UNIT;
                dRow["PRICE"] = data.PRICE;
                dRow["DISCOUNT"] = data.DISCOUNT;
                dRow["NETPRICE"] = data.NETPRICE;
                dRow["DUEDATE"] = data.DUEDATE;
                dRow["CODE"] = data.PRITEMCODE;
                dRow["PRITEM"] = data.PRITEM;
             //   dRow["ISVAT"] = data.ISVAT;

                dt.Rows.Add(dRow);
                System.Web.HttpContext.Current.Session[sessionName] = dt;
            }
        }
        return ret;
    }
Exemplo n.º 5
0
 private bool VerifyData(POItemData data)
 {
     bool ret = true;
     if (data.PRODUCT == 0)
     {
         ret = false;
         _error = "¡ÃسÒàÅ×Í¡ÊÔ¹¤éÒ";
     }
     else if (data.QTY == 0)
     {
         ret = false;
         _error = "¡ÃسÒÃкبӹǹ";
     }
     else if (data.PRICE == 0)
     {
         ret = false;
         _error = "¡ÃسÒÃкØÃÒ¤Ò/˹èÇÂ";
     }
     else if (data.DUEDATE.Year == 1)
     {
         ret = false;
         _error = "¡ÃسÒÃкءÓ˹´Êè§";
     }
     else
     {
         DataTable dt = (DataTable)System.Web.HttpContext.Current.Session[sessionName];
         foreach (DataRow dRow in dt.Rows)
         {
             if ((Convert.ToDouble(dRow["PRODUCT"]) == data.PRODUCT) && (Convert.ToDouble(dRow["PRITEM"]) == data.PRITEM) && (Convert.ToDouble(dRow["LOID"]) != data.LOID))
             {
                 _error = "ÃÒ¡ÒÃÊÔ¹¤éÒ¹ÕéÁÕÍÂÙèã¹ÃÒ¡ÒÃáÅéÇ";
                 ret = false;
                 break;
             }
         }
     }
     return ret;
 }
Exemplo n.º 6
0
 public bool CopyPDOrder(string userID, double loidSource)
 {
     PurchaseOrderData data = GetData(loidSource);
     DataTable itemList = GetPOItem(data.LOID);
     ArrayList arr = new ArrayList();
     foreach (DataRow dRow in itemList.Rows)
     {
         POItemData idata = new POItemData();
         idata.PRODUCT = Convert.ToDouble(dRow["PRODUCT"]);
         idata.QTY = Convert.ToDouble(dRow["QTY"]);
         idata.UNIT = Convert.ToDouble(dRow["UNIT"]);
         idata.PRICE = Convert.ToDouble(dRow["PRICE"]);
         idata.DISCOUNT = Convert.ToDouble(dRow["DISCOUNT"]);
         idata.PRITEM = Convert.ToDouble(dRow["PRITEM"]);
         idata.ACTIVE = Constz.ActiveStatus.Active;
         idata.DUEDATE = Convert.ToDateTime(dRow["DUEDATE"]);
         arr.Add(idata);
     }
     data.ITEM = arr;
     DALObj.OnDB = false;
     data.LOID = 0;
     data.CODE = "";
     data.STATUS = Constz.Requisition.Status.Waiting.Code;
     data.ACTIVE = Constz.ActiveStatus.Active;
     data.ORDERTYPE = Constz.OrderType.PO.Code;
     return UpdateData(userID, data);
 }
Exemplo n.º 7
0
    protected void grvItem_RowCommand(object sender, GridViewCommandEventArgs e)
    {
        ImageButton img = (ImageButton)e.CommandSource;
        Int16 rowIndex = (Int16)((GridViewRow)img.Parent.Parent).RowIndex;
        GridViewRow commandRow;
        if (rowIndex >= 0)
        {
            commandRow = this.grvItem.Rows[rowIndex];
        }
        else
        {
            commandRow = this.grvItem.FooterRow;
        }
        TextBox txtBarCode = (TextBox)commandRow.Cells[2].FindControl(commandRow.RowType == DataControlRowType.DataRow ? "txtBarCode" : "txtNewBarCode");
        TextBox txtProduct = (TextBox)commandRow.Cells[3].FindControl(commandRow.RowType == DataControlRowType.DataRow ? "txtProduct" : "txtNewProduct");
        TextBox txtQty = (TextBox)commandRow.Cells[4].FindControl(commandRow.RowType == DataControlRowType.DataRow ? "txtQty" : "txtNewQty");
        TextBox txtUnit = (TextBox)commandRow.Cells[5].FindControl(commandRow.RowType == DataControlRowType.DataRow ? "txtUnit" : "txtNewUnit");
        TextBox txtPrice = (TextBox)commandRow.Cells[6].FindControl(commandRow.RowType == DataControlRowType.DataRow ? "txtPrice" : "txtNewPrice");
        TextBox txtDiscount = (TextBox)commandRow.Cells[7].FindControl(commandRow.RowType == DataControlRowType.DataRow ? "txtDiscount" : "txtNewDiscount");
        TextBox txtNetPrice = (TextBox)commandRow.Cells[8].FindControl(commandRow.RowType == DataControlRowType.DataRow ? "txtNetPrice" : "txtNewNetPrice");
        Controls_DatePickerControl ctlDueDate = (Controls_DatePickerControl)commandRow.Cells[9].FindControl(commandRow.RowType == DataControlRowType.DataRow ? "ctlDueDate" : "ctlNewDueDate");
        TextBox txtPRItemCode = (TextBox)commandRow.Cells[10].FindControl(commandRow.RowType == DataControlRowType.DataRow ? "txtPRItemCode" : "txtNewPRItemCode");
        CheckBox chkVat = (CheckBox)commandRow.Cells[11].FindControl("chkVat");

        if (e.CommandName == "Insert")
        {
            POItemData data = new POItemData();

            data.BARCODE = txtBarCode.Text;
            data.PRODUCTNAME = txtProduct.Text;
            try
            {
                data.PRODUCT = Convert.ToDouble(commandRow.Cells[14].Text);
            }
            catch(Exception)
            {
                data.PRODUCT = 0;
            }
            data.QTY = Convert.ToDouble(txtQty.Text == "" ? "0" : txtQty.Text);
            data.UNITNAME = txtUnit.Text;
            try
            {
                data.UNIT = Convert.ToDouble(commandRow.Cells[15].Text);
            }
            catch (Exception)
            {
                data.UNIT = 0;
            }
            data.PRICE = Convert.ToDouble(txtPrice.Text == "" ? "0" : txtPrice.Text);
            data.DISCOUNT = Convert.ToDouble(txtDiscount.Text == "" ? "0" : txtDiscount.Text);
            data.NETPRICE = Convert.ToDouble(txtNetPrice.Text == "" ? "0" : txtNetPrice.Text);
            data.DUEDATE = ctlDueDate.DateValue;
            data.PRITEMCODE = txtPRItemCode.Text;
            data.PDORDER = Convert.ToDouble(Request["loid"] == null ? "0" : Request["loid"]);
            try
            {
                data.PRITEM = Convert.ToDouble(commandRow.Cells[16].Text);
            }
            catch (Exception)
            {
                data.PRITEM = 0;
            }
            if (chkVat.Checked)
            {
                data.ISVAT = "Y";
            }
            else
            {
                data.ISVAT = "N";
            }

            if (ItemObj.InsertPOItem(data))
            {
                SetGrvItem(this.txtStatus.Text);
                Calculation();
            }
            else
                Appz.ClientAlert(this, ItemObj.ErrorMessage);
        }
        else if (e.CommandName == "Search")
        {
            TextBox txtGetData = (TextBox)commandRow.Cells[2].FindControl("txtGetData");
            DataTable dt = FlowObj.GetViewProductPOPopupList(Convert.ToDouble(txtGetData.Text));
            if (dt.Rows.Count > 0)
            {
                //this.txtDebug.Text = txtGetData.Text;
                txtBarCode.Text = dt.Rows[0]["BARCODE"].ToString();
                txtProduct.Text = dt.Rows[0]["PDNAME"].ToString();
                txtQty.Text = dt.Rows[0]["QTY"].ToString();
                txtUnit.Text = dt.Rows[0]["UNAME"].ToString();
                txtPrice.Text = dt.Rows[0]["CURPRICE"].ToString();
                ctlDueDate.DateValue = Convert.ToDateTime(dt.Rows[0]["DUEDATE"]);
                txtPRItemCode.Text = dt.Rows[0]["PRCODE"].ToString();
                commandRow.Cells[13].Text = dt.Rows[0]["ISVAT"].ToString();
                commandRow.Cells[14].Text = dt.Rows[0]["LOID"].ToString();
                commandRow.Cells[15].Text = dt.Rows[0]["UNIT"].ToString();
                commandRow.Cells[16].Text = dt.Rows[0]["PRITEM"].ToString();

                if (dt.Rows[0]["ISVAT"].ToString() == "1")
                {
                    chkVat.Checked = true;
                }
                else
                {
                    chkVat.Checked = false;
                }

                double qty = Convert.ToDouble(txtQty.Text == "" ? "0" : txtQty.Text);
                double price = Convert.ToDouble(txtPrice.Text == "" ? "0" : txtPrice.Text);
                double discount = Convert.ToDouble(txtDiscount.Text == "" ? "0" : txtDiscount.Text);
                double ans = (qty * price) - discount;

                txtNetPrice.Text = ans.ToString();
            }
        }
    }
Exemplo n.º 8
0
    private bool VerifyData(POItemData data)
    {
        bool ret = true;
        if (data.PRODUCT == 0)
        {
            ret = false;
            _error = "¡ÃسÒàÅ×Í¡ÊÔ¹¤éÒ";
        }
        else if (data.QTY == 0)
        {
            ret = false;
            _error = "¡ÃسÒÃкبӹǹ";
        }
        else if (data.PRICE == 0)
        {
            ret = false;
            _error = "¡ÃسÒÃкØÃÒ¤Ò/˹èÇÂ";
        }
        else if (data.DUEDATE.Year == 1)
        {
            ret = false;
            _error = "¡ÃسÒÃкءÓ˹´Êè§";
        }
        else
        {
            DataTable dt = (DataTable)System.Web.HttpContext.Current.Session[sessionName];
            foreach (DataRow dRow in dt.Rows)
            {
                if ((Convert.ToDouble(dRow["PRODUCT"]) == data.PRODUCT) && (Convert.ToDouble(dRow["PRITEM"]) == data.PRITEM) && (Convert.ToDouble(dRow["LOID"]) != data.LOID))
                {
                    _error = "ÃÒ¡ÒÃÊÔ¹¤éÒ¹ÕéÁÕÍÂÙèã¹ÃÒ¡ÒÃáÅéÇ";
                    ret = false;
                    break;
                }
            }

            dt = FlowObj.GetPRQTY(data.PRITEM, data.PDORDER);
            if (dt.Rows.Count > 0)
            {
                double Qty = Convert.ToDouble(dt.Rows[0][0]);
                if (data.QTY > Qty)
                {
                    _error = "¨Ó¹Ç¹ÊÔ¹¤éÒà¡Ô¹¨Ò¡ãº¢Í«×éÍ";
                    ret = false;
                }
            }
            else
            {
                dt = FlowObj.GetPOQty(data.PRITEM);
                if (dt.Rows.Count > 0)
                {
                    double Qty = Convert.ToDouble(dt.Rows[0][0]);
                    if (data.QTY > Qty)
                    {
                        _error = "¨Ó¹Ç¹ÊÔ¹¤éÒà¡Ô¹¨Ò¡ãº¢Í«×éÍ";
                        ret = false;
                    }
                }
            }
        }
        return ret;
    }