//保存 protected void btnSubmit_Click(object sender, EventArgs e) { ChkAdminLevel("_ybd_answer_result", EnumCollection.ActionEnum.Modify.ToString()); //检查权限 BLL.answer_result bll = new BLL.answer_result(); Model.answer_result model = bll.GetModel(this.id); model.group_id = Convert.ToInt32(txtgroup_id.Text); model.exa_id = Convert.ToInt32(txtexa_id.Text); model.exa_title = Convert.ToString(txtexa_title.Text); model.user_id = Convert.ToInt32(txtuser_id.Text); model.avatar = Convert.ToString(txtavatar.Text); model.nick_name = Convert.ToString(txtnick_name.Text); model.use_min = Convert.ToInt32(txtuse_min.Text); model.use_sec = Convert.ToInt32(txtuse_sec.Text); model.truth_num = Convert.ToInt32(txttruth_num.Text); model.count = Convert.ToInt32(txtcount.Text); model.truth_ratio = Convert.ToDecimal(txttruth_ratio.Text); model.score = Convert.ToInt32(txtscore.Text); model.status = Convert.ToInt32(txtstatus.Text); model.add_time = Convert.ToDateTime(txtadd_time.Text); if (bll.Update(model)) { AddAdminLog(EnumCollection.ActionEnum.Modify.ToString(), "修改答题结果信息,主键:" + id); //记录日志 JscriptMsg("修改答题结果信息成功!", "Manage.aspx"); } else { JscriptMsg("保存过程中发生错误!", ""); } }
/// <summary> /// 获得Model /// </summary> /// <param name="Top">大于0取前几行数据,否则取全部</param> /// <param name="whereStr">where条件</param> /// <param name="filedOrder">排序字段Order By + filedOrder (不可为空)</param> /// <returns></returns> public Model.answer_result GetModel(int Top, string whereStr, string filedOrder) { DataTable dt = dal.GetList(Top, whereStr, filedOrder).Tables[0]; Model.answer_result model = dt.Rows.Count > 0 ? DataRowToModel(dt.Rows[0]) : null; return(model); }
/// <summary> /// 获得Model /// </summary> /// <param name="whereStr"></param> /// <returns></returns> public Model.answer_result GetModel(string whereStr) { DataTable dt = dal.GetList(whereStr).Tables[0]; Model.answer_result model = dt.Rows.Count > 0 ? DataRowToModel(dt.Rows[0]) : null; return(model); }
private void BindInfo() { BLL.answer_result bll = new BLL.answer_result(); Model.answer_result model = bll.GetModel(this.id); if (model == null) { JscriptMsg("信息不存在或已被删除!", "back"); return; } txtgroup_id.Text = model.group_id + ""; txtexa_id.Text = model.exa_id + ""; txtexa_title.Text = model.exa_title + ""; txtuser_id.Text = model.user_id + ""; txtavatar.Text = model.avatar + ""; txtnick_name.Text = model.nick_name + ""; txtuse_min.Text = model.use_min + ""; txtuse_sec.Text = model.use_sec + ""; txttruth_num.Text = model.truth_num + ""; txtcount.Text = model.count + ""; txttruth_ratio.Text = model.truth_ratio + ""; txtscore.Text = model.score + ""; txtstatus.Text = model.status + ""; txtadd_time.Text = model.add_time + ""; }
private void SumScore(int exa_id, int uid) { int truth_count = 0; int score = 0; BLL.common_questions qBll = new BLL.common_questions(); BLL.answer_record arBll = new BLL.answer_record(); BLL.common_answers aBll = new BLL.common_answers(); Model.user_info user = new BLL.user_info().GetModel(uid); Model.common_examination exa = new BLL.common_examination().GetModel(exa_id); if (exa != null) { DataTable dt = arBll.GetList(" exa_id = " + exa_id + " and user_id = " + uid); foreach (DataRow item in dt.Rows) { #region 批改作业按老师选择对错为准 int is_truth = Convert.ToInt32(item["is_truth"]); if (is_truth == 1) { truth_count++; score += Convert.ToInt32(item["score"]); } #endregion #region 批改作业按答题记录为准 //int q_id = Convert.ToInt32(item["q_id"]); //string answer = item["answer"].ToString(); //Model.common_questions question = qBll.GetModel(q_id); //if (!string.IsNullOrEmpty(answer))//没有答题 //{ // if (question.type == (int)EnumCollection.questions_type.单选题 || question.type == (int)EnumCollection.questions_type.判断题) // { // Model.common_answers anModel = aBll.GetModel(Convert.ToInt32(answer)); // if (anModel.options == question.answer) // { // truth_count++; // score += Convert.ToInt32(item["score"]); // } // } // if (question.type == (int)EnumCollection.questions_type.多选题) // { // string[] ids = answer.Split(new char[] { ',' }, StringSplitOptions.RemoveEmptyEntries); // string anids = string.Empty; // foreach (string id in ids) // { // Model.common_answers anModel = aBll.GetModel(Convert.ToInt32(id)); // anids += anModel.options + ","; // } // if (question.answer == Utils.DelLastComma(anids)) // { // truth_count++; // score += Convert.ToInt32(item["score"]); // } // } // if (question.type == (int)EnumCollection.questions_type.填空题 || question.type == (int)EnumCollection.questions_type.主观题) // { // if (answer.Contains(question.answer)) // { // truth_count++; // score += Convert.ToInt32(item["score"]); // } // } //} #endregion } BLL.answer_result bll = new BLL.answer_result(); Model.answer_result model = bll.GetModel(" group_id = " + (int)EnumCollection.examination_group.课堂作业 + " and exa_id = " + exa_id + " and user_id = " + uid); if (model != null) { model.truth_num = truth_count; model.count = exa.nums; model.truth_ratio = Convert.ToDecimal((decimal)model.truth_num / (decimal)model.count) * 100; model.score = score; model.status = (int)EnumCollection.correcting_status.已批改; bll.Update(model); } else { model = new Model.answer_result(); model.group_id = (int)EnumCollection.examination_group.课堂作业; model.exa_id = exa_id; model.exa_title = exa.name; model.user_id = uid; model.avatar = user.avatar; model.nick_name = user.nick_name; model.use_min = 0; model.use_sec = 0; model.truth_num = truth_count; model.count = exa.nums; model.truth_ratio = 0; model.score = score; model.status = (int)EnumCollection.correcting_status.未批改; model.add_time = System.DateTime.Now; bll.Add(model); } } }
/// <summary> /// 增加一条数据 /// </summary> public int Add(Model.answer_result model) { StringBuilder strSql = new StringBuilder(); strSql.Append(@"Insert Into ybd_answer_result( group_id ,exa_id ,exa_title ,user_id ,avatar ,nick_name ,use_min ,use_sec ,truth_num ,count ,truth_ratio ,score ,status ,add_time ) Values ( @group_id ,@exa_id ,@exa_title ,@user_id ,@avatar ,@nick_name ,@use_min ,@use_sec ,@truth_num ,@count ,@truth_ratio ,@score ,@status ,@add_time ); SELECT @@IDENTITY;"); SqlParameter[] parameters = { new SqlParameter("@group_id", SqlDbType.Int, 4) , new SqlParameter("@exa_id", SqlDbType.Int, 4) , new SqlParameter("@exa_title", SqlDbType.NVarChar, 50) , new SqlParameter("@user_id", SqlDbType.Int, 4) , new SqlParameter("@avatar", SqlDbType.NVarChar, 50) , new SqlParameter("@nick_name", SqlDbType.NVarChar, 50) , new SqlParameter("@use_min", SqlDbType.Int, 4) , new SqlParameter("@use_sec", SqlDbType.Int, 4) , new SqlParameter("@truth_num", SqlDbType.Int, 4) , new SqlParameter("@count", SqlDbType.Int, 4) , new SqlParameter("@truth_ratio", SqlDbType.Decimal, 5) , new SqlParameter("@score", SqlDbType.Int, 4) , new SqlParameter("@status", SqlDbType.Int, 4) , new SqlParameter("@add_time", SqlDbType.DateTime, 8) }; parameters[0].Value = model.group_id; parameters[1].Value = model.exa_id; parameters[2].Value = model.exa_title; parameters[3].Value = model.user_id; parameters[4].Value = model.avatar; parameters[5].Value = model.nick_name; parameters[6].Value = model.use_min; parameters[7].Value = model.use_sec; parameters[8].Value = model.truth_num; parameters[9].Value = model.count; parameters[10].Value = model.truth_ratio; parameters[11].Value = model.score; parameters[12].Value = model.status; parameters[13].Value = model.add_time; object obj = DbHelperSQL.GetSingle(strSql.ToString(), parameters); if (obj == null) { return(0); } else { return(Convert.ToInt32(obj)); } }
/// <summary> /// 更新一条数据 /// </summary> public bool Update(Model.answer_result model) { StringBuilder strSql = new StringBuilder(); strSql.Append(@"UPDATE ybd_answer_result SET group_id = @group_id ,exa_id = @exa_id ,exa_title = @exa_title ,user_id = @user_id ,avatar = @avatar ,nick_name = @nick_name ,use_min = @use_min ,use_sec = @use_sec ,truth_num = @truth_num ,count = @count ,truth_ratio = @truth_ratio ,score = @score ,status = @status ,add_time = @add_time WHERE id = @id"); SqlParameter[] parameters = { new SqlParameter("@id", SqlDbType.Int, 4) , new SqlParameter("@group_id", SqlDbType.Int, 4) , new SqlParameter("@exa_id", SqlDbType.Int, 4) , new SqlParameter("@exa_title", SqlDbType.NVarChar, 50) , new SqlParameter("@user_id", SqlDbType.Int, 4) , new SqlParameter("@avatar", SqlDbType.NVarChar, 50) , new SqlParameter("@nick_name", SqlDbType.NVarChar, 50) , new SqlParameter("@use_min", SqlDbType.Int, 4) , new SqlParameter("@use_sec", SqlDbType.Int, 4) , new SqlParameter("@truth_num", SqlDbType.Int, 4) , new SqlParameter("@count", SqlDbType.Int, 4) , new SqlParameter("@truth_ratio", SqlDbType.Decimal, 5) , new SqlParameter("@score", SqlDbType.Int, 4) , new SqlParameter("@status", SqlDbType.Int, 4) , new SqlParameter("@add_time", SqlDbType.DateTime, 8) }; parameters[0].Value = model.id; parameters[1].Value = model.group_id; parameters[2].Value = model.exa_id; parameters[3].Value = model.exa_title; parameters[4].Value = model.user_id; parameters[5].Value = model.avatar; parameters[6].Value = model.nick_name; parameters[7].Value = model.use_min; parameters[8].Value = model.use_sec; parameters[9].Value = model.truth_num; parameters[10].Value = model.count; parameters[11].Value = model.truth_ratio; parameters[12].Value = model.score; parameters[13].Value = model.status; parameters[14].Value = model.add_time; int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
/// <summary> /// 得到一个对象实体 /// </summary> public Model.answer_result DataRowToModel(DataRow row) { Model.answer_result model = new Model.answer_result(); if (row != null) { if (row["id"] != null) //&& row["id"].ToString() != "" { model.id = Convert.ToInt32(row["id"]); } if (row["group_id"] != null) //&& row["group_id"].ToString() != "" { model.group_id = Convert.ToInt32(row["group_id"]); } if (row["exa_id"] != null) //&& row["exa_id"].ToString() != "" { model.exa_id = Convert.ToInt32(row["exa_id"]); } if (row["exa_title"] != null) //&& row["exa_title"].ToString() != "" { model.exa_title = Convert.ToString(row["exa_title"]); } if (row["user_id"] != null) //&& row["user_id"].ToString() != "" { model.user_id = Convert.ToInt32(row["user_id"]); } if (row["avatar"] != null) //&& row["avatar"].ToString() != "" { model.avatar = Convert.ToString(row["avatar"]); } if (row["nick_name"] != null) //&& row["nick_name"].ToString() != "" { model.nick_name = Convert.ToString(row["nick_name"]); } if (row["use_min"] != null) //&& row["use_min"].ToString() != "" { model.use_min = Convert.ToInt32(row["use_min"]); } if (row["use_sec"] != null) //&& row["use_sec"].ToString() != "" { model.use_sec = Convert.ToInt32(row["use_sec"]); } if (row["truth_num"] != null) //&& row["truth_num"].ToString() != "" { model.truth_num = Convert.ToInt32(row["truth_num"]); } if (row["count"] != null) //&& row["count"].ToString() != "" { model.count = Convert.ToInt32(row["count"]); } if (row["truth_ratio"] != null) //&& row["truth_ratio"].ToString() != "" { model.truth_ratio = Convert.ToDecimal(row["truth_ratio"]); } if (row["score"] != null) //&& row["score"].ToString() != "" { model.score = Convert.ToInt32(row["score"]); } if (row["status"] != null) //&& row["status"].ToString() != "" { model.status = Convert.ToInt32(row["status"]); } if (row["add_time"] != null && row["add_time"].ToString() != "") { model.add_time = Convert.ToDateTime(row["add_time"]); } return(model); } else { return(null); } }
/// <summary> /// 更新一条数据 /// </summary> public bool Update(Model.answer_result model) { return(dal.Update(model)); }
/// <summary> /// 增加一条数据 /// </summary> public int Add(Model.answer_result model) { return(dal.Add(model)); }
//保存 protected void btnSubmit_Click(object sender, EventArgs e) { ChkAdminLevel("_ybd_answer_result", EnumCollection.ActionEnum.Add.ToString()); //检查权限 #region string strError = string.Empty; if (txtgroup_id.Text.Trim() == "" || txtgroup_id.Text.Trim().Length > 4) { strError += "分组ID为空或超出长度![br]"; } if (txtexa_id.Text.Trim() == "" || txtexa_id.Text.Trim().Length > 4) { strError += "试卷ID为空或超出长度![br]"; } if (txtexa_title.Text.Trim() == "" || txtexa_title.Text.Trim().Length > 50) { strError += "试卷标题为空或超出长度![br]"; } if (txtuser_id.Text.Trim() == "" || txtuser_id.Text.Trim().Length > 4) { strError += "答题者ID为空或超出长度![br]"; } if (txtavatar.Text.Trim() == "" || txtavatar.Text.Trim().Length > 50) { strError += "头像为空或超出长度![br]"; } if (txtnick_name.Text.Trim() == "" || txtnick_name.Text.Trim().Length > 50) { strError += "昵称为空或超出长度![br]"; } if (txtuse_min.Text.Trim() == "" || txtuse_min.Text.Trim().Length > 4) { strError += "用时-分钟为空或超出长度![br]"; } if (txtuse_sec.Text.Trim() == "" || txtuse_sec.Text.Trim().Length > 4) { strError += "用时-秒钟为空或超出长度![br]"; } if (txttruth_num.Text.Trim() == "" || txttruth_num.Text.Trim().Length > 4) { strError += "答对题数为空或超出长度![br]"; } if (txtcount.Text.Trim() == "" || txtcount.Text.Trim().Length > 4) { strError += "总题数为空或超出长度![br]"; } if (txttruth_ratio.Text.Trim() == "" || txttruth_ratio.Text.Trim().Length > 5) { strError += "正确率为空或超出长度![br]"; } if (txtscore.Text.Trim() == "" || txtscore.Text.Trim().Length > 4) { strError += "总分为空或超出长度![br]"; } if (txtstatus.Text.Trim() == "" || txtstatus.Text.Trim().Length > 4) { strError += "批改状态 1已批改 0未批改为空或超出长度![br]"; } if (txtadd_time.Text.Trim() == "" || txtadd_time.Text.Trim().Length > 8) { strError += "完成时间为空或超出长度![br]"; } if (strError != string.Empty) { JscriptMsg(strError, "", "Error"); return; } #endregion Model.answer_result model = new Model.answer_result(); BLL.answer_result bll = new BLL.answer_result(); model.group_id = Convert.ToInt32(txtgroup_id.Text); model.exa_id = Convert.ToInt32(txtexa_id.Text); model.exa_title = Convert.ToString(txtexa_title.Text); model.user_id = Convert.ToInt32(txtuser_id.Text); model.avatar = Convert.ToString(txtavatar.Text); model.nick_name = Convert.ToString(txtnick_name.Text); model.use_min = Convert.ToInt32(txtuse_min.Text); model.use_sec = Convert.ToInt32(txtuse_sec.Text); model.truth_num = Convert.ToInt32(txttruth_num.Text); model.count = Convert.ToInt32(txtcount.Text); model.truth_ratio = Convert.ToDecimal(txttruth_ratio.Text); model.score = Convert.ToInt32(txtscore.Text); model.status = Convert.ToInt32(txtstatus.Text); model.add_time = Convert.ToDateTime(txtadd_time.Text); int id = bll.Add(model); if (id > 0) { AddAdminLog(EnumCollection.ActionEnum.Add.ToString(), "添加答题结果信息,主键:" + id); //记录日志 JscriptMsg("添加答题结果信息成功!", "Manage.aspx", ""); } else { JscriptMsg("保存过程中发生错误!", ""); } }