private void load_toSettingGrade() { MysqlClass db = new MysqlClass(); DataTable tb = db.GetData("SELECT cou.keterangan FROM(SELECT keterangan FROM tb_grade group by keterangan) as cou"); //MessageBox.Show(tb.Rows.Count.ToString()); foreach (DataRow row in tb.Rows) { TabPage tp = new TabPage(row["keterangan"].ToString()); Bunifu.Framework.UI.BunifuCustomDataGrid dgv = new Bunifu.Framework.UI.BunifuCustomDataGrid(); dgv.Dock = DockStyle.Fill; dgv.Columns.Add("no", "No"); dgv.Columns.Add("grade", "Grade"); dgv.Columns.Add("biaya", "Biaya"); dgv.RowHeadersVisible = false; dgv.ColumnHeadersDefaultCellStyle.BackColor = Color.FromArgb(67, 20, 109); dgv.ColumnHeadersDefaultCellStyle.ForeColor = Color.White; dgv.Dock = DockStyle.Fill; dgv.Location = new Point(20, 10); tp.Controls.Add(dgv); // settingGrade1.tabControl1.TabPages.Add(tp); } }
void BunifuFlatButton4Click(object sender, EventArgs e) { MysqlClass db = new MysqlClass(); db.Execute("INSERT INTO tb_dana_tetap (keterangan,lama,grade,kat, biaya) VALUES (@a, @b, @c, @d, @e)", new MySql.Data.MySqlClient.MySqlParameter("@a", bunifuMetroTextbox3.Text), new MySql.Data.MySqlClient.MySqlParameter("@b", txtlama.Text), new MySql.Data.MySqlClient.MySqlParameter("@d", cmbketerangan.selectedValue.ToString()), new MySql.Data.MySqlClient.MySqlParameter("@c", cmbgrade.selectedValue.ToString()), new MySql.Data.MySqlClient.MySqlParameter("@e", txtbiaya.Text) ); DataTable tb2 = db.GetData("select * from tb_dana_tetap"); int nub = 0; bunifuCustomDataGrid1.Rows.Clear(); for (int i = 0; i < tb2.Rows.Count; i++) { nub++; bunifuCustomDataGrid1.Rows.Add(tb2.Rows[i]["id"].ToString(), nub.ToString(), tb2.Rows[i]["keterangan"].ToString(), tb2.Rows[i]["lama"].ToString(), tb2.Rows[i]["kat"].ToString(), tb2.Rows[i]["grade"].ToString(), tb2.Rows[i]["biaya"].ToString(), tb2.Rows[i]["total"].ToString()); } foreach (DataGridViewRow row in bunifuCustomDataGrid1.Rows) { row.Cells[7].Value = (double.Parse(row.Cells[3].Value.ToString()) * double.Parse(row.Cells[6].Value.ToString())).ToString(); //More code here } }
private void load_dataBiayaTetap() { MysqlClass db = new MysqlClass(); DataTable tb = db.GetData("SELECT cou.keterangan FROM(SELECT keterangan FROM tb_grade group by keterangan) as cou"); //load }
void CmbgradeonItemSelected(object sender, EventArgs e) { MysqlClass db = new MysqlClass(); DataTable tb = db.GetData("select biaya from tb_grade where keterangan = @ket and grade = @gr", new MySql.Data.MySqlClient.MySqlParameter("@ket", cmbketerangan.selectedValue.ToString()), new MySql.Data.MySqlClient.MySqlParameter("@gr", cmbgrade.selectedValue.ToString().Substring(0, 1))); //MessageBox.Show(tb.Rows.Count.ToString()); txtbiaya.Text = tb.Rows[0]["biaya"].ToString(); }
void BunifuFlatButton3Click(object sender, EventArgs e) { if (bunifuCustomDataGrid1.SelectedRows.Count > 0) { var id_edit = bunifuCustomDataGrid1.CurrentRow.Cells[0].Value.ToString(); MysqlClass db = new MysqlClass(); DataTable tb2 = db.GetData("select a.* ,b.biaya from tb_dana_tetap as a, tb_grade as b WHERE a.grade = b.grade AND a.kat = b.keterangan AND id = @id", new MySql.Data.MySqlClient.MySqlParameter("@id", id_edit)); } else { MessageBox.Show("Pilih Data"); } }
void CmbketeranganonItemSelected(object sender, EventArgs e) { if (cmbketerangan.selectedIndex != -1) { MysqlClass db = new MysqlClass(); DataTable tb = db.GetData("select grade, biaya from tb_grade where keterangan = @ket", new MySql.Data.MySqlClient.MySqlParameter("@ket", cmbketerangan.selectedValue.ToString())); cmbgrade.Clear(); foreach (DataRow row in tb.Rows) { cmbgrade.AddItem(row["grade"].ToString() + " " + string.Format("{0:N0}", double.Parse(row["biaya"].ToString()))); } } else { cmbgrade.Clear(); } }
void load_data() { MysqlClass db = new MysqlClass(); DataTable tb = db.GetData("select keterangan from tb_grade group by keterangan"); biayaTetap.Instance.bunifuCustomDataGrid1.Columns[0].Visible = false; foreach (DataRow row in tb.Rows) { biayaTetap.Instance.cmbketerangan.AddItem(row["keterangan"].ToString()); } DataTable tb2 = db.GetData("select * from tb_dana_tetap"); int num = 0; for (int i = 0; i < tb2.Rows.Count; i++) { num++; bunifuCustomDataGrid1.Rows.Add(tb2.Rows[i]["id"].ToString(), num.ToString(), tb2.Rows[i]["keterangan"].ToString(), tb2.Rows[i]["lama"].ToString(), tb2.Rows[i]["kat"].ToString(), tb2.Rows[i]["grade"].ToString(), tb2.Rows[i]["biaya"].ToString(), tb2.Rows[i]["total"].ToString()); } }