/// <summary> /// 删除 /// </summary> /// <param name="id">主键</param> /// <returns>影响行数</returns> public int Delete(string id) { int returnValue = 0; PiStaffEntity staffEntity = this.GetEntity(id); if (!string.IsNullOrEmpty(staffEntity.UserId)) { // 删除角色用户关联表 returnValue += DbCommonLibary.Delete(DBProvider, PiUserRoleTable.TableName, PiUserRoleTable.FieldUserId, staffEntity.UserId); // 删除用户的权限数据 // 删除用户的权限范围数据 // 删除相关的用户数据 PiUserManager userManager = new PiUserManager(DBProvider, UserInfo); returnValue += userManager.DeleteEntity(staffEntity.UserId); } //删除员工组织关系关联表 returnValue += DbCommonLibary.Delete(DBProvider, PiStaffOrganizeTable.TableName, PiStaffOrganizeTable.FieldStaffId, id); // 删除员工本表 returnValue += DbCommonLibary.Delete(DBProvider, PiStaffTable.TableName, PiStaffTable.FieldId, id); return(returnValue); }
/// <summary> /// 删除实体 /// </summary> /// <param name="id">主键</param> /// <returns>影响行数</returns> public int Delete(string id) { int returnValue = 0; // 删除用户角色表 returnValue += DbCommonLibary.Delete(DBProvider, PiUserRoleTable.TableName, PiUserRoleTable.FieldRoleId, id); // 删除角色表 var parameters = new List <KeyValuePair <string, object> > { new KeyValuePair <string, object>(PiRoleTable.FieldId, id), new KeyValuePair <string, object>(PiRoleTable.FieldAllowDelete, 1) }; returnValue += DbCommonLibary.Delete(DBProvider, PiRoleTable.TableName, parameters); return(returnValue); }
public virtual int Delete(params KeyValuePair <string, object>[] parameters) { List <KeyValuePair <string, object> > parametersList = parameters.ToList(); return(DbCommonLibary.Delete(DBProvider, this.CurrentTableName, parametersList)); }
public virtual int Delete(string[] names, object[] values, bool force) { // 这个函数需要覆盖 return(DbCommonLibary.Delete(DBProvider, this.CurrentTableName, names, values)); }
public virtual int Delete(string name, object[] values) { return(DbCommonLibary.Delete(DBProvider, this.CurrentTableName, name, values)); }
public virtual int Delete(object[] ids, bool force) { // 这个函数需要覆盖 return(DbCommonLibary.Delete(DBProvider, this.CurrentTableName, BusinessLogic.FieldId, ids)); }
public virtual int Delete(string name1, object value1, string name2, object value2, bool force) { // 这个函数需要覆盖 return(DbCommonLibary.Delete(DBProvider, this.CurrentTableName, name1, value1, name2, value2)); }
// // 删除数据部分 // force 是否强制删除关联数据 // public virtual int Delete() { return(DbCommonLibary.Delete(DBProvider, this.CurrentTableName)); }
public virtual int Delete(List <KeyValuePair <string, object> > parameters) { return(DbCommonLibary.Delete(DBProvider, this.CurrentTableName, parameters)); }