public static string GetList(string TeacherId, string DateType, string DateData, int PageSize, int PageIndex) { try { TeacherId = TeacherId.Filter(); DateType = DateType.Filter(); DateData = DateData.Filter(); string strWhere = " 1=1 "; if (!string.IsNullOrEmpty(TeacherId)) { strWhere += " AND t.user_id = '" + TeacherId + "'"; } if (!string.IsNullOrEmpty(DateType)) { switch (DateType) { case "day": strWhere += " and CONVERT(varchar(10),t.open_time,120)='" + DateData + "'"; break; case "week": strWhere += " and dbo.f_GetDatePartWeek(CONVERT(varchar(10),t.open_time,120))='" + DateData + "'"; break; case "month": strWhere += " and CONVERT(varchar(7),t.open_time,120)='" + DateData + "'"; break; } } DataTable dt = new DataTable(); BLL_visit_client_s bll = new BLL_visit_client_s(); dt = bll.GetListByPageDetail(strWhere, " t.open_time desc", ((PageIndex - 1) * PageSize + 1), PageIndex * PageSize).Tables[0]; int intRecordCount = bll.GetRecordCountDetail(strWhere); List <object> listReturn = new List <object>(); int inum = 1; string temp = string.Empty; for (int i = 0; i < dt.Rows.Count; i++) { listReturn.Add(new { num = ((PageIndex - 1) * PageSize) + inum, TeacherName = dt.Rows[i]["TeacherName"].ToString(), Resource_Name = dt.Rows[i]["Resource_Name"].ToString().ReplaceForFilter(), open_time = pfunction.ConvertToLongDateTime(dt.Rows[i]["open_time"].ToString(), "MM-dd HH:mm:ss"), //close_time = pfunction.ConvertToLongDateTime(dt.Rows[i]["close_time"].ToString(), "MM-dd HH:mm:ss"), typeName = (dt.Rows[i]["resource_class"].ToString() == Rc.Common.Config.Resource_ClassConst.云资源) ? "云资源" : "自有资源" }); inum++; } if (inum > 1) { return(JsonConvert.SerializeObject(new { err = "null", PageIndex = PageIndex, PageSize = PageSize, TotalCount = intRecordCount, list = listReturn })); } else { return(JsonConvert.SerializeObject(new { err = "暂无数据" })); } } catch (Exception ex) { return(JsonConvert.SerializeObject(new { err = ex.Message.ToString() })); } }
public static string GetList(string GradeID, string DateType, string TeacherName, int PageSize, int PageIndex) { try { GradeID = GradeID.Filter(); //ClassID = ClassID.Filter(); DateType = DateType.Filter(); TeacherName = TeacherName.Filter(); string strWhere = " 1=1 "; if (!string.IsNullOrEmpty(GradeID)) { strWhere += " and TeacherId in ( select userid from VW_UserOnClassGradeSchool where GradeId='" + GradeID + "')"; } //if (!string.IsNullOrEmpty(ClassID)) //{ // strWhere += " AND ClassId = '" + ClassID + "'"; //} if (!string.IsNullOrEmpty(DateType)) { strWhere += " AND DateType = '" + DateType + "'"; } if (!string.IsNullOrEmpty(TeacherName)) { strWhere += " and TeacherName like '%" + TeacherName + "%' "; } DataTable dt = new DataTable(); BLL_visit_client_s bll = new BLL_visit_client_s(); dt = bll.GetListByPageNew(strWhere, " DateData desc,VisitCount_All desc,TeacherName", ((PageIndex - 1) * PageSize + 1), PageIndex * PageSize).Tables[0]; int intRecordCount = bll.GetRecordCountNew(strWhere); List <object> listReturn = new List <object>(); int inum = 1; string temp = string.Empty; for (int i = 0; i < dt.Rows.Count; i++) { listReturn.Add(new { DateType = dt.Rows[i]["DateType"].ToString(), DateData = dt.Rows[i]["DateData"].ToString(), TeacherId = dt.Rows[i]["TeacherId"].ToString(), TeacherName = dt.Rows[i]["TeacherName"].ToString(), TrueName = dt.Rows[i]["TrueName"].ToString(), VisitCount_All = dt.Rows[i]["VisitCount_All"].ToString(), VisitCount_Cloud = dt.Rows[i]["VisitCount_Cloud"].ToString(), VisitCount_Own = dt.Rows[i]["VisitCount_Own"].ToString(), VisitFile_All = dt.Rows[i]["VisitFile_All"].ToString(), VisitFile_Cloud = dt.Rows[i]["VisitFile_Cloud"].ToString(), VisitFile_Own = dt.Rows[i]["VisitFile_Own"].ToString(), TeacherClass = GetTeacherClass(GradeID, dt.Rows[i]["TeacherId"].ToString()), CreateOwnCount_All = dt.Rows[i]["CreateOwnCount_All"].ToString(), CreateOwnCount_Plan = dt.Rows[i]["CreateOwnCount_Plan"].ToString(), CreateOwnCount_TestPaper = dt.Rows[i]["CreateOwnCount_TestPaper"].ToString() }); inum++; } if (inum > 1) { return(JsonConvert.SerializeObject(new { err = "null", PageIndex = PageIndex, PageSize = PageSize, TotalCount = intRecordCount, list = listReturn })); } else { return(JsonConvert.SerializeObject(new { err = "暂无数据" })); } } catch (Exception ex) { return(JsonConvert.SerializeObject(new { err = ex.Message.ToString() })); } }