/// <summary>
/// 插入T_SYS_ROLES
/// </summary>
public virtual bool Insert(RolesOR roles)
{
string sql = "insert into T_SYS_ROLES (GUID, ROLE_NAME, ROLE_DESC) values (@GUID, @ROLE_NAME, @ROLE_DESC)";
SqlParameter[] parameters = new SqlParameter[]
{
new SqlParameter("@GUID", Guid.NewGuid().ToString()),
new SqlParameter("@ROLE_NAME", roles.RoleName),
new SqlParameter("@ROLE_DESC", roles.RoleDesc)
};
return db.ExecuteNoQuery(sql, parameters) > -1;
}
public RolesOR selectARowDate(string m_id)
{
string sql = string.Format("select * from T_SYS_ROLES where GUID='{0}'", m_id);
DataTable dt = null;
try
{
dt = db.ExecuteQueryDataSet(sql).Tables[0];
}
catch (Exception ex)
{
throw ex;
}
if (dt == null)
return null;
if (dt.Rows.Count == 0)
return null;
DataRow dr = dt.Rows[0];
RolesOR m_Role = new RolesOR(dr);
return m_Role;
}
/// <summary>
/// 更新T_SYS_ROLES
/// </summary>
public virtual bool Update(RolesOR roles)
{
string sql = "update T_SYS_ROLES set ROLE_NAME = @ROLE_NAME, ROLE_DESC = @ROLE_DESC where GUID = @GUID";
SqlParameter[] parameters = new SqlParameter[]
{
new SqlParameter("@GUID", SqlDbType.VarChar, 36, ParameterDirection.Input, false, 0, 0, "GUID", DataRowVersion.Default, roles.Guid),
new SqlParameter("@ROLE_NAME", SqlDbType.NVarChar, 128, ParameterDirection.Input, false, 0, 0, "ROLE_NAME", DataRowVersion.Default, roles.RoleName),
new SqlParameter("@ROLE_DESC", SqlDbType.NVarChar, 512, ParameterDirection.Input, false, 0, 0, "ROLE_DESC", DataRowVersion.Default, roles.RoleDesc)
};
return db.ExecuteNoQuery(sql, parameters) > -1;
}
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;
}
