partial void DeleteCHUNG_TU_THU_CHI(CHUNG_TU_THU_CHI instance);
partial void UpdateCHUNG_TU_THU_CHI(CHUNG_TU_THU_CHI instance);
private void bbiLuu_ItemClick(object sender, DevExpress.XtraBars.ItemClickEventArgs e)
{
if (!Kiem_Tra())
{
return;
}
string phan_loai = "";
string ma_phan_loai = "";
switch (cbLoai.Text)
{
case "Thu tiền khách chuộc đồ":
phan_loai = "Chuộc";
ma_phan_loai = "Chuoc";
break;
case "Thu tiền khách trả tiền lời":
phan_loai = "Trả tiền lời";
ma_phan_loai = "Loi";
break;
case "Thu tiền khách trả bớt tiền":
phan_loai = "Trả bớt tiền";
ma_phan_loai = "Bot";
break;
default:
phan_loai = "Thu khác";
ma_phan_loai = "Thu Khac";
break;
}
try
{
DB_Quan_Ly_Cam_DoDataContext db = new DB_Quan_Ly_Cam_DoDataContext(SqlHelper.ConnectionString);
if (tinh_trang == "them")
{
CHUNG_TU_THU_CHI cttc = new CHUNG_TU_THU_CHI();
cttc.Ma = txtMa.Text;
cttc.Ngay = txtNgay.DateTime;
cttc.Ngay_Ghi_So = txtNgayGhiSo.DateTime;
cttc.Ma_Chung_Tu_Cam_Do = txtMaChungTuCamDo.Text;
cttc.Loai = "Thu";
cttc.Ma_Phan_Loai = ma_phan_loai;
cttc.Phan_Loai = phan_loai;
cttc.Ten_Loai = cbLoai.Text;
cttc.So_Tien_Cam = txtSoTienCam.Value;
cttc.Tien_Lai = txtTienLai.Value;
cttc.So_Tien_Thu = txtSoTien.Value;
cttc.So_Tien_Chi = 0;
cttc.Ghi_Chu = txtGhi_Chu.Text;
cttc.Sap_Xep = 0;
db.CHUNG_TU_THU_CHIs.InsertOnSubmit(cttc);
}
else
{
var cttc = (from ct in db.CHUNG_TU_THU_CHIs
where ct.Ma == txtMa.Text
select ct).FirstOrDefault();
cttc.Ma = txtMa.Text;
cttc.Ngay = txtNgay.DateTime;
cttc.Ngay_Ghi_So = txtNgayGhiSo.DateTime;
cttc.Ma_Chung_Tu_Cam_Do = txtMaChungTuCamDo.Text;
cttc.Loai = "Thu";
cttc.Ma_Phan_Loai = ma_phan_loai;
cttc.Phan_Loai = phan_loai;
cttc.Ten_Loai = cbLoai.Text;
cttc.So_Tien_Cam = txtSoTienCam.Value;
cttc.Tien_Lai = txtTienLai.Value;
cttc.So_Tien_Thu = txtSoTien.Value;
cttc.So_Tien_Chi = 0;
cttc.Ghi_Chu = txtGhi_Chu.Text;
cttc.Sap_Xep = 0;
}
db.SubmitChanges();
CapNhatCMNDPhieuCamDo();
RaiseReloadEventHander();
Close();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
partial void InsertCHUNG_TU_THU_CHI(CHUNG_TU_THU_CHI instance);
private void bbiLuu_ItemClick(object sender, DevExpress.XtraBars.ItemClickEventArgs e)
{
if (!Kiem_Tra())
{
return;
}
string phan_loai = "";
string ma_phan_loai = "";
switch (cbLoai.Text)
{
case "Chi tiền khách lấy thêm tiền":
phan_loai = "Lấy thêm tiền";
ma_phan_loai = "Them";
break;
default:
phan_loai = "Chi khác";
ma_phan_loai = "Chi Khac";
break;
}
try
{
if (tinh_trang == "them")
{
CHUNG_TU_THU_CHI cttc = new CHUNG_TU_THU_CHI();
cttc.Ma = txtMa.Text;
cttc.Ngay = txtNgay.DateTime;
cttc.Ngay_Ghi_So = txtNgayGhiSo.DateTime;
cttc.Ma_Chung_Tu_Cam_Do = txtMa_Chung_Tu_Cam_Do.Text;
cttc.Loai = "Chi";
cttc.Ma_Phan_Loai = ma_phan_loai;
cttc.Phan_Loai = phan_loai;
cttc.Ten_Loai = cbLoai.Text;
cttc.So_Tien_Thu = 0;
cttc.So_Tien_Chi = txtSoTien.Value;
cttc.Ghi_Chu = txtGhi_Chu.Text;
cttc.Sap_Xep = 0;
db.CHUNG_TU_THU_CHIs.InsertOnSubmit(cttc);
}
else
{
var cttc = (from ct in db.CHUNG_TU_THU_CHIs
where ct.Ma == txtMa.Text
select ct).FirstOrDefault();
cttc.Ma = txtMa.Text;
cttc.Ngay = txtNgay.DateTime;
cttc.Ngay_Ghi_So = txtNgayGhiSo.DateTime;
cttc.Ma_Chung_Tu_Cam_Do = txtMa_Chung_Tu_Cam_Do.Text;
cttc.Loai = "Chi";
cttc.Ma_Phan_Loai = ma_phan_loai;
cttc.Phan_Loai = phan_loai;
cttc.Ten_Loai = cbLoai.Text;
cttc.So_Tien_Thu = 0;
cttc.So_Tien_Chi = txtSoTien.Value;
cttc.Ghi_Chu = txtGhi_Chu.Text;
cttc.Sap_Xep = 0;
}
db.SubmitChanges();
RaiseReloadEventHander();
Close();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
