Exemple #1
0
    protected void btnCancel_Click(object sender, EventArgs e)
    {
        ErrorMsgLabel.Text = "";
        ErrorMsgLabel2.Text = "";
        GridView1.DataSource = null;
        GridView1.DataBind();

        BCO.VAM22_BCO bco = new BCO.VAM22_BCO(ConnectionDB);
        ParameterList.Clear();
        ParameterList.Add(DBPara(slpKEYIN_DATE.Text, ParaType.Date));
        ParameterList.Add(DBPara(slpTAX_TYPE.Text, ParaType.Number));
        ParameterList.Add(Session["UID"].ToString());
        ParameterList.Add(DateTime.Now);
        int i = bco.DeleteAutoDisc(ParameterList);
        if (i == 0)
            ErrorMsgLabel.Text = "查無自動折讓的資料";
        else
            ErrorMsgLabel.Text = "解除成功,共處理 " + i.ToString() + " 筆折讓單";


    }
Exemple #2
0
    }//GridView1_Sorting   
    #endregion

    #region Buttons

    protected void btnExec_Click(object sender, EventArgs e)
    {
        ErrorMsgLabel.Text = "";
        ErrorMsgLabel2.Text = "";
        //ParameterList=>
        //0.D_SOURCE_DATE_S     Date,
        //1.D_SOURCE_DATE_E     Date,
        //2.N_TAX_TYPE number
        //3.DISC_DATE           Date
        //4.D_KEYIN_DATE        Date            
        //5.UID            
        BCO.VAM22_BCO bco = new BCO.VAM22_BCO(ConnectionDB);
        ParameterList.Clear();
        ParameterList.Add(DBPara(slpDateRange.StartDate, ParaType.Date));
        ParameterList.Add(DBPara(slpDateRange.EndDate, ParaType.Date));
        ParameterList.Add(DBPara(slpTAX_TYPE.Text, ParaType.Number));
        ParameterList.Add(DBPara(slpDISC_DATE.Text, ParaType.Date));
        ParameterList.Add(DBPara(slpKEYIN_DATE.Text, ParaType.Date));
        ParameterList.Add(Session["UID"].ToString());

        int iDiscRows = 0;
        DataTable dt = bco.AutoDiscFlg(ParameterList, out iDiscRows);
        if (iDiscRows == 0)
            ErrorMsgLabel.Text = "目前無符合自動折讓的資料";
        else
            ErrorMsgLabel.Text = "廠商自動折讓產生完成,共處理 " + iDiscRows.ToString() + " 筆折讓單";


        if (dt.Rows.Count > 0)
            ErrorMsgLabel2.Text = "為避免超折廠商,以下發票餘額不足皆未自動產生折讓單";
        Session["VAM221_" + PageTimeStamp.Value] = dt;

        ViewState["SortField"] = null;
        ViewState["SortDirect"] = "";
        this.GridView1.PageIndex = 0;
        GV_Bind();
    }