Beispiel #1
0
 /// <summary>
 /// 添加
 /// </summary>
 /// <param name="entity"></param>
 /// <returns></returns>
 public bool Insert(AdminEntity entity)
 {
     return(sysuserobj.Insert(entity));
 }
Beispiel #2
0
 public Admin(AdminEntity adminEntity) : base(adminEntity)
 {
 }
Beispiel #3
0
        /// <summary>
        /// 提交表单
        /// </summary>
        private void SubmitForm()
        {
            if (ValidateData())
            {
                BCtrl_SysUser bllSysuser = new BCtrl_SysUser();
                bool          isSuccess  = false;
                AdminEntity   entity     = null;

                if (pid > 0)
                {
                    #region 修改
                    entity = bllSysuser.QuerySysUserEntity(pid);
                    if (entity != null)
                    {
                        entity.TrueName    = this.txtTruename.Value.Trim();
                        entity.User_Sex    = int.Parse(this.selsex.Value);
                        entity.User_Tel    = this.txtUser_Tel.Value.Trim();
                        entity.User_Mobile = this.txtUser_Mobile.Value.Trim();
                        entity.User_Mail   = this.txtUser_Mail.Value.Trim();
                        entity.User_DeptID = int.Parse(this.selDepartMent.Value);

                        isSuccess = bllSysuser.Update(entity);

                        if (isSuccess)
                        {
                            Page.ClientScript.RegisterStartupScript(this.GetType(), "adminEdit", "<script>bootbox.dialog(\"保存成功!\", [{\"label\": \"OK\",\"class\": \"btn-small btn-primary\",callback: function () {window.location.href = 'AdminManager.aspx?fun=" + Master.fun + "';}}]);</script>");
                        }
                        else
                        {
                            Page.ClientScript.RegisterStartupScript(this.GetType(), "adminEdit", "<script>bootbox.alert(\"保存失败\");</script>");
                        }
                    }
                    else
                    {
                        Page.ClientScript.RegisterStartupScript(this.GetType(), "adminEdit", "<script>bootbox.dialog(\"当前用户不存在或已被删除!\", [{\"label\": \"OK\",\"class\": \"btn-small btn-primary\",callback: function () { window.location.href = 'AdminManager.aspx?fun=" + Master.fun + "';}}]);</script>");
                    }
                    #endregion
                }
                else
                {
                    #region 新增
                    entity             = new AdminEntity();
                    entity.User_Name   = this.txtLoginname.Value.Trim();
                    entity.TrueName    = this.txtTruename.Value.Trim();
                    entity.User_Pwd    = MD5.Encode(WebKeys.AdminPwdRandom, this.txtUserpwd.Value.Trim());
                    entity.User_Sex    = int.Parse(this.selsex.Value);
                    entity.User_Tel    = this.txtUser_Tel.Value.Trim();
                    entity.User_Mobile = this.txtUser_Mobile.Value.Trim();
                    entity.User_Mail   = this.txtUser_Mail.Value.Trim();
                    entity.User_DeptID = int.Parse(this.selDepartMent.Value);

                    entity.IsValid      = false;
                    entity.RegisterDate = DateTime.Now;

                    isSuccess = bllSysuser.Insert(entity);

                    if (isSuccess)
                    {
                        Page.ClientScript.RegisterStartupScript(this.GetType(), "adminEdit", "<script>bootbox.dialog(\"添加成功!\", [{\"label\": \"OK\",\"class\": \"btn-small btn-primary\",callback: function () {window.location.href = 'AdminManager.aspx?fun=" + Master.fun + "';}}]);</script>");
                    }
                    else
                    {
                        Page.ClientScript.RegisterStartupScript(this.GetType(), "adminEdit", "<script>bootbox.alert(\"添加失败\");</script>");
                    }
                    #endregion
                }
            }
            else
            {
                Page.ClientScript.RegisterStartupScript(this.GetType(), "adminEdit", "<script>bootbox.alert(\"请检查必填项或数据格式是否正确\");</script>");
            }
        }
        public ActionResult ToExcel()
        {
            PageInfo pageInfo = new Git.Framework.DataTypes.PageInfo()
            {
                PageIndex = 1, PageSize = Int32.MaxValue
            };
            string        userCode  = WebUtil.GetFormValue <string>("userCode", string.Empty);
            string        userName  = WebUtil.GetFormValue <string>("userName", string.Empty);
            string        roleNum   = WebUtil.GetFormValue <string>("roleNum", string.Empty);
            string        departNum = WebUtil.GetFormValue <string>("departNum", string.Empty);
            AdminProvider provider  = new AdminProvider();
            AdminEntity   entity    = new AdminEntity();

            if (!userCode.IsEmpty())
            {
                entity.Where("UserCode", ECondition.Like, userCode + "%");
            }
            if (!userName.IsEmpty())
            {
                entity.Where("UserName", ECondition.Like, userName + "%");
            }
            if (!roleNum.IsEmpty())
            {
                entity.And(a => a.RoleNum == roleNum);
            }
            if (!departNum.IsEmpty())
            {
                entity.And(a => a.DepartNum == departNum);
            }
            List <AdminEntity> listResult = provider.GetList(entity, ref pageInfo);

            if (!listResult.IsNullOrEmpty())
            {
                DataTable dt = new DataTable();
                dt.Columns.Add(new DataColumn("用户名"));
                dt.Columns.Add(new DataColumn("编号"));
                dt.Columns.Add(new DataColumn("真名"));
                dt.Columns.Add(new DataColumn("Email"));
                dt.Columns.Add(new DataColumn("联系方式"));
                dt.Columns.Add(new DataColumn("登录次数"));
                dt.Columns.Add(new DataColumn("部门"));
                dt.Columns.Add(new DataColumn("角色"));
                foreach (AdminEntity t in listResult)
                {
                    DataRow row = dt.NewRow();
                    row[0] = t.UserName;
                    row[1] = t.UserCode;
                    row[2] = t.RealName;
                    row[3] = t.Email;
                    row[4] = t.Mobile;
                    row[5] = t.LoginCount;
                    row[6] = t.DepartName;
                    row[7] = t.RoleName;
                    dt.Rows.Add(row);
                }
                string filePath = Server.MapPath("~/UploadFiles/");
                if (!System.IO.Directory.Exists(filePath))
                {
                    System.IO.Directory.CreateDirectory(filePath);
                }
                string    filename = string.Format("员工管理{0}.xls", DateTime.Now.ToString("yyyyMMddHHmmss"));
                NPOIExcel excel    = new NPOIExcel("员工管理", "员工", System.IO.Path.Combine(filePath, filename));
                excel.ToExcel(dt);
                this.ReturnJson.AddProperty("Path", ("/UploadFiles/" + filename).Escape());
            }
            else
            {
                this.ReturnJson.AddProperty("d", "无数据导出!");
            }
            return(Content(this.ReturnJson.ToString()));
        }