Exemplo n.º 1
0
    protected void Btn_Query_Click(object sender, EventArgs e)
    {
        try
        {
            ErrorMsgLabel.Text = "";
            ResultMsgLabel.Text = "";
            gvMsgLabel.Text = "";

            #region 勾選[門市主檔檢核]
            if (CheckBox1.Checked)
            {

                DataTable Dt = new DataTable();

                Dt = this.searchData();

                if (Dt == null || (Dt != null && Dt.Rows.Count <= 0))
                {
                    ResultMsgLabel.Text = "門市主檔檢核成功";
                }
                else
                {

                    dt_Detail = Dt;

                    #region 設定查詢結果
                    gvMsgLabel.Text = "門市主檔檢核未成功";
                    this.gv_Detail.DataSource = Dt;
         //           this.gv_Detail.PageSize = (TextBoxPagesize.Text == "") ? 10 : (int.Parse(TextBoxPagesize.Text) < 0) ? 10 : int.Parse(TextBoxPagesize.Text);
                    this.gv_Detail.PageIndex = 0;
                    this.gv_Detail.DataBind();

                    #endregion

                }


            }
            #endregion

            #region 勾選[產生唯一檔]

            else if (CheckBox2.Checked)
            {

                DataTable Dt = new DataTable();

                Dt = this.searchData();

                if (Dt == null || (Dt != null && Dt.Rows.Count <= 0))
                {
                    //ResultMsgLabel.Text = "查無資料";
                    BCO.CreateStoreUniqueFile bco = new CreateStoreUniqueFile(ConntionDB);
                    int[] vCount = bco.CreateMutiStoreData(null);
                    ScriptManager.RegisterStartupScript(this.up_ErrorMsg, typeof(UpdatePanel), "STM031", "alert('成功轉入門市唯一檔共" + Convert.ToString(vCount[0]) + "筆,目前可配送店數" + Convert.ToString(vCount[1]) + "筆');", true);
           
                }
                else
                {

                    dt_Detail = Dt;

                    #region 設定查詢結果
                    gvMsgLabel.Text = "門市主檔審核未成功";
                    this.gv_Detail.DataSource = Dt;
        //            this.gv_Detail.PageSize = (TextBoxPagesize.Text == "") ? 10 : (int.Parse(TextBoxPagesize.Text) < 0) ? 10 : int.Parse(TextBoxPagesize.Text);
                    this.gv_Detail.PageIndex = 0;
                    this.gv_Detail.DataBind();

                    #endregion

                }

            }
            #endregion

        }
        catch (Exception ex)
        { this.ErrorMsgLabel.Text = ex.ToString(); }
        finally { }


    }