public bool Update(ProductInfo product)
{
using (DataCommand cmd = DataCommandManager.GetDataCommand("UpdateProduct"))
{
cmd.SetParameterValue("@ProductId", product.ProductId);
cmd.SetParameterValue("@Name", product.Name);
//cmd.SetParameterValue("@Price", price);
//cmd.SetParameterValue("@IsProcess", isProcess);
//cmd.SetParameterValue("@Elapse", );
cmd.SetParameterValue("@EditDate", DateTime.Now);
cmd.SetParameterValue("@Source", product.Source);
return cmd.ExecuteNonQuery()>0;
}
}
public bool Insert(ProductInfo product)
{
using (DataCommand cmd = DataCommandManager.GetDataCommand("InsertProduct"))
{
cmd.SetParameterValue("@ProductId", PrimaryKeyGenerator.NewComb().ToString().Replace("-", ""));
cmd.SetParameterValue("@Name", product.Name);
cmd.SetParameterValue("@Url", product.Url);
cmd.SetParameterValue("@ListImage", 0);
cmd.SetParameterValue("@CategoryId", 0);
cmd.SetParameterValue("@Supplier", 1);
//cmd.SetParameterValue("@Inventory", );
cmd.SetParameterValue("@CommentNumber", 0);
cmd.SetParameterValue("@InDate", DateTime.Now);
cmd.SetParameterValue("@EditDate", DateTime.Now);
return cmd.ExecuteNonQuery()>0;
}
}
public List<ProductInfo> GetProducts(string sqlWhere)
{
var data = new List<ProductInfo>();
using (DataCommand cmd = DataCommandManager.GetDataCommand("GetProducts"))
{
if (!string.IsNullOrEmpty(sqlWhere))
{
cmd.CommandText += sqlWhere;
}
using (var dataReader = cmd.ExecuteDataReader())
{
while (dataReader.Read())
{
var product = new ProductInfo();
if (!Convert.IsDBNull(dataReader["ProductId"]))
{
product.ProductId = dataReader["ProductId"].ToString();
}
if (!Convert.IsDBNull(dataReader["Name"]))
{
product.Name = dataReader["Name"].ToString();
}
if (!Convert.IsDBNull(dataReader["Url"]))
{
product.Url = dataReader["Url"].ToString();
}
if (!Convert.IsDBNull(dataReader["Supplier"]))
{
product.ECPlatformId = Convert.ToInt32(dataReader["Supplier"]);
}
data.Add(product);
}
}
}
return data;
}
public bool Update(ProductInfo product)
{
return productDataAccess.Update(product);
}
public bool Insert(ProductInfo model)
{
return productDataAccess.Insert(model);
}