using System;
using System.Data;
using System.Data.SqlClient;
using System.Configuration;
using System.Collections;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
namespace Yin
{
public partial class manNew : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
binds();
}
}
protected void binds(){
int chars;
if (Request.QueryString["id"] == "" || Request.QueryString["id"] == null)
chars = 1;
else
chars = int.Parse(Request.QueryString["id"]);
News news = new News();
DataView dv = news.GetAllNew(chars);
GridView1.DataSource = dv;
//GridView1.AutoGenerateDeleteButton = true;
//GridView1.AutoGenerateEditButton = true;
GridView1.DataKeyNames = new string[] { "newId" };//主键
GridView1.DataBind();
for (int i = 0; i <= GridView1.Rows.Count - 1; i++){
DataRowView mydrv;
string gIntro;
if (GridView1.PageIndex == 0){
mydrv = dv[i];
gIntro = Convert.ToString(mydrv["newContent"]);
GridView1.Rows[i].Cells[2].Text = SubStr(gIntro, 20);
string gIntros = Convert.ToString(mydrv["newTitle"]);
GridView1.Rows[i].Cells[1].Text = SubStr(gIntro, 10);
}
else{
mydrv = dv[i + (5 * GridView1.PageIndex)];
gIntro = Convert.ToString(mydrv["newContent"]);
GridView1.Rows[i].Cells[2].Text = SubStr(gIntro, 20);
}
}
}
public string SubStr(string sString, int nLeng){
if (sString.Length <= nLeng)
return sString;
string sNewStr = sString.Substring(0, nLeng);
sNewStr = sNewStr + "...";
return sNewStr;
}
#region 删除
protected void GridView1_RowDeleting(object sender, GridViewDeleteEventArgs e){
string strSql = "delete from News where newId= @id";// +GridView1.DataKeys[e.RowIndex].Value.ToString() + "'";
SqlParameter parms = new SqlParameter("@id", SqlDbType.Int);
parms.Value = GridView1.DataKeys[e.RowIndex].Value.ToString();
int val = SqlHelper.ExecuteNonQuery(CommandType.Text, strSql, parms);
if (val > 0)
RegisterClientScriptBlock("", "<script laguage='javascrt'>alert('删除成功');</script>");
else
RegisterClientScriptBlock("", "<script laguage='javascrt'>alert('删除时发生错误');</script>");
binds();
}
#endregion
#region 编辑模式
protected void GridView1_RowEditing(object sender, GridViewEditEventArgs e){
GridView1.EditIndex = e.NewEditIndex;
binds();
}
#endregion
#region 更新
protected void GridView1_RowUpdating(object sender, GridViewUpdateEventArgs e){
string str = "update News set newTitle=@newTitle,newContent=@newContent where newId = @newId";
SqlParameter [] parms ={ new SqlParameter("@newTitle",SqlDbType.VarChar,100),
new SqlParameter("@newContent",SqlDbType.VarChar,8000),
new SqlParameter("@newId",SqlDbType.VarChar,10)};
parms[0].Value = ((TextBox)(GridView1.Rows[e.RowIndex].Cells[1].Controls[0])).Text.ToString().Trim();
parms[1].Value = ((TextBox)(GridView1.Rows[e.RowIndex].Cells[2].Controls[0])).Text.ToString().Trim();
parms[2].Value = ((TextBox)(GridView1.Rows[e.RowIndex].Cells[0].Controls[0])).Text.ToString().Trim();
int val = SqlHelper.ExecuteNonQuery(CommandType.Text, str, parms);
if (val > 0)
RegisterClientScriptBlock("", "<script laguage='javascrt'>alert('更新成功');</script>");
else
RegisterClientScriptBlock("", "<script laguage='javascrt'>alert('更新时发生错误');</script>");
binds();
}
#endregion
#region 取消
protected void GridView1_RowCancelingEdit(object sender, GridViewCancelEditEventArgs e){
GridView1.EditIndex = -1;
binds();
}
#endregion
}
}