public PPOStatus(PPO ppo, ListView listView1)
        {
            this.PPO = ppo;
            this.lv  = listView1;
            InitializeComponent();
            PPONo.Text                 = lv.SelectedItems[0].Text;
            SupplierNo.Text            = lv.SelectedItems[0].SubItems[1].Text;
            PurchaseOrderRevision.Text = lv.SelectedItems[0].SubItems[2].Text;
            CreationDate.Text          = lv.SelectedItems[0].SubItems[3].Text;
            EffectiveDate.Text         = lv.SelectedItems[0].SubItems[4].Text;
            BuyerName.Text             = lv.SelectedItems[0].SubItems[5].Text;
            BillingAddress.Text        = lv.SelectedItems[0].SubItems[6].Text;
            BuyerAccount.Text          = lv.SelectedItems[0].SubItems[7].Text;
            SRNo.Text     = lv.SelectedItems[0].SubItems[8].Text;
            Amount.Text   = lv.SelectedItems[0].SubItems[9].Text;
            Currency.Text = lv.SelectedItems[0].SubItems[10].Text;
            TAC.Text      = lv.SelectedItems[0].SubItems[11].Text;
            MySqlConnection cnn = new MySqlConnection("server=code4cat.me; user id=jackysc; password=123456; database=procurement;SslMode=none");

            cnn.Open();
            MySqlDataAdapter getItem = new MySqlDataAdapter("SELECT * FROM PPOLines WHERE PPONo = '" + PPONo.Text + "'", cnn);
            DataTable        dt      = new DataTable();

            getItem.Fill(dt);
            foreach (DataRow dr in dt.Rows)
            {
                dataGridView1.Rows.Add(dr["ItemDescription"].ToString(), dr["Quantity"].ToString(), dr["UOM"].ToString(), dr["Price"].ToString());
            }
            SetReadonlyControls(groupBox1.Controls);
        }
예제 #2
0
 public PPOEdit(PPO ppo, ListView listView1)
 {
     this.PPO = ppo;
     this.lv  = listView1;
     InitializeComponent();
     PPONo.Text                 = lv.SelectedItems[0].Text;
     SupplierNo.Text            = lv.SelectedItems[0].SubItems[1].Text;
     PurchaseOrderRevision.Text = lv.SelectedItems[0].SubItems[2].Text;
     CreationDate.Text          = lv.SelectedItems[0].SubItems[3].Text;
     EffectiveDate.Text         = lv.SelectedItems[0].SubItems[4].Text;
     BuyerName.Text             = lv.SelectedItems[0].SubItems[5].Text;
     BillingAddress.Text        = lv.SelectedItems[0].SubItems[6].Text;
     BuyerAccount.Text          = lv.SelectedItems[0].SubItems[7].Text;
     SRNo.Text     = lv.SelectedItems[0].SubItems[8].Text;
     Amount.Text   = lv.SelectedItems[0].SubItems[9].Text;
     Currency.Text = lv.SelectedItems[0].SubItems[10].Text;
     TAC.Text      = lv.SelectedItems[0].SubItems[11].Text;
 }
예제 #3
0
        private void button3_Click(object sender, EventArgs e)
        {
            PPO PPO = new PPO(this);

            PPO.ShowDialog();
        }