/// <summary>
/// 依條件篩選商品資料
/// </summary>
/// <param name="condition"></param>
/// <returns></returns>
public List <eSaleModel.Product> GetProductByCondition(eSaleModel.Product condition)
{
List <eSaleModel.Product> result = new List <eSaleModel.Product>();
eSaleDao.ProductDao productDao = new eSaleDao.ProductDao(this.DbConn);
var datalist = productDao.GetProductByCondition(condition);
return(this.MapProductStore(datalist));
}
public JsonResult GetProductList()
{
var result = new eSaleModel.Product();
var productService = new eSalesService.ProductService(this.GetDBConnectionString());
var store = new eSaleModel.Store();
result.ProductId = 0;
result.ProductName = "%" + null + "%";
result.SupplierId = 0;
result.CategoryId = 0;
return(this.Json(productService.GetProductByCondition(result), JsonRequestBehavior.AllowGet));
}
/// <summary>
/// 依條件篩選商品資料
/// </summary>
/// <param name="condition"></param>
/// <returns></returns>
public DataTable GetProductByCondition(eSaleModel.Product condition)
{
DataTable dt = new DataTable();
string sql = @"SELECT * FROM Production.Products WHERE (ProductId=@ProductId OR @ProductId = 0 ) AND
(ProductName LIKE @ProductName OR @ProductName IS NULL ) AND
(SupplierId=@SupplierId OR @SupplierId = 0 ) AND
(CategoryId=@CategoryId OR @CategoryId = 0 ) ";
using (SqlConnection conn = new SqlConnection(this.DbConn))
{
conn.Open();
SqlCommand cmd = new SqlCommand(sql, conn);
cmd.Parameters.Add(new SqlParameter("@ProductId", condition.ProductId == null ? 0 : condition.ProductId));
cmd.Parameters.Add(new SqlParameter("@ProductName", condition.ProductName == null ? string.Empty : condition.ProductName));
cmd.Parameters.Add(new SqlParameter("@SupplierId", condition.SupplierId == null ? 0 : condition.SupplierId));
cmd.Parameters.Add(new SqlParameter("@CategoryId", condition.CategoryId == null ? 0 : condition.CategoryId));
SqlDataAdapter sqlAdapter = new SqlDataAdapter(cmd);
sqlAdapter.Fill(dt);
conn.Close();
}
return(dt);
}
