//初始化list页面 public override ActionResult GetList() { GridRequest req = new GridRequest(Request); int iCount = req.PageCondition.RowCount; string strSql = Request["strSql"]; // var mq = System.Text.RegularExpressions.Regex.Matches(strSql, @"select (.*?) from (\w*) (where (.*?))? "); string txtConn = Request["txtConn"]; if (strSql.IndexOf("select") == 0) { string sql = @" select top {0} * from ( select row_number() over(order by id) as rownumber,* from ({2}) _a ) A where rownumber > {1}"; sql = string.Format(sql, req.PageCondition.PageSize, Request["start"], strSql); // string list3; string str; using (var db = new SqlSugar.SqlSugarClient(ConfigurationManager.ConnectionStrings[txtConn].ConnectionString)) { // list3 = db.SqlQueryDynamic(sql); if (req.PageCondition.RowCount == 0) { req.PageCondition.RowCount = db.GetInt(string.Format("select count(*) from ({0}) a", strSql)); } str = db.SqlQueryJson(sql); list3 = Newtonsoft.Json.JsonConvert.SerializeObject(new { sEcho = Request["draw"], iTotalRecords = req.PageCondition.RowCount, iTotalDisplayRecords = req.PageCondition.RowCount, aaData = "##" }); str = list3.Replace("\"##\"", str); } return(Content(str, "application/json")); } else { //sql = strSql; // var rep = _BaseService.Repository.SqlExcute(strSql, 1); using (var db = new SqlSugar.SqlSugarClient(ConfigurationManager.ConnectionStrings[txtConn].ConnectionString)) { db.ExecuteCommand(strSql); } return(SuccessNotification("")); } //实现对用户和多条件的分页的查询,rows表示一共多少条,page表示当前第几页 // var list = GetListEx(predicate, req.PageCondition);// _newsService.GetList(null, null, 10, 10); }
public ActionResult GetListFirst() { string strSql = Request["strSql"]; // var mq = System.Text.RegularExpressions.Regex.Matches(strSql, @"select (.*?) from (\w*) (where (.*?))? "); string sql = @"select top 1 * from ( {0}) a"; sql = string.Format(sql, strSql); // dynamic rep = _BaseService.Repository.UnitOfWork.SqlQuery<List<dynamic>>(sql, 1).ToList(); string txtConn = Request["txtConn"]; object list3; string str; List <object> aa; using (var db = new SqlSugar.SqlSugarClient(ConfigurationManager.ConnectionStrings[txtConn].ConnectionString)) { str = db.SqlQueryJson(sql); // list3 = db.SqlQueryDynamic(sql); aa = Newtonsoft.Json.JsonConvert.DeserializeObject <List <object> >(str); } var dd = (aa[0].GetType()).GetProperties(System.Reflection.BindingFlags.NonPublic | System.Reflection.BindingFlags.Public | System.Reflection.BindingFlags.Instance | System.Reflection.BindingFlags.DeclaredOnly)[0]; var ddd = (Collection <JToken>)dd.GetValue(aa[0]); StringBuilder sb = new StringBuilder(); foreach (var dddd in ddd) { dynamic da = dddd; sb.AppendFormat(",{0}", da.Name); } if (!string.IsNullOrEmpty(str)) { return(Content(sb.ToString().Substring(1))); } else { return(Content("")); } //using (SqlConnection connection = new SqlConnection(ConfigurationManager.ConnectionStrings[txtConn].ConnectionString)) //{ // connection.Open(); // brand = connection.Query<dynamic>(sql).ToList(); //} //return Content(str, "application/json"); //return Json(list3, JsonRequestBehavior.AllowGet); // return Content(str); //实现对用户和多条件的分页的查询,rows表示一共多少条,page表示当前第几页 // var list = GetListEx(predicate, req.PageCondition);// _newsService.GetList(null, null, 10, 10); }