Exemple #1
0
        public IEnumerable<ImexCheckModel> GetAllIMEXByFilter(ImexCheckModel model, DateTime dateFrom, DateTime dateTo)
        {
            IEnumerable<ImexCheckModel> query = new List<ImexCheckModel>();

            query = this.GetAllIMEX();
            query = query.Where(p => p.InvoiceDate.Date >= dateFrom.Date.Date && p.InvoiceDate.Date <= dateTo.Date.Date);

            if (!string.IsNullOrEmpty(model.StoreInPlanNum)) { query = query.Where(p => p.StoreInPlanNum.Contains(model.StoreInPlanNum)); }
            if (!string.IsNullOrEmpty(model.InvoiceNum)) { query = query.Where(p => p.InvoiceNum.Contains(model.InvoiceNum)); }

            return query.ToList();
        }
        private void butSearch_Click(object sender, EventArgs e)
        {
            ImexCheckModel model = new ImexCheckModel();
            model.StoreInPlanNum = txtStoreInPlanNo.Text.Trim();
            model.InvoiceNum = txtInvoiceNo.Text.Trim();

            var result = _repo.GetAllIMEXByFilter(model, dtpInvoiceDateFrom.Value, dtpInvoiceDateTo.Value);
            SetDetail(result);
        }