private void bbiXoa_ItemClick(object sender, DevExpress.XtraBars.ItemClickEventArgs e)
{
if (MessageBox.Show("Khi xóa chứng từ thì tất cả các phiếu thu liên quan sẽ được xóa theo.\nBạn có muốn xóa không?", "Thông báo", MessageBoxButtons.YesNo, MessageBoxIcon.Warning) == DialogResult.No)
return;
gbList.Focus();
int[] selectedRows = gbList.GetSelectedRows();
string[] chungtu = new string[selectedRows.Length];
for (int i = selectedRows.Length; i > 0; i--)
{
var arg = gbList.GetRowCellValue(selectedRows[i - 1], colMa_Chung_Tu);
if (arg == null)
continue;
if (!KiemTraPhieuDaChuoc(arg.ToString()))
continue;
chungtu[i - 1] = arg.ToString();
}
var db = new DB_Quan_Ly_Cam_DoDataContext(SqlHelper.ConnectionString);
try
{
db.Connection.Open();
System.Data.Common.DbTransaction transaction = db.Connection.BeginTransaction();
db.Transaction = transaction;
var ct = from c in db.CHUNG_TUs
where chungtu.Contains(c.Ma_Chung_Tu)
select c;
foreach (var c in ct)
{
db.CHUNG_TUs.DeleteOnSubmit(c);
var chung_tu_thu_chi = from cttcs in db.CHUNG_TU_THU_CHIs
where cttcs.Ma_Chung_Tu_Cam_Do == c.Ma_Chung_Tu
select cttcs;
foreach (var cttc in chung_tu_thu_chi)
{
db.CHUNG_TU_THU_CHIs.DeleteOnSubmit(cttc);
}
}
db.SubmitChanges();
db.Transaction.Commit();
db.Connection.Close();
bbiXem_ItemClick(this, null);
}
catch (Exception ex)
{
db.Transaction.Rollback();
MessageBox.Show(ex.Message);
}
}
private void bbiXoa_ItemClick(object sender, DevExpress.XtraBars.ItemClickEventArgs e)
{
if (MessageBox.Show("Có muốn xóa không?", "Thông báo", MessageBoxButtons.YesNo, MessageBoxIcon.Warning) == DialogResult.No)
return;
gbList.Focus();
int[] selectedRows = gbList.GetSelectedRows();
string[] chungtuthuchi = new string[selectedRows.Length];
for (int i = selectedRows.Length; i > 0; i--)
{
var arg = gbList.GetRowCellValue(selectedRows[i - 1], colMa);
if (arg == null)
continue;
chungtuthuchi[i - 1] = arg.ToString();
}
DB_Quan_Ly_Cam_DoDataContext db = new DB_Quan_Ly_Cam_DoDataContext(SqlHelper.ConnectionString);
var cttc = from ct in db.CHUNG_TU_THU_CHIs
where chungtuthuchi.Contains(ct.Ma)
select ct;
foreach (var c in cttc)
{
db.CHUNG_TU_THU_CHIs.DeleteOnSubmit(c);
}
try
{
db.SubmitChanges();
bbiXem_ItemClick(this, null);
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
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);
}
}
public void CapNhatCMNDPhieuCamDo()
{
if (cbCapNhatCMND.Checked && !string.IsNullOrEmpty(txtSoCMND.Text.Trim()))
{
try
{
DB_Quan_Ly_Cam_DoDataContext db = new DB_Quan_Ly_Cam_DoDataContext(SqlHelper.ConnectionString);
var chung_tu_cam_do = (from ct in db.CHUNG_TUs
where ct.Ma_Chung_Tu == txtMaChungTuCamDo.Text
select ct).First();
chung_tu_cam_do.So_CMND = txtSoCMND.Text;
db.SubmitChanges();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
}
string Luu_Chi_Tiet(DB_Quan_Ly_Cam_DoDataContext database)
{
var ket_qua = "OK";
var dt = dsCamDo.CHUNG_TU_CHI_TIET;
var id = "";
var row = 0;
for (var i = 0; i < dt.Rows.Count; i++)
{
if (dt.Rows[i].RowState != DataRowState.Deleted)
{
if (dt.Rows[i]["Ten_Tai_San"] == DBNull.Value || string.IsNullOrEmpty(dt.Rows[i]["Ten_Tai_San"].ToString()))
{
MessageBox.Show("Tên tài sản không được rỗng.", "Thông báo",
MessageBoxButtons.OK, MessageBoxIcon.Warning);
ket_qua = "Tên tài sản không được rỗng.";
gbList.FocusedRowHandle = row;
gbList.SetColumnError(colTen_Tai_San, "Tên tài sản không được rỗng.");
return ket_qua;
}
id = dt.Rows[i]["Ma_Chi_Tiet"].ToString();
row++;
}
var dr = dt.Rows[i];
switch (dr.RowState)
{
case DataRowState.Added:
var chung_tu_chi_tiet = new CHUNG_TU_CHI_TIET
{
Ma_Chi_Tiet = Guid.NewGuid(),
Ma_Chung_Tu = txtMaChungTu.Text,
Ten_Tai_San = dt.Rows[i]["Ten_Tai_San"].ToString(),
Loai_Vang = dt.Rows[i]["Loai_Vang"].ToString(),
Trong_Luong_Vang_18k = Convert.ToDecimal(dt.Rows[i][colTrong_Luong_Vang_18k.FieldName] == DBNull.Value ? 0 : dt.Rows[i][colTrong_Luong_Vang_18k.FieldName]),
Trong_Luong_Vang_24k = Convert.ToDecimal(dt.Rows[i][colTrong_Luong_Vang_24k.FieldName] == DBNull.Value ? 0 : dt.Rows[i][colTrong_Luong_Vang_24k.FieldName]),
Trong_Luong_Khac = Convert.ToDecimal(dt.Rows[i][colTrong_Luong_Khac.FieldName] == DBNull.Value ? 0 : dt.Rows[i][colTrong_Luong_Khac.FieldName]),
Trong_Luong = dt.Rows[i]["Trong_Luong"].ToString(),
Chuan_Do = dt.Rows[i]["Chuan_Do"].ToString(),
Gia_Tri_Vat_Cam = Convert.ToDecimal(dt.Rows[i]["Gia_Tri_Vat_Cam"] == DBNull.Value ? 0 : dt.Rows[i]["Gia_Tri_Vat_Cam"]),
Sap_Xep = 0
};
database.CHUNG_TU_CHI_TIETs.InsertOnSubmit(chung_tu_chi_tiet);
break;
case DataRowState.Modified:
var chi_tiet_sua = (from ctct in database.CHUNG_TU_CHI_TIETs
where ctct.Ma_Chi_Tiet == new Guid(id)
select ctct).FirstOrDefault();
chi_tiet_sua.Ma_Chi_Tiet = new Guid(id);
chi_tiet_sua.Ma_Chung_Tu = txtMaChungTu.Text;
chi_tiet_sua.Ten_Tai_San = dt.Rows[i]["Ten_Tai_San"].ToString();
chi_tiet_sua.Loai_Vang = dt.Rows[i]["Loai_Vang"].ToString();
chi_tiet_sua.Trong_Luong_Vang_18k = Convert.ToDecimal(dt.Rows[i][colTrong_Luong_Vang_18k.FieldName] == DBNull.Value ? 0 : dt.Rows[i][colTrong_Luong_Vang_18k.FieldName]);
chi_tiet_sua.Trong_Luong_Vang_24k = Convert.ToDecimal(dt.Rows[i][colTrong_Luong_Vang_24k.FieldName] == DBNull.Value ? 0 : dt.Rows[i][colTrong_Luong_Vang_24k.FieldName]);
chi_tiet_sua.Trong_Luong_Khac = Convert.ToDecimal(dt.Rows[i][colTrong_Luong_Khac.FieldName] == DBNull.Value ? 0 : dt.Rows[i][colTrong_Luong_Khac.FieldName]);
chi_tiet_sua.Trong_Luong = dt.Rows[i]["Trong_Luong"].ToString();
chi_tiet_sua.Chuan_Do = dt.Rows[i]["Chuan_Do"].ToString();
chi_tiet_sua.Gia_Tri_Vat_Cam = Convert.ToDecimal(dt.Rows[i]["Gia_Tri_Vat_Cam"] == DBNull.Value ? 0 : dt.Rows[i]["Gia_Tri_Vat_Cam"]);
chi_tiet_sua.Sap_Xep = 0;
break;
case DataRowState.Deleted:
var chi_tiet_xoa = (from ctct in database.CHUNG_TU_CHI_TIETs
where ctct.Ma_Chi_Tiet == new Guid(dt.Rows[i]["Ma_Chi_Tiet", DataRowVersion.Original].ToString())
select ctct).FirstOrDefault();
database.CHUNG_TU_CHI_TIETs.DeleteOnSubmit(chi_tiet_xoa);
break;
}
database.SubmitChanges();
}
return ket_qua;
}
private void bbiLuu_ItemClick(object sender, DevExpress.XtraBars.ItemClickEventArgs e)
{
gbList.FocusedRowHandle += 1;
gbList.UpdateCurrentRow();
if (!Kiem_Tra())
{
return;
}
DB_Quan_Ly_Cam_DoDataContext database = new DB_Quan_Ly_Cam_DoDataContext(SqlHelper.ConnectionString);
try
{
database.Connection.Open();
System.Data.Common.DbTransaction transaction = database.Connection.BeginTransaction();
database.Transaction = transaction;
if (tinh_trang == "them")
{
CHUNG_TU chung_tu = new CHUNG_TU
{
Ma_Chung_Tu = txtMaChungTu.Text,
So = txtSo.Text,
Lien = txtLien.Text,
Ngay = txtNgay.DateTime,
Ten_Khach_Hang = txtKhachHang.Text,
So_CMND = txtCMNDSo.Text,
Ngay_Cap_CMND = txtNgayCap.Text,
Noi_Cap = txtNoiCap.Text,
Ngay_Sinh = txtNgaySinh.Text,
Dia_Chi = txtDiaChi.Text,
So_Dien_Thoai = txtSoDienThoai.Text,
Chu_Tiem = txtChuTiem.Text,
So_Tien_Cam = txtSoTienCam.Value,
Tu_Ngay = txtTuNgay.Text,
Den_Ngay = txtDenNgay.Text,
Lai_Suat_Ngay = txtLaiSuatNgay.Value,
Lai_Suat_Thang = txtLaiSuatThang.Value,
Da_Chuoc = false,
Ghi_Chu = txtGhiChu.Text,
//Tien_Lai_Cu = txtTienLaiCu.Value,
//Chung_Tu_Goc = txtChungTuGoc.Text,
Da_Lam_Lai_Giay = false,
Mat_Giay = false,
Sap_Xep = 0
};
database.CHUNG_TUs.InsertOnSubmit(chung_tu);
}
else
{
var chung_tu = (from ct in database.CHUNG_TUs
where ct.Ma_Chung_Tu == txtMaChungTu.Text
select ct).FirstOrDefault();
chung_tu.Ma_Chung_Tu = txtMaChungTu.Text;
chung_tu.So = txtSo.Text;
chung_tu.Lien = txtLien.Text;
chung_tu.Ngay = txtNgay.DateTime;
chung_tu.Ten_Khach_Hang = txtKhachHang.Text;
chung_tu.So_CMND = txtCMNDSo.Text;
chung_tu.Ngay_Cap_CMND = txtNgayCap.Text;
chung_tu.Noi_Cap = txtNoiCap.Text;
chung_tu.Ngay_Sinh = txtNgaySinh.Text;
chung_tu.Dia_Chi = txtDiaChi.Text;
chung_tu.So_Dien_Thoai = txtSoDienThoai.Text;
chung_tu.Chu_Tiem = txtChuTiem.Text;
chung_tu.So_Tien_Cam = txtSoTienCam.Value;
chung_tu.Tu_Ngay = txtTuNgay.Text;
chung_tu.Den_Ngay = txtDenNgay.Text;
chung_tu.Lai_Suat_Ngay = txtLaiSuatNgay.Value;
chung_tu.Lai_Suat_Thang = txtLaiSuatThang.Value;
chung_tu.Da_Chuoc = false;
chung_tu.Ghi_Chu = txtGhiChu.Text;
//chung_tu.Tien_Lai_Cu = txtTienLaiCu.Value;
//chung_tu.Chung_Tu_Goc = txtChungTuGoc.Text;
chung_tu.Da_Lam_Lai_Giay = false;
chung_tu.Mat_Giay = false;
chung_tu.Sap_Xep = 0;
}
string ket_qua = "";
//if (lcChungTuGoc.Visibility == DevExpress.XtraLayout.Utils.LayoutVisibility.Always && !string.IsNullOrEmpty(txtChungTuGoc.Text))
//{
// ket_qua = Luu_Lam_Giay_Moi(database);
// if (ket_qua != "OK")
// {
// database.Transaction.Rollback();
// MessageBox.Show(ket_qua);
// }
//}
ket_qua = Luu_Chi_Tiet(database);
if (ket_qua == "OK")
{
database.SubmitChanges();
database.Transaction.Commit();
database.Connection.Close();
if (InPhieu)
{
var rpt = new rptPhieuInCamDo(txtMaChungTu.Text, cbInThongTinRutGon.Checked);
//rpt.AssignPrintTool(new ReportPrintTool(rpt));
rpt.CreateDocument();
//rpt.ShowPreview();
int lien = 0;
if (int.TryParse(txtLien.Text, out lien))
{
for (int i = 0; i < lien - 1; i++)
{
var rpt_add = new rptPhieuInCamDo(txtMaChungTu.Text, false);
rpt_add.CreateDocument();
rpt.Pages.AddRange(rpt_add.Pages);
}
}
rpt.PrintingSystem.ContinuousPageNumbering = true;
ReportPrintTool printTool = new ReportPrintTool(rpt);
printTool.ShowPreview();
}
InPhieu = false;
RaiseReloadEventHander();
Close();
}
else
{
database.Transaction.Rollback();
MessageBox.Show(ket_qua);
}
}
catch (Exception ex)
{
database.Transaction.Rollback();
MessageBox.Show(ex.ToString());
}
}
