C# SqlCeDataManager.RunActionQuery方法代码示例

 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();
 }

 private int Insert(String ManufacturerCode, InManufacturerSeries manufacturer)
 {
     String Query = "INSERT INTO [SecLockManufacturerSeries]([ManufacturerCode],[Name]) VALUES('"
         +  ManufacturerCode + "','" + manufacturer.Name + "');";
     SqlCeDataManager oDm = new SqlCeDataManager(this.ConnectionString, Query, true);
     return oDm.RunActionQuery();
 }

 public void GenerateScheduleNextRun()
 {
     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())";
     oDm = new SqlCeDataManager(this.ConnectionString, Query, true);
     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())";
     oDm = new SqlCeDataManager(this.ConnectionString, Query, true);
     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())";
     oDm = new SqlCeDataManager(this.ConnectionString, Query, true);
     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())";
     oDm = new SqlCeDataManager(this.ConnectionString, Query, true);
     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())";
     oDm = new SqlCeDataManager(this.ConnectionString, Query, true);
     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())";
     oDm = new SqlCeDataManager(this.ConnectionString, Query, true);
     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())";
     oDm = new SqlCeDataManager(this.ConnectionString, Query, true);
     oDm.RunActionQuery();
 }

 public int DeleteByPart(String AdiNumber)
 {
     String Query = "DELETE FROM ADIInventory WHERE AdiNumber = @AdiNumber";
     SqlCeDataManager oDm = new SqlCeDataManager(ConnectionString, Query, true);
     oDm.AddVarcharPara("AdiNumber", 4000, AdiNumber);
     return oDm.RunActionQuery();
 }

 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();
 }

 private int Update(String ManufacturerCode, InManufacturerSeries manufacturer)
 {
     String Query = "UPDATE [SecLockManufacturerSeries] SET [Name] = '" + manufacturer.Name
         + "',[ManufacturerCode] = '" + ManufacturerCode
         + "' WHERE [Name] = '" + manufacturer.Name + "'";
     SqlCeDataManager oDm = new SqlCeDataManager(this.ConnectionString, Query, true);
     return oDm.RunActionQuery();
 }

 public int Insert(String PART_NUM, String PropertyName, String PropertyValue)
 {
     String Query = "INSERT INTO [ADIChild] WITH (ROWLOCK) ([PART_NUM],[PropertyName],[PropertyValue])VALUES(@PART_NUM, @PropertyName, @PropertyValue)";
     SqlCeDataManager oDm = new SqlCeDataManager(this.ConnectionString, Query, true);
     oDm.AddVarcharPara("PART_NUM", 4000, PART_NUM);
     oDm.AddVarcharPara("PropertyName", 4000, PropertyName);
     oDm.AddVarcharPara("PropertyValue", 4000, PropertyValue);
     return oDm.RunActionQuery();
 }

 public void GenerateExport()
 {
     String Query = "INSERT INTO [ADICategoryExport] ([RootValue] ,[RootDisplayName] ,[ParentValue] ,[ParentDisplayName] ,[Value] ,[DisplayName] ,[CategoryUrl]) "
         + "SELECT ROOT.[Value] ,ROOT.[DisplayName] ,PARENT.[Value] ,PARENT.[DisplayName] ,CHILD.[Value] ,CHILD.[DisplayName] ,CHILD.[CategoryUrl] "
         + "FROM [ADICategory] ROOT WITH (NOLOCK) JOIN [ADICategory] PARENT  WITH (NOLOCK) ON ROOT.[Value] = PARENT.[ParentValue] "
         + "JOIN [ADICategory] CHILD WITH (NOLOCK) ON PARENT.[Value] = CHILD.[ParentValue] "
         + "WHERE ROOT.[ParentValue] IS NULL";
     SqlCeDataManager oDm = new SqlCeDataManager(this.ConnectionString, Query, true);
     oDm.RunActionQuery();
 }

 public int Insert(String ExportSite, String ExportType, String ExportValue)
 {
     String Query = "INSERT INTO FinalExport (ExportSite, ExportType, ExportValue, CreatedDate) "
         + "VALUES (@ExportSite, @ExportType, @ExportValue, @CreatedDate)";
     SqlCeDataManager oDm = new SqlCeDataManager(ConnectionString, Query, true);
     oDm.AddVarcharPara("ExportSite", 4000, ExportSite);
     oDm.AddVarcharPara("ExportType", 4000, ExportType);
     oDm.AddVarcharPara("ExportValue", 4000, ExportValue);
     oDm.AddDateTimePara("CreatedDate", DateTime.Now);
     return oDm.RunActionQuery();
 }

 public int Delete(String ExportSite, String ExportType, String ExportValue, DateTime CreatedDate)
 {
     String Query = "DELETE FROM FinalExport WHERE "
         + "ExportSite = @ExportSite AND ExportType = @ExportType AND ExportValue = @ExportValue AND CreatedDate = @CreatedDate";
     SqlCeDataManager oDm = new SqlCeDataManager(ConnectionString, Query, true);
     oDm.AddVarcharPara("ExportSite", 4000, ExportSite);
     oDm.AddVarcharPara("ExportType", 4000, ExportType);
     oDm.AddVarcharPara("ExportValue", 4000, ExportValue);
     oDm.AddDateTimePara("CreatedDate", CreatedDate);
     return oDm.RunActionQuery();
 }

 private int Insert(InProduct product)
 {
     String Query = "INSERT INTO [SecLockProduct] ([Code] ,[Name] ,[Url] ,[ManufacturerCode],[ManufacturerName],[ManufacturerSeries],[CategoyCode],[CategoryName], [YourPrice] ,[ListPrice] ,[ImageUrl1],[ImageUrl2] ,[Stock] ,[Description] ,[TechDoc]) "
         + "VALUES ('" + product.Code + "' ,'" + product.Name + "' ,'" + product.Url + "' ,'"
         + product.ManufacturerCode +"', '"+ product.ManufacturerName +"', '"+ product.ManufacturerSeries +"',  '"
         + product.CategoyCode +"', '"+ product.CategoryName +"', '"
         + product.YourPrice + "' ,'" + product.ListPrice + "' ,'" + product.ImageUrl1 + "' ,'" + product.ImageUrl2 + "', '"
         + product.Stock + "' ,'" + (String.IsNullOrEmpty(product.Description) ? String.Empty : product.Description.Replace("\'", "\'\'"))
         + "' ,'" + (String.IsNullOrEmpty(product.TechDoc) ? String.Empty : product.TechDoc.Replace("'", "''")) + "')";
     SqlCeDataManager oDm = new SqlCeDataManager(this.ConnectionString, Query, true);
     return oDm.RunActionQuery();
 }

 public int Insert(String PART_NUM, int TotalInventory, int Dallas, int DC_AtlantaHub, int DC_Dallas_Hub, int DC_Elk_Grove_Hub, int DC_Feura_Bush, int DC_Louisville_Hub
     , int DC_Reno_Hub, int DC_Richmond_Dist_Ctr, int Oklahama, int RemainingBranches, DateTime LastUpdate)
 {
     String Query = "INSERT INTO ADIInventoryExport WITH (ROWLOCK) (PART_NUM, TotalInventory, Dallas, DC_AtlantaHub, DC_Dallas_Hub, DC_Elk_Grove_Hub, DC_Feura_Bush, DC_Louisville_Hub, DC_Reno_Hub, DC_Richmond_Dist_Ctr, Oklahama, RemainingBranches, LastUpdate) "
      + "VALUES (@PART_NUM, @TotalInventory, @Dallas, @DC_AtlantaHub, @DC_Dallas_Hub, @DC_Elk_Grove_Hub, @DC_Feura_Bush, @DC_Louisville_Hub, @DC_Reno_Hub, @DC_Richmond_Dist_Ctr, @Oklahama, @RemainingBranches, @LastUpdate)";
     SqlCeDataManager oDm = new SqlCeDataManager(this.ConnectionString, Query, true);
     oDm.AddVarcharPara("PART_NUM", 4000, PART_NUM);
     oDm.AddIntegerPara("TotalInventory", TotalInventory);
     oDm.AddIntegerPara("Dallas", Dallas);
     oDm.AddIntegerPara("DC_AtlantaHub", DC_AtlantaHub);
     oDm.AddIntegerPara("DC_Dallas_Hub", DC_Dallas_Hub);
     oDm.AddIntegerPara("DC_Elk_Grove_Hub", DC_Elk_Grove_Hub);
     oDm.AddIntegerPara("DC_Feura_Bush", DC_Feura_Bush);
     oDm.AddIntegerPara("DC_Louisville_Hub", DC_Louisville_Hub);
     oDm.AddIntegerPara("DC_Reno_Hub", DC_Reno_Hub);
     oDm.AddIntegerPara("DC_Richmond_Dist_Ctr", DC_Richmond_Dist_Ctr);
     oDm.AddIntegerPara("Oklahama", Oklahama);
     oDm.AddIntegerPara("RemainingBranches", RemainingBranches);
     oDm.AddDateTimePara("LastUpdate", LastUpdate);
     return oDm.RunActionQuery();
 }

 public int StockAvailability()
 {
     String Query = "UPDATE ADICategory WITH (ROWLOCK) SET InStock = 0 ";
     SqlCeDataManager oDm = new SqlCeDataManager(this.ConnectionString, Query, true);
     return oDm.RunActionQuery();
 }

 public int SetStockAvailability(String Value)
 {
     String Query = "UPDATE ADICategory WITH (ROWLOCK) SET InStock = 1 WHERE Value = @Value";
     SqlCeDataManager oDm = new SqlCeDataManager(this.ConnectionString, Query, true);
     oDm.AddVarcharPara("Value", 4000, Value);
     return oDm.RunActionQuery();
 }

 public int SetOnlineSpecialsByCategoryValue(String Value)
 {
     String Query = "UPDATE ADICategory WITH (ROWLOCK) SET OnlineSpecials = 1 WHERE Value = @Value";
     SqlCeDataManager oDm = new SqlCeDataManager(this.ConnectionString, Query, true);
     oDm.AddVarcharPara("Value", 4000, Value);
     return oDm.RunActionQuery();
 }