sd.Value = clne.Trim();
SqlParameter se = updateClass.Parameters.Add(\, SqlDbType.Char, 200);
se.Value = oldname.Trim();
int rt = updateClass.ExecuteNonQuery(); if (rt > 0) {
myLabel.Text = \更新成功！\; cont.Close();
updateArticle(clne.Trim(), oldname.Trim()); MyDataGrid.EditItemIndex = -1; getClass(); } else {
myLabel.Text = \更新错误！\; cont.Close(); } } } public {
string num = e.Item.Cells[2].Text; //取得文章数 num = num.Trim(); if (num != \) {
myLabel.Text = \你不能删除有文章数的分类!\; } else {
delClass(this.MyDataGrid.DataKeys[e.Item.ItemIndex]); int d = MyDataGrid.PageCount % MyDataGrid.PageSize; if (d == 0) {
MyDataGrid.CurrentPageIndex = MyDataGrid.CurrentPageIndex - 1; }
getClass(); } } public {
this.MyDataGrid.EditItemIndex = -1;
void
MyDataGrid_CancelCommand(object
source,
System.Web.UI.WebControls.DataGridCommandEventArgs e)
//验证分类是否有文章
void
MyDataGrid_DeleteCommand(object
source,
System.Web.UI.WebControls.DataGridCommandEventArgs e)
//回到编辑状态 //更新
getClass(); } public {
this.MyDataGrid.EditItemIndex = e.Item.ItemIndex; getClass();
dr = ds.Tables[\].Rows[MyDataGrid.EditItemIndex]; //取得popedom字段 oldclass = (string)dr[\]; oldclass = oldclass.Trim(); Session[\] = oldclass; Response.Write(Session[\]); }
public void MyDataGrid_SelectedIndexChanged(object sender, System.EventArgs e) {
getClass(); } }
void
MyDataGrid_EditCommand(object
source,
System.Web.UI.WebControls.DataGridCommandEventArgs e)
4.5 添加用户功能
系统管理员可以在该模块中添加用户，十分方便。其功能界面如图4-5-1所
示：
图 4-5-1 添加管理员界面图
该功能主要代码如下：
public partial class admin_admin_userAdd : System.Web.UI.Page {
protected void Page_Load(object sender, EventArgs e) {
if (!Page.IsPostBack) {
string userclass;
userclass = (string)Session[\]; if (userclass.Trim() != \系统管理员\) {
Page.Visible = false; }
} }
protected void Submit_Click(object sender, EventArgs e) {
if (Page.IsValid) {
addAdminUser(); } }
protected void addAdminUser() {
string con = ConfigurationManager.ConnectionStrings[\].ConnectionString;
//取得DSN字符
//连接数据库
SqlConnection myConnection = new SqlConnection(con);//连接字符串 myConnection.Open(); 验证是否已有此管理员名
selAdmin.CommandType = CommandType.StoredProcedure;
SqlParameter sel = selAdmin.Parameters.Add(\, SqlDbType.Char, 40); sel.Value = Username.Text.Trim();
SqlDataReader readAdmin = selAdmin.ExecuteReader(); if (readAdmin.Read() == true) {
myLabel.Text = \已有此管理员，请重新输入姓名！！\; readAdmin.Close();
myConnection.Close();//关闭连接 } else { try {
readAdmin.Close();
SqlCommand cd = new SqlCommand(\, myConnection);
//设置
SqlCommand selAdmin = new SqlCommand(\, myConnection); //
SQL命令
cd.CommandType = CommandType.StoredProcedure; //调用存储过程 SqlParameter username = cd.Parameters.Add(\, SqlDbType.Char, 40);
//设置存储过程参数
SqlParameter password = cd.Parameters.Add(\, SqlDbType.Char, 40); SqlParameter userclass = cd.Parameters.Add(\, SqlDbType.Char, 20); SqlParameter remark = cd.Parameters.Add(\, SqlDbType.NChar, 200); username.Value = Username.Text.Trim(); password.Value = Password.Text.Trim();
userclass.Value = UserClass.SelectedItem.Text.Trim(); remark.Value = Remarks.Text.Trim(); int se = cd.ExecuteNonQuery(); myLabel.Text = \添加管理员成功！\; myConnection.Close();//关闭连接 }
catch (SqlException e) {
Console.WriteLine(\ + e.Message); //出错处理 } } } }
//增加一个新管理员
4.6新闻转移功能
新闻管理员可以更改新闻类型，从而达到修改新闻类型的功能。 新闻转移界面如图4-7-1所示：
图4-7-1新闻转移界面图
public partial class admin_admin_move : System.Web.UI.Page {
public object num;
protected void Page_Load(object sender, EventArgs e) {
if (!Page.IsPostBack) {
string userclass;
userclass = (string)Session[\]; if (userclass.Trim() != \系统管理员\) {
Page.Visible = false; }
else getClass(); } }
protected void getClass()
{
try {
con
=
//根据权限设置分类
string
}
ConfigurationManager.ConnectionStrings[\].ConnectionString; //取得DSN字符
SqlConnection myConnection = new SqlConnection(con);//连接字符串 myConnection.Open();
SqlDataAdapter selClassAll = new SqlDataAdapter();//创建SqlDataAdapter 类 selClassAll.SelectCommand=new SqlCommand(\,myConnection); }
catch(SqlException e) { }
Console.WriteLine(\ + e.Message); //出错处
selClassAll.SelectCommand.CommandType=CommandType.StoredProcedure ; DataSet ds = new DataSet(); selClassAll.Fill(ds,\); ClassID.DataSource=ds;
ClassID.DataTextField=\; ClassID.DataValueField=\; ClassID.DataBind(); ToClassID.DataSource=ds;
ToClassID.DataTextField=\; ToClassID.DataValueField=\; ToClassID.DataBind(); myConnection.Close();
//调用存储过程
protected object selClassNum(string name)