/// <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));
}
