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