예제 #1
0
    public void GVLoad(string id)
    {
        hdnKindid.SetValue(id.ToString());
        var item = from i in dc.Person
                   from d in dc.Department
                   join p in dc.Position on i.Personid equals p.Posid into gg
                   from tt in gg.DefaultIfEmpty()
                   where i.Deptid == d.Deptnumber &&
                   i.Visualfield == 3 && (i.Areadeptid == id || i.Maindeptid == id)
                   //orderby i.Sort
                   select new
        {
            i.Name,
            i.Personnumber,
            Posname = tt.Posname == null?"":tt.Posname,
            d.Deptname,
            i.Visualfield
        };

        ItemStore.DataSource = item;
        ItemStore.DataBind();

        btnJoemNew.Disabled = false;
        //ItemControlSet();

        //JeomSet(-1);
    }
예제 #2
0
    public void GVLoad(int id)
    {
        hdnKindid.SetValue(id.ToString());
        var item = from i in dc.SqsKind
                   where i.Did == id && i.Status == "1"
                   orderby i.Pkindid
                   select new
        {
            i.Fullscore,
            i.Indate,
            i.Pkindid,
            Pkindname = i.Pkindname + "(满分:" + i.Fullscore + ",系数:" + i.Rate + ")",
            i.Status,
            i.Rate
        };

        ItemStore.DataSource = item;
        ItemStore.DataBind();
        ItemControlSet();

        JeomSet(-1, id);
    }
예제 #3
0
    public void GVLoad(int id)
    {
        hdnKindid.SetValue(id.ToString());
        var item = from i in dc.Swlearn
                   where i.Levelid == id && i.Deptnumber == SessionBox.GetUserSession().DeptNumber
                   //orderby i.Sort
                   select new
        {
            i.Lname,
            i.Lid,
            i.Intime,
            i.Nstatus
        };

        ItemStore.DataSource = item;
        ItemStore.DataBind();

        btnJoemNew.Disabled = false;
        //ItemControlSet();

        //JeomSet(-1);
    }
예제 #4
0
    public void GVLoad(int id)
    {
        hdnKindid.SetValue(id.ToString());
        var item = from i in dc.ParItem
                   where i.Pkindid == id && i.Status == "1"
                   orderby i.Sort
                   select new
        {
            i.Fullscore,
            i.Indate,
            i.Itemid,
            Itemname = i.Itemname + "(" + i.Fullscore + ")",
            i.Pkindid,
            i.Sort,
            i.Status,
        };

        ItemStore.DataSource = item;
        ItemStore.DataBind();
        ItemControlSet();

        JeomSet(-1);
    }