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