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); }
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); }
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); }
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]; }
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); }
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); }
public decimal get_id_trang_thai_lao_dong(decimal ip_dc_id_nhan_vien) { CStoredProc v_sp = new CStoredProc("pr_get_id_trang_thai_lao_dong_hien_tai"); v_sp.addDecimalInputParam("@ip_dc_id_nhan_vien", ip_dc_id_nhan_vien); SqlParameter v_para = v_sp.addDecimalOutputParam("@op_dc_id_trang_thai_hien_tai", 0); v_sp.ExecuteCommand(this); return CIPConvert.ToDecimal(v_para.Value.ToString()); }
public void FillDatasetGiaoKHByIdDonVi(DS_V_DM_QUYET_DINH_KH ip_ds, decimal ip_dc_id_don_vi, DateTime ip_dat_tu_ngay, DateTime ip_dat_den_ngay, string ip_str_filter) { CStoredProc v_prc = new CStoredProc("pr_F190_danh_sach_quyet_dinh_giao_kh"); v_prc.addDecimalInputParam("@ip_dc_id_don_vi", ip_dc_id_don_vi); 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_filter); v_prc.fillDataSetByCommand(this, ip_ds); }
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); }
public void get_don_gia_dinh_muc_and_so_luong_thong_ke(decimal ip_id_trung_tam, decimal ip_id_loai_dinh_muc , DateTime ip_from_date, DateTime ip_to_date , ref decimal op_don_gia_dinh_muc, ref decimal op_so_luong_thong_ke) { CStoredProc v_proc = new CStoredProc("pr_get_don_gia_dinh_muc_and_so_luong_thong_ke"); v_proc.addDecimalInputParam("@ID_TRUNG_TAM", ip_id_trung_tam); v_proc.addDecimalInputParam("@ID_LOAI_DINH_MUC", ip_id_loai_dinh_muc); v_proc.addDatetimeInputParam("@FROM_DATE", ip_from_date); v_proc.addDatetimeInputParam("@TO_DATE", ip_to_date); SqlParameter v_obj_don_gia_dinh_muc = v_proc.addDecimalOutputParam("@DON_GIA_DINH_MUC", -1); SqlParameter v_obj_so_luong_thong_ke = v_proc.addDecimalOutputParam("@SO_LUONG_THONG_KE", -1); v_proc.ExecuteCommand(this); if(v_obj_don_gia_dinh_muc.Value.ToString() != "0" && v_obj_don_gia_dinh_muc.Value.ToString() != "") { op_don_gia_dinh_muc = CIPConvert.ToDecimal(v_obj_don_gia_dinh_muc.Value); } if(v_obj_so_luong_thong_ke.Value.ToString() != "0" && v_obj_so_luong_thong_ke.Value.ToString() != "") { op_so_luong_thong_ke = CIPConvert.ToDecimal(v_obj_so_luong_thong_ke.Value); } }
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); }
public void FillDataset_by_thang_nam_id_nhan_vien( DS_V_F419_BAO_CAO_LCD_NHAN_VIEN_THEO_THANG op_ds_bc_lcd_nv_theo_thang, decimal ip_dc_thang, decimal ip_dc_nam, decimal ip_dc_id_nhan_vien, decimal ip_co_xem_lich_su_giao_dich) { CStoredProc v_cstore = new CStoredProc("pr_f419_bao_cao_lcd_1_nhan_vien_theo_thang_nam"); v_cstore.addDecimalInputParam("@ip_dc_thang", ip_dc_thang); v_cstore.addDecimalInputParam("@ip_dc_nam", ip_dc_nam); v_cstore.addDecimalInputParam("@ip_dc_id_nhan_vien", ip_dc_id_nhan_vien); v_cstore.addDecimalInputParam("@ip_co_xem_lich_su_giao_dich", ip_co_xem_lich_su_giao_dich); v_cstore.fillDataSetByCommand(this, op_ds_bc_lcd_nv_theo_thang); }
public void get_co_so_dinh_muc_ap_dung_tu_ngay(decimal ip_id_trung_tam, decimal ip_id_loai_dinh_muc , DateTime ip_from_date, DateTime ip_to_date , ref decimal op_id_co_so_dinh_muc, ref DateTime op_ap_dung_tu_ngay , ref string op_ten_co_so_dinh_muc) { CStoredProc v_proc = new CStoredProc("pr_get_co_so_dinh_muc_ap_dung_tu_ngay"); v_proc.addDecimalInputParam("@ID_TRUNG_TAM", ip_id_trung_tam); v_proc.addDecimalInputParam("@ID_LOAI_DINH_MUC", ip_id_loai_dinh_muc); v_proc.addDatetimeInputParam("@FROM_DATE", ip_from_date); v_proc.addDatetimeInputParam("@TO_DATE", ip_to_date); SqlParameter v_obj_id_co_so_dinh_muc = v_proc.addDecimalOutputParam("@ID_CO_SO_DINH_MUC", -1); SqlParameter v_obj_ten_co_so_dinh_muc = v_proc.addNVarcharOutputParam("@TEN_CO_SO_DINH_MUC", -1); SqlParameter v_obj_ap_dung_tu_ngay = v_proc.addDatetimeOutputParam("@AP_DUNG_TU_NGAY", -1); v_proc.ExecuteCommand(this); op_id_co_so_dinh_muc = CIPConvert.ToDecimal(v_obj_id_co_so_dinh_muc.Value); string temp = v_obj_ap_dung_tu_ngay.Value.ToString(); if(temp != "") { temp = temp.Substring(0, temp.IndexOf(" ")); op_ap_dung_tu_ngay = CIPConvert.ToDatetime(temp); } if(v_obj_ten_co_so_dinh_muc.Value.ToString() != "") { op_ten_co_so_dinh_muc = CIPConvert.ToStr(v_obj_ten_co_so_dinh_muc.Value); } }
public void get_grid_uy_nhiem_chi_dataset(DS_GRID_GIAI_NGAN op_ds , decimal ip_dc_id_don_vi , decimal ip_dc_id_dm_uy_nhiem_chi) { CStoredProc v_sp = new CStoredProc("pr_get_grid_uy_nhiem_chi"); v_sp.addDecimalInputParam("@ip_dc_id_don_vi", ip_dc_id_don_vi); v_sp.addDecimalInputParam("@ip_dc_id_dm_uy_nhiem_chi", ip_dc_id_dm_uy_nhiem_chi); v_sp.fillDataSetByCommand(this, op_ds); }
public void get_grid_giay_rut_du_toan(DataSet op_ds , decimal ip_dc_id_don_vi , decimal ip_dc_id_dm_uy_nhiem_chi , decimal ip_dc_id_user , string ip_str_is_nguon_ns) { CStoredProc v_sp = new CStoredProc("pr_F305_giay_rut_du_toan_ngan_sach"); v_sp.addDecimalInputParam("@ip_dc_id_don_vi", ip_dc_id_don_vi); v_sp.addDecimalInputParam("@ip_dc_id_dm_uy_nhiem_chi", ip_dc_id_dm_uy_nhiem_chi); v_sp.addDecimalInputParam("@ip_dc_id_user", ip_dc_id_user); v_sp.addNVarcharInputParam("@ip_str_is_nguon_ns", ip_str_is_nguon_ns); v_sp.fillDataSetByCommand(this, op_ds); }
public void get_grid_giai_ngan(DS_GRID_GIAI_NGAN op_ds , decimal ip_dc_id_don_vi , decimal ip_dc_id_dm_uy_nhiem_chi , decimal ip_dc_id_user , string ip_str_is_nguon_ns) { CStoredProc v_sp = new CStoredProc("pr_F304_nhap_giai_ngan_theo_unc"); v_sp.addDecimalInputParam("@ip_dc_id_don_vi", ip_dc_id_don_vi); v_sp.addDecimalInputParam("@ip_dc_id_dm_uy_nhiem_chi", ip_dc_id_dm_uy_nhiem_chi); v_sp.addDecimalInputParam("@ip_dc_id_user", ip_dc_id_user); v_sp.addNVarcharInputParam("@ip_str_is_nguon_ns", ip_str_is_nguon_ns); v_sp.fillDataSetByCommand(this, op_ds); }
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); }
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); }
public bool deleteAllDataOfUNC(decimal ip_dc_id_unc) { CStoredProc v_sp = new CStoredProc("pr_DM_GIAI_NGAN_deleteAllDataOfUNC"); v_sp.addDecimalInputParam("@ip_dc_id_unc", ip_dc_id_unc); try { v_sp.ExecuteCommand(this); return true; } catch (Exception) { return false; } return false; }
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); }
/// <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); }
public void thay_doi_trang_thai_lao_dong(decimal ip_dc_id_nhan_vien , decimal ip_dc_id_trang_thai_chuyen , DateTime ip_dat_ngay_lap , string ip_str_nguoi_lap) { CStoredProc v_sp = new CStoredProc("pr_thay_doi_trang_thai_lao_dong"); v_sp.addDecimalInputParam("@ip_dc_id_nhan_vien", ip_dc_id_nhan_vien); v_sp.addDecimalInputParam("@ip_dc_id_trang_thai_chuyen", ip_dc_id_trang_thai_chuyen); v_sp.addDatetimeInputParam("@ip_dat_ngay_lap", ip_dat_ngay_lap); v_sp.addNVarcharInputParam("@ip_str_nguoi_lap", ip_str_nguoi_lap); v_sp.ExecuteCommand(this); }
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); }
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]; }
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); }
public void KetThucLuongNangSuatNhanVien(decimal ip_dc_id_nhan_vien, DateTime ip_dat_ngay_ket_thuc) { CStoredProc v_cs = new CStoredProc("pr_HD_cap_nhat_ngay_ket_thuc_luong_nang_suat"); v_cs.addDecimalInputParam("@ip_dc_id_nhan_vien", ip_dc_id_nhan_vien); v_cs.addDatetimeInputParam("@ip_dat_ngay_ket_thuc", ip_dat_ngay_ket_thuc); v_cs.ExecuteCommand(this); }
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); }
public bool KiemTraThoiGianHeSoLNSHopLeForInsert(decimal ip_dc_id_nhan_vien, DateTime ip_dat_tu_ngay, DateTime ip_dat_den_ngay) { CStoredProc v_cstore = new CStoredProc("pr_HD_du_lieu_hs_lns_hop_le_CheckInsert"); v_cstore.addDecimalInputParam("@ip_dc_id_nhan_vien", ip_dc_id_nhan_vien); v_cstore.addDatetimeInputParam("@ip_dat_tu_ngay", ip_dat_tu_ngay); v_cstore.addDatetimeInputParam("@ip_dat_den_ngay", ip_dat_den_ngay); SqlParameter v_yn = v_cstore.addNVarcharOutputParam("@op_str_hop_le_yn", ""); v_cstore.ExecuteCommand(this); return v_yn.Value.ToString() == "Y" ? true : false; }
public void update_cau_hoi_cu() { CStoredProc v_cstore = new CStoredProc("pr_GD_CAU_HOI_HOC_VIEN_Update_cau_hoi_cu"); v_cstore.addDecimalInputParam("@ID", this.dcID); v_cstore.addDecimalInputParam("@ID_TRANG_THAI", this.dcID_TRANG_THAI); v_cstore.addDecimalInputParam("@ID_DANH_GIA", this.dcID_DANH_GIA); v_cstore.addNVarcharInputParam("@GHI_CHU_Y_KIEN_KHAC", this.strGHI_CHU_Y_KIEN_KHAC); v_cstore.ExecuteCommand(this); }
public bool KiemTraThoiGianVoiLuongCungHopLeForUpdate(decimal ip_dc_id_gd_he_so_lns, DateTime ip_dat_tu_ngay, DateTime ip_dat_den_ngay) { CStoredProc v_cstore = new CStoredProc("pr_LNS_kiem_tra_thoi_gian_hop_le_voi_luong_cung_ForUpdate"); v_cstore.addDecimalInputParam("@ip_dc_id_gd_he_so_lns", ip_dc_id_gd_he_so_lns); v_cstore.addDatetimeInputParam("@ip_dat_tu_ngay", ip_dat_tu_ngay); v_cstore.addDatetimeInputParam("@ip_dat_den_ngay", ip_dat_den_ngay); SqlParameter v_yn = v_cstore.addNVarcharOutputParam("@op_str_hop_le_yn", ""); v_cstore.ExecuteCommand(this); return v_yn.Value.ToString() == "Y" ? true : false; }