ShuangHui_API/codegit/CallCenterApi/CallCenterAp.../CallCenterAp.../Controllers/UserAccountC...

using CallCenter.Utility;
using CallCenterApi.Common;
using CallCenterApi.DB;
using CallCenterApi.Interface.Controllers.Base;
using CallCenterApi.Interface.Models.Filter;
using CallCenterApi.Interface.Models.Input;
using System;
using System.Collections.Generic;
using System.Data;
using System.Linq;
using System.Web;
using System.Web.Mvc;

namespace CallCenterApi.Interface.Controllers
{
    [Authority]
    public class UserAccountController : BaseController
    {
        private BLL.T_Sys_UserAccount sysUserAccountBll = new BLL.T_Sys_UserAccount();
        private BLL.T_Sys_Department departmentBLL = new BLL.T_Sys_Department();
        private BLL.T_Sys_DictionaryValue dicValueBLL = new BLL.T_Sys_DictionaryValue();
        public ActionResult GetMaillist()
        {
            if (Request.IsAuthenticated)
            {
                int userId = CurrentUser.UserData.F_UserId;
                Model.T_Sys_UserAccount userModel = new BLL.T_Sys_UserAccount().GetModel(userId);

                DataTable dt = new DataTable();
                string sql = " ";
                int  dptid = 0;
                if (userModel != null)
                {
                    if (userModel.F_RoleId == 51 || userModel.F_RoleId == 52)
                        dptid = userModel.F_DeptId;
                }
                Model.T_Sys_Department deptModel = new BLL.T_Sys_Department().GetModel(dptid);
                if (deptModel != null)
                {
                    sql += " and F_DeptId in ( select F_DeptId from T_Sys_Department where F_DeptCode like '" + deptModel.F_DeptCode + "%') ";
                }
               
              var modelList=new  BLL.UserAccount().GetModelList(sql);

              
                var obj = new
                {
                    rows = modelList.Select(x => new
                    {
                        F_UserId = x.F_UserId,
                        F_UserCode = x.F_UserCode,
                        F_ExtensionNumber = x.F_ExtensionNumber,
                        F_UserName = x.F_UserName,
                        F_GroupName = x.F_GroupName,
                        F_DeptId = x.F_DeptId,
                        F_RoleId = x.F_RoleId,
                        F_GroupId = x.F_GroupId,
                        F_SeatFlag = x.F_SeatFlag,
                        F_SeatRight = x.F_SeatRight,
                        F_SeatLevel = x.F_SeatLevel,
                        F_SexFlag = x.F_SexFlag,
                        F_RemindFlag = x.F_RemindFlag,
                        F_Remark = x.F_Remark,
                        F_Telephone = x.F_Telephone,
                        F_Mobile = x.F_Mobile,
                        F_HomePhone = x.F_HomePhone,
                        F_Birthday = x.F_Birthday,
                        F_CreateOn = x.F_CreateOn,
                        F_CancelOn = x.F_CancelOn,
                        F_DeleteFlag = x.F_DeleteFlag,
                        F_APPOnFlag = x.F_APPOnFlag,
                        F_LastActiveTime = x.F_LastActiveTime,
                        F_See = x.F_See,
                        F_HJType = x.F_HJType,
                        F_PId = x.F_PId,
                        F_TmId = x.F_TmId,
                        F_RoleName = x.F_RoleName,
                        F_DeptName = x.F_DeptName,
                        F_WorkNumber = x.F_WorkNumber,
                        F_Post = x.F_Post,
                        //F_WXNo=x.F_WXNo,
                        F_SeatGroup = x.F_SeartGroup
                    }),
                    total = modelList.Count 
                };

                dt.Clear();
                dt.Dispose();
                return Content(obj.ToJson());
            }
            return NoToken("未知错误，请重新登录");
        
    }
        //[Authority]
        //用户列表
        public ActionResult GetList(FilterUserAccount filter)
        {
            if (Request.IsAuthenticated)
            {
                int userId = CurrentUser.UserData.F_UserId;
                Model.T_Sys_UserAccount userModel = new BLL.T_Sys_UserAccount().GetModel(userId);

                DataTable dt = new DataTable();
                string sql = " ";

                //if (userModel.F_SeartGroupID != 0)
                //{
                //    sql += " and F_SeartGroupID = '" + userModel.F_SeartGroupID + "' ";
                //}
                if (userModel != null)
                {
                    if (userModel.F_RoleId == 51|| userModel.F_RoleId == 52)
                        filter.dptid= userModel.F_DeptId;
                }
                if (filter.dptid > 0)
                {
                    Model.T_Sys_Department deptModel = new BLL.T_Sys_Department().GetModel(filter.dptid);
                    if (deptModel != null)
                    {
                        sql += " and F_DeptId in ( select F_DeptId from T_Sys_Department where F_DeptCode like '%" + deptModel.F_DeptCode + "%') ";
                    }
                }
                if (!string.IsNullOrWhiteSpace(filter.Key))
                {
                    sql = "";
                    string str = string.Format(" and (F_UserCode like '%{0}%' or F_UserName like '%{1}%')", filter.Key, filter.Key);
                    sql += str;
                }
                if (filter .type ==1)
                {
                    sql += "and F_RoleId=52";
                }
                if (filter.type == 2)
                {
                    sql += "and F_RoleId=53";
                }
                sql += "and F_See!='5'";
                int recordCount = 0;
                dt = BLL.PagerBLL.GetListPager(
                                        "T_Sys_UserAccount",
                                        "F_UserId",
                                        "*",
                                        sql,
                                        "ORDER BY F_UserId desc",
                                        filter.PageSize,
                                        filter.PageIndex,
                                        true,
                                        out recordCount);

                List<Model.UserAccount> modelList = new BLL.UserAccount().DataTableToList(dt);
                var obj = new
                {
                    rows = modelList.Select(x => new
                    {
                        F_UserId = x.F_UserId,
                        F_UserCode = x.F_UserCode,
                        F_ExtensionNumber = x.F_ExtensionNumber,
                        F_UserName = x.F_UserName,
                        F_GroupName = x.F_GroupName,
                        F_DeptId = x.F_DeptId,
                        F_RoleId = x.F_RoleId,
                        F_GroupId = x.F_GroupId,
                        F_SeatFlag = x.F_SeatFlag,
                        F_SeatRight = x.F_SeatRight,
                        F_SeatLevel = x.F_SeatLevel,
                        F_SexFlag = x.F_SexFlag,
                        F_RemindFlag = x.F_RemindFlag,
                        F_Remark = x.F_Remark,
                        F_Telephone = x.F_Telephone,
                        F_Mobile = x.F_Mobile,
                        F_HomePhone = x.F_HomePhone,
                        F_Birthday = x.F_Birthday,
                        F_CreateOn = x.F_CreateOn,
                        F_CancelOn = x.F_CancelOn,
                        F_DeleteFlag = x.F_DeleteFlag,
                        F_APPOnFlag = x.F_APPOnFlag,
                        F_LastActiveTime = x.F_LastActiveTime,
                        F_See = x.F_See,
                        F_HJType = x.F_HJType,
                        F_PId = x.F_PId,
                        F_TmId = x.F_TmId,
                        F_RoleName = x.F_RoleName,
                        F_DeptName = x.F_DeptName,
                        F_WorkNumber = x.F_WorkNumber,
                        F_Post = x.F_Post,
                        //F_WXNo=x.F_WXNo,
                        F_SeatGroup = x.F_SeartGroup
                    }),
                    total = recordCount
                };

                dt.Clear();
                dt.Dispose();
                return Content(obj.ToJson());
           //   return ;
            }
            return NoToken("未知错误，请重新登录");
        }
        //[Authority]
        //获取用户信息
        public ActionResult GetUser(int userId = 0, string userCode = "")
        {
            if (Request.IsAuthenticated)
            {
                string sql = "";
                if (userId > 0)
                {
                    sql += " and F_UserId=" + userId;
                }
                if (!string.IsNullOrWhiteSpace(userCode))
                {
                    sql += " and F_UserCode=" + userCode;
                }
                if (string.IsNullOrWhiteSpace(sql))
                    return Error("获取失败");

                Model.T_Sys_UserAccount userModel = sysUserAccountBll.GetModelList(" 1=1 " + sql).FirstOrDefault();
                if (userModel == null) return Error("获取失败");
                var depModel = departmentBLL.GetModel(userModel.F_DeptId);
                var zxzModel = dicValueBLL.GetModel(userModel.F_GroupId ?? 0);
                return Success("获取成功", new
                {
                    F_UserId = userModel.F_UserId,
                    F_UserCode = userModel.F_UserCode,
                    F_ExtensionNumber = userModel.F_ExtensionNumber,
                    F_UserName = userModel.F_UserName,
                    F_DeptId = userModel.F_DeptId,
                    F_RoleId = userModel.F_RoleId,
                    F_GroupId = userModel.F_GroupId,
                    F_SeatFlag = userModel.F_SeatFlag,
                    F_SeatRight = userModel.F_SeatRight,
                    F_SeatLevel = userModel.F_SeatLevel,
                    F_SexFlag = userModel.F_SexFlag,
                    F_RemindFlag = userModel.F_RemindFlag,
                    F_Remark = userModel.F_Remark,
                    F_Telephone = userModel.F_Telephone,
                    F_Mobile = userModel.F_Mobile,
                    F_HomePhone = userModel.F_HomePhone,
                    F_Birthday = (userModel.F_Birthday != null ? userModel.F_Birthday.Value.ToString("yyyy-MM-dd") : ""),
                    F_CreateOn = userModel.F_CreateOn,
                    F_CancelOn = userModel.F_CancelOn,
                    F_DeleteFlag = userModel.F_DeleteFlag,
                    F_APPOnFlag = userModel.F_APPOnFlag,
                    F_LastActiveTime = userModel.F_LastActiveTime,
                    F_See = userModel.F_See,
                    F_HJType = userModel.F_HJType ?? 0,
                    F_PId = userModel.F_PId,
                    F_TmId = userModel.F_TmId,
                    F_WorkNumber = userModel.F_WorkNumber,
                    F_Post = userModel.F_Post ,
                    //F_WXNo = userModel.F_WXNo,
                    F_SeatGroup = userModel.F_SeartGroup,
                    zxzname = zxzModel?.F_Name ?? "",
                    depname = depModel?.F_DeptName ?? ""
                });
            }
            return NoToken("未知错误，请重新登录");
        }
        //[Authority]
        //添加用户信息
        public ActionResult AddUsers(UserAccountInput input)
        {
            if (Request.IsAuthenticated)
            {

                Model.T_Sys_UserAccount userAccountModel = new Model.T_Sys_UserAccount();
                //员工工号不能重复
                string ucode = input.Usercode.Trim();
                if (!string.IsNullOrEmpty(ucode))
                {
                    Model.T_Sys_UserAccount uModel = new BLL.T_Sys_UserAccount().GetModel(ucode);
                    if (uModel != null)
                    {
                        return Error("不能重复添加工号");
                    }
                    else
                    {
                        userAccountModel.F_UserCode = ucode;
                        userAccountModel.F_WorkNumber = ucode;
                    }
                }
                if (input.Username != null)
                    userAccountModel.F_UserName = input.Username.Trim();
                if (input.Password != null)
                    userAccountModel.F_Password = input.Password.Trim();
                if (input.Extno != null)
                    userAccountModel.F_ExtensionNumber = input.Extno.Trim();
                if (input.DeptId != 0)
                    userAccountModel.F_DeptId = input.DeptId;
                if (input.Pid  != 0)
                    userAccountModel.F_PId  = input.Pid;
                if (input.RoleId != 0)
                {
                    userAccountModel.F_RoleId = input.RoleId;
                    if (input.RoleId==17|| input.RoleId == 50|| input.RoleId == 49)
                    {
                        userAccountModel.F_See = "0";
                    }
                    else if (input.RoleId == 1 || input.RoleId ==4)
                    {
                        userAccountModel.F_See = "1";
                    }
                    else if (input.RoleId == 51 || input.RoleId == 52 || input.RoleId == 55 || input.RoleId == 56)
                    {
                        userAccountModel.F_See = "2";
                    }
                    else if (input.RoleId ==53 || input.RoleId == 57|| input.RoleId ==58|| input.RoleId == 59 || input.RoleId == 60)
                    {
                        userAccountModel.F_See = "3";
                    }
                }
                    
               
                //if (input.GroupId != 0)
                //    userAccountModel.F_GroupId = input.GroupId;
                if (input .Post!=null )
                    userAccountModel.F_Post  = input.Post;
                userAccountModel.F_SeatFlag = input.IsSeat;
                if (input.SearRight != null)
                    userAccountModel.F_SeatRight = input.SearRight;
                if (input.Sex != null)
                    userAccountModel.F_SexFlag = input.Sex;
                if (input.Remark != null)
                    userAccountModel.F_Remark = input.Remark;
                if (input.Mobile != null)
                    userAccountModel.F_Mobile = input.Mobile;
                if (input.Telphone != null)
                    userAccountModel.F_Telephone = input.Telphone;
                if (input.Birth != null)
                    userAccountModel.F_Birthday = input.Birth;
                userAccountModel.F_CreateOn = DateTime.Now;
                userAccountModel.F_DeleteFlag = 0;
                if (input.HjType != null)
                    userAccountModel.F_HJType = input.HjType;
                //if (input.IsSeat)
                //{
                //    userAccountModel.F_WXNo = input.WXNo.Trim();
                //}
                //if (input.SeartGroupID != 0)
                if (input.GroupId != 0)
                {
                    userAccountModel.F_SeartGroupID = input.GroupId;
                    Model.T_Sys_SeatGroup sm = new BLL.T_Sys_SeatGroup().GetModel(input.GroupId);
                    if (sm != null)
                    {
                        userAccountModel.F_SeartGroup = sm.F_ZXZName;
                    }
                }
                if (input.IsSeat)
                {
                    SysConfigController sys = new SysConfigController();
                    //话务人员限制权限判断
                    if (sys.IsValidSeatPermission())
                    {
                        var model = sysUserAccountBll.GetModel(int.Parse(input.Usercode));
                        if (model != null)
                            return Error("当前员工工号存在，请更换！");
                        if (sysUserAccountBll.Add(userAccountModel) > 0)
                            return Success("新增成功！");
                        else
                            return Error("新增失败！");
                    }
                    else
                    {
                        return Error("话务人员数量已超！");
                    }
                }
                else
                {
                    if (sysUserAccountBll.Add(userAccountModel) > 0)
                        return Success("新增成功！");
                    else
                        return Error("新增失败！");
                }
            }
            return NoToken("未知错误，请重新登录");
        }
        // [Authority]
        //修改用户信息
        public ActionResult EditUsers(UserAccountInput input)
        {
            if (Request.IsAuthenticated)
            {
                BLL.T_Sys_UserAccount sysUserAccountBll = new BLL.T_Sys_UserAccount();
                Model.T_Sys_UserAccount userAccountModel = sysUserAccountBll.GetModelList("  F_UserId = " + input.UserId).FirstOrDefault();
                if (userAccountModel == null)
                    return Error("获取用户失败");
                //员工工号不能重复
                string ucode = input.Usercode.Trim();
                if (!string.IsNullOrEmpty(ucode))
                {
                    var uModels = new BLL.T_Sys_UserAccount().GetModelList(" F_UserCode='" + ucode + "'");
                    if (uModels.Count() > 1)
                    {
                        return Error("不能重复添加工号");
                    }
                    else
                    {
                        userAccountModel.F_UserCode = ucode;
                        userAccountModel.F_WorkNumber = ucode;
                    }
                }
                if (input.Username != null)
                    userAccountModel.F_UserName = input.Username.Trim();
                if (input.Password != null)
                    userAccountModel.F_Password = input.Password.Trim();
                if (input.Extno != null)
                    userAccountModel.F_ExtensionNumber = input.Extno.Trim();
                //if (input.WXNo != null)
                //    userAccountModel.F_WXNo = input.WXNo.Trim();
                if (input.DeptId != 0)
                    userAccountModel.F_DeptId = input.DeptId;
                if (input.RoleId != 0)
                {
                    userAccountModel.F_RoleId = input.RoleId;
                    if (input.RoleId == 17 || input.RoleId == 50 || input.RoleId == 49)
                    {
                        userAccountModel.F_See = "0";
                    }
                    else if (input.RoleId == 1 || input.RoleId == 4)
                    {
                        userAccountModel.F_See = "1";
                    }
                    else if (input.RoleId == 51 || input.RoleId == 52 || input.RoleId == 55 || input.RoleId == 56)
                    {
                        userAccountModel.F_See = "2";
                    }
                    else if (input.RoleId == 53 || input.RoleId == 57 || input.RoleId == 58 || input.RoleId == 59 || input.RoleId == 60)
                    {
                        userAccountModel.F_See = "3";
                    }
                }
                   if (input.Pid!=0)
                    userAccountModel.F_PId  = input.Pid;
                //if (input.GroupId != 0)
                //    userAccountModel.F_GroupId = input.GroupId;
               
                    if (userAccountModel.F_RoleId==4|| userAccountModel.F_RoleId == 17 || userAccountModel.F_RoleId == 1)
                    userAccountModel.F_SeatFlag = true ;
                else 
                    userAccountModel.F_SeatFlag = input.IsSeat;
                
                if (input.SearRight != null)
                    userAccountModel.F_SeatRight = input.SearRight;
                if (input.Post != null)
                    userAccountModel.F_Post = input.Post;
                if (input.Sex != null)
                    userAccountModel.F_SexFlag = input.Sex;
                if (input.Remark != null)
                    userAccountModel.F_Remark = input.Remark;
                if (input.Mobile != null)
                    userAccountModel.F_Mobile = input.Mobile;
                if (input.Telphone != null)
                    userAccountModel.F_Telephone = input.Telphone;
                if (input.Birth != null)
                    userAccountModel.F_Birthday = input.Birth;
                //userAccountModel.F_CreateOn = DateTime.Now;

                //if (input.SeartGroupID != 0)
                if (input.GroupId != 0)
                {
                    userAccountModel.F_SeartGroupID = input.GroupId;
                    Model.T_Sys_SeatGroup sm = new BLL.T_Sys_SeatGroup().GetModel(input.GroupId);
                    if (sm != null)
                    {
                        userAccountModel.F_SeartGroup = sm.F_ZXZName;
                    }
                }

                userAccountModel.F_DeleteFlag = 0;
                if (input.HjType != null)
                    userAccountModel.F_HJType = input.HjType;

                if (input.IsSeat)
                {
                    SysConfigController sys = new SysConfigController();
                    //话务人员限制权限判断
                    if (sys.IsValidSeatPermission())
                    {
                        if (sysUserAccountBll.Update(userAccountModel))
                            return Success("编辑成功！");
                        else
                            return Error("编辑失败！");
                    }
                    else
                    {
                        return Error("话务人员数量已超！");
                    }
                }
                else
                {
                    if (sysUserAccountBll.Update(userAccountModel))
                        return Success("编辑成功！");
                    else
                        return Error("编辑失败！");
                }
            }
            return NoToken("未知错误，请重新登录");
        }
        //[Authority]
        //删除/禁用/启用 用户
        [Authority]
        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("请选择用户");

            SysConfigController sys = new SysConfigController();
            if (state == 0)
            {
                //话务人员限制权限判断
                if (sys.IsValidSeatPermission())
                {
                    if (sysUserAccountBll.DeleteList(idStr, state))
                        return Success("设置成功");
                    else
                        return Error("设置失败");
                }
                return Error("话务人员数量已超！");
            }
            if (sysUserAccountBll.DeleteList(idStr, state))
                return Success("设置成功");
            else
                return Error("设置失败");
        }

        //[Authority]
        //删除用户
        public ActionResult DeleteUsers(string[] ids)
        {
            if (Request.IsAuthenticated)
            {
                if (ids == null || ids.Length <= 0)
                    return Error("请选择用户");
                var idStr = string.Join(",", ids);
                if (string.IsNullOrEmpty(idStr))
                    return Error("请选择用户");
                if (sysUserAccountBll.DeleteList(idStr))
                    return Success("删除成功");
                else
                    return Error("删除失败");
            }
            return NoToken("未知错误，请重新登录");
        }

        //获取坐席列表
        public ActionResult GetSeatList()
        {
            if (Request.IsAuthenticated)
            {

                int userId = CurrentUser.UserData.F_UserId;
                Model.T_Sys_UserAccount userModel = new BLL.T_Sys_UserAccount().GetModel(userId);

                string sql = " f_seatflag=1 ";
                int roleid = CurrentUser.UserData.F_RoleId;
                int deptid = CurrentUser.UserData.F_DeptId;
                if (roleid != 0)
                {
                    if (roleid != 17)
                    {
                        if (deptid != 0)
                            sql += " and F_DeptId=" + deptid;
                    }
                }

                if (userModel.F_SeartGroupID != 0)
                {
                    sql += " and F_SeartGroupID = '" + userModel.F_SeartGroupID + "' ";
                }

                List<Model.T_Sys_UserAccount> userSeartList = sysUserAccountBll.GetModelList(sql + " order by f_userid desc ");
                if (userSeartList.Count > 0)
                    return Success("列表加载成功", userSeartList);
                else
                    return Error("列表加载失败");
            }
            return NoToken("未知错误，请重新登录");
        }

        //根据部门获取用户
        public ActionResult GetDeptUserList(int deptid = 0)
        {
            if (Request.IsAuthenticated)
            {
                List<Model.T_Sys_UserAccount> DeptUserList = sysUserAccountBll.GetModelList("F_DeptId='" + deptid + "' order by f_userid desc ");
                return Success("列表加载成功", DeptUserList);
            }
            return NoToken("未知错误，请重新登录");
        }
        public DataTable GetFileData(string ids, string prefix)
        {
            DataTable dt = new DataTable();
            if (!string.IsNullOrEmpty(ids))
            {
                dt = DbHelperSQL.Query("select * from T_Sys_Accessories where F_Id in (" + ids + ")").Tables[0];
                foreach (DataRow dr in dt.Rows)
                {
                    dr["F_Url"] = prefix + dr["F_Url"].ToString();
                }
            }
            return dt;
        }
        //获取当前用户信息
        public ActionResult GetNowUser()
        {
            if (Request.IsAuthenticated)
            {
            string display = Configs.GetValue("display");
                Model.T_Sys_UserAccount userModel = new BLL.T_Sys_UserAccount().GetModel(CurrentUser.UserData.F_UserId);
              if (userModel == null)
                    return Error("获取失败");
                var configfj = new BLL.T_Sys_SystemConfig().GetModelList(" F_ParamCode='FileUrlPath' ").FirstOrDefault();
                Model.T_Sys_RoleInfo roleModel = new BLL.T_Sys_RoleInfo().GetModel(userModel.F_RoleId);
             var  FileUrl = GetFileData(userModel.F_PId.ToString () , configfj.F_ParamValue);
                var obj = new
                {
                    user = userModel,
                    role = roleModel,
                    FileUrl = FileUrl,
                    display= display
                };
                return Success("获取成功", obj);
            }
            return NoToken("未知错误，请重新登录");
        }
        // [Authority]
        /// <summary>
        /// 重置密码
        /// </summary>
        /// <param name="usercode"></param>
        /// <param name="pwd"></param>
        /// <returns></returns>
        public ActionResult ResetPwd(string usercode = "", string pwd = "")
        {
            if (Request.IsAuthenticated)
            {
                if (string.IsNullOrWhiteSpace(pwd))
                    return Error("请输入密码");
                var model = sysUserAccountBll.GetModel(usercode);
                if (model == null) return Error("此用户不存在");
                model.F_Password = pwd;
                if (sysUserAccountBll.Update(model))
                    return Success("重置密码成功");
                else
                    return Error("重置密码失败");
            }
            return NoToken("未知错误，请重新登录");
        }

        public ActionResult UpdatePwd(string usercode = "", string pwd = "", string oldPwd = "", string mobile = "")
        {
            if (Request.IsAuthenticated)
            {
                if (string.IsNullOrWhiteSpace(pwd))
                    return Error("请输入密码");
                if (string.IsNullOrWhiteSpace(usercode))
                    return Error("账号错误");
                var model = sysUserAccountBll.GetModel(int.Parse(usercode));
                if (model == null) return Error("此用户不存在");
                if (!model.F_Password.Equals(oldPwd)) return Error("原密码不正确");
                model.F_Password = pwd;
                if (!string.IsNullOrWhiteSpace(mobile))
                    model.F_Mobile = mobile;
                if (sysUserAccountBll.Update(model))
                    return Success("重置密码成功");
                else
                    return Error("重置密码失败");
            }
            return NoToken("未知错误，请重新登录");
        }

    }
}