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