Exemple #1
0
        public CtrlDeliveryItemData GetRequisition(double requisition, string invcode)
        {
            string where = "";
            if (requisition != 0)
                where += (where == "" ? "" : "AND ") + "LOID = " + requisition.ToString() + " ";

            if (invcode.Trim() != "")
                where += (where == "" ? "" : "AND ") + "UPPER(INVCODE) = '" + invcode.Trim().ToUpper() + "' ";

            string sql = "SELECT LOID, INVCODE, REFTYPELOID, TYPENAME, CUSTOMERNAME, CADDRESS, CTEL, CONTACTNAME ";
            sql += "FROM V_INVOICE_FOR_DELIVERLY ";
            sql += (where == "" ? "" : "WHERE ") + where + " ";

            DataTable dt = OracleDB.ExecListCmd(sql);
            CtrlDeliveryItemData data = new CtrlDeliveryItemData();
            if (dt.Rows.Count == 1)
            {
                DataRow dRow = dt.Rows[0];
                if (!Convert.IsDBNull(dRow["CADDRESS"])) data.CADDRESS = dRow["CADDRESS"].ToString();
                if (!Convert.IsDBNull(dRow["CUSTOMERNAME"])) data.CNAME = dRow["CUSTOMERNAME"].ToString();
                if (!Convert.IsDBNull(dRow["CONTACTNAME"])) data.CONTACTNAME = dRow["CONTACTNAME"].ToString();
                if (!Convert.IsDBNull(dRow["CTEL"])) data.CTEL = dRow["CTEL"].ToString();
                if (!Convert.IsDBNull(dRow["INVCODE"])) data.INVCODE = dRow["INVCODE"].ToString();
                if (!Convert.IsDBNull(dRow["LOID"])) data.REQUISITION = Convert.ToDouble(dRow["LOID"]);
            }

            return data;
        }
    protected void grvItem_RowUpdating(object sender, GridViewUpdateEventArgs e)
    {
        TextBox txtBoxQty = (TextBox)this.grvItem.Rows[e.RowIndex].Cells[4].FindControl("txtBoxQty");
        TextBox txtInvcode = (TextBox)this.grvItem.Rows[e.RowIndex].Cells[2].FindControl("txtInvcode");
        CtrlDeliveryItemData data = new CtrlDeliveryItemData();

        data.BOXQTY = Convert.ToDouble(txtBoxQty.Text == "" ? "0" : txtBoxQty.Text);
        data.INVCODE = txtInvcode.Text;


        e.NewValues["LOID"] = this.grvItem.Rows[e.RowIndex].Cells[5].Text;
        e.NewValues["BOXQTY"] = data.BOXQTY.ToString();
        e.NewValues["INVCODE"] = data.INVCODE;


    }
    protected void grvItem_RowCommand(object sender, GridViewCommandEventArgs e)
    {
        if (e.CommandName == "Insert")
        {
            TextBox txtBoxQty = (TextBox)this.grvItem.FooterRow.Cells[4].FindControl("txtNewBoxQty");
            TextBox txtRequisition = (TextBox)this.grvItem.FooterRow.Cells[2].FindControl("txtNewRequisition");
            TextBox txtInvcode = (TextBox)this.grvItem.FooterRow.Cells[2].FindControl("txtNewInvcode");

            CtrlDeliveryItemData data = new CtrlDeliveryItemData();

            data.REQUISITION = Convert.ToDouble(txtRequisition.Text == "" ? "0" : txtRequisition.Text);
            data.BOXQTY = Convert.ToDouble(txtBoxQty.Text == "" ? "0" : txtBoxQty.Text);
            data.INVCODE = txtInvcode.Text;


            if (ItemObj.InsertRequisitionItem(data))
            {
                SetGrvItem();
            }
            else
                Appz.ClientAlert(this, ItemObj.ErrorMessage);
        }
        else if (e.CommandName == "EditSearch")
        {
            int rowIndex = ((GridViewRow)((ImageButton)e.CommandSource).Parent.Parent).RowIndex;

            TextBox txtInvCode = (TextBox)this.grvItem.Rows[rowIndex].Cells[4].FindControl("txtInvcode");
            TextBox txtBoxQty = (TextBox)this.grvItem.Rows[rowIndex].Cells[4].FindControl("txtBoxQty");
            Label txtContactName = (Label)this.grvItem.Rows[rowIndex].Cells[3].FindControl("txtContactName");
            Label txtCname = (Label)this.grvItem.Rows[rowIndex].Cells[3].FindControl("txtCname");
            Label txtAddress = (Label)this.grvItem.Rows[rowIndex].Cells[3].FindControl("txtAddress");
            Label txtTel = (Label)this.grvItem.Rows[rowIndex].Cells[3].FindControl("txtTel");
            TextBox txtRequisition = (TextBox)this.grvItem.Rows[rowIndex].Cells[2].FindControl("txtRequisition");

            CtrlDeliveryItemData data = FlowObj.GetRequisition(Convert.ToDouble(txtRequisition.Text == "" ? "0" : txtRequisition.Text), txtInvCode.Text.Trim());
            txtInvCode.Text = data.INVCODE;
            txtContactName.Text = data.CONTACTNAME;
            txtCname.Text = data.CNAME;
            txtAddress.Text = data.CADDRESS;
            txtTel.Text = data.CTEL;
            txtRequisition.Text = data.REQUISITION.ToString();
        }
        else if (e.CommandName == "Search")
        {
            int rowIndex = ((GridViewRow)((ImageButton)e.CommandSource).Parent.Parent).RowIndex;

            TextBox txtInvCode = (TextBox)this.grvItem.FooterRow.Cells[4].FindControl("txtNewInvcode");
            TextBox txtBoxQty = (TextBox)this.grvItem.FooterRow.Cells[4].FindControl("txtNewBoxQty");
            Label txtContactName = (Label)this.grvItem.FooterRow.Cells[3].FindControl("txtNewContactName");
            Label txtCname = (Label)this.grvItem.FooterRow.Cells[3].FindControl("txtNewCname");
            Label txtAddress = (Label)this.grvItem.FooterRow.Cells[3].FindControl("txtNewAddress");
            Label txtTel = (Label)this.grvItem.FooterRow.Cells[3].FindControl("txtNewTel");
            TextBox txtRequisition = (TextBox)this.grvItem.FooterRow.Cells[2].FindControl("txtNewRequisition");

            CtrlDeliveryItemData data = FlowObj.GetRequisition(Convert.ToDouble(txtRequisition.Text == "" ? "0" : txtRequisition.Text), txtInvCode.Text.Trim());
            txtInvCode.Text = data.INVCODE;
            txtContactName.Text = data.CONTACTNAME;
            txtCname.Text = data.CNAME;
            txtAddress.Text = data.CADDRESS;
            txtTel.Text = data.CTEL;
            txtRequisition.Text = data.REQUISITION.ToString();
        }
    }
Exemple #4
0
    public bool UpdateDeliveryItem(decimal LOID,decimal RANK, decimal REQUISITION, decimal BOXQTY, string INVCODE, string CONTACTNAME, string CNAME, string CADDRESS, string CTEL)
    {
        CtrlDeliveryItemData data = new CtrlDeliveryItemData();
        data.LOID = Convert.ToDouble(LOID);
        data.REQUISITION = Convert.ToDouble(REQUISITION);
        data.BOXQTY = Convert.ToDouble(BOXQTY);
        data.INVCODE = INVCODE.ToString();
        data.CONTACTNAME = CONTACTNAME.ToString();
        data.CNAME = CNAME.ToString();
        data.CADDRESS = CADDRESS.ToString();
        data.CTEL = (CTEL == null ? "" : CTEL.ToString());

        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["INVCODE"] = data.INVCODE;
                dRow["BOXQTY"] = data.BOXQTY;
                CtrlDeliveryItemData requisition = FlowObj.GetRequisition(data.REQUISITION, data.INVCODE);
                dRow["CONTACTNAME"] = data.CONTACTNAME;
                dRow["CNAME"] = data.CNAME;
                dRow["CADDRESS"] = data.CADDRESS;
                dRow["CTEL"] = data.CTEL;
                dRow["REQUISITION"] = requisition.REQUISITION;
                ReOrder(dt);
                System.Web.HttpContext.Current.Session[sessionName] = dt;
            }
        }
        else throw new ApplicationException(_error);
        return ret;
    }
Exemple #5
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)
            {
                CtrlDeliveryItemData data = new CtrlDeliveryItemData();
 
                data.BOXQTY = Convert.ToDouble(dRow["BOXQTY"]);
                data.LOID = Convert.ToDouble(dRow["LOID"]);
                data.CADDRESS = dRow["CADDRESS"].ToString();
                data.CNAME = dRow["CNAME"].ToString();
                data.CONTACTNAME = dRow["CONTACTNAME"].ToString();
                data.CTEL = dRow["CTEL"].ToString();
                data.REQUISITION = Convert.ToDouble(dRow["REQUISITION"]);

                arr.Add(data);
            }
        }
        return arr;
    }
Exemple #6
0
    //0 LOID, 0 PRODUCT, 0 QTY, 0 UNIT, 0 PRICE, 0 DISCOUNT, 0 NETPRICE, '" + Constz.ActiveStatus.Active + "' ACTIVE, '' BARCODE, '' UNITNAME, '' ISVAT ";
    public bool InsertRequisitionItem(CtrlDeliveryItemData 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["INVCODE"] = data.INVCODE;
                dRow["BOXQTY"] = Convert.ToDouble(data.BOXQTY);
                CtrlDeliveryItemData requisition = FlowObj.GetRequisition(data.REQUISITION, data.INVCODE);
                dRow["REQUISITION"] = requisition.REQUISITION;
                dRow["CONTACTNAME"] = requisition.CONTACTNAME;
                dRow["CNAME"] = requisition.CNAME;
                dRow["CADDRESS"] = requisition.CADDRESS;
                dRow["CTEL"] = requisition.CTEL;

                dt.Rows.Add(dRow);
                System.Web.HttpContext.Current.Session[sessionName] = dt;
            }
        }
        return ret;
    }
Exemple #7
0
 private bool VerifyData(CtrlDeliveryItemData data)
 {
     bool ret = true;
     if (data.REQUISITION == 0)
     {
         ret = false;
         _error = "¡ÃسÒÃкØàÅ¢·Õè Invoice ";
     }
     else if (data.INVCODE == "")
     {
         ret = false;
         _error = "¡ÃسҵÃǨÊͺàÅ¢·Õè Invoice ";
     }
     else if (data.BOXQTY == 0)
     {
         ret = false;
         _error = "¡ÃسÒÃкبӹǹ¡Åèͧ";
     }
     else
     {
         DataTable dt = (DataTable)System.Web.HttpContext.Current.Session[sessionName];
         if (dt != null)
         {
             foreach (DataRow dRow in dt.Rows)
             {
                 if (Convert.ToDouble(dRow["REQUISITION"]) == data.REQUISITION && Convert.ToDouble(dRow["LOID"]) != data.LOID)
                 {
                     _error = "àÅ¢·Õè Invoice ¹ÕéÁÕÍÂÙèã¹ÃÒ¡ÒÃáÅéÇ";
                     ret = false;
                     goto ex;
                 }
             }
         }
     ex: ;
     }
     return ret;
 }