public IEnumerable <jmp_statistics> FindPagedListByAgent(int userid, string orderBy, string stime, string etime, string a_name) { var where = new List <string>(); if (!string.IsNullOrEmpty(stime)) { where.Add("convert(varchar(10),a.s_time,120)>='" + stime + "' "); } if (!string.IsNullOrEmpty(etime)) { where.Add(" convert(varchar(10),a.s_time,120)<='" + etime + "' "); } if (a_name != "所有应用") { where.Add("b.a_name ='" + a_name + "'"); } where.Add("c.relation_type=" + (int)Relationtype.Agent + ""); where.Add("c.relation_person_id='" + userid + "'"); return(_repository.FindListBySql(string.Join(" AND ", where), "")); }