public static string GetStatsClassHW_KP(string Class, string ResourceToResourceFolder_Id, string UserId, string KPName, string KPScoreAvgRate)
{
try
{
Class = Class.Filter();
ResourceToResourceFolder_Id = ResourceToResourceFolder_Id.Filter();
UserId = UserId.Filter();
KPName = KPName.Filter();
KPScoreAvgRate = KPScoreAvgRate.Filter();
string TempDate = string.Empty;
string StrWhere = string.Empty;
string ClassName = string.Empty;
if (!string.IsNullOrEmpty(KPName))
{
StrWhere += " and KPName like '%" + KPName.TrimEnd() + "%'";
}
if (!string.IsNullOrEmpty(KPScoreAvgRate))
{
StrWhere += " and KPScoreAvgRate<" + KPScoreAvgRate.TrimEnd() + "";
}
// string Temp = "<tr><td>数列的极限</td><td>20</td><td>90%</td><td><a href="##">第1题</a><a href="##">第3题</a></td></tr>";
string Temp = "<tr><td>{0}</td><td>{1}</td><td>{2}%</td><td>{3}</td><td><a href='{4}' target='_blank'>查看</a></td></tr>";
string KPNames = string.Empty;
string KPScoreAvgRates = string.Empty;
//name: '一班',data: [83, 78, 98, 93, 56, 84, 65, 104, 91, 83]
DataTable dtTQ_S = new BLL_TestQuestions_Score().GetList("ResourceToResourceFolder_Id='" + ResourceToResourceFolder_Id + "' order by TestQuestions_Num,TestQuestions_OrderNum ").Tables[0];
if (Class == "-1")
{
HttpContext.Current.Session["StatsClassClassId"] = "-1";
BLL_StatsTeacherHW_KP bllTeacherHW_KP = new BLL_StatsTeacherHW_KP();
List <Model_StatsTeacherHW_KP> TeacherHW_KPList = new List <Model_StatsTeacherHW_KP>();
TeacherHW_KPList = bllTeacherHW_KP.GetModelList("TeacherID='" + UserId + "' and ResourceToResourceFolder_Id='" + ResourceToResourceFolder_Id + "'" + StrWhere + " order by TestQuestionNums ");
foreach (var item in TeacherHW_KPList)
{
TempDate += string.Format(Temp
, item.KPName
, item.KPScoreSum.ToString().clearLastZero()
, item.KPScoreAvgRate.ToString().clearLastZero()
, GetTQNum(dtTQ_S, item.KPName, item.ResourceToResourceFolder_Id, item.TestQuestionNumStrs, item.TestQuestionNums)
, "HisKlgAnalysisSource.aspx?SubjectID=" + item.SubjectID + "&ClassID=&KPName=" + Rc.Common.DBUtility.DESEncrypt.Encrypt(item.KPName.ToString()) + "&DateData=&DateType=month&TeacherId=" + item.TeacherID
);
KPScoreAvgRates += item.KPScoreAvgRate.ToString().clearLastZero() + ",";
KPNames += item.KPName + ",";
}
if (TempDate == "")
{
return("");
}
else
{
return(TempDate + "|全部班级|" + KPScoreAvgRates.TrimEnd(',') + "|" + KPNames.TrimEnd(','));
}
}
else
{
HttpContext.Current.Session["StatsClassClassId"] = Class;
BLL_StatsClassHW_KP bllClassHW_KP = new BLL_StatsClassHW_KP();
List <Model_StatsClassHW_KP> ClassHW_KPList = new List <Model_StatsClassHW_KP>();
ClassHW_KPList = bllClassHW_KP.GetModelList("ClassID='" + Class + "' and ResourceToResourceFolder_Id='" + ResourceToResourceFolder_Id + "' " + StrWhere + " order by TestQuestionNums ");
foreach (var item in ClassHW_KPList)
{
TempDate += string.Format(Temp
, item.KPName
, item.KPScoreSum.ToString().clearLastZero()
, item.KPScoreAvgRate.ToString().clearLastZero()
, GetTQNum(dtTQ_S, item.KPName, item.ResourceToResourceFolder_Id, item.TestQuestionNumStrs, item.TestQuestionNums)
, "HisKlgAnalysisSource.aspx?SubjectID=" + item.SubjectID + "&ClassID=" + item.ClassID + "&KPName=" + Rc.Common.DBUtility.DESEncrypt.Encrypt(item.KPName.ToString()) + "&DateData=" + pfunction.ConvertToLongDateTime(item.HomeWorkCreateTime.ToString(), "yyyy-MM") + "&DateType=month&TeacherId=" + item.TeacherID
);
KPScoreAvgRates += item.KPScoreAvgRate.ToString().clearLastZero() + ",";
KPNames += item.KPName + ",";
ClassName = item.ClassName;
}
if (TempDate == "")
{
return("");
}
else
{
return(TempDate + "|" + ClassName + "|" + KPScoreAvgRates.TrimEnd(',') + "|" + KPNames.TrimEnd(','));
}
}
}
catch (Exception)
{
return("");
}
}
public static string GetHWList(string TeacherID, string SubjectID, string ClassID, string KPName, string DateData, string DateType)
{
try
{
TeacherID = TeacherID.Filter();
SubjectID = SubjectID.Filter();
ClassID = ClassID.Filter();
KPName = KPName = Rc.Common.DBUtility.DESEncrypt.Decrypt(KPName);
DateData = DateData.Filter();
DateType = DateType.Filter();
string strWhere = "TeacherID ='" + TeacherID + "'";
if (!string.IsNullOrEmpty(SubjectID))
{
strWhere += " AND SubjectID ='" + SubjectID + "'";
}
if (!string.IsNullOrEmpty(ClassID))
{
strWhere += " AND ClassID ='" + ClassID + "'";
}
if (!string.IsNullOrEmpty(KPName))
{
strWhere += " AND KPName ='" + KPName + "'";
}
if (!string.IsNullOrEmpty(DateData))
{
switch (DateType)
{
case "month":
strWhere += " AND CONVERT(varchar(7),HomeWorkCreateTime,120)='" + DateData + "'";
break;
case "halfyear":
strWhere += " AND dbo.[f_GetDatePartHalfYear](CONVERT(varchar(10),HomeWorkCreateTime,120))='" + DateData + "'";
break;
case "quarter":
strWhere += " AND dbo.[f_GetDatePartQuarter](CONVERT(varchar(10),HomeWorkCreateTime,120))='" + DateData + "'";
break;
}
}
DataTable dt = new DataTable();
if (string.IsNullOrEmpty(ClassID))//从老师表读取数据
{
dt = new BLL_StatsTeacherHW_KP().GetList(strWhere + " ORDER BY Resource_Name DESC").Tables[0];
}
else
{
dt = new BLL_StatsClassHW_KP().GetList(strWhere + " ORDER BY HomeWorkCreateTime DESC").Tables[0];
}
List <object> listReturn = new List <object>();
int inum = 1;
string temp = string.Empty;
string strxAxis = string.Empty;
string strSeries = string.Empty;
for (int i = 0; i < dt.Rows.Count; i++)
{
DataTable dtTQ_S = new BLL_TestQuestions_Score().GetList("ResourceToResourceFolder_Id='" + dt.Rows[i]["ResourceToResourceFolder_Id"] + "' and ContentText='" + KPName + "' order by TestQuestions_Num,TestQuestions_OrderNum ").Tables[0];
string TQNums = string.Empty;
string TQStr = dt.Rows[i]["TestQuestionNumStrs"].ToString();
string TQNumsStr = dt.Rows[i]["TestQuestionNums"].ToString();
if (!string.IsNullOrEmpty(TQStr))
{
string[] strArr = TQStr.Split(',');
string[] strNumArr = TQNumsStr.Split(',');
for (int j = 0; j < strArr.Length; j++)
{
string testIndex = string.Empty;
if (dtTQ_S.Rows.Count > 0 && (dtTQ_S.Rows[j]["TestType"].ToString() == "clozeTest" || dtTQ_S.Rows[j]["TestType"].ToString() == "fill"))
{
testIndex = string.IsNullOrEmpty(dtTQ_S.Rows[j]["testIndex"].ToString()) ? "" : "-" + dtTQ_S.Rows[j]["testIndex"].ToString();
}
TQNums += string.Format("<a href='../teacher/HomeworkPreviewT.aspx?ResourceToResourceFolder_Id={0}#{2}' target=\"_blank\">第{1}题", dt.Rows[i]["ResourceToResourceFolder_Id"].ToString()
, strArr[j].TrimEnd('.') + testIndex
, strNumArr[j].TrimEnd('.'));
}
}
strxAxis += ((!string.IsNullOrEmpty(dt.Rows[i]["Resource_Name"].ToString())) ? dt.Rows[i]["Resource_Name"].ToString().ReplaceForFilter() : "-") + ",";
strSeries += dt.Rows[i]["KPScoreAvgRate"].ToString() + ",";
listReturn.Add(new
{
HomeWork_Name = dt.Rows[i]["Resource_Name"].ToString().ReplaceForFilter(),
HomeWorkCreateTime = string.IsNullOrEmpty(ClassID) ? pfunction.ConvertToLongDateTime(dt.Rows[i]["CreateTime"].ToString(), "yyyy-MM-dd HH:mm") : pfunction.ConvertToLongDateTime(dt.Rows[i]["HomeWorkCreateTime"].ToString(), "yyyy-MM-dd HH:mm"),
KPScoreSum = dt.Rows[i]["KPScoreSum"].ToString().clearLastZero(),
KPScoreAvgRate = (!string.IsNullOrEmpty(dt.Rows[i]["KPScoreAvgRate"].ToString())) ? dt.Rows[i]["KPScoreAvgRate"].ToString().clearLastZero() + "%" : "-",
TestQuestionNums = TQNums,
ClassID = string.IsNullOrEmpty(ClassID) ? "" : ClassID
});
inum++;
}
if (inum > 1)
{
return(JsonConvert.SerializeObject(new
{
err = "null",
list = listReturn,
strxAxisCategories = strxAxis.TrimEnd(','),
strSeriesData = strSeries.TrimEnd(','),
DataCount = dt.Rows.Count
}));
}
else
{
return(JsonConvert.SerializeObject(new
{
err = "暂无数据"
}));
}
}
catch (Exception ex)
{
return(JsonConvert.SerializeObject(new
{
err = ex.Message.ToString()
}));
}
}
