/// <summary> /// 更新一条数据 /// </summary> public bool Update(Eastcom.Model.考试题库 model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update 考试题库 set "); strSql.Append("题目内容=@题目内容,"); strSql.Append("A选项=@A选项,"); strSql.Append("B选项=@B选项,"); strSql.Append("C选项=@C选项,"); strSql.Append("D选项=@D选项,"); strSql.Append("其他选项=@其他选项,"); strSql.Append("标准答案=@标准答案,"); strSql.Append("标准答案2=@标准答案2"); strSql.Append(" where id=@id"); SqlParameter[] parameters = { new SqlParameter("@题目内容", SqlDbType.NText), new SqlParameter("@A选项", SqlDbType.VarChar, 5000), new SqlParameter("@B选项", SqlDbType.VarChar, 5000), new SqlParameter("@C选项", SqlDbType.VarChar, 5000), new SqlParameter("@D选项", SqlDbType.VarChar, 5000), new SqlParameter("@其他选项", SqlDbType.NText), new SqlParameter("@标准答案", SqlDbType.VarChar, 50), new SqlParameter("@标准答案2", SqlDbType.VarChar, 50), new SqlParameter("@id", SqlDbType.Int, 4) }; parameters[0].Value = model.题目内容; parameters[1].Value = model.A选项; parameters[2].Value = model.B选项; parameters[3].Value = model.C选项; parameters[4].Value = model.D选项; parameters[5].Value = model.其他选项; parameters[6].Value = model.标准答案; parameters[7].Value = model.标准答案2; parameters[8].Value = model.id; int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
/// <summary> /// 得到一个对象实体 /// </summary> public Eastcom.Model.考试题库 DataRowToModel(DataRow row) { Eastcom.Model.考试题库 model = new Eastcom.Model.考试题库(); if (row != null) { if (row["id"] != null && row["id"].ToString() != "") { model.id = int.Parse(row["id"].ToString()); } if (row["题目内容"] != null) { model.题目内容 = row["题目内容"].ToString(); } if (row["A选项"] != null) { model.A选项 = row["A选项"].ToString(); } if (row["B选项"] != null) { model.B选项 = row["B选项"].ToString(); } if (row["C选项"] != null) { model.C选项 = row["C选项"].ToString(); } if (row["D选项"] != null) { model.D选项 = row["D选项"].ToString(); } if (row["其他选项"] != null) { model.其他选项 = row["其他选项"].ToString(); } if (row["标准答案"] != null) { model.标准答案 = row["标准答案"].ToString(); } if (row["标准答案2"] != null) { model.标准答案2 = row["标准答案2"].ToString(); } } return(model); }
/// <summary> /// /// </summary> /// <param name="model"></param> /// <returns></returns> private string CommonModel(Eastcom.Model.错题提交信息 model) { StringBuilder str = new StringBuilder(); model.FK_考试题库 = FK_ID; model.错误提交信息 = Request.Params["area_Err"].Trim(); model.提交人 = Submiter; model.提交时间 = CommonClass.StringHander.Common.GetDateTime(SubmitTime); Eastcom.Model.考试题库 考题 = new Eastcom.Model.考试题库(); 考题 = new Eastcom.BLL.考试题库().GetModel(CommonClass.StringHander.Common.GetInt(FK_ID)); if (考题 != null) { model.题目信息 = 考题.题目内容; model.答案信息 = 考题.标准答案; } return(str.ToString()); }
/// <summary> /// 增加一条数据 /// </summary> public int Add(Eastcom.Model.考试题库 model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into 考试题库("); strSql.Append("题目内容,A选项,B选项,C选项,D选项,其他选项,标准答案,标准答案2)"); strSql.Append(" values ("); strSql.Append("@题目内容,@A选项,@B选项,@C选项,@D选项,@其他选项,@标准答案,@标准答案2)"); strSql.Append(";select @@IDENTITY"); SqlParameter[] parameters = { new SqlParameter("@题目内容", SqlDbType.NText), new SqlParameter("@A选项", SqlDbType.VarChar, 5000), new SqlParameter("@B选项", SqlDbType.VarChar, 5000), new SqlParameter("@C选项", SqlDbType.VarChar, 5000), new SqlParameter("@D选项", SqlDbType.VarChar, 5000), new SqlParameter("@其他选项", SqlDbType.NText), new SqlParameter("@标准答案", SqlDbType.VarChar, 50), new SqlParameter("@标准答案2", SqlDbType.VarChar, 50) }; parameters[0].Value = model.题目内容; parameters[1].Value = model.A选项; parameters[2].Value = model.B选项; parameters[3].Value = model.C选项; parameters[4].Value = model.D选项; parameters[5].Value = model.其他选项; parameters[6].Value = model.标准答案; parameters[7].Value = model.标准答案2; object obj = DbHelperSQL.GetSingle(strSql.ToString(), parameters); if (obj == null) { return(0); } else { return(Convert.ToInt32(obj)); } }
/// <summary> /// 得到一个对象实体 /// </summary> public Eastcom.Model.考试题库 GetModel(int id) { StringBuilder strSql = new StringBuilder(); strSql.Append("select top 1 id,题目内容,A选项,B选项,C选项,D选项,其他选项,标准答案,标准答案2 from 考试题库 "); strSql.Append(" where id=@id"); SqlParameter[] parameters = { new SqlParameter("@id", SqlDbType.Int, 4) }; parameters[0].Value = id; Eastcom.Model.考试题库 model = new Eastcom.Model.考试题库(); DataSet ds = DbHelperSQL.Query(strSql.ToString(), parameters); if (ds.Tables[0].Rows.Count > 0) { return(DataRowToModel(ds.Tables[0].Rows[0])); } else { return(null); } }
/// <summary> /// /// </summary> public void AjaxMethod() { Eastcom.BLL.月度考核内容_详细 BLL_model_详细 = new Eastcom.BLL.月度考核内容_详细(); Eastcom.BLL.月度考核内容 BLL_model_列表 = new Eastcom.BLL.月度考核内容(); Eastcom.Model.月度考核内容_详细 model_详细 = null; Eastcom.Model.月度考核内容 model_列表 = null; StringBuilder strMsg = new StringBuilder(); int isReload = 0;//0:不刷新父页面 1:刷新父页面 bool IsError = false; switch (handleType) //this.PageType { case "Save": #region 保存 model_详细 = BLL_model_详细.GetModelByBH_YD(CommonClass.StringHander.Common.GetInt(FK_YDKHNR), CommonClass.StringHander.Common.GetInt(id)); strMsg.Append(this.CommonModel(model_详细)); if (strMsg.Length == 0) { if (BLL_model_详细.Update(model_详细)) { IsError = false; strMsg.Append(""); Get考核月份(); } else { IsError = true; strMsg.Append("更新失败"); } } else { IsError = false; } #endregion break; case "Submit": #region 提交 List <Eastcom.Model.月度考核内容_详细> ModelList = new List <Eastcom.Model.月度考核内容_详细>(); ModelList = BLL_model_详细.GetModelList("FK_月度考核内容='" + FK_YDKHNR + "'"); model_列表 = BLL_model_列表.GetModel(Common.GetInt(FK_YDKHNR)); decimal 总得分 = 0; if (undoneid != 0) { IsError = true; strMsg.Append("你还有未完成的题!"); } else { foreach (Eastcom.Model.月度考核内容_详细 m in ModelList) { string 用户答案 = m.用户答案 == "" ? ",,," : m.用户答案; Eastcom.Model.考试题库 model_题库 = new Eastcom.Model.考试题库(); model_题库 = new Eastcom.BLL.考试题库().GetModel(Common.GetInt(m.题目编号)); if (model_题库 != null) { UserPoint c = new UserPoint(); c = c.Get用户得分情况(用户答案, model_题库.标准答案.Trim()); m.得分 = c.用户得分; m.回答情况 = c.得分情况; BLL_model_详细.Update(m); 总得分 += Common.GetDecimal(m.得分); } } } model_列表.得分 = 总得分; model_列表.提交时间 = DateTime.Now; model_列表.提交情况 = Eastcom.ConfigUntility.ConfigArgs.提交情况.已提交.ToString(); //strMsg.Append(this.CommonModel(model_详细)); if (strMsg.Length == 0) { if (BLL_model_列表.Update(model_列表)) { IsError = false; strMsg.Append("提交成功"); } else { IsError = true; strMsg.Append("更新失败"); } } else { IsError = true; } #endregion break; default: strMsg.Append("页面操作类型不明确,操作失败!"); break; } CommonClass.Message.Log.WriteMessage(new CommonClass.Message.GoAjaxPara() { msg = strMsg.ToString(), isReload = isReload, isError = IsError, msnLog = "", Data = new ExamId() { nextid = nextid.ToString(), preid = preid.ToString(), Undoneid = undoneid.ToString() } }); }
protected void Upload1_Click(object sender, EventArgs e) { if (FileUpload1.HasFile) { Lbl_Messaage.Text = ""; Label_1.Text = ""; #region string fileExt = System.IO.Path.GetExtension(FileUpload1.FileName); if (fileExt == ".xls" || fileExt == ".xlsx") { #region try { string newname = System.DateTime.Now.ToString("yyyyMMddHHmmssffff");//重命名 newname += ".xls"; FileUpload1.SaveAs(Server.MapPath("excel") + "\\" + newname); string filename = (Server.MapPath("excel") + "\\" + newname).ToString(); if (filename != "") { try { DataTable dt = CommonClass.DataHandler.ExcelToData.ReadExcelToTable(filename, 0); #region 插入 Eastcom.BLL.考试题库 bll = new Eastcom.BLL.考试题库(); int success = 0, error = 0; string ErrorMsg = ""; DateTime now = DateTime.Now; /*添加备份*/ string RealName = ""; if (CurrentUserModel != null) { RealName = CurrentUserModel.RealName; } bll.AddHisBak(now, RealName.ToString()); bll.ExecuteTrunCate(); for (int i = 0; i < dt.Rows.Count; i++) { try { string 题目内容 = dt.Rows[i]["题目内容"].ToString().Trim(); string 项A = dt.Rows[i]["选项A"].ToString().Trim(); string 项B = dt.Rows[i]["选项B"].ToString().Trim(); string 项C = dt.Rows[i]["选项C"].ToString().Trim(); string 项D = dt.Rows[i]["选项D"].ToString().Trim(); string 项E = dt.Rows[i]["选项E"].ToString().Trim(); string 标准答案 = dt.Rows[i]["答案"].ToString().Trim(); //string 标准答案2 = dt.Rows[i]["标准答案2"].ToString().Trim(); Eastcom.Model.考试题库 model = new Eastcom.Model.考试题库(); model.题目内容 = 题目内容; model.A选项 = 项A; model.B选项 = 项B; model.C选项 = 项C; model.D选项 = 项D; model.其他选项 = 项E; //model.标准答案 = 标准答案; model.标准答案2 = 标准答案; bll.Add(model); success++; } catch { ErrorMsg += "第" + (i + 1) + "行数据录入出错<br>"; error++; } } bll.Update标准答案(); if (error == 0) { Lbl_Messaage.Text = success.ToString() + "条导入成功"; Lbl_Messaage.ForeColor = System.Drawing.Color.Green; } else { Lbl_Messaage.Text = success.ToString() + "条导入成功," + error.ToString() + "条导入失败.失败数据请修改后重新导入!<BR>" + ErrorMsg; Lbl_Messaage.ForeColor = System.Drawing.Color.Red; } #endregion } catch (Exception ex) { Eastcom.Common.MessageBox.Show(this, "导入失败"); } } } catch (Exception ex) { Label_1.Text = "ERROR: " + ex.Message.ToString(); Label_1.ForeColor = System.Drawing.Color.Red; } #endregion } else { Label_1.Text = "只能上传Excel文件!"; Label_1.ForeColor = System.Drawing.Color.Red; } #endregion } else { Label_1.Text = "请选择一个Excel文件。"; Label_1.ForeColor = System.Drawing.Color.Red; //字体为 红色 System.Drawing.Color.Red } }