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


C# SqlCeDataManager.AddDecimalPara方法代碼示例

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


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

示例1: 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

示例2: 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();
 }
開發者ID:riskypathak,項目名稱:WebSpider,代碼行數:71,代碼來源:ADIProductManager.cs


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