public int delete(Role_Detail role_Detail)
{
db.Connection.Open();
var result = db.Connection.Execute(StoreProcedureNames.Role_Detail.Delete, new { Id_Role = role_Detail.id_Role, Id_Allowed_Action = role_Detail.id_Allowed_Action, Id_Sec_Object = role_Detail.id_Sec_Object }, commandType: CommandType.StoredProcedure);
db.Connection.Close();
return(result);
}
/// <summary>
/// 增加
/// </summary>
/// <param name="Role_Detail">Role_Detail实体对象</param>
/// <returns>int值,返回自增ID</returns>
public int addReturnId(Role_Detail model)
{
SqlParameter[] param = new SqlParameter[]
{
new SqlParameter ("@User_ID",model.User_ID),
new SqlParameter ("@Roles_ID",model.Roles_ID)
};
return Convert.ToInt32(Helper.ExecuteScalar ("Role_Detail_AddReturnId",param));
}
/// <summary>
/// 增加
/// </summary>
/// <param name="Role_Detail">Role_Detail实体对象</param>
/// <returns>bool值,判断是否操作成功</returns>
public bool add(Role_Detail model)
{
SqlParameter[] param = new SqlParameter[]
{
new SqlParameter ("@User_ID",model.User_ID),
new SqlParameter ("@Roles_ID",model.Roles_ID)
};
return Helper.ExecuteNonQuery("Role_Detail_Add",param);
}
public ActionResult <object> Update(Role_Detail role_Detail)
{
AppDB db = provider.GetRequiredService <AppDB>();
Role_DetailDA role_DetailDA = new Role_DetailDA(db);
var res = role_DetailDA.update(role_Detail);
return(new
{
result = res
});
}
/// <summary>
/// 查看全部
/// </summary>
/// <returns>list集合</returns>
public List<Role_Detail> selectAll()
{
List<Role_Detail> list = new List<Role_Detail>();
Role_Detail model = null;
using (SqlDataReader dr = Helper.ExecuteReader("Role_Detail_SelectAll", null))
{
while (dr.Read())
{
model = new Role_Detail();
model.RolesDet_ID = dr["RolesDet_ID"].ToString();
if (DBNull.Value!=dr["User_ID"])
model.User_ID = dr["User_ID"].ToString();
if (DBNull.Value!=dr["Roles_ID"])
model.Roles_ID = dr["Roles_ID"].ToString();
list.Add(model);
}
}
return list;
}
/// <summary>
/// 通过条件查询
/// </summary>
/// <param name="WhereString">查询条件</param>
/// <returns>Role_Detail实体类对象</returns>
public List<Role_Detail> selectByWhere(string WhereString)
{
SqlParameter[] param = new SqlParameter[]
{
new SqlParameter ("@where",WhereString)
};
List<Role_Detail> list = new List<Role_Detail>();
Role_Detail model = null;
using (SqlDataReader dr = Helper.ExecuteReader("Role_Detail_SelectByWhere", param))
{
while (dr.Read())
{
model = new Role_Detail();
model.RolesDet_ID = dr["RolesDet_ID"].ToString();
if (DBNull.Value!=dr["User_ID"])
model.User_ID = dr["User_ID"].ToString();
if (DBNull.Value!=dr["Roles_ID"])
model.Roles_ID = dr["Roles_ID"].ToString();
list.Add(model);
}
}
return list;
}
/// <summary>
/// 通过Id查询
/// </summary>
/// <param name="Id">主键Id</param>
/// <returns>Role_Detail实体类对象</returns>
public Role_Detail selectById(int Id)
{
SqlParameter[] param = new SqlParameter[]
{
new SqlParameter ("@RolesDet_ID",Id)
};
Role_Detail model = new Role_Detail();
using (SqlDataReader dr = Helper.ExecuteReader("Role_Detail_SelectById", param))
{
if (dr.Read())
{
model.RolesDet_ID = dr["RolesDet_ID"].ToString();
if (DBNull.Value!=dr["User_ID"])
model.User_ID = dr["User_ID"].ToString();
if (DBNull.Value!=dr["Roles_ID"])
model.Roles_ID = dr["Roles_ID"].ToString();
}
}
return model;
}