public virtual bool Exists(KeyValuePair <string, object> parameter, object id)
{
List <KeyValuePair <string, object> > parameters = new List <KeyValuePair <string, object> >();
parameters.Add(parameter);
return(DbLogic.Exists(DbHelper, this.CurrentTableName, parameters, new KeyValuePair <string, object>(this.PrimaryKey, id)));
}
/// <summary>
/// 是否合法的用户
/// 若有用户的Id，这个可以走索引，效率会很高，若没有Id会是全表扫描了。
/// </summary>
/// <param name="userId">用户主键</param>
/// <param name="openId">Key</param>
/// <param name="systemCode">独立子系统</param>
/// <returns>合法</returns>
public bool ValidateOpenId(string userId, string openId, string systemCode = null)
{
bool result = false;
if (string.IsNullOrEmpty(systemCode))
{
systemCode = string.Empty;
}
// 这个是独立业务系统
if (systemCode.Equals("PDA"))
{
this.CurrentTableName = "PDAUserLogOn";
}
List <KeyValuePair <string, object> > parameters = new List <KeyValuePair <string, object> >();
if (!string.IsNullOrWhiteSpace(userId))
{
parameters.Add(new KeyValuePair <string, object>(BaseUserLogOnEntity.FieldId, userId));
}
parameters.Add(new KeyValuePair <string, object>(BaseUserLogOnEntity.FieldOpenId, openId));
result = DbLogic.Exists(DbHelper, this.CurrentTableName, parameters);
return(result);
}
public virtual bool Exists(KeyValuePair <string, object> parameter1, KeyValuePair <string, object> parameter2, KeyValuePair <string, object> parameter)
{
List <KeyValuePair <string, object> > parameters = new List <KeyValuePair <string, object> >();
parameters.Add(parameter1);
parameters.Add(parameter2);
return(DbLogic.Exists(DbHelper, this.CurrentTableName, parameters, parameter));
}
public virtual bool Exists(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.Exists(DbHelper, this.CurrentTableName, parametersList));
}
public virtual bool Exists(List <KeyValuePair <string, object> > parameters, object id = null)
{
bool result = false;
if (id != null)
{
result = DbLogic.Exists(DbHelper, this.CurrentTableName, parameters, new KeyValuePair <string, object>(this.PrimaryKey, id));
}
else
{
result = DbLogic.Exists(DbHelper, this.CurrentTableName, parameters);
}
return(result);
}
/// <summary>
/// 用户添加之前执行的方法
/// </summary>
/// <param name="entity">用户实体</param>
public void BeforeAdd(BaseUserEntity entity)
{
// 检测成功，可以添加用户
this.StatusCode = Status.OKAdd.ToString();
if (!string.IsNullOrEmpty(entity.UserName) &&
this.Exists(new KeyValuePair <string, object>(BaseUserEntity.FieldUserName, entity.UserName)
, new KeyValuePair <string, object>(BaseUserEntity.FieldDeletionStateCode, 0)))
{
// 用户名已重复
this.StatusCode = Status.ErrorNameExist.ToString();
}
else
{
// 检查编号是否重复
if (!string.IsNullOrEmpty(entity.Code) &&
this.Exists(new KeyValuePair <string, object>(BaseUserEntity.FieldCode, entity.Code)
, new KeyValuePair <string, object>(BaseUserEntity.FieldDeletionStateCode, 0)))
{
// 编号已重复
this.StatusCode = Status.ErrorCodeExist.ToString();
}
if (entity.IsStaff == 1)
{
List <KeyValuePair <string, object> > parameters = new List <KeyValuePair <string, object> >();
parameters.Add(new KeyValuePair <string, object>(BaseStaffEntity.FieldUserName, entity.UserName));
parameters.Add(new KeyValuePair <string, object>(BaseStaffEntity.FieldDeletionStateCode, 0));
if (DbLogic.Exists(DbHelper, BaseStaffEntity.TableName, parameters))
{
// 编号已重复
this.StatusCode = Status.ErrorNameExist.ToString();
}
if (!string.IsNullOrEmpty(entity.Code))
{
parameters = new List <KeyValuePair <string, object> >();
parameters.Add(new KeyValuePair <string, object>(BaseStaffEntity.FieldCode, entity.Code));
parameters.Add(new KeyValuePair <string, object>(BaseStaffEntity.FieldDeletionStateCode, 0));
if (DbLogic.Exists(DbHelper, BaseStaffEntity.TableName, parameters))
{
// 编号已重复
this.StatusCode = Status.ErrorCodeExist.ToString();
}
}
}
}
}
/// <summary>
/// 判断用户是否有有相应的权限
/// </summary>
/// <param name="userId">用户主键</param>
/// <param name="permissionItemCode">权限编号</param>
/// <returns>有权限</returns>
public bool CheckPermission(string userId, string permissionItemCode)
{
BasePermissionItemManager permissionItemManager = new BasePermissionItemManager(DbHelper);
string permissionItemId = permissionItemManager.GetIdByCode(permissionItemCode);
// 没有找到相应的权限
if (String.IsNullOrEmpty(permissionItemId))
{
return(false);
}
List <KeyValuePair <string, object> > parameters = new List <KeyValuePair <string, object> >();
parameters.Add(new KeyValuePair <string, object>(BasePermissionEntity.FieldResourceCategory, BaseUserEntity.TableName));
parameters.Add(new KeyValuePair <string, object>(BasePermissionEntity.FieldResourceId, userId));
parameters.Add(new KeyValuePair <string, object>(BasePermissionEntity.FieldEnabled, "1"));
return(DbLogic.Exists(DbHelper, this.CurrentTableName, parameters));
}
/// <summary>
/// 创建数据表
/// </summary>
/// <param name="userInfo">用户</param>
/// <param name="tableName">表名</param>
/// <param name="statusCode">状态返回码</param>
/// <param name="statusMessage">状态返回信息</param>
public void CreateTable(BaseUserInfo userInfo, string tableName, out string statusCode, out string statusMessage)
{
string returnCode = string.Empty;
string returnMessage = string.Empty;
var parameter = ServiceInfo.Create(userInfo, MethodBase.GetCurrentMethod());
ServiceUtil.ProcessBusinessDb(userInfo, parameter, (dbHelper) =>
{
if (!DbLogic.Exists(dbHelper, tableName))
{
var manager = new BaseItemsManager(dbHelper, userInfo);
// 创建表结构
manager.CreateTable(tableName, out returnCode);
returnMessage = manager.GetStateMessage(returnCode);
}
});
statusCode = returnCode;
statusMessage = returnMessage;
}
/// <summary>
/// 创建数据表
/// </summary>
/// <param name="userInfo">用户</param>
/// <param name="tableName">表名</param>
/// <param name="statusCode">状态返回码</param>
/// <param name="statusMessage">状态返回信息</param>
public void CreateTable(BaseUserInfo userInfo, string tableName, out string statusCode, out string statusMessage)
{
string returnCode = string.Empty;
string returnMessage = string.Empty;
var parameter = ServiceInfo.Create(userInfo, MethodBase.GetCurrentMethod());
ServiceUtil.ProcessUserCenterWriteDb(userInfo, parameter, (dbHelper) =>
{
// 20130602 JiRiGaLa 改进是否表存在
if (!DbLogic.Exists(dbHelper, tableName))
{
BaseItemsManager itemsManager = new BaseItemsManager(dbHelper, userInfo);
// 创建表结构
itemsManager.CreateTable(tableName, out returnCode);
returnMessage = itemsManager.GetStateMessage(returnCode);
}
});
statusCode = returnCode;
statusMessage = returnMessage;
}
public virtual bool Exists(List <KeyValuePair <string, object> > parameters, object id = null)
{
return(DbLogic.Exists(DbHelper, this.CurrentTableName, parameters, new KeyValuePair <string, object>(this.PrimaryKey, id)));
}
