本文整理汇总了C#中DataBase.ItemInsert方法的典型用法代码示例。如果您正苦于以下问题：C# DataBase.ItemInsert方法的具体用法？C# DataBase.ItemInsert怎么用？C# DataBase.ItemInsert使用的例子？那么恭喜您, 这里精选的方法代码示例或许可以为您提供帮助。您也可以进一步了解该方法所在类DataBase的用法示例。
在下文中一共展示了DataBase.ItemInsert方法的5个代码示例，这些例子默认根据受欢迎程度排序。您可以为喜欢或者感觉有用的代码点赞，您的评价将有助于系统推荐出更棒的C#代码示例。
示例1: GetItemByType
public void GetItemByType()
{
DataBase dataBase = new DataBase();
string itemTypeName1 = Guid.NewGuid().ToString();
string itemTypeName2 = Guid.NewGuid().ToString();
string itemTypeName3 = Guid.NewGuid().ToString();
int rowsInserted =
dataBase.ItemTypeInsert(new ItemType {Name = itemTypeName1, Description = "item type description 1",});
Assert.AreEqual(1, rowsInserted);
rowsInserted =
dataBase.ItemTypeInsert(new ItemType {Name = itemTypeName2, Description = "item type description 2",});
Assert.AreEqual(1, rowsInserted);
rowsInserted =
dataBase.ItemTypeInsert(new ItemType {Name = itemTypeName3, Description = "item type description 3",});
Assert.AreEqual(1, rowsInserted);
List<ItemType> itemTypes = dataBase.ItemTypeGetAll();
string itemName1 = Guid.NewGuid().ToString();
string itemName2 = Guid.NewGuid().ToString();
string itemName3 = Guid.NewGuid().ToString();
int itemTypeId1 = itemTypes.Find(n => n.Name == itemTypeName1).Id;
int itemTypeId2 = itemTypes.Find(n => n.Name == itemTypeName2).Id;
int itemTypeId3 = itemTypes.Find(n => n.Name == itemTypeName3).Id;
rowsInserted =
dataBase.ItemInsert(new Item
{
Name = itemName1,
Description = "item description 1",
ItemTypeId = itemTypeId1,
});
Assert.AreEqual(1, rowsInserted);
rowsInserted =
dataBase.ItemInsert(new Item
{
Name = itemName2,
Description = "item description 2",
ItemTypeId = itemTypeId2,
});
Assert.AreEqual(1, rowsInserted);
rowsInserted =
dataBase.ItemInsert(new Item
{
Name = itemName3,
Description = "item description 3",
ItemTypeId = itemTypeId2,
});
Assert.AreEqual(1, rowsInserted);
List<Item> items = dataBase.ItemGetByType(itemTypeId1);
Assert.IsNotNull(items);
Assert.IsTrue(items.Count == 1, "Expected: {0}, Actual:{1}", 1, items.Count);
items = dataBase.ItemGetByType(itemTypeId2);
Assert.IsNotNull(items);
Assert.IsTrue(items.Count == 2, "Expected: {0}, Actual:{1}", 2, items.Count);
items = dataBase.ItemGetByType(itemTypeId3);
Assert.IsNotNull(items);
Assert.IsTrue(items.Count == 0, "Expected: {0}, Actual:{1}", 0, items.Count);
}示例2: OrderGetAll
public void OrderGetAll()
{
DataBase dataBase = new DataBase();
string itemTypeName = Guid.NewGuid().ToString();
ItemType itemType = new ItemType {Name = itemTypeName,};
dataBase.ItemTypeInsert(itemType);
ItemType itemTypeGet = dataBase.ItemTypeGet(itemTypeName);
Assert.IsNotNull(itemTypeGet);
string itemName = Guid.NewGuid().ToString();
Item item = new Item
{
Name = itemName,
ItemTypeId = itemTypeGet.Id,
};
dataBase.ItemInsert(item);
Item itemGet = dataBase.ItemGet(itemName);
Assert.IsNotNull(itemGet);
string itemStatusName = Guid.NewGuid().ToString();
ItemStatus itemStatus = new ItemStatus {Name = itemStatusName};
dataBase.ItemStatusInsert(itemStatus);
ItemStatus itemStatusGet = dataBase.ItemStatusGet(itemStatusName);
Assert.IsNotNull(itemStatusGet);
string personInfoName = Guid.NewGuid().ToString();
string personInfoSurName = Guid.NewGuid().ToString();
PersonInfo personInfo = new PersonInfo {Name = personInfoName, SurName = personInfoSurName,};
dataBase.PersonInfoInsert(personInfo);
PersonInfo personInfoGet = dataBase.PersonInfoGet(personInfoName, personInfoSurName);
Assert.IsNotNull(personInfoGet);
Order order = new Order
{
ItemId = itemGet.Id,
Count = 1,
ItemStatusId = itemStatusGet.Id,
LegalEntity = true,
PersonInfoId = personInfoGet.Id,
Postage = 0M.DecimalToString(),
Price = 1M.DecimalToString(),
BankId = -1,
};
int rowsInserted = dataBase.OrderInsert(order);
Assert.AreEqual(1, rowsInserted);
List<Order> orders = dataBase.OrderGetAll();
Assert.IsNotNull(orders);
Order find = orders.Find(o => o.ItemId == itemGet.Id);
Assert.IsNotNull(find);
}示例3: UpdateItem
public void UpdateItem()
{
DataBase dataBase = new DataBase();
string name = Guid.NewGuid().ToString();
Item item = new Item
{
Name = name,
Description = Guid.NewGuid().ToString(),
ItemTypeId = 0,
Image = new byte[] {1, 2, 3, 4, 5},
};
int rowsInserted = dataBase.ItemInsert(item);
Assert.AreEqual(1, rowsInserted);
List<Item> items = dataBase.ItemGetAll(@"SELECT Id, Name, Description, ItemType, Image FROM Item");
Assert.IsNotNull(items);
Item find = items.Find(i => i.Name == name);
Assert.IsNotNull(find);
string newName = Guid.NewGuid().ToString();
find.Name = newName;
int rowsUpdated = dataBase.ItemUpdate(find);
Assert.AreEqual(1, rowsUpdated);
Item updatedItem = dataBase.ItemGet(find.Id);
Assert.AreEqual(newName, updatedItem.Name);
Assert.AreEqual(item.Description, updatedItem.Description);
Assert.AreEqual(item.ItemTypeId, updatedItem.ItemTypeId);
}示例4: ItemGetByName
public void ItemGetByName()
{
DataBase dataBase = new DataBase();
string name = Guid.NewGuid().ToString();
Item item = new Item
{
Name = name,
ItemTypeId = 0,
};
int rowsInserted = dataBase.ItemInsert(item);
Assert.AreEqual(1, rowsInserted);
Item itemGet = dataBase.ItemGet(name);
Assert.IsNotNull(itemGet);
}示例5: InsertItemWitPicture
public void InsertItemWitPicture()
{
DataBase dataBase = new DataBase();
string name = Guid.NewGuid().ToString();
const string imagePath = "Untitled.png";
byte[] imageData = Misc.GetImageData(imagePath);
Assert.IsNotNull(imageData, "No image '{0}'!", imagePath);
Item item = new Item
{
Name = name,
Description = Guid.NewGuid().ToString(),
ItemTypeId = 0,
Image = imageData,
};
int rowsInserted = dataBase.ItemInsert(item);
Assert.AreEqual(1, rowsInserted);
List<Item> items = dataBase.ItemGetAll(@"SELECT Id, Name, Description, ItemType, Image FROM Item");
Assert.IsNotNull(items, "Ites is null");
Item find = items.Find(i => i.Name == name);
Assert.IsNotNull(find, "Item {0} not found!", name);
Assert.AreEqual(imageData.Length, find.Image.Length, "Wrong Image!");
}