本文整理匯總了C#中WebSpider.Data.DatabaseManager.SqlCeDataManager.AddIntegerPara方法的典型用法代碼示例。如果您正苦於以下問題:C# SqlCeDataManager.AddIntegerPara方法的具體用法?C# SqlCeDataManager.AddIntegerPara怎麽用?C# SqlCeDataManager.AddIntegerPara使用的例子?那麽, 這裏精選的方法代碼示例或許可以為您提供幫助。您也可以進一步了解該方法所在類WebSpider.Data.DatabaseManager.SqlCeDataManager
的用法示例。
在下文中一共展示了SqlCeDataManager.AddIntegerPara方法的12個代碼示例,這些例子默認根據受歡迎程度排序。您可以為喜歡或者感覺有用的代碼點讚,您的評價將有助於係統推薦出更棒的C#代碼示例。
示例1: GetDataBySite
public List<TaskDetail> GetDataBySite(Int64 TaskHeaderID, String TaskSite, Int32 TaskStatus)
{
String Query = "SELECT * FROM TaskDetail WHERE TaskSite = @TaskSite AND TaskStatus = @TaskStatus";
SqlCeDataManager oDm = new SqlCeDataManager(ConnectionString, Query, true);
oDm.AddVarcharPara("TaskSite", 4000, TaskSite);
oDm.AddIntegerPara("TaskStatus", TaskStatus);
return DataParser.ToList<TaskDetail>(oDm.GetTable());
}
示例2: UpdateByPartNum
public int UpdateByPartNum(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 = "UPDATE ADIInventoryExport WITH (ROWLOCK) SET TotalInventory = @TotalInventory, Dallas = @Dallas, DC_AtlantaHub = @DC_AtlantaHub, DC_Dallas_Hub = @DC_Dallas_Hub, DC_Elk_Grove_Hub = @DC_Elk_Grove_Hub, DC_Feura_Bush = @DC_Feura_Bush, DC_Louisville_Hub = @DC_Louisville_Hub, DC_Reno_Hub = @DC_Reno_Hub,DC_Richmond_Dist_Ctr = @DC_Richmond_Dist_Ctr, Oklahama = @Oklahama, RemainingBranches = @RemainingBranches, LastUpdate = @LastUpdate WHERE PART_NUM = @PART_NUM";
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();
}
示例3: 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();
}
示例4: Insert
public int Insert(Int64 ScheduleID, String TaskName, String TaskDescription, String Site, DateTime ScheduleFrom
, Boolean TaskRepeat, Int32 TaskRepeatInterval, String TaskRepeatUnit, Boolean Enabled)
{
String Query = "INSERT INTO [TaskHeader] ([TaskName], [TaskDescription], [Site], [ScheduleFrom], [TaskRepeat], [TaskRepeatInterval], [TaskRepeatUnit], [Enabled], [CreatedDate]) "
+ "VALUES (@TaskName, @TaskDescription, @Site, @ScheduleFrom, @TaskRepeat, @TaskRepeatInterval, @TaskRepeatUnit, @Enabled, @CreatedDate);";
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);
oDm.AddDateTimePara("CreatedDate", DateTime.Now);
return oDm.RunActionQuery();
}
示例5: 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();
}
示例6: 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();
}
示例7: 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();
}
示例8: Insert
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();
}
示例9: 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();
}
示例10: SetUpdateInterval
public int SetUpdateInterval(String AdiNumber, int UpdateInterval)
{
String Query = "UPDATE ADIProduct1 WITH (ROWLOCK) SET UpdateInterval = @UpdateInterval WHERE AdiNumber = @AdiNumber";
SqlCeDataManager oDm = new SqlCeDataManager(this.ConnectionString, Query, true);
oDm.AddVarcharPara("AdiNumber", 4000, AdiNumber);
oDm.AddIntegerPara("UpdateInterval", UpdateInterval);
return oDm.RunActionQuery();
}
示例11: SetProductPriority
public int SetProductPriority(String AdiNumber, Boolean PriorityProduct, Int32 LeastCount)
{
String Query = "UPDATE ADIProduct1 WITH (ROWLOCK) SET PriorityProduct = @PriorityProduct, LeastCount = @LeastCount WHERE AdiNumber = @AdiNumber";
SqlCeDataManager oDm = new SqlCeDataManager(this.ConnectionString, Query, true);
oDm.AddVarcharPara("AdiNumber", 4000, AdiNumber);
oDm.AddBoolPara("PriorityProduct", PriorityProduct);
oDm.AddIntegerPara("LeastCount", LeastCount);
return oDm.RunActionQuery();
}
示例12: InsertNew
public int InsertNew(
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 = "INSERT INTO ADIProduct1 WITH (ROWLOCK) (AdiNumber, VendorName, VendorNumber, VendorModel, PartNumber, Name, "
+ "Url, AllowedToBuy, DangerousGoodsMessage, InventoryMessage, MarketingMessage, MinQty, ModelNumber, Price, ProductDescription, "
+ "ProductImagePath, RecycleFee, SaleMessageIndicator, SaleType, ST, SMI, InventoryMessageCode, CatagoryID, SmallImage, BigImage, "
+ "IsUpdating, UpdateInterval, LastUpdateDatetime) "
+ "VALUES ( @AdiNumber, @VendorName, @VendorNumber, @VendorModel, @PartNumber, @Name, "
+ "@Url, @AllowedToBuy, @DangerousGoodsMessage, @InventoryMessage, @MarketingMessage, @MinQty, @ModelNumber, @Price, @ProductDescription, "
+ "@ProductImagePath, @RecycleFee, @SaleMessageIndicator, @SaleType, @ST, @SMI, @InventoryMessageCode, @CatagoryID, @SmallImage, @BigImage, "
+ "@IsUpdating, @UpdateInterval, @LastUpdateDatetime)";
SqlCeDataManager oDm = new SqlCeDataManager(this.ConnectionString, Query, true);
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();
}