public void Update(Model.CMS.StaticPage entity) { using (IDbConnection conn = SqlString.GetSQLiteConnection()) { conn.Execute("UPDATE cms_staticpage SET PageName=@PageName,PageParameter=@PageParameter,CreateTime=@CreateTime,LastTime=@LastTime,TempPageId =@TempPageId WHERE Page_Id =@Page_Id", entity); } }
public bool Insert(Model.CMS.StaticPage entity) { using (IDbConnection conn = SqlString.GetSQLiteConnection()) { int i = conn.Execute("INSERT INTO cms_staticpage(PageName,PageParameter,CreateTime,LastTime,TempPageId)" + "VALUES(@PageName,@PageParameter,@CreateTime,@LastTime,@TempPageId)", entity); if (i > 0) { return(true); } else { return(false); } } }