当前文件： webzcn/Admin/GuestBookManger.aspx.cs[6K，2009-6-12 11:58:27]，打开代码结构图

		            
  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 sql;
 12
 13public partial class Admin_GuestBookManger : System.Web.UI.Page
 14...{
 15    SqlDB sqldb = new SqlDB();
 16    Operation operate = new Operation();
 17    protected void Page_Load(object sender, EventArgs e)
 18    ...{
 19        if (!IsPostBack)
 20        ...{
 21            if (Session["Admin"] == null)
 22            ...{
 23                Response.Redirect("index.aspx");
 24            }
 25            P2.Visible = false;
 26            P1.Visible = false;
 27            GridViewBind();
 28        }
 29    }
 30    /**//// <summary>
 31    /// 绑定GridView显示列表
 32    /// </summary>
 33    private void GridViewBind()
 34    ...{
 35        string strSql = "select * from guestBook";
 36        operate.GridViewBind(GridView1, strSql);
 37    }  
 38    /**//// <summary>
 39    /// 准备执行插入命令
 40    /// </summary>
 41    protected void GridView1_RowCommand(object sender, GridViewCommandEventArgs e)
 42    ...{
 43        if (e.CommandName == "Insert")
 44        ...{
 45            P2.Visible = true;
 46            P1.Visible = false;
 47        }
 48    }
 49    /**//// <summary>
 50    /// 执行翻页命令
 51    /// </summary>
 52    protected void GridView1_OnPageIndexChanged(object sender, GridViewPageEventArgs e)
 53    ...{
 54        GridView1.PageIndex = e.NewPageIndex;
 55        GridViewBind();
 56    }
 57    /**//// <summary>
 58    /// 执行删除
 59    /// </summary>
 60    /// <param name="sender"></param>
 61    /// <param name="e"></param>
 62    protected void GridView1_RowDeleting(object sender, GridViewDeleteEventArgs e)
 63    ...{
 64        string id = GridView1.DataKeys[e.RowIndex].Value.ToString();
 65        string strSql = "delete from guestbook where AriticleId=" + id;
 66        try
 67        ...{
 68            if (sqldb.ExecuteNonQueryCheck(strSql) > 0)
 69            ...{
 70                strSql = "delete from guestbookClass where AriticleId="+id;
 71                sqldb.ExecuteNonQuery(strSql);                                 
 72                GridViewBind();
 73                sql.Operation.Show_Msg("恭喜您，评论删除成功！");
 74            }
 75            else
 76            ...{
 77                sql.Operation.Show_Msg("评论删除失败，请重新删除！");               
 78            }
 79        }
 80        catch (Exception ex)
 81        ...{
 82        }
 83        finally
 84        ...{
 85        }
 86    }
 87    /**//// <summary>
 88    /// 准备执行编辑
 89    /// </summary>
 90    /// <param name="sender"></param>
 91    /// <param name="e"></param>
 92    protected void GridView1_RowEditing(object sender, GridViewEditEventArgs e)
 93    ...{
 94        P1.Visible = true;
 95        P2.Visible = false;
 96        string id = GridView1.DataKeys[e.NewEditIndex].Value.ToString();
 97        ViewState["id"] = id;
 98        string strSql = "select * from Guestbook where AriticleId=" + id;
 99        DataSet ds = sqldb.GetDS(strSql);
100        txtTitleEdit.Text = ds.Tables[0].Rows[0]["Title"].ToString();
101        txtContentEdit.Text = ds.Tables[0].Rows[0]["content"].ToString();
102        txtEmailEdit.Text=ds.Tables[0].Rows[0]["email"].ToString();
103        txtPhoneEdit.Text = ds.Tables[0].Rows[0]["phone"].ToString();
104        txtUserNameEdit.Text = ds.Tables[0].Rows[0]["username"].ToString();
105        ds.Clear();
106
107    }
108    /**//// <summary>
109    /// 取消添加
110    /// </summary>
111    /// <param name="sender"></param>
112    /// <param name="e"></param>
113    protected void btnCancelAdd_Click(object sender, EventArgs e)
114    ...{
115        P2.Visible = false;
116    }
117    /**//// <summary>
118    /// 取消编辑
119    /// </summary>
120    /// <param name="sender"></param>
121    /// <param name="e"></param>
122    protected void btnCanelEdit_Click(object sender, EventArgs e)
123    ...{
124        P1.Visible = false;
125    }  
126    /**//// <summary>
127    /// 执行添加
128    /// </summary>
129    /// <param name="sender"></param>
130    /// <param name="e"></param>
131    protected void btnAdd_Click(object sender, EventArgs e)
132    ...{       
133
134        string Ip = Request.UserHostAddress.ToString();
135        string allValues = "'" + sqldb.CheckString(txtTitle.Text) + "','" + sqldb.CheckString(txtContent.Text) + "','" + sqldb.CheckString(txtUserName.Text) + "','" + sqldb.CheckString(txtEmail.Text) + "','" + sqldb.CheckString(txtPhone.Text) + "','" + Ip + "','" + DateTime.Now + "','暂无回复',0,0";
136        string strsql = "insert into guestbook (title,content,username,email,phone,ip,datetime,lastuser,hits,recallhits) values(" + allValues + ")";
137        if (sqldb.ExecuteNonQueryCheck(strsql) > 0)
138        ...{
139            txtTitle.Text = "";
140            txtContent.Text = "";
141            txtUserName.Text = "匿名";
142            txtEmail.Text = "";
143            txtPhone.Text = "";
144            P2.Visible = false;
145            GridViewBind();
146            sql.Operation.Show_Msg("恭喜您，评论发表成功！");
147        }
148        else
149        ...{
150            sql.Operation.Show_Msg("评论发表失败，请重试！");
151        }
152    }
153    /**//// <summary>
154    /// 执行编辑
155    /// </summary>
156    /// <param name="sender"></param>
157    /// <param name="e"></param>
158    protected void btnEdit_Click(object sender, EventArgs e)
159    ...{
160        string Ip = Request.UserHostAddress.ToString();
161        string strsql = "update guestbook set title='" + sqldb.CheckString(txtTitleEdit.Text.Trim()) + "',content='" + sqldb.CheckString(txtContentEdit.Text) + "',username='" + sqldb.CheckString(txtUserNameEdit.Text) + "',email='" + sqldb.CheckString(txtEmailEdit.Text) + "',phone='" + sqldb.CheckString(txtPhoneEdit.Text) + "',ip='" + Ip + "',datetime='" + DateTime.Now + "'where AriticleId=" + ViewState["id"].ToString();
162        if (sqldb.ExecuteNonQueryCheck(strsql) > 0)
163        ...{
164            txtTitleEdit.Text = "";
165            txtContentEdit.Text = "";
166            txtUserNameEdit.Text = "匿名";
167            txtEmailEdit.Text = "";
168            txtPhoneEdit.Text = "";
169            P1.Visible = false;
170            GridViewBind();
171            sql.Operation.Show_Msg("恭喜您，评论修改成功！");
172        }
173        else
174        ...{
175            sql.Operation.Show_Msg("评论修改失败，请重试！");
176        }        
177    }   
178}
179