當前位置: 首頁>>代碼示例>>C#>>正文

C# SubSonic.StoredProcedure類代碼示例

本文整理匯總了C#中SubSonic.StoredProcedure類的典型用法代碼示例。如果您正苦於以下問題：C# StoredProcedure類的具體用法？C# StoredProcedure怎麽用？C# StoredProcedure使用的例子？那麽, 這裏精選的類代碼示例或許可以為您提供幫助。


StoredProcedure類屬於SubSonic命名空間，在下文中一共展示了StoredProcedure類的15個代碼示例，這些例子默認根據受歡迎程度排序。您可以為喜歡或者感覺有用的代碼點讚，您的評價將有助於係統推薦出更棒的C#代碼示例。

示例1: BaocaoDanhsachhoadonThuphi

        /// <summary>
        /// Creates an object wrapper for the baocao_danhsachhoadon_thuphi Procedure
        /// </summary>
        public static StoredProcedure BaocaoDanhsachhoadonThuphi(DateTime? TuNgay, DateTime? DenNgay, int? LoaiTimKiem, string DoiTuong, string NguoiThu, int? NTNT, int? cohoadon, string maquyen, int? fromserie, int? toserie, string KhoaThucHien)
        {
            SubSonic.StoredProcedure sp = new SubSonic.StoredProcedure("baocao_danhsachhoadon_thuphi", DataService.GetInstance("ORM"), "dbo");

            sp.Command.AddParameter("@TuNgay", TuNgay, DbType.DateTime, null, null);

            sp.Command.AddParameter("@DenNgay", DenNgay, DbType.DateTime, null, null);

            sp.Command.AddParameter("@LoaiTimKiem", LoaiTimKiem, DbType.Int32, 0, 10);

            sp.Command.AddParameter("@DoiTuong", DoiTuong, DbType.String, null, null);

            sp.Command.AddParameter("@NguoiThu", NguoiThu, DbType.String, null, null);

            sp.Command.AddParameter("@NTNT", NTNT, DbType.Int32, 0, 10);

            sp.Command.AddParameter("@cohoadon", cohoadon, DbType.Int32, 0, 10);

            sp.Command.AddParameter("@maquyen", maquyen, DbType.String, null, null);

            sp.Command.AddParameter("@from_serie", fromserie, DbType.Int32, 0, 10);

            sp.Command.AddParameter("@to_serie", toserie, DbType.Int32, 0, 10);

            sp.Command.AddParameter("@KhoaThucHien", KhoaThucHien, DbType.String, null, null);

            return sp;
        }
開發者ID:khaha2210，項目名稱:VXIS，代碼行數:31，代碼來源:StoredProcedures.cs

示例2: Elmah_LogError

        /// <summary>
        /// Creates an object wrapper for the ELMAH_LogError Procedure
        /// </summary>
        public static StoredProcedure Elmah_LogError(Guid? ErrorId, string Application, string Host, string Type, string Source, string Message, string User, string AllXml, int? StatusCode, DateTime? TimeUtc)
        {
            SubSonic.StoredProcedure sp = new SubSonic.StoredProcedure("ELMAH_LogError" , DataService.GetInstance("DotNetKicks"));

            sp.Command.AddParameter("@ErrorId", ErrorId,DbType.Guid);

            sp.Command.AddParameter("@Application", Application,DbType.String);

            sp.Command.AddParameter("@Host", Host,DbType.String);

            sp.Command.AddParameter("@Type", Type,DbType.String);

            sp.Command.AddParameter("@Source", Source,DbType.String);

            sp.Command.AddParameter("@Message", Message,DbType.String);

            sp.Command.AddParameter("@User", User,DbType.String);

            sp.Command.AddParameter("@AllXml", AllXml,DbType.String);

            sp.Command.AddParameter("@StatusCode", StatusCode,DbType.Int32);

            sp.Command.AddParameter("@TimeUtc", TimeUtc,DbType.DateTime);

            return sp;
        }
開發者ID:Letractively，項目名稱:dotnetkicks，代碼行數:29，代碼來源:StoredProcedures.cs

示例3: BaocaoSoluongNhanguiMau

        /// <summary>
        /// Creates an object wrapper for the BAOCAO_SOLUONG_NHANGUI_MAU Procedure
        /// </summary>
        public static StoredProcedure BaocaoSoluongNhanguiMau(DateTime? fromDate, DateTime? ToDate, int? ObjectTypeID, int? IDLoaiXN, int? DepartmentID, int? Noitru, int? LAM, string NguoiNhan, string NguoiGui, int? StatusPrint, int? GioNhan)
        {
            SubSonic.StoredProcedure sp = new SubSonic.StoredProcedure("BAOCAO_SOLUONG_NHANGUI_MAU", DataService.GetInstance("ORM"), "dbo");

            sp.Command.AddParameter("@fromDate", fromDate, DbType.DateTime, null, null);

            sp.Command.AddParameter("@ToDate", ToDate, DbType.DateTime, null, null);

            sp.Command.AddParameter("@ObjectType_ID", ObjectTypeID, DbType.Int32, 0, 10);

            sp.Command.AddParameter("@ID_Loai_XN", IDLoaiXN, DbType.Int32, 0, 10);

            sp.Command.AddParameter("@Department_ID", DepartmentID, DbType.Int32, 0, 10);

            sp.Command.AddParameter("@Noitru", Noitru, DbType.Int32, 0, 10);

            sp.Command.AddParameter("@LAM", LAM, DbType.Int32, 0, 10);

            sp.Command.AddParameter("@NguoiNhan", NguoiNhan, DbType.String, null, null);

            sp.Command.AddParameter("@NguoiGui", NguoiGui, DbType.String, null, null);

            sp.Command.AddParameter("@StatusPrint", StatusPrint, DbType.Int32, 0, 10);

            sp.Command.AddParameter("@GioNhan", GioNhan, DbType.Int32, 0, 10);

            return sp;
        }
開發者ID:khaha2210，項目名稱:CodeNewTeam，代碼行數:31，代碼來源:StoredProcedures.cs

示例4: AspnetMembershipCreateUser

        /// <summary>
        /// Creates an object wrapper for the aspnet_Membership_CreateUser Procedure
        /// </summary>
        public static StoredProcedure AspnetMembershipCreateUser(string ApplicationName, string UserName, string Password, string PasswordSalt, string Email, string PasswordQuestion, string PasswordAnswer, bool? IsApproved, DateTime? CurrentTimeUtc, DateTime? CreateDate, int? UniqueEmail, int? PasswordFormat, Guid? UserId)
        {
            SubSonic.StoredProcedure sp = new SubSonic.StoredProcedure("aspnet_Membership_CreateUser", DataService.GetInstance("SignificantTradeSS"), "dbo");

            sp.Command.AddParameter("@ApplicationName", ApplicationName, DbType.String, null, null);

            sp.Command.AddParameter("@UserName", UserName, DbType.String, null, null);

            sp.Command.AddParameter("@Password", Password, DbType.String, null, null);

            sp.Command.AddParameter("@PasswordSalt", PasswordSalt, DbType.String, null, null);

            sp.Command.AddParameter("@Email", Email, DbType.String, null, null);

            sp.Command.AddParameter("@PasswordQuestion", PasswordQuestion, DbType.String, null, null);

            sp.Command.AddParameter("@PasswordAnswer", PasswordAnswer, DbType.String, null, null);

            sp.Command.AddParameter("@IsApproved", IsApproved, DbType.Boolean, null, null);

            sp.Command.AddParameter("@CurrentTimeUtc", CurrentTimeUtc, DbType.DateTime, null, null);

            sp.Command.AddParameter("@CreateDate", CreateDate, DbType.DateTime, null, null);

            sp.Command.AddParameter("@UniqueEmail", UniqueEmail, DbType.Int32, 0, 10);

            sp.Command.AddParameter("@PasswordFormat", PasswordFormat, DbType.Int32, 0, 10);

            sp.Command.AddOutputParameter("@UserId", DbType.Guid, null, null);

            return sp;
        }
開發者ID:unepwcmc，項目名稱:sigtrade，代碼行數:35，代碼來源:StoredProcedures.cs

示例5: DtCheckinobject

 /// <summary>
 /// Creates an object wrapper for the dt_checkinobject Procedure
 /// </summary>
 public static StoredProcedure DtCheckinobject(string chObjectType, string vchObjectName, string vchComment, string vchLoginName, string vchPassword, int? iVCSFlags, int? iActionFlag, string txStream1, string txStream2, string txStream3)
 {
     SubSonic.StoredProcedure sp = new SubSonic.StoredProcedure("dt_checkinobject", DataService.GetInstance("WWIprov"), "dbo");
 	
     sp.Command.AddParameter("@chObjectType", chObjectType, DbType.AnsiStringFixedLength, null, null);
 	
     sp.Command.AddParameter("@vchObjectName", vchObjectName, DbType.AnsiString, null, null);
 	
     sp.Command.AddParameter("@vchComment", vchComment, DbType.AnsiString, null, null);
 	
     sp.Command.AddParameter("@vchLoginName", vchLoginName, DbType.AnsiString, null, null);
 	
     sp.Command.AddParameter("@vchPassword", vchPassword, DbType.AnsiString, null, null);
 	
     sp.Command.AddParameter("@iVCSFlags", iVCSFlags, DbType.Int32, 0, 10);
 	
     sp.Command.AddParameter("@iActionFlag", iActionFlag, DbType.Int32, 0, 10);
 	
     sp.Command.AddParameter("@txStream1", txStream1, DbType.AnsiString, null, null);
 	
     sp.Command.AddParameter("@txStream2", txStream2, DbType.AnsiString, null, null);
 	
     sp.Command.AddParameter("@txStream3", txStream3, DbType.AnsiString, null, null);
 	
     return sp;
 }
開發者ID:Publiship，項目名稱:WWI_CRM_folders，代碼行數:29，代碼來源:StoredProcedures.cs

示例6: FetchAllProductsByCategoryId

        /// <summary>
        /// Creates an object wrapper for the dashCommerce_Store_FetchAllProductsByCategoryId Procedure
        /// </summary>
        public static StoredProcedure FetchAllProductsByCategoryId(int? CategoryId)
        {
            SubSonic.StoredProcedure sp = new SubSonic.StoredProcedure("dashCommerce_Store_FetchAllProductsByCategoryId" , DataService.GetInstance("dashCommerceProvider"));

            sp.Command.AddParameter("@CategoryId", CategoryId,DbType.Int32);

            return sp;
        }
開發者ID:freecin，項目名稱:dashcommerce-3，代碼行數:11，代碼來源:StoredProcedures.cs

示例7: GetChildItems

        /// <summary>
        /// Creates an object wrapper for the GetChildItems Procedure
        /// </summary>
        public static StoredProcedure GetChildItems(string categoryId)
        {
            SubSonic.StoredProcedure sp = new SubSonic.StoredProcedure("GetChildItems", DataService.GetInstance("External"), "dbo");

            sp.Command.AddParameter("@categoryId", categoryId, DbType.String, null, null);

            return sp;
        }
開發者ID:rafathan，項目名稱:OriginalIntranet，代碼行數:11，代碼來源:StoredProcedures.cs

示例8: CustOrdersOrders

        /// <summary>
        /// Creates an object wrapper for the CustOrdersOrders Procedure
        /// </summary>
        public static StoredProcedure CustOrdersOrders(string CustomerID)
        {
            SubSonic.StoredProcedure sp = new SubSonic.StoredProcedure("CustOrdersOrders", DataService.GetInstance("NorthwindAccess"), "");

            sp.Command.AddParameter("[CustomerID]", CustomerID, DbType.String, null, null);

            return sp;
        }
開發者ID:RyanDansie，項目名稱:SubSonic-2.0，代碼行數:11，代碼來源:StoredProcedures.cs

示例9: CustOrdersDetail

        /// <summary>
        /// Creates an object wrapper for the CustOrdersDetail Procedure
        /// </summary>
        public static StoredProcedure CustOrdersDetail(int? OrderID)
        {
            SubSonic.StoredProcedure sp = new SubSonic.StoredProcedure("CustOrdersDetail", DataService.GetInstance("NorthwindAccess"), "");

            sp.Command.AddParameter("[OrderID]", OrderID, DbType.Int32, null, null);

            return sp;
        }
開發者ID:RyanDansie，項目名稱:SubSonic-2.0，代碼行數:11，代碼來源:StoredProcedures.cs

示例10: DtAdduserobjectVcs

 /// <summary>
 /// Creates an object wrapper for the dt_adduserobject_vcs Procedure
 /// </summary>
 public static StoredProcedure DtAdduserobjectVcs(string vchProperty)
 {
     SubSonic.StoredProcedure sp = new SubSonic.StoredProcedure("dt_adduserobject_vcs", DataService.GetInstance("WWIprov"), "dbo");
 	
     sp.Command.AddParameter("@vchProperty", vchProperty, DbType.AnsiString, null, null);
 	
     return sp;
 }
開發者ID:Publiship，項目名稱:WWI_CRM_folders，代碼行數:11，代碼來源:StoredProcedures.cs

示例11: BExpRelate_Sp

        /// <summary>
        /// Creates an object wrapper for the BExpRelate_sp Procedure
        /// </summary>
        public static StoredProcedure BExpRelate_Sp(int? BusinessExpId)
        {
            SubSonic.StoredProcedure sp = new SubSonic.StoredProcedure("BExpRelate_sp", DataService.GetInstance("SubsonicProvider"), "dbo");

            sp.Command.AddParameter("@BusinessExpId", BusinessExpId, DbType.Int32, 0, 10);

            return sp;
        }
開發者ID:xingfudaiyan，項目名稱:OA，代碼行數:11，代碼來源:SPs.cs

示例12: BasEmScoregv_Sp

        /// <summary>
        /// Creates an object wrapper for the BasEmScoregv_sp Procedure
        /// </summary>
        public static StoredProcedure BasEmScoregv_Sp(int? EmployeeId)
        {
            SubSonic.StoredProcedure sp = new SubSonic.StoredProcedure("BasEmScoregv_sp", DataService.GetInstance("SubsonicProvider"), "dbo");

            sp.Command.AddParameter("@EmployeeId", EmployeeId, DbType.Int32, 0, 10);

            return sp;
        }
開發者ID:xingfudaiyan，項目名稱:OA，代碼行數:11，代碼來源:SPs.cs

示例13: AspnetSetupRemoveAllRoleMembers

        /// <summary>
        /// Creates an object wrapper for the aspnet_Setup_RemoveAllRoleMembers Procedure
        /// </summary>
        public static StoredProcedure AspnetSetupRemoveAllRoleMembers(string name)
        {
            SubSonic.StoredProcedure sp = new SubSonic.StoredProcedure("aspnet_Setup_RemoveAllRoleMembers", DataService.GetInstance("Peerfx"), "dbo");

            sp.Command.AddParameter("@name", name, DbType.String, null, null);

            return sp;
        }
開發者ID:Lornestar，項目名稱:pfx，代碼行數:11，代碼來源:StoredProcedures.cs

示例14: SpFixPeriodBillingRates

 /// <summary>
 /// Creates an object wrapper for the sp_FixPeriodBillingRates Procedure
 /// </summary>
 public static StoredProcedure SpFixPeriodBillingRates(int? PeriodID)
 {
     SubSonic.StoredProcedure sp = new SubSonic.StoredProcedure("sp_FixPeriodBillingRates" , DataService.GetInstance("Billing"));
 	
     sp.Command.AddParameter("@PeriodID", PeriodID,DbType.Int32);
 	    
     return sp;
 }
開發者ID:gosuto，項目名稱:tfs2.com，代碼行數:11，代碼來源:StoredProcedures.cs

示例15: FetchAssociatedDownloadsByProductIdAndForPurchase

        /// <summary>
        /// Creates an object wrapper for the dashCommerce_Store_FetchAssociatedDownloadsByProductIdAndForPurchase Procedure
        /// </summary>
        public static StoredProcedure FetchAssociatedDownloadsByProductIdAndForPurchase(int? ProductId)
        {
            SubSonic.StoredProcedure sp = new SubSonic.StoredProcedure("dashCommerce_Store_FetchAssociatedDownloadsByProductIdAndForPurchase" , DataService.GetInstance("dashCommerceProvider"));

            sp.Command.AddParameter("@ProductId", ProductId,DbType.Int32);

            return sp;
        }
開發者ID:freecin，項目名稱:dashcommerce-3，代碼行數:11，代碼來源:StoredProcedures.cs


注：本文中的SubSonic.StoredProcedure類示例由純淨天空整理自Github/MSDocs等開源代碼及文檔管理平台，相關代碼片段篩選自各路編程大神貢獻的開源項目，源碼版權歸原作者所有，傳播和使用請參考對應項目的License；未經允許，請勿轉載。