开通博客赚积分
发布资源赚积分
分类

源码开发语言/平台
当前位置：首页 > 源码/资料 > Internet/网络编程 > SilverLight > 查看源码
WebUserControl.ascx.cs
资源名称：SunShine.rar　[点击查看]
上传用户：tjxpgg
上传日期：2017-05-14
资源大小：2244k
文件大小：4k
源码类别：

SilverLight

开发平台：

ASP/ASPX

WebUserControl.ascx.cs：源码内容
  1. using System;
  2. using System.Data;
  3. using System.Configuration;
  4. using System.Collections;
  5. using System.Web;
  6. using System.Web.Security;
  7. using System.Web.UI;
  8. using System.Web.UI.WebControls;
  9. using System.Web.UI.WebControls.WebParts;
  10. using System.Web.UI.HtmlControls;
  11. using Microsoft.Practices.EnterpriseLibrary.Common;
  12. using Microsoft.Practices.EnterpriseLibrary.Data;
  13. public partial class WebUserControl : System.Web.UI.UserControl
  14. {
  15.     Database DB = DatabaseFactory.CreateDatabase();
  16.     protected void Page_Load(object sender, EventArgs e)
  17.     {
  18.         this.btnFirst.Command += new CommandEventHandler(ClikMe);
  19.         this.btnPre.Command += new CommandEventHandler(ClikMe);
  20.         this.btnNext.Command += new CommandEventHandler(ClikMe);
  21.         this.btnLast.Command += new CommandEventHandler(ClikMe);
  22.         if (!IsPostBack)
  23.         {
  24.             ViewState["count"] = 1;
  25.             GetCount();
  26.             GetAllPage();
  27.             GetALLInfo();
  28.         }
  29.         
  30.     }
  31.     public void GetCount()
  32.     {
  33.         int AllInfo =Convert.ToInt32( DB.ExecuteScalar("GetRecordFromPage", this.TableName, "*",this.Column, this.PageSize, 1, 1, "asc", ""));
  34.         this.lblTolCount.Text = AllInfo.ToString();
  35.     }
  36.     public void GetAllPage()
  37.     {
  38.         int AllInfo = Convert.ToInt32(DB.ExecuteScalar("GetRecordFromPage", this.TableName, "*", this.Column, this.PageSize, 1, 1, "asc", ""));
  39.         int Page = 0;
  40.         if (AllInfo % 10 == 0)
  41.         {
  42.             Page = AllInfo / 10;
  43.         }
  44.         else
  45.         {
  46.             Page = AllInfo / 10 + 1;
  47.         }
  48.         this.lblPageCount.Text = Page.ToString();
  49.     }
  50.     public void GetALLInfo()
  51.     {
  52.         int index = Convert.ToInt32(ViewState["count"]);
  53.         (this.Page.FindControl(this.GridViewName) as Repeater).DataSource = DB.ExecuteDataSet("GetRecordFromPage", this.TableName, "*", this.Column, this.PageSize, index, 0, "asc", "");
  54.         (this.Page.FindControl(this.GridViewName) as Repeater).DataBind();
  55.     }
  56.     public string GridViewName
  57.     {
  58.         get { return ViewState["GridViewNam"].ToString(); }
  59.         set { ViewState["GridViewNam"] = value; }
  60.     }
  62.     public string TableName
  63.     {
  64.         get { return ViewState["TableName"].ToString(); }
  65.         set { ViewState["TableName"] = value; }
  66.     }
  67.     public int PageSize
  68.     {
  69.         get { return Convert.ToInt32(ViewState["PageSize"]); }
  70.         set { ViewState["PageSize"] = value; }
  71.     }
  72.     public string Column
  73.     {
  74.         get { return ViewState["column"].ToString(); }
  75.         set { ViewState["column"] = value; }
  76.     }
  79.     protected void ClikMe(object sender, CommandEventArgs e)
  80.     {
  81.         string name = e.CommandName;
  82.         if (name == "FirstCmd")
  83.         {
  84.             ViewState["count"] = 1;
  85.         }
  86.         else if (name == "PreCmd")
  87.         {
  88.             if (Convert.ToInt32(ViewState["count"]) == 1)
  89.             {
  90.                 ViewState["count"] = 1;
  91.             }
  92.             else
  93.             {
  94.                 ViewState["count"] = Convert.ToInt32(ViewState["count"]) - 1;
  95.             }
  96.         }
  97.         else if (name == "NextCmd")
  98.         {
  99.             if (Convert.ToInt32(ViewState["count"]) == Convert.ToInt32(this.lblPageCount.Text))
  100.             {
  101.                 ViewState["count"] = Convert.ToInt32(this.lblPageCount.Text);
  102.             }
  103.             else
  104.             {
  105.                 ViewState["count"] = Convert.ToInt32(ViewState["count"]) + 1;
  106.             }
  107.         }
  108.         else 
  109.         {
  110.             ViewState["count"] = Convert.ToInt32(this.lblPageCount.Text);
  111.         }
  112.         GetALLInfo();
  113.     }
  114.     protected void txtCurrentPage_TextChanged(object sender, EventArgs e)
  115.     {
  116.         ViewState["count"] = Convert.ToInt32(this.txtCurrentPage.Text);
  117.         (this.Page.FindControl(this.GridViewName) as Repeater).DataSource = DB.ExecuteDataSet("GetRecordFromPage", this.TableName, "*", this.Column, this.PageSize, Convert.ToInt32(ViewState["count"]), 0, "asc", "");
  118.         (this.Page.FindControl(this.GridViewName) as Repeater).DataBind();
  119.     }
  120. }