/// <summary> /// 增加一条数据 /// </summary> public int Add(Model.examination_question model) { StringBuilder strSql = new StringBuilder(); strSql.Append(@"Insert Into ybd_examination_question( exa_id ,q_id ) Values ( @exa_id ,@q_id ); SELECT @@IDENTITY;"); SqlParameter[] parameters = { new SqlParameter("@exa_id", SqlDbType.Int, 4) , new SqlParameter("@q_id", SqlDbType.Int, 4) }; parameters[0].Value = model.exa_id; parameters[1].Value = model.q_id; object obj = DbHelperSQL.GetSingle(strSql.ToString(), parameters); if (obj == null) { return(0); } else { return(Convert.ToInt32(obj)); } }
/// <summary> /// 获得Model /// </summary> /// <param name="Top">大于0取前几行数据,否则取全部</param> /// <param name="whereStr">where条件</param> /// <param name="filedOrder">排序字段Order By + filedOrder (不可为空)</param> /// <returns></returns> public Model.examination_question GetModel(int Top, string whereStr, string filedOrder) { DataTable dt = dal.GetList(Top, whereStr, filedOrder).Tables[0]; Model.examination_question model = dt.Rows.Count > 0 ? DataRowToModel(dt.Rows[0]) : null; return(model); }
/// <summary> /// 更新一条数据 /// </summary> public bool Update(Model.examination_question model) { StringBuilder strSql = new StringBuilder(); strSql.Append(@"UPDATE ybd_examination_question SET exa_id = @exa_id ,q_id = @q_id WHERE id = @id"); SqlParameter[] parameters = { new SqlParameter("@id", SqlDbType.BigInt, 8) , new SqlParameter("@exa_id", SqlDbType.Int, 4) , new SqlParameter("@q_id", SqlDbType.Int, 4) }; parameters[0].Value = model.id; parameters[1].Value = model.exa_id; parameters[2].Value = model.q_id; int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
private void BindInfo() { BLL.examination_question bll = new BLL.examination_question(); Model.examination_question model = bll.GetModel(this.id); if (model == null) { JscriptMsg("信息不存在或已被删除!", "back"); return; } txtexa_id.Text = model.exa_id + ""; txtq_id.Text = model.q_id + ""; }
//保存 protected void btnSubmit_Click(object sender, EventArgs e) { ChkAdminLevel("_ybd_examination_question", EnumCollection.ActionEnum.Modify.ToString()); //检查权限 BLL.examination_question bll = new BLL.examination_question(); Model.examination_question model = bll.GetModel(this.id); model.exa_id = Convert.ToInt32(txtexa_id.Text); model.q_id = Convert.ToInt32(txtq_id.Text); if (bll.Update(model)) { AddAdminLog(EnumCollection.ActionEnum.Modify.ToString(), "修改试卷题目关联信息,主键:" + id); //记录日志 JscriptMsg("修改试卷题目关联信息成功!", "Manage.aspx"); } else { JscriptMsg("保存过程中发生错误!", ""); } }
//保存 protected void btnSubmit_Click(object sender, EventArgs e) { ChkAdminLevel("_ybd_examination_question", EnumCollection.ActionEnum.Add.ToString()); //检查权限 #region string strError = string.Empty; if (txtexa_id.Text.Trim() == "" || txtexa_id.Text.Trim().Length > 4) { strError += "试卷ID为空或超出长度![br]"; } if (txtq_id.Text.Trim() == "" || txtq_id.Text.Trim().Length > 4) { strError += "题目ID为空或超出长度![br]"; } if (strError != string.Empty) { JscriptMsg(strError, "", "Error"); return; } #endregion Model.examination_question model = new Model.examination_question(); BLL.examination_question bll = new BLL.examination_question(); model.exa_id = Convert.ToInt32(txtexa_id.Text); model.q_id = Convert.ToInt32(txtq_id.Text); int id = bll.Add(model); if (id > 0) { AddAdminLog(EnumCollection.ActionEnum.Add.ToString(), "添加试卷题目关联信息,主键:" + id); //记录日志 JscriptMsg("添加试卷题目关联信息成功!", "Manage.aspx", ""); } else { JscriptMsg("保存过程中发生错误!", ""); } }
/// <summary> /// 得到一个对象实体 /// </summary> public Model.examination_question DataRowToModel(DataRow row) { Model.examination_question model = new Model.examination_question(); if (row != null) { if (row["id"] != null) //&& row["id"].ToString() != "" { model.id = Convert.ToInt32(row["id"]); } if (row["exa_id"] != null) //&& row["exa_id"].ToString() != "" { model.exa_id = Convert.ToInt32(row["exa_id"]); } if (row["q_id"] != null) //&& row["q_id"].ToString() != "" { model.q_id = Convert.ToInt32(row["q_id"]); } return(model); } else { return(null); } }
/// <summary> /// 更新一条数据 /// </summary> public bool Update(Model.examination_question model) { return(dal.Update(model)); }
/// <summary> /// 增加一条数据 /// </summary> public int Add(Model.examination_question model) { return(dal.Add(model)); }
protected void btnAdd_Click(object sender, EventArgs e) { ChkAdminLevel("_common_questions", EnumCollection.ActionEnum.Add.ToString()); //检查权限 int sucCount = 0; int errorCount = 0; string allid = hdfAllID.Value; string[] ids = allid.Split(new char[] { ',' }, StringSplitOptions.RemoveEmptyEntries); BLL.examination_question bll = new BLL.examination_question(); int id = 0; for (int i = 0; i < ids.Length; i++) { id = Convert.ToInt32(ids[i]); Model.examination_question model = bll.GetModel(" exa_id = " + this.exaid + " and q_id = " + id); if (model == null) { //添加 model = new Model.examination_question(); model.exa_id = this.exaid; model.q_id = id; if (bll.Add(model) > 0) { sucCount += 1; } else { errorCount += 1; } } else { errorCount += 1; } } hdfAllID.Value = ""; //for (int i = 0; i < rptList.Items.Count; i++) //{ // int id = Convert.ToInt32(((HiddenField)rptList.Items[i].FindControl("hidId")).Value); // CheckBox cb = (CheckBox)rptList.Items[i].FindControl("chkId"); // if (cb.Checked) // { // Model.examination_question model = bll.GetModel(" group_id = " + this.group + " and exa_id = " + this.exaid + " and q_id = " + id); // if (model == null) // { // //添加 // model = new Model.examination_question(); // model.exa_id = this.exaid; // model.q_id = id; // if (bll.Add(model) > 0) // { // sucCount += 1; // } // else // { // errorCount += 1; // } // } // else // { // errorCount += 1; // } // } //} AddAdminLog(EnumCollection.ActionEnum.Add.ToString(), "添加未选题目信息" + sucCount + "条,失败" + errorCount + "条"); //记录日志 JscriptMsg("添加成功" + sucCount + "条,失败" + errorCount + "条!", ""); BindData(); }