/// <summary>
/// 更新角色
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public bool Update(SeatManage.ClassModel.SysRolesDicInfo model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update SysRolesDic set ROLENAME=@ROLENAME, IsLock=@IsLock");
strSql.Append(" where ROLEID=@ROLEID");
SqlParameter[] parameters = new SqlParameter[3];
parameters[0] = new SqlParameter("@ROLEID", model.RoleID);
parameters[1] = new SqlParameter("@RoleName", model.RoleName);
parameters[2] = new SqlParameter("@IsLock", model.IsLock);
try
{
int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
catch (Exception e)
{
throw e;
}
}
/// <summary>
/// 删除角色
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public bool Delete(SeatManage.ClassModel.SysRolesDicInfo model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("delete SysRolesDic");
strSql.Append(" where ROLEID=@ROLEID");
SqlParameter[] parameters = new SqlParameter[1];
parameters[0] = new SqlParameter("@ROLEID", model.RoleID);
try
{
int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
catch (Exception e)
{
throw e;
}
}
/// <summary>
/// 添加角色
/// </summary>
/// <returns></returns>
public int Add(SeatManage.ClassModel.SysRolesDicInfo model)
{
SqlParameter[] parameters = new SqlParameter[3];
parameters[0] = new SqlParameter("@RoleID", SqlDbType.Int);
parameters[0].Direction = ParameterDirection.Output;
parameters[1] = new SqlParameter("@RoleName", model.RoleName);
parameters[2] = new SqlParameter("@IsLock", model.IsLock);
try
{
DbHelperSQL.Execute_Proc("Proc_AddRole", parameters);
return(int.Parse(parameters[0].Value.ToString()));
}
catch (Exception e)
{
throw e;
}
}