public TestModle GetModleByID(string ID) { string strWhere = " ActivityID='" + ID + "'"; DataTable dt = GetList(strWhere); if (dt.Rows.Count == 0) { return(null); } TestModle modle = new TestModle(); modle.TestID = Int32.Parse(ID); if (dt.Rows[0][1] != null) { modle.TestCourse = dt.Rows[0][1].ToString(); } if (dt.Rows[0][3] != null) { modle.TestName = dt.Rows[0][3].ToString(); } if (dt.Rows[0][4] != null) { modle.TestClass = dt.Rows[0][4].ToString(); } if (dt.Rows[0][5] != null) { modle.Test = dt.Rows[0][5].ToString(); } return(modle); }
public int Edit(TestModle modle) { string sql = "update Paper set QID=@QID,Questionname=@Questionname,Qauthor=@Qauthor,Teacherclass=@Teacherclass,Test=@Test"; SqlParameter[] para = { new SqlParameter("@QID", modle.TestID), new SqlParameter("@Questionname", modle.TestCourse), new SqlParameter("@Qauthor", modle.TestName), new SqlParameter("@Teacherclass", modle.TestClass), new SqlParameter("@Test", modle.Test) }; return(DBHelperSQL.Execute(sql, para)); }
//添加试卷 public int Add(TestModle modle) { string sql = "insert into Paper(QID,Questionname,Qauthor,Teacherclass,Test)values(@QID,@Questionname,@Qauthor,@Teacherclass,@Test)"; SqlParameter[] para = { new SqlParameter("@QID", modle.TestID), new SqlParameter("@Questionname", modle.TestCourse), new SqlParameter("@Qauthor", modle.TestName), new SqlParameter("@Teacherclass", modle.TestClass), new SqlParameter("@Test", modle.Test) }; return(DBHelperSQL.Execute(sql, para)); }
protected void btnSelect_Click(object sender, EventArgs e) { TestModle modle = new TestModle(); modle.TestName = ddlTestName.SelectedValue; modle.TestCourse = ddlTestCourse.SelectedValue; modle.TestClass = ddlTestClass.SelectedValue; modle.Test = ddlTest.SelectedValue; if (testbll.Add(modle) > 0) { Response.Write("<script language='javascript'>alert('添加成功');</script>"); } else { Response.Write("<script language='javascript'>alert('添加成功');</script>"); } }
public int Edit(TestModle modle) { return(dal.Edit(modle)); }
public int Add(TestModle modle) { return(dal.Add(modle)); }