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