public US_GD_CAU_HOI_HOC_VIEN(decimal i_dbID)
 {
     pm_objDS = new DS_GD_CAU_HOI_HOC_VIEN();
     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]);
 }
 public US_V_RPT_420_BC_TAI_CHINH_THEO_LOP_MON_HS(decimal i_dbID)
 {
     pm_objDS = new DS_V_RPT_420_BC_TAI_CHINH_THEO_LOP_MON_HS();
     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]);
 }
 public US_V_F320_THONG_TIN_CHI_TIET_DANH_SACH_HOP_DONG_DA_KY_THEO_THOI_GIAN(decimal i_dbID)
 {
     pm_objDS = new DS_V_F320_THONG_TIN_CHI_TIET_DANH_SACH_HOP_DONG_DA_KY_THEO_THOI_GIAN();
     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]);
 }
 public US_V_F460_DANH_SACH_NHAN_VIEN_DANG_HOAT_DONG_O_CONG_TY(decimal i_dbID)
 {
     pm_objDS = new DS_V_F460_DANH_SACH_NHAN_VIEN_DANG_HOAT_DONG_O_CONG_TY();
     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]);
 }
        public US_CM_DM_LOAI_TD(string i_strMaLoaiTD)
        {
            pm_objDS = new DS_CM_DM_LOAI_TD();
            pm_strTableName = c_TableName;

            System.Data.SqlClient.SqlCommand v_cmd = default(System.Data.SqlClient.SqlCommand);
            IMakeSelectCmd v_MakeSelCommand = default(IMakeSelectCmd);
            v_MakeSelCommand = new CMakeAndSelectCmd(pm_objDS, c_TableName);
            v_MakeSelCommand.AddCondition("MA_LOAI", i_strMaLoaiTD, eKieuDuLieu.KieuString, eKieuSoSanh.Bang);
            v_cmd = v_MakeSelCommand.getSelectCmd();

            this.FillDatasetByCommand(pm_objDS, v_cmd);
            pm_objDR = getRowClone(pm_objDS.Tables[pm_strTableName].Rows[0]);
        }
 public bool isHaving_thong_tin_don_vi(decimal i_dbID_DON_VI)
 {
     pm_objDS = new DS_DM_THONG_TIN_DON_VI();
     pm_strTableName = c_TableName;
     IMakeSelectCmd v_objMkCmd = new CMakeAndSelectCmd(pm_objDS, c_TableName);
     v_objMkCmd.AddCondition("ID_DON_VI", i_dbID_DON_VI, eKieuDuLieu.KieuNumber, eKieuSoSanh.Bang);
     SqlCommand v_cmdSQL;
     v_cmdSQL = v_objMkCmd.getSelectCmd();
     this.FillDatasetByCommand(pm_objDS, v_cmdSQL);
     return (pm_objDS.Tables[0].Rows.Count != 0);
 }
 public void InitByID_DON_VI(decimal i_dbID_DON_VI)
 {
     pm_objDS = new DS_DM_THONG_TIN_DON_VI();
     pm_strTableName = c_TableName;
     IMakeSelectCmd v_objMkCmd = new CMakeAndSelectCmd(pm_objDS, c_TableName);
     v_objMkCmd.AddCondition("ID_DON_VI", i_dbID_DON_VI, 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]);
 }
 public bool InitUSWithIDIsOK(decimal ip_dc_id_don_vi)
 {
     pm_objDS = new DS_DM_DON_VI();
     pm_strTableName = c_TableName;
     IMakeSelectCmd v_objMkCmd = new CMakeAndSelectCmd(pm_objDS, c_TableName);
     v_objMkCmd.AddCondition("ID", ip_dc_id_don_vi, eKieuDuLieu.KieuNumber, eKieuSoSanh.Bang);
     SqlCommand v_cmdSQL;
     v_cmdSQL = v_objMkCmd.getSelectCmd();
     this.FillDatasetByCommand(pm_objDS, v_cmdSQL);
     if (pm_objDS.Tables[pm_strTableName].Rows.Count == 0) return false ;
     pm_objDR = getRowClone(pm_objDS.Tables[pm_strTableName].Rows[0]);
     return true;
 }
        public void FillDataset(
            decimal ip_dc_don_vi_chu_quan
            , decimal ip_dc_trang_thai
            , DS_V_DM_OTO op_ds_v_oto)
        {
            IMakeSelectCmd v_obj_mak_cmd = new CMakeAndSelectCmd(op_ds_v_oto, this.pm_strTableName);

            v_obj_mak_cmd.AddCondition(
                V_DM_OTO.ID_DON_VI_SU_DUNG
                , ip_dc_don_vi_chu_quan
                , eKieuDuLieu.KieuNumber
                , eKieuSoSanh.Bang);
            v_obj_mak_cmd.AddCondition(
                    V_DM_OTO.ID_TRANG_THAI
                    , ip_dc_trang_thai
                    , eKieuDuLieu.KieuNumber
                    , eKieuSoSanh.Bang);
            SqlCommand v_obj_sql_cmd = v_obj_mak_cmd.getSelectCmd();
            v_obj_sql_cmd.CommandText += " ORDER BY " + V_DM_OTO.ID_LOAI_TAI_SAN;

            this.FillDatasetByCommand(op_ds_v_oto, v_obj_sql_cmd);
        }
 public void FillDatasetByGroupUserID(decimal i_dc_group_user_id
     , DS_HT_PHAN_QUYEN_CHO_NHOM i_ds)
 {
     IMakeSelectCmd v_obj_mak_cmd = new CMakeAndSelectCmd(i_ds, i_ds.HT_PHAN_QUYEN_CHO_NHOM.TableName);
     v_obj_mak_cmd.AddCondition(HT_PHAN_QUYEN_CHO_NHOM.ID_USER_GROUP, i_dc_group_user_id, eKieuDuLieu.KieuNumber, eKieuSoSanh.Bang);
     this.FillDatasetByCommand(i_ds, v_obj_mak_cmd.getSelectCmd());
 }
 public void FillDatasetByUserID(decimal i_dc_user_id
     , DS_HT_QUYEN_USER i_ds)
 {
     IMakeSelectCmd v_obj_mak_cmd = new CMakeAndSelectCmd(i_ds, i_ds.HT_QUYEN_USER.TableName);
     v_obj_mak_cmd.AddCondition("ID_USER", i_dc_user_id, eKieuDuLieu.KieuNumber, eKieuSoSanh.Bang);
     this.FillDatasetByCommand(i_ds, v_obj_mak_cmd.getSelectCmd());
 }
 public string get_station_id_by_user(decimal i_dc_user_id)
 {
     DS_DM_NGUOI_DUNG_STATION v_ds = new DS_DM_NGUOI_DUNG_STATION();
     IMakeSelectCmd v_obj_mak_cmd = new CMakeAndSelectCmd(v_ds, v_ds.DM_NGUOI_DUNG_STATION.TableName);
     v_obj_mak_cmd.AddCondition(DM_NGUOI_DUNG_STATION.ID_NGUOI_DUNG, i_dc_user_id, eKieuDuLieu.KieuNumber, eKieuSoSanh.Bang);
     this.FillDatasetByCommand(v_ds, v_obj_mak_cmd.getSelectCmd());
     if (v_ds.DM_NGUOI_DUNG_STATION.Rows.Count > 0)
         return CIPConvert.ToStr(v_ds.DM_NGUOI_DUNG_STATION[0][DM_NGUOI_DUNG_STATION.STATION_CODE]);
     else return "";
 }