123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185 |
- 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;
- }
- }
- }
- }
|