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
}
}
