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