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