예제 #1
0
    protected void Page_Load(object sender, EventArgs e)
    {
        this.RequirePermission(Affinity.RolePermission.AdminSystem);
        this.RequirePermission(Affinity.RolePermission.AffinityManager);
        this.Master.SetLayout("Manage Companies", MasterPage.LayoutStyle.ContentOnly);

        Affinity.Companys        cps  = new Affinity.Companys(this.phreezer);
        Affinity.CompanyCriteria crit = new Affinity.CompanyCriteria();
        crit.AppendToOrderBy("Name");

        cps.Query(crit);

        cGrid.DataSource = cps;
        cGrid.DataBind();
    }
예제 #2
0
    public string[] GetCompanies(string prefixText, int count)
    {
        Phreezer phreezer = new Phreezer(ConfigurationManager.ConnectionStrings["DBConn"].ConnectionString);

        Affinity.Companys        cs = new Affinity.Companys(phreezer);
        Affinity.CompanyCriteria cc = new Affinity.CompanyCriteria();
        cc.NameBeginsWith = prefixText;
        cc.AppendToOrderBy("Name");
        cc.MaxResults = count;

        cs.Query(cc);
        string[] returnval = new string[cs.Count];

        int i = 0;

        foreach (Affinity.Company c in cs)
        {
            returnval[i++] = c.Name;
        }

        phreezer.Close();

        return(returnval);
    }