RMYY_CallCenter_Api/RMYY_CallCen.../Controllers/System/UserAccountC...

using RMYY_CallCenter_Api.Utility;
using System;
using System.Collections.Generic;
using System.Data;
using System.Linq;
using System.Web;
using System.Web.Mvc;

namespace RMYY_CallCenter_Api.Controllers.System
{
    public class UserAccountController : BaseController
    {

        private Bll.T_Sys_UserAccount userbll = new Bll.T_Sys_UserAccount();
        // GET: UserAccount

        /// <summary>
        /// 获取分页列表
        /// </summary>
        /// <returns></returns>
        [HttpPost]
        public ActionResult GetList(string key, int roleid = 0, int deptid = 0, int page = 1, int pagesize = 10)
        {
            DataTable dt = new DataTable();
            string sql = string.Empty;

            if (deptid > 0)
            {
                sql += " and F_DeptId='" + deptid + "'";
            }
            if (roleid > 0)
            {
                sql += " and F_RoleId='" + roleid + "'";
            }

            if (!string.IsNullOrWhiteSpace(key))
            {
                sql += " and (F_UserCode like '%"+ key + "%' or F_UserName like '%"+ key + "%')";
            }

            int recordCount = 0;
            dt = Bll.PagerBll.GetListPager(
                                    "T_Sys_UserAccount a with(nolock)",
                                    "F_UserId",
                                    "*,(select F_DeptName from T_Sys_Department  where F_DeptId=a.F_DeptId)as F_DeptName,(select F_RoleName from T_Sys_Role where F_RoleId=a.F_RoleId)as F_RoleName,(select F_ZXZName from T_Sys_SeatGroup  where F_ID=a.F_SeatGroup)as F_SeatGroupName",
                                    sql,
                                    "ORDER BY F_UserId desc",
                                    pagesize,
                                    page,
                                    true,
                                    out recordCount);
            var obj = new
            {
                state = "success",
                rows = dt,
                total = recordCount
            };

            return Content(obj.ToJson());
        }

        /// <summary>
        /// 获取用户信息
        /// </summary>
        /// <param name="userId"></param>
        /// <param name="userCode"></param>
        /// <returns></returns>
        public ActionResult GetModel(int userid = 0, string usercode = "")
        {
            string sql = " 1=1 ";        
            if (userid > 0)
            {
                sql += " and F_UserId=" + userid;
            }
            if (!string.IsNullOrWhiteSpace(usercode))
            {
                sql += " and F_UserCode='" + usercode + "'";
            }
            if (string.IsNullOrEmpty(usercode)&& userid==0)
                return Error("获取失败");

            Model.T_Sys_UserAccount ua = new Bll.T_Sys_UserAccount().GetModelList(sql).FirstOrDefault();
            if (ua != null)
            {
              var dptmodel = new Bll.T_Sys_Department().GetModel(ua.F_DeptId);
              ua.F_DeptName = dptmodel.F_DeptName;
              ua.deptype = new Bll.T_Sys_Department().GetDeplayer(ua.F_DeptId);
            }
            if (ua == null)
                return Error("不存在此用户信息！");
            return Success("获取成功", ua);
        }
        /// <summary>
        /// 获取所有的人员信息
        /// </summary>
        /// <returns></returns>
        public ActionResult GetModelalllist()
        {
            var sql = "";
            List<Model.T_Sys_UserAccount> ualist = new Bll.T_Sys_UserAccount().GetModelList(sql);
           
            return Success("获取成功", ualist);
        }

        // [Authority]
        //修改用户信息
        public ActionResult EditUsers(int userid, string Usercode, string Username, string Password, int DeptId, int RoleId, int IsSeat, int? SeatGroup, string Remark, string Phon, string sex, string companyphone, string address, string job, string Extno = "")
        {
            var umodel = userbll.GetModelList("  F_UserId = " + userid).FirstOrDefault();
            if (umodel == null)
                return Error("获取用户失败");

            if (userbll.GetRecordCount(" F_UserCode='" + Usercode.Trim() + "' and F_UserId != " + userid) > 0)
            {
                return Error("已存在此工号，请重新输入！");
            }
            umodel.F_UserCode = Usercode.Trim();
            umodel.F_UserName = Username.Trim();
            umodel.F_ExtensionNumber = Extno.Trim();
            umodel.F_DeptId = DeptId;
            umodel.F_RoleId = RoleId;
            umodel.F_SeatGroup = SeatGroup;
            if (SeatGroup > 0)
            {
                umodel.F_SeatFlag = 1;
            }
            else
                umodel.F_SeatFlag = 0;
            umodel.F_Remark = Remark;
            umodel.F_Telephone = Phon;
            umodel.F_Sex = sex;
            umodel.F_WorkPhone = companyphone;
            umodel.F_HomeAddress = address;
            umodel.F_Job = job;
            if (userbll.Update(umodel))
                return Success("编辑成功！");
            else
                return Error("编辑失败！");
        }

        //[Authority]
        //添加用户信息
        public ActionResult AddUsers(string Usercode, string Username, string Password, int DeptId, int RoleId,int? SeatGroup, string Remark, string Phon, string sex, string companyphone,string address,string job, string Extno = "")
        {
            if (userbll.GetRecordCount(" F_UserCode='" + Usercode.Trim() + "' ") > 0)
            {
                return Error("已存在此工号，请重新输入！");
            }

            Model.T_Sys_UserAccount ua = new Model.T_Sys_UserAccount();

            ua.F_UserCode = Usercode.Trim();
            ua.F_UserName = Username.Trim();
            ua.F_Password = Password.Trim();
            ua.F_ExtensionNumber = Extno.Trim();
            ua.F_DeptId = DeptId;
            ua.F_RoleId = RoleId;
            ua.F_SeatGroup = SeatGroup;
            if (SeatGroup > 0)
            {
                ua.F_SeatFlag = 1;
            }
            else
                ua.F_SeatFlag = 0;
            ua.F_Remark = Remark;
            ua.F_Telephone = Phon;
            ua.F_Sex = sex;
            ua.F_CreateUser = User.F_UserCode;
            ua.F_CreateTime = DateTime.Now;
            ua.F_WorkPhone = companyphone;
            ua.F_HomeAddress = address;
            ua.F_Job = job;
            ua.F_DeleteFlag = 0;
            if (new Bll.T_Sys_UserAccount().Add(ua) > 0)
                return Success("新增成功！");
            else
                return Error("新增失败！");
        }

      
        //[Authority]
        //删除用户
        public ActionResult DeleteUsers(string[] ids)
        {
           if(User!=null)
            {
                if (ids == null || ids.Length <= 0)
                    return Error("请选择用户");
                var idStr = string.Join(",", ids);
                if (string.IsNullOrEmpty(idStr))
                    return Error("请选择用户");
                if (userbll.DeleteList(idStr))
                    return  Success("删除成功");
                else
                    return Error("删除失败");
            }
            return Error("请重新登陆！");
        }

        /// <summary>
        /// 重置密码
        /// </summary>
        /// <param name="usercode"></param>
        /// <param name="pwd"></param>
        /// <returns></returns>
        public ActionResult ResetPwd(string usercode = "", string pwd = "")
        {
            if (User!=null)
            {
                if (string.IsNullOrEmpty(pwd))
                    return Error("请输入密码");
                var model = userbll.GetModel(usercode);
                if (model == null) return Error("此用户不存在");
                model.F_Password = pwd;
                if (userbll.Update(model))
                    return Success("重置密码成功");
                else
                    return Error("重置密码失败");
            }
            return Error("未知错误，请重新登录");
        }



        /// <summary>
        /// 获取坐席列表
        /// </summary>
        /// <returns></returns>
        public ActionResult GetGroupseatList()
        {
            if (User!=null)
            {
                DataTable dt = new DataTable();
                int deptid = User.F_DeptId;
                int roleid = User.F_RoleId;

                string sql = "";
                //if (roleid != 17)
                //{
                //    sql = " and F_DeptId=" + deptid;
                //}

                dt = userbll.GetList(" f_seatflag=1 and F_DeleteFlag=0 " + sql + " order by f_userid desc ").Tables[0];

                if (dt.Rows.Count > 0)
                {
                   return  Success("坐席列表加载成功", dt);
                }
                else
                {
                   return Error("坐席列表加载失败");
                }
            }
            return Error("未知错误，请重新登陆");
        }

        /// <summary>
        /// 启用  state = 0和禁用  state = 1 用户 
        /// </summary>
        /// <param name="ids"></param>
        /// <param name="state"></param>
        /// <returns></returns>
        public ActionResult DelUsers(string[] ids, int state = 0)
        {
            if (ids == null || ids.Length <= 0)
                return Error("请选择用户");
            var idStr = string.Join(",", ids);
            if (string.IsNullOrEmpty(idStr))
                return Error("请选择用户");

          
            //话务人员限制权限判断
            if (state == 0)
            {                 
                    if (userbll.DeleteFlagList(idStr, state))
                        return Success("设置成功");
                    else
                        return Error("设置失败");
                 
            }
            if (userbll.DeleteFlagList(idStr, state))
                return Success("设置成功");
            else
                return Error("设置失败");
        }

    }
}