public virtual bool Exists(KeyValuePair <string, object> parameter, object id)
{
List <KeyValuePair <string, object> > parameters = new List <KeyValuePair <string, object> > {
parameter
};
return(DbCommonLibary.Exists(DBProvider, this.CurrentTableName, parameters, new KeyValuePair <string, object>(this.PrimaryKey, id)));
}
public virtual bool Exists(KeyValuePair <string, object> parameter1, KeyValuePair <string, object> parameter2)
{
List <KeyValuePair <string, object> > parameters = new List <KeyValuePair <string, object> >
{
parameter1,
parameter2
};
return(DbCommonLibary.Exists(DBProvider, this.CurrentTableName, parameters));
}
/// <summary>
/// 用户添加之前执行的方法
/// </summary>
/// <param name="userEntity">用户实体</param>
/// <param name="statusCode">状态码</param>
public void BeforeAdd(PiUserEntity userEntity, out string statusCode)
{
statusCode = StatusCode.OK.ToString();
if (!string.IsNullOrEmpty(userEntity.UserName) && this.Exists(PiUserTable.FieldUserName, userEntity.UserName, PiUserTable.FieldDeleteMark, "0") || DbCommonLibary.Exists(DBProvider, PiStaffTable.TableName, PiStaffTable.FieldUserName, userEntity.UserName, PiStaffTable.FieldDeleteMark, "0"))
{
// 用户名已重复
statusCode = StatusCode.ErrorUserExist.ToString();
}
else
{
// 检查编号是否重复
if (!string.IsNullOrEmpty(userEntity.Code) && this.Exists(PiUserTable.FieldCode, userEntity.Code, PiUserTable.FieldDeleteMark, "0"))
{
// 编号已重复
statusCode = StatusCode.ErrorCodeExist.ToString();
}
if (userEntity.IsStaff == 1)
{
var parameters = new List <KeyValuePair <string, object> >
{
new KeyValuePair <string, object>(PiStaffTable.FieldUserName, userEntity.UserName),
new KeyValuePair <string, object>(PiStaffTable.FieldDeleteMark, 0)
};
if (DbCommonLibary.Exists(DBProvider, PiStaffTable.TableName, parameters))
{
// 编号已重复
statusCode = StatusCode.ErrorNameExist.ToString();
}
if (!string.IsNullOrEmpty(userEntity.Code))
{
parameters = new List <KeyValuePair <string, object> >
{
new KeyValuePair <string, object>(PiStaffTable.FieldCode, userEntity.Code),
new KeyValuePair <string, object>(PiStaffTable.FieldDeleteMark, 0)
};
if (DbCommonLibary.Exists(DBProvider, PiStaffTable.TableName, parameters))
{
// 编号已重复
statusCode = StatusCode.ErrorCodeExist.ToString();
}
}
}
}
}
/// <summary>
/// 判断用户是否有有相应的权限
/// </summary>
/// <param name="userId">用户主键</param>
/// <param name="permissionItemCode">权限编号</param>
/// <returns>有权限</returns>
public bool CheckPermission(string userId, string permissionItemCode)
{
PiPermissionItemManager permissionItemManager = new PiPermissionItemManager(DBProvider);
string permissionItemId = permissionItemManager.GetIdByCode(permissionItemCode);
// 没有找到相应的权限
if (String.IsNullOrEmpty(permissionItemId))
{
return(false);
}
string[] names = new string[3];
string[] values = new string[3];
names[0] = PiPermissionTable.FieldResourceCategory;
values[0] = PiUserTable.TableName;
names[1] = PiPermissionTable.FieldResourceId;
values[1] = userId;
names[2] = PiPermissionTable.FieldEnabled;
values[2] = "1";
return(DbCommonLibary.Exists(DBProvider, this.CurrentTableName, names, values));
}
public virtual bool Exists(params KeyValuePair <string, object>[] parameters)
{
List <KeyValuePair <string, object> > parametersList = parameters.ToList();
return(DbCommonLibary.Exists(DBProvider, this.CurrentTableName, parametersList));
}
public virtual bool Exists(string[] names, object[] values, object id)
{
return(DbCommonLibary.Exists(DBProvider, this.CurrentTableName, names, values, this.PrimaryKey, id));
}
public virtual bool Exists(string name1, object value1, string name2, object value2, object id)
{
return(DbCommonLibary.Exists(DBProvider, this.CurrentTableName, name1, value1, name2, value2, this.PrimaryKey, id));
}
public virtual bool Exists(string name, object value)
{
return(DbCommonLibary.Exists(DBProvider, this.CurrentTableName, name, value));
}
public virtual bool Exists(object[] ids)
{
return(DbCommonLibary.Exists(DBProvider, this.CurrentTableName, this.PrimaryKey, ids));
}
