Наследование: IP.Core.IPUserService.US_Object
 private void load_data_to_sle_ten_nhan_vien()
 {
     DataSet v_ds = new DataSet();
     DataTable v_dt = new DataTable();
     US_DUNG_CHUNG v_us = new US_DUNG_CHUNG();
     v_ds.Tables.Add(v_dt);
     throw new Exception("Sua lai khong dung FillDataSetWithTableName nua nhe");
        // v_us.FillDatasetWithTableName(v_ds, "V_DM_NHAN_VIEN");
     m_sle_ten_nhan_vien.Properties.DataSource = v_ds.Tables[0];
     m_sle_ten_nhan_vien.Properties.BestFitMode = BestFitMode.BestFitResizePopup;
 }
 private void delete_gd_da_co_trong_thang_cua_nhan_vien(US_DUNG_CHUNG v_us_dc, DataRow v_data_row, decimal ip_dc_id_nv)
 {
     decimal v_id_gd_hs_chat_luong = 0;
     DataSet v_ds = new DataSet();
     v_ds.Tables.Add(new DataTable());
     v_us_dc.FillDatasetWithQuery(v_ds, "SELECT * FROM GD_HE_SO_CHAT_LUONG WHERE ID_NHAN_VIEN =" + ip_dc_id_nv + " AND THANG = " + CIPConvert.ToDecimal(m_txt_chon_thang.Text.Trim()) + " AND NAM = " + CIPConvert.ToDecimal(m_txt_chon_nam.Text.Trim()));
     if (v_ds.Tables[0].Rows.Count > 0)
     {
         v_id_gd_hs_chat_luong = CIPConvert.ToDecimal(v_ds.Tables[0].Rows[0]["ID"].ToString());
         US_GD_HE_SO_CHAT_LUONG v_us_gd_hs_cl = new US_GD_HE_SO_CHAT_LUONG(v_id_gd_hs_chat_luong);
         v_us_gd_hs_cl.BeginTransaction();
         v_us_gd_hs_cl.Delete();
         v_us_gd_hs_cl.CommitTransaction();
     }
     else
     {
         return;
     }
 }
 private bool check_ngay_cong_phep(System.Data.DataRow v_dr)
 {
     if (v_dr["MA_NGAY_CONG"].ToString() == "F")
     {
         DataSet v_ds = new DataSet();
         US_DUNG_CHUNG v_us = new US_DUNG_CHUNG();
         v_ds.Tables.Add(new DataTable());
         string v_nam_cham_cong = m_dat_ngay_cham_cong.Value.Year.ToString();
         decimal v_id_nhan_vien = CIPConvert.ToDecimal(v_dr["ID_NHAN_VIEN"].ToString());
         v_us.FillDatasetNgayPhepTieuChuan(v_ds, v_nam_cham_cong , v_id_nhan_vien);
         decimal v_so_phep_da_nghi = CIPConvert.ToDecimal(v_ds.Tables[0].Rows[0]["SO_PHEP_DA_NGHI"].ToString());
         decimal v_so_phep_tieu_chuan = CIPConvert.ToDecimal(v_ds.Tables[0].Rows[0]["SO_PHEP_TIEU_CHUAN"].ToString());
         if (v_so_phep_da_nghi == v_so_phep_tieu_chuan)
         {
             return false;
         }
         else return true;
     }
     else return true;
 }
        private void load_data_2_gridd(decimal ip_dc_thang, decimal ip_dc_nam)
        {
            CHRMCommon.make_stt(m_grv_quan_ly_thu_nhap_khac);
            US_DUNG_CHUNG v_us = new US_DUNG_CHUNG();
            DataSet v_ds = new DataSet();
            v_ds.Tables.Add(new DataTable());

            v_us.FillDatasetWithQuery(v_ds, "SELECT * FROM V_GD_THU_NHAP_KHAC WHERE THANG = " + ip_dc_thang + " AND NAM = " + ip_dc_nam);

            m_grc_quan_ly_thu_nhap_khac.DataSource = v_ds.Tables[0];
        }
        private void load_data_2_grid(decimal ip_dc_thang, decimal ip_dc_nam)
        {
            CHRMCommon.make_stt(m_grv_hs_chat_luong);
            US_DUNG_CHUNG v_us = new US_DUNG_CHUNG();
            DataSet v_ds = new DataSet();
            v_ds.Tables.Add(new DataTable());

            //v_us.FillDatasetWithQuery(v_ds, "SELECT * FROM V_GD_HE_SO_CHAT_LUONG WHERE THANG = " + ip_dc_thang + " AND NAM = " + ip_dc_nam);
            m_grc_hs_chat_luong.DataSource = v_ds.Tables[0];
        }
        private DataSet load_data_2_ds_v_dm_nv()
        {
            US_DUNG_CHUNG v_us = new US_DUNG_CHUNG();
            DataSet v_ds = new DataSet();

            v_ds.Tables.Add(new DataTable());
            v_us.FillDatasetWithTableName(v_ds, "V_DM_NHAN_VIEN");
            return v_ds;
        }
 private void load_data_2_grid()
 {
     int v_row_count = 0;
     CHRMCommon.make_stt(m_grv_cham_cong);
     US_DUNG_CHUNG v_us = new US_DUNG_CHUNG();
     DataSet v_ds = new System.Data.DataSet();
     v_ds.Tables.Add(new DataTable());
     v_us.FillDatasetGDChamCong(v_ds, m_dat_ngay_cham_cong.Value.Date);
     v_row_count = v_ds.Tables[0].Rows.Count;
     m_grc_cham_cong.DataSource = v_ds.Tables[0];
 }
        private DataSet load_data_2_ds_dm_loai_ngay_cong(DataSet v_ds_dm_loai_ngay_cong)
        {
            US_DUNG_CHUNG v_us = new US_DUNG_CHUNG();
            DataSet v_ds_ = new DataSet();
            v_ds_dm_loai_ngay_cong.Tables.Add(new DataTable());
            v_us.FillDatasetWithQuery(v_ds_dm_loai_ngay_cong, "select ID AS ID_LOAI_NGAY_CONG, MA_NGAY_CONG, TEN_NGAY_CONG FROM DM_LOAI_NGAY_CONG");

            return v_ds_dm_loai_ngay_cong;
        }
 private void LayDuLieuLoaiNgayCong()
 {
     US_DUNG_CHUNG v_us = new US_DUNG_CHUNG();
     m_ds_loai_ngay_cong.Tables.Add(new DataTable());
     m_ds_loai_ngay_cong.Clear();
     v_us.FillDatasetCBO(m_ds_loai_ngay_cong, "DM_LOAI_NGAY_CONG", "ID", "MA_NGAY_CONG", "");
 }
        private void kiem_tra_va_thuc_hien_nhap_hs(ref decimal v_count, ref int v_int_khong_nhap_duoc, decimal v_selectedRowCount)
        {
            if (CHRMCommon.thang_da_chot_bang_luong(CIPConvert.ToDecimal(m_txt_chon_thang.Text.Trim()), CIPConvert.ToDecimal(m_txt_chon_nam.Text.Trim())))
            {
                CHRM_BaseMessages.MsgBox_Error(CONST_ID_MSGBOX.ERROR_THANG_DA_CHOT_BANG_LUONG);
                return;
            }
            else
            {
                for (int i = 0; i < v_selectedRowCount; i++)
                {
                    decimal v_id_nv = 0;
                    US_DUNG_CHUNG v_us_dc = new US_DUNG_CHUNG();
                    US_GD_HE_SO_CHAT_LUONG v_us_hs_cl = new US_GD_HE_SO_CHAT_LUONG();

                    var v_data_row = m_grv_them_hs.GetDataRow(m_grv_them_hs.GetSelectedRows()[i]);

                    try
                    {
                        get_id_nhan_vien_tu_data_row(v_us_dc, v_data_row, ref v_id_nv);
                    }
                    catch (Exception)
                    {
                        CHRM_BaseMessages.MsgBox_Error("Mã nhân viên " + v_data_row[1].ToString() + " không tồn tại trong hệ thống. Vui lòng kiểm tra lại thông tin!");
                        v_int_khong_nhap_duoc++;
                        continue;
                    }

                    v_us_hs_cl.dcID_NHAN_VIEN = v_id_nv;
                    v_us_hs_cl.dcHE_SO_K = Convert.ToDecimal(v_data_row["HSK"]);
                    v_us_hs_cl.dcTHANG = CIPConvert.ToDecimal(m_txt_chon_thang.Text.Trim());
                    v_us_hs_cl.dcNAM = CIPConvert.ToDecimal(m_txt_chon_nam.Text.Trim());
                    v_us_hs_cl.datNGAY_LAP = DateTime.Now.Date;
                    v_us_hs_cl.strNGUOI_LAP = CAppContext_201.getCurrentUserName();
                    v_us_hs_cl.strDA_XOA = "N";

                    try
                    {
                        delete_gd_da_co_trong_thang_cua_nhan_vien(v_us_dc, v_data_row, v_id_nv);
                        v_us_hs_cl.BeginTransaction();
                        v_us_hs_cl.Insert();
                        v_us_hs_cl.CommitTransaction();
                        v_count++;
                    }
                    catch (Exception)
                    {
                        CHRM_BaseMessages.MsgBox_Error(CONST_ID_MSGBOX.ERROR_DA_CO_LOI_XAY_RA);
                        v_int_khong_nhap_duoc++;
                    }
                }
            }
        }
 private void get_id_nhan_vien_tu_data_row(US_DUNG_CHUNG v_us_dc, DataRow v_data_row, ref decimal v_id_nv)
 {
     DataSet v_ds = new DataSet();
     v_ds.Tables.Add(new DataTable());
     v_us_dc.FillDatasetWithQuery(v_ds, "SELECT * FROM DM_NHAN_VIEN WHERE MA_NV ='" + v_data_row[1].ToString() + "'");
     v_id_nv = CIPConvert.ToDecimal(v_ds.Tables[0].Rows[0]["ID"].ToString());
 }
        private void tao_file_mau()
        {
            US_DUNG_CHUNG v_us = new US_DUNG_CHUNG();
            DataSet v_ds = new DataSet();
            v_ds.Tables.Add(new DataTable());
            v_us.get_bang_cham_cong(v_ds, m_txt_chon_thang.Text, m_txt_chon_nam.Text);

            var v_c_hsk = new DataColumn();
            v_c_hsk.ColumnName = "HSK";
            v_ds.Tables[0].Columns.Add(v_c_hsk);
            m_grc_them_hs.DataSource = v_ds.Tables[0];
            SaveXLSX();
        }
        private DataSet load_data_2_ds_v_dm_nv()
        {
            US_DUNG_CHUNG v_us = new US_DUNG_CHUNG();
            DataSet v_ds = new DataSet();

            v_ds.Tables.Add(new DataTable());
            throw new Exception("Sua lai khong dung FillDataSetWithTableName nua nhe");
            //v_us.FillDatasetWithTableName(v_ds, "V_DM_NHAN_VIEN");
            return v_ds;
        }