protected void Page_Load(object sender, EventArgs e)
{
timer.Start();
try
{
ResourceToResourceFolder_Id = Request.QueryString["ResourceToResourceFolder_Id"].Filter();
StatsClassHW_ScoreID = Request.QueryString["StatsClassHW_ScoreID"].Filter();
HomeWorkId = Request.QueryString["HomeWorkId"].Filter();
if (!IsPostBack)
{
CommonHandel bllc = new CommonHandel();
DataTable dt = bllc.GetHomeWorkInfo("HomeWork_Id='" + HomeWorkId + "'").Tables[0];
if (dt.Rows.Count > 0)
{
ltlHomeWork_Name.Text = dt.Rows[0]["HomeWork_Name"].ToString();
ltlGrade.Text = dt.Rows[0]["GradeName"].ToString();
ltlClass.Text = dt.Rows[0]["ClassName"].ToString();
ltlSubjectName.Text = dt.Rows[0]["SubjectName"].ToString();
ltlTeacherName.Text = dt.Rows[0]["TeacherName"].ToString();
ltlSumSore.Text = dt.Rows[0]["HW_Score"].ToString().clearLastZero();
strHomeWorkId = " and HomeWork_Id='" + HomeWorkId + "' ";
}
LoadData();
}
}
catch (Exception)
{
}
}
public static string GetStatsClassHW_ScoreOverview(string ClassCode, string ResourceToResourceFolder_Id, string UserId)
{
try
{
ClassCode = ClassCode.Filter();
ResourceToResourceFolder_Id = ResourceToResourceFolder_Id.Filter();
UserId = UserId.Filter();
CommonHandel chbll = new CommonHandel();
BLL_StatsTeacherHW_Score bllsthwso = new BLL_StatsTeacherHW_Score();
List <Model_StatsTeacherHW_Score> teacherScoreOverviewList = new List <Model_StatsTeacherHW_Score>();
DataTable dt = new DataTable();
string StrTemp = string.Empty;
if (ClassCode == "-1")
{
HttpContext.Current.Session["StatsClassClassId"] = "-1";
teacherScoreOverviewList = bllsthwso.GetModelList(" TeacherID='" + UserId + "' and ResourceToResourceFolder_Id='" + ResourceToResourceFolder_Id + "' ");
foreach (var item in teacherScoreOverviewList)
{
StrTemp += string.Format("<tr><td>全部</td><td>{0}</td><td>{1}</td><td>{2}</td><td>{3}</td><td>{4}</td><td>{5}</td><td>{6}</td><td>{7}</td><td>{8}</td><td>{9}</td></tr>"
, item.ClassAllCount
, item.HighestScore.ToString().clearLastZero()
, item.LowestScore.ToString().clearLastZero()
, item.AVGScore.ToString().clearLastZero()
, item.Median.ToString().clearLastZero()
, item.Mode
, item.StandardDeviation.ToString().clearLastZero()
, item.AssignedCount.ToString().clearLastZero() + "/" + (Convert.ToInt32(item.ClassAllCount) - Convert.ToInt32(item.AssignedCount.ToString().clearLastZero()))
, item.CommittedCount.ToString().clearLastZero() + "/" + item.UncommittedCount.ToString().clearLastZero()
, item.CorrectedCount.ToString().clearLastZero() + "/" + item.UnCorrectedCount.ToString().clearLastZero());
}
return(StrTemp);
}
else
{
HttpContext.Current.Session["StatsClassClassId"] = ClassCode;
BLL_StatsClassHW_Score bllcswso = new BLL_StatsClassHW_Score();
List <Rc.Model.Resources.Model_StatsClassHW_Score> ClassScoreOverviewList = new List <Model_StatsClassHW_Score>();
ClassScoreOverviewList = bllcswso.GetModelList("ClassID='" + ClassCode + "' and ResourceToResourceFolder_Id='" + ResourceToResourceFolder_Id + "'");
foreach (var item in ClassScoreOverviewList)
{
StrTemp = string.Format("< ><td>{0}</td><td>{1}</td><td>{2}</td><td>{3}</td><td>{4}</td><td>{5}</td><td>{6}</td><td>{7}</td><td>{8}</td><td>{9}</td><td>{10}</td></tr>", item.ClassName, item.ClassAllCount
, item.HighestScore.ToString().clearLastZero()
, item.LowestScore.ToString().clearLastZero()
, item.AVGScore.ToString().clearLastZero()
, item.Median.ToString().clearLastZero()
, item.Mode
, item.StandardDeviation.ToString().clearLastZero()
, item.AssignedCount.ToString().clearLastZero() + "/" + (Convert.ToInt32(item.ClassAllCount) - Convert.ToInt32(item.AssignedCount.ToString().clearLastZero()))
, item.CommittedCount.ToString().clearLastZero() + "/" + item.UncommittedCount.ToString().clearLastZero()
, item.CorrectedCount.ToString().clearLastZero() + "/" + item.UnCorrectedCount.ToString().clearLastZero());
}
return(StrTemp);
}
}
catch (Exception)
{
return("");
}
}
/// <summary>
/// 获取老师有效班级(统计二级页面)xpy 2016-04-22
/// </summary>
/// <returns></returns>
public static string GetTeacherClass(string TeacherId, string ClassID, string ClassName, string ResourceToResourceFolder_Id)
{
StringBuilder classStr = new StringBuilder();
//if (string.IsNullOrEmpty(ClassID))
//{
ClassID = "-1";
string classActive = string.Empty;
DataTable dt = new CommonHandel().GetTeacherAllClassByRTRFolder_Id(TeacherId, ResourceToResourceFolder_Id).Tables[0];
DataRow[] dr = dt.Select("AnalysisDataCount=1");
if (HttpContext.Current.Session["StatsClassClassId"] == null || HttpContext.Current.Session["StatsClassClassId"].ToString() == "" || HttpContext.Current.Session["StatsClassClassId"].ToString() == "-1")
{
classStr.Append("<li><a href='javascript:;' tt='1' cs='-1' class='active' ajax-value=''>全部</a></li>");
foreach (DataRow item in dr)
{
string strClassId = item["ClassId"].ToString().Trim();
classStr.AppendFormat("<li><a href='javascript:;' tt='1' cs='{0}' >{1}</a></li>"
, strClassId
, item["ClassName"].ToString());
}
}
else
{
classStr.Append("<li><a href='javascript:;' tt='1' cs='-1' ajax-value=''>全部</a></li>");
foreach (DataRow item in dr)
{
string strClassId = item["ClassId"].ToString().Trim();
classActive = (HttpContext.Current.Session["StatsClassClassId"].ToString() == strClassId) ? "active" : "";
classStr.AppendFormat("<li><a href='javascript:;' tt='1' cs='{0}' class='{2}' >{1}</a></li>"
, strClassId
, item["ClassName"].ToString()
, classActive);
}
}
return(classStr.ToString());
//}
//else
//{
// classStr.AppendFormat("<li><a href='javascript:;' tt='1' cs='{0}' class=\"{2}\">{1}</a></li>"
// , ClassID
// , ClassName
// , "active");
// return classStr.ToString();
//}
}
/// <summary>
/// 获取年级下的所有班级 2016-4-23 xpy
/// </summary>
/// <param name="GradeID"></param>
/// <returns></returns>
public static string GetGradeAllClass(string GradeID)
{
StringBuilder strHtml = new StringBuilder();
try
{
GradeID = GradeID.Filter();
DataTable dt = new CommonHandel().GetGradeAllClass(GradeID).Tables[0];
strHtml.Append("<li><a href='javascript:;' class='active' ajax-value=''>全部</a></li>");
foreach (DataRow item in dt.Rows)
{
strHtml.AppendFormat("<li><a href='javascript:;' ajax-value='{0}' >{1}</a></li>"
, item["ClassId"].ToString()
, item["ClassName"].ToString());
}
}
catch (Exception)
{
strHtml = new StringBuilder();
}
return(strHtml.ToString());
}
/// <summary>
/// 获取老师有效班级（班主任、代课老师）2016-08-12 讲义
/// </summary>
/// <returns></returns>
public static string GetTeacherClassByTeacherIdForCommon(string TeacherId, string StrWhere)
{
StringBuilder strHtml = new StringBuilder();
try
{
TeacherId = TeacherId.Filter();
DataTable dt = new CommonHandel().GetTeacherAllClassForCommon(TeacherId, StrWhere).Tables[0];
strHtml.Append("<li><a href='javascript:;' class='active' ajax-value=''>全部</a></li>");
foreach (DataRow item in dt.Rows)
{
strHtml.AppendFormat("<li><a href='javascript:;' ajax-value='{0}'>{1}</a></li>"
, item["ClassId"].ToString()
, item["ClassName"].ToString());
}
}
catch (Exception)
{
strHtml = new StringBuilder();
}
return(strHtml.ToString());
}
/// <summary>
/// 获取老师有效班级（班主任、代课老师）2016-04-22
/// </summary>
/// <returns></returns>
public static string GetTeacherClassBySubject(string TeacherId, string Subject)
{
StringBuilder strHtml = new StringBuilder();
try
{
TeacherId = TeacherId.Filter();
DataTable dt = new CommonHandel().GetTeacherAllClassBySubject(TeacherId, Subject).Tables[0];
DataRow[] dr = dt.Select("AnalysisDataCount=1");
strHtml.Append("<li><a href='javascript:;' class='active' ajax-value=''>全部</a></li>");
foreach (DataRow item in dr)
{
strHtml.AppendFormat("<li><a href='javascript:;' ajax-value='{0}'>{1}</a></li>"
, item["ClassId"].ToString()
, item["ClassName"].ToString());
}
}
catch (Exception)
{
strHtml = new StringBuilder();
}
return(strHtml.ToString());
}
protected void Page_Load(object sender, EventArgs e)
{
Model_F_User modelFUser = (Model_F_User)Session["FLoginUser"];
UserId = modelFUser.UserId;
ResourceToResourceFolder_Id = Request.QueryString["ResourceToResourceFolder_Id"].Filter();
HomeWork_ID = Request.QueryString["HomeWork_ID"].Filter();
ClassID = Request.QueryString["ClassID"].Filter();
TeacherID = Request.QueryString["TeacherID"].Filter();
ClassName = Request.QueryString["ClassName"].Filter();
if (!string.IsNullOrEmpty(HomeWork_ID))
{
if (!string.IsNullOrEmpty(ClassID))//判断查看的统计是否为此老师的
{
StrTemp = "&ClassID=" + ClassID + "&ClassName=" + ClassName + "&TeacherID=" + TeacherID;
DataTable dt = new CommonHandel().GetTeacherAllClassByRTRFolder_Id(TeacherID, ResourceToResourceFolder_Id).Tables[0];
DataRow[] dr = dt.Select("AnalysisDataCount=1");
if (dr.Length < 2)
{
Judge = true;
}
}
else
{
DataTable dt = new CommonHandel().GetTeacherAllClassByRTRFolder_Id(UserId, ResourceToResourceFolder_Id).Tables[0];
DataRow[] dr = dt.Select("AnalysisDataCount=1");
if (dr.Length < 2)
{
Judge = true;
}
}
LoadDate();
GetLeftNAV();
}
}
public static string GetStatsClassHW_ScoreOrder(string ClassCode, string ResourceToResourceFolder_Id, string UserId)
{
try
{
CommonHandel ch = new CommonHandel();
DataTable dt = new DataTable();
string StrTemp = string.Empty;
string Num = "5";
string StrSql = string.Empty;
if (ClassCode == "-1")
{
StrSql = @"select top 5 stsh.* from StatsTeacherStudentHW_Score stsh
where stsh.StudentID in(select Student_Id from Student_HomeWork shw
inner join Student_HomeWork_Submit shwSubmit on shwSubmit.Student_HomeWork_Id=shw.Student_HomeWork_Id and shwSubmit.Student_HomeWork_Status=1
where HomeWork_Id in(select HomeWork_Id from HomeWork
where ResourceToResourceFolder_Id=stsh.ResourceToResourceFolder_Id and HomeWork_AssignTeacher=stsh.TeacherID) ) and stsh.TeacherID='" + UserId + "' and stsh.ResourceToResourceFolder_Id='" + ResourceToResourceFolder_Id + "' order by stsh.StudentScoreOrder";
BLL_StatsTeacherStudentHW_Score bllTeacherStudentHW_Score = new BLL_StatsTeacherStudentHW_Score();
dt = Rc.Common.DBUtility.DbHelperSQL.Query(StrSql).Tables[0];
//dt = bllTeacherStudentHW_Score.GetList(5, "TeacherID='" + UserId + "' and ResourceToResourceFolder_Id='" + ResourceToResourceFolder_Id + "'", "StudentScoreOrder").Tables[0];
if (dt.Rows.Count > 0)
{
if (dt.Rows.Count < 5)
{
Num = dt.Rows.Count.ToString();
}
for (int i = 0; i < dt.Rows.Count; i++)//dt.Rows[i]["Score"]dt.Rows[i]["StudentName"]
{
StrTemp += string.Format(" <td class=\"before\"><h2>{0}</h2><p>{1}</p></td>", dt.Rows[i]["StudentScore"].ToString().clearLastZero(), dt.Rows[i]["StudentName"].ToString());
}
}
StrSql = @"select top 5 stsh.* from StatsTeacherStudentHW_Score stsh
where stsh.StudentID in(select Student_Id from Student_HomeWork shw
inner join Student_HomeWork_Submit shwSubmit on shwSubmit.Student_HomeWork_Id=shw.Student_HomeWork_Id and shwSubmit.Student_HomeWork_Status=1 where HomeWork_Id in(select HomeWork_Id from HomeWork
where ResourceToResourceFolder_Id=stsh.ResourceToResourceFolder_Id and HomeWork_AssignTeacher=stsh.TeacherID) ) and stsh.TeacherID='" + UserId + "' and stsh.ResourceToResourceFolder_Id='" + ResourceToResourceFolder_Id + "' order by stsh.StudentScoreOrder desc";
dt = Rc.Common.DBUtility.DbHelperSQL.Query(StrSql).Tables[0];
//dt = bllTeacherStudentHW_Score.GetList(5, "TeacherID='" + UserId + "' and ResourceToResourceFolder_Id='" + ResourceToResourceFolder_Id + "'", "StudentScoreOrder desc").Tables[0];
if (dt.Rows.Count > 0)
{
if (dt.Rows.Count < 5)
{
Num = dt.Rows.Count.ToString();
}
for (int i = 0; i < dt.Rows.Count; i++)//dt.Rows[i]["Score"]dt.Rows[i]["StudentName"]
{
StrTemp += string.Format(" <td class=\"after\"><h2>{0}</h2><p>{1}</p></td>", dt.Rows[i]["StudentScore"].ToString().clearLastZero(), (dt.Rows[i]["StudentName"].ToString()));
}
}
return(StrTemp + "|" + Num);
}
else
{
BLL_StatsClassStudentHW_Score bllClassStudentHW_Score = new BLL_StatsClassStudentHW_Score();
StrSql = @"select top 5 stsh.*,shwSubmit.Student_HomeWork_Status from StatsClassStudentHW_Score stsh
left join dbo.Student_HomeWork shw on shw.HomeWork_ID=stsh.HomeWork_ID and shw.Student_Id=stsh.StudentID
inner join Student_HomeWork_Submit shwSubmit on shwSubmit.Student_HomeWork_Id=shw.Student_HomeWork_Id
where stsh.ClassID='" + ClassCode + "' and stsh.ResourceToResourceFolder_Id='" + ResourceToResourceFolder_Id + "' and shwSubmit.Student_HomeWork_Status=1 order by stsh.StudentScoreOrder,AnswerEnd";
dt = Rc.Common.DBUtility.DbHelperSQL.Query(StrSql).Tables[0];
//dt = bllClassStudentHW_Score.GetList(5, "ClassID='" + ClassCode + "' and ResourceToResourceFolder_Id='" + ResourceToResourceFolder_Id + "'", "StudentScoreOrder,AnswerEnd").Tables[0];
if (dt.Rows.Count > 0)
{
if (dt.Rows.Count < 5)
{
Num = dt.Rows.Count.ToString();
}
for (int i = 0; i < dt.Rows.Count; i++)//dt.Rows[i]["Score"]dt.Rows[i]["StudentName"]
{
StrTemp += string.Format(" <td class=\"before\"><h2>{0}</h2><p>{1}</p></td>", dt.Rows[i]["StudentScore"].ToString().clearLastZero(), (dt.Rows[i]["StudentName"].ToString()));
}
}
StrSql = @"select top 5 stsh.*,shwSubmit.Student_HomeWork_Status from StatsClassStudentHW_Score stsh
left join dbo.Student_HomeWork shw on shw.HomeWork_ID=stsh.HomeWork_ID and shw.Student_Id=stsh.StudentID
inner join Student_HomeWork_Submit shwSubmit on shwSubmit.Student_HomeWork_Id=shw.Student_HomeWork_Id
where stsh.ClassID='" + ClassCode + "' and stsh.ResourceToResourceFolder_Id='" + ResourceToResourceFolder_Id + "' and shwSubmit.Student_HomeWork_Status=1 order by stsh.StudentScoreOrder desc ,AnswerEnd desc";
dt = Rc.Common.DBUtility.DbHelperSQL.Query(StrSql).Tables[0];
//dt = bllClassStudentHW_Score.GetList(5, "ClassID='" + ClassCode + "' and ResourceToResourceFolder_Id='" + ResourceToResourceFolder_Id + "'", "StudentScoreOrder desc,AnswerEnd desc").Tables[0];
if (dt.Rows.Count > 0)
{
if (dt.Rows.Count < 5)
{
Num = dt.Rows.Count.ToString();
}
for (int i = 0; i < dt.Rows.Count; i++)//dt.Rows[i]["Score"]dt.Rows[i]["StudentName"]
{
StrTemp += string.Format(" <td class=\"after\"><h2>{0}</h2><p>{1}</p></td>", dt.Rows[i]["StudentScore"].ToString().clearLastZero(), (dt.Rows[i]["StudentName"].ToString()));
}
}
return(StrTemp + "|" + Num);
}
}
catch (Exception)
{
throw;
}
}
public static string GetEachHWAnalysis(string HWName, string HomeWorkCreateTime, string HomeWorkFinishTime, string ClassID, string TeacherID, int PageIndex, int PageSize)
{
try
{
HWName = HWName.Filter();
HomeWorkCreateTime = HomeWorkCreateTime.Filter();
HomeWorkFinishTime = HomeWorkFinishTime.Filter();
ClassID = ClassID.Filter();
TeacherID = TeacherID.Filter();
string strWhere = "WHERE T.HomeWork_AssignTeacher ='" + TeacherID + "' ";
if (!string.IsNullOrEmpty(HWName))
{
strWhere += " and T.HomeWork_Name like '%" + HWName + "%'";
}
if (!string.IsNullOrEmpty(HomeWorkCreateTime))
{
strWhere += " and Convert(nvarchar(10),T.CreateTime,23) >= '" + HomeWorkCreateTime + "'";
}
if (!string.IsNullOrEmpty(HomeWorkFinishTime))
{
strWhere += " and Convert(nvarchar(10),T.CreateTime,23) <= '" + HomeWorkFinishTime + "'";
}
if (!string.IsNullOrEmpty(ClassID))
{
strWhere += " and T.UserGroup_Id = '" + ClassID + "'";
}
DataTable dt = new DataTable();
BLL_StatsClassHW_Score bll = new BLL_StatsClassHW_Score();
CommonHandel bllc = new CommonHandel();
dt = bllc.GetListByPageForCommonHandel(strWhere, " T.CreateTime desc", ((PageIndex - 1) * PageSize + 1), PageIndex * PageSize).Tables[0];
int intRecordCount = bllc.GetRecordCountForCommonHandel(strWhere);
List <object> listReturn = new List <object>();
int inum = 1;
string temp = string.Empty;
string strSql = "select COUNT(1) as ICount,HomeWork_Id from Student_HomeWork shw inner join Student_HomeWork_Submit shwSubmit on shwSubmit.Student_HomeWork_Id=shw.Student_HomeWork_Id where shwSubmit.Student_HomeWork_Status=1 group by HomeWork_Id";
DataTable dtWTJ = Rc.Common.DBUtility.DbHelperSQL.Query(strSql).Tables[0];
for (int i = 0; i < dt.Rows.Count; i++)
{
DataRow[] dr = dtWTJ.Select("HomeWork_Id='" + dt.Rows[i]["HomeWork_Id"].ToString() + "'");
listReturn.Add(new
{
HomeWork_Name = dt.Rows[i]["HomeWork_Name"].ToString(),
ClassName = dt.Rows[i]["ClassName"].ToString(),
HomeWork_Id = dt.Rows[i]["HomeWork_Id"].ToString(),
CreateTime = pfunction.ConvertToLongDateTime(dt.Rows[i]["CreateTime"].ToString()),
StatsClassHW_ScoreID = dt.Rows[i]["StatsClassHW_ScoreID"].ToString(),
ResourceToResourceFolder_Id = dt.Rows[i]["ResourceToResourceFolder_Id"].ToString(),
HighestScore = dt.Rows[i]["HighestScore"].ToString() == "" ? "-" : dt.Rows[i]["HighestScore"].ToString().clearLastZero(),
LowestScore = dt.Rows[i]["LowestScore"].ToString() == "" ? "-" : dt.Rows[i]["LowestScore"].ToString().clearLastZero(),
AVGScore = dt.Rows[i]["AVGScore"].ToString() == "" ? "-" : dt.Rows[i]["AVGScore"].ToString().clearLastZero(),
Median = dt.Rows[i]["Median"].ToString() == "" ? "-" : dt.Rows[i]["Median"].ToString().clearLastZero(),
Mode = dt.Rows[i]["Mode"].ToString() == "" ? "-" : dt.Rows[i]["Mode"].ToString(),
WTJ = dr.Length > 0 ? "1" : "0"
});
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()
}));
}
}
