/// <summary> /// 获取列表 /// </summary> public ActionResult GetDataGridJsonV(string userID) { SplitPage s = new SplitPage() { Conditions = new Conditions[] { new Conditions() { Key = "userID", Value = userID } } }; s.sort = "CreateDate"; s.order = "desc"; int total = 0; string sqlw = SxSqlHelperBLL.getSqlw(s); System.Data.DataTable dt = new System.Data.DataTable(); SxSqlHelperBLL.getPageDataEasyUi(sqlw, "Base_Person", s, ref total, ref dt); if (!TB.CheckTB(dt)) { dt = new System.Data.DataTable(); } var jsonData = new { rows = dt, total = total }; return(ToJsonResult(jsonData)); }
/// <summary> /// 获取列表 /// </summary> public ActionResult GetDataGridJsonV(int?typeX) { SplitPage splitPage = new SplitPage() { Conditions = new Conditions[] { new Conditions() { Key = "isnull(isOK,-1)", Value = typeX.ToStringV() } } }; splitPage.order = "desc"; splitPage.sort = "createDate"; string sqlw = SxSqlHelperBLL.getSqlw(splitPage); int total = 0; System.Data.DataTable dt = new System.Data.DataTable(); SxSqlHelperBLL.getPageDataEasyUi(sqlw, "CR_CreditMoney", splitPage, ref total, ref dt); if (!TB.CheckTB(dt)) { dt = new System.Data.DataTable(); } var jsonData = new { rows = dt, total = total }; return(ToJsonResult(jsonData)); }
/// <summary> /// 获取列表 /// </summary> /// <param name="splitPage">分页参数</param> /// <returns></returns> public ActionResult GetDataGridJson(SplitPage splitPage) { string sqlw = SxSqlHelperBLL.getSqlw(splitPage); int total = 0; System.Data.DataTable dt = new System.Data.DataTable(); SxSqlHelperBLL.getPageDataEasyUi(sqlw, "Base_Person", splitPage, ref total, ref dt); if (!TB.CheckTB(dt)) { dt = new System.Data.DataTable(); } var jsonData = new { rows = dt, total = total }; return(ToJsonResult(jsonData)); }