예제 #1
0
    /// <summary>
    /// 計算鈕
    /// </summary>
    protected void btnCalculate_Click(object sender, EventArgs e)
    {
        ErrorMsgLabel.Text = "";

        //檢核門市進貨日是否己出庫
        if (SLP_StAcceptDate.Text.Trim() != "")
        {
            if (VerifyALOOutNo() == false)
                return;
        }


        if (SLP_SKU1.Text.Trim() == "" && txtSLP_Gift.Text.Trim() == "")
        {
           
            //ErrorMsgLabel.Text = "品號或虛擬品號須擇一輸入";

            ErrorMsgLabel.Text = "品號或虛擬品號須擇一輸入";
            //ScriptManager.RegisterStartupScript(Page, this.GetType(), "CGD071.aspx", "alert(' 品號或虛擬品號須擇一輸入 ');", true);

            return;
        }

        //檢核品項是否存在門市進貨主檔
        if ((SLP_SKU1.Text.Trim() != "" || txtSLP_Gift.Text.Trim() != "") && SLP_Period.Text.Trim() != "")
        {
            if (CheckAloItemS() == false)
                return;
        }
      
        if (VerifyFormData() == true)
        {
            try
            {
                ErrorMsgLabel.Text = "";

                string SessionIDName = "CGD071_" + PageTimeStamp.Value;

                CGDModel.ProcessDeliverBatchAdj BCO = new CGDModel.ProcessDeliverBatchAdj(ConntionDB);

                DataTable Dt;
                ParameterList.Clear();

                ParameterList.Add(SLP_StAcceptDate.Text.Trim());
                ParameterList.Add(SLP_StoreChain1.Text.Trim());
                ParameterList.Add(ddlTypeNo.SelectedValue.Trim());
                ParameterList.Add(SLP_Route1.Text.Trim());
                ParameterList.Add(txtStep_Start.Text.Trim());
                ParameterList.Add(txtStep_End.Text.Trim());
                ParameterList.Add(SLP_SKU1.Text.Trim());
                ParameterList.Add(SLP_Period.Text.Trim());
                ParameterList.Add(txtSLP_Gift.Text.Trim());

                Dt = BCO.QuerySwitch(CGDModel.CGDCommon.QueryType.GetAloItemSumQty, ParameterList);

                if (Dt.Rows.Count == 0)
                {
                    ErrorMsgLabel.Text = "查無資料";
                    //ScriptManager.RegisterStartupScript(Page, this.GetType(), "CGD071.aspx", "alert(' 查無資料 ');", true);

                    return;
                }
                else
                {
                    txtCount.Value = Dt.Rows[0][0].ToString();
                }
            }
            catch (Exception ex)
            {
                ErrorMsgLabel.Text = ex.Message;
            }
        }
        

       
    }
예제 #2
0
    /// <summary>
    /// 檢核品項是否存在門市進貨主檔
    /// </summary>
    private bool CheckAloItemS()
    {
        try
        {
            ErrorMsgLabel.Text = "";

            string CheckErr;

            string SessionIDName = "CGD071_" + PageTimeStamp.Value;

            CGDModel.ProcessDeliverBatchAdj BCO = new CGDModel.ProcessDeliverBatchAdj(ConntionDB);

            DataTable Dt;
            ParameterList.Clear();

            ParameterList.Add(SLP_StAcceptDate.Text.Trim());
            ParameterList.Add(SLP_StoreChain1.Text.Trim());
            ParameterList.Add(ddlTypeNo.SelectedValue.Trim());
            ParameterList.Add(SLP_Route1.Text.Trim());
            ParameterList.Add(txtStep_Start.Text.Trim());
            ParameterList.Add(txtStep_End.Text.Trim());
            ParameterList.Add(SLP_SKU1.Text.Trim());
            ParameterList.Add(SLP_Period.Text.Trim());
            ParameterList.Add(txtSLP_Gift.Text.Trim());

            //Dt = BCO.QuerySwitch(CGDModel.CGDCommon.QueryType.CheckAloItem, ParameterList);
            CheckErr = BCO.CheckAloItem(ParameterList);

            if (CheckErr == String.Empty || CheckErr == null)
            //if (Dt.Rows.Count == 0)
            {
                ErrorMsgLabel.Text = "門市進貨日的通路或路線無此品號或虛擬品號的期別";
                //ScriptManager.RegisterStartupScript(Page, this.GetType(), "CGD071.aspx", "alert(' 門市進貨日的通路或路線無此品號或虛擬品號的期別 ');", true);

                return false;
            }
        }
        catch (Exception ex)
        {
            ErrorMsgLabel.Text = ex.Message;
            return false;
        }

        return true;

    }
예제 #3
0
    /// <summary>
    /// 執行鈕
    /// </summary>
    protected void btnQuery_Click(object sender, EventArgs e)
    {

        //檢核門市進貨日是否己出庫
        if (SLP_StAcceptDate.Text.Trim() != "")
        {
            if (VerifyALOOutNo() == false)
                return;
        }


        if (txtStore_Qty.Text.Trim() == "" || Convert.ToInt32(txtStore_Qty.Text.Trim()) < 0)
        {
            ErrorMsgLabel.Text = "單店數量不可為空值或小於0";
            //ScriptManager.RegisterStartupScript(Page, this.GetType(), "CGD071.aspx", "alert('單店數量不可為空值或小於0 ');", true);

            return;
        }

        //檢核品項是否存在門市進貨主檔
        if ((SLP_SKU1.Text.Trim() != "" || txtSLP_Gift.Text.Trim() != "") && SLP_Period.Text.Trim() != "")
        {
            if (CheckAloItemS() == false)
                return;
        }

        if (VerifyFormData() == true ) 
        {
            try
            {
                ErrorMsgLabel.Text = "";

                string SessionIDName = "CGD071_" + PageTimeStamp.Value;
                int Store_Qty = 0;
                int rtn = 0;

                CGDModel.ProcessDeliverBatchAdj BCO = new CGDModel.ProcessDeliverBatchAdj(ConntionDB);

                ParameterList.Clear();

                ParameterList.Add(SLP_StAcceptDate.Text.Trim());
                ParameterList.Add(SLP_StoreChain1.Text.Trim());
                ParameterList.Add(ddlTypeNo.SelectedValue.Trim());
                ParameterList.Add(SLP_Route1.Text.Trim());
                ParameterList.Add(txtStep_Start.Text.Trim());
                ParameterList.Add(txtStep_End.Text.Trim());
                ParameterList.Add(SLP_SKU1.Text.Trim());
                ParameterList.Add(SLP_Period.Text.Trim());
                ParameterList.Add(txtSLP_Gift.Text.Trim());
                if (txtStore_Qty.Text.Trim() != "")
                {
                    Store_Qty = Convert.ToInt32(txtStore_Qty.Text.Trim());
                    ParameterList.Add(Store_Qty);
                }
                //else
                //{
                //    ParameterList.Add(Store_Qty);
                //}

                ParameterList.Add(Session["UID"].ToString().Trim());

                rtn = BCO.UpdateAloItemQty(ParameterList);

                ErrorMsgLabel.Text = "執行成功";
                //ScriptManager.RegisterStartupScript(Page, this.GetType(), "CGD071.aspx", "alert(' 執行成功 ');", true);

            }
            catch (Exception ex)
            {
                ErrorMsgLabel.Text = ex.Message;
            }
        }
    }