通用后台设计

通用后台设计(一)

通用后台设计（一）
using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;

namespace AfterEndDemo.Admin
{
    public partial class NewsList : System.Web.UI.Page
    {
        protected void Page_Load(object sender, EventArgs e)
        {
            if (!IsPostBack)
            {
                ddlNewsListBinds();
                gvNewsListBinds(ddlNewstype.SelectedValue, txtTitle.Text);
            }
        }

        //绑定新闻类别
        protected void ddlNewsListBinds()
        {
            ddlNewstype.DataSource = DBHelper.GetDataTable("select * from NewsType");
            ddlNewstype.DataTextField = "Type";
            ddlNewstype.DataValueField = "ID";
            ddlNewstype.DataBind();
            //在下拉框的顶端添加一个选项
            ddlNewstype.Items.Insert(0, new ListItem("全部", ""));
        }

        //绑定新闻列表
        protected void gvNewsListBinds(String type, String title)
        {
            String sql = "select * from News where 1=1";

            if (!String.IsNullOrEmpty(type))
            {
                sql += " and NewsType=" + type;
            }

            if (!String.IsNullOrEmpty(title))
            {
                sql += " and Title like '%" + title + "%'";
            }

            gvNewsList.DataSource = DBHelper.GetDataTable(sql);
            gvNewsList.DataBind();
        }

        //搜索
        protected void imbSearch_Click(object sender, ImageClickEventArgs e)
        {
            gvNewsListBinds(ddlNewstype.SelectedValue, txtTitle.Text);
        }

        //分页
        protected void gvNewsList_PageIndexChanging(object sender, GridViewPageEventArgs e)
        {
            gvNewsList.PageIndex = e.NewPageIndex;
            gvNewsListBinds(ddlNewstype.SelectedValue, txtTitle.Text);
        }

        //在绑定行的时候激发
        protected void gvNewsList_RowDataBound(object sender, GridViewRowEventArgs e)
        {
            //判断是否是数据行
            if (e.Row.RowType == DataControlRowType.DataRow)
            {
                e.Row.Attributes.Add("onmouseover", "this.style.background='#FCFDEE'");
                e.Row.Attributes.Add("onmouseout","this.style.background='#FFFFFF'");
            }
        }

        protected void lbnDelete_Click(object sender, EventArgs e)
        {
            //用于获取表单元素指定的name的Value
            //如果有多个name相同的表单元素，将以","分隔
            string id = Request.Form["cbID"];
            if (String.IsNullOrEmpty(id))
            {
                Page.ClientScript.RegisterStartupScript(this.GetType(), "msg", "alert('未选择任何数据！');", true);
                return;
            }

            string sql = "delete From News Where id in (" + id + ")";
            string msg = "删除失败";
            if (DBHelper.ExecuteCommand(sql)>0)
            {
                msg = "删除成功!";
                //重绑定
                gvNewsListBinds(ddlNewstype.SelectedValue, txtTitle.Text);
            }

            Page.ClientScript.RegisterStartupScript(this.GetType(), "msg2", "alert('" + msg + "');location.href='NewsList.aspx'", true);

        }
        //新增
        protected void lbnAdd_Click(object sender, EventArgs e)
        {
            Response.Redirect("AddNews.aspx");
        }
        //本地编辑
        protected void gvNewsList_RowEditing(object sender, GridViewEditEventArgs e)
        {
            gvNewsList.EditIndex = e.NewEditIndex;
            gvNewsListBinds(ddlNewstype.SelectedValue, txtTitle.Text);
        }
        //更新
        protected void gvNewsList_RowUpdating(object sender, GridViewUpdateEventArgs e)
        {
           TextBox txtTitle=gvNewsList.Rows[e.RowIndex].Cells[2].Controls[0] as TextBox;

           int id=Convert.ToInt32(gvNewsList.DataKeys[e.RowIndex].Value);
           
        }
        //取消
        protected void gvNewsList_RowCancelingEdit(object sender, GridViewCancelEditEventArgs e)
        {
            gvNewsList.EditIndex = -1;
            gvNewsListBinds(ddlNewstype.SelectedValue, txtTitle.Text);
        }

        protected void gvNewsList_RowCreated(object sender, GridViewRowEventArgs e)
        {
            
        }
    }
}

通用后台设计(二)

通用后台设计（二）
using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Data.SqlClient;
using System.Data;
namespace AfterEndDemo.Admin
{
    public partial class AddNews : System.Web.UI.Page
    {
        protected void Page_Load(object sender, EventArgs e)
        {
            if (!IsPostBack)
            {
                ViewState["id"] = Request.QueryString["id"];
                ddlNewsTypeBinds();
                NewsBind();
            }
        }
        //修改绑定值
        protected void NewsBind() 
        {
            if (ViewState["id"]!=null)
            {
                DataTable dt = DBHelper.GetDataTable("select * from News where id=" + Convert.ToInt32(ViewState["id"]) + " ");
                txtTitle.Text = dt.Rows[0]["Title"].ToString();
                ddlNewsType.SelectedValue = dt.Rows[0]["NewsType"].ToString();
                txtFrom.Text = dt.Rows[0]["NewsFrom"].ToString();
                txtAuthor.Text = dt.Rows[0]["Author"].ToString();
                txtNewsContent.Text = dt.Rows[0]["NewsContent"].ToString();
            }
           

        }

        //绑定新闻类别
        protected void ddlNewsTypeBinds()
        {
            ddlNewsType.DataSource=DBHelper.GetDataTable("select * from newsType");
            ddlNewsType.DataTextField = "Type";
            ddlNewsType.DataValueField = "ID";
            ddlNewsType.DataBind();
        }

        //保存
        protected void lbnSave_Click(object sender, EventArgs e)
        {
            if ( ViewState["id"] ==null)
            {
                string sql = " insert into News(Title,NewsFrom,NewsImage,Author,NewsContent,NewsType,UserID,CreateTime) "
           + "  Values(@Title,@NewsFrom,@NewsImage,@Author,@NewsContent,@NewsType,@UserID,@CreateTime)";
                SqlParameter[] parameter = new SqlParameter[] { 
            new SqlParameter("@Title",txtTitle.Text),
            new SqlParameter("@NewsFrom",txtFrom.Text),
            new SqlParameter("@NewsImage","........"),
            new SqlParameter("@Author",txtAuthor.Text),
            new SqlParameter("@NewsContent",txtNewsContent.Text),
            new SqlParameter("@NewsType",ddlNewsType.SelectedValue),
            new SqlParameter("@UserID",1),
            new SqlParameter("@CreateTime",DateTime.Now.ToString("yyyy-MM-dd hh:mm:ss"))
            };
                int resule = DBHelper.ExecuteCommand(sql, parameter);
                if (resule > 0)
                {
                    Page.ClientScript.RegisterStartupScript(this.GetType(), "msg", "alert('保存成功')", true);

                }
            }

            else
            {
                string sql = "update News set ,"
                +" where ";
                SqlParameter[] parameter = new SqlParameter[]{
                 new SqlParameter("@Title",txtTitle.Text),
                  new SqlParameter("@NewsType",ddlNewsType.Text),
                   new SqlParameter("@NewsFrom",txtFrom.Text),
                    new SqlParameter("@Author",txtAuthor.Text),
                    new SqlParameter("@NewsContent",txtNewsContent.Text),
                    new SqlParameter("@id",ViewState["id"])
                };
                int result = DBHelper.ExecuteCommand(sql, parameter);
                if (result>0)
                {
                    Page.ClientScript.RegisterStartupScript(this.GetType(),
                        "msg", "alert('更新成功'); location.href='NewsList.aspx'", true);
                }

            }
           


        }


        //取消
        protected void lbnCancel_Click(object sender, EventArgs e)
        {
            Response.Redirect("NewsList.aspx");
        }
    }
}

通用后台(三)

通用后台(3)
using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Data.SqlClient;
namespace AfterEndDemo.Admin
{
    public partial class NewsTypeList : System.Web.UI.Page
    {
        protected void Page_Load(object sender, EventArgs e)
        {
            if (!IsPostBack)
            {
                this.GvNewsTypeListBinds();
            }
        }
        protected void GvNewsTypeListBinds()
        {
            gvNewsList.DataSource = DBHelper.GetDataTable("select* from NewsType");
            gvNewsList.DataBind();
        }

        protected void imbSearch_Click(object sender, ImageClickEventArgs e)
        {

        }

        protected void gvNewsList_RowEditing(object sender, GridViewEditEventArgs e)
        {
            gvNewsList.EditIndex = e.NewEditIndex;
            this.GvNewsTypeListBinds();
        }

        protected void gvNewsList_RowCancelingEdit(object sender, GridViewCancelEditEventArgs e)
        {
            gvNewsList.EditIndex = -1;
            this.GvNewsTypeListBinds();
        }

        protected void gvNewsList_RowUpdating(object sender, GridViewUpdateEventArgs e)
        {
            TextBox txtType = gvNewsList.Rows[e.RowIndex].Cells[2].Controls[0] as TextBox;

            int id = Convert.ToInt32(gvNewsList.DataKeys[e.RowIndex].Value);
            string sql = "update NewsType set where ";
            DBHelper.ExecuteCommand(sql, new SqlParameter("Type", txtType.Text), new SqlParameter("@id", id));
            //
            gvNewsList.EditIndex = -1;
            this.GvNewsTypeListBinds();

        }
    }
}

 

转载于:https://www.cnblogs.com/lijie007jh/archive/2012/06/25/2560867.html