private void searchProduct(string q)
{
DataTable data = getService.searchProductWithFilter(q, "#available", "CONVERT(VARCHAR(10), s.created_date, 111) BETWEEN '" + range.from.Date.ToString("yyyy/MM/dd") + "' AND '" + range.to.Date.ToString("yyyy/MM/dd") + "'");
if (data.Rows.Count > 0)
{
productGridView.DataSource = data;
}
else
{
productGridView.DataSource = null;
}
}
private void searchSold(string q)
{
DataTable data = getService.searchProductWithFilter(q, "#sold", "CONVERT(VARCHAR(10), s.created_date, 111) BETWEEN '" + range.from.Date.ToString("yyyy/MM/dd") + "' AND '" + range.to.Date.ToString("yyyy/MM/dd") + "'");
app.showSuccess(data.Rows.Count.ToString());
if (data.Rows.Count > 0)
{
soldGridView.DataSource = data;
}
else
{
soldGridView.DataSource = null;
}
}
