コード例 #1
0
 public US_KET_QUA_TONG_HOP(decimal i_dbID)
 {
     pm_objDS = new DS_KET_QUA_TONG_HOP();
     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]);
 }
コード例 #2
0
        public US_KET_QUA_TONG_HOP(decimal i_dbID)
        {
            pm_objDS        = new DS_KET_QUA_TONG_HOP();
            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]);
        }
コード例 #3
0
        public void FillDatasetByID_AUCTION(decimal i_id_auction , DS_KET_QUA_TONG_HOP i_ds, 
										 ref decimal i_dc_so_luong_co_phan_nguoi_nuoc_ngoai_duoc_mua
										,ref decimal i_dc_menh_gia_co_phan
										,ref decimal i_dc_gia_khoi_diem
										,ref decimal i_dc_tong_so_nha_dau_tu_phap_nhan
										,ref decimal i_dc_tong_so_nha_dau_tu_ca_nhan
										,ref decimal i_dc_khoi_luong_dat_cao_nhat
										,ref decimal i_dc_khoi_luong_dat_thap_nhat
										,ref decimal i_dc_gia_dat_cao_nhat
										,ref decimal i_dc_gia_dat_thap_nhat
										,ref decimal i_dc_so_co_phan_trung_cua_nguoi_nuoc_ngoai)
        {
            CStoredProc v_pro = new CStoredProc ( "pr_get_ket_qua_tong_hop" ) ;
            v_pro.addDecimalInputParam ( "@id_auction" , i_id_auction ) ;
            SqlParameter v_obj_para_sl_co_phan_nuoc_ngoai
            = v_pro.addDecimalOutputParam( "@SoLuongCoPhanNguoiNuocNgoaiDuocMua", 0) ;
            SqlParameter v_obj_para_menh_gia_co_phan
            = v_pro.addDecimalOutputParam( "@MenhGiaCoPhan", 0);
            SqlParameter v_obj_para_gia_khoi_diem
            = v_pro.addDecimalOutputParam("@GiaKhoiDiem", 0);
            SqlParameter v_obj_para_tong_so_nha_dau_tu_phap_nhan
            = v_pro.addDecimalOutputParam("@TongSoNhaDauTuPhapNhan", 0);
            SqlParameter v_obj_para_tong_so_nha_dau_tu_ca_nhan
            = v_pro.addDecimalOutputParam("@TongSoNhaDauTuCaNhan", 0);
            SqlParameter v_obj_para_khoi_luong_dat_cao_nhat
            = v_pro.addDecimalOutputParam("@KhoiLuongDatCaoNhat", 0);
            SqlParameter v_obj_para_khoi_luong_dat_thap_nhat
            = v_pro.addDecimalOutputParam("@KhoiLuongDatThapNhat", 0);
            SqlParameter v_obj_para_gia_dat_cao_nhat
            = v_pro.addDecimalOutputParam("@GiaDatCaoNhat",0);
            SqlParameter v_obj_para_gia_dat_thap_nhat
            = v_pro.addDecimalOutputParam("@GiaDatThapNhat",0);
            SqlParameter v_obj_para_so_co_phan_trung_cua_nguoi_nuoc_ngoai
            = v_pro.addDecimalOutputParam("@SoCoPhanTrungCuaNguoiNuocNgoai",0);

            v_pro.ExecuteCommand (this) ;
            v_pro.fillDataSetByCommand(this, i_ds);
            i_dc_so_luong_co_phan_nguoi_nuoc_ngoai_duoc_mua
            = CIPConvert.ToDecimal(v_obj_para_sl_co_phan_nuoc_ngoai.Value);
            i_dc_menh_gia_co_phan = CIPConvert.ToDecimal(v_obj_para_menh_gia_co_phan.Value);
            i_dc_gia_khoi_diem = CIPConvert.ToDecimal(v_obj_para_gia_khoi_diem.Value);
            i_dc_tong_so_nha_dau_tu_phap_nhan =
            CIPConvert.ToDecimal(v_obj_para_tong_so_nha_dau_tu_phap_nhan.Value);
            i_dc_tong_so_nha_dau_tu_ca_nhan =
            CIPConvert.ToDecimal(v_obj_para_tong_so_nha_dau_tu_ca_nhan.Value );
            i_dc_khoi_luong_dat_cao_nhat =
            CIPConvert.ToDecimal(v_obj_para_khoi_luong_dat_cao_nhat.Value );
            i_dc_khoi_luong_dat_thap_nhat =
            CIPConvert.ToDecimal(v_obj_para_khoi_luong_dat_thap_nhat.Value );
            i_dc_gia_dat_cao_nhat = CIPConvert.ToDecimal(v_obj_para_gia_dat_cao_nhat.Value );
            i_dc_gia_dat_thap_nhat = CIPConvert.ToDecimal(v_obj_para_gia_dat_thap_nhat.Value );
            i_dc_so_co_phan_trung_cua_nguoi_nuoc_ngoai
            = CIPConvert.ToDecimal(v_obj_para_so_co_phan_trung_cua_nguoi_nuoc_ngoai.Value );
        }
コード例 #4
0
 public US_KET_QUA_TONG_HOP()
 {
     pm_objDS = new DS_KET_QUA_TONG_HOP();
     pm_strTableName = c_TableName;
     pm_objDR = pm_objDS.Tables[pm_strTableName].NewRow();
 }
コード例 #5
0
 public US_KET_QUA_TONG_HOP()
 {
     pm_objDS        = new DS_KET_QUA_TONG_HOP();
     pm_strTableName = c_TableName;
     pm_objDR        = pm_objDS.Tables[pm_strTableName].NewRow();
 }