public string GetTeacherList(string TeacherName, string schoolId, string pagecurrent) { string TeacherList = ""; Teacher teacher = new Teacher(); string linkpage = "";// 分页标签 // 初期化时当前页是否为空、若为空默认第一页 if (string.IsNullOrEmpty(pagecurrent)) { pagecurrent = "1"; } // 取得记录集数 int listcount = teacher.GetTeacherListCount(TeacherName, schoolId, "1"); // 分页 MyPages page = new MyPages(); page.subeachnums = Constant.BACKGROUND_RESOURCE_NUM; // 每页显示的条目数 page.subnums = listcount; // 总条目数 page.subcurrentpage = int.Parse(pagecurrent); // 当前被选中的页 page.subeachpages = 10; // 每次显示的页数 page.subpagetype = 2; // 分页样式1:普通模式、2:经典模式 page.subformname = "ActionForm"; // 表单名 linkpage = page.SubPages(); // 生成分页标签 // 删除时的设置 start // 删除操作时如果当前页大于总页数,当前页设为最后一页 if (int.Parse(pagecurrent) > page.subpagenums && page.subpagenums != 0) { pagecurrent = page.subpagenums.ToString(); } List <object> Ret = new List <object>(); Ret = teacher.GetTeacherList(TeacherName, schoolId, page.subeachnums, int.Parse(pagecurrent), "1"); TeacherList = "{\"result\":\"success\",\"list\":" + ToJosn.wxListToJson(Ret) + ",\"linkpage\":\"" + JsonHelper.String2Json(linkpage) + "\"}"; return(TeacherList); }
public ContentResult GetRule(string id) { List <object> Ret = new List <object>(); try { string sql = "SELECT top 1 * FROM Z_PointRule "; DBOperation db = new DBOperation(); DataSet ds = new DataSet(); ds = db.GetDataSet(sql); //保存数据表并返回 Ret.Add(ds); string json = "{\"result\":\"success\",\"list\":" + ToJosn.wxListToJson(Ret) + "}"; return(Content(json)); } catch (Exception ex) { Ret.Add("state:0,msg:获取数据错误!"); return(Content("")); } }