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()
}));
}
}