当前文件路径：XingHuanWebSms/Sms_List.aspx.cs

		            
 1using System;
 2using System.Data;
 3using System.Configuration;
 4using System.Collections;
 5using System.Web;
 6using System.Web.Security;
 7using System.Web.UI;
 8using System.Web.UI.WebControls;
 9using System.Web.UI.WebControls.WebParts;
10using System.Web.UI.HtmlControls;
11using SMS_Lib;
12using DBLibrary;
13public partial class SMS_Sms_List : SMS_PageBase
14...{
15    private DBLibrary.DBClass db = new DBClass();
16    private int flg = 1;//1,发送,2接收
17    protected void Page_Load(object sender, EventArgs e)
18    ...{
19        //this.GridView1.AutoGenerateColumns = false;
20    
21        if (!Page.IsPostBack)
22        ...{
23            if (Request["Flag"] != null)
24            ...{
25                this.title.InnerText = "已接收的短信";
26                //this.GridView1.Columns[5].Visible = false;
27                this.GridView1.Columns.RemoveAt(2);
28                this.GridView1.Columns.RemoveAt(3);
29                flg = 2;
30                ViewState["fg"] = "2";
31                this.send.Visible = false;
32            }
33            else
34            ...{
35                ViewState["fg"] = "1";
36                this.title.InnerText = "已发送的短信";
37                this.GridView1.Columns.RemoveAt(1);
38            }
39            Sms_DataBind(flg);
40        }
41
42    }
43    private void Sms_DataBind(int flag)
44    ...{
45        string id = this.sms_id.ToString();
46
47        System.Data.SqlClient.SqlParameter[] para =
48            ...{
49                db.MakeInputParameter("@sid",SqlDbType.NVarChar,50,id),
50                db.MakeInputParameter("@flag",SqlDbType.Int,4,ViewState["fg"]==null?"1":ViewState["fg"].ToString())
51            };
52        try
53        ...{
54            DataTable dt = db.RunProcedureForDataSet("SMS_Web_SMSList", para).Tables[0];
55            this.GridView1.DataSource = dt.DefaultView;
56            this.GridView1.DataBind();
57        }
58        catch
59        ...{
60        }
61
62    }
63
64    protected void GridView1_PageIndexChanging(object sender, GridViewPageEventArgs e)
65    ...{
66        this.GridView1.PageIndex = e.NewPageIndex;
67        Sms_DataBind(flg);
68    }
69}
70