Example #1
0
        public void load_ds_dich_vu_by_loai(decimal ip_dc_id_loai_dv, DS_DM_LOAI_YEU_CAU op_ds)
        {
            CStoredProc v_cstore = new CStoredProc("pr_DM_LOAI_YEU_CAU_load_ds_dich_vu_by_loai");

            v_cstore.addDecimalInputParam("@ID_LOAI_DICH_VU", ip_dc_id_loai_dv);
            v_cstore.fillDataSetByCommand(this, op_ds);
        }
Example #2
0
        private void load_data_2_cbo_dich_vu()
        {
            US_DM_LOAI_YEU_CAU v_us_dich_vu         = new US_DM_LOAI_YEU_CAU();
            DS_DM_LOAI_YEU_CAU v_ds_dich_vu         = new DS_DM_LOAI_YEU_CAU();
            decimal            v_dc_id_loai_dich_vu = CIPConvert.ToDecimal(m_cbo_loai_dich_vu.SelectedValue);

            v_us_dich_vu.load_ds_dich_vu_by_loai(v_dc_id_loai_dich_vu, v_ds_dich_vu);

            DataRow v_dr = v_ds_dich_vu.DM_LOAI_YEU_CAU.NewDM_LOAI_YEU_CAURow();

            v_dr[DM_LOAI_YEU_CAU.ID] = 0;
            if (v_ds_dich_vu.DM_LOAI_YEU_CAU.Rows.Count == 0)
            {
                v_dr[DM_LOAI_YEU_CAU.TEN_YEU_CAU] = "- Không có dịch vụ con -";
                m_cbo_dich_vu.Enabled             = false;
            }
            else
            {
                v_dr[DM_LOAI_YEU_CAU.TEN_YEU_CAU] = "- Chọn một dịch vụ -";
                m_cbo_dich_vu.Enabled             = true;
            }
            v_ds_dich_vu.EnforceConstraints = false;
            v_ds_dich_vu.DM_LOAI_YEU_CAU.Rows.InsertAt(v_dr, 0);

            m_cbo_dich_vu.DataSource    = v_ds_dich_vu.DM_LOAI_YEU_CAU;
            m_cbo_dich_vu.DisplayMember = DM_LOAI_YEU_CAU.TEN_YEU_CAU;
            m_cbo_dich_vu.ValueMember   = DM_LOAI_YEU_CAU.ID;
        }
Example #3
0
 public US_DM_LOAI_YEU_CAU(decimal i_dbID)
 {
     pm_objDS = new DS_DM_LOAI_YEU_CAU();
     pm_strTableName = c_TableName;
     IMakeSelectCmd v_objMkCmd = new CMakeAndSelectCmd(pm_objDS, c_TableName);
     v_objMkCmd.AddCondition("ID", i_dbID, eKieuDuLieu.KieuNumber, eKieuSoSanh.Bang);
     SqlCommand v_cmdSQL;
     v_cmdSQL = v_objMkCmd.getSelectCmd();
     this.FillDatasetByCommand(pm_objDS, v_cmdSQL);
     pm_objDR = getRowClone(pm_objDS.Tables[pm_strTableName].Rows[0]);
 }
Example #4
0
        public US_DM_LOAI_YEU_CAU(decimal i_dbID)
        {
            pm_objDS        = new DS_DM_LOAI_YEU_CAU();
            pm_strTableName = c_TableName;
            IMakeSelectCmd v_objMkCmd = new CMakeAndSelectCmd(pm_objDS, c_TableName);

            v_objMkCmd.AddCondition("ID", i_dbID, eKieuDuLieu.KieuNumber, eKieuSoSanh.Bang);
            SqlCommand v_cmdSQL;

            v_cmdSQL = v_objMkCmd.getSelectCmd();
            this.FillDatasetByCommand(pm_objDS, v_cmdSQL);
            pm_objDR = getRowClone(pm_objDS.Tables[pm_strTableName].Rows[0]);
        }
Example #5
0
        private void load_data_2_cbo_loai_dich_vu()
        {
            US_DM_LOAI_YEU_CAU v_us_loai_dich_vu = new US_DM_LOAI_YEU_CAU();
            DS_DM_LOAI_YEU_CAU v_ds_loai_dich_vu = new DS_DM_LOAI_YEU_CAU();

            v_us_loai_dich_vu.load_ds_loai_dich_vu(v_ds_loai_dich_vu);

            DataRow v_dr = v_ds_loai_dich_vu.DM_LOAI_YEU_CAU.NewDM_LOAI_YEU_CAURow();

            v_dr[DM_LOAI_YEU_CAU.ID]             = 0;
            v_dr[DM_LOAI_YEU_CAU.TEN_YEU_CAU]    = "- Chọn một loại dịch vụ -";
            v_ds_loai_dich_vu.EnforceConstraints = false;
            v_ds_loai_dich_vu.DM_LOAI_YEU_CAU.Rows.InsertAt(v_dr, 0);

            m_cbo_loai_dich_vu.DataSource    = v_ds_loai_dich_vu.DM_LOAI_YEU_CAU;
            m_cbo_loai_dich_vu.DisplayMember = DM_LOAI_YEU_CAU.TEN_YEU_CAU;
            m_cbo_loai_dich_vu.ValueMember   = DM_LOAI_YEU_CAU.ID;

            m_e_cbo_trang_thai_loai_dich_vu = e_cbo_state.DA_FILL_DATA_XONG;
        }
Example #6
0
 public US_DM_LOAI_YEU_CAU()
 {
     pm_objDS = new DS_DM_LOAI_YEU_CAU();
     pm_strTableName = c_TableName;
     pm_objDR = pm_objDS.Tables[pm_strTableName].NewRow();
 }
Example #7
0
        private void load_dât_2_loai_yeu_cau()
        {
            US_DM_LOAI_YEU_CAU v_us_loai_yeu_cau = new US_DM_LOAI_YEU_CAU();
            DS_DM_LOAI_YEU_CAU v_ds_loai_yeu_cau = new DS_DM_LOAI_YEU_CAU();
            v_us_loai_yeu_cau.load_ds_loai_dich_vu(v_ds_loai_yeu_cau);

            DataRow v_dr = v_ds_loai_yeu_cau.DM_LOAI_YEU_CAU.NewDM_LOAI_YEU_CAURow();
            v_dr[DM_LOAI_YEU_CAU.ID] = 0;
            v_dr[DM_LOAI_YEU_CAU.TEN_YEU_CAU] = "-- Tất cả --";
            v_ds_loai_yeu_cau.EnforceConstraints = false;
            v_ds_loai_yeu_cau.DM_LOAI_YEU_CAU.Rows.InsertAt(v_dr, 0);

            m_cbo_loai_yeu_cau.DataSource = v_ds_loai_yeu_cau.DM_LOAI_YEU_CAU;
            m_cbo_loai_yeu_cau.DisplayMember = DM_LOAI_YEU_CAU.TEN_YEU_CAU;
            m_cbo_loai_yeu_cau.ValueMember = DM_LOAI_YEU_CAU.ID;
        }
Example #8
0
        public void load_ds_loai_dich_vu(DS_DM_LOAI_YEU_CAU op_ds)
        {
            CStoredProc v_cstore = new CStoredProc("pr_DM_LOAI_YEU_CAU_load_ds_loai_dich_vu");

            v_cstore.fillDataSetByCommand(this, op_ds);
        }
Example #9
0
 public US_DM_LOAI_YEU_CAU()
 {
     pm_objDS        = new DS_DM_LOAI_YEU_CAU();
     pm_strTableName = c_TableName;
     pm_objDR        = pm_objDS.Tables[pm_strTableName].NewRow();
 }
 public void load_ds_loai_dich_vu(DS_DM_LOAI_YEU_CAU op_ds)
 {
     CStoredProc v_cstore = new CStoredProc("pr_DM_LOAI_YEU_CAU_load_ds_loai_dich_vu");
     v_cstore.fillDataSetByCommand(this, op_ds);
 }
 public void load_ds_dich_vu_by_loai(decimal ip_dc_id_loai_dv, DS_DM_LOAI_YEU_CAU op_ds)
 {
     CStoredProc v_cstore = new CStoredProc("pr_DM_LOAI_YEU_CAU_load_ds_dich_vu_by_loai");
     v_cstore.addDecimalInputParam("@ID_LOAI_DICH_VU", ip_dc_id_loai_dv);
     v_cstore.fillDataSetByCommand(this, op_ds);
 }