/// <summary> /// 获取列表 /// </summary> /// <param name="categoryId">类别主键</param> /// <returns>数据表</returns> public virtual DataTable GetDataTableByCategory(string categoryCode) { List <KeyValuePair <string, object> > parameters = new List <KeyValuePair <string, object> >(); parameters.Add(new KeyValuePair <string, object>(BaseBusinessLogic.FieldCategoryCode, categoryCode)); return(DbLogic.GetDataTable(DbHelper, this.CurrentTableName, parameters)); }
/// <summary> /// 检查用户的网卡Mac地址 /// </summary> /// <param name="macAddress">Mac地址</param> /// <returns>是否符合限制</returns> private bool CheckMacAddress(string macAddress, string userId) { bool returnValue = false; List <KeyValuePair <string, object> > parameters = new List <KeyValuePair <string, object> >(); parameters.Add(new KeyValuePair <string, object>(BaseParameterEntity.FieldParameterId, userId)); parameters.Add(new KeyValuePair <string, object>(BaseParameterEntity.FieldCategoryId, "MacAddress")); parameters.Add(new KeyValuePair <string, object>(BaseParameterEntity.FieldEnabled, 1)); DataTable dt = DbLogic.GetDataTable(this.DbHelper, BaseParameterEntity.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][BaseParameterEntity.FieldParameterCode].ToString(); parameterCotent = dt.Rows[i][BaseParameterEntity.FieldParameterContent].ToString(); returnValue = (macAddress.ToLower()).Equals(parameterCotent.ToLower());//简单格式化一下 if (returnValue) { break; } } } return(returnValue); }
public virtual DataTable GetDataTable(KeyValuePair <string, object> parameter, int topLimit = 0, string order = null) { List <KeyValuePair <string, object> > parameters = new List <KeyValuePair <string, object> >(); parameters.Add(parameter); return(DbLogic.GetDataTable(DbHelper, this.CurrentTableName, parameters, topLimit, order)); }
/// <summary> /// 按父亲节点获取数据 /// </summary> /// <param name="parentId">父节点主键</param> /// <returns>数据表</returns> public virtual DataTable GetDataTableByParent(string parentId) { List <KeyValuePair <string, object> > parameters = new List <KeyValuePair <string, object> >(); parameters.Add(new KeyValuePair <string, object>(BaseBusinessLogic.FieldParentId, parentId)); return(DbLogic.GetDataTable(DbHelper, this.CurrentTableName, parameters, 0, BaseBusinessLogic.FieldSortCode)); }
public virtual DataTable GetDataTable(KeyValuePair <string, object> parameter1, KeyValuePair <string, object> parameter2, string order) { List <KeyValuePair <string, object> > parameters = new List <KeyValuePair <string, object> >(); parameters.Add(parameter1); parameters.Add(parameter2); return(DbLogic.GetDataTable(DbHelper, this.CurrentTableName, parameters, 0, order)); }
public virtual DataTable GetDataTable(params KeyValuePair <string, object>[] parameters) { List <KeyValuePair <string, object> > parametersList = new List <KeyValuePair <string, object> >(); for (int i = 0; i < parameters.Length; i++) { parametersList.Add(parameters[i]); } return(DbLogic.GetDataTable(DbHelper, this.CurrentTableName, parametersList)); }
public DataTable GetExternalUser(string id) { DataTable result = null; string connectionString = ConfigurationHelper.AppSettings("WeChatDbConnection", BaseSystemInfo.EncryptDbConnection); if (!string.IsNullOrEmpty(connectionString)) { List <KeyValuePair <string, object> > parameters = new List <KeyValuePair <string, object> >(); parameters.Add(new KeyValuePair <string, object>("Id", id)); IDbHelper dbHelper = DbHelperFactory.GetHelper(CurrentDbType.Oracle, connectionString); result = DbLogic.GetDataTable(dbHelper, "ExternalUser", parameters); result.TableName = "ExternalUser"; } return(result); }
/// <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> >(); parameters.Add(new KeyValuePair <string, object>(BaseParameterEntity.FieldParameterId, userId)); parameters.Add(new KeyValuePair <string, object>(BaseParameterEntity.FieldCategoryId, "IPAddress")); parameters.Add(new KeyValuePair <string, object>(BaseParameterEntity.FieldEnabled, 1)); DataTable dt = DbLogic.GetDataTable(this.DbHelper, BaseParameterEntity.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][BaseParameterEntity.FieldParameterCode].ToString(); parameterCotent = dt.Rows[i][BaseParameterEntity.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[] GetResourcePermissionIds(BaseUserInfo userInfo, string resourceCategory, string resourceId) /// <summary> /// 获取资源权限主键数组 /// </summary> /// <param name="userInfo">用户</param> /// <param name="resourceCategory">资源分类</param> /// <returns>主键数组</returns> public string[] GetResourcePermissionIds(BaseUserInfo userInfo, string resourceCategory, string resourceId) { string[] result = null; var parameter = ServiceInfo.Create(userInfo, MethodBase.GetCurrentMethod()); ServiceUtil.ProcessUserCenterReadDb(userInfo, parameter, (dbHelper) => { List <KeyValuePair <string, object> > parameters = new List <KeyValuePair <string, object> >(); parameters.Add(new KeyValuePair <string, object>(BasePermissionEntity.FieldResourceCategory, resourceCategory)); parameters.Add(new KeyValuePair <string, object>(BasePermissionEntity.FieldResourceId, resourceId)); var dt = DbLogic.GetDataTable(dbHelper, BasePermissionEntity.TableName, parameters); result = BaseBusinessLogic.FieldToArray(dt, BasePermissionEntity.FieldPermissionId).Distinct <string>().Where(t => !string.IsNullOrEmpty(t)).ToArray(); }); return(result); }
////////////////////////////////////////////////////////////////////////////////////////////////////// /// 资源权限设定关系相关 ////////////////////////////////////////////////////////////////////////////////////////////////////// #region public string[] GetResourcePermissionItemIds(BaseUserInfo userInfo, string resourceCategory, string resourceId) /// <summary> /// 获取资源权限主键数组 /// </summary> /// <param name="userInfo">用户</param> /// <param name="resourceCategory">资源分类</param> /// <returns>主键数组</returns> public string[] GetResourcePermissionItemIds(BaseUserInfo userInfo, string resourceCategory, string resourceId) { // 写入调试信息 #if (DEBUG) int milliStart = BaseBusinessLogic.StartDebug(userInfo, MethodBase.GetCurrentMethod()); #endif // 加强安全验证防止未授权匿名调用 #if (!DEBUG) LogOnService.UserIsLogOn(userInfo); #endif string[] returnValue = null; using (IDbHelper dbHelper = DbHelperFactory.GetHelper(BaseSystemInfo.UserCenterDbType)) { try { dbHelper.Open(UserCenterDbConnection); List <KeyValuePair <string, object> > parameters = new List <KeyValuePair <string, object> >(); parameters.Add(new KeyValuePair <string, object>(BasePermissionEntity.FieldResourceCategory, resourceCategory)); parameters.Add(new KeyValuePair <string, object>(BasePermissionEntity.FieldResourceId, resourceId)); DataTable dataTable = DbLogic.GetDataTable(dbHelper, BasePermissionEntity.TableName, parameters); returnValue = BaseBusinessLogic.FieldToArray(dataTable, BasePermissionEntity.FieldPermissionItemId); BaseLogManager.Instance.Add(dbHelper, userInfo, this.serviceName, AppMessage.PermissionService_GetResourcePermissionItemIds, MethodBase.GetCurrentMethod()); } catch (Exception ex) { BaseExceptionManager.LogException(dbHelper, userInfo, ex); throw ex; } finally { dbHelper.Close(); } } // 写入调试信息 #if (DEBUG) BaseBusinessLogic.EndDebug(MethodBase.GetCurrentMethod(), milliStart); #endif return(returnValue); }
/// <summary> /// 按父节点获取列表 /// </summary> /// <param name="userInfo">用户</param> /// <param name="parentId">父节点</param> /// <returns>数据表</returns> public DataTable GetDataTableByParent(BaseUserInfo userInfo, string parentId) { DataTable result = null; var parameter = ServiceParameter.CreateWithMessage(userInfo , MethodBase.GetCurrentMethod() , this.serviceName , AppMessage.OrganizeService_GetProvince); System.Web.Caching.Cache cache = HttpRuntime.Cache; string cacheObject = "Area"; if (!string.IsNullOrEmpty(parentId)) { cacheObject = "Area" + parentId; } if (cache == null || cache[cacheObject] == null) { lock (locker) { if (cache == null || cache[cacheObject] == null) { ServiceUtil.ProcessUserCenterReadDb(userInfo, parameter, (dbHelper) => { // 这里是条件字段 List <KeyValuePair <string, object> > parameters = new List <KeyValuePair <string, object> >(); parameters.Add(new KeyValuePair <string, object>(BaseAreaEntity.FieldParentId, parentId)); parameters.Add(new KeyValuePair <string, object>(BaseAreaEntity.FieldEnabled, 1)); parameters.Add(new KeyValuePair <string, object>(BaseAreaEntity.FieldDeletionStateCode, 0)); // 用静态方法获取数据,提高效率,获取列表,指定排序字段 result = DbLogic.GetDataTable(dbHelper, BaseAreaEntity.TableName, parameters, 0, BaseAreaEntity.FieldSortCode, null); // var manager = new BaseAreaManager(dbHelper, userInfo); // result = manager.GetDataTable(parameters, BaseAreaEntity.FieldSortCode); result.DefaultView.Sort = BaseAreaEntity.FieldSortCode; result.TableName = BaseAreaEntity.TableName; // 这里可以缓存起来,提高效率 cache.Add(cacheObject, result, null, DateTime.Now.AddMinutes(30), TimeSpan.Zero, CacheItemPriority.Normal, null); System.Console.WriteLine(System.DateTime.Now.ToString(BaseSystemInfo.DateTimeFormat) + " cache Area " + parentId); }); } } } result = cache[cacheObject] as DataTable; return(result); }
public virtual DataTable GetDataTable(List <KeyValuePair <string, object> > parameters, string order) { return(DbLogic.GetDataTable(DbHelper, this.CurrentTableName, parameters, 0, order)); }
public virtual DataTable GetDataTable(string order) { return(DbLogic.GetDataTable(DbHelper, this.CurrentTableName, null, 0, order)); }
public virtual DataTable GetDataTable(string name, Object[] values, string order = null) { return(DbLogic.GetDataTable(BaseSystemInfo.UserCenterDbType, DbHelper, this.CurrentTableName, name, values, order)); }
public virtual DataTable GetDataTable(string name, Object[] values, string order = null) { return(DbLogic.GetDataTable(DbHelper, this.CurrentTableName, name, values, order)); }
public virtual DataTable GetDataTable(string[] ids) { return(DbLogic.GetDataTable(DbHelper, this.CurrentTableName, BaseBusinessLogic.FieldId, ids)); }
// // 读取多条记录 // public virtual DataTable GetDataTable(int topLimit = 0, string order = null) { return(DbLogic.GetDataTable(DbHelper, this.CurrentTableName, null, topLimit, order)); }