private void frmPurchaseNew_Load(object sender, EventArgs e)
        {
            //loading ComboBox
            DAL.Ledger   ld = new DAL.Ledger();
            DAL.Employee em = new DAL.Employee();
            DAL.Product  p  = new DAL.Product();
            DAL.Purchase pr = new DAL.Purchase();

            cmbLedger.DataSource    = ld.select().Tables[0];
            cmbLedger.DisplayMember = "name";
            cmbLedger.ValueMember   = "id";
            cmbLedger.SelectedValue = -1;

            cmbEmployee.DataSource    = em.select().Tables[0];
            cmbEmployee.DisplayMember = "name";
            cmbEmployee.ValueMember   = "id";
            cmbEmployee.SelectedValue = -1;

            //product
            colProduct.DataSource    = p.select().Tables[0];
            colProduct.DisplayMember = "name";
            colProduct.ValueMember   = "id";

            this.MaximumSize = this.Size;
            this.MinimumSize = this.Size;
        }
예제 #2
0
        private void btnSearch_Click(object sender, EventArgs e)
        {
            DAL.Ledger ld = new DAL.Ledger();
            ld.Search  = txtSearch.Text;
            ld.Contact = Convert.ToString(txtContact.Text);
            ld.Email   = Convert.ToString(txtEmail.Text);

            //dateSearch
            ld.isDateSearch = ucDateSearch1.isEnabled;
            ld.DateFrom     = ucDateSearch1.DateFrom;
            ld.DateTo       = ucDateSearch1.DateTo;

            dgvLedger.DataSource = ld.select().Tables[0];
        }