public void xoa(BANGCONG f) { var sql = data.database().BangCongs.SingleOrDefault(a => a.MaTinhCong == f.cbb_matinhcong.Text); sql.IsDelete = 0; data.database().SubmitChanges(); loaddulieu(f); }
public void loaddulieucbbbl(BANGCONG f1) { var sql = data.database().BangLuongs.Where(a => a.IsDelete == 1); f1.cbb_matinhluong.DataSource = sql; f1.cbb_matinhluong.DisplayMember = "MaTinhLuong"; f1.cbb_matinhluong.ValueMember = "MaTinhLuong"; }
public void tinhcong(BANGCONG f) { double dlcong = 0; dlcong = Convert.ToDouble(f.txt_chedocong.Text) - Convert.ToDouble(f.txt_socongnghi.Text) + Convert.ToDouble(f.txt_congtangca.Text); f.lb_tongcong.Text = Convert.ToString(dlcong); var sql = data.database().BangCongs.SingleOrDefault(a => a.MaTinhCong == f.cbb_matinhcong.Text); sql.DULIEUCONG = Convert.ToDouble(f.lb_tongcong.Text); data.database().SubmitChanges(); }
public void sua(BANGCONG f) { var sql = data.database().BangCongs.SingleOrDefault(a => a.MaTinhCong == f.cbb_matinhcong.Text); sql.CheDoCong = f.txt_chedocong.Text; sql.SoCongNghi = f.txt_socongnghi.Text; sql.SoCongTangCa = f.txt_congtangca.Text; sql.MaTinhLuong = f.cbb_matinhluong.Text; data.database().SubmitChanges(); loaddulieu(f); }
public void them(BANGCONG f) { BangCong bc = new BangCong(); bc.MaTinhCong = f.cbb_matinhcong.Text; bc.CheDoCong = f.txt_chedocong.Text; bc.SoCongNghi = f.txt_socongnghi.Text; bc.SoCongTangCa = f.txt_congtangca.Text; bc.MaTinhLuong = f.cbb_matinhluong.Text; bc.IsDelete = 1; data.database().BangCongs.InsertOnSubmit(bc); data.database().SubmitChanges(); DialogResult thongbao = MessageBox.Show("Thêm thành công", "Thông Báo", MessageBoxButtons.OK); if (thongbao == DialogResult.OK) { loaddulieu(f); } }
private void bt_bangcong_Click(object sender, EventArgs e) { BANGCONG BC = new BANGCONG(); BC.Show(); }
public void loaddulieu(BANGCONG f) { var sql = data.database().BangCongs.Where(a => a.IsDelete == 1); f.dgv_bangcong.DataSource = sql; }