public bool Update(CsProducts model)
{
var strSql = new StringBuilder();
strSql.Append("UPDATE CrabShop.dbo.[CsProducts] SET ");
strSql.Append("ProductType = @ProductType,ProductName = @ProductName,ProductImage = @ProductImage,ProductWeight = @ProductWeight,ProductPrice = @ProductPrice,ProductState = @ProductState,OperationDate = @OperationDate,ProductStock = @ProductStock,ProductNumber = @ProductNumber");
strSql.Append(" WHERE ProductId = @ProductId");
return(DbClient.Excute(strSql.ToString(), model) > 0);
}
public int Add(CsProducts model)
{
var strSql = new StringBuilder();
strSql.Append("INSERT INTO CrabShop.dbo.[CsProducts] (");
strSql.Append("ProductType,ProductName,ProductImage,ProductWeight,ProductPrice,ProductState,OperationDate,ProductStock,ProductNumber");
strSql.Append(") VALUES (");
strSql.Append("@ProductType,@ProductName,@ProductImage,@ProductWeight,@ProductPrice,@ProductState,@OperationDate,@ProductStock,@ProductNumber);");
strSql.Append("SELECT @@IDENTITY");
return(DbClient.ExecuteScalar <int>(strSql.ToString(), model));
}
