public static string UpdateC(string Id) { try { Model_F_User loginUser = HttpContext.Current.Session["FLoginUser"] as Model_F_User; Id = Id.Filter(); Model_HomeWork model = new Model_HomeWork(); BLL_HomeWork bll = new BLL_HomeWork(); model = bll.GetModel(Id); model.HomeWork_Status = 0; model.HomeWork_FinishTime = null; if (loginUser.UserId != model.HomeWork_AssignTeacher)//当前登录用户和布置改作业的老师不一致 { return(""); } else { if (bll.Update(model)) { return("1"); } else { return(""); } } } catch (Exception) { return(""); } }
protected void Page_Load(object sender, EventArgs e) { HomeWork_Id = Request["HomeWork_Id"].Filter(); Student_HomeWork_Id = Request["Student_HomeWork_Id"].Filter(); StudentId = Request["StudentId"].Filter(); if (!IsPostBack) { try { Model_HomeWork model = new Model_HomeWork(); model = new BLL_HomeWork().GetModel(HomeWork_Id); if (model != null) { ResourceToResourceFolder_Id = model.ResourceToResourceFolder_Id; } #region 读取连接link if (string.IsNullOrEmpty(Student_HomeWork_Id))//web端批改 { link += string.Format("<li><a href='../student/OHomeWorkViewTTNew.aspx?ResourceToResourceFolder_Id={0}&HomeWork_Id={1}&StudentId={2}'>批改详情</a></li><li><li><a href='../Evaluation/StudentAnalysisReportsNew.aspx?ResourceToResourceFolder_Id={0}&HomeWork_Id={1}&StudentId={2}'>答题分析</a></li><li class='active'><a href='../Evaluation/StudentErrorAnalysis.aspx?ResourceToResourceFolder_Id={0}&HomeWork_Id={1}&StudentId={2}'>错题分析</a></li><li><a href='../Evaluation/StudentRemedyScheme.aspx?ResourceToResourceFolder_Id={0}&HomeWork_Id={1}&StudentId={2}'>补救方案</a></li>", ResourceToResourceFolder_Id, HomeWork_Id, StudentId); } else//客户端批改 { link += string.Format(@"<li><a href='../student/ohomeworkview_clientNew.aspx?ResourceToResourceFolder_Id={0}&HomeWork_Id={1}&StudentId={2}&Student_HomeWork_Id={3}'>批改详情</a></li><li><a href='../Evaluation/StudentAnalysisReportsNew.aspx?ResourceToResourceFolder_Id={0}&HomeWork_Id={1}&StudentId={2}&Student_HomeWork_Id={3}'>答题分析</a></li><li class='active'><a href='../Evaluation/StudentErrorAnalysis.aspx?ResourceToResourceFolder_Id={0}&HomeWork_Id={1}&StudentId={2}&Student_HomeWork_Id={3}'>错题分析</a></li><li><a href='../Evaluation/StudentRemedyScheme.aspx?ResourceToResourceFolder_Id={0}&HomeWork_Id={1}&StudentId={2}&Student_HomeWork_Id={3}'>补救方案</a></li>" , ResourceToResourceFolder_Id , HomeWork_Id , StudentId , Student_HomeWork_Id); } #endregion #region 读取作业基本信息 DataTable dtw = new DataTable(); dtw = Rc.Common.DBUtility.DbHelperSQL.Query(string.Format(@"select hw.* ,vw.GradeName,vw.GradeId,vw.ClassId,vw.ClassName ,u.UserName,u.TrueName ,HWScore=(select SUM(TestQuestions_Score) from TestQuestions_Score where TestQuestions_Score!=-1 and ResourceToResourceFolder_Id=hw.ResourceToResourceFolder_Id) ,StudentScore=(select SUM(Student_Score) from Student_HomeWorkAnswer where Student_Id='{0}' and HomeWork_Id=hw.HomeWork_Id ) ,shwCorrect.Student_HomeWork_CorrectStatus from HomeWork hw inner join Student_HomeWork shw on shw.Student_Id='{0}' and shw.HomeWork_Id=hw.HomeWork_Id inner join Student_HomeWork_Correct shwCorrect on shwCorrect.Student_HomeWork_Id=shw.Student_HomeWork_Id inner join F_User u on u.UserId=shw.Student_Id left join VW_ClassGradeSchool vw on vw.ClassId=hw.UserGroup_Id and vw.GradeId!='' where hw.HomeWork_Id='{1}'" , StudentId, HomeWork_Id)).Tables[0]; this.Title = dtw.Rows[0]["HomeWork_Name"].ToString(); this.ltlHwName.Text = dtw.Rows[0]["HomeWork_Name"].ToString(); this.ltlClassName.Text = dtw.Rows[0]["ClassName"].ToString(); this.ltlGradeName.Text = dtw.Rows[0]["GradeName"].ToString(); this.ltlSundentName.Text = string.IsNullOrEmpty(dtw.Rows[0]["TrueName"].ToString()) ? dtw.Rows[0]["UserName"].ToString() : dtw.Rows[0]["TrueName"].ToString(); this.ltlHwSorce.Text = dtw.Rows[0]["HWScore"].ToString().clearLastZero(); this.ltlStuScorce.Text = dtw.Rows[0]["StudentScore"].ToString().clearLastZero(); #endregion } catch (Exception) { Response.Write("页面加载失败..."); Response.End(); } } }
public static string UpdateHomeWork(string HomeWorkID, string CorrectMode) { try { HomeWorkID = HomeWorkID.Filter(); CorrectMode = CorrectMode.Filter(); Model_HomeWork model = new Model_HomeWork(); BLL_HomeWork bll = new BLL_HomeWork(); model = bll.GetModel(HomeWorkID); model.CorrectMode = CorrectMode; if (bll.UpdateCorrectMode(model) > 0) { return("1"); } else { return(""); } } catch (Exception) { return(""); } }
public static string UpdateS(string Id) { try { Model_F_User loginUser = HttpContext.Current.Session["FLoginUser"] as Model_F_User; Id = Id.Filter(); Model_HomeWork model = new Model_HomeWork(); BLL_HomeWork bll = new BLL_HomeWork(); model = bll.GetModel(Id); model.HomeWork_Status = 1; model.HomeWork_FinishTime = DateTime.Now; if (loginUser.UserId != model.HomeWork_AssignTeacher)//当前登录用户和布置改作业的老师不一致 { return(""); } else { if (bll.Update(model)) { //#region 执行数据分析,记录日志 //Model_StatsLog modelLog = new Model_StatsLog(); //modelLog.StatsLogId = Guid.NewGuid().ToString(); //modelLog.DataId = model.HomeWork_Id; //modelLog.DataName = model.HomeWork_Name; //modelLog.DataType = "1"; //modelLog.LogStatus = "2"; //modelLog.CTime = DateTime.Now; //modelLog.CUser = loginUser.UserId; //new BLL_StatsLog().ExecuteStatsAddLog(modelLog); //#endregion return("1"); } else { return(""); } } } catch (Exception) { return(""); } }
public List <Model_HomeWork> DataTableToList(DataTable dt) { List <Model_HomeWork> list = new List <Model_HomeWork>(); int count = dt.Rows.Count; if (count > 0) { for (int i = 0; i < count; i++) { Model_HomeWork item = this.dal.DataRowToModel(dt.Rows[i]); if (item != null) { list.Add(item); } } } return(list); }
protected void Page_Load(object sender, EventArgs e) { strTestpaperViewWebSiteUrl = pfunction.GetResourceHost("TestWebSiteUrl"); ClassId = Request.QueryString["ClassId"].Filter(); stuHomeWorkId = Request.QueryString["stuHomeWorkId"].Filter(); HomeWork_Id = Request.QueryString["HomeWork_Id"].Filter(); if (!IsPostBack) { modelHW = new BLL_HomeWork().GetModel(HomeWork_Id); hwCreateTime = modelHW.CreateTime.ToString(); this.Title = ltlTitle.Text = modelHW.HomeWork_Name; ResourceToResourceFolder_Id = modelHW.ResourceToResourceFolder_Id; if (!string.IsNullOrEmpty(ResourceToResourceFolder_Id)) { LoadData(); } } }
private void LoadData() { Model_HomeWork hwmodel = new Model_HomeWork(); BLL_HomeWork hwbll = new BLL_HomeWork(); hwmodel = hwbll.GetModel(HomeWork_Id); this.txtStopTime.Text = pfunction.ConvertToLongerDateTime(hwmodel.StopTime.ToString()); //this.txtBeginTime.Text = pfunction.ConvertToLongerDateTime(hwmodel.BeginTime.ToString()); string txtTimeLength = hwmodel.isTimeLength.ToString(); string strWhere = string.Format(" User_ApplicationStatus='passed' and UserStatus='0' and UserGroup_Id='{0}' and MembershipEnum='{1}' ", classId, MembershipEnum.student); rptStudentList.DataSource = new BLL_UserGroup_Member().GetClassMemberListEX(strWhere, HomeWork_Id, "HomeWork_Id,TrueName").Tables[0]; rptStudentList.DataBind(); Model_UserGroup modelUserGroup = new BLL_UserGroup().GetModel(classId); if (modelUserGroup != null) { className = modelUserGroup.UserGroup_Name; } }
private bool LoadData() { bool flag = false; try { Stream resStream = HttpContext.Current.Request.InputStream; StreamReader sr = new StreamReader(resStream, System.Text.Encoding.UTF8); string testJsion = sr.ReadToEnd(); string resInfo = testJsion; tchAssignModel modelAssign = JsonConvert.DeserializeObject <tchAssignModel>(resInfo); Model_HomeWork model = new Model_HomeWork(); model.SubjectId = modelAssign.SubjectId; #region 布置作业表 model.HomeWork_Id = modelAssign.HomeWork_Id; model.ResourceToResourceFolder_Id = modelAssign.ResourceToResourceFolder_Id; model.HomeWork_Name = modelAssign.HomeWork_Name; model.HomeWork_AssignTeacher = modelAssign.HomeWork_AssignTeacher; model.BeginTime = modelAssign.BeginTime; model.StopTime = modelAssign.StopTime; model.IsHide = modelAssign.IsHide; model.HomeWork_Status = modelAssign.HomeWork_Status; model.CreateTime = modelAssign.CreateTime; model.UserGroup_Id = modelAssign.UserGroup_Id; model.isTimeLimt = modelAssign.isTimeLimt; model.isTimeLength = modelAssign.isTimeLength; model.SubjectId = modelAssign.SubjectId; model.IsShowAnswer = modelAssign.IsShowAnswer; #endregion #region 学生作业表 List <Model_Student_HomeWork> listSHomwWork = new List <Model_Student_HomeWork>(); List <Model_Student_HomeWork_Submit> listSHomwWorkSubmit = new List <Model_Student_HomeWork_Submit>(); List <Model_Student_HomeWork_Correct> listSHomwWorkCorrect = new List <Model_Student_HomeWork_Correct>(); string strStudent = modelAssign.stuInfo; string[] strArrStudent = strStudent.Split(','); for (int i = 0; i < strArrStudent.Length; i++) { string ShwGuid = Guid.NewGuid().ToString(); Model_Student_HomeWork modelSHomeWork = new Model_Student_HomeWork(); modelSHomeWork.Student_HomeWork_Id = ShwGuid; modelSHomeWork.HomeWork_Id = modelAssign.HomeWork_Id; modelSHomeWork.Student_Id = strArrStudent[i]; modelSHomeWork.CreateTime = modelAssign.CreateTime; listSHomwWork.Add(modelSHomeWork); #region 作业提交状态 Model_Student_HomeWork_Submit modelSHomeWorkSubmit = new Model_Student_HomeWork_Submit(); modelSHomeWorkSubmit.Student_HomeWork_Id = ShwGuid; modelSHomeWorkSubmit.Student_HomeWork_Status = 0; listSHomwWorkSubmit.Add(modelSHomeWorkSubmit); #endregion #region 作业批改状态 Model_Student_HomeWork_Correct modelSHomeWorkCorrect = new Model_Student_HomeWork_Correct(); modelSHomeWorkCorrect.Student_HomeWork_Id = ShwGuid; modelSHomeWorkCorrect.Student_HomeWork_CorrectStatus = 0; listSHomwWorkCorrect.Add(modelSHomeWorkCorrect); #endregion } #endregion #region 统计帮助表 DataTable dtHWDetail = Rc.Common.DBUtility.DbHelperSQL.Query("select * from VW_ClassGradeSchool where ClassId='" + modelAssign.UserGroup_Id + "' and GradeId is not null and SchoolId is not null ").Tables[0]; Model_StatsHelper modelSH_HW = new Model_StatsHelper(); modelSH_HW.StatsHelper_Id = Guid.NewGuid().ToString(); modelSH_HW.ResourceToResourceFolder_Id = model.ResourceToResourceFolder_Id; modelSH_HW.Homework_Id = model.HomeWork_Id; modelSH_HW.Exec_Status = "0"; modelSH_HW.SType = "1"; modelSH_HW.CreateUser = modelAssign.HomeWork_AssignTeacher; modelSH_HW.SchoolId = dtHWDetail.Rows[0]["SchoolId"].ToString(); modelSH_HW.GradeId = dtHWDetail.Rows[0]["GradeId"].ToString(); modelSH_HW.ClassId = modelAssign.UserGroup_Id; modelSH_HW.TeacherId = modelAssign.HomeWork_AssignTeacher; modelSH_HW.HW_CreateTime = modelAssign.CreateTime; #endregion Rc.Common.SystemLog.SystemLog.AddLogFromBS(modelAssign.HomeWork_AssignTeacher, "", "布置作业(学校服务器):4开始写入数据123"); if (new BLL_HomeWork().AddHomework(model, listSHomwWork, listSHomwWorkSubmit, listSHomwWorkCorrect, modelSH_HW)) { Rc.Common.SystemLog.SystemLog.AddLogFromBS(modelAssign.HomeWork_AssignTeacher, "", "布置作业(学校服务器):4结束写入数据"); if (GenerateTestPaperFileForStudent(modelAssign.HomeWork_AssignTeacher, modelAssign.HomeWork_Id)) { flag = true; } else { //RevokeHW 生成学生作业文件失败 撤销作业 new BLL_HomeWork().RevokeHW(model.HomeWork_Id); Rc.Common.SystemLog.SystemLog.AddLogErrorFromBS(modelAssign.HomeWork_AssignTeacher, "", "布置作业失败(学校服务器):生成学生作业文件失败"); } } else { //RevokeHW 写入数据失败 撤销作业 new BLL_HomeWork().RevokeHW(model.HomeWork_Id); Rc.Common.SystemLog.SystemLog.AddLogErrorFromBS(modelAssign.HomeWork_AssignTeacher, "", "布置作业失败(学校服务器):写入数据失败"); } } catch (Exception ex) { Rc.Common.SystemLog.SystemLog.AddLogErrorFromBS("", "", "布置作业失败(学校服务器):" + ex.Message.ToString()); } return(flag); }
protected void Page_Load(object sender, EventArgs e) { try { StudentId = Request.QueryString["StudentId"].Filter(); strTestpaperViewWebSiteUrl = pfunction.GetResourceHost("TestWebSiteUrl"); if (!string.IsNullOrEmpty(StudentId) && strTestpaperViewWebSiteUrl == Rc.Common.ConfigHelper.GetConfigString("TestWebSiteUrl")) { strTestpaperViewWebSiteUrl = pfunction.GetResourceHost("TestWebSiteUrl", StudentId); } stuHomeWorkId = Request.QueryString["Student_HomeWork_Id"].Filter(); string reqWrong = Request["wrong"].Filter(); if (reqWrong == "w") { isShowWrong = true; } ResourceToResourceFolder_Id = Request.QueryString["ResourceToResourceFolder_Id"].Filter(); HomeWork_Id = Request.QueryString["HomeWork_Id"].Filter(); modelHW = new BLL_HomeWork().GetModel(HomeWork_Id); string tempSql = string.Empty; tempSql = string.Format(@"select COUNT(1) as icount from Student_HomeWork shw inner join Student_HomeWork_Correct shwCorrect on shwCorrect.Student_HomeWork_Id=shw.Student_HomeWork_Id where HomeWork_Id='{0}' and Student_Id='{1}' and shwCorrect.Student_HomeWork_CorrectStatus='{2}'", HomeWork_Id, StudentId, "1"); int i = int.Parse(Rc.Common.DBUtility.DbHelperSQL.GetSingle(tempSql).ToString()); if (i > 0) { //} List <Model_StatsClassStudentHW_Score> listSCSHW = new BLL_StatsClassStudentHW_Score().GetModelList(" HomeWork_ID='" + HomeWork_Id + "' and StudentId='" + StudentId + "' "); if (listSCSHW.Count > 0) { isCorrect = true; this.Title = listSCSHW[0].Resource_Name.ReplaceForFilter(); this.ltlTitle.Text = listSCSHW[0].Resource_Name.ReplaceForFilter() + "<span class='correct_state bg-success'>已完成批改</span>"; ltlGradeSubject.Text = string.Format("<span>年级:{0}</span><span>班级:{1}</span><span>学生:{2}</span><span>满分:{3}分</span><span>得分:{4}分</span>" , listSCSHW[0].GradeName , listSCSHW[0].ClassName , listSCSHW[0].StudentName , listSCSHW[0].HWScore.ToString().clearLastZero() , listSCSHW[0].StudentScore.ToString().clearLastZero()); } } else { #region 未批改 DataTable dtw = new DataTable(); dtw = Rc.Common.DBUtility.DbHelperSQL.Query(string.Format(@"select hw.* ,vw.GradeName,vw.GradeId,vw.ClassId,vw.ClassName ,u.UserName,u.TrueName ,HWScore=(select SUM(TestQuestions_Score) from TestQuestions_Score where ResourceToResourceFolder_Id=hw.ResourceToResourceFolder_Id) ,StudentScore=(select SUM(Student_Score) from Student_HomeWorkAnswer where Student_Id='{0}' and HomeWork_Id=hw.HomeWork_Id ) ,shwCorrect.Student_HomeWork_CorrectStatus from HomeWork hw inner join Student_HomeWork shw on shw.Student_Id='{0}' and shw.HomeWork_Id=hw.HomeWork_Id inner join Student_HomeWork_Correct shwCorrect on shwCorrect.Student_HomeWork_Id=shw.Student_HomeWork_Id inner join F_User u on u.UserId=shw.Student_Id left join VW_ClassGradeSchool vw on vw.ClassId=hw.UserGroup_Id and vw.GradeId!='' where hw.HomeWork_Id='{1}'" , StudentId, HomeWork_Id)).Tables[0]; this.Title = dtw.Rows[0]["HomeWork_Name"].ToString(); this.ltlTitle.Text = dtw.Rows[0]["HomeWork_Name"].ToString() + "<span class='correct_state bg-warning'>未完成批改</span>"; ltlGradeSubject.Text = string.Format("<span>年级:{0}</span><span>班级:{1}</span><span>学生:{2}</span><span>满分:{3}分</span><span>得分:{4}分</span>" , dtw.Rows[0]["GradeName"] , dtw.Rows[0]["ClassName"] , string.IsNullOrEmpty(dtw.Rows[0]["TrueName"].ToString()) ? dtw.Rows[0]["UserName"] : dtw.Rows[0]["TrueName"] , dtw.Rows[0]["HWScore"].ToString().clearLastZero() , dtw.Rows[0]["StudentScore"].ToString().clearLastZero()); if (dtw.Rows[0]["Student_HomeWork_CorrectStatus"].ToString() == "1") { isCorrect = true; } #endregion } StringBuilder stbLink = new StringBuilder(); stbLink.AppendFormat("<li {3}><a href=\"ohomeworkview_clientNew.aspx?ResourceToResourceFolder_Id={0}&HomeWork_Id={1}&StudentId={2}&Student_HomeWork_Id={4}\">批改详情</a></li>" , ResourceToResourceFolder_Id , HomeWork_Id , StudentId , (isShowWrong ? "" : "class=\"active\"") , stuHomeWorkId); if (isCorrect) { //stbLink.AppendFormat("<li {3}><a href=\"ohomeworkview_client.aspx?ResourceToResourceFolder_Id={0}&HomeWork_Id={1}&StudentId={2}&wrong=w&Student_HomeWork_Id={4}\">错题详情</a></li>" //, ResourceToResourceFolder_Id //, HomeWork_Id //, StudentId //, (isShowWrong ? "class=\"active\"" : "") //, stuHomeWorkId); //stbLink.AppendFormat("<li><a href=\"../Evaluation/StudentAnalysisReports.aspx?ResourceToResourceFolder_Id={0}&HomeWork_Id={1}&StudentId={2}&Student_HomeWork_Id={3}\">分析报告</a></li>" //, ResourceToResourceFolder_Id //, HomeWork_Id //, StudentId //, stuHomeWorkId); stbLink.AppendFormat("<li><a href=\"../Evaluation/StudentAnalysisReportsNew2.aspx?ResourceToResourceFolder_Id={0}&HomeWork_Id={1}&StudentId={2}&Student_HomeWork_Id={3}\">分析报告</a></li>" , ResourceToResourceFolder_Id , HomeWork_Id , StudentId , stuHomeWorkId); // stbLink.AppendFormat("<li><a href=\"../Evaluation/StudentErrorAnalysis.aspx?ResourceToResourceFolder_Id={0}&HomeWork_Id={1}&StudentId={2}&Student_HomeWork_Id={3}\">错题分析</a></li>" // , ResourceToResourceFolder_Id // , HomeWork_Id // , StudentId // , stuHomeWorkId); // stbLink.AppendFormat("<li><a href=\"../Evaluation/StudentRemedyScheme.aspx?ResourceToResourceFolder_Id={0}&HomeWork_Id={1}&StudentId={2}&Student_HomeWork_Id={3}\">补救方案</a></li>" //, ResourceToResourceFolder_Id //, HomeWork_Id //, StudentId //, stuHomeWorkId); } else { stbLink.AppendFormat("<li><a href=\"javascript:;\" title='老师未批改' class='disabled'>分析报告</a></li>" , ResourceToResourceFolder_Id , HomeWork_Id , StudentId , stuHomeWorkId); // stbLink.AppendFormat("<li><a href=\"javascript:;\" title='老师未批改' class='disabled'>错题分析</a></li>" // , ResourceToResourceFolder_Id // , HomeWork_Id // , StudentId // , stuHomeWorkId); // stbLink.AppendFormat("<li><a href=\"javascript:;\" title='老师未批改' class='disabled'>补救方案</a></li>" //, ResourceToResourceFolder_Id //, HomeWork_Id //, StudentId //, stuHomeWorkId); } ltlLink.Text = stbLink.ToString(); if (!IsPostBack) { } } catch (Exception) { Response.Write("页面加载失败..."); Response.End(); } }
public bool AddHomework(Model_HomeWork model, List <Model_Student_HomeWork> list, List <Model_Student_HomeWork_Submit> listSubmit, List <Model_Student_HomeWork_Correct> listCorrect, Model_StatsHelper modelSH_HW) { return(this.dal.AddHomework(model, list, listSubmit, listCorrect, modelSH_HW)); }
public bool Update(Model_HomeWork model) { return(this.dal.Update(model)); }
public bool Add(Model_HomeWork model) { return(this.dal.Add(model)); }
protected void btnSubmit_Click(object sender, EventArgs e) { try { Model_HomeWork model = new Model_HomeWork(); BLL_HomeWork bll = new BLL_HomeWork(); #region 布置作业表 string guid = HomeWork_Id; model = bll.GetModel(guid); model.StopTime = Convert.ToDateTime(txtStopTime.Text); #endregion #region 学生作业表 List <Model_Student_HomeWork> listSHomwWork = new List <Model_Student_HomeWork>(); List <Model_Student_HomeWork_Submit> listSHomwWorkSubmit = new List <Model_Student_HomeWork_Submit>(); List <Model_Student_HomeWork_Correct> listSHomwWorkCorrect = new List <Model_Student_HomeWork_Correct>(); string strStudent = Rc.Cloud.Web.Common.pfunction.CheckImp(hidStudentId.Value); strStudent = strStudent.TrimEnd(','); string[] strArrStudent = strStudent.Split(','); for (int i = 0; i < strArrStudent.Length; i++) { string ShwGuid = Guid.NewGuid().ToString(); Model_Student_HomeWork modelSHomeWork = new Model_Student_HomeWork(); modelSHomeWork.Student_HomeWork_Id = ShwGuid; modelSHomeWork.HomeWork_Id = guid; modelSHomeWork.Student_Id = strArrStudent[i]; modelSHomeWork.CreateTime = DateTime.Now; listSHomwWork.Add(modelSHomeWork); #region 作业提交状态 Model_Student_HomeWork_Submit modelSHomeWorkSubmit = new Model_Student_HomeWork_Submit(); modelSHomeWorkSubmit.Student_HomeWork_Id = ShwGuid; modelSHomeWorkSubmit.Student_HomeWork_Status = 0; listSHomwWorkSubmit.Add(modelSHomeWorkSubmit); #endregion #region 作业批改状态 Model_Student_HomeWork_Correct modelSHomeWorkCorrect = new Model_Student_HomeWork_Correct(); modelSHomeWorkCorrect.Student_HomeWork_Id = ShwGuid; modelSHomeWorkCorrect.Student_HomeWork_CorrectStatus = 0; listSHomwWorkCorrect.Add(modelSHomeWorkCorrect); #endregion } #endregion #region 统计帮助表 DataTable dtHWDetail = bll.GetHWDetail(HomeWork_Id).Tables[0]; Model_StatsHelper modelSH_HW = new Model_StatsHelper(); modelSH_HW.ResourceToResourceFolder_Id = model.ResourceToResourceFolder_Id; modelSH_HW.Homework_Id = model.HomeWork_Id; modelSH_HW.SchoolId = dtHWDetail.Rows[0]["SchoolId"].ToString(); modelSH_HW.GradeId = dtHWDetail.Rows[0]["GradeId"].ToString(); #endregion if (bll.UpdateHomework(model, listSHomwWork, listSHomwWorkSubmit, listSHomwWorkCorrect, modelSH_HW)) { string strJ = "layer.msg('布置作业成功',{time:1000,icon:1},function(){"; if (Request.QueryString["tp"] != "1") { strJ += "window.parent.loadData();"; } else { strJ += "window.parent.location.reload();"; } strJ += "parent.layer.close(parent.layer.getFrameIndex(window.name));});"; ClientScript.RegisterStartupScript(this.GetType(), "temp", strJ, true); Rc.Common.SystemLog.SystemLog.AddLogFromBS(FloginUser.UserId, "", "布置作业成功"); } else { ClientScript.RegisterStartupScript(this.GetType(), "temp", "layer.msg('布置作业失败',{time:2000,icon:2});", true); Rc.Common.SystemLog.SystemLog.AddLogErrorFromBS(FloginUser.UserId, "", "布置作业失败"); } } catch (Exception ex) { ClientScript.RegisterStartupScript(this.GetType(), "temp", "layer.msg('布置作业失败',{time:2000,icon:2});", true); Rc.Common.SystemLog.SystemLog.AddLogErrorFromBS(FloginUser.UserId, "", "布置作业失败:" + ex.Message.ToString()); } }
protected void Page_Load(object sender, EventArgs e) { HomeWork_Id = Request["HomeWork_Id"].Filter(); Student_HomeWork_Id = Request["Student_HomeWork_Id"].Filter(); StudentId = Request["StudentId"].Filter(); if (!IsPostBack) { Model_HomeWork model = new Model_HomeWork(); model = new BLL_HomeWork().GetModel(HomeWork_Id); if (model != null) { ResourceToResourceFolder_Id = model.ResourceToResourceFolder_Id; } #region 读取连接link if (string.IsNullOrEmpty(Student_HomeWork_Id))//web端批改 { link += string.Format("<li><a href='../student/OHomeWorkViewTTNew.aspx?ResourceToResourceFolder_Id={0}&HomeWork_Id={1}&StudentId={2}'>批改详情</a></li><li><li><a href='../Evaluation/StudentAnalysisReportsNew.aspx?ResourceToResourceFolder_Id={0}&HomeWork_Id={1}&StudentId={2}'>答题分析</a></li><li><a href='../Evaluation/StudentErrorAnalysis.aspx?ResourceToResourceFolder_Id={0}&HomeWork_Id={1}&StudentId={2}'>错题分析</a></li><li class='active'><a href='../Evaluation/StudentRemedyScheme.aspx?ResourceToResourceFolder_Id={0}&HomeWork_Id={1}&StudentId={2}'>补救方案</a></li>", ResourceToResourceFolder_Id, HomeWork_Id, StudentId); } else//客户端批改 { link += string.Format(@"<li><a href='../student/ohomeworkview_clientNew.aspx?ResourceToResourceFolder_Id={0}&HomeWork_Id={1}&StudentId={2}&Student_HomeWork_Id={3}'>批改详情</a></li><li><a href='../Evaluation/StudentAnalysisReportsNew.aspx?ResourceToResourceFolder_Id={0}&HomeWork_Id={1}&StudentId={2}&Student_HomeWork_Id={3}'>答题分析</a></li><li><a href='../Evaluation/StudentErrorAnalysis.aspx?ResourceToResourceFolder_Id={0}&HomeWork_Id={1}&StudentId={2}&Student_HomeWork_Id={3}'>错题分析</a></li><li class='active'><a href='../Evaluation/StudentRemedyScheme.aspx?ResourceToResourceFolder_Id={0}&HomeWork_Id={1}&StudentId={2}&Student_HomeWork_Id={3}'>补救方案</a></li>" , ResourceToResourceFolder_Id , HomeWork_Id , StudentId , Student_HomeWork_Id); } #endregion #region 读取作业基本信息 DataTable dtw = new DataTable(); dtw = Rc.Common.DBUtility.DbHelperSQL.Query(string.Format(@"select hw.* ,vw.GradeName,vw.GradeId,vw.ClassId,vw.ClassName ,u.UserName,u.TrueName ,HWScore=(select SUM(TestQuestions_Score) from TestQuestions_Score where TestQuestions_Score!=-1 and ResourceToResourceFolder_Id=hw.ResourceToResourceFolder_Id) ,StudentScore=(select SUM(Student_Score) from Student_HomeWorkAnswer where Student_Id='{0}' and HomeWork_Id=hw.HomeWork_Id ) ,shwCorrect.Student_HomeWork_CorrectStatus from HomeWork hw inner join Student_HomeWork shw on shw.Student_Id='{0}' and shw.HomeWork_Id=hw.HomeWork_Id inner join Student_HomeWork_Correct shwCorrect on shwCorrect.Student_HomeWork_Id=shw.Student_HomeWork_Id inner join F_User u on u.UserId=shw.Student_Id left join VW_ClassGradeSchool vw on vw.ClassId=hw.UserGroup_Id and vw.GradeId!='' where hw.HomeWork_Id='{1}'" , StudentId, HomeWork_Id)).Tables[0]; this.Title = dtw.Rows[0]["HomeWork_Name"].ToString(); this.ltlHwName.Text = dtw.Rows[0]["HomeWork_Name"].ToString(); this.ltlClassName.Text = dtw.Rows[0]["ClassName"].ToString(); this.ltlGradeName.Text = dtw.Rows[0]["GradeName"].ToString(); this.ltlSundentName.Text = string.IsNullOrEmpty(dtw.Rows[0]["TrueName"].ToString()) ? dtw.Rows[0]["UserName"].ToString() : dtw.Rows[0]["TrueName"].ToString(); this.ltlHwSorce.Text = dtw.Rows[0]["HWScore"].ToString().clearLastZero(); this.ltlStuScorce.Text = dtw.Rows[0]["StudentScore"].ToString().clearLastZero(); #endregion #region 数据分析 string sql = string.Format(@" select KPNameBasic=(select KPNameBasic+',' from [dbo].[StatsStuHW_Wrong_KP] where HomeWork_Id='{0}' and Student_Id='{1}' FOR XML PATH('') ) ,CountKPNameBasic=(select count(*) from [dbo].[StatsStuHW_Wrong_KP] where HomeWork_Id='{0}' and Student_Id='{1}' ) ,CountTQ=(select count(*) from [dbo].[StatsStuHW_Wrong_TQ] where HomeWork_Id='{0}' and Student_Id='{1}' ) ,topicNumber=(select replace(topicNumber,'.','')+'题,' from [dbo].[StatsStuHW_Wrong_TQ] where HomeWork_Id='{0}' and Student_Id='{1}' group by topicNumber,TestQuestions_Num order by TestQuestions_Num FOR XML PATH('') )" , HomeWork_Id , StudentId); DataTable Dt = Rc.Common.DBUtility.DbHelperSQL.Query(sql).Tables[0]; if (Dt.Rows.Count > 0) { ltlKPName.Text = Dt.Rows[0]["KPNameBasic"].ToString().TrimEnd(','); ltlCountKPName.Text = Dt.Rows[0]["CountKPNameBasic"].ToString(); ltlTQNum.Text = string.IsNullOrEmpty(Dt.Rows[0]["topicNumber"].ToString().TrimEnd(',')) ? "" : "请该同学对本次作业中的" + Dt.Rows[0]["topicNumber"].ToString().TrimEnd(',') + "进行再次练习,以便从中总结规律、方法、技巧,巩固对知识点的学习。"; //ltlCountTQ.Text = Dt.Rows[0]["CountTQ"].ToString().clearLastZero(); } #endregion } }