Hospital/web/Module/Sys/User/List.aspx.cs

using System;
using System.Collections;
using System.Configuration;
using System.Data;
//using System.Linq;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.HtmlControls;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
//using System.Xml.Linq;
using System.Text;

namespace Com.Jpsoft.Hospital.Web.Module.Sys.User
{
    public partial class List : Com.Jpsoft.Hospital.Web.Common.BasePage
    {
        protected void Page_Load(object sender, EventArgs e)
        {
            if (!IsPostBack)
            {
                int pageindex = 1;
                int id = 0;
                string cmd = string.Empty;
                FetchQueryString("curpage", out pageindex);
                FetchQueryString("cmd", out cmd);
                FetchQueryString("uid", out id);
                AspNetPager1.RecordCount = pageindex * AspNetPager1.PageSize;
                AspNetPager1.CurrentPageIndex = pageindex;


                if (cmd == "del")
                {
                    Delete(id, pageindex);
                }

                BindData();

            }
        }

        private void Delete(int id, int pageindex)
        {
            Com.Jpsoft.Hospital.BLL.jp_sys_user user = new Com.Jpsoft.Hospital.BLL.jp_sys_user();
            try
            {
                user.Delete(id);
                Response.Write("<script>alert('删除成功！');window.navigate('List.aspx?curpage=" + pageindex + "');</script>");
            }
            catch (Exception ex)
            {
                Response.Write("<script>alert('错误原因：" + ex.ToString() + "');</script>");
            }

        }

        private void BindData()
        {
            int RecordCount = 0;
            string strWhere = " where 1=1";
            if (ViewState["SearchTerms"] != null)
            {
                strWhere = ViewState["SearchTerms"].ToString();
            }
            string strOrder = " order by user_createdate DESC";
            using (IDataReader idr = Com.Jpsoft.Hospital.DAL.jp_sys_userEx.SelectPage(AspNetPager1.CurrentPageIndex, AspNetPager1.PageSize, strWhere, strOrder))
            {
                if (idr.Read())
                {
                    RecordCount = Convert.ToInt32(idr["RecordCount"]);
                }
                idr.NextResult();

                GridView1.DataSource = idr;
                GridView1.DataBind();
            }
            this.AspNetPager1.RecordCount = RecordCount;
        }

        protected void AspNetPager1_PageChanged(object sender, EventArgs e)
        {
            BindData();
        }
        /// <summary>
        /// 查询
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        protected void btnSearch_Click(object sender, EventArgs e)
        {
            string username = GetSafeSql(txtUsername.Text.Trim());
            string name = GetSafeSql(txtName.Text.Trim());

            StringBuilder strWhere = new StringBuilder();
            strWhere.Append(" where 1=1 ");

            if (username.Length != 0)
            {
                strWhere.Append(" and user_loginname like '%" + username + "%'");
            }
            if (name.Length != 0)
            {
                strWhere.Append(" and user_name like '%" + name + "%'");
            }
            ViewState["SearchTerms"] = strWhere.ToString();
            BindData();

        }

        protected void btnAdd_Click(object sender, EventArgs e)
        {
            Response.Write("<script>window.location.href='Insert.aspx';</script>");
        }

        #region
        ///// <summary>
        ///// 行数据绑定
        /////// </summary>
        ///// <param name="sender"></param>
        ///// <param name="e"></param>
        //protected void GridView1_RowDataBound(object sender, GridViewRowEventArgs e)
        //{
        //    if (e.Row.RowType == DataControlRowType.DataRow)
        //    {
        //        if (e.Row.RowState == DataControlRowState.Alternate || e.Row.RowState == DataControlRowState.Normal)
        //        {
        //            ((LinkButton)e.Row.Cells[1].Controls[0]).Attributes.Add("onclick", "return confirm('确定要删除吗？');");
        //        }
        //    }
        //}
        ///// <summary>
        ///// 行删除事件
        /////// </summary>
        ///// <param name="sender"></param>
        ///// <param name="e"></param>
        //protected void GridView1_RowDeleting(object sender, GridViewDeleteEventArgs e)
        //{
        //    int id = int.Parse(this.GridView1.DataKeys[e.RowIndex].Value.ToString());
        //    Com.Jpsoft.Hospital.BLL.jp_sys_user user = new Com.Jpsoft.Hospital.BLL.jp_sys_user();
        //    try {
        //        user.Delete(id);
        //        Response.Write("<script>alert('删除成功！');window.navigate(location.href);</script>");
        //    }
        //    catch(Exception ex)
        //    {
        //        Response.Write("<script>alert('错误原因："+ex.ToString()+"');</script>");
        //    }
        //    BindData();
        //}
        #endregion

        protected void btnSynchro_Click(object sender, EventArgs e)
        {
            //读取用户信息
            string str = "";
            string sqlUser = "select user_loginname from jp_sys_user";
            DataTable dtUser = BLL.BaseClass.GetTable(sqlUser);
            foreach (DataRow drUser in dtUser.Rows)
            {
                str += string.Format(",'{0}'", drUser[0]);
            }
            if(!string.IsNullOrEmpty(str))
            {
                str = str.Substring(1);
            }

            //读取员工信息
            ArrayList error = new ArrayList();
            string sqlYG = "select gh,name from jp_v_rsks where gh not in (" + str + ")";
            DataTable dtYG = BLL.BaseClass.GetTable5(sqlYG);
            foreach (DataRow drYG in dtYG.Rows)
            {
                //写入用户信息
                Com.Jpsoft.Hospital.BLL.jp_sys_user bll = new Com.Jpsoft.Hospital.BLL.jp_sys_user();
                Com.Jpsoft.Hospital.Model.jp_sys_user model = new Com.Jpsoft.Hospital.Model.jp_sys_user();
                model.user_loginname = drYG[0].ToString();
                model.user_name = drYG[1].ToString();
                model.user_loginpwd = Com.Jpsoft.Hospital.Web.Common.MD5Encoding.GetMD5_Str(drYG[0].ToString());
                model.user_isadmin = false;
                model.user_islock = false;
                model.user_createdate = DateTime.Now;
                try
                {
                    int reId = bll.Add(model);

                    Com.Jpsoft.Hospital.Model.jp_sys_userrole userrolemodel = new Com.Jpsoft.Hospital.Model.jp_sys_userrole();
                    Com.Jpsoft.Hospital.BLL.jp_sys_userrole userrole = new Com.Jpsoft.Hospital.BLL.jp_sys_userrole();
                    userrolemodel.ur_roleid = 13;
                    userrolemodel.ur_userid = reId;
                    userrole.Add(userrolemodel);
                }
                catch (Exception ex)
                {
                    error.Add(drYG[0].ToString());
                }
            }
            if (error.Count > 0)
            {
                Response.Write("<script>alert('发生错误！原因：" + string.Join(",", (string[])error.ToArray(typeof(string))) + "');</script>");
            }
            else
            {
                Response.Write("<script>alert('同步完成！');</script>");
            }
        }
    }
}