private void btn_sua_Click(object sender, EventArgs e) { int flag = 1; PHIEU_CHI pc = new PHIEU_CHI(); //txt_maphieuchi.Text = pc.MA_PCHI; //txt_chuthich.Text = pc.CHU_THICH; //txt_tien.Text = pc.SO_TIEN.ToString(); //cb_date.DateTime = (DateTime)pc.NGAY_LAP; //cbo_tk.SelectedValue = pc.MATK; //cb_cthm.SelectedValue = pc.MA_CTHM_CHI; //txt_chicho.Text = pc.CHI_CHO_AI; try { pc.MA_PCHI = gridView1.GetFocusedRowCellValue("MA_PHIEU_CHI").ToString(); pc.MATK = gridView1.GetFocusedRowCellValue("MA_TK").ToString(); pc.MA_CTHM_CHI = int.Parse(gridView1.GetFocusedRowCellValue("MA_CTHM_CHI").ToString()); pc.NGAY_LAP = DateTime.Parse(gridView1.GetFocusedRowCellValue("NGAY_LAP").ToString()); pc.SO_TIEN = decimal.Parse(gridView1.GetFocusedRowCellValue("SO_TIEN").ToString()); pc.CHU_THICH = gridView1.GetFocusedRowCellValue("CHU_THICH").ToString() + ""; pc.CHI_CHO_AI = (gridView1.GetFocusedRowCellValue("CHI_CHO_AI") == null ? "" : gridView1.GetFocusedRowCellValue("CHI_CHO_AI").ToString()); int mahmchi = int.Parse(gridView1.GetFocusedRowCellValue("MA_HM_CHI").ToString()); string matiente = gridView1.GetFocusedRowCellValue("MA_LOAI").ToString(); XtraForm1 frm = new XtraForm1(pc, mahmchi, matiente); frm.ShowDialog(); } catch (Exception ex) { } }
//kiem tra khoa chinh public int KT_KhoaChinh(string ma) { PHIEU_CHI p = qlc.PHIEU_CHIs.Where(t => t.MA_PCHI == ma).FirstOrDefault(); if (p != null) { return(1); } return(0); }
//kiểm tra khóa ngoại public int KT_KhoaNgoai(string matk) { PHIEU_CHI pc = qlq.PHIEU_CHIs.Where(t => t.MATK == matk).FirstOrDefault(); PHIEU_THU pt = qlq.PHIEU_THUs.Where(t => t.MATK == matk).FirstOrDefault(); if (pc != null || pt != null) { return(1); } return(0); }
private void simpleButton3_Click(object sender, EventArgs e) { try { PHIEU_CHI p = new PHIEU_CHI(); if (txt_maphieuchi.Text.Trim() == string.Empty) { txt_maphieuchi.Text = get_maphieu(); } p.MA_PCHI = txt_maphieuchi.Text; p.MATK = cbo_tk.SelectedValue.ToString(); if (txt_tien.Text.Trim() == string.Empty) { txt_tien.Text = 0 + ""; } p.SO_TIEN = (decimal.Parse(txt_tien.Text) * decimal.Parse(txt_tigia.Text)); p.MA_CTHM_CHI = int.Parse(cb_cthm.SelectedValue.ToString()); if (cb_date.SelectedText == null) { MessageBox.Show("Chưa chọn ngày"); return; } p.NGAY_LAP = DateTime.Parse(cb_date.EditValue.ToString()); p.CHU_THICH = txt_chuthich.Text; p.CHI_CHO_AI = string.Empty; if (flag != 1) //thêm mới { int kq = qlc.Them_PhieuChi(p); if (kq == 1) { MessageBox.Show("Thêm thành công"); int update = qlc.update_tien(p.MATK, (decimal)p.SO_TIEN); qlc.load_grid(); this.Close(); } else { MessageBox.Show("Lỗi"); } } else //sửa { int kq = qlc.Sua_PhieuChi(pc.MA_PCHI, p); if (kq == 0) { MessageBox.Show("Sửa thành công"); } } } catch (Exception ex) { } }
//thêm public int Them_PhieuChi(PHIEU_CHI p) { try { if (KT_KhoaChinh(p.MA_PCHI) == 1) { return(0); } qlc.PHIEU_CHIs.InsertOnSubmit(p); qlc.SubmitChanges(); return(1); } catch (Exception ex) { return(0); } }
//xóa phiếu chi public int Xoa_PhieuChi(string ma) { try { PHIEU_CHI p = qlc.PHIEU_CHIs.Where(t => t.MA_PCHI == ma).FirstOrDefault(); TAI_KHOAN tk = qlc.TAI_KHOANs.Where(t => t.MATK == p.MATK).FirstOrDefault(); tk.SODUHT += p.SO_TIEN; qlc.PHIEU_CHIs.DeleteOnSubmit(p); qlc.SubmitChanges(); return(0); } catch (Exception ex) { return(1); } }
public XtraForm1(PHIEU_CHI pc1, int mahm, string matiente) { pc = pc1; mahmchi = mahm; maloai = matiente; this.flag = 1; InitializeComponent(); //pcn.MA_PCHI = pc.MA_PCHI.ToString().Trim() ; //txt_chuthich.Text = pc.CHU_THICH; //txt_tien.Text = pc.SO_TIEN.ToString(); //cb_date.DateTime = (DateTime)pc.NGAY_LAP; //cbo_tk.SelectedValue = pc.MATK; //cb_cthm.SelectedValue = pc.MA_CTHM_CHI; //txt_chicho.Text = pc.CHI_CHO_AI; }
//sửa public int Sua_PhieuChi(string ma, PHIEU_CHI pc) { PHIEU_CHI p = qlc.PHIEU_CHIs.Where(t => t.MA_PCHI == ma).FirstOrDefault(); p.MA_CTHM_CHI = pc.MA_CTHM_CHI; update_tien_lan2(pc.MATK, p.SO_TIEN, pc.SO_TIEN); p.SO_TIEN = pc.SO_TIEN; p.NGAY_LAP = pc.NGAY_LAP; p.CHU_THICH = pc.CHU_THICH; p.CHI_CHO_AI = pc.CHI_CHO_AI; qlc.SubmitChanges(); return(0); }