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));
}