SYCW_API/codegit/CallCenterApi/CallCenterAp.../CallCenterAp.../Controllers/MageCus/MageCusContr...

using CallCenterApi.DB;
using CallCenterApi.Interface.Controllers.Base;
using CallCenterApi.Interface.Models.Input;
using CallCenterApi.Model;
using System;
using System.Collections.Generic;
using System.Data;
using System.Linq;
using System.Web;
using System.Web.Mvc;

namespace CallCenterApi.Interface.Controllers.MageCus
{
    public class MageCusController : BaseController
    {
        BLL.ManagementUser muserbll = new BLL.ManagementUser();
        BLL.T_Cus_CustomerBaseNew customnew = new BLL.T_Cus_CustomerBaseNew();
        /// <summary>
        /// 分页显示管理员账号信息
        /// </summary>
        /// <param name="PageIndex"></param>
        /// <param name="PageSize"></param>
        /// <param name="username"></param>
        /// <returns></returns>
        public ActionResult GetManagementcus(int PageIndex, int PageSize, string username)
        {
            #region 分页显示管理员账号信息
            if (PageIndex == 0)
            {
                PageIndex = 1;
            }
            if (PageSize == 0)
            {
                PageSize = 10;
            }
            var sql = "";
            ///按名称模糊查询
            if (username != null)
            {
                if (username != "")
                {
                    sql += "  and username like '%" + username + "%' ";
                }

            }
            Model.PageData<Model.ManagementUser> pageModel = new Model.PageData<Model.ManagementUser>();
            var recordCount = 0;
            var dt = BLL.PagerBLL.GetListPager(
                 "ManagementUser",
                 "ManagementUser.id",
                 "*",
                 sql,
                 "ORDER BY ManagementUser.id desc ",
                 PageSize,
                 PageIndex,
                 true,
                 out recordCount);
            List<Model.ManagementUser> modelList = new BLL.ManagementUser().DataTableToList(dt);
            var list = new List<Model.ManagementUser>();
            foreach (var item in modelList)
            {
                list.Add(new Model.ManagementUser
                {
                    id = item.id,
                    username = item.username,
                    userpower = item.userpower,
                    handdate = item.handdate,
                    handleper = item.handleper,
                    ifdeler = item.ifdeler,
                    openid = item.openid
                });
            }
            var obj = new
            {
                rows = list,
                total = recordCount
            };
            return Success("成功", obj);
            #endregion
        }
        /// <summary>
        /// 登陆
        /// </summary>
        /// <param name="username"></param>
        /// <param name="userpower"></param>
        /// <param name="openid"></param>
        /// <returns></returns>
        public ActionResult Login(string username, string userpower, string openid)
        {
            #region 把其他OpenId更新为空
            var userAccount = muserbll.GetModelByOpenid(openid);
            if (userAccount != null)
            {
                userAccount.openid = "";
                muserbll.Update(userAccount);
            }
            #endregion
            
            Dictionary<string, string> paras_Customer = new Dictionary<string, string>();
            string sql_Customer = " select * from ManagementUser (NOLOCK) where username=@username and userpower=@userpower  ";//and ifdeler = 0 
            paras_Customer.Add("@username", username);
            paras_Customer.Add("@userpower", userpower);
            var dt_Customer = DbHelperSQL.Query(sql_Customer, paras_Customer).Tables[0];

            if (dt_Customer != null && dt_Customer.Rows.Count > 0)
            {
                
                //var customer = customerBaseBLL.GetModel(login.UserCode);  //20180926 次方法查询有漏洞
                var customer = muserbll.DataTableToList(dt_Customer).ToList().FirstOrDefault();
                customer.openid = openid;
                if (customer.ifdeler == 0)
                {
                    #region 新加 - 登录后同时获取用户账号，openid，和角色
                    //5--业主（客户档案会员） 
                    //int UserType = 5;
                    var obj = new
                    {
                        openid = openid,
                        username = username,
                        userpower = userpower
                    };
                    #endregion
                    if (muserbll.Update(customer))
                        return Success("绑定成功！", obj);
                    else
                        return Error("绑定失败！");
                }
                else {
                    return Error("该账户被禁用！");
                }
            }
            return Error("账号或密码错误或者没有注册，请重新登录");
        }
        //[Authority]
        //添加用户信息
        public ActionResult AddUsers(ManagementUserInput input)
        {
            Model.ManagementUser ManagementUsertModel = new Model.ManagementUser();
            //用户名不能重复
            string username = input.username.Trim();
            //用户名与客户信息表编号也不能重复
            Model.T_Cus_CustomerBaseNew cusmodel = customnew.GetModelcuscode(username);
            if (cusmodel != null)
                return Error("客户名已存在");
            Model.ManagementUser uModel = new BLL.ManagementUser().GetModel(username);
            if (uModel != null)
            {
                if (uModel.ifdeler == 0)
                {
                    return Error("该用户名已存在");
                }
                else {
                    return Error("该账户被禁用");
                }
            }
            else
            {
               ManagementUsertModel.username = username;
            }
            ManagementUsertModel.handleper = CurrentUser.UserData.F_UserCode;//  "000";//
            ManagementUsertModel.handdate = DateTime.Now;
            ManagementUsertModel.ifdeler = 0;
            if (input.userpower != null)
                    ManagementUsertModel.userpower = input.userpower.Trim();
              
            if (muserbll.Add(ManagementUsertModel) > 0)
                    return Success("新增成功！");
                else
                    return Error("新增失败！");
        
        }
        /// <summary>
        /// 获取详情
        /// </summary>
        /// <param name="id"></param>
        /// <returns></returns>
        public ActionResult GetModelarchives(int id)
        {
            var model = muserbll.GetModels(id);
            if (model == null)
                return Error("该信息不存在");
            //根据id获取过关联的客户信息
            var manacustomer = muserbll.GetManageCustomerModelList(" mangid="+id);
            string companyname = "";
            int a = 1;
            foreach (var item in manacustomer)
            {
                companyname += item.F_CompanyName;
                if (a < manacustomer.Count)

                {
                    companyname += ",";
                }
                a++;
            }
            var obj = new Model.ManagementUser
            {
                id = model.id,
                username = model.username,
                userpower = model.userpower,
                handdate = model.handdate,
                handleper = model.handleper,
                ifdeler = model.ifdeler,
                openid = model.openid,
                companyname = companyname
            };
            return Success("获取成功", obj);
        }
        //修改用户信息
        public ActionResult EditUsers(ManagementUserInput input)
        {
           
           Model.ManagementUser ManagementUsertModel = muserbll.GetModelList("  id = " + input.id).FirstOrDefault();
           if (ManagementUsertModel == null)
               return Error("获取用户失败");

            //用户名不能重复
            string username = input.username.Trim();

            //用户名与客户信息表编号也不能重复
            Model.T_Cus_CustomerBaseNew cusmodel = customnew.GetModelcuscode(username);
            if (cusmodel != null)
                return Error("客户名已存在");
            Model.ManagementUser uModel = new BLL.ManagementUser().GetModel(username);
            if (uModel != null)
            {
                if (uModel.id != input.id)
                {
                    if (uModel != null)
                    {
                        if (uModel.ifdeler == 0)
                        {
                            return Error("该用户名已存在");
                        }
                        else
                        {
                            return Error("该账户被禁用");
                        }
                    }
                    else
                    {
                        ManagementUsertModel.username = username;
                    }
                }
                else
                {
                    ManagementUsertModel.username = username;
                }
            }
            else {
                ManagementUsertModel.username = username;
            }
           

            ManagementUsertModel.handleper =  CurrentUser.UserData.F_UserCode;//;//"900";//
            ManagementUsertModel.handdate = DateTime.Now;
            ManagementUsertModel.ifdeler = 0;
            if (input.userpower != null)
                ManagementUsertModel.userpower = input.userpower.Trim();


            if (muserbll.Update(ManagementUsertModel))
                        return  Success("编辑成功！");
                    else
                        return  Error("编辑失败！");
               
            
        }
        //[Authority]
        //删除用户
        public ActionResult DeleteUsers(string ids)
        {
            
                if (ids == null || ids=="")
                    return Error("请选择用户");
                
                if (string.IsNullOrEmpty(ids))
                    return Error("请选择用户");
                if (muserbll.DeleteList(ids))
                    return Success("删除成功");
                else
                    return Error("删除失败");
         
        }
        /// <summary>
        /// 根据名称获取管理员信息
        /// </summary>
        /// <param name="username"></param>
        /// <returns></returns>
        public ActionResult GetModelManageuser(string username)
        {

            string sql = "";
            var list = new List<Model.ManagementUser>();
            if (username == null || username == "")
            {
                sql += " ifdeler=0";

            }
            else
            {
                sql += " ifdeler=0 ";
                sql += $" and username like '%" + username.Trim() + "%'";
            }
            if (!string.IsNullOrWhiteSpace(sql))
            {
                list = muserbll.GetModelList(sql);
            }
          
            if (list.Count > 0)
                return Success("根据名称获取管理员信息", list);
            else
                return Success("没有获取到管理员信息，请重新搜索", list);
        }
        /// <summary>
        /// 获取管理员和客户关联信息
        /// </summary>
        /// <returns></returns>
        public ActionResult GetManageCustomer(int PageIndex, int PageSize)
        {
            //DataTable dt = new DataTable();
            //dt = muserbll.GetManageCustomer().Tables[0];
            //return Success("加载成功", dt);
            #region 分页显示管理员账号信息
            if (PageIndex == 0)
            {
                PageIndex = 1;
            }
            if (PageSize == 0)
            {
                PageSize = 10;
            }
            var sql = " ";
           
            Model.PageData<Model.ManageCustomer> pageModel = new Model.PageData<Model.ManageCustomer>();
            var recordCount = 0;
            var dt = BLL.PagerBLL.GetListPager(
                 "( select a.*,b.username,c.F_CompanyName,c.F_CustomerCode from ManageCustomer a  left join ManagementUser b on a.mangid=b.id  left join T_Cus_CustomerBaseNew c on a.cusmid=c.F_CustomerId ) d",
                 "d.id",
                 "*",
                 sql,
                 "ORDER BY d.id desc ",
                 PageSize,
                 PageIndex,
                 true,
                 out recordCount);
            List<Model.ManageCustomer> modelList = new BLL.ManagementUser().DataTableToList1(dt);
            var list = new List<Model.ManageCustomer>();
            foreach (var item in modelList)
            {
                list.Add(new Model.ManageCustomer
                {
                    id = item.id,
                    username = item.username,
                    mangid=item.mangid,
                    cusmid=item.cusmid,
                    F_CompanyName=item.F_CompanyName,
                    F_CustomerCode=item.F_CustomerCode
                });
            }
            var obj = new
            {
                rows = list,
                total = recordCount
            };
            return Success("成功", obj);
            #endregion
        }
        //添加关联信息
        public ActionResult AddManageCustomer(int mangid,string cusmid)
        {

            string[] arrStr = cusmid.Split(',');
            foreach (var item in arrStr)
            {
                Model.ManageCustomer ManageCustomerModel = new Model.ManageCustomer();
                ManageCustomerModel.mangid = mangid;

                ManageCustomerModel.cusmid =Convert.ToInt32(item);

                if (muserbll.AddManageCustomer(ManageCustomerModel) > 0)
                {

                }
                else
                {
                    return Error("新增失败！");
                }
                    
            }
            return Success("新增成功！");

        }
        /// <summary>
        /// 获取管理员客户关联数据详情
        /// </summary>
        /// <param name="id"></param>
        /// <returns></returns>
        public ActionResult GetManageCustomerModel(int id)
        {
            var model = muserbll.GetManageCustomerModel(id);
            if (model == null)
                return Error("该信息不存在");
            var obj = new Model.ManageCustomer
            {
                id = model.id,
                cusmid=model.cusmid,
                mangid=model.mangid,
                username=model.username,
                F_CompanyName=model.F_CompanyName,
                F_CustomerCode=model.F_CustomerCode
                
            };
            return Success("获取成功", obj);
        }
        /// <summary>
        /// 修改管理员客户关联数据信息
        /// </summary>
        /// <param name="mangid"></param>
        /// <param name="cusmid"></param>
        /// <param name="id"></param>
        /// <returns></returns>
        public ActionResult UpdateManageCustomer(int mangid, int cusmid,int id)
        {
            Model.ManageCustomer ManageCustomerModel = new Model.ManageCustomer();
            ManageCustomerModel.mangid = mangid;

            ManageCustomerModel.cusmid = cusmid;
            ManageCustomerModel.id = id;
            if (muserbll.UpdateManageCustomer(ManageCustomerModel))
                return Success("修改成功！");
            else
                return Error("修改失败！");
        }
        /// <summary>
        /// 根据用户名获取所管理的客户
        /// </summary>
        /// <param name="username"></param>
        /// <returns></returns>
        public ActionResult GetManageCustomername(string username)
        {
            ManagementUser mause = muserbll.GetModelname(username);
            int id = 0;
            if (mause != null)
            {
                id = mause.id;
            }
            string sql = "";
            if (id > 0)
            {
                sql += " mangid=" + id;
            }
            var maulist = muserbll.GetManageCustomerModelList(sql);
            return Success("获取成功", maulist);
        }
        /// <summary>
        /// 删除管理员账号与客户关联表数据
        /// </summary>
        /// <param name="ids"></param>
        /// <returns></returns>
        public ActionResult DeleManageCust(string ids)
        {
            if (ids == null || ids == "")
                return Error("请选择数据");

            if (string.IsNullOrEmpty(ids))
                return Error("请选择数据");
            if (muserbll.DeleteManaList(ids))
                return Success("删除成功");
            else
                return Error("删除失败");

          }
    }
}