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

C# SqlCeDataManager.AddIntegerBigPara方法代碼示例

本文整理匯總了C#中WebSpider.Data.DatabaseManager.SqlCeDataManager.AddIntegerBigPara方法的典型用法代碼示例。如果您正苦於以下問題：C# SqlCeDataManager.AddIntegerBigPara方法的具體用法？C# SqlCeDataManager.AddIntegerBigPara怎麽用？C# SqlCeDataManager.AddIntegerBigPara使用的例子？那麽, 這裏精選的方法代碼示例或許可以為您提供幫助。您也可以進一步了解該方法所在類WebSpider.Data.DatabaseManager.SqlCeDataManager的用法示例。


在下文中一共展示了SqlCeDataManager.AddIntegerBigPara方法的14個代碼示例，這些例子默認根據受歡迎程度排序。您可以為喜歡或者感覺有用的代碼點讚，您的評價將有助於係統推薦出更棒的C#代碼示例。

示例1: DeleteById

 public int DeleteById(Int64 TaskID)
 {
     String Query = "DELETE FROM TaskDetail WHERE TaskID = @TaskID";
     SqlCeDataManager oDm = new SqlCeDataManager(ConnectionString, Query, true);
     oDm.AddIntegerBigPara("TaskID", TaskID);
     return oDm.RunActionQuery();
 }
開發者ID:riskypathak，項目名稱:WebSpider，代碼行數:7，代碼來源:TaskDetailManager.cs

示例2: DeleteById

 public int DeleteById(Int64 ScheduleID)
 {
     String Query = "DELETE FROM [TaskHeader] WHERE [ScheduleID] = @ScheduleID";
     SqlCeDataManager oDm = new SqlCeDataManager(this.ConnectionString, Query, true);
     oDm.AddIntegerBigPara("ScheduleID", ScheduleID);
     return oDm.RunActionQuery();
 }
開發者ID:riskypathak，項目名稱:WebSpider，代碼行數:7，代碼來源:TaskHeaderManager.cs

示例3: GetDataById

 public List<TaskDetail> GetDataById(Int64 TaskID)
 {
     String Query = "SELECT * FROM TaskDetail WHERE TaskID = @TaskID";
     SqlCeDataManager oDm = new SqlCeDataManager(ConnectionString, Query, true);
     oDm.AddIntegerBigPara("TaskID", TaskID);
     return DataParser.ToList<TaskDetail>(oDm.GetTable());
 }
開發者ID:riskypathak，項目名稱:WebSpider，代碼行數:7，代碼來源:TaskDetailManager.cs

示例4: GenerateScheduleNextRun

        public void GenerateScheduleNextRun(Int64 ScheduleID)
        {
            String Query = String.Empty;
            SqlCeDataManager oDm;
            Query = "UPDATE	[TaskHeader] WITH (ROWLOCK) SET [NextRun] = DATEADD(yy, [TaskRepeatInterval], CASE WHEN [LastRun] IS NULL THEN [ScheduleFrom] ELSE [LastRun] END) WHERE	[TaskRepeatUnit] = 'YEAR' AND (ISNULL([NextRun]) = 1 OR [NextRun] < GETDATE()) AND ScheduleID = @ScheduleID";
            oDm = new SqlCeDataManager(this.ConnectionString, Query, true);
            oDm.AddIntegerBigPara("ScheduleID", ScheduleID);
            oDm.RunActionQuery();

            Query = "UPDATE	[TaskHeader] WITH (ROWLOCK) SET [NextRun] = DATEADD(q, [TaskRepeatInterval], CASE WHEN [LastRun] IS NULL THEN [ScheduleFrom] ELSE [LastRun] END) WHERE	[TaskRepeatUnit] = 'QUARTER' AND (ISNULL([NextRun]) = 1 OR [NextRun] < GETDATE()) AND ScheduleID = @ScheduleID";
            oDm = new SqlCeDataManager(this.ConnectionString, Query, true);
            oDm.AddIntegerBigPara("ScheduleID", ScheduleID);
            oDm.RunActionQuery();

            Query = "UPDATE	[TaskHeader] WITH (ROWLOCK) SET [NextRun] = DATEADD(m, [TaskRepeatInterval], CASE WHEN [LastRun] IS NULL THEN [ScheduleFrom] ELSE [LastRun] END) WHERE	[TaskRepeatUnit] = 'MONTH' AND (ISNULL([NextRun]) = 1 OR [NextRun] < GETDATE()) AND ScheduleID = @ScheduleID";
            oDm = new SqlCeDataManager(this.ConnectionString, Query, true);
            oDm.AddIntegerBigPara("ScheduleID", ScheduleID);
            oDm.RunActionQuery();

            Query = "UPDATE	[TaskHeader] WITH (ROWLOCK) SET [NextRun] = DATEADD(ww, [TaskRepeatInterval], CASE WHEN [LastRun] IS NULL THEN [ScheduleFrom] ELSE [LastRun] END) WHERE	[TaskRepeatUnit] = 'WEEK' AND (ISNULL([NextRun]) = 1 OR [NextRun] < GETDATE()) AND ScheduleID = @ScheduleID";
            oDm = new SqlCeDataManager(this.ConnectionString, Query, true);
            oDm.AddIntegerBigPara("ScheduleID", ScheduleID);
            oDm.RunActionQuery();

            Query = "UPDATE	[TaskHeader] WITH (ROWLOCK) SET [NextRun] = DATEADD(d, [TaskRepeatInterval], CASE WHEN [LastRun] IS NULL THEN [ScheduleFrom] ELSE [LastRun] END) WHERE	[TaskRepeatUnit] = 'DAY' AND (ISNULL([NextRun]) = 1 OR [NextRun] < GETDATE()) AND ScheduleID = @ScheduleID";
            oDm = new SqlCeDataManager(this.ConnectionString, Query, true);
            oDm.AddIntegerBigPara("ScheduleID", ScheduleID);
            oDm.RunActionQuery();

            Query = "UPDATE	[TaskHeader] WITH (ROWLOCK) SET [NextRun] = DATEADD(hh, [TaskRepeatInterval], CASE WHEN [LastRun] IS NULL THEN [ScheduleFrom] ELSE [LastRun] END) WHERE	[TaskRepeatUnit] = 'HOUR' AND (ISNULL([NextRun]) = 1 OR [NextRun] < GETDATE()) AND ScheduleID = @ScheduleID";
            oDm = new SqlCeDataManager(this.ConnectionString, Query, true);
            oDm.AddIntegerBigPara("ScheduleID", ScheduleID);
            oDm.RunActionQuery();

            Query = "UPDATE	[TaskHeader] WITH (ROWLOCK) SET [NextRun] = DATEADD(mi, [TaskRepeatInterval], CASE WHEN [LastRun] IS NULL THEN [ScheduleFrom] ELSE [LastRun] END) WHERE	[TaskRepeatUnit] = 'MINUTE' AND (ISNULL([NextRun]) = 1 OR [NextRun] < GETDATE()) AND ScheduleID = @ScheduleID";
            oDm = new SqlCeDataManager(this.ConnectionString, Query, true);
            oDm.AddIntegerBigPara("ScheduleID", ScheduleID);
            oDm.RunActionQuery();
        }
開發者ID:riskypathak，項目名稱:WebSpider，代碼行數:39，代碼來源:TaskHeaderManager.cs

示例5: Update

 public int Update(Int64 ScheduleID, String TaskName, String TaskDescription, String Site, DateTime ScheduleFrom
     , Boolean TaskRepeat, Int32 TaskRepeatInterval, String TaskRepeatUnit, Boolean Enabled)
 {
     String Query = "UPDATE [TaskHeader] SET [TaskName] = @TaskName, [TaskDescription] = @TaskDescription, [Site] = @Site, "
         + "[ScheduleFrom] = @ScheduleFrom, [TaskRepeat] = @TaskRepeat, [TaskRepeatInterval] = @TaskRepeatInterval, "
         + "[TaskRepeatUnit] = @TaskRepeatUnit, [Enabled] = @Enabled "
         + "WHERE [ScheduleID] = @ScheduleID";
     SqlCeDataManager oDm = new SqlCeDataManager(this.ConnectionString, Query, true);
     oDm.AddIntegerBigPara("ScheduleID", ScheduleID);
     oDm.AddVarcharPara("TaskName", 4000, TaskName);
     oDm.AddVarcharPara("TaskDescription", 4000, TaskDescription);
     oDm.AddVarcharPara("Site", 4000, Site);
     oDm.AddDateTimePara("ScheduleFrom", ScheduleFrom);
     oDm.AddBoolPara("TaskRepeat", TaskRepeat);
     oDm.AddIntegerPara("TaskRepeatInterval", TaskRepeatInterval);
     oDm.AddVarcharPara("TaskRepeatUnit", 4000, TaskRepeatUnit);
     oDm.AddBoolPara("Enabled", Enabled);
     return oDm.RunActionQuery();
 }
開發者ID:riskypathak，項目名稱:WebSpider，代碼行數:19，代碼來源:TaskHeaderManager.cs

示例6: GetData

 public List<TaskHeader> GetData(Int64 ScheduleID)
 {
     String Query = "SELECT * FROM TaskHeader WITH (NOLOCK) WHERE ScheduleID = @ScheduleID";
     SqlCeDataManager oDm = new SqlCeDataManager(this.ConnectionString, Query, true);
     oDm.AddIntegerBigPara("ScheduleID", ScheduleID);
     return DataParser.ToList<TaskHeader>(oDm.GetTable());
 }
開發者ID:riskypathak，項目名稱:WebSpider，代碼行數:7，代碼來源:TaskHeaderManager.cs

示例7: GetDataBySite

 public List<TaskDetail> GetDataBySite(Int64 TaskHeaderID, String TaskSite, Int32[] TaskStatus)
 {
     String Query = "SELECT * FROM TaskDetail WHERE TaskHeaderID = @TaskHeaderID AND TaskSite = @TaskSite AND TaskStatus IN ({0})";
     Query = String.Format(Query, String.Join(",", TaskStatus.Select(x => x.ToString()).ToArray()));
     SqlCeDataManager oDm = new SqlCeDataManager(ConnectionString, Query, true);
     oDm.AddIntegerBigPara("TaskHeaderID", TaskHeaderID);
     oDm.AddVarcharPara("TaskSite", 4000, TaskSite);
     return DataParser.ToList<TaskDetail>(oDm.GetTable());
 }
開發者ID:riskypathak，項目名稱:WebSpider，代碼行數:9，代碼來源:TaskDetailManager.cs

示例8: UpdateIgnitoMode

 public int UpdateIgnitoMode(Int64 TaskID, Boolean IgnitoMode)
 {
     String Query = "UPDATE TaskDetail SET IgnitoMode = @IgnitoMode, UpdatedOn = @UpdatedOn) WHERE TaskID = @TaskID";
     SqlCeDataManager oDm = new SqlCeDataManager(ConnectionString, Query, true);
     oDm.AddIntegerBigPara("TaskID", TaskID);
     oDm.AddBoolPara("IgnitoMode", IgnitoMode);
     oDm.AddDateTimePara("UpdatedOn", DateTime.Now);
     return oDm.RunActionQuery();
 }
開發者ID:riskypathak，項目名稱:WebSpider，代碼行數:9，代碼來源:TaskDetailManager.cs

示例9: UpdateStatus

 public int UpdateStatus(Int64 TaskID, String TaskStatusText, int TaskStatus)
 {
     String Query = "UPDATE TaskDetail SET TaskStatusText = @TaskStatusText, TaskStatus = @TaskStatus, UpdatedOn = @UpdatedOn WHERE TaskID = @TaskID";
     SqlCeDataManager oDm = new SqlCeDataManager(ConnectionString, Query, true);
     oDm.AddIntegerBigPara("TaskID", TaskID);
     oDm.AddVarcharPara("TaskStatusText", 4000, TaskStatusText);
     oDm.AddIntegerPara("TaskStatus", TaskStatus);
     oDm.AddDateTimePara("UpdatedOn", DateTime.Now);
     return oDm.RunActionQuery();
 }
開發者ID:riskypathak，項目名稱:WebSpider，代碼行數:10，代碼來源:TaskDetailManager.cs

示例10: Update

 public int Update(Int64 TaskID, Int64 TaskHeaderID, string TaskNameText, string TaskNameValue, string TaskStatusText, int TaskStatus, bool DownloadImages, bool IgnitoMode, string TaskType, String TaskMode, string TaskSite)
 {
     String Query = "UPDATE TaskDetail SET TaskHeaderID = @TaskHeaderID, TaskNameText = @TaskNameText, TaskNameValue = @TaskNameValue, TaskStatusText = @TaskStatusText, TaskStatus = @TaskStatus, "
         + "DownloadImages = @DownloadImages, IgnitoMode = @IgnitoMode, TaskType = @TaskType, TaskMode = @TaskMode, TaskSite = @TaskSite, UpdatedOn = @UpdatedOn WHERE TaskID = @TaskID";
     SqlCeDataManager oDm = new SqlCeDataManager(ConnectionString, Query, true);
     oDm.AddIntegerBigPara("TaskID", TaskID);
     oDm.AddIntegerBigPara("TaskHeaderID", TaskHeaderID);
     oDm.AddVarcharPara("TaskNameText", 4000, TaskNameText);
     oDm.AddVarcharPara("TaskNameValue", 4000, TaskNameValue);
     oDm.AddVarcharPara("TaskStatusText", 4000, TaskStatusText);
     oDm.AddIntegerPara("TaskStatus", TaskStatus);
     oDm.AddBoolPara("DownloadImages", DownloadImages);
     oDm.AddBoolPara("IgnitoMode", IgnitoMode);
     oDm.AddVarcharPara("TaskType", 4000, TaskType);
     oDm.AddVarcharPara("TaskMode", 4000, TaskMode);
     oDm.AddVarcharPara("TaskSite", 4000, TaskSite);
     oDm.AddDateTimePara("UpdatedOn", DateTime.Now);
     return oDm.RunActionQuery();
 }
開發者ID:riskypathak，項目名稱:WebSpider，代碼行數:19，代碼來源:TaskDetailManager.cs

示例11: Insert

 public int Insert(Int64 TaskID, Int64 TaskHeaderID, String TaskNameText, String TaskNameValue, String TaskStatusText, int TaskStatus, Boolean DownloadImages, Boolean IgnitoMode, String TaskType, String TaskMode, String TaskSite)
 {
     String Query = "INSERT INTO TaskDetail (TaskHeaderID, TaskNameText ,TaskNameValue ,TaskStatusText ,TaskStatus, DownloadImages, IgnitoMode, TaskType, TaskMode ,TaskSite ,CreatedOn, UpdatedOn) "
         + "VALUES (@TaskHeaderID, @TaskNameText ,@TaskNameValue ,@TaskStatusText ,@TaskStatus, @DownloadImages, @IgnitoMode ,@TaskType, @TaskMode ,@TaskSite ,@CreatedOn, @UpdatedOn)";
     SqlCeDataManager oDm = new SqlCeDataManager(ConnectionString, Query, true);
     oDm.AddIntegerBigPara("TaskHeaderID", TaskHeaderID);
     oDm.AddVarcharPara("TaskNameText", 4000, TaskNameText);
     oDm.AddVarcharPara("TaskNameValue", 4000, TaskNameValue);
     oDm.AddVarcharPara("TaskStatusText", 4000, TaskStatusText);
     oDm.AddIntegerPara("TaskStatus", TaskStatus);
     oDm.AddBoolPara("DownloadImages", DownloadImages);
     oDm.AddBoolPara("IgnitoMode", IgnitoMode);
     oDm.AddVarcharPara("TaskType", 4000, TaskType);
     oDm.AddVarcharPara("TaskMode", 4000, TaskMode);
     oDm.AddVarcharPara("TaskSite", 4000, TaskSite);
     oDm.AddDateTimePara("CreatedOn", DateTime.Now);
     oDm.AddDateTimePara("UpdatedOn", null);
     return oDm.RunActionQuery();
 }
開發者ID:riskypathak，項目名稱:WebSpider，代碼行數:19，代碼來源:TaskDetailManager.cs

示例12: GetDataByStatus

 public List<TaskDetail> GetDataByStatus(Int64 TaskHeaderID, Int32 TaskStatus)
 {
     String Query = "SELECT * FROM TaskDetail WHERE TaskHeaderID = @TaskHeaderID AND TaskStatus = @TaskStatus";
     SqlCeDataManager oDm = new SqlCeDataManager(ConnectionString, Query, true);
     oDm.AddIntegerBigPara("TaskHeaderID", TaskHeaderID);
     oDm.AddIntegerPara("TaskStatus", TaskStatus);
     return DataParser.ToList<TaskDetail>(oDm.GetTable());
 }
開發者ID:riskypathak，項目名稱:WebSpider，代碼行數:8，代碼來源:TaskDetailManager.cs

示例13: UpdateImageByID

 public int UpdateImageByID(Int64 ID, String SmallImage, String BigImage)
 {
     String Query = "UPDATE ADIProduct1 WITH (ROWLOCK) SET SmallImage = @SmallImage, BigImage = @BigImage WHERE ID = @ID";
     SqlCeDataManager oDm = new SqlCeDataManager(this.ConnectionString, Query, true);
     oDm.AddVarcharPara("SmallImage", 4000, SmallImage);
     oDm.AddVarcharPara("BigImage", 4000, BigImage);
     oDm.AddIntegerBigPara("ID", ID);
     return oDm.RunActionQuery();
 }
開發者ID:riskypathak，項目名稱:WebSpider，代碼行數:9，代碼來源:ADIProductManager.cs

示例14: UpdateByID

 public int UpdateByID(
     Int64 ID,
     String AdiNumber,
     String VendorName,
     String VendorNumber,
     String VendorModel,
     String PartNumber,
     String Name,
     String Url,
     String AllowedToBuy,
     String DangerousGoodsMessage,
     String InventoryMessage,
     String MarketingMessage,
     decimal? MinQty,
     String ModelNumber,
     decimal? Price,
     String ProductDescription,
     String ProductImagePath,
     String RecycleFee,
     String SaleMessageIndicator,
     String SaleType,
     String ST,
     String SMI,
     String InventoryMessageCode,
     String CatagoryID,
     String SmallImage,
     String BigImage,
     bool IsUpdating,
     int UpdateInterval,
     DateTime LastUpdateDatetime
 )
 {
     String Query = "UPDATE ADIProduct1 WITH (ROWLOCK) SET AdiNumber = @AdiNumber, VendorName = @VendorName, VendorNumber = @VendorNumber, "
         + "VendorModel = @VendorModel, PartNumber = @PartNumber, Name = @Name, Url = @Url, AllowedToBuy = @AllowedToBuy, "
         + "DangerousGoodsMessage = @DangerousGoodsMessage, InventoryMessage = @InventoryMessage, MarketingMessage = @MarketingMessage, "
         + "MinQty = @MinQty, ModelNumber = @ModelNumber, Price = @Price, ProductDescription = @ProductDescription, ProductImagePath = @ProductImagePath, "
         + "RecycleFee = @RecycleFee, SaleMessageIndicator = @SaleMessageIndicator, SaleType = @SaleType, ST = @ST, SMI = @SMI, "
         + "InventoryMessageCode = @InventoryMessageCode, CatagoryID = @CatagoryID, SmallImage = @SmallImage, BigImage = @BigImage, "
         + "IsUpdating = @IsUpdating, UpdateInterval = @UpdateInterval, LastUpdateDatetime = @LastUpdateDatetime "
         + "WHERE ID = @ID";
     SqlCeDataManager oDm = new SqlCeDataManager(this.ConnectionString, Query, true);
     oDm.AddIntegerBigPara("ID", ID);
     oDm.AddVarcharPara("AdiNumber", 4000, AdiNumber);
     oDm.AddVarcharPara("VendorName", 4000, VendorName);
     oDm.AddVarcharPara("VendorNumber", 4000, VendorNumber);
     oDm.AddVarcharPara("VendorModel", 4000, VendorModel);
     oDm.AddVarcharPara("PartNumber", 4000, PartNumber);
     oDm.AddVarcharPara("Name", 4000, Name);
     oDm.AddVarcharPara("Url", 4000, Url);
     oDm.AddVarcharPara("AllowedToBuy", 4000, AllowedToBuy);
     oDm.AddVarcharPara("DangerousGoodsMessage", 4000, DangerousGoodsMessage);
     oDm.AddVarcharPara("InventoryMessage", 4000, InventoryMessage);
     oDm.AddVarcharPara("MarketingMessage", 4000, MarketingMessage);
     oDm.AddDecimalPara("MinQty", 2, 10, MinQty);
     oDm.AddVarcharPara("ModelNumber", 4000, ModelNumber);
     oDm.AddDecimalPara("Price", 2, 10, Price);
     oDm.AddVarcharPara("ProductDescription", 4000, ProductDescription);
     oDm.AddVarcharPara("ProductImagePath", 4000, ProductImagePath);
     oDm.AddVarcharPara("RecycleFee", 4000, RecycleFee);
     oDm.AddVarcharPara("SaleMessageIndicator", 4000, SaleMessageIndicator);
     oDm.AddVarcharPara("SaleType", 4000, SaleType);
     oDm.AddVarcharPara("ST", 4000, ST);
     oDm.AddVarcharPara("SMI", 4000, SMI);
     oDm.AddVarcharPara("InventoryMessageCode", 4000, InventoryMessageCode);
     oDm.AddVarcharPara("CatagoryID", 4000, CatagoryID);
     oDm.AddVarcharPara("SmallImage", 4000, SmallImage);
     oDm.AddVarcharPara("BigImage", 4000, BigImage);
     oDm.AddBoolPara("IsUpdating", IsUpdating);
     oDm.AddIntegerPara("UpdateInterval", UpdateInterval);
     oDm.AddDateTimePara("LastUpdateDatetime", LastUpdateDatetime);
     return oDm.RunActionQuery();
 }
開發者ID:riskypathak，項目名稱:WebSpider，代碼行數:72，代碼來源:ADIProductManager.cs


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