예제 #1
0
        private void btnSearch_Click(object sender, EventArgs e)
        {
            frmFindImport frm = new frmFindImport();

            frm.strWhere = " and stat='فعال'";
            frm.ShowDialog();

            if (frm.strImportID != "")
            {
                txtImportId.Text  = (frm.strImportID);
                txtImport_no.Text = frm.strImportNo;

                lstImpContainer.Items.Clear();

                ConnectionToDB cnn       = new ConnectionToDB();
                DataTable      dtInvoice = cnn.GetDataTable("select distinct l.container from packing_list l " +
                                                            " where l.import_id =  " + txtImportId.Text);

                lstImpContainer.DataSource = dtInvoice;

                lstImpContainer.DisplayMember = "container";

                lstImpContainer.SelectedIndex = -1;

                LoadExp();
            }
        }
예제 #2
0
        private void btnSearch_Click(object sender, EventArgs e)
        {
            frmFindImport frm = new frmFindImport();

            frm.strWhere = " and stat='فعال'";
            frm.ShowDialog();

            if (frm.strImportID != "")
            {
                txtImportId.Text  = (frm.strImportID);
                txtImport_no.Text = frm.strImportNo;

                lstImpInvoices.Items.Clear();

                ConnectionToDB cnn       = new ConnectionToDB();
                DataTable      dtInvoice = cnn.GetDataTable("select b.swid,b.bill_number from purchases_bill b " +
                                                            " where b.imports_id = " + txtImportId.Text);

                lstImpInvoices.DataSource    = dtInvoice;
                lstImpInvoices.ValueMember   = "swid";
                lstImpInvoices.DisplayMember = "bill_number";

                lstImpInvoices.SelectedIndex = -1;
            }
        }
예제 #3
0
        private void btnSearch_Click(object sender, EventArgs e)
        {
            frmFindImport frm = new frmFindImport();

            frm.strWhere = " and stat='فعال'";
            frm.ShowDialog();

            if (frm.strImportID != "")
            {
                GetData(frm.strImportID);
            }
        }
예제 #4
0
        private void btnSearch_Click(object sender, EventArgs e)
        {
            frmFindImport frm = new frmFindImport();

            frm.strWhere = " and stat='فعال'";
            frm.ShowDialog();

            if (frm.strImportID != "")
            {
                txtImportId.Text  = (frm.strImportID);
                txtImport_no.Text = frm.strImportNo;


                GetImportItems();
            }
        }