datatable筛选条件_使用Linq操作Datatable，按条件筛选数据，找出数量前10的数据，按字段分组...

public string GetAreaAndPieJson()

{

DataTable dt = new DataTable();

DataTable dt2 =new DataTable();

DataTable dtt2 =new DataTable();

string areapieJson = "";

BaseBLL.MobileBLL mb = new BaseBLL.MobileBLL();

BaseBLL.SMZ smz = new BaseBLL.SMZ();

//如果是点击分公司，来赛选数据，则通过分公司单位编号来查找数据，否则则通过系统缓存来实现

if (Session["deptID"] != "" && Session["deptID"]!=null)

{

dt = mb.GetGDRT_ZCQK2(Session["deptID"].ToString());

dt2 = smz.GetRLJandAllcount(Session["deptID"].ToString());

dtt2 = smz.GetRJCS_Info(Session["deptID"].ToString());

}

else {

dt = mb.GetGDRT_ZCQK2(CondictionInfo.CurrentDWBH);

dt2 = smz.GetRLJandAllcount(CondictionInfo.CurrentDWBH);

dtt2 =