public int Insert(CompanyModel.Material model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into material(");
strSql.Append("title,contents,type,topimg,author,url,summary,annex,createtime,list,filename)");
strSql.Append(" values (");
strSql.Append("@title,@contents,@type,@topimg,@author,@url,@summary,@annex,@createtime,@list,@filename)");
strSql.Append(";select @@IDENTITY");
return(DBHelper.ExecuteSql(strSql.ToString(), model));
}
public int Update(CompanyModel.Material model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update material set ");
strSql.Append("title=@title,");
strSql.Append("contents=@contents,");
strSql.Append("type=@type,");
strSql.Append("topimg=@topimg,");
strSql.Append("author=@author,");
strSql.Append("url=@url,");
strSql.Append("summary=@summary,");
strSql.Append("annex=@annex,");
strSql.Append("createtime=@createtime,");
strSql.Append("list=@list,");
strSql.Append("filename=@filename");
strSql.Append(" where id=@id");
return(DBHelper.ExecuteSql(strSql.ToString(), model));
}
