当前位置: 首页>>代码示例>>C#>>正文


C# CStoredProc.ExecuteCommand方法代码示例

本文整理汇总了C#中IP.Core.IPUserService.CStoredProc.ExecuteCommand方法的典型用法代码示例。如果您正苦于以下问题:C# CStoredProc.ExecuteCommand方法的具体用法?C# CStoredProc.ExecuteCommand怎么用?C# CStoredProc.ExecuteCommand使用的例子?那么恭喜您, 这里精选的方法代码示例或许可以为您提供帮助。您也可以进一步了解该方法所在IP.Core.IPUserService.CStoredProc的用法示例。


在下文中一共展示了CStoredProc.ExecuteCommand方法的15个代码示例,这些例子默认根据受欢迎程度排序。您可以为喜欢或者感觉有用的代码点赞,您的评价将有助于系统推荐出更棒的C#代码示例。

示例1: KiemTraNhanVienCoCongTacChua

        public bool KiemTraNhanVienCoCongTacChua(decimal ip_dc_id_nhan_vien, decimal ip_dc_id_don_vi)
        {
            CStoredProc v_cstore = new CStoredProc("pr_NS_nhan_vien_thuoc_phong_ban_Check");
            v_cstore.addDecimalInputParam("@ip_dc_id_nhan_vien", ip_dc_id_nhan_vien);
            v_cstore.addDecimalInputParam("@ip_dc_id_don_vi", ip_dc_id_don_vi);
            SqlParameter v_para = v_cstore.addNVarcharOutputParam("@op_str_yn", "");
            v_cstore.ExecuteCommand(this);

            return v_para.Value.ToString() == "Y" ? true : false;
        }
开发者ID:assassinadal,项目名称:BKIProject-DichVuMatDat,代码行数:10,代码来源:US_GD_CONG_TAC.cs

示例2: KiemTraThoiGianHeSoLNSHopLeForInsert

        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;
        }
开发者ID:assassinadal,项目名称:BKIProject-DichVuMatDat,代码行数:12,代码来源:US_GD_HE_SO_LNS.cs

示例3: deleteAllDataOfUNC

 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;
 }
开发者ID:nguyendanhtu,项目名称:bki-quan-ly-du-toan,代码行数:15,代码来源:US_DM_GIAI_NGAN.cs

示例4: thay_doi_trang_thai_lao_dong

        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);
        }
开发者ID:assassinadal,项目名称:BKIProject-DichVuMatDat,代码行数:13,代码来源:US_GD_TRANG_THAI_LAO_DONG.cs

示例5: get_don_gia_dinh_muc_and_so_luong_thong_ke

        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);
            }
        }
开发者ID:tudm,项目名称:QuanLyHanhChinh,代码行数:22,代码来源:US_RPT_TONG_TIEN_DINH_MUC.cs

示例6: DeleteAllQuyenOfGroupUser

 public void DeleteAllQuyenOfGroupUser(decimal i_dc_group_user_id)
 {
     CStoredProc v_obj = new CStoredProc("pr_HT_PHAN_QUYEN_HE_THONG_Delele_All_Quyen_Of_group_user");
     v_obj.addDecimalInputParam("@ip_dc_group_user_id", i_dc_group_user_id);
     v_obj.ExecuteCommand(this);
 }
开发者ID:phamngocphong,项目名称:BKI_DaoTaoNoiBo,代码行数:6,代码来源:US_HT_PHAN_QUYEN_CHO_NHOM.cs

示例7: Insert_nhom_nguoi_dung

 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.ExecuteCommand(this);
 }
开发者ID:chutinhha,项目名称:bki-quan-ly-tai-san,代码行数:7,代码来源:US_HT_USER_GROUP.cs

示例8: update_noi_dung_chi_from_giao_kh_sang_giao_von

 public void update_noi_dung_chi_from_giao_kh_sang_giao_von(
     DateTime ip_dat_tu_ngay
     , DateTime ip_dat_den_ngay
     , decimal ip_dc_id_don_vi
     , decimal ip_dc_id_quyet_dinh)
 {
     CStoredProc v_sp = new CStoredProc("pr_gd_giao_von_insert_from_gd_giao_kh");
     v_sp.addDatetimeInputParam("@ip_dat_tu_ngay", ip_dat_tu_ngay);
     v_sp.addDatetimeInputParam("@ip_dat_den_ngay", ip_dat_den_ngay);
     v_sp.addDecimalInputParam("@ip_dc_id_don_vi", ip_dc_id_don_vi);
     v_sp.addDecimalInputParam("@ip_dc_id_quyet_dinh", ip_dc_id_quyet_dinh);
     v_sp.ExecuteCommand(this);
 }
开发者ID:nguyendanhtu,项目名称:bki-quan-ly-du-toan,代码行数:13,代码来源:US_GD_CHI_TIET_GIAO_VON.cs

示例9: gen_ma_nhan_vien

 public void gen_ma_nhan_vien(ref string v_str_op_ma_nhan_vien)
 {
     CStoredProc v_obj_csp = new CStoredProc("pr_gen_ma_nhan_vien");
     SqlParameter v_op_str = v_obj_csp.addNVarcharOutputParam("@op_ma_nhan_vien", "");
     v_obj_csp.ExecuteCommand(this);
     v_str_op_ma_nhan_vien = v_op_str.Value.ToString();
 }
开发者ID:assassinadal,项目名称:BKIProject-DichVuMatDat,代码行数:7,代码来源:US_V_GD_MA_TRA_CUU_NHAN_VIEN.cs

示例10: check_diem_danh_hs

        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;
        }
开发者ID:assassinadal,项目名称:bki-trung-tam-quoc-anh,代码行数:25,代码来源:US_GD_DIEM_DANH.cs

示例11: Find_ID_GD_DIEM_DANH

        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);
        }
开发者ID:assassinadal,项目名称:bki-trung-tam-quoc-anh,代码行数:10,代码来源:US_GD_DIEM_DANH.cs

示例12: LockBangLuongThang

        public void LockBangLuongThang(decimal ip_dc_thang, decimal ip_dc_nam, string ip_str_nguoi_chot)
        {
            CStoredProc v_pr = new CStoredProc("pr_TL_bang_luong_LOCK");
            v_pr.addDecimalInputParam("@ip_dc_thang", ip_dc_thang);
            v_pr.addDecimalInputParam("@ip_dc_nam", ip_dc_nam);
            v_pr.addNVarcharInputParam("@ip_str_nguoi_chot", ip_str_nguoi_chot);

            v_pr.ExecuteCommand(this);
        }
开发者ID:assassinadal,项目名称:BKIProject-DichVuMatDat,代码行数:9,代码来源:US_RPT_CHOT_BANG_LUONG.cs

示例13: IsLockBangLuong

        public bool IsLockBangLuong(decimal ip_dc_thang, decimal ip_dc_nam)
        {
            CStoredProc v_pr = new CStoredProc("pr_TL_infor_lock_bang_luong_Get");
            v_pr.addDecimalInputParam("@ip_dc_thang", ip_dc_thang);
            v_pr.addDecimalInputParam("@ip_dc_nam", ip_dc_nam);
            SqlParameter v_para = v_pr.addNVarcharOutputParam("@op_str_lock_yn", "");

            v_pr.ExecuteCommand(this);
            return v_para.Value.ToString() == "Y" ? true : false;
        }
开发者ID:assassinadal,项目名称:BKIProject-DichVuMatDat,代码行数:10,代码来源:US_RPT_CHOT_BANG_LUONG.cs

示例14: cap_nhat_trang_thai_cau_hoi

        public void cap_nhat_trang_thai_cau_hoi()
        {
            CStoredProc v_cstore = new CStoredProc("pr_V_GD_XU_LY_NOI_BO_Update_TrangThaiCauHoi");

            v_cstore.addDecimalInputParam("@ID", this.dcID);
            v_cstore.addDecimalInputParam("@ID_TRANG_THAI_CAU_HOI", this.dcID_TRANG_THAI_CAU_HOI);

            v_cstore.ExecuteCommand(this);
        }
开发者ID:anhphamkstn,项目名称:BKI_DVMC,代码行数:9,代码来源:US_V_GD_XU_LY_NOI_BO.cs

示例15: lap_hop_dong_moi_cho_nhan_vien

 public void lap_hop_dong_moi_cho_nhan_vien(decimal ID_NHAN_VIEN
     , decimal ID_LOAI_HOP_DONG
     , string MA_HOP_DONG
     , DateTime NGAY_BAT_DAU
     , DateTime NGAY_KET_THUC
     , DateTime NGAY_KY_HOP_DONG
     , DateTime NGAY_LAP
     , string NGUOI_LAP
     , string DA_XOA
     , decimal ID_CD_LCD
     , decimal ID_MUC_LCD
     , decimal ID_CD_LNS
     , decimal ID_MUC_LNS
     , ref string op_str_mess)
 {
     CStoredProc v_sp = new CStoredProc("pr_lap_hop_dong_moi_cho_nhan_vien");
     v_sp.addDecimalInputParam("@ID_NHAN_VIEN", ID_NHAN_VIEN);
     v_sp.addDecimalInputParam("@ID_LOAI_HOP_DONG", ID_LOAI_HOP_DONG);
     v_sp.addNVarcharInputParam("@MA_HOP_DONG", MA_HOP_DONG);
     v_sp.addDatetimeInputParam("@NGAY_BAT_DAU", NGAY_BAT_DAU);
     v_sp.addDatetimeInputParam("@NGAY_KET_THUC", NGAY_KET_THUC);
     v_sp.addDatetimeInputParam("@NGAY_KY_HOP_DONG", NGAY_KY_HOP_DONG);
     v_sp.addDatetimeInputParam("@NGAY_LAP", NGAY_LAP);
     v_sp.addNVarcharInputParam("@NGUOI_LAP", NGUOI_LAP);
     v_sp.addNVarcharInputParam("@DA_XOA", DA_XOA);
     v_sp.addDecimalInputParam("@ID_CD_LCD", ID_CD_LCD);
     v_sp.addDecimalInputParam("@ID_MUC_LCD", ID_MUC_LCD);
     v_sp.addDecimalInputParam("@ID_CD_LNS", ID_CD_LNS);
     v_sp.addDecimalInputParam("@ID_MUC_LNS", ID_MUC_LNS);
     SqlParameter v_op_str = v_sp.addNVarcharOutputParam("@OP_STR_MESSAGE", op_str_mess);
     v_sp.ExecuteCommand(this);
     op_str_mess = v_op_str.Value.ToString();
 }
开发者ID:assassinadal,项目名称:BKIProject-DichVuMatDat,代码行数:33,代码来源:US_GD_HOP_DONG.cs


注:本文中的IP.Core.IPUserService.CStoredProc.ExecuteCommand方法示例由纯净天空整理自Github/MSDocs等开源代码及文档管理平台,相关代码片段筛选自各路编程大神贡献的开源项目,源码版权归原作者所有,传播和使用请参考对应项目的License;未经允许,请勿转载。