public void load_tong_so_hs_dang_hoc(DateTime ip_dat_tu_ngay, DateTime ip_dat_den_ngay, ref decimal ip_dc_tong_so_hs_dang_hoc) { CStoredProc v_pr = new CStoredProc("pr_load_tong_so_hs_dang_hoc"); v_pr.addDatetimeInputParam("@ip_dat_tu_ngay", ip_dat_tu_ngay); v_pr.addDatetimeInputParam("@ip_dat_den_ngay", ip_dat_den_ngay); SqlParameter v_pa = v_pr.addDecimalOutputParam("@op_dc_tong_so_hs_dang_hoc", ip_dc_tong_so_hs_dang_hoc); v_pr.ExecuteCommand(this); ip_dc_tong_so_hs_dang_hoc = CIPConvert.ToDecimal(v_pa.Value); }
public bool check_diem_danh_hs( decimal ip_dc_id_hoc_sinh , decimal ip_dc_id_lop_mon , decimal ip_dc_id_nguoi_diem_danh , DateTime ip_dat_tai_ngay , ref decimal op_dc_id_gd_diem_danh) { DS_GD_DIEM_DANH op_ds_diem_danh = new DS_GD_DIEM_DANH(); CStoredProc v_obj_spr = new CStoredProc("pr_kiem_tra_hoc_sinh_diem_danh"); v_obj_spr.addDecimalInputParam("@ip_dc_id_hoc_sinh", ip_dc_id_hoc_sinh); v_obj_spr.addDecimalInputParam("@ip_dc_id_lop_mon", ip_dc_id_lop_mon); v_obj_spr.addDecimalInputParam("@ip_dc_id_nguoi_diem_danh", ip_dc_id_nguoi_diem_danh); v_obj_spr.addDatetimeInputParam("@ip_dat_tai_ngay", ip_dat_tai_ngay); SqlParameter v_id_gd_diem_danh = v_obj_spr.addDecimalOutputParam("@op_dc_id_gd_diem_danh", 0); v_obj_spr.ExecuteCommand(this); op_dc_id_gd_diem_danh = CIPConvert.ToDecimal(v_id_gd_diem_danh.Value); if (op_dc_id_gd_diem_danh == -1) { return false; } else return true; }
public decimal get_tong_tien_dinh_muc_hang_thang(decimal ip_id_trung_tam, decimal ip_id_loai_dinh_muc, DateTime ip_dau_thang, DateTime ip_cuoi_thang) { CStoredProc v_store_proc = new CStoredProc("[pr_get_tong_tien_dm_theo_thang]"); v_store_proc.addDecimalInputParam("@ID_TRUNG_TAM ", ip_id_trung_tam); v_store_proc.addDatetimeInputParam("@DAU_THANG", ip_dau_thang.Date); v_store_proc.addDatetimeInputParam("@CUOI_THANG", ip_cuoi_thang.Date); v_store_proc.addDecimalInputParam("@ID_LOAI_DINH_MUC", ip_id_loai_dinh_muc); SqlParameter v_obj_tong_tien_dinh_muc = v_store_proc.addDecimalOutputParam("@TONG_TIEN", 0); v_store_proc.ExecuteCommand(this); if(v_obj_tong_tien_dinh_muc.Value!=null) return CIPConvert.ToDecimal(v_obj_tong_tien_dinh_muc.Value); return 0; }
public void Insert_nhom_nguoi_dung() { CStoredProc v_cstore = new CStoredProc("pr_HT_USER_GROUP_Insert"); v_cstore.addNVarcharInputParam("@USER_GROUP_NAME", this.strUSER_GROUP_NAME); v_cstore.addNVarcharInputParam("@DESCRIPTION", this.strDESCRIPTION); v_cstore.addDecimalInputParam("@ID_DON_VI", this.dcID_DON_VI); v_cstore.addDecimalOutputParam("@ID", this.dcID); v_cstore.ExecuteCommand(this); }
public void LayMaMucLNSCuaHopDong(decimal ip_dc_id_hop_dong_con_hieu_luc, out decimal op_dc_he_so, out string op_str_ma, out string op_str_muc) { CStoredProc v_sp = new CStoredProc("pr_HD_ma_muc_lns_Get"); v_sp.addDecimalInputParam("@ip_dc_id_hop_dong_con_hieu_luc", @ip_dc_id_hop_dong_con_hieu_luc); SqlParameter v_p_he_so = v_sp.addDecimalOutputParam("@op_dc_he_so", (decimal)1.123); v_p_he_so.Precision = 6; v_p_he_so.Scale = 2; SqlParameter v_p_muc = v_sp.addNVarcharOutputParam("@op_str_muc_lns", ""); SqlParameter v_p_ma = v_sp.addNVarcharOutputParam("@op_str_ma_lns", ""); v_sp.ExecuteCommand(this); op_dc_he_so = Convert.ToDecimal(v_p_he_so.Value); op_str_ma = v_p_ma.Value.ToString(); op_str_muc = v_p_muc.Value.ToString(); }
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 bool is_so_tien_null(US_DM_BILL ip_us_dm_bill, string ip_so_bill) { CStoredProc v_proc = new CStoredProc("pr_is_so_tien_null"); v_proc.addNVarcharInputParam("@SO_BILL", ip_so_bill); SqlParameter v_obj_is_so_tien_null = v_proc.addDecimalOutputParam("@SO_TIEN", 0); v_proc.ExecuteCommand(ip_us_dm_bill); if(CIPConvert.ToDecimal(v_obj_is_so_tien_null.Value) == -1) { return true; } return false; }
public void Find_id_gd_phieu_thu(decimal ip_dc_id_lop_mon, DateTime ip_dat_ngay_thu, ref decimal op_dc_id_gd_phieu_thu) { CStoredProc v_obj = new CStoredProc("pr_get_id_gd_hoc_by_id_lop_ngay_thu"); v_obj.addDecimalInputParam("@ip_dc_id_lop_mon", ip_dc_id_lop_mon); v_obj.addDatetimeInputParam("@ip_dat_ngay_thu", ip_dat_ngay_thu); SqlParameter v_id_gd_phieu_thu = v_obj.addDecimalOutputParam("@op_dc_id_gd_phieu_thu", 0); v_obj.ExecuteCommand(this); op_dc_id_gd_phieu_thu = CIPConvert.ToDecimal(v_id_gd_phieu_thu.Value); }
public decimal getIDNhanVienByMaNV(string ip_str_ma_nv) { CStoredProc v_sp = new CStoredProc("pr_get_id_nhan_vien_by_ma_nv"); v_sp.addNVarcharInputParam("@ip_str_ma_nv", ip_str_ma_nv); SqlParameter v_para = v_sp.addDecimalOutputParam("@op_dc_id_nhan_vien", -1); v_sp.ExecuteCommand(this); return Convert.ToDecimal(v_para.Value); }
public void tinh_tuoi_nhan_vien(DateTime ip_dat_ngay_sinh, ref decimal op_dc_so_tuoi) { CStoredProc v_obj_csp = new CStoredProc("pr_get_so_tuoi_nhan_vien"); v_obj_csp.addDatetimeInputParam("@ip_dat_ngay_sinh", ip_dat_ngay_sinh); SqlParameter v_op_result = v_obj_csp.addDecimalOutputParam("@op_dc_so_tuoi", 0); v_obj_csp.ExecuteCommand(this); op_dc_so_tuoi = Convert.ToDecimal(v_op_result.Value); }
public void kiem_tra_thang_da_giam_tru_chua(decimal ip_dc_thang, decimal ip_dc_nam, ref decimal op_dc_thang_da_giam_tru) { CStoredProc v_obj = new CStoredProc("pr_CHECK_DA_GIAM_TRU_THANG_DO_YN"); v_obj.addDecimalInputParam("@ip_dc_thang", ip_dc_thang); v_obj.addDecimalInputParam("@ip_dc_nam", ip_dc_nam); SqlParameter v_dc_thang_da_giam_tru = v_obj.addDecimalOutputParam("@op_dc_thang_da_giam_tru", 0); v_obj.ExecuteCommand(this); op_dc_thang_da_giam_tru = CIPConvert.ToDecimal(v_dc_thang_da_giam_tru.Value); }
//Bang luong public void LayTrangThaiBangLuong(decimal ip_dc_thang , decimal ip_dc_nam , out decimal op_sl_nv_can_tinh_luong , out decimal op_sl_nv_da_tinh_luong , out bool op_bol_co_du_lieu_chua , out bool op_bol_chot_bang_luong) { op_sl_nv_can_tinh_luong = 0; op_sl_nv_da_tinh_luong = 0; CStoredProc v_sp = new CStoredProc("pr_TL_trang_thai_bang_luong_Get"); v_sp.addDecimalInputParam("@ip_i_thang", ip_dc_thang); v_sp.addDecimalInputParam("@ip_i_nam", ip_dc_nam); SqlParameter v_para_all = v_sp.addDecimalOutputParam("@op_i_tong_so_nhan_vien_can_tinh", 0); SqlParameter v_para_da_tinh = v_sp.addDecimalOutputParam("@op_i_so_luong_nhan_vien_da_tinh", 0); SqlParameter v_para_co_du_lieu_chua = v_sp.addNVarcharOutputParam("@op_str_co_du_lieu_chua", ""); SqlParameter v_para_chot_bang_luong = v_sp.addNVarcharOutputParam("@op_str_chot_bang_luong", ""); v_sp.ExecuteCommand(this); op_sl_nv_can_tinh_luong = CIPConvert.ToDecimal(v_para_all.Value); op_sl_nv_da_tinh_luong = CIPConvert.ToDecimal(v_para_da_tinh.Value); op_bol_co_du_lieu_chua = v_para_co_du_lieu_chua.Value.ToString() == "Y" ? true : false; op_bol_chot_bang_luong = v_para_chot_bang_luong.Value.ToString() == "Y" ? true : false; }
public void get_thong_tin_qua_trinh_tinh_luong(decimal ip_thang, decimal ip_nam, out decimal op_sl_nv_can_tinh_luong, out decimal op_sl_nv_da_tinh_luong) { op_sl_nv_can_tinh_luong = 0; op_sl_nv_da_tinh_luong = 0; CStoredProc v_sp = new CStoredProc("pr_get_thong_tin_qua_trinh_tinh_luong"); v_sp.addDecimalInputParam("@ip_dat_thang", ip_thang); v_sp.addDecimalInputParam("@ip_dat_nam", ip_nam); SqlParameter v_para_all = v_sp.addDecimalOutputParam("@op_dc_so_luong_nv_tinh_luong", 0); SqlParameter v_para_da_tinh = v_sp.addDecimalOutputParam("@op_dc_so_luong_da_tinh_luong", 0); v_sp.ExecuteCommand(this); op_sl_nv_can_tinh_luong = CIPConvert.ToDecimal(v_para_all.Value); op_sl_nv_da_tinh_luong = CIPConvert.ToDecimal(v_para_da_tinh.Value); }
public void Find_ID_GD_DIEM_DANH(decimal ip_dc_id_lop_mon, DateTime ip_dat_tai_ngay, ref decimal op_dc_id_gd_diem_danh) { CStoredProc v_obj = new CStoredProc("pr_get_id_diem_danh_by_id_lop_mon_va_ngay_diem_danh"); v_obj.addDecimalInputParam("@ip_dc_id_lop_mon", ip_dc_id_lop_mon); v_obj.addDatetimeInputParam("@ip_dat_tai_ngay", ip_dat_tai_ngay); SqlParameter v_id_gd_diem_danh = v_obj.addDecimalOutputParam("@op_dc_id_gd_diem_danh", 0); v_obj.ExecuteCommand(this); op_dc_id_gd_diem_danh = CIPConvert.ToDecimal(v_id_gd_diem_danh.Value); }
public void FillDataset_2_lbl_tong_so(DS_V_F316_DM_HOC_SINH_LOP_MON op_ds_tong_so_hoc_sinh, decimal ip_dc_id_lop_mon, ref decimal op_dc_tong_so_hoc_sinh) { CStoredProc v_obj_spr = new CStoredProc("pr_tinh_tong_so_hoc_sinh_theo_lop_mon"); v_obj_spr.addDecimalInputParam("@ip_dc_id_lop_mon", ip_dc_id_lop_mon); SqlParameter v_tong_so_hoc_sinh = v_obj_spr.addDecimalOutputParam("@op_dc_tong_so_hoc_sinh", op_dc_tong_so_hoc_sinh); v_obj_spr.fillDataSetByCommand(this, op_ds_tong_so_hoc_sinh); op_dc_tong_so_hoc_sinh = CIPConvert.ToDecimal(v_tong_so_hoc_sinh.Value); }
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 ); }
public decimal get_id_don_vi_by_id_user(decimal ip_dc_id_user) { CStoredProc v_sp = new CStoredProc("pr_get_id_don_vi_by_id_user"); Decimal v_dc_id_don_vi = 0; v_sp.addDecimalInputParam("@ip_dc_id_user", ip_dc_id_user); v_sp.addDecimalOutputParam("@ip_dc_id_don_vi", v_dc_id_don_vi); v_sp.ExecuteCommand(this); return v_dc_id_don_vi; }
public void Find_ID_GD_HOC(decimal ip_dc_id_lop_mon, decimal ip_dc_id_hoc_sinh, ref decimal op_dc_id_gd_hoc) { CStoredProc v_obj = new CStoredProc("pr_get_id_gd_hoc_by_id_hoc_sinh_id_lop_mon"); v_obj.addDecimalInputParam("@ip_dc_id_lop_mon", ip_dc_id_lop_mon); v_obj.addDecimalInputParam("@ip_dc_id_hoc_sinh", ip_dc_id_hoc_sinh); SqlParameter v_id_gd_hoc = v_obj.addDecimalOutputParam("@op_dc_id_gd_hoc", 0); v_obj.ExecuteCommand(this); op_dc_id_gd_hoc = CIPConvert.ToDecimal(v_id_gd_hoc.Value); }
public decimal get_id_td_dich_vu(decimal v_id_loai_dich_vu, decimal v_id_td) { decimal count = 0; CStoredProc v_cstore = new CStoredProc("get_id_td_dich_vu"); v_cstore.addDecimalInputParam("@id", v_id_loai_dich_vu); v_cstore.addDecimalInputParam("@v_id_td", v_id_td); SqlParameter v_result = v_cstore.addDecimalOutputParam("@count", count); v_cstore.ExecuteCommand(this); return (decimal)v_result.Value; }
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 string suggest_id_hs_moi() { CStoredProc v_obj_spr = new CStoredProc("pr_suggest_ma_hs"); SqlParameter v_sql = v_obj_spr.addDecimalOutputParam("@op_dc_ma_hs_suggest", -1); v_obj_spr.ExecuteCommand(this); return v_sql.Value.ToString(); }
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 decimal get_tong_tien_da_chi_hang_thang(decimal ip_id_trung_tam, DateTime ip_thang) { CStoredProc v_store_proc = new CStoredProc("[pr_get_tong_tien_da_chi_hang_thang]"); v_store_proc.addDecimalInputParam("@ID_TRUNG_TAM ", ip_id_trung_tam); v_store_proc.addDatetimeInputParam("@THANG", ip_thang.Date); SqlParameter v_obj_tong_tien_dinh_muc = v_store_proc.addDecimalOutputParam("@TONG_TIEN", 0); v_store_proc.ExecuteCommand(this); if(v_obj_tong_tien_dinh_muc.Value!=null) return CIPConvert.ToDecimal(v_obj_tong_tien_dinh_muc.Value); return 0; }