using PMS.Interface.SysManager;
using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using PMS.EntityModels.SysManager;
using PMS.DBService.SysManager;
using QWPlatform.IService;
using System.Data;
using QWPlatform.SystemLibrary.Utils;

namespace PMS.BusinessService.SysManager
{
    public class XTZHBLLService : IXTZHModel
    {
        private XTZHDBService XTZHDBService = DataServiceBase.Instance<XTZHDBService>();

        /// <summary>
        /// 系统账户查找
        /// </summary>
        /// <param name="iD"></param>
        /// <returns></returns>
        public DataTable GetSystemUserInfo(int ID)
        {
           return XTZHDBService.GetSystemUserInfo(ID);
        }
        /// <summary>
        /// 人员信息的查询
        /// </summary>
        /// <param name="zh"></param>
        public string SelectPersonInfo(string zh)
        {
            var dt = XTZHDBService.SelectPersonInfo(zh);
            if (dt.Rows.Count == 0)
            {
                return "";
            }
            else
            { 
            return Strings.ObjectToJson(XTZHDBService.SelectPersonInfo(zh), true);
            }
        }

        /// <summary>
        /// 获取系统账户姓名
        /// </summary>
        /// <param name="XM"></param>
        /// <returns></returns>
        public string UserNameCheck(string XM)
        {
           return  XTZHDBService.UserNameCheck(XM);
        }

        /// <summary>
        /// 系统账户重置密码
        /// </summary>
        /// <param name="id"></param>
        /// <param name="pwd"></param>
        public void XGMm(int id, string pwd)
        {
            XTZHDBService.XGMm(id,pwd);
        }

        /// <summary>
        ///删除系统账户
        /// </summary>
        /// <param name="id"></param>
        public void XtZHDel(int id)
        {
            XTZHDBService.XtZHDel(id);
        }
        /// <summary>
        /// 更新用户访问渠道项目权限
        /// </summary>
        /// <param name="id"></param>
        /// <param name="authorize">1是，0否</param>
        public bool UpdataAuthorize(int id, int authorize)
        {
          return  XTZHDBService.UpdataAuthorize(id, authorize);
        }

        /// <summary>
        /// 系统账户得新增修改
        /// </summary>
        /// <param name="xtzhModel">系统账户实体</param>
        /// <param name="editType">编辑类型</param>
        /// <returns></returns>
        public string XtZHEdit(XTZHModel xtzhModel, int editType)
        {
            if (xtzhModel.MM==null)
            {
                xtzhModel.MM = "1";
            }
           return XTZHDBService.XtZHEdit(xtzhModel, editType);
        }
        /// <summary>
        /// 获取账户渠道信息
        /// </summary>
        /// <returns></returns>
        public string XtZHGs()
        {
            DataTable dt = XTZHDBService.XtZHGs();
           // dt.Rows.Remove(dt.Rows[0]);
            return Strings.ObjectToJson(dt, true);
        }

        /// <summary>
        /// 获取系统账户类型
        /// </summary>
        /// <returns></returns>
        public string XtZHLx()
        {
            DataTable dt = XTZHDBService.XtZHLx();
            dt.Rows.Remove(dt.Rows[2]);
            return Strings.ObjectToJson(dt, true);
        }
        /// <summary>
        /// 获取公司下的人员
        /// </summary>
        /// <param name="gSID"></param>
        /// <returns></returns>
        public string XtZHRY(string gSID)
        {
            DataTable dt = XTZHDBService.XtZHRY(gSID);
            // dt.Rows.Remove(dt.Rows[0]);
            return Strings.ObjectToJson(dt, true);
        }

        /// <summary>
        /// 系统账户得查询
        /// </summary>
        /// <param name="search"></param>
        /// <param name="page"></param>
        /// <param name="rows"></param>
        /// <returns></returns>
        public string XtZHSelect(string search, int page, int rows)
        {
            int defaultrow = 20;
            int start_number = GetStartNumber(page,rows, defaultrow);
            int end_number = GetEndNumber(page,rows,defaultrow);
            return XTZHDBService.XtZHSelect(search, start_number, end_number);
        }
        /// <summary>
        /// 得到结束行数
        /// </summary>
        /// <param name="page"></param>
        /// <param name="rows"></param>
        /// <returns></returns>
        private int GetEndNumber(int page, int rows,int defaultrow)
        {
            try
            {
                int _pageNum = page == 0 ? 1 : page;
                int _pagerows = rows == 0 ? defaultrow : rows;
                return (_pageNum * _pagerows);
            }

            catch (Exception)
            {
                return 0;
            }
          
        }
        /// <summary>
        /// 开始行数
        /// </summary>
        /// <param name="page"></param>
        /// <param name="rows"></param>
        /// <returns></returns>
        private int GetStartNumber(int page, int rows, int defaultrow)
        {
            try
            {
                int _pageNum = page == 0 ? 1 : page;
                int _pagerows = rows == 0 ? defaultrow : rows;
                return ((_pageNum - 1) * _pagerows + 1);
            }

            catch (Exception)
            {
                return 0;
            }
        }
    }
}