Exemplo n.º 1
0
    protected void txtChanCode_TextChanged(object sender, EventArgs e)
    {
        try
        {
            #region 取得查詢資料
            TextBox txtChanCode = (TextBox)sender;
            ALOModel.MaintainDisRecord BCO = new ALOModel.MaintainDisRecord(ConnectionDB);
            ArrayList ParameterList = new ArrayList();//20091113
            ParameterList.Clear();
            ParameterList.Add(s_DIS_NO);
            ParameterList.Add(s_ITEM);
            ParameterList.Add(s_PERIOD);
            ParameterList.Add(txtChanCode.Text);
            ParameterList.Add(null); //AREA_CODE 預設查全部
            ParameterList.Add(Session["UID"].ToString());
            ParameterList.Add(s_SESSION_ID);
            #endregion

            #region DataBind
            DataTable dt_Return2 = BCO.QueryDisAreaTmp(ParameterList);
            if (dt_Return2 == null || (dt_Return2 != null && dt_Return2.Rows.Count <= 0))
            {
                dt_Area = dt_Return2;
                gv_Area.DataSource = dt_Area;
                //設定分頁大小
                iCurrentGvPageIndex_Area = 0;
                gv_Area.PageSize = 10;
                gv_Area.PageIndex = iCurrentGvPageIndex_Area;
                gv_Area.DataBind();

                this.RightMsgLabel.Text = "查無資料";

            }
            else if (dt_Return2 != null)
            {
                dt_Area = dt_Return2;

                DataView dv = dt_Area.DefaultView;

                if (ViewState["SortingCondition_Area"] != null)
                {
                    dv.Sort = ViewState["SortingCondition_Area"].ToString();
                }
                gv_Area.DataSource = dv;
                //設定分頁大小
                iCurrentGvPageIndex_Area = 0;
                gv_Area.PageSize = 10;
                gv_Area.PageIndex = iCurrentGvPageIndex_Area;
                gv_Area.DataBind();

            }
            dt_Return2.Dispose();
            #endregion

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

    }