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