示例#1
0
        private void fill()
        {
            accessDb ad = new accessDb();
            DataSet  ds = ad.getData("payment");

            metroGrid1.DataSource = ds.Tables["payment"].DefaultView;
        }
示例#2
0
文件: buyerView.cs 项目: tayduivn/ITP
        private void viewAll_Load(object sender, EventArgs e)
        {
            // TODO: This line of code loads data into the 'itpDataSet.buyer' table. You can move, or remove it, as needed.
            //this.buyerTableAdapter.Fill(this.itpDataSet.buyer);
            accessDb ad = new accessDb();
            DataSet  ds = ad.getData("buyer");

            viewTable.DataSource = ds.Tables["buyer"].DefaultView;
        }
示例#3
0
        private void comboBox1_SelectedIndexChanged(object sender, EventArgs e)
        {
            accessDb adb = new accessDb();

            this.ptotal     = adb.getData("invoice", "invoiceNo", comboBox1.Text, "netTotal");
            label15.Visible = true;
            label15.Text    = this.ptotal;

            string tempOut = adb.getData("invoice", "invoiceNo", comboBox1.Text, "buyerId");

            this.pcredit    = adb.getData("buyer", "buyerId", tempOut, "creditLimit");
            label17.Visible = true;
            label17.Text    = this.pcredit;

            string due = adb.getData("due", "invoiceNo", comboBox1.Text, "totalPaid");

            //MessageBox.Show("Total = "+ this.ptotal+"\n totalPaid= "+tempOut+ "\n Credit = "+this.pcredit +"\n due ="+due);

            if (double.Parse(this.ptotal) - double.Parse(due) == 0)
            {
                radioButton1.Enabled = false;
                radioButton2.Enabled = false;

                groupBox1.Enabled = false;
                groupBox2.Enabled = false;
            }
            else
            {
                radioButton1.Enabled = true;
                radioButton2.Enabled = true;
            }

            if (string.IsNullOrEmpty(due) || due == "0")
            {
                label16.Text = this.ptotal;
            }
            else
            {
                label16.Text = (double.Parse(this.ptotal) - double.Parse(due)).ToString();
            }
        }