62,244
社区成员




projectadminEntitie _ctx = new projectadminEntitie();
LinqToDataTable toDataTable = new LinqToDataTable();
public DataTable GetFirst(Hashtable ht,out int count)
{
string projectno = ht["Projectno"].ToString();
string projectname = ht["projectname"].ToString();
string flg = ht["flg"].ToString();
int pageIndex = Convert.ToInt32(ht["page"].ToString());
int pageSize = Convert.ToInt32(ht["rows"].ToString());
var result = from p in _ctx.P_ProjectClass
where (string.IsNullOrEmpty(projectno) ? true : p.projectID.Trim().Equals(projectno))
&& (string.IsNullOrEmpty(projectno) ? true : p.projectID.Trim().Equals(projectno))
&& (p.classID == 1)
select new
{
ID = p.ID,
ProjectID = p.projectID,
ProjectName = p.projectname,
ProjectHead = p.HeadName
};
count = result.Count();
return toDataTable.ToDataTable(result.ToList());
}
list.Skip(10).Take(10)
var result = from p in _ctx.P_ProjectClass
where (string.IsNullOrEmpty(projectno) ? true : p.projectID.Trim().Equals(projectno))
&& (string.IsNullOrEmpty(projectno) ? true : p.projectID.Trim().Equals(projectno))
&& (p.classID == 1)
select new
{
ID = p.ID,
ProjectID = p.projectID,
ProjectName = p.projectname,
ProjectHead = p.HeadName
};
count = result.Count();
var list= qList.ToPagedList(1, 2);
list.Items.ToList(); //这个是list集合