/// <summary>
/// 更新T_SYS_ROLES
/// </summary>
public virtual bool Update(RolesOR roles)
{
string sql = "update T_SYS_ROLE set ROLE_NAME = @ROLE_NAME, ROLE_DESC = @ROLE_DESC where ROLE_ID= @ROLE_ID";
return db.ExecuteNoQuery(sql,
db.GetDataParameter("@ROLE_ID", roles.Guid),
db.GetDataParameter("@ROLE_NAME", roles.RoleName),
db.GetDataParameter("@ROLE_DESC", roles.RoleDesc)) > 0;
}
/// <summary>
/// 插入T_SYS_ROLES
/// </summary>
public virtual bool Insert(RolesOR roles)
{
string sql = "insert into T_SYS_ROLE (ROLE_ID, ROLE_NAME, ROLE_DESC) values (@ROLE_ID, @ROLE_NAME, @ROLE_DESC)";
return db.ExecuteNoQuery(sql,
db.GetDataParameter("@ROLE_ID", Guid.NewGuid().ToString()),
db.GetDataParameter("@ROLE_NAME", roles.RoleName),
db.GetDataParameter("@ROLE_DESC", roles.RoleDesc))>0;
}
private RolesOR setValue()
{
RolesOR T_SY = new RolesOR();
if (Request.QueryString["id"] != null)
T_SY.Guid = Request.QueryString["id"].ToString();
T_SY.RoleName = txtName.Text;//角色名称
T_SY.RoleDesc = txtROLE_DESC.Text;//角色说明
return T_SY;
}