gridview的使用(后台代码)

最新推荐文章于 2019-07-15 22:39:24 发布
最新推荐文章于 2019-07-15 22:39:24 发布
阅读量759 收藏
点赞数
文章标签： exception object null session string delete
版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。
本文链接：https://blog.csdn.net/QiXing_Gan/article/details/5344678
版权

using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using HeartFly.Model;
using HeartFly.ReflectionFactory;
using System.Collections;

namespace HeartFly.UI.Admin
{
    public partial class SelEmployeePage : System.Web.UI.Page
    {
        public bool isDelete = false;//是否显示删除按钮
        public bool isUpdate = false;//是否显示修改按钮

        public int isAmend = 0; //判断跳转后是否可以更改信息 1:可以修改 0:不可修改

        EmployeeModel empModel = null;
        IList<EmployeeModel> employeeList = new List<EmployeeModel>();

        protected void Page_Load(object sender, EventArgs e)
        {
            if (Session["userInfo"] != null)
            {
                if (!IsPostBack)
                {
                    NowPage = 0;
                    empID = int.MaxValue;
                    empMoney = string.Empty;
                    empType = string.Empty;
                    empvalidity = 1;
                    isBtnVisible();
                    UserDateBand();
                }
            }
            else
            {
                Response.Redirect("AdminLogin.aspx");
            }
        }

        private void UserDateBand()
        {
            PagedDataSource userInfoData = new PagedDataSource();

            userInfoData.DataSource = HeartFly_AbstractBLL.GetReflection_IBLLEmployee().SelectEmployee(empModel = new EmployeeModel(empID,empType,empMoney,empvalidity));
            userInfoData.AllowPaging = true;//启用分页
            userInfoData.CurrentPageIndex = NowPage;//当前页
            userInfoData.PageSize = 10;//每页显示的行数

            IsVisible(userInfoData);

            AllPage = userInfoData.PageCount;
            //if (userInfoData.Count <= 0)
            //{
            //    JScript.Alert("没有查询到数据", this.Page); ;
            //    return;
            //}
            //else
            //{
                this.gvUserInfo.DataSource = userInfoData;
                this.gvUserInfo.DataBind();

                if (this.gvUserInfo.Rows.Count <= 0)
                {
                    //JScript.AlertAndRedirect("没有查询到数据","SelEmployeePage.aspx", this.Page);
                    //return;
                    Response.Redirect("SelEmployeePage.aspx");
                }
            //}
        }

        private void isBtnVisible()
        {
            if ((Session["userRightList"] as IList<RightModel>) != null)
            {
                foreach (RightModel item in (Session["userRightList"] as IList<RightModel>))
                {
                    if (item.RightID.ToString().ToUpper().Equals("15248682-4914-43B0-B964-981A5131BFB0"))
                    {
                        isDelete = true;
                    }
                    if (item.RightID.ToString().ToUpper().Equals("91315D4B-1C30-4EBE-A070-7D9C2F608F6E"))
                    {
                        isUpdate = true;
                    }
                }
                if (isUpdate == true)
                {
                    isAmend = 1;
                }
            }
        }

        #region 控制翻页

        protected void btnFristPage_Click(object sender, EventArgs e)
        {
            NowPage = 0;
            isBtnVisible();
            UserDateBand();
        }

        protected void btnUpPage_Click(object sender, EventArgs e)
        {
            NowPage--;
            if (NowPage == -1)
            {
                NowPage = 0;
            }
            isBtnVisible();
            UserDateBand();
        }

        protected void btnDownPage_Click(object sender, EventArgs e)
        {
            NowPage++;
            if (NowPage >= AllPage)
            {
                NowPage = AllPage;
            }
            isBtnVisible();
            UserDateBand();
        }

        protected void btnLastPage_Click(object sender, EventArgs e)
        {
            NowPage = Convert.ToInt32(AllPage) - 1;
            isBtnVisible();
            UserDateBand();
        }

        /// <summary>
        /// 当前页
        /// </summary>
        public int NowPage
        {
            get
            {
                return (int)ViewState["page"];
            }
            set
            {
                ViewState["page"] = value;
            }
        }

        /// <summary>
        /// 总页数
        /// </summary>
        public int AllPage
        {
            get
            {
                return (int)ViewState["allpage"];
            }
            set
            {
                ViewState["allpage"] = value;
            }
        }
        #endregion

        #region 控制 首页/上一页/尾页/下一页 是否有效

        /// <summary>
        /// 控制 首页/上一页/尾页/下一页 是否有效
        /// </summary>
        /// <param name="userInfoData"></param>
        private void IsVisible(PagedDataSource userInfoData)
        {
            if (userInfoData.IsFirstPage)
            {
                btnFristPage.Enabled = false;
                btnUpPage.Enabled = false;
            }
            if (userInfoData.IsLastPage)
            {
                btnLastPage.Enabled = false;
                btnDownPage.Enabled = false;
            }
            if (!userInfoData.IsFirstPage)
            {
                btnFristPage.Enabled = true;
                btnUpPage.Enabled = true;
            }
            if (!userInfoData.IsLastPage)
            {
                btnLastPage.Enabled = true;
                btnDownPage.Enabled = true;
            }

            btnDelectCheck.Visible = isDelete;
        }
        #endregion

        /// <summary>
        /// 编号
        /// </summary>
        private int empID
        {
            get
            {
                return Convert.ToInt32(ViewState["empID"].ToString());
            }
            set
            {
                try
                {
                    ViewState["empID"] = value ;
                }
                catch (Exception)
                {
                    ViewState["empID"] = int.MaxValue;
                }
               
            }
        }

        /// <summary>
        /// 类型
        /// </summary>
        private string empType
        {
            get
            {
                return ViewState["empType"].ToString();
            }
            set
            {
                try
                {
                    ViewState["empType"] = value;
                }
                catch (Exception)
                {
                    ViewState["empType"] = string.Empty;
                }

            }
        }
        /// <summary>
        /// 工资范围
        /// </summary>
        private string empMoney
        {
            get
            {
                return ViewState["empMoney"].ToString();
            }
            set
            {
                try
                {
                    if (value.Equals("0"))
                    {
                        ViewState["empMoney"] = string.Empty;
                    }
                    else
                    {
                        ViewState["empMoney"] = value;
                    }
                }
                catch (Exception)
                {
                    ViewState["empMoney"] = string.Empty;
                }

            }
        }

        /// <summary>
        /// 有效性
        /// </summary>
        private int empvalidity
        {
            get
            {
                return Convert.ToInt32(ViewState["empvalidity"]);
            }
            set
            {
                try
                {
                    if (value.ToString().Equals("2"))
                    {
                        ViewState["empvalidity"] = int.MaxValue;
                    }
                    else
                    {
                        ViewState["empvalidity"] =value;
                    }
                }
                catch (Exception)
                {
                    ViewState["empvalidity"] = int.MaxValue;
                }

            }
        }

        /// <summary>
        /// 删除选中项
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        protected void btnDelectCheck_Click(object sender, EventArgs e)
        {
            CheckBox cb;
            EmployeeModel employeeModel = null;
            IList<EmployeeModel> employeeList = new List<EmployeeModel>();
            for (int i = 0; i < this.gvUserInfo.Rows.Count; i++)
            {
                cb = (CheckBox)this.gvUserInfo.Rows[i].FindControl("ck");

                if (cb != null)
                {
                    if (cb.Checked)
                    {
                        employeeModel = new EmployeeModel();
                        employeeModel.employeeID = Convert.ToInt32(this.gvUserInfo.Rows[i].Cells[0].Text.ToString());
                        employeeList.Add(employeeModel);

                    }
                }
            }
            if (employeeList != null && employeeList.Count > 0)
            {
                int count = HeartFly_AbstractBLL.GetReflection_IBLLEmployee().DeleteEmployee(employeeList);

                if (count == 1)
                {
                    isBtnVisible();
                    UserDateBand();
                }
                else
                {
                    //Response.Write("<script>alert('数据删除失败,请重新操作!');window.location.href='SelFriendContactPage.aspx'</script>");
                    JScript.AlertAndRedirect("数据删除失败,请重新操作!", "SelEmployeePage.aspx", this.Page);
                }
            }
        }

        protected void gvUserInfo_RowDataBound(object sender, GridViewRowEventArgs e)
        {
            if (e.Row.RowType == DataControlRowType.DataRow)
            {
                e.Row.Attributes.Add("onmouseover", "this.style.backgroundColor='#e0e0e0';");
                e.Row.Attributes.Add("onmouseout", "this.style.backgroundColor='#fdffff';");

                LinkButton linBtn = e.Row.FindControl("linbtnDelete") as LinkButton;
                linBtn.Attributes.Add("onclick", "return confirm('删除后不可恢复，确认删除吗？')");
            }
        }

        protected void ImageButton1_Click(object sender, ImageClickEventArgs e)
        {
            if (Request["ID"] != null && Request["ID"] != "")
            {
                try
                {
                    empID = Convert.ToInt32(Request["ID"].ToString());
                }
                catch (Exception)
                {
                    empID = int.MaxValue;
                }
            }
            if (Request["ID"] == null || Request["ID"] == "")
            {

                empID = int.MaxValue;

            }
            if (Request["validity"] != null && Request["validity"] != "")
            {
                try
                {
                    empvalidity = Convert.ToInt32(Request["validity"].ToString());
                }
                catch (Exception)
                {
                    empvalidity = int.MaxValue;
                }
            }
            if (Request["validity"] == null || Request["validity"] == "")
            {
                empvalidity = int.MaxValue;
            }
            empMoney = Request["money"].ToString();
            empType = Request["type"].ToString();

            isBtnVisible();
            UserDateBand();
        }

        protected void gvUserInfo_RowCommand(object sender, GridViewCommandEventArgs e)
        {
            int count = 0;

            if (e.CommandName.Equals("delete"))
            {
                empModel = new EmployeeModel();
                empModel.employeeID = Convert.ToInt32(e.CommandArgument.ToString());

                count = HeartFly_AbstractBLL.GetReflection_IBLLEmployee().DeleteEmployee(empModel);

                if (count == 1)
                {
                    JScript.Alert("数据删除成功", this.Page);

                    isBtnVisible();
                    UserDateBand();
                }
                else
                {
                    JScript.Alert("数据删除失败，请重新操作", this.Page);

                    isBtnVisible();
                    UserDateBand();
                }
            }
            if (e.CommandName.Equals("selemp"))
            {
                if (e.CommandArgument.ToString() != "" && e.CommandArgument != null)
                {
                    empModel = new EmployeeModel();
                    empModel.employeeID = Convert.ToInt32(e.CommandArgument.ToString().Split(',')[0]);
                    empModel.employeeValidity = empvalidity;

                    employeeList = HeartFly_AbstractBLL.GetReflection_IBLLEmployee().SelectEmployee(empModel);

                    if (employeeList != null && employeeList.Count > 0)
                    {
                        foreach (EmployeeModel item in employeeList)
                        {
                            empModel = item;
                        }
                        Session["updateEmp"] = empModel;

                        Response.Redirect("SelOneEmployeePage.aspx?pd=" + e.CommandArgument.ToString().Split(',')[1]);
                    }
                }

            }
            if (e.CommandName.Equals("update"))
            {
                if (e.CommandArgument.ToString() != "" && e.CommandArgument != null)
                {
                    empModel = new EmployeeModel();
                    empModel.employeeID = Convert.ToInt32(e.CommandArgument.ToString().Split(',')[0]);

                    employeeList = HeartFly_AbstractBLL.GetReflection_IBLLEmployee().SelectEmployee(empModel);

                    if (employeeList != null && employeeList.Count > 0)
                    {
                        foreach (EmployeeModel item in employeeList)
                        {
                            empModel = item;
                        }

                        Session["updateEmp"] = empModel;

                        Response.Redirect("SelOneEmployeePage.aspx?pd=" + e.CommandArgument.ToString().Split(',')[1]);
                    }
                }
            }
           
        }

        protected void gvUserInfo_RowDeleting(object sender, GridViewDeleteEventArgs e)
        {

        }

        protected void gvUserInfo_RowUpdating(object sender, GridViewUpdateEventArgs e)
        {

        }
    }
}

isme2013
关注
  • 0
    点赞
  • 踩
  • 0
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
C#.NET GridView功能各种界面效果源代码超实用
04-09
GridView用了这么久，还不知道还有这么多功能没有使用过，可以进行排序，表头固定，页面新增修改，做表尾统计等。有详细源代码
Gridview后台代码
weixin_30730053的博客
08-27 113
protected void Page_Load(object sender, EventArgs e) { if (!Page.IsPostBack) { Getdata(); } } public void Getdata() { GridView1.Da...
使用后台代码实现Gridview显示sql数据
zhangqiagn1104的专栏
05-15 1384
代码如下： 在page_lode函数中，引用getData（）；即可 public void getData() { SqlConnection con = new SqlConnection("Data Source=PC-PC;Initial Catalog=TunnelMonitor;Integrated Security=True");
我的MVC 简单的gridview 操作
06-19
我的MVC 简单的gridview 操作 删除 全选啊 光棒 送给大家
GridView 使用笔记 - 后台部分
记录 分享
03-10 877
数据绑定： private void GridDataBind() { SqlHelper db = new SqlHelper(); db.Open(); SqlCommand Cmd = new SqlCommand(); Cmd.Connection = db.con; Cmd.CommandTi
GridView删除行后台代码
07-03
GridView删除行后台代码，测试通过。
C# gridview 操作源代码大全
04-16
10. **数据操作的事务处理**：当需要确保一组操作的原子性时，可以在后台代码中使用TransactionScope来包裹增删改操作。 11. **异步处理**：通过AJAX技术，如UpdatePanel或jQuery，可以实现GridView的部分更新，...
代码实现GridView数据显示
11-16
这个项目可能包含了一个.aspx页面，其中包含一个GridView控件，以及对应的.aspx.cs后台代码文件，里面实现了数据源的创建、数据绑定和事件处理。通过查看和学习这个示例，你可以更好地理解和掌握如何在实际项目中...
GridView分页代码简单万能实用
10-27
GridView在使用.net技术搭建的后台，在商品列表或者是信息列表经常会出现;它的作用在于有效的管理信息，增删改查等等最主要的是还可以实现分页，这一点是无可比靡的，接下来介绍如何使用GridView实现分页，需要了解...
GridView代码
12-27
对于更新（修改）和删除操作，GridView会在用户触发操作时自动处理数据库操作，但你需要在后台代码中编写事件处理程序，如RowUpdating和RowDeleting，以执行实际的数据库更新或删除命令： ```csharp protected void...
GridView详解
Urchin_dong的博客
03-26 6415
GridView详解
【ASP.NET】GridView连接数据库，显示数据
热门推荐
像风走过八千里
05-24 2万+
前端 1、添加控件GridView，添加数据源，接着按步骤选择自己的数据库 添加数据源显示数据有俩种方法： （1）一种方法是在GridView控件上直接按步骤添加数据源，及设计想要显示的列，这种方法比较直接简单 （2）另一种方法是直接用后端的代码实现显示数据 鉴于后边的功能想要把“编辑”和“删除”列加在后边，而通过代码显示的数据，新添加的列在前边，不美观，所以进行了手动添加数据源这步操作...
gridview 报错
代码特工的专栏
03-26 713
类型“GridView”的控件“PropertyList”必须放在具有 runat=server 的窗体标记内。     GridViewAutoGenerateColumns 属性 获取或设置一个值，该值指示是否为数据源中的每个字段自动创建绑定字段。
gridview后台增加列（转载）
weixin_30955341的博客
07-15 344
gridview后台增加列（转载） protected void Page_Load(object sender, EventArgs e) { DataTable dt = new DataTable(); DataColumn dc;//创建列 DataRow dr; //创建行 string[] He...
asp.net中gridview控件怎么使用
最新发布
06-09
2.然后，在页面的代码后台中，设置 GridView 的数据源。 ``` protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { GridView1.DataBind(); } } protected void SqlDataSource1_...

“相关推荐”对你有帮助么？

  • 非常没帮助
  • 没帮助
  • 一般
  • 有帮助
  • 非常有帮助
提交
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

当前余额3.43元 前往充值 >
需支付：10.00元
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付元
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明：

1.余额是钱包充值的虚拟货币，按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载，可以购买VIP、付费专栏及课程。

余额充值