示例#1
0
    //查詢
    protected void btnQuery_Click(object sender, EventArgs e)
    {
        DateTime Dt;
        try
        {
            GridView2.Visible = false;
            UpdatePanel1.Update();
            bool isDate = DateTime.TryParse(SLP_SLPDate.Text, out Dt);
            DataTable dt = new DataTable();
            if (isDate || SLP_SLPDate.Text == "")
            {
                if(radNonPeriod.Checked)
                    if (SLP_SLPDate.Text == "")
                    {
                        lblMsg.Text = "請輸入日期欄位";
                        TextBox tb = (TextBox)SLP_SLPDate.FindControl("TextBoxCode");
                        ScriptManager.RegisterStartupScript(this, this.GetType(), "ALO122_Focus", "document.all['" + tb.ClientID + "'].focus(); document.all['" + tb.ClientID + "'].select();", true);
                        return;
                    }
                string SessionIDName = "ALO124_dt5" + PageTimeStamp.Value;
                ArrayList ParameterList = new ArrayList();//20091113

                ParameterList.Clear();
                ParameterList.Add(Request.QueryString["pPG_ID"]);
                ParameterList.Add(PageTimeStamp.Value + Session["UID"].ToString());
                ParameterList.Add(Request.QueryString["pDisNo"]);
                ParameterList.Add(Request.QueryString["pItem"]);
                ParameterList.Add(Request.QueryString["pPeriod"]);
                ParameterList.Add(SLP_SLPDate.Text);
                ParameterList.Add(Session["UID"].ToString());
                BCO.MaintainDisRecord bco = new BCO.MaintainDisRecord(ConnectionDB);
                dt = bco.QueryNewDisStore(ParameterList);
                if (dt.Rows.Count > 0) btnConfirm.Enabled = true; else btnConfirm.Enabled = false;
                Session[SessionIDName] = dt;
                GridView2.DataSource = dt;
                GridView2.DataBind();
                GridView2.Visible = true;
                UpdatePanel1.Update();
            }
        }
        catch (Exception ex) { lblMsg.Text = ex.Message; }
    }