Exemple #1
0
        private void Query(HttpContext context)
        {
            var corName = context.Request["name"].Trim();
            var teaName = context.Request["teaName"].Trim();
            var teaplace = context.Request["teaplace"].Trim();
            var teaTime = context.Request["teaTime"].Trim();
            var ds = new DataSet();
            var courBll = new BLL.Course();
            var strWhere = "";
            if (!string.IsNullOrEmpty(corName))
            {
                strWhere = string.Format(" CourseName like '%" + corName + "%' ");
            }
            if (!string.IsNullOrEmpty(teaName))
            {
                if (!string.IsNullOrEmpty(strWhere))
                {
                    strWhere += string.Format(" and  TeacherName  like '%" + teaName + "%' ");
                }
                else
                {
                    strWhere = string.Format(" TeacherName like '%" + teaName + "%' ");
                }
            }
            if (!string.IsNullOrEmpty(teaplace))
            {
                if (!string.IsNullOrEmpty(strWhere))
                {
                    strWhere += string.Format(" and  TeachPlace  like '%" + teaplace + "%' ");
                }
                else
                {
                    strWhere = string.Format(" TeachPlace like '%" + teaplace + "%' ");
                }
            }
            if (!string.IsNullOrEmpty(teaTime))
            {
                if (!string.IsNullOrEmpty(strWhere))
                {
                    strWhere += string.Format(" and  TeachTime  like '%" + teaTime + "%' ");
                }
                else
                {
                    strWhere = string.Format(" TeachTime like '%" + teaTime + "%' ");
                }
            }

            var page = Convert.ToInt32(context.Request["page"]);
            var rows = Convert.ToInt32(context.Request["rows"]);

            var sort = string.IsNullOrEmpty(context.Request["sort"]) ? "TeachTime" : context.Request["sort"];
            var order = string.IsNullOrEmpty(context.Request["order"]) ? "asc" : context.Request["order"];

            var startIndex = (page - 1)*rows + 1;
            var endIndex = startIndex + rows - 1;

            var num = courBll.GetRecordCount(strWhere);
            ds = courBll.GetListByPage(strWhere, sort, startIndex, endIndex,order);

            var str = JsonConvert.SerializeObject(new {total = num, rows = ds.Tables[0]});
            context.Response.Write(str);
        }
Exemple #2
0
        private string GetData(HttpContext context)
        {
            var ds = new DataSet();
            var courBll = new BLL.Course();

            var page = Convert.ToInt32(context.Request["page"]);
            var rows = Convert.ToInt32(context.Request["rows"]);

            var sort = string.IsNullOrEmpty(context.Request["sort"]) ? "TeachTime" : context.Request["sort"];
            var order = string.IsNullOrEmpty(context.Request["order"]) ? "desc" : context.Request["order"];

            var startIndex = (page - 1) * rows + 1;
            var endIndex = startIndex + rows - 1;

            var num = courBll.GetRecordCount("");
            ds = courBll.GetListByPage("", sort, startIndex, endIndex,order);

            var str = JsonConvert.SerializeObject(new { total = num, rows = ds.Tables[0] });
            return str;
        }