internal void DisplayForPresent(decimal v_id_nhan_vien, string m_txt_nam)
{
US_RPT_LUONG_V2 v_us = new US_RPT_LUONG_V2();
DataSet v_ds = new DataSet();
DataTable v_dt = new DataTable();
v_ds.Tables.Add(v_dt);
v_us.FillDatasetBaoCaoThuNhapDoubleClick(v_ds, v_id_nhan_vien, m_txt_nam);
m_grc_tong_hop.DataSource = v_ds.Tables[0];
m_adv_tong_hop.BestFitColumns();
m_adv_tong_hop.ExpandAllGroups();
fill_du_lieu(v_ds);
m_lbl_nam_2.Text = m_txt_nam;
m_lbl_nam_2.ForeColor = Color.Maroon;
m_lbl_nam_2.Font = new Font("Tahoma", 18, FontStyle.Bold);
this.ShowDialog();
}
internal void DisplayForPresent(decimal v_id_nhan_vien, DateTime ip_dat_tu_thang, DateTime ip_dat_den_thang)
{
US_RPT_LUONG_V2 v_us = new US_RPT_LUONG_V2();
DataSet v_ds = new DataSet();
DataTable v_dt = new DataTable();
v_ds.Tables.Add(v_dt);
v_us.FillDatasetKeKhaiThueDoubleClick(v_ds, v_id_nhan_vien, ip_dat_tu_thang, ip_dat_den_thang);
m_grc_tong_hop.DataSource = v_ds.Tables[0];
fill_du_lieu(v_ds);
m_adv_tong_hop.BestFitColumns();
m_adv_tong_hop.ExpandAllGroups();
m_lbl_nam_2.Text = ip_dat_tu_thang.Year.ToString();
m_lbl_nam_2.ForeColor = Color.Maroon;
m_lbl_nam_2.Font = new Font("Tahoma", 18, FontStyle.Bold);
this.ShowDialog();
}
private void lay_thong_tin_bang_luong()
{
decimal v_dc_so_luong_nhan_vien_can_tinh;
decimal v_dc_so_luong_nhan_vien_da_tinh;
bool v_bol_co_du_lieu_chua;
bool v_bol_chot_bang_luong;
US_RPT_LUONG_V2 v_us_luong_v2 = new US_RPT_LUONG_V2();
v_us_luong_v2.LayTrangThaiBangLuong(THANG
, NAM
, out v_dc_so_luong_nhan_vien_can_tinh
, out v_dc_so_luong_nhan_vien_da_tinh
, out v_bol_co_du_lieu_chua
, out v_bol_chot_bang_luong);
CO_DU_LIEU_LUONG = v_bol_co_du_lieu_chua;
SO_LUONG_NHAN_VIEN_DA_TINH = v_dc_so_luong_nhan_vien_da_tinh;
SO_LUONG_NHAN_VIEN_CAN_TINH = v_dc_so_luong_nhan_vien_can_tinh;
CHOT_BANG_LUONG = v_bol_chot_bang_luong;
}
private void load_data_to_grid()
{
US_RPT_LUONG_V2 v_us = new US_RPT_LUONG_V2();
DataSet v_ds = new DataSet();
v_ds.Tables.Add(new DataTable());
//m_dat_tu_thang.DateTime = new DateTime(2015,06,01);
//m_dat_den_thang.DateTime = new DateTime(2015, 12,31);
v_us.FillDatasetProcBangKeKhaiThuNhap(v_ds, m_dat_tu_thang.DateTime, m_dat_den_thang.DateTime);
m_grc_tong_hop.DataSource = v_ds.Tables[0];
if(v_ds.Tables[0].Rows.Count != 0)
{
m_lbl_nam_2.Text = m_dat_tu_thang.DateTime.Year.ToString();
m_lbl_nam_2.ForeColor = Color.Maroon;
m_lbl_nam_2.Font = new Font("Tahoma", 18, FontStyle.Bold);
format_grid();
hien_thi_cac_o_text_box(v_ds);
}
else
{
MessageBox.Show("Không có dữ liệu cho năm " + m_dat_tu_thang.DateTime.Year.ToString() + " . Vui lòng kiểm tra lại thông tin!");
m_lbl_nam_2.Text = "";
}
}
private void load_data_to_grid()
{
US_RPT_LUONG_V2 v_us = new US_RPT_LUONG_V2();
DataSet v_ds = new DataSet();
v_ds.Tables.Add(new DataTable());
if (m_txt_nam.Text == "")
{
m_txt_nam.Text = "2015";
}
v_us.FillDatasetProcBaoCaoThuNhapTheoNam(v_ds, m_txt_nam.Text);
m_grc_tong_hop.DataSource = v_ds.Tables[0];
if (v_ds.Tables[0].Rows.Count != 0)
{
format_grid();
hien_thi_cac_o_text_box(v_ds);
}
else
{
MessageBox.Show("Không có dữ liệu cho năm " + m_txt_nam.Text + " . Vui lòng kiểm tra lại thông tin!");
m_lbl_nam_2.Text = "";
}
}
public DataSet LayDanhSachNhanVienCanTinhLuong(ENUM_CONFIRM_TINH_BANG_LUONG ip_confirm_cach_tinh, decimal ip_dc_thang, decimal ip_dc_nam)
{
US_RPT_LUONG_V2 v_us_rpt_luong = new US_RPT_LUONG_V2();
DataSet v_ds_danh_sach_nhan_vien;
if(ip_confirm_cach_tinh == ENUM_CONFIRM_TINH_BANG_LUONG.TINH_NHAN_VIEN_CHUA_CO)
{
v_us_rpt_luong.LayDanhSachNhanVienIDChuaTinhLuong(
out v_ds_danh_sach_nhan_vien
, ip_dc_thang
, ip_dc_nam);
}
else if(ip_confirm_cach_tinh == ENUM_CONFIRM_TINH_BANG_LUONG.TINH_LAI_TOAN_BO)
{
v_us_rpt_luong.LayToanBoNhanVienIDTinhLuong(
out v_ds_danh_sach_nhan_vien
, ip_dc_thang
, ip_dc_nam);
}
else
{
v_ds_danh_sach_nhan_vien = new DS_RPT_LUONG_V2();
}
return v_ds_danh_sach_nhan_vien;
}
private US_RPT_LUONG_V2 transfer_dto_2_us_object(DTO_BANG_LUONG_V2 ip_dto_luong)
{
US_RPT_LUONG_V2 v_us_luong_v2 = new US_RPT_LUONG_V2();
v_us_luong_v2.dcID_NHAN_VIEN = ExecuteFuntion.LayNhanVienID(ip_dto_luong.MA_NV);
v_us_luong_v2.dcTHANG = ip_dto_luong.THANG;
v_us_luong_v2.dcNAM = ip_dto_luong.NAM;
v_us_luong_v2.strMA_NV = ip_dto_luong.MA_NV;
v_us_luong_v2.dcLUONG_NS = ip_dto_luong.LUONG_NS;
v_us_luong_v2.dcLUONG_CD = ip_dto_luong.LUONG_CD;
v_us_luong_v2.dcPHU_CAP_TN = ip_dto_luong.PHU_CAP_TN;
v_us_luong_v2.dcAN_CA = ip_dto_luong.AN_CA;
v_us_luong_v2.dcLAM_THEM = ip_dto_luong.LAM_THEM;
v_us_luong_v2.dcGIAM_TRU_LAM_THEM_200 = ip_dto_luong.LAM_THEM_200;
v_us_luong_v2.dcGIAM_TRU_LAM_THEM_300 = ip_dto_luong.LAM_THEM_300;
v_us_luong_v2.dcTHU_NHAP_KHAC_TRONG_LUONG = ip_dto_luong.THU_NHAP_KHAC_TRONG_LUONG;
v_us_luong_v2.dcTONG_THU_NHAP_TRONG_LUONG = ip_dto_luong.TONG_THU_NHAP_TRONG_LUONG;
v_us_luong_v2.dcTHUONG = ip_dto_luong.THUONG;
v_us_luong_v2.dcTHUONG_ATHK = ip_dto_luong.THUONG_ATHK;
v_us_luong_v2.dcBO_SUNG_LUONG = ip_dto_luong.BO_SUNG_LUONG;
v_us_luong_v2.dcTHUONG_LE_TET = ip_dto_luong.THUONG_LE_TET;
v_us_luong_v2.dcTHU_NHAP_KHAC_NGOAI_LUONG = ip_dto_luong.THU_NHAP_KHAC_NGOAI_LUONG;
v_us_luong_v2.dcTONG_THU_NHAP_NGOAI_LUONG = ip_dto_luong.TONG_THU_NHAP_NGOAI_LUONG;
v_us_luong_v2.dcTONG_THU_NHAP = ip_dto_luong.TONG_THU_NHAP;
v_us_luong_v2.dcBHXH = ip_dto_luong.BHXH;
v_us_luong_v2.dcBHYT = ip_dto_luong.BHYT;
v_us_luong_v2.dcBHTN = ip_dto_luong.BHTN;
v_us_luong_v2.dcGIAM_TRU_LAM_THEM_150 = ip_dto_luong.GIAM_TRU_LAM_THEM_150;
v_us_luong_v2.dcGIAM_TRU_LAM_THEM_200 = ip_dto_luong.GIAM_TRU_LAM_THEM_200;
v_us_luong_v2.dcGIAM_TRU_LAM_THEM_300 = ip_dto_luong.GIAM_TRU_LAM_THEM_300;
v_us_luong_v2.dcGIAM_TRU_GIA_CANH = ip_dto_luong.GIAM_TRU_GIA_CANH;
v_us_luong_v2.dcGIAM_TRU_PHU_THUOC = ip_dto_luong.GIAM_TRU_PHU_THUOC;
v_us_luong_v2.dcGIAM_TRU_KHAC = ip_dto_luong.GIAM_TRU_KHAC;
v_us_luong_v2.dcTONG_GIAM_TRU = ip_dto_luong.TONG_GIAM_TRU;
v_us_luong_v2.dcTHU_NHAP_CHIU_THUE = ip_dto_luong.THU_NHAP_TINH_THUE;
v_us_luong_v2.dcDOAN_PHI_CD = ip_dto_luong.DOAN_PHI_CD;
v_us_luong_v2.dcTHUE = ip_dto_luong.THUE;
v_us_luong_v2.dcPHAI_NOP_KHAC = ip_dto_luong.PHAI_NOP_KHAC;
v_us_luong_v2.dcTONG_PHAI_NOP = ip_dto_luong.TONG_PHAI_NOP;
v_us_luong_v2.dcTHUC_LINH = ip_dto_luong.THUC_LINH;
v_us_luong_v2.dcSO_TIEN_DA_NOP_THUE = ip_dto_luong.SO_TIEN_DA_NOP_THUE;
return v_us_luong_v2;
}
private bool kiem_tra_nhan_vien_co_trong_danh_sach_tinh_luong_thang(decimal ip_dc_id_nhan_vien, decimal ip_dc_thang, decimal ip_dc_nam)
{
US_RPT_LUONG_V2 v_us = new US_RPT_LUONG_V2();
return v_us.kiem_tra_nhan_vien_co_duoc_tinh_luong_thang(ip_dc_id_nhan_vien, ip_dc_thang, ip_dc_nam);
}
private DataRow get_luong_1_nhan_vien_v2(decimal ip_dc_id_nhan_vien, decimal ip_dc_thang, decimal ip_dc_nam)
{
US_RPT_LUONG_V2 v_us = new US_RPT_LUONG_V2();
DataSet v_ds = new DataSet();
v_ds.Tables.Add(new DataTable());
v_us.TaoBangLuongNhanVien(v_ds, ip_dc_id_nhan_vien, ip_dc_thang, ip_dc_nam);
DataRow v_dr = v_ds.Tables[0].Rows[0];
return v_dr;
}
public void XoaToanBoBangLuong(decimal ip_dc_thang, decimal ip_dc_nam)
{
US_RPT_LUONG_V2 v_us_luong = new US_RPT_LUONG_V2();
US_RPT_THONG_TIN_TONG_HOP_V2 v_us_rpt_tong_hop = new US_RPT_THONG_TIN_TONG_HOP_V2();
v_us_luong.BeginTransaction();
v_us_luong.XoaToanBoBangLuong(ip_dc_thang, ip_dc_nam);
v_us_rpt_tong_hop.UseTransOfUSObject(v_us_luong);
v_us_rpt_tong_hop.XoaToanBoDuLieuTongHop(ip_dc_thang, ip_dc_nam);
v_us_luong.CommitTransaction();
}
public void XoaBanGhiLuongNhanVien(decimal ip_dc_id_nhan_vien, decimal ip_dc_thang, decimal ip_dc_nam)
{
US_RPT_LUONG_V2 v_us_rpt_luong_v2 = new US_RPT_LUONG_V2();
US_RPT_THONG_TIN_TONG_HOP_V2 v_us_rpt_tong_hop_v2 = new US_RPT_THONG_TIN_TONG_HOP_V2();
v_us_rpt_luong_v2.BeginTransaction();
v_us_rpt_luong_v2.XoaBangLuongNhanVien(ip_dc_id_nhan_vien, ip_dc_thang, ip_dc_nam);
v_us_rpt_tong_hop_v2.UseTransOfUSObject(v_us_rpt_luong_v2);
v_us_rpt_tong_hop_v2.XoaDuLieuTongHopNhanVien(ip_dc_id_nhan_vien, ip_dc_thang, ip_dc_nam);
v_us_rpt_luong_v2.CommitTransaction();
}
