C# SubSonic.StoredProcedure类代码示例

        /// <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;
        }

        /// <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;
        }

        /// <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;
        }

        /// <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;
        }

 /// <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;
 }

        /// <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;
        }

        /// <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;
        }

        /// <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;
        }

        /// <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;
        }

 /// <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;
 }

        /// <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;
        }

        /// <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;
        }

        /// <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;
        }

 /// <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;
 }

        /// <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;
        }