Ejemplo n.º 1
0
        /// <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;
        }
Ejemplo n.º 2
0
        /// <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;
        }
Ejemplo n.º 3
0
        /// <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;
        }
Ejemplo n.º 4
0
        /// <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;
        }
Ejemplo n.º 5
0
 /// <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;
 }
Ejemplo n.º 6
0
        /// <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;
        }
Ejemplo n.º 7
0
        /// <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;
        }
Ejemplo n.º 8
0
        /// <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;
        }
Ejemplo n.º 9
0
        /// <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;
        }
Ejemplo n.º 10
0
        /// <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("NorthwindRepository"), "dbo");

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

            return sp;
        }
Ejemplo n.º 11
0
 /// <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;
 }
Ejemplo n.º 12
0
        /// <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;
        }
Ejemplo n.º 13
0
        /// <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;
        }
Ejemplo n.º 14
0
        /// <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;
        }
Ejemplo n.º 15
0
 /// <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;
 }
Ejemplo n.º 16
0
        /// <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;
        }
Ejemplo n.º 17
0
 /// <summary>
 /// Creates an object wrapper for the price_by_companyid_ext Procedure
 /// </summary>
 public static StoredProcedure PriceByCompanyidExt(int? companyid)
 {
     SubSonic.StoredProcedure sp = new SubSonic.StoredProcedure("price_by_companyid_ext", DataService.GetInstance("pricerprov"), "pricer_u");
 	
     sp.Command.AddParameter("@companyid", companyid, DbType.Int32, 0, 10);
 	
     return sp;
 }
Ejemplo n.º 18
0
        /// <summary>
        /// Creates an object wrapper for the dashCommerce_Content_FetchTemplateRegionsByTemplateId Procedure
        /// </summary>
        public static StoredProcedure FetchTemplateRegionsByTemplateId(int? TemplateId)
        {
            SubSonic.StoredProcedure sp = new SubSonic.StoredProcedure("dashCommerce_Content_FetchTemplateRegionsByTemplateId" , DataService.GetInstance("dashCommerceProvider"));

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

            return sp;
        }
Ejemplo n.º 19
0
        /// <summary>
        /// Creates an object wrapper for the Dmuc_Laydanhmucthuoc_Xuatexcel Procedure
        /// </summary>
        public static StoredProcedure DmucLaydanhmucthuocXuatexcel(int? All)
        {
            SubSonic.StoredProcedure sp = new SubSonic.StoredProcedure("Dmuc_Laydanhmucthuoc_Xuatexcel", DataService.GetInstance("ORM"), "dbo");

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

            return sp;
        }
Ejemplo n.º 20
0
        /// <summary>
        /// Creates an object wrapper for the aspnet_AnyDataInTables Procedure
        /// </summary>
        public static StoredProcedure AspnetAnyDataInTables(int? TablesToCheck)
        {
            SubSonic.StoredProcedure sp = new SubSonic.StoredProcedure("aspnet_AnyDataInTables" , DataService.GetInstance("WinSubSonicProvider"));

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

            return sp;
        }
Ejemplo n.º 21
0
        /// <summary>
        /// Creates an object wrapper for the GetItem Procedure
        /// </summary>
        public static StoredProcedure GetItem(string itemId)
        {
            SubSonic.StoredProcedure sp = new SubSonic.StoredProcedure("GetItem", DataService.GetInstance("External"), "dbo");

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

            return sp;
        }
Ejemplo n.º 22
0
        /// <summary>
        /// Creates an object wrapper for the Danhmuc_Xoadanhsachbaocaohethong Procedure
        /// </summary>
        public static StoredProcedure DanhmucXoadanhsachbaocaohethong(string lstID)
        {
            SubSonic.StoredProcedure sp = new SubSonic.StoredProcedure("Danhmuc_Xoadanhsachbaocaohethong", DataService.GetInstance("ORM"), "dbo");

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

            return sp;
        }
Ejemplo n.º 23
0
        /// <summary>
        /// Creates an object wrapper for the CustOrderHist Procedure
        /// </summary>
        public static StoredProcedure CustOrderHist(string CustomerID)
        {
            SubSonic.StoredProcedure sp = new SubSonic.StoredProcedure("CustOrderHist", DataService.GetInstance("NorthwindRepository"), "dbo");

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

            return sp;
        }
Ejemplo n.º 24
0
        /// <summary>
        /// Creates an object wrapper for the dashCommerce_Core_FetchStateOrRegionByCountryCode Procedure
        /// </summary>
        public static StoredProcedure FetchStateOrRegionByCountryCode(string Code)
        {
            SubSonic.StoredProcedure sp = new SubSonic.StoredProcedure("dashCommerce_Core_FetchStateOrRegionByCountryCode" , DataService.GetInstance("dashCommerceProvider"));

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

            return sp;
        }
Ejemplo n.º 25
0
        /// <summary>
        /// Creates an object wrapper for the aspnet_AnyDataInTables Procedure
        /// </summary>
        public static StoredProcedure AspnetAnyDataInTables(int? TablesToCheck)
        {
            SubSonic.StoredProcedure sp = new SubSonic.StoredProcedure("aspnet_AnyDataInTables", DataService.GetInstance("SignificantTradeSS"), "dbo");

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

            return sp;
        }
Ejemplo n.º 26
0
        /// <summary>
        /// Creates an object wrapper for the Employee Sales by Country Procedure
        /// </summary>
        public static StoredProcedure EmployeeSalesByCountry(DateTime? BeginningDate, DateTime? EndingDate)
        {
            SubSonic.StoredProcedure sp = new SubSonic.StoredProcedure("Employee Sales by Country", DataService.GetInstance("NorthwindAccess"), "");

            sp.Command.AddParameter("[Beginning Date]", BeginningDate, DbType.Date, null, null);

            sp.Command.AddParameter("[Ending Date]", EndingDate, DbType.Date, null, null);

            return sp;
        }
Ejemplo n.º 27
0
        /// <summary>
        /// Creates an object wrapper for the dashCommerce_Content_JoinRegionToPage Procedure
        /// </summary>
        public static StoredProcedure JoinRegionToPage(int? RegionId, int? PageId)
        {
            SubSonic.StoredProcedure sp = new SubSonic.StoredProcedure("dashCommerce_Content_JoinRegionToPage" , DataService.GetInstance("dashCommerceProvider"));

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

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

            return sp;
        }
Ejemplo n.º 28
0
        /// <summary>
        /// Creates an object wrapper for the aspnet_CheckSchemaVersion Procedure
        /// </summary>
        public static StoredProcedure AspnetCheckSchemaVersion(string Feature, string CompatibleSchemaVersion)
        {
            SubSonic.StoredProcedure sp = new SubSonic.StoredProcedure("aspnet_CheckSchemaVersion", DataService.GetInstance("SignificantTradeSS"), "dbo");

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

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

            return sp;
        }
Ejemplo n.º 29
0
        /// <summary>
        /// Creates an object wrapper for the aspnet_Applications_CreateApplication Procedure
        /// </summary>
        public static StoredProcedure AspnetApplicationsCreateApplication(string ApplicationName, Guid? ApplicationId)
        {
            SubSonic.StoredProcedure sp = new SubSonic.StoredProcedure("aspnet_Applications_CreateApplication", DataService.GetInstance("SignificantTradeSS"), "dbo");

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

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

            return sp;
        }
Ejemplo n.º 30
0
        /// <summary>
        /// Creates an object wrapper for the Dmuc_Laydanhsach_Bacsi Procedure
        /// </summary>
        public static StoredProcedure DmucLaydanhsachBacsi(int? DepartmentID, int? NoitruNgoaitru)
        {
            SubSonic.StoredProcedure sp = new SubSonic.StoredProcedure("Dmuc_Laydanhsach_Bacsi", DataService.GetInstance("ORM"), "dbo");

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

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

            return sp;
        }