Esempio n. 1
0
        private void searchCustomer(string q)
        {
            DataTable data = getService.searchDataWithFilter(app.objects["customers"], q, "CONVERT(VARCHAR(10), created_date, 111) BETWEEN  '" + range.from.Date.ToString("yyyy/MM/dd") + "' AND '" + range.to.Date.ToString("yyyy/MM/dd") + "'");

            if (data.Rows.Count > 0)
            {
                customerGridView.DataSource = data;
            }
        }
Esempio n. 2
0
        private void searchVouchers(string q)
        {
            DataTable data = getService.searchDataWithFilter(app.objects["vouchers"], q, "CONVERT(VARCHAR(10), transaction_date , 111) BETWEEN  '" + range.from.Date.ToString("yyyy/MM/dd") + "' AND '" + range.to.Date.ToString("yyyy/MM/dd") + "'");

            if (data.Rows.Count > 0)
            {
                vouchersGridView.DataSource = data;
            }
            else
            {
                vouchersGridView.DataSource = null;
            }
        }