/// <summary> /// 检查用户的网卡Mac地址 /// </summary> /// <param name="macAddress">Mac地址</param> /// <param name="userId">用户主键</param> /// <returns>是否符合限制</returns> private bool CheckMacAddress(string macAddress, string userId) { bool returnValue = false; List <KeyValuePair <string, object> > parameters = new List <KeyValuePair <string, object> > { new KeyValuePair <string, object>(CiParameterTable.FieldParameterId, userId), new KeyValuePair <string, object>(CiParameterTable.FieldCategoryKey, "MacAddress"), new KeyValuePair <string, object>(CiParameterTable.FieldEnabled, 1) }; DataTable dt = DbCommonLibary.GetDT(this.DBProvider, CiParameterTable.TableName, parameters); if (dt.Rows.Count > 0) { string parameterCode = string.Empty; string parameterCotent = string.Empty; for (int i = 0; i < dt.Rows.Count; i++) { parameterCode = dt.Rows[i][CiParameterTable.FieldParameterCode].ToString(); parameterCotent = dt.Rows[i][CiParameterTable.FieldParameterContent].ToString(); returnValue = (macAddress.ToLower()).Equals(parameterCotent.ToLower()); if (returnValue) { break; } } } return(returnValue); }
public virtual DataTable GetDT(KeyValuePair <string, object> parameter, string order) { List <KeyValuePair <string, object> > parameters = new List <KeyValuePair <string, object> >(); parameters.Add(parameter); return(DbCommonLibary.GetDT(DBProvider, this.CurrentTableName, parameters, 0, order)); }
public virtual DataTable GetDT(KeyValuePair <string, object> parameter, int topLimit = 0, string order = null) { List <KeyValuePair <string, object> > parameters = new List <KeyValuePair <string, object> > { parameter }; return(DbCommonLibary.GetDT(DBProvider, this.CurrentTableName, parameters, topLimit, order)); }
/// <summary> /// 检查用户IP地址 /// </summary> /// <param name="ipAddress">IP地址</param> /// <returns>是否符合限制</returns> private bool CheckIPAddress(string ipAddress, string userId) { bool returnValue = false; List <KeyValuePair <string, object> > parameters = new List <KeyValuePair <string, object> > { new KeyValuePair <string, object>(CiParameterTable.FieldParameterId, userId), new KeyValuePair <string, object>(CiParameterTable.FieldCategoryKey, "IPAddress"), new KeyValuePair <string, object>(CiParameterTable.FieldEnabled, 1) }; DataTable dt = DbCommonLibary.GetDT(this.DBProvider, CiParameterTable.TableName, parameters); if (dt.Rows.Count > 0) { string parameterCode = string.Empty; string parameterCotent = string.Empty; for (int i = 0; i < dt.Rows.Count; i++) { parameterCode = dt.Rows[i][CiParameterTable.FieldParameterCode].ToString(); parameterCotent = dt.Rows[i][CiParameterTable.FieldParameterContent].ToString(); switch (parameterCode) { // 匹配单个IP case "Single": returnValue = CheckSingleIPAddress(ipAddress, parameterCotent); break; // 匹配ip地址段 case "Range": returnValue = CheckIPAddressWithRange(ipAddress, parameterCotent); break; // 匹配带掩码的地址段 case "Mask": returnValue = CheckIPAddressWithMask(ipAddress, parameterCotent); break; } if (returnValue) { break; } } } return(returnValue); }
////////////////////////////////////////////////////////////////////////////////////////////////////// /// 资源权限设定关系相关 ////////////////////////////////////////////////////////////////////////////////////////////////////// #region public string[] GetResourcePermissionItemIds(UserInfo userInfo, string resourceCategory, string resourceId) 获取资源权限主键数组 /// <summary> /// 获取资源权限主键数组 /// </summary> /// <param name="userInfo">用户</param> /// <param name="resourceCategory">资源分类</param> /// <param name="resourceId">资源主键</param> /// <returns>操作权限主键数组</returns> public string[] GetResourcePermissionItemIds(UserInfo userInfo, string resourceCategory, string resourceId) { string[] returnValue = null; var parameter = ParameterUtil.CreateWithMessage(userInfo, MethodBase.GetCurrentMethod(), this.serviceName, RDIFrameworkMessage.PermissionService_GetResourcePermissionItemIds); ServiceUtil.ProcessRDIReadDb(userInfo, parameter, dbProvider => { var names = new string[2]; var values = new string[2]; names[0] = PiPermissionTable.FieldResourceCategory; values[0] = resourceCategory; names[1] = PiPermissionTable.FieldResourceId; values[1] = resourceId; DataTable dataTable = DbCommonLibary.GetDT(dbProvider, PiPermissionTable.TableName, names, values); returnValue = BusinessLogic.FieldToArray(dataTable, PiPermissionTable.FieldPermissionId); }); return(returnValue); }
public virtual DataTable GetDT(string name, Object[] values) { return(DbCommonLibary.GetDT(DBProvider, this.CurrentTableName, name, values)); }
/// <summary> /// 获取分页DataTable /// </summary> /// <param name="recordCount">记录总数</param> /// <param name="currentPage">当前页数</param> /// <param name="perPage">每页显示多少条</param> /// <param name="whereConditional">条件</param> /// <param name="order">排序字段</param> /// <returns>数据表</returns> public virtual DataTable GetDT(out int recordCount, int currentPage, int perPage, string whereConditional, string order) { recordCount = DbCommonLibary.GetCount(DBProvider, this.CurrentTableName, whereConditional); return(DbCommonLibary.GetDT(DBProvider, this.CurrentTableName, currentPage, perPage, whereConditional, order)); }
/// <summary> /// 读取多条记录 /// </summary> /// <returns>数据表</returns> public virtual DataTable GetDT() { return(DbCommonLibary.GetDT(DBProvider, this.CurrentTableName)); }
/// <summary> /// 按父亲节点获取数据 /// </summary> /// <param name="parentId">父节点主键</param> /// <returns>数据表</returns> public virtual DataTable GetDTByParent(string parentId) { return(DbCommonLibary.GetDT(DBProvider, this.CurrentTableName, BusinessLogic.FieldParentId, parentId, BusinessLogic.FieldSortCode)); }
/// <summary> /// 获取列表 /// </summary> /// <param name="categoryId">类别主键</param> /// <returns>数据表</returns> public virtual DataTable GetDTByCategory(string categoryId) { return(DbCommonLibary.GetDT(DBProvider, this.CurrentTableName, BusinessLogic.FieldCategoryId, categoryId, BusinessLogic.FieldSortCode)); }
public virtual DataTable GetDT(params KeyValuePair <string, object>[] parameters) { List <KeyValuePair <string, object> > parametersList = parameters.ToList(); return(DbCommonLibary.GetDT(DBProvider, this.CurrentTableName, parametersList)); }
public virtual DataTable GetDT(string[] names, Object[] values, int topLimit, string order) { return(DbCommonLibary.GetDT(DBProvider, this.CurrentTableName, names, values, topLimit, order)); }
public virtual DataTable GetDT(int topLimit, string order) { return(DbCommonLibary.GetDT(DBProvider, this.CurrentTableName, topLimit, order)); }
public virtual DataTable GetDT(string name, object value, string order) { return(DbCommonLibary.GetDT(DBProvider, this.CurrentTableName, name, value, order)); }
public virtual DataTable GetDT(string name1, object value1, string name2, object value2, int topLimit, string order) { return(DbCommonLibary.GetDT(DBProvider, this.CurrentTableName, name1, value1, name2, value2, topLimit, order)); }
public virtual DataTable GetDT(string[] ids) { return(DbCommonLibary.GetDT(DBProvider, this.CurrentTableName, ids)); }