public static string GetStatsGradeHW_Score(string GradeId, string ResourceToResourceFolder_Id)
{
try
{
GradeId = GradeId.Filter();
ResourceToResourceFolder_Id = ResourceToResourceFolder_Id.Filter();
string TempGrade = string.Empty;
string avgScore = string.Empty;
string Temp = " <tr><td>{0}</td><td>{1}</td><td>{2}</td><td>{3}</td></tr>";
string TempDate = string.Empty;
BLL_StatsClassHW_Score bllStatsClassHW_Score = new BLL_StatsClassHW_Score();
List <Model_StatsClassHW_Score> StatsClassHW_ScoreList = new List <Model_StatsClassHW_Score>();
StatsClassHW_ScoreList = bllStatsClassHW_Score.GetModelList("GradeID='" + GradeId + "' and ResourceToResourceFolder_Id='" + ResourceToResourceFolder_Id + "' order by AVGScore desc");
int i = 0;
foreach (var item in StatsClassHW_ScoreList)
{
TempDate += string.Format(Temp, i + 1, item.ClassName, item.TeacherName, item.AVGScore.ToString().clearLastZero());
TempGrade += "" + item.ClassName + ",";
avgScore += item.AVGScore + ",";
i++;
}
if (string.IsNullOrEmpty(TempDate))
{
return("");
}
else
{
return(TempDate + "|" + TempGrade.TrimEnd(',') + "|" + avgScore.TrimEnd(',') + "");
}
}
catch (Exception)
{
return("");
}
}
public static string GetStatsGradeHW_Score(string GradeId, string ResourceToResourceFolder_Id)
{
try
{
GradeId = GradeId.Filter();
ResourceToResourceFolder_Id = ResourceToResourceFolder_Id.Filter();
string TempAll = "<tr><td class='text-left'>全部</td><td class='text-left'>{8}</td><td>{1}</td><td>{2}</td><td>{3}</td><td>{4}</td><td>{5}</td><td>{0}</td><td>{9}</td><td>{6}/{7}</td></tr>";
string Temps = "<tr><td class='text-left'>{9}</td><td class='text-left'>{8}</td><td>{1}</td><td>{2}</td><td>{3}</td><td>{4}</td><td>{5}</td><td>{0}</td><td>{10}</td><td>{6}/{7}</td></tr>";
string TempDate = string.Empty;
string TempDateAll = string.Empty;
BLL_StatsGradeHW_Score bllStatsGradeHW_Score = new BLL_StatsGradeHW_Score();
List <Model_StatsGradeHW_Score> StatsGradeHW_ScoreList = new List <Model_StatsGradeHW_Score>();
StatsGradeHW_ScoreList = bllStatsGradeHW_Score.GetModelList("GradeID='" + GradeId + "' and ResourceToResourceFolder_Id='" + ResourceToResourceFolder_Id + "'");
foreach (var item in StatsGradeHW_ScoreList)
{
TempDateAll = string.Format(TempAll, item.ClassAllCount.ToString().clearLastZero(), item.HighestScore.ToString().clearLastZero(), item.LowestScore.ToString().clearLastZero(), item.AVGScore.ToString().clearLastZero(), item.Median.ToString().clearLastZero(), item.Mode, item.CommittedCount.ToString().clearLastZero(), item.UncommittedCount.ToString().clearLastZero(), "-", item.AssignedCount.ToString().clearLastZero() + "/" + (Convert.ToInt32(item.ClassAllCount) - Convert.ToInt32(item.AssignedCount)));
}
BLL_StatsClassHW_Score bllStatsClassHW_Score = new BLL_StatsClassHW_Score();
List <Model_StatsClassHW_Score> StatsClassHW_ScoreList = new List <Model_StatsClassHW_Score>();
StatsClassHW_ScoreList = bllStatsClassHW_Score.GetModelList("GradeID='" + GradeId + "' and ResourceToResourceFolder_Id='" + ResourceToResourceFolder_Id + "'");
foreach (var item in StatsClassHW_ScoreList)
{
TempDate += string.Format(Temps, item.ClassAllCount.ToString().clearLastZero(), item.HighestScore.ToString().clearLastZero(), item.LowestScore.ToString().clearLastZero(), item.AVGScore.ToString().clearLastZero(), item.Median.ToString().clearLastZero(), item.Mode, item.CommittedCount.ToString().clearLastZero(), item.UncommittedCount.ToString().clearLastZero(), item.TeacherName, item.ClassName, item.AssignedCount.ToString().clearLastZero() + "/" + (Convert.ToInt32(item.ClassAllCount) - Convert.ToInt32(item.AssignedCount)));
}
return(TempDateAll + "†" + TempDate);
}
catch (Exception)
{
return("");
}
}
public static string getData(string SubjectID, string ClassID, string GradeID)
{
try
{
SubjectID = SubjectID.Filter();
ClassID = ClassID.Filter();
GradeID = GradeID.Filter();
string strAVGScore = string.Empty;
string strAVGScoreRate = string.Empty;
string strHWScore = string.Empty;
//string strScoreOrder = string.Empty;
string strHWName = string.Empty;
BLL_StatsClassHW_Score bll_StatsClassHW_Score = new BLL_StatsClassHW_Score();
List <Model_StatsClassHW_Score> list = new List <Model_StatsClassHW_Score>();
list = bll_StatsClassHW_Score.GetModelList("SubjectID='" + SubjectID + "' AND ClassID = '" + ClassID + "'AND GradeID = '" + GradeID + "' ORDER BY HomeWorkCreateTime ASC");
foreach (var item in list)
{
strAVGScore += item.AVGScore.ToString() + ",";
strAVGScoreRate += item.AVGScoreRate.ToString() + ",";
strHWScore += item.HW_Score.ToString() + ",";
strHWName += ((!string.IsNullOrEmpty(item.Resource_Name.ToString())) ? item.Resource_Name.ToString().ReplaceForFilter() : "-") + ",";
}
return(Newtonsoft.Json.JsonConvert.SerializeObject(new
{
AVGScore = strAVGScore.TrimEnd(','),
AVGScoreRate = strAVGScoreRate.TrimEnd(','),
HWScore = strHWScore.TrimEnd(','),
HWName = strHWName.TrimEnd(',')
}));
}
catch (Exception)
{
return("err");
}
}
public static string GetStatsClassHW_Score(string ResourceToResourceFolder_Id, string UserId, string ClassID)
{
try
{
string StrWhere = "TeacherID='" + UserId.Filter() + "' and ResourceToResourceFolder_Id='" + ResourceToResourceFolder_Id.Filter() + "'";
//if (!string.IsNullOrEmpty(ClassID))
//{
// StrWhere += "and ClassID='" + ClassID.Filter() + "'";
//}
string StrTemp = string.Empty;
BLL_StatsClassHW_Score bllcswso = new BLL_StatsClassHW_Score();
List <Model_StatsClassHW_Score> ClassScoreOverviewList = new List <Model_StatsClassHW_Score>();
ClassScoreOverviewList = bllcswso.GetModelList(StrWhere);
string Temp = "<tr><td>{0}</td><td>{1}</td><td>{2}</td><td>{3}</td><td>{4}</td><td>{5}</td><td>{6}/{7}</td><td>{8}/{9}</td></tr>";
foreach (var item in ClassScoreOverviewList)
{
StrTemp += string.Format(Temp, item.ClassName, item.AVGScore.ToString().clearLastZero(), item.HighestScore.ToString().clearLastZero()
, item.LowestScore.ToString().clearLastZero(), item.Median.ToString().clearLastZero(), item.Mode, item.CommittedCount.ToString().clearLastZero(), item.UncommittedCount.ToString().clearLastZero(), item.CorrectedCount.ToString().clearLastZero(), item.UnCorrectedCount.ToString().clearLastZero());
}
return(StrTemp);
}
catch (Exception)
{
return("");
}
}
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("");
}
}
protected void Page_Load(object sender, EventArgs e)
{
try
{
HomeWork_Id = Request.QueryString["HomeWork_Id"].Filter();
ResourceToResourceFolder_Id = Request.QueryString["ResourceToResourceFolder_Id"].Filter();
if (!IsPostBack)
{
if (!string.IsNullOrEmpty(HomeWork_Id))
{
BLL_StatsClassHW_Score bllschwso = new BLL_StatsClassHW_Score();
DataTable dt = bllschwso.GetList("HomeWork_ID='" + HomeWork_Id + "' ").Tables[0];
if (dt.Rows.Count == 0)
{
string strSql = string.Format(@"select t.*,t2.Resource_Name
,t3.GradeName,t3.ClassName
,t4.D_Name as SubjectName
,(case when t5.TrueName is null then t5.UserName when t5.TrueName='' then t5.UserName else t5.UserName end) as TeacherName
,HW_Score=(select ISNULL(SUM(TestQuestions_Score),0) from TestQuestions_Score where ResourceToResourceFolder_Id=t.ResourceToResourceFolder_Id)
,t.HomeWork_AssignTeacher as TeacherID,t.UserGroup_Id as ClassId
from HomeWork t
inner join ResourceToResourceFolder t2 on t2.ResourceToResourceFolder_Id=t.ResourceToResourceFolder_Id
inner join VW_ClassGradeSchool t3 on t3.ClassId=t.UserGroup_Id
inner join Common_Dict t4 on t4.Common_Dict_ID=t.SubjectId
inner join F_User t5 on t5.UserId=t.HomeWork_AssignTeacher
where t.HomeWork_Id='{0}'", HomeWork_Id);
dt = Rc.Common.DBUtility.DbHelperSQL.Query(strSql).Tables[0];
}
if (dt.Rows.Count > 0)
{
ltlHomeWork_Name.Text = dt.Rows[0]["Resource_Name"].ToString().ReplaceForFilter();
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='" + HomeWork_Id + "' ";
ClassId = dt.Rows[0]["ClassID"].ToString();
GetData();
}
}
}
}
catch (Exception ex)
{
new Rc.Cloud.BLL.BLL_clsAuth().AddLogErrorFromBS(Request.Url.ToString(), string.Format("讲评概述加载失败。作业标识：{0}，资源标识：{1}。错误：{2}"
, HomeWork_Id, ResourceToResourceFolder_Id, ex.Message.ToString()));
}
}
/// <summary>
/// 获得基本信息
/// </summary>
/// <returns></returns>
protected void getCommon()
{
StringBuilder commonInfo = new StringBuilder();
DataTable dt = new DataTable();
BLL_StatsClassHW_Score bll_StatsClassHW_Score = new BLL_StatsClassHW_Score();
dt = bll_StatsClassHW_Score.GetList("StatsClassHW_ScoreID = '" + StatsClassHW_ScoreID + "'").Tables[0];
foreach (DataRow item in dt.Rows)
{
PageTitle = item["ClassName"].ToString() + "的成长轨迹";
//Student_ID = item["StudentID"].ToString();
SubjectID = item["SubjectID"].ToString();
ClassID = item["ClassID"].ToString();
GradeID = item["GradeID"].ToString();
commonInfo.AppendFormat("<span>年级：{0}</span>", item["GradeName"].ToString());
commonInfo.AppendFormat("<span>学科：{0}</span>", item["SubjectName"].ToString());
commonInfo.AppendFormat("<span>老师：{0}</span>", item["TeacherName"].ToString());
//commonInfo.AppendFormat("<span>满分：{0}分</span>", Convert.ToInt16(item["HWScore"]).ToString());
}
ltlCommonInfo.Text = commonInfo.ToString();
}
public static string GetEachHWAnalysis(string GradeId, string SubjectId, string ResourceToResourceFolder_Id, int PageIndex, int PageSize)
{
try
{
GradeId = GradeId.Filter();
SubjectId = SubjectId.Filter();
ResourceToResourceFolder_Id = ResourceToResourceFolder_Id.Filter();
HttpContext.Current.Session["StatsClassSubject"] = SubjectId;
string strWhere = " ResourceToResourceFolder_Id='" + ResourceToResourceFolder_Id + "' ";
DataTable dt = new DataTable();
BLL_StatsClassHW_Score bll = new BLL_StatsClassHW_Score();
string strSqlMain = string.Format(@"select hw.HomeWork_ID,hw.ResourceToResourceFolder_Id,hw.HomeWork_Name,hw.HomeWork_AssignTeacher as TeacherId,hw.UserGroup_Id as ClassId,hw.SubjectId,hw.CreateTime,hw.HomeWork_FinishTime,hw.HomeWork_Status
,ug.UserGroup_Name as ClassName,cd.D_Name as SubjectName,fu.UserName,fu.TrueName from HomeWork hw
left join UserGroup ug on ug.UserGroup_Id=hw.UserGroup_Id
left join Common_Dict cd on cd.Common_Dict_Id=hw.SubjectId
left join F_User fu on fu.UserId=hw.HomeWork_AssignTeacher
where hw.SubjectId='{0}' and hw.UserGroup_Id in(select ClassId from VW_ClassGradeSchool where GradeId='{1}') "
, SubjectId
, GradeId);
StringBuilder strSql = new StringBuilder();
strSql.Append("SELECT * FROM ( ");
strSql.Append(" SELECT ROW_NUMBER() OVER (");
strSql.Append("order by T.HomeWork_FinishTime desc");
strSql.AppendFormat(")AS Row, T.* from ( {0} ) T ", strSqlMain);
strSql.Append(" WHERE " + strWhere);
strSql.Append(" ) TT");
strSql.AppendFormat(" WHERE TT.Row between {0} and {1}", ((PageIndex - 1) * PageSize + 1), PageIndex * PageSize);
dt = Rc.Common.DBUtility.DbHelperSQL.Query(strSql.ToString()).Tables[0];
StringBuilder strSqlCount = new StringBuilder();
strSqlCount.AppendFormat("SELECT count(1) from ( {0} ) T ", strSqlMain);
strSqlCount.Append(" WHERE " + strWhere);
int intRecordCount = int.Parse(Rc.Common.DBUtility.DbHelperSQL.GetSingle(strSqlCount.ToString()).ToString());
List <object> listReturn = new List <object>();
int inum = 1;
string temp = string.Empty;
for (int i = 0; i < dt.Rows.Count; i++)
{
string strPG = GetCorrectStudent(dt.Rows[i]["HomeWork_ID"].ToString());
string strTJ = GetSubmitStudent(dt.Rows[i]["HomeWork_ID"].ToString());
listReturn.Add(new
{
HomeWork_ID = dt.Rows[i]["HomeWork_ID"].ToString(),
HomeWork_Name = dt.Rows[i]["HomeWork_Name"].ToString(),
ClassName = dt.Rows[i]["ClassName"].ToString(),
ClassNameEncode = HttpContext.Current.Server.UrlEncode(dt.Rows[i]["ClassName"].ToString()),
SubjectName = dt.Rows[i]["SubjectName"].ToString(),
CreateTime = pfunction.ToShortDate(dt.Rows[i]["CreateTime"].ToString()),
ResourceToResourceFolder_Id = dt.Rows[i]["ResourceToResourceFolder_Id"].ToString(),
TeacherID = dt.Rows[i]["TeacherID"].ToString(),
TeacherName = string.IsNullOrEmpty(dt.Rows[i]["TrueName"].ToString()) ? dt.Rows[i]["UserName"].ToString() : dt.Rows[i]["TrueName"].ToString(),
ClassID = dt.Rows[i]["ClassID"].ToString(),
TJ = GetSubmitStudent(dt.Rows[i]["HomeWork_ID"].ToString()),
PG = strPG,
TJData = strTJ.Split('/')[0],
IsFinish = (dt.Rows[i]["HomeWork_Status"].ToString() == "1") ? "<font color='green'>是</font>" : "<font color='red'>否</font>",
HomeWork_FinishTime = pfunction.ConvertToLongDateTime(dt.Rows[i]["HomeWork_FinishTime"].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()
}));
}
}
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()
}));
}
}
public static string GetList(string GradeID, string SubjectID, string ClassID, int PageIndex, int PageSize)
{
try
{
SubjectID = SubjectID.Filter();
ClassID = ClassID.Filter();
HttpContext.Current.Session["StatsGradeSubject"] = SubjectID;
// key = key.Filter();
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 StudentName like '%" + key + "%'";
//}
strWhere += @" AND StatsClassHW_ScoreID IN(select StatsClassHW_ScoreID from (
select StatsClassHW_ScoreID,
ROW_NUMBER() over(partition by Gradeid,SubjectID,ClassID order by HomeWorkCreateTime desc) as rowNum
from StatsClassHW_Score where " + strWhere + " ) t where rowNum=1) ";
DataTable dt = new DataTable();
BLL_StatsClassHW_Score bll = new BLL_StatsClassHW_Score();
dt = bll.GetListByPage(strWhere, "StatsClassHW_ScoreID 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
{
GradeName = dt.Rows[i]["GradeName"].ToString(),
SubjectName = dt.Rows[i]["SubjectName"].ToString(),
ClassName = dt.Rows[i]["ClassName"].ToString(),
AVGScore = dt.Rows[i]["AVGScore"].ToString().clearLastZero(),
StandardDeviation = dt.Rows[i]["StandardDeviation"].ToString().clearLastZero(),
StatsClassHW_ScoreID = dt.Rows[i]["StatsClassHW_ScoreID"].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()
}));
}
}
public static string GetEachHWAnalysis(string HWName, string HomeWorkCreateTime, string HomeWorkFinishTime, string SubjectID, string TeacherID, int PageIndex, int PageSize)
{
try
{
HWName = HWName.Filter();
HomeWorkCreateTime = HomeWorkCreateTime.Filter();
HomeWorkFinishTime = HomeWorkFinishTime.Filter();
TeacherID = TeacherID.Filter();
HttpContext.Current.Session["StatsClassSubject"] = SubjectID;
string strWhere = " TeacherId='" + TeacherID + "' ";
if (!string.IsNullOrEmpty(HWName))
{
strWhere += " and HomeWork_Name like '%" + HWName + "%'";
}
if (!string.IsNullOrEmpty(HomeWorkCreateTime))
{
strWhere += " and CreateTime > '" + HomeWorkCreateTime + "'";
}
if (!string.IsNullOrEmpty(HomeWorkFinishTime))
{
strWhere += " and CreateTime <= '" + HomeWorkFinishTime + "'";
}
if (!string.IsNullOrEmpty(SubjectID))
{
strWhere += " and SubjectID = '" + SubjectID + "'";
}
Model_F_User loginUser = HttpContext.Current.Session["FLoginUser"] as Model_F_User;
strWhere += StatsCommonHandle.GetStrWhereBySelfClassForTeacherData(SubjectID);
DataTable dt = new DataTable();
BLL_StatsClassHW_Score bll = new BLL_StatsClassHW_Score();
string strSqlMain = string.Format(@"select hw.HomeWork_ID,hw.ResourceToResourceFolder_Id,hw.HomeWork_Name,hw.HomeWork_AssignTeacher as TeacherId,hw.UserGroup_Id as ClassId,hw.SubjectId,hw.CreateTime
,ug.UserGroup_Name as ClassName,cd.D_Name as SubjectName,fu.UserName,fu.TrueName from HomeWork hw
left join UserGroup ug on ug.UserGroup_Id=hw.UserGroup_Id
left join Common_Dict cd on cd.Common_Dict_Id=hw.SubjectId
left join F_User fu on fu.UserId=hw.HomeWork_AssignTeacher
where hw.UserGroup_Id in(select UserGroup_Id from UserGroup_Member where UserStatus='0' and MemberShipEnum='{2}' and User_Id='{0}')
or (hw.SubjectId='{1}' and hw.HomeWork_AssignTeacher='{0}')"
, TeacherID
, SubjectID
, MembershipEnum.headmaster);
StringBuilder strSql = new StringBuilder();
strSql.Append("SELECT * FROM ( ");
strSql.Append(" SELECT ROW_NUMBER() OVER (");
strSql.Append("order by T.CreateTime desc");
strSql.AppendFormat(")AS Row, T.* from ( {0} ) T ", strSqlMain);
strSql.Append(" WHERE " + strWhere);
strSql.Append(" ) TT");
strSql.AppendFormat(" WHERE TT.Row between {0} and {1}", ((PageIndex - 1) * PageSize + 1), PageIndex * PageSize);
dt = Rc.Common.DBUtility.DbHelperSQL.Query(strSql.ToString()).Tables[0];
StringBuilder strSqlCount = new StringBuilder();
strSqlCount.AppendFormat("SELECT count(1) from ( {0} ) T ", strSqlMain);
strSqlCount.Append(" WHERE " + strWhere);
int intRecordCount = int.Parse(Rc.Common.DBUtility.DbHelperSQL.GetSingle(strSqlCount.ToString()).ToString());
// string strSql = string.Format(@"select hw.*,ug.UserGroup_Name,cd.D_Name as SubjectName from HomeWork hw
//left join UserGroup ug on ug.UserGroup_Id=hw.UserGroup_Id
//left join Common_Dict cd on cd.Common_Dict_Id=hw.SubjectId
// where hw.UserGroup_Id in(select UserGroup_Id from UserGroup_Member where UserStatus='0' and MemberShipEnum='{2}' and User_Id='{0}')
//or (hw.SubjectId='{1}' and hw.HomeWork_AssignTeacher='{0}')"
// , TeacherID
// , SubjectID);
//dt = bll.GetListByPage(strWhere, "HomeWorkCreateTime desc", ((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++)
{
string strPG = GetCorrectStudent(dt.Rows[i]["HomeWork_ID"].ToString());
string strTJ = GetSubmitStudent(dt.Rows[i]["HomeWork_ID"].ToString());
listReturn.Add(new
{
HomeWork_ID = dt.Rows[i]["HomeWork_ID"].ToString(),
HomeWork_Name = dt.Rows[i]["HomeWork_Name"].ToString(),
ClassName = dt.Rows[i]["ClassName"].ToString(),
ClassNameEncode = HttpContext.Current.Server.UrlEncode(dt.Rows[i]["ClassName"].ToString()),
SubjectName = dt.Rows[i]["SubjectName"].ToString(),
CreateTime = pfunction.ToShortDate(dt.Rows[i]["CreateTime"].ToString()),
ResourceToResourceFolder_Id = dt.Rows[i]["ResourceToResourceFolder_Id"].ToString(),
TeacherID = dt.Rows[i]["TeacherID"].ToString(),
TeacherName = string.IsNullOrEmpty(dt.Rows[i]["TrueName"].ToString()) ? dt.Rows[i]["UserName"].ToString() : dt.Rows[i]["TrueName"].ToString(),
ClassID = dt.Rows[i]["ClassID"].ToString(),
TJ = strTJ,
PG = strPG,
HaveTJ = strTJ.Split('/')[0],
IsTeacherData = dt.Rows[i]["TeacherID"].ToString() == loginUser.UserId ? "" : "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()
}));
}
}