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