public static string GetKnowledge(string SubjectID, string ClassID, string key, string KPScoreAvgRate, string DateType, string DateData, string TeacherID, int PageSize, int PageIndex) { try { SubjectID = SubjectID.Filter(); ClassID = ClassID.Filter(); key = key.Filter(); KPScoreAvgRate = KPScoreAvgRate.Filter(); DateData = DateData.Filter(); HttpContext.Current.Session["StatsClassSubject"] = SubjectID; string strWhere = "TeacherID ='" + TeacherID + "' "; if (!string.IsNullOrEmpty(SubjectID)) { strWhere += " and SubjectID = '" + SubjectID + "'"; } if (!string.IsNullOrEmpty(ClassID)) { strWhere += " and ClassID = '" + ClassID + "'"; } if (!string.IsNullOrEmpty(key)) { strWhere += " and KPName like '%" + key.TrimEnd() + "%'"; } if (!string.IsNullOrEmpty(KPScoreAvgRate)) { strWhere += " and KPScoreAvgRate < " + KPScoreAvgRate + ""; } if (!string.IsNullOrEmpty(DateType)) { strWhere += " and DateType = '" + DateType + "'"; } if (!string.IsNullOrEmpty(DateData)) { strWhere += " and DateData = '" + DateData + "'"; } Model_F_User loginUser = HttpContext.Current.Session["FLoginUser"] as Model_F_User; //strWhere += StatsCommonHandle.GetStrWhereBySelfClassForTeacherData(SubjectID); DataTable dt = new DataTable(); int intRecordCount = 0; List <object> listReturn = new List <object>(); int inum = 1; //if (string.IsNullOrEmpty(ClassID))//全部班级 暂时不从老师表取数据 //{ // BLL_StatsTeacherHW_KPInData bll = new BLL_StatsTeacherHW_KPInData(); // dt = bll.GetListByPage(strWhere, "StatsTeacherHW_KPInDataID", ((PageIndex - 1) * PageSize + 1), PageIndex * PageSize).Tables[0]; // intRecordCount = bll.GetRecordCount(strWhere); // string temp = string.Empty; // for (int i = 0; i < dt.Rows.Count; i++) // { // listReturn.Add(new // { // SubjectID = dt.Rows[i]["SubjectID"].ToString(), // SubjectName = dt.Rows[i]["SubjectName"].ToString(), // KPName = dt.Rows[i]["KPName"].ToString(), // KPScoreAvgRate = (!string.IsNullOrEmpty(dt.Rows[i]["KPScoreAvgRate"].ToString())) ? dt.Rows[i]["KPScoreAvgRate"].ToString() + "%" : "-", // DateData = dt.Rows[i]["DateData"].ToString(), // DateType = dt.Rows[i]["DateType"].ToString() // }); // inum++; // } //} //else //{ BLL_StatsClassHW_KPInData bll = new BLL_StatsClassHW_KPInData(); dt = bll.GetListByPage(strWhere, "ClassName,DateData desc", ((PageIndex - 1) * PageSize + 1), PageIndex * PageSize).Tables[0]; intRecordCount = bll.GetRecordCount(strWhere); string temp = string.Empty; for (int i = 0; i < dt.Rows.Count; i++) { listReturn.Add(new { SubjectID = dt.Rows[i]["SubjectID"].ToString(), SubjectName = dt.Rows[i]["SubjectName"].ToString(), ClassID = dt.Rows[i]["ClassID"].ToString(), ClassName = dt.Rows[i]["ClassName"].ToString(), KPName = dt.Rows[i]["KPName"].ToString(), KPNameEncode = Rc.Common.DBUtility.DESEncrypt.Encrypt(dt.Rows[i]["KPName"].ToString()), KPScoreAvgRate = (!string.IsNullOrEmpty(dt.Rows[i]["KPScoreAvgRate"].ToString())) ? dt.Rows[i]["KPScoreAvgRate"].ToString().clearLastZero() + "%" : "-", DateData = dt.Rows[i]["DateData"].ToString(), DateType = dt.Rows[i]["DateType"].ToString(), TeacherId = dt.Rows[i]["TeacherId"].ToString(), IsTeacherData = loginUser.UserId == TeacherID ? "" : "1" }); 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 GetKnowledge(string Gradeid, string SubjectID, string ClassID, string key, string KPScoreAvgRate, string DateType, string DateData, int PageSize, int PageIndex) { try { Gradeid = Gradeid.Filter(); SubjectID = SubjectID.Filter(); ClassID = ClassID.Filter(); key = key.Filter(); KPScoreAvgRate = KPScoreAvgRate.Filter(); DateData = DateData.Filter(); HttpContext.Current.Session["StatsGradeSubject"] = SubjectID; string strWhere = "1=1"; if (!string.IsNullOrEmpty(Gradeid)) { strWhere += " and Gradeid = '" + Gradeid + "'"; } if (!string.IsNullOrEmpty(SubjectID)) { strWhere += " and SubjectID = '" + SubjectID + "'"; } if (!string.IsNullOrEmpty(ClassID)) { strWhere += " and ClassID = '" + ClassID + "'"; } if (!string.IsNullOrEmpty(key)) { strWhere += " and KPName like '%" + key + "%'"; } if (!string.IsNullOrEmpty(KPScoreAvgRate)) { strWhere += " and KPScoreAvgRate < " + KPScoreAvgRate + ""; } if (!string.IsNullOrEmpty(DateType)) { strWhere += " and DateType = '" + DateType + "'"; } if (!string.IsNullOrEmpty(DateData)) { strWhere += " and DateData = '" + DateData + "'"; } DataTable dt = new DataTable(); BLL_StatsClassHW_KPInData bll = new BLL_StatsClassHW_KPInData(); dt = bll.GetListByPage(strWhere, "StatsClassHW_KPInDataID ASC", ((PageIndex - 1) * PageSize + 1), PageIndex * PageSize).Tables[0]; int intRecordCount = bll.GetRecordCount(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 { GradeID = dt.Rows[i]["Gradeid"], GradeName = dt.Rows[i]["GradeName"].ToString(), SubjectID = dt.Rows[i]["SubjectID"].ToString(), SubjectName = dt.Rows[i]["SubjectName"].ToString(), ClassID = dt.Rows[i]["ClassID"].ToString(), ClassName = dt.Rows[i]["ClassName"].ToString(), KPName = dt.Rows[i]["KPName"].ToString(), KPNameEncode = Rc.Common.DBUtility.DESEncrypt.Encrypt(dt.Rows[i]["KPName"].ToString()), KPScoreAvgRate = (!string.IsNullOrEmpty(dt.Rows[i]["KPScoreAvgRate"].ToString())) ? dt.Rows[i]["KPScoreAvgRate"].ToString().clearLastZero() + "%" : "-", DateData = dt.Rows[i]["DateData"].ToString(), DateType = dt.Rows[i]["DateType"].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() })); } }