public bool Update(Model_StatsHelper model) { StringBuilder builder = new StringBuilder(); builder.Append("update StatsHelper set "); builder.Append("ResourceToResourceFolder_Id=@ResourceToResourceFolder_Id,"); builder.Append("Homework_Id=@Homework_Id,"); builder.Append("Correct_Time=@Correct_Time,"); builder.Append("Exec_Status=@Exec_Status,"); builder.Append("SType=@SType,"); builder.Append("CreateUser=@CreateUser,"); builder.Append("Exec_Time=@Exec_Time,"); builder.Append("SchoolId=@SchoolId,"); builder.Append("GradeId=@GradeId,"); builder.Append("ClassId=@ClassId,"); builder.Append("TeacherId=@TeacherId,"); builder.Append("HW_CreateTime=@HW_CreateTime"); builder.Append(" where StatsHelper_Id=@StatsHelper_Id "); SqlParameter[] cmdParms = new SqlParameter[] { new SqlParameter("@ResourceToResourceFolder_Id", SqlDbType.Char, 0x24), new SqlParameter("@Homework_Id", SqlDbType.Char, 0x24), new SqlParameter("@Correct_Time", SqlDbType.DateTime), new SqlParameter("@Exec_Status", SqlDbType.Char, 1), new SqlParameter("@SType", SqlDbType.VarChar, 50), new SqlParameter("@CreateUser", SqlDbType.Char, 0x24), new SqlParameter("@Exec_Time", SqlDbType.DateTime), new SqlParameter("@SchoolId", SqlDbType.Char, 0x24), new SqlParameter("@GradeId", SqlDbType.Char, 0x24), new SqlParameter("@ClassId", SqlDbType.Char, 0x24), new SqlParameter("@TeacherId", SqlDbType.Char, 0x24), new SqlParameter("@HW_CreateTime", SqlDbType.DateTime), new SqlParameter("@StatsHelper_Id", SqlDbType.Char, 0x24) }; cmdParms[0].Value = model.ResourceToResourceFolder_Id; cmdParms[1].Value = model.Homework_Id; cmdParms[2].Value = model.Correct_Time; cmdParms[3].Value = model.Exec_Status; cmdParms[4].Value = model.SType; cmdParms[5].Value = model.CreateUser; cmdParms[6].Value = model.Exec_Time; cmdParms[7].Value = model.SchoolId; cmdParms[8].Value = model.GradeId; cmdParms[9].Value = model.ClassId; cmdParms[10].Value = model.TeacherId; cmdParms[11].Value = model.HW_CreateTime; cmdParms[12].Value = model.StatsHelper_Id; return(DbHelperSQL.ExecuteSql(builder.ToString(), cmdParms) > 0); }
public List <Model_StatsHelper> DataTableToList(DataTable dt) { List <Model_StatsHelper> list = new List <Model_StatsHelper>(); int count = dt.Rows.Count; if (count > 0) { for (int i = 0; i < count; i++) { Model_StatsHelper item = this.dal.DataRowToModel(dt.Rows[i]); if (item != null) { list.Add(item); } } } return(list); }
public bool Add(Model_StatsHelper model) { StringBuilder builder = new StringBuilder(); builder.Append("insert into StatsHelper("); builder.Append("StatsHelper_Id,ResourceToResourceFolder_Id,Homework_Id,Correct_Time,Exec_Status,SType,CreateUser,Exec_Time,SchoolId,GradeId,ClassId,TeacherId,HW_CreateTime)"); builder.Append(" values ("); builder.Append("@StatsHelper_Id,@ResourceToResourceFolder_Id,@Homework_Id,@Correct_Time,@Exec_Status,@SType,@CreateUser,@Exec_Time,@SchoolId,@GradeId,@ClassId,@TeacherId,@HW_CreateTime)"); SqlParameter[] cmdParms = new SqlParameter[] { new SqlParameter("@StatsHelper_Id", SqlDbType.Char, 0x24), new SqlParameter("@ResourceToResourceFolder_Id", SqlDbType.Char, 0x24), new SqlParameter("@Homework_Id", SqlDbType.Char, 0x24), new SqlParameter("@Correct_Time", SqlDbType.DateTime), new SqlParameter("@Exec_Status", SqlDbType.Char, 1), new SqlParameter("@SType", SqlDbType.VarChar, 50), new SqlParameter("@CreateUser", SqlDbType.Char, 0x24), new SqlParameter("@Exec_Time", SqlDbType.DateTime), new SqlParameter("@SchoolId", SqlDbType.Char, 0x24), new SqlParameter("@GradeId", SqlDbType.Char, 0x24), new SqlParameter("@ClassId", SqlDbType.Char, 0x24), new SqlParameter("@TeacherId", SqlDbType.Char, 0x24), new SqlParameter("@HW_CreateTime", SqlDbType.DateTime) }; cmdParms[0].Value = model.StatsHelper_Id; cmdParms[1].Value = model.ResourceToResourceFolder_Id; cmdParms[2].Value = model.Homework_Id; cmdParms[3].Value = model.Correct_Time; cmdParms[4].Value = model.Exec_Status; cmdParms[5].Value = model.SType; cmdParms[6].Value = model.CreateUser; cmdParms[7].Value = model.Exec_Time; cmdParms[8].Value = model.SchoolId; cmdParms[9].Value = model.GradeId; cmdParms[10].Value = model.ClassId; cmdParms[11].Value = model.TeacherId; cmdParms[12].Value = model.HW_CreateTime; return(DbHelperSQL.ExecuteSql(builder.ToString(), cmdParms) > 0); }
public Model_StatsHelper DataRowToModel(DataRow row) { Model_StatsHelper helper = new Model_StatsHelper(); if (row != null) { if (row["StatsHelper_Id"] != null) { helper.StatsHelper_Id = row["StatsHelper_Id"].ToString(); } if (row["ResourceToResourceFolder_Id"] != null) { helper.ResourceToResourceFolder_Id = row["ResourceToResourceFolder_Id"].ToString(); } if (row["Homework_Id"] != null) { helper.Homework_Id = row["Homework_Id"].ToString(); } if ((row["Correct_Time"] != null) && (row["Correct_Time"].ToString() != "")) { helper.Correct_Time = new DateTime?(DateTime.Parse(row["Correct_Time"].ToString())); } if (row["Exec_Status"] != null) { helper.Exec_Status = row["Exec_Status"].ToString(); } if (row["SType"] != null) { helper.SType = row["SType"].ToString(); } if (row["CreateUser"] != null) { helper.CreateUser = row["CreateUser"].ToString(); } if ((row["Exec_Time"] != null) && (row["Exec_Time"].ToString() != "")) { helper.Exec_Time = new DateTime?(DateTime.Parse(row["Exec_Time"].ToString())); } if (row["SchoolId"] != null) { helper.SchoolId = row["SchoolId"].ToString(); } if (row["GradeId"] != null) { helper.GradeId = row["GradeId"].ToString(); } if (row["ClassId"] != null) { helper.ClassId = row["ClassId"].ToString(); } if (row["TeacherId"] != null) { helper.TeacherId = row["TeacherId"].ToString(); } if ((row["HW_CreateTime"] != null) && (row["HW_CreateTime"].ToString() != "")) { helper.HW_CreateTime = new DateTime?(DateTime.Parse(row["HW_CreateTime"].ToString())); } } return(helper); }
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); }
public int TeacherCorrectStuHomeWork(Model_Student_HomeWork_Correct modelSHWCorrect, List <Model_Student_HomeWorkAnswer> listModel, Model_StatsHelper modelSH_HW) { return(this.dal.TeacherCorrectStuHomeWork(modelSHWCorrect, listModel, modelSH_HW)); }
public int TeacherCorrectStuHomeWork(Model_Student_HomeWork_Correct modelSHWCorrect, List <Model_Student_HomeWorkAnswer> listModel, Model_StatsHelper modelSH_HW) { new Dictionary <string, SqlParameter[]>(); StringBuilder builder = new StringBuilder(); builder = new StringBuilder(); builder.Append("update Student_HomeWork_Correct set "); builder.AppendFormat("Student_HomeWork_CorrectStatus='{0}'", modelSHWCorrect.Student_HomeWork_CorrectStatus); builder.AppendFormat(",CorrectTime='{0}'", modelSHWCorrect.CorrectTime.ToString()); builder.AppendFormat(",CorrectMode='{0}'", modelSHWCorrect.CorrectMode.ToString()); builder.AppendFormat(",CorrectUser='******'", modelSHWCorrect.CorrectUser.ToString()); builder.AppendFormat(" where Student_HomeWork_Id='{0}';", modelSHWCorrect.Student_HomeWork_Id); foreach (Model_Student_HomeWorkAnswer answer in listModel) { builder.Append("update Student_HomeWorkAnswer set "); builder.AppendFormat("Student_Score='{0}',", answer.Student_Score); builder.AppendFormat("Student_Answer_Status='{0}',", answer.Student_Answer_Status); builder.AppendFormat("Comment='{0}',", answer.Comment); builder.AppendFormat("isRead='{0}'", answer.isRead); builder.AppendFormat(" where Student_HomeWorkAnswer_Id='{0}'; ", answer.Student_HomeWorkAnswer_Id); } builder.AppendFormat("delete from Student_WrongHomeWork where Student_HomeWorkAnswer_Id in(select Student_HomeWorkAnswer_Id from Student_HomeWorkAnswer where Student_HomeWork_Id='{0}'); ", modelSHWCorrect.Student_HomeWork_Id); builder.AppendFormat("insert into Student_WrongHomeWork\r\nselect NEWID(),t.Student_HomeWorkAnswer_Id,getdate() from Student_HomeWorkAnswer t inner join TestQuestions_Score tq on tq.TestQuestions_Score_ID=t.TestQuestions_Score_ID\r\nwhere tq.TestQuestions_Score!=-1 and t.Student_Answer_Status<>'right' and t.Student_HomeWork_Id='{0}'; ", modelSHWCorrect.Student_HomeWork_Id); builder.AppendFormat("update StatsHelper set Correct_Time='{0}',Exec_Status='0' where (SType='1' or SType='3') and Homework_Id='{1}' ;", modelSH_HW.Correct_Time, modelSH_HW.Homework_Id); builder.AppendFormat("update StatsHelper set Correct_Time='{0}',Exec_Status='0' where SType='2' and ResourceToResourceFolder_Id='{1}' and GradeId='{2}' ;", modelSH_HW.Correct_Time, modelSH_HW.ResourceToResourceFolder_Id, modelSH_HW.GradeId); int num = DbHelperSQL.ExecuteSql(builder.ToString()); if (num > 0) { return(num); } return(0); }
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 Add(Model_StatsHelper model) { return(this.dal.Add(model)); }
public bool Update(Model_StatsHelper model) { return(this.dal.Update(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()); } }