private DTO_QUY_THU_NHAP_KHAC create_dto_quy_thu_nhap_khac(decimal ip_dc_id_quy_thu_nhap_khac)
{
DTO_QUY_THU_NHAP_KHAC v_dto_quy = new DTO_QUY_THU_NHAP_KHAC();
//Lay du lieu tu Db
US_GD_QUY_THU_NHAP_KHAC v_us_quy = new US_GD_QUY_THU_NHAP_KHAC();
DataRow v_dr_quy = v_us_quy.LayThongTinQuyThuNhapKhac(ip_dc_id_quy_thu_nhap_khac);
//Chuyen doi du lieu sang dto
v_dto_quy.CO_DU_LIEU = v_dr_quy[V_TNK_GD_QUY_THU_NHAP_KHAC.CO_DU_LIEU].ToString() == "Y" ? true : false;
v_dto_quy.DA_XOA = v_dr_quy[V_TNK_GD_QUY_THU_NHAP_KHAC.DA_XOA].ToString();
v_dto_quy.NGUOI_LAP = v_dr_quy[V_TNK_GD_QUY_THU_NHAP_KHAC.NGUOI_LAP].ToString();
v_dto_quy.NGUOI_LAP_PHAN_MEM = v_dr_quy[V_TNK_GD_QUY_THU_NHAP_KHAC.NGUOI_LAP_PHAN_MEM].ToString();
v_dto_quy.GHI_CHU = v_dr_quy[V_TNK_GD_QUY_THU_NHAP_KHAC.GHI_CHU].ToString();
v_dto_quy.LY_DO_THUONG = v_dr_quy[V_TNK_GD_QUY_THU_NHAP_KHAC.LY_DO_THUONG].ToString();
v_dto_quy.TEN_QUY = v_dr_quy[V_TNK_GD_QUY_THU_NHAP_KHAC.TEN_QUY].ToString();
v_dto_quy.NGAY_LAP = v_dr_quy[V_TNK_GD_QUY_THU_NHAP_KHAC.NGAY_LAP] == DBNull.Value ? (DateTime?) null : Convert.ToDateTime(v_dr_quy[V_TNK_GD_QUY_THU_NHAP_KHAC.NGAY_LAP]);
v_dto_quy.NGAY_LAP_PHAN_MEM = v_dr_quy[V_TNK_GD_QUY_THU_NHAP_KHAC.NGAY_LAP_PHAN_MEM] == DBNull.Value ? (DateTime?)null : Convert.ToDateTime(v_dr_quy[V_TNK_GD_QUY_THU_NHAP_KHAC.NGAY_LAP_PHAN_MEM]);
v_dto_quy.TU_NGAY_XET_THUONG = v_dr_quy[V_TNK_GD_QUY_THU_NHAP_KHAC.TU_NGAY_XET_THUONG] == DBNull.Value ? (DateTime?)null : Convert.ToDateTime(v_dr_quy[V_TNK_GD_QUY_THU_NHAP_KHAC.TU_NGAY_XET_THUONG]);
v_dto_quy.DEN_NGAY_XET_THUONG = v_dr_quy[V_TNK_GD_QUY_THU_NHAP_KHAC.DEN_NGAY_XET_THUONG] == DBNull.Value ? (DateTime?)null : Convert.ToDateTime(v_dr_quy[V_TNK_GD_QUY_THU_NHAP_KHAC.DEN_NGAY_XET_THUONG]);
v_dto_quy.ID = Convert.ToDecimal(v_dr_quy[V_TNK_GD_QUY_THU_NHAP_KHAC.ID]);
v_dto_quy.ID_LOAI_THU_NHAP_KHAC = Convert.ToDecimal(v_dr_quy[V_TNK_GD_QUY_THU_NHAP_KHAC.ID_LOAI_QUY_THU_NHAP_KHAC]);
v_dto_quy.THANG = Convert.ToDecimal(v_dr_quy[V_TNK_GD_QUY_THU_NHAP_KHAC.THANG]);
v_dto_quy.NAM = Convert.ToDecimal(v_dr_quy[V_TNK_GD_QUY_THU_NHAP_KHAC.NAM]);
v_dto_quy.SO_LUONG_NV_TRONG_QUY = Convert.ToDecimal(v_dr_quy[V_TNK_GD_QUY_THU_NHAP_KHAC.SO_LUONG_NV_TRONG_QUY]);
v_dto_quy.TONG_TIEN = Convert.ToDecimal(v_dr_quy[V_TNK_GD_QUY_THU_NHAP_KHAC.TONG_TIEN]);
v_dto_quy.TONG_TIEN_NOP_THUE = Convert.ToDecimal(v_dr_quy[V_TNK_GD_QUY_THU_NHAP_KHAC.TONG_TIEN_NOP_THUE]);
v_dto_quy.TONG_TIEN_THUC_LINH = Convert.ToDecimal(v_dr_quy[V_TNK_GD_QUY_THU_NHAP_KHAC.TONG_TIEN_THUC_LINH]);
return v_dto_quy;
}
internal void display_for_update(US_GD_QUY_THU_NHAP_KHAC v_us)
{
if (check_quy_tien_dang_su_dung_yn(v_us.dcID) || check_quy_tien_da_chot_yn(v_us.strTHANG, v_us.strNAM))
{
m_dat_thang_ap_dung_quy.Enabled = false;
m_sle_loai_quy_thu_nhap.Enabled = false;
}
m_us = v_us;
us_to_form(v_us);
this.ShowDialog();
}
private void delete_gd_thu_nhap_khac(US_GD_QUY_THU_NHAP_KHAC v_us_gd_quy_tnk)
{
US_GD_THU_NHAP_KHAC v_us = new US_GD_THU_NHAP_KHAC();
DS_GD_THU_NHAP_KHAC v_ds = new DS_GD_THU_NHAP_KHAC();
v_us.XoaTNKTheoIDQuy(v_us_gd_quy_tnk.dcID);
//for (int i = 0; i < m_dt_thu_nhap_khac.Rows.Count; i++)
//{
// US_GD_THU_NHAP_KHAC v_us = new US_GD_THU_NHAP_KHAC(decimal.Parse(m_dt_thu_nhap_khac.Rows[i][0].ToString()));
// v_us.Delete();
//}
}
public void Display_for_insert(decimal ip_dc_id_quy_thu_nhap_khac)
{
US_GD_QUY_THU_NHAP_KHAC v_us_quy = new US_GD_QUY_THU_NHAP_KHAC(ip_dc_id_quy_thu_nhap_khac);
m_us_gd_tnk = new US_GD_THU_NHAP_KHAC();
m_us_gd_tnk.dcID_QUY_THU_NHAP_KHAC = v_us_quy.dcID;
m_us_gd_tnk.dcID_LOAI_THU_NHAP_KHAC = v_us_quy.dcID_LOAI_QUY_THU_NHAP_KHAC;
m_us_gd_tnk.dcNAM = Convert.ToDecimal(v_us_quy.strNAM);
m_us_gd_tnk.dcTHANG = Convert.ToDecimal(v_us_quy.strTHANG);
m_e_form_mode = DataEntryFormMode.InsertDataState;
ShowDialog();
}
private bool check_quy_tien_dang_su_dung_yn(US_GD_QUY_THU_NHAP_KHAC v_us)
{
m_dt_thu_nhap_khac.Clear();
US_GD_THU_NHAP_KHAC v_us_gd_tnk = new US_GD_THU_NHAP_KHAC();
DS_GD_THU_NHAP_KHAC v_ds_gd_tnk = new DS_GD_THU_NHAP_KHAC();
v_us_gd_tnk.LayDuLieuThuNhapKhacTheoIDQuy(v_ds_gd_tnk, v_us.dcID);
if (v_ds_gd_tnk.Tables[0].Rows.Count != 0)
{
m_dt_thu_nhap_khac = v_ds_gd_tnk.Tables[0];
return true;
}
else return false;
}
private void load_data_to_sle_quy_tien()
{
DS_GD_QUY_THU_NHAP_KHAC v_ds = new DS_GD_QUY_THU_NHAP_KHAC();
US_GD_QUY_THU_NHAP_KHAC v_us = new US_GD_QUY_THU_NHAP_KHAC();
v_us.FillDatasetQuyTNKbyIDLoaiQuy(v_ds, 756);
m_sle_quy_tien.Properties.DataSource = v_ds.Tables[0];
}
private decimal get_thang_theo_quy(decimal v_id_quy)
{
US_GD_QUY_THU_NHAP_KHAC v_us = new US_GD_QUY_THU_NHAP_KHAC();
DS_GD_QUY_THU_NHAP_KHAC v_ds = new DS_GD_QUY_THU_NHAP_KHAC();
v_us.FillDataset(v_ds, "where id=" + v_id_quy);
return decimal.Parse(v_ds.Tables[0].Rows[0][2].ToString());
}
private void us_to_form(US_GD_QUY_THU_NHAP_KHAC v_us)
{
m_sle_loai_quy_thu_nhap.EditValue = v_us.dcID_LOAI_QUY_THU_NHAP_KHAC;
m_sle_cach_tinh_thue.EditValue = v_us.dcID_CACH_QUYET_TOAN;
m_txt_ten_quy.Text = v_us.strTEN_QUY;
m_dat_thang_ap_dung_quy.DateTime = new DateTime(int.Parse(v_us.strNAM), int.Parse(v_us.strTHANG), 1);
m_dat_ngay_lap_quy.DateTime = v_us.datNGAY_LAP;
m_txt_nguoi_lap_quy.Text = v_us.strNGUOI_LAP;
m_dat_tu_ngay.DateTime = v_us.datTU_NGAY_XET_THUONG;
m_dat_den_ngay.DateTime = v_us.datDEN_NGAY_XET_THUONG;
m_txt_ly_do_lap_quy.Text = v_us.strLY_DO_THUONG;
}
private bool kiem_tra_xem_trong_quy_co_nhan_vien_chua()
{
US_GD_QUY_THU_NHAP_KHAC v_us = new US_GD_QUY_THU_NHAP_KHAC();
return v_us.KiemTraQuyCoNhanVienChua(m_us_gd_tnk.dcID_QUY_THU_NHAP_KHAC, m_us_gd_tnk.dcID_NHAN_VIEN);
}
private void load_data_to_grid()
{
CHRMCommon.make_stt_indicator(m_grv);
US_GD_QUY_THU_NHAP_KHAC v_us = new US_GD_QUY_THU_NHAP_KHAC();
DS_GD_QUY_THU_NHAP_KHAC v_ds = new DS_GD_QUY_THU_NHAP_KHAC();
v_us.FillDatasetQuyTNK(v_ds, m_dat_tu_thang.DateTime, m_dat_den_thang.DateTime);
m_grc.DataSource = v_ds.Tables[0];
}
private void delete_gd_quy_tien(US_GD_QUY_THU_NHAP_KHAC v_us)
{
v_us.strDA_XOA = "Y";
v_us.Update();
}
private void xoa_quy_tien(US_GD_QUY_THU_NHAP_KHAC v_us)
{
if (check_quy_tien_dang_su_dung_yn(v_us))
{
int v_slg_nvien = m_dt_thu_nhap_khac.Rows.Count;
string v_str_confirms = "Quỹ tiền đang được sử dụng cho " + v_slg_nvien + " nhân viên.\nBạn có muốn xóa cả khoản thu nhập của " + v_slg_nvien + " nhân viên đang sử dụng quỹ tiền này?";
DialogResult v_dialog = XtraMessageBox.Show(v_str_confirms, "Cảnh báo", MessageBoxButtons.YesNo, MessageBoxIcon.Warning);
if (v_dialog == DialogResult.No)
return;
}
delete_gd_thu_nhap_khac(v_us);
delete_gd_quy_tien(v_us);
XtraMessageBox.Show("Đã xóa thành công!");
}
void m_cmd_update_Click(object sender, EventArgs e)
{
try
{
var v_dr = m_grv.GetDataRow(m_grv.FocusedRowHandle);
US_GD_QUY_THU_NHAP_KHAC v_us = new US_GD_QUY_THU_NHAP_KHAC(CIPConvert.ToDecimal(v_dr[0].ToString()));
if (m_grv.FocusedRowHandle < 0)
XtraMessageBox.Show("Bạn chưa chọn dòng dữ liệu để sửa", "Lỗi", MessageBoxButtons.OK, MessageBoxIcon.Error);
//else if (check_quy_tien_da_chot_yn(v_dr[2].ToString(), v_dr[3].ToString()))
// XtraMessageBox.Show("Quỹ tiền hiện đã chốt. Vui lòng không cập nhật!", "Thông báo", MessageBoxButtons.OK, MessageBoxIcon.Stop);
//else if (check_quy_tien_dang_su_dung_yn(v_us))
// XtraMessageBox.Show("Quỹ đã chi tiền cho nhân viên, vui lòng không cập nhật!", "Thông báo", MessageBoxButtons.OK, MessageBoxIcon.Stop);
else
{
f354_danh_sach_quy_thuong_de v_f = new f354_danh_sach_quy_thuong_de();
v_f.display_for_update(v_us);
load_data_to_grid();
}
}
catch (Exception v_e)
{
CSystemLog_301.ExceptionHandle(v_e);
}
}
void m_cmd_delete_Click(object sender, EventArgs e)
{
try
{
var v_dr = m_grv.GetDataRow(m_grv.FocusedRowHandle);
if (m_grv.FocusedRowHandle < 0)
XtraMessageBox.Show("Bạn chưa chọn dòng dữ liệu để sửa", "Lỗi", MessageBoxButtons.OK, MessageBoxIcon.Error);
else if (check_quy_tien_da_chot_yn(v_dr[2].ToString(), v_dr[3].ToString()))
XtraMessageBox.Show("Bạn không thể xóa quỹ tiền đã chốt!","Thông báo",MessageBoxButtons.OK,MessageBoxIcon.Stop);
else
{
US_GD_QUY_THU_NHAP_KHAC v_us = new US_GD_QUY_THU_NHAP_KHAC(CIPConvert.ToDecimal(v_dr[0].ToString()));
string v_str_confirm = "Bạn có chắc chắn muốn xóa quỹ tiền này?";
DialogResult v_dialog = XtraMessageBox.Show(v_str_confirm,"Xác nhận",MessageBoxButtons.YesNo,MessageBoxIcon.Question);
if (v_dialog == DialogResult.Yes)
{
xoa_quy_tien(v_us);
load_data_to_grid();
}
}
}
catch (Exception v_e)
{
CSystemLog_301.ExceptionHandle(v_e);
}
}
private DataTable create_data_chi_tiet_quy(decimal ip_dc_id_quy_thu_nhap_khac)
{
US_GD_QUY_THU_NHAP_KHAC v_us_quy = new US_GD_QUY_THU_NHAP_KHAC();
return v_us_quy.LayChiTietQuy(ip_dc_id_quy_thu_nhap_khac);
}
