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);
}
