/// <summary>
/// 添加管理员角色
/// </summary>
/// <param name="managerRole"></param>
/// <returns>
/// 添加成功: >0
/// 失败 : =0
/// </returns>
public int AddManagerRole(ManagerRole managerRole)
{
int result = 0;
try
{
StringBuilder strSql = new StringBuilder();
strSql.Append(" insert into T_Sys_Log ( RoleName ) values(");
strSql.Append(" @RoleName ");
strSql.Append(" ):select @@IDENTITY");
SqlParameter[] para =
{
new SqlParameter("@RoleName",SqlDbType.NVarChar,100)
};
para[0].Value = managerRole.RoleName;
object obj = SqlHelper.ExecuteScalar(SqlHelper.connString, CommandType.Text, strSql.ToString(), para);
if (obj != null)
{
result = Convert.ToInt32(obj);
}
}
catch (Exception e)
{
Log4Net.LogWrite("err", "Med_DAL:DAL_ManagerRole//AddManagerRole" + e.Message); //发生异常，记录
}
return result;
}
/// <summary>
/// 更新管理员角色信息
/// </summary>
/// <param name="managerRole"></param>
/// <returns>
/// 成功：true
/// 失败：false
/// </returns>
public static bool UpdateManagerRole(ManagerRole managerRole)
{
return DalManagerRole.UpdateManagerRole(managerRole);
}
private static readonly DAL_ManagerRole DalManagerRole = new DAL_ManagerRole(); //实例化
#endregion Fields
#region Methods
/// <summary>
/// 添加管理员角色
/// </summary>
/// <param name="managerRole"></param>
/// <returns>
/// 添加成功: >0
/// 失败 : =0
/// </returns>
public static int AddManagerRole(ManagerRole managerRole)
{
return DalManagerRole.AddManagerRole(managerRole);
}
/// <summary>
/// 更新管理员角色信息
/// </summary>
/// <param name="managerRole"></param>
/// <returns>
/// 成功：true
/// 失败：false
/// </returns>
public bool UpdateManagerRole(ManagerRole managerRole)
{
bool result = false;
try
{
StringBuilder strSql = new StringBuilder();
strSql.Append(" update T_Sys_Role set");
strSql.Append(" RoleName=@RoleName");
SqlParameter[] parameters = {
new SqlParameter("@RoleName", SqlDbType.NVarChar,50)
};
parameters[0].Value = managerRole.RoleName;
if (SqlHelper.ExecuteNonQuery(SqlHelper.connString, CommandType.Text, strSql.ToString(), parameters) == 1) //更改成功 影响条数为1
{
result = true; //更新成功设置为true
}
}
catch (Exception e)
{
Log4Net.LogWrite("err", "Med_DAL:DAL_ManagerRole//UpdateManager" + e.Message); //发生异常，记录
}
return result;
}
