protected void Page_Load(object sender, EventArgs e)
{
UserId = FloginUser.UserId;
ResourceToResourceFolder_Id = Request.QueryString["ResourceToResourceFolder_Id"].Filter();
ClassID = Request.QueryString["ClassID"].Filter();
TeacherID = Request.QueryString["TeacherID"].Filter();
ClassCode = Request.QueryString["ClassCode"].Filter();
ClassName = HttpContext.Current.Server.UrlDecode(Request.QueryString["ClassName"].Filter());
if (!string.IsNullOrEmpty(ClassCode))
{
Session["StatsClassClassId"] = ClassCode;
}
if (!IsPostBack)
{
if (!string.IsNullOrEmpty(TeacherID))
{
UserId = TeacherID;
}
StudentNum = "[ {y: 10,name: '优秀'},{y: 20,name: '良好'},{y: 30,name: '中等'},{y: 40,name: '及格'},{y: 50,name: '不及格'}]";
if (!string.IsNullOrEmpty(ResourceToResourceFolder_Id))
{
ltlClasses.Text = StatsCommonHandle.GetTeacherClass(UserId, ClassID, ClassName, ResourceToResourceFolder_Id);//有效班级
if (string.IsNullOrEmpty(ClassID))
{
ClassID = "-1";
}
}
}
}
protected void Page_Load(object sender, EventArgs e)
{
ClassID = Request.QueryString["ClassID"].Filter();
TeacherID = Request.QueryString["TeacherID"].Filter();
ClassName = Request.QueryString["ClassName"].Filter();
UserId = FloginUser.UserId;
ResourceToResourceFolder_Id = Request.QueryString["ResourceToResourceFolder_Id"].Filter();
HomeWork_ID = Request.QueryString["HomeWork_ID"].Filter();
if (!IsPostBack)
{
if (!string.IsNullOrEmpty(TeacherID))
{
StrTemp = "&ClassID=" + ClassID + "&ClassName=" + ClassName + "&TeacherID=" + TeacherID;
UserId = TeacherID;
}
StudentNum = "[ {value: 10,name: '优秀'},{value: 20,name: '良好'},{value: 30,name: '中等'},{value: 40,name: '及格'},{value: 50,name: '不及格'}]";
if (!string.IsNullOrEmpty(ResourceToResourceFolder_Id))
{
ltlClasses.Text = StatsCommonHandle.GetTeacherClass(UserId, ClassID, ClassName, ResourceToResourceFolder_Id);//有效班级
if (string.IsNullOrEmpty(ClassID))
{
ClassID = "-1";
}
}
}
}
/// <summary>
/// 班级
/// </summary>
public static string GetClass(string SubjectID, string TeacherID)
{
try
{
string StrWhere = string.Empty;
string TempDate = string.Empty;
Model_F_User loginUser = HttpContext.Current.Session["FLoginUser"] as Model_F_User;
// if (SubjectID != loginUser.Subject)
// {
// StrWhere = @" and ClassId in(select ClassId from (
//select distinct vw.ClassId,AnalysisDataCount=(select COUNT(1) from HomeWork where UserGroup_Id=vw.ClassId)
//from VW_UserOnClassGradeSchool vw where ClassMemberShipEnum='" + MembershipEnum.headmaster + "' and UserId='" + loginUser.UserId + "') t where AnalysisDataCount>0) ";
// }
// else
// {
StrWhere = @" and ClassId in(select ClassId from (
select distinct vw.ClassId,AnalysisDataCount=(select COUNT(1) from HomeWork where UserGroup_Id=vw.ClassId)
from VW_UserOnClassGradeSchool vw where ClassMemberShipEnum in('" + MembershipEnum.headmaster + "','" + MembershipEnum.teacher + "') and UserId='" + loginUser.UserId + "') t where AnalysisDataCount>0) ";
//}
TempDate = StatsCommonHandle.GetTeacherClassByTeacherIdForCommon(TeacherID, StrWhere);
return(TempDate);
}
catch (Exception)
{
throw;
}
}
private void LoadData()
{
dtGrade = StatsCommonHandle.GetTeacherGradeData();
if (dtGrade.Rows.Count > 0)
{
string ss = dtGrade.Rows[0]["GroupGradeTypeName"].ToString();
DataView dataView = dtGrade.DefaultView;
DataTable dtDistinct = dataView.ToTable(true, "GroupGradeType", "GroupGradeTypeName");
rptStudysection.DataSource = dtDistinct;
rptStudysection.DataBind();
}
}
/// <summary>
/// 班级
/// </summary>
public static string GetClass(string SubjectID, string TeacherID)
{
try
{
string TempDate = string.Empty;
TempDate = StatsCommonHandle.GetTeacherClassBySubject(TeacherID.Filter(), SubjectID.Filter());
return(TempDate);
}
catch (Exception)
{
throw;
}
}
/// <summary>
/// 班级
/// </summary>
public static string GetClass(string TeacherID)
{
try
{
string StrWhere = string.Empty;
string TempDate = string.Empty;
Model_F_User loginUser = HttpContext.Current.Session["FLoginUser"] as Model_F_User;
TempDate = StatsCommonHandle.GetTeacherClassByTeacherId(TeacherID, "");
return(TempDate);
}
catch (Exception)
{
return("");
}
}
/// <summary>
/// 班级
/// </summary>
public static string GetClass(string TeacherID)
{
try
{
string StrWhere = string.Empty;
string TempDate = string.Empty;
StrWhere = @" and ClassId in(select ClassId from (
select distinct vw.ClassId,AnalysisDataCount=(select COUNT(1) from HomeWork where UserGroup_Id=vw.ClassId)
from VW_UserOnClassGradeSchool vw where ClassMemberShipEnum in('" + MembershipEnum.headmaster + "','" + MembershipEnum.teacher + "') and UserId='" + TeacherID + "') t where AnalysisDataCount>0) ";
TempDate = StatsCommonHandle.GetTeacherClassByTeacherIdForCommon(TeacherID, StrWhere);
return(TempDate);
}
catch (Exception)
{
throw;
}
}
public static string GetGradeList(string UserID)
{
try
{
UserID = UserID.Filter();
string strWhere = string.Empty;
List <object> ListReturn = new List <object>();
DataTable dt = StatsCommonHandle.GetTeacherGradeData();
foreach (DataRow item in dt.Rows)
{
ListReturn.Add(new
{
GradeName = item["GradeName"].ToString(),
GradeId = item["GradeId"].ToString(),
ClassCount = item["ClassCount"].ToString(),
StudentCount = item["StudentCount"].ToString()
});
}
if (dt.Rows.Count > 0)
{
return(JsonConvert.SerializeObject(new
{
err = "",
list = ListReturn
}));
}
else
{
return(JsonConvert.SerializeObject(new
{
err = "暂无数据"
}));
}
}
catch (Exception ex)
{
return(JsonConvert.SerializeObject(new
{
err = ex.Message.ToString()
}));
}
}
/// <summary>
/// 班级
/// </summary>
protected void GetClass()
{
ltlClass.Text = StatsCommonHandle.GetGradeAllClass(GradeId);
}
/// <summary>
/// 学科
/// </summary>
protected void GetSubject()
{
ltlSubject.Text = StatsCommonHandle.GetTeacherSubjectData();
}
/// <summary>
/// 学科
/// </summary>
public void GetSubjec()
{
ltlSubject.Text = StatsCommonHandle.GetTeacherSubjectData();
}
/// <summary>
/// 老师（班主任和代课老师）
/// </summary>
protected void GetAllTeacher()
{
ltlTeacher.Text = StatsCommonHandle.GetAllTeacher();
}
public static string GetEachHWAnalysis(string HWName, string HomeWorkCreateTime, string HomeWorkFinishTime, string SubjectID, string ClassID, string TeacherID, int PageIndex, int PageSize)
{
try
{
HWName = HWName.Filter();
HomeWorkCreateTime = HomeWorkCreateTime.Filter();
HomeWorkFinishTime = HomeWorkFinishTime.Filter();
SubjectID = SubjectID.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(SubjectID))
{
strWhere += " and T.SubjectID = '" + SubjectID + "'";
}
if (!string.IsNullOrEmpty(ClassID))
{
strWhere += " and T.UserGroup_Id = '" + ClassID + "'";
}
else
{
strWhere += StatsCommonHandle.GetStrWhereBySelfClassForComment(SubjectID);
}
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(),
//SubjectName = dt.Rows[i]["SubjectName"].ToString(),
HomeWork_Id = dt.Rows[i]["HomeWork_Id"].ToString(),
CreateTime = pfunction.ConvertToLongDateTime(dt.Rows[i]["CreateTime"].ToString(), "yyyy-MM-dd"),
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()
}));
}
}
/// <summary>
/// 学科
/// </summary>
protected void GetSubject()
{
ltlSubject.Text = StatsCommonHandle.GetTeacherSubjectForComment(FloginUser.UserId.Filter()); //StatsCommonHandle.GetTeacherSubject();
}
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()
}));
}
}
