You cannot select more than 25 topics
Topics must start with a letter or number, can include dashes ('-') and can be up to 35 characters long.
274 lines
11 KiB
Plaintext
274 lines
11 KiB
Plaintext
9 months ago
|
using System;
|
||
|
|
using System.Data;
|
||
|
|
using BP.DA;
|
||
|
|
using BP.Web;
|
||
|
|
using BP.WF.HttpHandler;
|
||
|
|
|
||
|
|
namespace BP.CCFast.CCMenu
|
||
|
|
{
|
||
|
|
/// <summary>
|
||
|
|
/// 页面功能实体
|
||
|
|
/// </summary>
|
||
|
|
public class PortPage : DirectoryPageBase
|
||
|
|
{
|
||
|
|
#region 构造函数
|
||
|
|
/// <summary>
|
||
|
|
/// 构造函数
|
||
|
|
/// </summary>
|
||
|
|
public PortPage()
|
||
|
|
{
|
||
|
|
}
|
||
|
|
#endregion 构造函数
|
||
|
|
|
||
|
|
#region 组织结构维护.
|
||
|
|
/// <summary>
|
||
|
|
/// 获取该部门的所有人员
|
||
|
|
/// </summary>
|
||
|
|
/// <returns></returns>
|
||
|
|
public string LoadDatagridDeptEmp_Init()
|
||
|
|
{
|
||
|
|
string deptNo = this.GetRequestVal("deptNo");
|
||
|
|
if (string.IsNullOrEmpty(deptNo))
|
||
|
|
{
|
||
|
|
return "{ total: 0, rows: [] }";
|
||
|
|
}
|
||
|
|
string orderBy = this.GetRequestVal("orderBy");
|
||
|
|
|
||
|
|
|
||
|
|
string searchText = this.GetRequestVal("searchText");
|
||
|
|
if (!DataType.IsNullOrEmpty(searchText))
|
||
|
|
{
|
||
|
|
searchText.Trim();
|
||
|
|
}
|
||
|
|
string addQue = "";
|
||
|
|
if (!string.IsNullOrEmpty(searchText))
|
||
|
|
{
|
||
|
|
addQue = " AND (pe.No like '%" + searchText + "%' or pe.Name like '%" + searchText + "%') ";
|
||
|
|
}
|
||
|
|
|
||
|
|
string pageNumber = this.GetRequestVal("pageNumber");
|
||
|
|
int iPageNumber = string.IsNullOrEmpty(pageNumber) ? 1 : Convert.ToInt32(pageNumber);
|
||
|
|
//每页多少行
|
||
|
|
string pageSize = this.GetRequestVal("pageSize");
|
||
|
|
int iPageSize = string.IsNullOrEmpty(pageSize) ? 9999 : Convert.ToInt32(pageSize);
|
||
|
|
|
||
|
|
string sql = "(select pe.*,pd.name FK_DutyText from Port_Emp pe left join port_duty pd on pd.no = pe.fk_duty where pe.no in (select fk_emp from Port_DeptEmp where fk_dept='" + deptNo + "') "
|
||
|
|
+ addQue + " ) dbSo ";
|
||
|
|
|
||
|
|
|
||
|
|
return DBPaging(sql, iPageNumber, iPageSize, "No", orderBy);
|
||
|
|
|
||
|
|
}
|
||
|
|
|
||
|
|
/// <summary>
|
||
|
|
/// 以下算法只包含 oracle mysql sqlserver 三种类型的数据库 qin
|
||
|
|
/// </summary>
|
||
|
|
/// <param name="dataSource">表名</param>
|
||
|
|
/// <param name="pageNumber">当前页</param>
|
||
|
|
/// <param name="pageSize">当前页数据条数</param>
|
||
|
|
/// <param name="key">计算总行数需要</param>
|
||
|
|
/// <param name="orderKey">排序字段</param>
|
||
|
|
/// <returns></returns>
|
||
|
|
public string DBPaging(string dataSource, int pageNumber, int pageSize, string key, string orderKey)
|
||
|
|
{
|
||
|
|
string sql = "";
|
||
|
|
string orderByStr = "";
|
||
|
|
|
||
|
|
if (!string.IsNullOrEmpty(orderKey))
|
||
|
|
orderByStr = " ORDER BY " + orderKey;
|
||
|
|
|
||
|
|
switch (DBAccess.AppCenterDBType)
|
||
|
|
{
|
||
|
|
case DBType.Oracle:
|
||
|
|
case DBType.KingBaseR3:
|
||
|
|
case DBType.KingBaseR6:
|
||
|
|
int beginIndex = (pageNumber - 1) * pageSize + 1;
|
||
|
|
int endIndex = pageNumber * pageSize;
|
||
|
|
|
||
|
|
sql = "SELECT * FROM ( SELECT A.*, ROWNUM RN " +
|
||
|
|
"FROM (SELECT * FROM " + dataSource + orderByStr + ") A WHERE ROWNUM <= " + endIndex + " ) WHERE RN >=" + beginIndex;
|
||
|
|
break;
|
||
|
|
case DBType.MSSQL:
|
||
|
|
sql = "SELECT TOP " + pageSize + " * FROM " + dataSource + " WHERE " + key + " NOT IN ("
|
||
|
|
+ "SELECT TOP (" + pageSize + "*(" + pageNumber + "-1)) " + key + " FROM " + dataSource + " )" + orderByStr;
|
||
|
|
break;
|
||
|
|
case DBType.MySQL:
|
||
|
|
sql = "select * from " + dataSource + orderByStr + " limit " + (pageNumber - 1) * pageSize + "," + pageSize;
|
||
|
|
break;
|
||
|
|
default:
|
||
|
|
throw new Exception("暂不支持您的数据库类型.");
|
||
|
|
}
|
||
|
|
|
||
|
|
DataTable DTable = DBAccess.RunSQLReturnTable(sql);
|
||
|
|
|
||
|
|
int totalCount = DBAccess.RunSQLReturnCOUNT("select " + key + " from " + dataSource);
|
||
|
|
|
||
|
|
return DataTableConvertJson.DataTable2Json(DTable, totalCount);
|
||
|
|
}
|
||
|
|
#endregion
|
||
|
|
|
||
|
|
#region 获取菜单权限.
|
||
|
|
/// <summary>
|
||
|
|
/// 获得菜单数据.
|
||
|
|
/// </summary>
|
||
|
|
/// <returns></returns>
|
||
|
|
public string GPM_DB_Menus()
|
||
|
|
{
|
||
|
|
var appNo = this.GetRequestVal("AppNo");
|
||
|
|
|
||
|
|
var sql1 = "SELECT No,Name,FK_Menu,ParentNo,UrlExt,Icon,Idx ";
|
||
|
|
sql1 += " FROM V_GPM_EmpMenu ";
|
||
|
|
sql1 += " WHERE FK_Emp = '" + WebUser.No + "' ";
|
||
|
|
sql1 += " AND MenuType = '3' ";
|
||
|
|
sql1 += " AND FK_App = '" + appNo + "' ";
|
||
|
|
sql1 += " UNION "; //加入不需要权限控制的菜单.
|
||
|
|
sql1 += "SELECT No,Name, No as FK_Menu,ParentNo,UrlExt,Icon,Idx";
|
||
|
|
sql1 += " FROM GPM_Menu ";
|
||
|
|
sql1 += " WHERE MenuCtrlWay=1 ";
|
||
|
|
sql1 += " AND MenuType = '3' ";
|
||
|
|
sql1 += " AND FK_App = '" + appNo + "' ORDER BY Idx ";
|
||
|
|
var dirs = DBAccess.RunSQLReturnTable(sql1);
|
||
|
|
dirs.TableName = "Dirs"; //获得目录.
|
||
|
|
|
||
|
|
var sql2 = "SELECT No,Name,FK_Menu,ParentNo,UrlExt,Icon,Idx ";
|
||
|
|
sql2 += " FROM V_GPM_EmpMenu ";
|
||
|
|
sql2 += " WHERE FK_Emp = '" + WebUser.No + "'";
|
||
|
|
sql2 += " AND MenuType = '4' ";
|
||
|
|
sql2 += " AND FK_App = '" + appNo + "' ";
|
||
|
|
sql2 += " UNION "; //加入不需要权限控制的菜单.
|
||
|
|
sql2 += "SELECT No,Name, No as FK_Menu,ParentNo,UrlExt,Icon,Idx ";
|
||
|
|
sql2 += " FROM GPM_Menu "; //加入不需要权限控制的菜单.
|
||
|
|
sql2 += " WHERE MenuCtrlWay=1 ";
|
||
|
|
sql2 += " AND MenuType = '4' ";
|
||
|
|
sql2 += " AND FK_App = '" + appNo + "' ORDER BY Idx ";
|
||
|
|
|
||
|
|
var menus = DBAccess.RunSQLReturnTable(sql2);
|
||
|
|
menus.TableName = "Menus"; //获得菜单.
|
||
|
|
|
||
|
|
//组装数据.
|
||
|
|
DataSet ds = new DataSet();
|
||
|
|
ds.Tables.Add(dirs);
|
||
|
|
ds.Tables.Add(menus);
|
||
|
|
|
||
|
|
return BP.Tools.Json.ToJson(ds);
|
||
|
|
}
|
||
|
|
/// <summary>
|
||
|
|
/// 获得OA菜单数据.
|
||
|
|
/// </summary>
|
||
|
|
/// <returns></returns>
|
||
|
|
public string GPM_OA_Menus()
|
||
|
|
{
|
||
|
|
var appNo = this.GetRequestVal("AppNo");
|
||
|
|
|
||
|
|
Paras ps = new Paras();
|
||
|
|
string dbstr = BP.Difference.SystemConfig.AppCenterDBVarStr;
|
||
|
|
ps.SQL = "SELECT No FROM GPM_Menu WHERE MenuType=" + dbstr + "MenuType AND FK_App=" + dbstr + "FK_App";
|
||
|
|
ps.Add("MenuType", 2);
|
||
|
|
ps.Add("FK_App", appNo);
|
||
|
|
|
||
|
|
string ParentNo = DBAccess.RunSQLReturnString(ps);
|
||
|
|
|
||
|
|
if (string.IsNullOrWhiteSpace(ParentNo))
|
||
|
|
return "[]";
|
||
|
|
|
||
|
|
var sql1 = "SELECT No,Name,FK_Menu,MenuType,ParentNo,Url,UrlExt,Tag1,Tag2,Tag3,WebPath,Icon,Idx ";
|
||
|
|
sql1 += " FROM v_gpm_empmenu ";
|
||
|
|
sql1 += " WHERE FK_Emp = '" + WebUser.No + "' ";
|
||
|
|
sql1 += " AND ParentNo = '" + ParentNo + "' ";
|
||
|
|
sql1 += " AND FK_App = '" + appNo + "' ";
|
||
|
|
sql1 += " UNION "; //加入不需要权限控制的菜单.
|
||
|
|
sql1 += "SELECT No,Name, No as FK_Menu,MenuType,ParentNo,Url,UrlExt,Tag1,Tag2,Tag3,WebPath,Icon,Idx";
|
||
|
|
sql1 += " FROM GPM_Menu ";
|
||
|
|
sql1 += " WHERE MenuCtrlWay=1 ";
|
||
|
|
sql1 += " AND ParentNo = '" + ParentNo + "' ";
|
||
|
|
sql1 += " AND FK_App = '" + appNo + "' ORDER BY Idx ";
|
||
|
|
var dirs = DBAccess.RunSQLReturnTable(sql1);
|
||
|
|
dirs.TableName = "Dirs"; //获得目录.
|
||
|
|
|
||
|
|
var sql2 = "SELECT No,Name,FK_Menu,MenuType,ParentNo,Url,UrlExt,Tag1,Tag2,Tag3,WebPath,Icon,Idx,openway ";
|
||
|
|
sql2 += " FROM v_gpm_empmenu ";
|
||
|
|
sql2 += " WHERE FK_Emp = '" + WebUser.No + "'";
|
||
|
|
sql2 += " AND ParentNo != '" + ParentNo + "' ";
|
||
|
|
sql2 += " AND FK_App = '" + appNo + "' ";
|
||
|
|
sql2 += " UNION "; //加入不需要权限控制的菜单.
|
||
|
|
sql2 += "SELECT No,Name, No as FK_Menu,MenuType,ParentNo,Url,UrlExt,Tag1,Tag2,Tag3,WebPath,Icon,Idx,openway ";
|
||
|
|
sql2 += " FROM GPM_Menu "; //加入不需要权限控制的菜单.
|
||
|
|
sql2 += " WHERE MenuCtrlWay=1 ";
|
||
|
|
sql2 += " AND ParentNo != '" + ParentNo + "' ";
|
||
|
|
sql2 += " AND FK_App = '" + appNo + "' ORDER BY Idx ";
|
||
|
|
|
||
|
|
var menus = DBAccess.RunSQLReturnTable(sql2);
|
||
|
|
menus.TableName = "Menus"; //获得菜单.
|
||
|
|
|
||
|
|
//组装数据.
|
||
|
|
DataSet ds = new DataSet();
|
||
|
|
ds.Tables.Add(dirs);
|
||
|
|
ds.Tables.Add(menus);
|
||
|
|
|
||
|
|
return BP.Tools.Json.ToJson(ds);
|
||
|
|
}
|
||
|
|
/// <summary>
|
||
|
|
/// 是否可以执行当前工作
|
||
|
|
/// </summary>
|
||
|
|
/// <returns></returns>
|
||
|
|
public string GPM_IsCanExecuteFunction()
|
||
|
|
{
|
||
|
|
var dt = GPM_GenerFlagDB(); //获得所有的标记.
|
||
|
|
var funcNo = this.GetRequestVal("FuncFlag");
|
||
|
|
foreach (DataRow dr in dt.Rows)
|
||
|
|
{
|
||
|
|
if (dr[0].ToString().Equals(funcNo) == true)
|
||
|
|
return "1";
|
||
|
|
}
|
||
|
|
return "0";
|
||
|
|
}
|
||
|
|
/// <summary>
|
||
|
|
/// 获得所有的权限标记.
|
||
|
|
/// </summary>
|
||
|
|
/// <returns></returns>
|
||
|
|
public DataTable GPM_GenerFlagDB()
|
||
|
|
{
|
||
|
|
var appNo = this.GetRequestVal("AppNo");
|
||
|
|
var sql2 = "SELECT Flag,Idx";
|
||
|
|
sql2 += " FROM V_GPM_EmpMenu ";
|
||
|
|
sql2 += " WHERE FK_Emp = '" + WebUser.No + "'";
|
||
|
|
sql2 += " AND MenuType = '5' ";
|
||
|
|
sql2 += " AND FK_App = '" + appNo + "' ";
|
||
|
|
sql2 += " UNION "; //加入不需要权限控制的菜单.
|
||
|
|
sql2 += "SELECT Flag,Idx ";
|
||
|
|
sql2 += " FROM GPM_Menu "; //加入不需要权限控制的菜单.
|
||
|
|
sql2 += " WHERE MenuCtrlWay=1 ";
|
||
|
|
sql2 += " AND MenuType = '5' ";
|
||
|
|
sql2 += " AND FK_App = '" + appNo + "' ORDER BY Idx ";
|
||
|
|
DataTable dt = DBAccess.RunSQLReturnTable(sql2);
|
||
|
|
return dt;
|
||
|
|
}
|
||
|
|
/// <summary>
|
||
|
|
/// 获得所有权限的标记
|
||
|
|
/// </summary>
|
||
|
|
/// <returns></returns>
|
||
|
|
public string GPM_AutoHidShowPageElement()
|
||
|
|
{
|
||
|
|
var dt = GPM_GenerFlagDB(); //获得所有的标记.
|
||
|
|
return BP.Tools.Json.ToJson(dt);
|
||
|
|
}
|
||
|
|
/// <summary>
|
||
|
|
/// 组织结构查询
|
||
|
|
/// </summary>
|
||
|
|
/// <returns></returns>
|
||
|
|
public string GPM_Search()
|
||
|
|
{
|
||
|
|
var searchKey = this.GetRequestVal("searchKey");
|
||
|
|
//var SearchDept = this.GetRequestVal("SearchDept");
|
||
|
|
//var SearchEmp = this.GetRequestVal("SearchEmp");
|
||
|
|
//var SearchTel = this.GetRequestVal("SearchTel");
|
||
|
|
var sql = "SELECT e.No AS No,e.Name AS Name,d.Name AS deptName,e.Email AS Email,e.Tel AS Tel from Port_Dept d,Port_Emp e " +
|
||
|
|
"where d.No=e.FK_Dept AND (e.No LIKE '%" + searchKey + "%' or e.NAME LIKE '%" + searchKey + "%' or d.Name LIKE '%" + searchKey + "%' or e.Tel LIKE '%" + searchKey + "%')";
|
||
|
|
DataTable dt = DBAccess.RunSQLReturnTable(sql);
|
||
|
|
return BP.Tools.Json.ToJson(dt);
|
||
|
|
}
|
||
|
|
#endregion
|
||
|
|
|
||
|
|
}
|
||
|
|
}
|