public string GetFinish(string deptid)
{
string sql = " select departmentid,fullname from base_department where find_in_set(departmentid, fn_recursive('" + deptid + "')) > 0 and nature = '班组';";
DataTable dt = this.BaseRepository().FindTable(sql);
string r = string.Empty;
var m = DateTime.Now.Month;
List <newObj> nlist = new List <newObj>();
newObj n = new newObj();
foreach (DataRow row in dt.Rows)
{
n = new newObj();
sql = "select count(*) from wg_meetingjob where IsFinished ='finish' and month(endtime)='" + m + "' and groupid ='" + row[0].ToString() + "'";
dt = this.BaseRepository().FindTable(sql);
n.Name = row[1].ToString();
n.Number = Convert.ToInt32(dt.Rows[0][0].ToString());
nlist.Add(n);
}
var sortedlist =
(from a in nlist
orderby a.Number descending
select a).ToList();
sortedlist = sortedlist.Take(6).ToList();
foreach (newObj o in sortedlist)
{
r += "{" + string.Format("category:'{0}',value:'{1}'", o.Name, o.Number) + "},";
}
r = string.Format("[{0}]", r.TrimEnd(new char[] { ',' }));
return(r);
}
public DataTable GetMore(string deptid)
{
//Operator user = OperatorProvider.Provider.Current();
//string deptid = user.DeptId;
string sql = " select departmentid,fullname from base_department where find_in_set(departmentid, fn_recursive('" + deptid + "')) > 0 and nature = '班组';";
DataTable dt = this.BaseRepository().FindTable(sql);
string r = string.Empty;
var m = DateTime.Now.Month;
DataTable dt1 = new DataTable();
dt1.Columns.Add("Bz");
dt1.Columns.Add("Num");
//foreach (DataRow row in dt.Rows)
//{
// DataRow newrow = dt1.NewRow();
// sql = "select count(*) from wg_meetingjob where IsFinished ='finish' and month(endtime)='" + m + "' and groupid ='" + row[0].ToString() + "'";
// dt = this.BaseRepository().FindTable(sql);
// newrow[0] = row[1].ToString();
// newrow[1] = Convert.ToInt32(dt.Rows[0][0].ToString());
// dt1.Rows.Add(newrow);
//}
List <newObj> nlist = new List <newObj>();
newObj n = new newObj();
foreach (DataRow row in dt.Rows)
{
n = new newObj();
sql = "select count(*) from wg_meetingjob where IsFinished ='finish' and month(endtime)='" + m + "' and groupid ='" + row[0].ToString() + "'";
dt = this.BaseRepository().FindTable(sql);
n.Name = row[1].ToString();
n.Number = Convert.ToInt32(dt.Rows[0][0].ToString());
nlist.Add(n);
}
var sortedlist =
(from a in nlist
orderby a.Number descending
select a).ToList();
foreach (newObj o in sortedlist)
{
DataRow newrow = dt1.NewRow();
newrow[0] = o.Name;
newrow[1] = o.Number;
dt1.Rows.Add(newrow);
}
return(dt1);
}
