BKI_DichVuMatDat.US.US_DM_NHAN_VIEN.FillDatasetNhanVienCanInsertHeSo C# (CSharp) Method

FillDatasetNhanVienCanInsertHeSo() public method

public FillDatasetNhanVienCanInsertHeSo ( DataSet op_ds, decimal ip_thang, decimal ip_nam ) : void
op_ds System.Data.DataSet
ip_thang decimal
ip_nam decimal
return void
        public void FillDatasetNhanVienCanInsertHeSo(DataSet op_ds, decimal ip_thang, decimal ip_nam)
        {
            CStoredProc v_cstore = new CStoredProc("pr_lay_danh_sach_nhan_vien_can_insert_he_so");
            v_cstore.addDecimalInputParam("@ip_thang", ip_thang);
            v_cstore.addDecimalInputParam("@ip_nam", ip_nam);
            v_cstore.fillDataSetByCommand(this, op_ds);
        }

Usage Example

        private void insert_hs_hs_bs_hs_anhk(decimal ip_dc_thang, decimal ip_dc_nam)
        {
            US_DM_NHAN_VIEN v_us_dung_chung = new US_DM_NHAN_VIEN();
            DataSet v_ds = new DataSet();
            v_ds.Tables.Add(new DataTable());
            v_us_dung_chung.FillDatasetNhanVienCanInsertHeSo(v_ds, ip_dc_thang, ip_dc_nam);
            //v_us_dung_chung.FillDatasetWithQuery(v_ds, "SELECT DISTINCT * FROM V_RPT_LUONG WHERE THANG = " + m_txt_thang.Text.Trim() + " AND NAM = " + m_txt_nam.Text.Trim());

            //m_grc.DataSource = v_ds.Tables[0];

            for(int i = 0; i < v_ds.Tables[0].Rows.Count; i++)
            {
                decimal v_id_nv = CIPConvert.ToDecimal(v_ds.Tables[0].Rows[i]["ID_NHAN_VIEN"].ToString());
                US_GD_HS_BO_SUNG_AN_TOAN_HANG_KHONG v_us = new US_GD_HS_BO_SUNG_AN_TOAN_HANG_KHONG();

                v_us.insert_data_by_proc(v_id_nv, ip_dc_thang, ip_dc_nam);
            }
            DevExpress.XtraEditors.XtraMessageBox.Show("Thành công!!!", "THÔNG BÁO");
            load_data_2_grid();
        }
US_DM_NHAN_VIEN