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);
 }
Esempio n. 2
0
 public void FillDatasetSearch(WebDS.DS_DM_OTO m_ds_dm_oto, string v_str_tu_khoa, string v_str_query)
 {
     CStoredProc cstored = new CStoredProc("pr_DM_OTO_get_search");
     cstored.addNVarcharInputParam("@TU_KHOA", v_str_tu_khoa);
     cstored.addNVarcharInputParam("@QUERY",v_str_query);
     cstored.fillDataSetByCommand(this, m_ds_dm_oto);
 }
        /// <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);
        }
Esempio n. 4
0
 public void FillDatasetBySearch(WebDS.DS_DM_OTO m_ds_dm_oto, 
     string v_str_tu_khoa,
     decimal v_dc_id_trang_thai,
     decimal v_dc_id_dv_bo_tinh,
     decimal v_dc_id_dv_quan_ly,
     decimal v_dc_id_dv_su_dung)
 {
     CStoredProc cstored = new CStoredProc("pr_DM_OTO_Search");
     cstored.addNVarcharInputParam("@TU_KHOA", v_str_tu_khoa);
     cstored.addDecimalInputParam("@ID_TRANG_THAI", v_dc_id_trang_thai);
     cstored.addDecimalInputParam("@ID_DV_SU_DUNG", v_dc_id_dv_su_dung);
     cstored.addDecimalInputParam("@ID_DV_QUAN_LY",v_dc_id_dv_quan_ly);
     cstored.addDecimalInputParam("@ID_DV_BO_TINH", v_dc_id_dv_bo_tinh);
     cstored.fillDataSetByCommand(this, m_ds_dm_oto);
 }