我将一些常用到的语句封装到一个类,做成各个函数,
现在想把这个类改成接口,怎么实现?
using System;
using System.Data;
using System.Data.SqlClient;
using System.Web;
using System.Web.UI.WebControls;
using System.Collections;//用动态数组
namespace LogMyBbs
{
#region//分页初始化
public static void pageload(int Count, System.Web.UI.WebControls.Label Lallsum, System.Web.UI.WebControls.Label Lpage, System.Web.UI.WebControls.Label LCount)
{
// System.Web.HttpContext.Current.ViewState[ "PageNumber" ] = 20;
System.Web.HttpContext.Current.Session["PageNumber"] = 20;
System.Web.HttpContext.Current.Session["Count"] = Count;
Lallsum.Text = "1";
Lallsum.Text = Convert.ToString(((int)System.Web.HttpContext.Current.Session["Count"]));
if ((int)System.Web.HttpContext.Current.Session["Count"] % 20 != 0)//如果总条数不是20的倍数,ViewState[ "Count" ]要加20
{
LCount.Text = Convert.ToString(((int)System.Web.HttpContext.Current.Session["Count"] + 20) / 20);
}
else
{
LCount.Text = Convert.ToString(((int)System.Web.HttpContext.Current.Session["Count"]) / 20);
}
}
#endregion
public static void pageGrid(object sender, EventArgs e, string sqlstr, SqlDataAdapter ada, DataTable dt, int PageNumber, System.Web.UI.WebControls.DataGrid MyDataGrid, System.Web.UI.WebControls.Label Lpage, System.Web.UI.WebControls.TextBox tbGO, System.Web.UI.WebControls.LinkButton btnFirst, System.Web.UI.WebControls.LinkButton btnPrev, System.Web.UI.WebControls.LinkButton btnNext, System.Web.UI.WebControls.LinkButton btnLast)
{
string arg = ((System.Web.UI.WebControls.LinkButton)sender).CommandArgument.ToString();
switch (arg)
{
case "Next":
Binding(sqlstr, ada, dt, MyDataGrid);
//Session对象不能+=,所以必须转为int PageNumber
PageNumber = Convert.ToInt32(System.Web.HttpContext.Current.Session["PageNumber"].ToString());
PageNumber += 20;
//再将递增的值传回给Session
System.Web.HttpContext.Current.Session["PageNumber"] = PageNumber;
Lpage.Text = Convert.ToString(((int)System.Web.HttpContext.Current.Session["PageNumber"]) / 20); tbGO.Text = "";
break;
case "Previous":
Binding(sqlstr, ada, dt, MyDataGrid); PageNumber = Convert.ToInt32(System.Web.HttpContext.Current.Session["PageNumber"].ToString());
PageNumber = PageNumber - 20;
//再将递增的值传回给Session
System.Web.HttpContext.Current.Session["PageNumber"] = PageNumber;
Lpage.Text = Convert.ToString(((int)System.Web.HttpContext.Current.Session["PageNumber"]) / 20); tbGO.Text = "";
break;
case "First":
Binding(sqlstr, ada, dt, MyDataGrid); System.Web.HttpContext.Current.Session["PageNumber"] = 20;
Lpage.Text = Convert.ToString(1);
btnPrev.Enabled = false;
btnFirst.Enabled = false;
break;
case "Last":
Binding(sqlstr, ada, dt, MyDataGrid); System.Web.HttpContext.Current.Session["PageNumber"] = 20;
PageNumber = Convert.ToInt32(System.Web.HttpContext.Current.Session["PageNumber"].ToString());
PageNumber = ((int)System.Web.HttpContext.Current.Session["Count"] / 20) * 20;
//再将PageNumber值传回给Session
System.Web.HttpContext.Current.Session["PageNumber"] = PageNumber; Lpage.Text = Convert.ToString(((int)System.Web.HttpContext.Current.Session["Count"] + 20) / 20);
btnNext.Enabled = false;
btnLast.Enabled = false;
break;
}
}
public static void ShowStats(System.Web.UI.WebControls.LinkButton btnFirst, System.Web.UI.WebControls.LinkButton btnPrev, System.Web.UI.WebControls.LinkButton btnNext, System.Web.UI.WebControls.LinkButton btnLast)
{
//再将PageNumber值传回给Session
//System.Web.HttpContext.Current.Session["PageNumber"] = PageNumber;
if (((int)System.Web.HttpContext.Current.Session["PageNumber"]) >= (int)System.Web.HttpContext.Current.Session["Count"])
{
btnNext.Enabled = false;
btnLast.Enabled = false;
}
if (((int)System.Web.HttpContext.Current.Session["PageNumber"]) <= 0)
{
btnPrev.Enabled = false;
btnFirst.Enabled = false;
}
}
#region//绑定数据库值到DropDownList
public static void Bind_DropDownList(string sqlbind,SqlDataAdapter ada,DataTable dt,System.Web.UI.WebControls.DropDownList DDL,string ColumnName)
{
// LogMyBbs.pClassMyBbs.Binding(sqlbind,ada,dt);
#region
ada=new SqlDataAdapter(sqlbind,DA.DataAccess.conn_MyBbs());
dt.Clear();
ada.Fill(dt); //填充DataTable,
#endregion
DDL.Items.Clear();
DDL.Items.Insert(0, new ListItem( "请选择 ", "请选择")); //using System.Web.UI.WebControls; 才有ListItem
//绑定数据库中字段到DropDownList,
for (int i = 0; i < dt.Rows.Count; i++)
{
ListItem item = new ListItem();
item.Text = dt.Rows[i][ColumnName].ToString();
item.Value = dt.Rows[i][ColumnName].ToString(); DDL.Items.Add(item);
// Response.Write(DDdep.Items.ToString());
}
}
#endregion
#region//登陆
public static void login(string sqlbind,SqlDataAdapter ada_login,DataTable dt_login,System.Web.UI.WebControls.TextBox Name,System.Web.UI.WebControls.TextBox Password,string ColumnName,string ColumnPassword,string sID,string sPassword,string PageName1,string PageName2)
{
#region
ada_login=new SqlDataAdapter(sqlbind,DA.DataAccess.conn_MyBbs());
dt_login.Clear();
ada_login.Fill(dt_login); //填充DataTable,
#endregion
for(int i=0;i<dt_login.Rows.Count;i++)
{ #region
if(Name.Text.ToString().Trim()!="" && Password.Text.ToString().Trim()!="")
{
#region
if(dt_login.Rows[i][ColumnName].ToString().Trim()==Name.Text.ToString().Trim() && dt_login.Rows[i][ColumnPassword].ToString().Trim()==Password.Text.ToString().Trim())
{
#region
if(Name.Text.ToString().Trim()==sID && Password.Text.ToString().Trim()==sPassword)
{ System.Web.HttpContext.Current.Response.Redirect(PageName1);
}
else
{
System.Web.HttpContext.Current.Response.Redirect(PageName2);
}
#endregion
return;
}
#endregion
}
#endregion
}
System.Web.HttpContext.Current.Response.Write("<script language=javascript>alert('用户名和密码错误')</script>");
return;
}
#endregion
}
{
//方法
void bb(){}}
//////////////调用
class cc:aa //右键移上aa,引用接口 ,自动出来 void bb(){ throw new...}
{}