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); }