C# SqlCeDataManager.AddDateTimePara方法代码示例

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

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

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

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

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

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

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

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

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

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

 public int Update(String AdiNumber, String id, String dc, String region, String storeName, String address1, String address2, String address3, 
     String country, String city, String state, String stateName, String zip, String phone, String fax, float? lat, float? lon, String inventory, 
     String manager, String responseCode, String responseMessage, Boolean IsHub)
 {
     String Query = "UPDATE ADIInventory  SET dc = @dc ,region = @region ,storeName = @storeName ,address1 = @address1 ,address2 = @address2 ,address3 = @address3 "
         + ",country = @country ,city = @city ,state = @state ,stateName = @stateName ,zip = @zip ,phone = @phone ,fax = @fax ,lat = @lat ,lon = @lon "
         + ",inventory = @inventory ,manager = @manager ,responseCode = @responseCode ,responseMessage = @responseMessage ,IsHub = @IsHub "
         + ",LastUpdate = @LastUpdate WHERE AdiNumber = @AdiNumber AND id = @id";
     SqlCeDataManager oDm = new SqlCeDataManager(ConnectionString, Query, true);
     oDm.AddVarcharPara("AdiNumber", 4000, AdiNumber);
     oDm.AddVarcharPara("id", 4000, id);
     oDm.AddVarcharPara("dc", 4000, dc);
     oDm.AddVarcharPara("region", 4000, region);
     oDm.AddVarcharPara("storeName", 4000, storeName);
     oDm.AddVarcharPara("address1", 4000, address1);
     oDm.AddVarcharPara("address2", 4000, address2);
     oDm.AddVarcharPara("address3", 4000, address3);
     oDm.AddVarcharPara("country", 4000, country);
     oDm.AddVarcharPara("city", 4000, city);
     oDm.AddVarcharPara("state", 4000, state);
     oDm.AddVarcharPara("stateName", 4000, stateName);
     oDm.AddVarcharPara("zip", 4000, zip);
     oDm.AddVarcharPara("phone", 4000, phone);
     oDm.AddVarcharPara("fax", 4000, fax);
     oDm.AddFloatPara("lat", lat);
     oDm.AddFloatPara("lon", lon);
     oDm.AddVarcharPara("inventory", 4000, inventory);
     oDm.AddVarcharPara("manager", 4000, manager);
     oDm.AddVarcharPara("responseCode", 4000, responseCode);
     oDm.AddVarcharPara("responseMessage", 4000, responseMessage);
     oDm.AddBoolPara("IsHub", IsHub);
     oDm.AddDateTimePara("LastUpdate", DateTime.Now);
     return oDm.RunActionQuery();
 }

 public int Insert(String AdiNumber, String id, String dc, String region, String storeName, String address1, String address2, String address3
     , String country, String city, String state, String stateName, String zip, String phone, String fax, float? lat, float? lon, String inventory
     , String manager, String responseCode, String responseMessage, Boolean IsHub)
 {
     String Query = "INSERT INTO ADIInventory (AdiNumber, id ,dc ,region ,storeName ,address1 ,address2 ,address3 ,country ,city ,state ,stateName ,zip ,phone ,fax ,lat ,lon ,inventory ,manager ,responseCode ,responseMessage ,IsHub, LastUpdate) "
         + "VALUES (@AdiNumber, @id ,@dc ,@region ,@storeName ,@address1 ,@address2 ,@address3 ,@country ,@city ,@state ,@stateName ,@zip ,@phone ,@fax ,@lat ,@lon ,@inventory ,@manager ,@responseCode ,@responseMessage ,@IsHub, @LastUpdate)";
     SqlCeDataManager oDm = new SqlCeDataManager(ConnectionString, Query, true);
     oDm.AddVarcharPara("AdiNumber", 4000, AdiNumber);
     oDm.AddVarcharPara("id", 4000, id);
     oDm.AddVarcharPara("dc", 4000, dc);
     oDm.AddVarcharPara("region", 4000, region);
     oDm.AddVarcharPara("storeName", 4000, storeName);
     oDm.AddVarcharPara("address1", 4000, address1);
     oDm.AddVarcharPara("address2", 4000, address2);
     oDm.AddVarcharPara("address3", 4000, address3);
     oDm.AddVarcharPara("country", 4000, country);
     oDm.AddVarcharPara("city", 4000, city);
     oDm.AddVarcharPara("state", 4000, state);
     oDm.AddVarcharPara("stateName", 4000, stateName);
     oDm.AddVarcharPara("zip", 4000, zip);
     oDm.AddVarcharPara("phone", 4000, phone);
     oDm.AddVarcharPara("fax", 4000, fax);
     oDm.AddFloatPara("lat", lat);
     oDm.AddFloatPara("lon", lon);
     oDm.AddVarcharPara("inventory", 4000, inventory);
     oDm.AddVarcharPara("manager", 4000, manager);
     oDm.AddVarcharPara("responseCode", 4000, responseCode);
     oDm.AddVarcharPara("responseMessage", 4000, responseMessage);
     oDm.AddBoolPara("IsHub", IsHub);
     oDm.AddDateTimePara("LastUpdate", DateTime.Now);
     return oDm.RunActionQuery();
 }