public bool Update(CsCart model) { var strSql = new StringBuilder(); strSql.Append("UPDATE CrabShop.dbo.[CsCart] SET "); strSql.Append("OpenId = @OpenId,ProductId = @ProductId,ProductNumber = @ProductNumber,ChoseType = @ChoseType"); strSql.Append(" WHERE CartId = @CartId"); return(DbClient.Excute(strSql.ToString(), model) > 0); }
public int Add(CsCart model) { var strSql = new StringBuilder(); strSql.Append("INSERT INTO CrabShop.dbo.[CsCart] ("); strSql.Append("OpenId,ProductId,ProductNumber,ChoseType"); strSql.Append(") VALUES ("); strSql.Append("@OpenId,@ProductId,@ProductNumber,@ChoseType);"); strSql.Append("SELECT @@IDENTITY"); return(DbClient.ExecuteScalar <int>(strSql.ToString(), model)); }