/// <summary>
/// 修改权限
/// </summary>
/// <param name="perMission"></param>
/// <returns></returns>
public int UpdatePerMission(PerMission perMission)
{
using (OracleConnection conn = DapperHelper.GetConnectionString())
{
conn.Open();
string sql = @"update PERMISSION set permissionname=:permissionname,establishtime=:establishtime,uptime=:uptime where permissionid=:permissionid";
int i = conn.Execute(sql, perMission);
return(i);
}
}
/// <summary>
/// 根据ID显示单个权限信息
/// </summary>
/// <param name="id"></param>
/// <returns></returns>
public PerMission GetPerMissionById(int id)
{
using (OracleConnection conn = DapperHelper.GetConnectionString())
{
conn.Open();
string sql = @"select PerMissionID,permissionname,establishtime,uptime from PERMISSION where permissionid=" + id;
PerMission perMission = conn.Query <PerMission>(sql, id).FirstOrDefault();
return(perMission);
}
}
/// <summary>
/// 添加权限
/// </summary>
/// <param name="perMission"></param>
/// <returns></returns>
public int AddPerMission(PerMission perMission)
{
using (OracleConnection conn = DapperHelper.GetConnectionString())
{
conn.Open();
string sql = @"insert into PERMISSION(permissionname,establishtime,uptime) values(:permissionname,:establishtime,:uptime)";
int i = conn.Execute(sql, perMission);
return(i);
}
}
public int UpdatePerMission(PerMission perMission)
{
int i = perMissionServices.UpdatePerMission(perMission);
return(i);
}
public PerMission GetPerMissionById(int id)
{
PerMission perMission = perMissionServices.GetPerMissionById(id);
return(perMission);
}
public int AddPerMission(PerMission perMission)
{
int i = perMissionServices.AddPerMission(perMission);
return(i);
}