private static Tab_CourseTest_Question ToModel(DataRow row) { Tab_CourseTest_Question model = new Tab_CourseTest_Question(); 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"]; return(model); }
public int AddNew(Tab_CourseTest_Question model) { string sql = "insert into Tab_CourseTest_Question(CourseMainIdx_Fx,QuestionText,Aquestion,Bquestion,Cquestion,Dquestion,Answer) values(@CourseMainIdx_Fx,@QuestionText,@Aquestion,@Bquestion,@Cquestion,@Dquestion,@Answer); 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) )); return(Idx); }
public bool Update(Tab_CourseTest_Question model) { string sql = "update Tab_CourseTest_Question set CourseMainIdx_Fx=@CourseMainIdx_Fx,QuestionText=@QuestionText,Aquestion=@Aquestion,Bquestion=@Bquestion,Cquestion=@Cquestion,Dquestion=@Dquestion,Answer=@Answer 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("Idx", model.Idx) ); return(rows > 0); }
public Tab_CourseTest_Question Get(string Idx) { DataTable dt = SqlHelper.ExecuteDataset(CommandType.Text, "select * from Tab_CourseTest_Question 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_CourseTest_Question model = ToModel(row); return(model); }