public ClassAModel ToModel(SQLiteDataReader reader) { ClassAModel classAModel = new ClassAModel(); classAModel.ClassName = (string)ToModelValue(reader, "className"); classAModel.ClassNote = (string)ToModelValue(reader, "classNote"); classAModel.CreateTime = Convert.ToDateTime(ToModelValue(reader, "createTime")); return(classAModel); }
public int Add(ClassAModel classAModel) { string sql = "INSERT INTO classA (className, classNote, createTime) VALUES (@className, @classNote, @createTime)"; SQLiteParameter[] para = new SQLiteParameter[] { new SQLiteParameter("@className", ToDBValue(classAModel.ClassName)), new SQLiteParameter("@classNote", ToDBValue(classAModel.ClassNote)), new SQLiteParameter("@createTime", ToDBValue(classAModel.CreateTime)), }; return(SqlHelper.ExecuteNonQuery(sql, para)); }
public int Update(ClassAModel classAModel) { string sql = "UPDATE classA " + "SET " + " classNote = @classNote" + ", createTime = @createTime" + " WHERE className = @className"; SQLiteParameter[] para = new SQLiteParameter[] { new SQLiteParameter("@className", classAModel.ClassName) , new SQLiteParameter("@classNote", ToDBValue(classAModel.ClassNote)) , new SQLiteParameter("@createTime", ToDBValue(classAModel.CreateTime)) }; return(SqlHelper.ExecuteNonQuery(sql, para)); }
public int Update(ClassAModel classAModel) { return(new ClassAModelDAL().Update(classAModel)); }
public int Add(ClassAModel classAModel) { return(new ClassAModelDAL().Add(classAModel)); }