protected void Page_Load(object sender, EventArgs e) { if (!this.IsPostBack) { string strSql = "select courseName=CourseMainType+'_'+Title,idx from v_CourseMain order by CourseMainType,SortNo"; DataSet ds = SqlHelper.ExecuteDataset(CommandType.Text, strSql); this.ddlCourse.DataSource = ds.Tables[0]; this.ddlCourse.DataTextField = "courseName"; this.ddlCourse.DataValueField = "idx"; this.ddlCourse.DataBind(); if (!string.IsNullOrEmpty(Request["Idx"])) { DBEntity.Tab_CourseMain_TestQuestion ent = new DBEntity.Tab_CourseMain_TestQuestion(); ent = ent.Get(Request["Idx"]); this.QuestionText.Text = ent.QuestionText; this.Aquestion.Text = ent.Aquestion; this.Bquestion.Text = ent.Bquestion; this.Cquestion.Text = ent.Cquestion; this.Dquestion.Text = ent.Dquestion; this.Answer.Text = ent.Answer; for (int i = 0; i < ddlCourse.Items.Count; i++) { if (ddlCourse.Items[i].Value == ent.CourseMainIdx_Fx.ToString()) { ddlCourse.Items[i].Selected = true; } } } } }
private static Tab_CourseMain_TestQuestion ToModel(DataRow row) { Tab_CourseMain_TestQuestion model = new Tab_CourseMain_TestQuestion(); model.Idx = row.IsNull("Idx")?null:(System.Int32?)row["Idx"]; model.CourseMainIdx_Fx = row.IsNull("CourseMainIdx_Fx")?null:(System.Int32?)row["CourseMainIdx_Fx"]; model.QuestionText = row.IsNull("QuestionText")?null:(System.String)row["QuestionText"]; model.Aquestion = row.IsNull("Aquestion")?null:(System.String)row["Aquestion"]; model.Bquestion = row.IsNull("Bquestion")?null:(System.String)row["Bquestion"]; model.Cquestion = row.IsNull("Cquestion")?null:(System.String)row["Cquestion"]; model.Dquestion = row.IsNull("Dquestion")?null:(System.String)row["Dquestion"]; model.Answer = row.IsNull("Answer")?null:(System.String)row["Answer"]; model.CreatedDate = row.IsNull("CreatedDate")?null:(System.DateTime?)row["CreatedDate"]; return(model); }
public int AddNew(Tab_CourseMain_TestQuestion model) { string sql = "insert into Tab_CourseMain_TestQuestion(CourseMainIdx_Fx,QuestionText,Aquestion,Bquestion,Cquestion,Dquestion,Answer,CreatedDate) values(@CourseMainIdx_Fx,@QuestionText,@Aquestion,@Bquestion,@Cquestion,@Dquestion,@Answer,@CreatedDate); select @@identity ;"; int Idx = Convert.ToInt32(SqlHelper.ExecuteScalar(CommandType.Text, sql , new SqlParameter("@CourseMainIdx_Fx", model.CourseMainIdx_Fx) , new SqlParameter("@QuestionText", model.QuestionText) , new SqlParameter("@Aquestion", model.Aquestion) , new SqlParameter("@Bquestion", model.Bquestion) , new SqlParameter("@Cquestion", model.Cquestion) , new SqlParameter("@Dquestion", model.Dquestion) , new SqlParameter("@Answer", model.Answer) , new SqlParameter("@CreatedDate", model.CreatedDate) )); return(Idx); }
public bool Update(Tab_CourseMain_TestQuestion model) { string sql = "update Tab_CourseMain_TestQuestion set CourseMainIdx_Fx=@CourseMainIdx_Fx,QuestionText=@QuestionText,Aquestion=@Aquestion,Bquestion=@Bquestion,Cquestion=@Cquestion,Dquestion=@Dquestion,Answer=@Answer,CreatedDate=@CreatedDate where Idx=@Idx"; int rows = SqlHelper.ExecuteNonQuery(CommandType.Text, sql , new SqlParameter("@CourseMainIdx_Fx", model.CourseMainIdx_Fx) , new SqlParameter("@QuestionText", model.QuestionText) , new SqlParameter("@Aquestion", model.Aquestion) , new SqlParameter("@Bquestion", model.Bquestion) , new SqlParameter("@Cquestion", model.Cquestion) , new SqlParameter("@Dquestion", model.Dquestion) , new SqlParameter("@Answer", model.Answer) , new SqlParameter("@CreatedDate", model.CreatedDate) , new SqlParameter("Idx", model.Idx) ); return(rows > 0); }
public Tab_CourseMain_TestQuestion Get(string Idx) { DataTable dt = SqlHelper.ExecuteDataset(CommandType.Text, "select * from Tab_CourseMain_TestQuestion where Idx=@Idx", new SqlParameter("Idx", Idx)).Tables[0]; if (dt.Rows.Count > 1) { throw new Exception("more than 1 row was found"); } if (dt.Rows.Count <= 0) { return(null); } DataRow row = dt.Rows[0]; Tab_CourseMain_TestQuestion model = ToModel(row); return(model); }