public void GetThamSoBangLuongThang(DS_BAO_CAO_THAM_SO_BANG_LUONG ip_ds, decimal ip_dec_thang, decimal ip_dec_nam)
 {
     CStoredProc v_sp = new CStoredProc("PR_GET_THAM_SO_BANG_LUONG");
     v_sp.addDecimalInputParam("@THANG", ip_dec_thang);
     v_sp.addDecimalInputParam("@NAM", ip_dec_nam);
     v_sp.fillDataSetByCommand(this, ip_ds);
 }
コード例 #2
0
ファイル: WebControl.cs プロジェクト: anhphamkstn/DVMC
 public void FillDatasetLopMonDaCo(DataSet v_ds, decimal id_nhan_vien, decimal id_mon_hoc)
 {
     CStoredProc v_cstore = new CStoredProc("get_lop_mon_da_co");
     v_cstore.addDecimalInputParam("@id_nhan_vien", id_nhan_vien);
     v_cstore.addDecimalInputParam("@id_mon_hoc", id_mon_hoc);
     v_cstore.fillDataSetByCommand(this, v_ds);
 }
コード例 #3
0
 public void FillDatasetWithProc(DataSet op_ds, string ip_str_table_name, string ip_str_column_name)
 {
     CStoredProc v_cstore = new CStoredProc("get_data_to_dataset_with_table_name_and_column_name");
     v_cstore.addNVarcharInputParam("@TABLE_NAME", ip_str_table_name);
     v_cstore.addNVarcharInputParam("@COLUMN_NAME", ip_str_column_name);
     v_cstore.fillDataSetByCommand(this, op_ds);
 }
コード例 #4
0
 public void FillDatasetLogin(DataSet v_ds, string user,string pass, decimal id_chi_nhanh)
 {
     CStoredProc v_cstore = new CStoredProc("check_login");
     v_cstore.addNVarcharInputParam("@user", user);
     v_cstore.addNVarcharInputParam("@pass", pass);
     v_cstore.addDecimalInputParam("@id_chi_nhanh", id_chi_nhanh);
     v_cstore.fillDataSetByCommand(this, v_ds);
 }
コード例 #5
0
 internal void FillDatasetCBO(DataSet op_ds, string ip_str_table_name, string ip_str_value_field, string ip_str_display_field, string ip_str_condition)
 {
     CStoredProc v_cstore = new CStoredProc("get_data_for_cbo");
     v_cstore.addNVarcharInputParam("@TABLE_NAME", ip_str_table_name);
     v_cstore.addNVarcharInputParam("@COLUMN_VALUE", ip_str_value_field);
     v_cstore.addNVarcharInputParam("@COLUMN_DISPLAY", ip_str_display_field);
     v_cstore.addNVarcharInputParam("@CONDITION", ip_str_condition);
     v_cstore.fillDataSetByCommand(this, op_ds);
 }
コード例 #6
0
    private void load_data_grid(string ip_str_tu_khoa)
    {
        DS_DM_DAT v_ds_dm_dat = new DS_DM_DAT();

        if (ip_str_tu_khoa.Equals(String.Empty))
        {
            m_us_dm_dat.FillDataset(v_ds_dm_dat);
        }
        else
        {
            CStoredProc v_cstore = new CStoredProc("pr_DM_DAT_Search");
            v_cstore.addNVarcharInputParam("@TU_KHOA", ip_str_tu_khoa);
            v_cstore.fillDataSetByCommand(m_us_dm_dat, v_ds_dm_dat);
        }
        m_grv_danh_sach_nha.DataSource = v_ds_dm_dat.DM_DAT;
        m_grv_danh_sach_nha.DataBind();
    }
コード例 #7
0
        public static string ExecuteFuntionSql(string ip_str_funtion_name, params object[] parameters)
        {
            string v_str_select = "select dbo." + ip_str_funtion_name;
            string v_str_param = "";
            foreach(object item in parameters)
            {
                v_str_param = v_str_param + "'" + item.ToString()+ "'" + ",";
            }
            string v_query = v_str_select + "(" + v_str_param;
            if(parameters.Length > 0)
            {
                v_query = v_query.Substring(0, v_query.LastIndexOf(","));
            }
            v_query = v_query + ")";
            CStoredProc v_sp = new CStoredProc("pr_execute_funtion_sql");
            v_sp.addNVarcharInputParam("@ip_str_query", v_query);

            DataSet v_ds = new DataSet();
            v_ds.Tables.Add();
            US_DUNG_CHUNG v_us = new US_DUNG_CHUNG();
            v_sp.fillDataSetByCommand(v_us, v_ds);

            return v_ds.Tables[0].Rows[0][0].ToString();
        }
コード例 #8
0
 internal void FillDatasetWithTableName(DataSet op_ds, string ip_str_table_name)
 {
     CStoredProc v_cstore = new CStoredProc("get_data_from_table");
     v_cstore.addNVarcharInputParam("@TABLE_NAME", ip_str_table_name);
     v_cstore.fillDataSetByCommand(this, op_ds);
 }
コード例 #9
0
 public void FillDataSet_Load_data_to_grid_danh_muc_don_vi_by_key_word(
     DS_DM_DON_VI op_ds_don_vi
     , decimal v_dc_id_loai_don_vi
     , string v_str_user_name
     , string v_str_key_word)
 {
     CStoredProc cstored = new CStoredProc("pr_DM_DON_VI_Load_to_grid_danh_muc_by_key_word");
     cstored.addDecimalInputParam("@ip_dc_loai_don_vi", v_dc_id_loai_don_vi);
     cstored.addNVarcharInputParam("@ip_str_user_name", v_str_user_name);
     cstored.addNVarcharInputParam("@ip_str_key_word", v_str_key_word);
     cstored.fillDataSetByCommand(this, op_ds_don_vi);
 }
コード例 #10
0
 public void FillDatasetByQueryString(
     WebDS.DS_DM_DON_VI op_ds_don_vi
     , string v_dc_id_loai_don_vi)
 {
     CStoredProc cstored = new CStoredProc("pr_DM_DON_VI_grid");
     cstored.addDecimalInputParam("@ID_LOAI_DON_VI", v_dc_id_loai_don_vi);
     cstored.fillDataSetByCommand(this, op_ds_don_vi);
 }
コード例 #11
0
 public void FillDataset(
     DS_DM_DON_VI op_ds_don_vi
     , decimal ip_dc_id_loai_don_vi
     , decimal ip_dc_id_don_vi_cap_tren1
     , decimal ip_dc_id_don_vi_cap_tren2
     , string ip_str_loai_hinh_don_vi
     , string ip_str_user_name
     )
 {
     CStoredProc v_obj_procedure = new CStoredProc("pr_DM_DON_VI_loai_hinh_don_vi_Select_by_user_name");
     v_obj_procedure.addNVarcharInputParam("@ip_str_user_name", ip_str_user_name);
     v_obj_procedure.addDecimalInputParam("@ip_dc_loai_don_vi", ip_dc_id_loai_don_vi);
     v_obj_procedure.addDecimalInputParam("@ip_dc_id_dv_cap_tren1", ip_dc_id_don_vi_cap_tren1);
     v_obj_procedure.addDecimalInputParam("@ip_dc_id_dv_cap_tren2", ip_dc_id_don_vi_cap_tren2);
     v_obj_procedure.addNVarcharInputParam("@ip_str_loai_hinh_don_vi", ip_str_loai_hinh_don_vi);
     v_obj_procedure.fillDataSetByCommand(this, op_ds_don_vi);
 }
コード例 #12
0
 public void fill_data_bo_loc(DS_V_HT_LOG_TRUY_CAP op_ds_ht_log_truy_cap
                         , string ip_str_username
                         , DateTime ip_dat_tu_ngay
                         , DateTime ip_dat_den_ngay
                         , decimal ip_dc_id_hanh_dong)
 {
     CStoredProc v_cstore = new CStoredProc("pr_V_HT_LOG_TRUY_CAP_filter");
     v_cstore.addNVarcharInputParam("@USERNAME", ip_str_username);
     v_cstore.addDatetimeInputParam("@TU_NGAY", ip_dat_tu_ngay);
     v_cstore.addDatetimeInputParam("@DEN_NGAY", ip_dat_den_ngay);
     v_cstore.addDecimalInputParam("@ID_LOAI_HANH_DONG", ip_dc_id_hanh_dong);
     v_cstore.fillDataSetByCommand(this, op_ds_ht_log_truy_cap);
 }
コード例 #13
0
 public DataTable GetLNSTheoHopDong(decimal ip_id_hop_dong)
 {
     CStoredProc v_cstore = new CStoredProc("pr_LNS_get_theo_hop_dong");
     v_cstore.addDecimalInputParam("@ip_id_hop_dong", ip_id_hop_dong);
     DS_GD_HE_SO_LNS v_ds = new DS_GD_HE_SO_LNS();
     v_cstore.fillDataSetByCommand(this, v_ds);
     return v_ds.Tables[0];
 }
コード例 #14
0
 internal void FillDatasetSQLInjection(DataSet v_ds, string p)
 {
     CStoredProc v_cstore = new CStoredProc("sqlInjection");
     v_cstore.addNVarcharInputParam("@str_query", p);
     v_cstore.fillDataSetByCommand(this, v_ds);
 }
コード例 #15
0
        public DS_V_GD_CONG_TAC LayDanhSachNhanVienKiemNhiem(DateTime ip_dat_tu_ngay, DateTime ip_dat_den_ngay)
        {
            CStoredProc v_sp = new CStoredProc("pr_lay_danh_sach_nhan_vien_bo_nhiem");
            DS_V_GD_CONG_TAC v_ds = new DS_V_GD_CONG_TAC();
            v_ds.EnforceConstraints = false;

            v_sp.addDatetimeInputParam("@ip_dat_tu_ngay", ip_dat_tu_ngay);
            v_sp.addDatetimeInputParam("@ip_dat_den_ngay", ip_dat_den_ngay);
            v_sp.fillDataSetByCommand(this, v_ds);
            return v_ds;
        }
コード例 #16
0
 public DataTable LayDanhSachNhanVienChuaCoLNS()
 {
     CStoredProc v_cstore = new CStoredProc("pr_LNS_danh_sach_nhan_vien_khong_co_lns_GetAll");
     DataSet v_ds = new DataSet();
     v_ds.Tables.Add(new DataTable());
     v_cstore.fillDataSetByCommand(this, v_ds);
     return v_ds.Tables[0];
 }
コード例 #17
0
        public DataTable LayDanhSachHopDongThayDoiHeSoLNS(DateTime ip_dat_tu_ngay, DateTime ip_dat_den_ngay)
        {
            CStoredProc v_cs = new CStoredProc("pr_HD_hop_dong_thay_doi_he_so_lns_GetAll");
            v_cs.addDatetimeInputParam("@ip_dat_tu_ngay", ip_dat_tu_ngay);
            v_cs.addDatetimeInputParam("@ip_dat_den_ngay", ip_dat_den_ngay);
            DataSet v_ds = new DataSet();
            v_ds.Tables.Add();
            v_cs.fillDataSetByCommand(this, v_ds);

            return v_ds.Tables[0];
        }
コード例 #18
0
 public DataSet LayDanhSachHetHanLNSTrongThang()
 {
     CStoredProc v_cstore = new CStoredProc("pr_LNS_het_han_trong_thang");
     DataSet v_ds = new DataSet();
     v_ds.Tables.Add(new DataTable());
     v_cstore.fillDataSetByCommand(this, v_ds);
     return v_ds;
 }
コード例 #19
0
 public DataTable LayDanhSachHeSoLNS(string ip_str_filter, decimal ip_dc_thang, decimal ip_dc_nam)
 {
     CStoredProc v_cstore = new CStoredProc("pr_LNS_danh_sach_he_so_lns_GetAll");
     DataSet v_ds = new DataSet();
     v_ds.Tables.Add(new DataTable());
     v_cstore.addNVarcharInputParam("@ip_str_option", ip_str_filter);
     v_cstore.addDecimalInputParam("@thang", ip_dc_thang);
     v_cstore.addDecimalInputParam("@nam", ip_dc_nam);
     v_cstore.fillDataSetByCommand(this, v_ds);
     return v_ds.Tables[0];
 }
コード例 #20
0
 public void FillDatasetGDChiTietChucVu(DataSet op_ds, DateTime ip_dat)
 {
     CStoredProc v_cstore = new CStoredProc("rpt_tinh_hinh_dao_tao");
     v_cstore.addDatetimeInputParam("@ip_dat_ngay_bao_cao",ip_dat );
     v_cstore.fillDataSetByCommand(this, op_ds);
 }
コード例 #21
0
 public void bc_giao_von_quy_bao_tri_theo_qd(DataSet ip_ds
     , decimal ip_id_don_vi
     , decimal ip_dc_id_loai_nhiem_vu
     , decimal ip_dc_id_cong_trinh
     , decimal ip_dc_id_du_an
     , DateTime ip_dat_tu_ngay
     , DateTime ip_dat_den_ngay
     , string ip_str_tu_khoa
     , string ip_nguon_ns)
 {
     CStoredProc v_prc = new CStoredProc("pr_A256_giao_von_theo_quyet_dinh");
     v_prc.addDecimalInputParam("@ip_dc_id_don_vi", ip_id_don_vi);
     v_prc.addDecimalInputParam("@ip_dc_id_du_an", ip_dc_id_du_an);
     v_prc.addDecimalInputParam("@ip_dc_id_cong_trinh", ip_dc_id_cong_trinh);
     v_prc.addDecimalInputParam("@ip_dc_id_loai_nhiem_vu", ip_dc_id_loai_nhiem_vu);
     v_prc.addDatetimeInputParam("@ip_dat_tu_ngay", ip_dat_tu_ngay);
     v_prc.addDatetimeInputParam("@ip_dat_den_ngay", ip_dat_den_ngay);
     v_prc.addNVarcharInputParam("@ip_str_tu_khoa", ip_str_tu_khoa);
     v_prc.addNVarcharInputParam("@ip_nguon_ns", ip_nguon_ns);
     v_prc.fillDataSetByCommand(this, ip_ds);
 }
コード例 #22
0
 public void FillDataSetTheoIDHD(DS_GD_HS_LNS_LCD v_ds, decimal ip_id_hop_dong)
 {
     CStoredProc v_cstore = new CStoredProc("pr_LNS_LCD_getTheoIDHD");
     v_cstore.addDecimalInputParam("@id_hop_dong", ip_id_hop_dong);
     v_cstore.fillDataSetByCommand(this, v_ds);
 }
コード例 #23
0
 internal void FillDatasetChungChiHetHan(DataSet v_ds, DateTime dateTime)
 {
     CStoredProc v_cstore = new CStoredProc("get_chung_chi_het_han_theo_ngach");
     v_cstore.addDatetimeInputParam("@ngay",dateTime );
     v_cstore.fillDataSetByCommand(this, v_ds);
 }
コード例 #24
0
 public void FillData2DatasetGiaiNgan(
     DataSet ip_ds,
     DateTime ip_dat_tu_ngay,
     DateTime ip_dat_den_ngay,
     decimal ip_dc_id_don_vi,
     decimal ip_dc_id_loai_nhiem_vu,
     decimal ip_dc_id_cong_trinh,
     decimal ip_dc_id_du_an,
     string ip_str_tu_khoa,
     string ip_str_nguon_ns,
     decimal ip_dc_id_giai_ngan,
     string ip_str_proc)
 {
     CStoredProc v_prc = new CStoredProc(ip_str_proc);
     v_prc.addDatetimeInputParam("@ip_dat_tu_ngay", ip_dat_tu_ngay);
     v_prc.addDatetimeInputParam("@ip_dat_den_ngay", ip_dat_den_ngay);
     v_prc.addDecimalInputParam("@ip_dc_id_don_vi", ip_dc_id_don_vi);
     v_prc.addDecimalInputParam("@ip_dc_id_loai_nhiem_vu", ip_dc_id_loai_nhiem_vu);
     v_prc.addDecimalInputParam("@ip_dc_id_cong_trinh", ip_dc_id_cong_trinh);
     v_prc.addDecimalInputParam("@ip_dc_id_du_an", ip_dc_id_du_an);
     v_prc.addNVarcharInputParam("@ip_str_tu_khoa", ip_str_tu_khoa);
     v_prc.addNVarcharInputParam("@ip_nguon_ns", ip_str_nguon_ns);
     v_prc.addDecimalInputParam("@ip_dc_id_giai_ngan", ip_dc_id_giai_ngan);
     v_prc.fillDataSetByCommand(this, ip_ds);
 }
コード例 #25
0
 internal void FillDatasetWithQuery(DataSet op_ds, string ip_query)
 {
     CStoredProc v_cstore = new CStoredProc("pr_fill_ds_with_query");
     v_cstore.addNVarcharInputParam("@SQL_QUERY", ip_query);
     v_cstore.fillDataSetByCommand(this, op_ds);
 }
コード例 #26
0
 public void get_dm_uy_nhiem_chi_by_don_vi_va_ngay_thang(DS_DM_GIAI_NGAN op_ds
     , decimal ip_dc_id_don_vi
     , DateTime ip_dat_tu_ngay
     , DateTime ip_dat_den_ngay
     , string ip_nguon_ns)
 {
     CStoredProc v_sp = new CStoredProc("pr_get_dm_uy_nhiem_chi_by_don_vi_va_ngay_thang");
     v_sp.addDecimalInputParam("@ip_dc_id_don_vi", ip_dc_id_don_vi);
     v_sp.addDatetimeInputParam("@ip_dat_tu_ngay", ip_dat_tu_ngay);
     v_sp.addDatetimeInputParam("@ip_dat_den_ngay", ip_dat_den_ngay);
     v_sp.addNVarcharInputParam("@ip_nguon_ns", ip_nguon_ns);
     v_sp.fillDataSetByCommand(this, op_ds);
 }
コード例 #27
0
 public void bc_tra_cuu_giao_von_theo_du_an(DataSet ip_ds, decimal ip_dc_id_cong_trinh_du_an, string ip_str_ten_du_an, decimal ip_dc_id_don_vi, DateTime ip_dat_tu_ngay, DateTime ip_dat_den_ngay)
 {
     CStoredProc v_prc = new CStoredProc("pr_bao_cao_tra_cuu_giao_von_theo_du_an");
     v_prc.addDecimalInputParam("@ip_dc_id_du_an_cong_trinh", ip_dc_id_cong_trinh_du_an);
     v_prc.addNVarcharInputParam("@ip_str_ten_du_an", ip_str_ten_du_an);
     v_prc.addDatetimeInputParam("@ip_dat_tu_ngay", ip_dat_tu_ngay);
     v_prc.addDatetimeInputParam("@ip_dat_den_ngay", ip_dat_den_ngay);
     v_prc.addDecimalInputParam("@ip_dc_id_don_vi", ip_dc_id_don_vi);
     v_prc.fillDataSetByCommand(this, ip_ds);
 }
コード例 #28
0
 public bool check_is_having_ma_don_vi(string ip_str_ma_don_vi)
 {
     DS_DM_DON_VI v_ds_dm_don_vi = new DS_DM_DON_VI();
     CStoredProc v_cstore = new CStoredProc("pr_DM_DON_VI_check_ma_don_vi");
     v_cstore.addNVarcharInputParam("@ip_str_ma_don_vi", ip_str_ma_don_vi);
     v_cstore.fillDataSetByCommand(this, v_ds_dm_don_vi);
     if (v_ds_dm_don_vi.DM_DON_VI.Rows.Count == 0)
         return false;
     return true;
 }
コード例 #29
0
 public void FillDataset_chi_tiet_dm(DS_RPT_BC_CHI_TIET_DM ip_v_ds, DateTime ip_v_dt_tu_ngay, DateTime ip_v_dt_den_ngay, decimal ip_v_id_loai_dm, decimal ip_v_id_trung_tam)
 {
     CStoredProc v_stored_proc = new CStoredProc("pr_V_BC_CHI_TIET_DM_search");
     v_stored_proc.addDatetimeInputParam("@TU_NGAY", ip_v_dt_tu_ngay);
     v_stored_proc.addDatetimeInputParam("@DEN_NGAY", ip_v_dt_den_ngay);
     v_stored_proc.addDecimalInputParam("@ID_LOAI_DINH_MUC", ip_v_id_loai_dm);
     v_stored_proc.addDecimalInputParam("@ID_TRUNG_TAM", ip_v_id_trung_tam);
     v_stored_proc.fillDataSetByCommand(this, ip_v_ds);
 }
コード例 #30
0
        /// <summary>
        /// 
        /// </summary>
        /// <param name="op_ds_don_vi"></param>
        /// <param name="ip_dc_id_loai_don_vi"></param>
        /// <param name="ip_dc_id_don_vi"></param>
        /// <param name="ip_dc_id_don_vi_cap_tren1"></param>
        /// <param name="ip_dc_id_don_vi_cap_tren2"></param>
        /// <param name="ip_str_user_name"></param>
        public void FillDataset(
            WebDS.DS_DM_DON_VI op_ds_don_vi
            , decimal ip_dc_id_loai_don_vi
            
            , decimal ip_dc_id_don_vi_cap_tren1
            , decimal ip_dc_id_don_vi_cap_tren2
            , string ip_str_user_name)
        {
            CStoredProc cstored = new CStoredProc("pr_DM_DON_VI_Select_by_user_name");
            cstored.addNVarcharInputParam("@ip_str_user_name", ip_str_user_name);
            cstored.addDecimalInputParam("@ip_dc_loai_don_vi", ip_dc_id_loai_don_vi);

            cstored.addDecimalInputParam("@ip_dc_id_dv_cap_tren1", ip_dc_id_don_vi_cap_tren1);
            cstored.addDecimalInputParam("@ip_dc_id_dv_cap_tren2", ip_dc_id_don_vi_cap_tren2);
            cstored.fillDataSetByCommand(this, op_ds_don_vi);
        }