public HttpResponseMessage deleteProduct([FromBody] PRODUCT p)
{
Result <PRODUCT> ru = new Result <PRODUCT>();
int result = 0;
try
{
result = DB_Product.deleteProduct(p);
if (result == 1)
{
ru.code = "3020";
ru.success = "true";
ru.message = "删除成功！";
}
else
{
ru.code = "3021";
ru.success = "false";
ru.message = "删除失败";
}
}
catch (Exception e) {
ru.code = "3022";
ru.success = "false";
ru.message = e.Message;
}
ru.systemTime = Conn.GetTimeStamp();
ru.data = null;
return(Conn.toJson(ru));
}
private void SearchProductInfoBtn_Click(object sender, RoutedEventArgs e)
{
string datePicker1 = DatePicker1.Text.Trim();
string datePicker2 = DatePicker2.Text.Trim();
if (datePicker1 == "" || datePicker2 == "")
{
MessageBox.Show("时间不可以为空！");
}
else
{
name.Clear();
output.Clear();
Qualified.Clear();
DataTable dt = DB_Product.searchProductInfo(datePicker1, datePicker2);
if (dt != null)
{
ProductInfo_DgSource.ItemsSource = dt.DefaultView;
ProductInfo_Page.ShowPages(ProductInfo_DgSource, dt, 9);
}
for (int i = 0; i < dt.Rows.Count; i++)
{
name.Add(dt.Rows[i][1].ToString().Trim());
output.Add(Convert.ToDouble(dt.Rows[i][2]));
Qualified.Add(Convert.ToDouble(dt.Rows[i][3]));
}
myaxis.Labels = name.ToArray();
outputline.Values = new ChartValues <double>(output);
Qualifiedline.Values = new ChartValues <double>(Qualified);
}
}
public static List <CREDIT> DataToCredit(DataTable dt)
{
List <CREDIT> list = new List <CREDIT>();
if (dt.Rows.Count > 0)
{
for (int i = 0; i < dt.Rows.Count; i++)
{
CREDIT d = new CREDIT
{
id = dt.Rows[i]["ID"].ToString(),
accounttype = dt.Rows[i]["ACCOUNTTYPE"].ToString(),
amount = dt.Rows[i]["AMOUNT"].ToString(),
paytype = dt.Rows[i]["PAYTYPE"].ToString(),
date = dt.Rows[i]["DATE"].ToString(),
pid = dt.Rows[i]["PID"].ToString(),
cid = dt.Rows[i]["CID"].ToString(),
uid = dt.Rows[i]["UID"].ToString(),
count = dt.Rows[i]["COUNT"].ToString(),
customer = DB_Customer.C_Customer(dt.Rows[i]["CID"].ToString()),
product = DB_Product.C_Product(dt.Rows[i]["PID"].ToString())
};
list.Add(d);
}
}
return(list);
}
public bool Buy(int id, int userid)
{
DB_Product product = db.Products.GetItem(id);
DB_User user = db.Users.GetItem(userid);
if (product == null || user == null)
{
throw new ArgumentNullException();
}
foreach (DB_Product p in user.Products)
{
if (p == product)
{
return(false);
}
else
{
user.Products.Add(product);
db.Users.Update(user);
db.Save();
return(true);
}
}
return(false);
}
public HttpResponseMessage queryProductAll()
{
Result <PRODUCT> ru = new Result <PRODUCT>();
List <PRODUCT> lproduct = new List <PRODUCT>();
try
{
lproduct = DB_Product.getProduct();
if (lproduct.Count > 0)
{
ru.code = "3030";
ru.success = "true";
ru.message = "获取成功！";
}
else
{
ru.code = "3031";
ru.success = "false";
ru.message = "无数据";
}
}
catch (Exception e)
{
ru.code = "3032";
ru.success = "false";
ru.message = e.Message;
}
ru.systemTime = Conn.GetTimeStamp();
ru.data = lproduct;
return(Conn.toJson(ru));
}
private void Start()
{
DontDestroyOnLoad(gameObject);
apps = FindObjectOfType <AppMessage>();
users = FindObjectOfType <DB_User>();
products = FindObjectOfType <DB_Product>();
countries = FindObjectOfType <DB_Country>();
product_groups = FindObjectOfType <DB_ProductGroup>();
scene_history = FindObjectOfType <SceneHistory>();
scene = SceneManager.GetActiveScene();
Initialized();
}
public void TestGetProduct()
{
Data();
List <DB_Product> products = new List <DB_Product>();
DB_Product p1 = new DB_Product();
products.Add(p1);
mockConteiner.Setup(a => a.Products).Returns(mockProducts.Object);
mockProducts.Setup(a => a.Get()).Returns(products);
Product result = new Product();
result = Mapper.Map <DB_Product, Product>(p1);
NUnit.Framework.Assert.AreEqual(result.ProductID, ProdO.GetProduct(0).ProductID);
}
public void Initialize()
{
db_product = DB_Product.GetInstance();
db_order = DB_Order.GetInstance();
db_orderdetail = DB_OrderDetail.GetInstance();
db_user = DBCustomUser.GetInstance();
int index = 0;
//Creates test user
user = new CustomUser
{
Username = "******",
Password = "******",
Email = "ClassLibrary1 - Test OrderDetail Database - User",
Wallet = 5000000.0,
};
db_user.CreateUser(user);
//loop for test products and test orders.
while (index < 100)
{
//Creates test product
Product product = new Product
{
Name = "ClassLibrary1 - Test OrderDetail Database - Product",
Price = 1500.0
};
//creates test order.
Order order = new Order
{
Price = 100.0,
IsShipped = true,
Username = user.Username
};
db_order.CreateOrder(order);
db_product.CreateProduct(product);
index++;
}
products = db_product.FindProductByName("ClassLibrary1 - Test OrderDetail Database - Product");
orders = db_order.FindOrderByUsername(user.Username);
orderdetails = new List <OrderDetail>();
}
public void TestCheckPost()
{
Mapper_Config.Initialize();
Data();
List <DB_Product> products = new List <DB_Product>();
DB_Product p1 = new DB_Product();
DB_Product p2 = new DB_Product();
products.Add(p1);
products.Add(p2);
mockConteiner.Setup(a => a.Products).Returns(mockProducts.Object);
mockProducts.Setup(a => a.Get()).Returns(products);
List <Product> result = new List <Product>();
result = Mapper.Map <List <DB_Product>, List <Product> >(products);
NUnit.Framework.Assert.AreEqual(true, ProdO.CheckCode(null));
}
public void TestGetProducts()
{
Mapper_Config.Initialize();
Data();
List <DB_Product> products = new List <DB_Product>();
DB_Product p1 = new DB_Product();
DB_Product p2 = new DB_Product();
products.Add(p1);
products.Add(p2);
mockConteiner.Setup(a => a.Products).Returns(mockProducts.Object);
mockProducts.Setup(a => a.Get()).Returns(products);
List <Product> result = new List <Product>();
result = Mapper.Map <List <DB_Product>, List <Product> >(products);
NUnit.Framework.Assert.AreEqual(result.Capacity, ProdO.GetAllProducts().Capacity);
}
public void EditProduct(Product product)
{
var newProduct = new DB_Product()
{
Name = product.Name,
Size = product.Size,
Image = product.Image,
Colour = product.Colour,
Material = product.Material,
Brend = product.Brend,
Season = product.Season,
Price = product.Price,
Category = db.Categories.GetItem(product.CategoryID),
CategoryID = product.CategoryID
};
db.Categories.Update(db.Categories.GetItem(product.CategoryID));
db.Products.Update(newProduct);
db.Save();
}
public void CreateProduct(Product product, int catid)
{
Category category = Mapper.Map <DB_Category, Category>(db.Categories.GetItem(catid));
var newProduct = new DB_Product()
{
Name = product.Name,
Size = product.Size,
Image = product.Image,
Colour = product.Colour,
Material = product.Material,
Brend = product.Brend,
Season = product.Season,
Price = product.Price,
Category = db.Categories.GetItem(catid),
CategoryID = catid
};
db.Products.Create(newProduct);
category.Products.Add(product);
db.Products.Update(newProduct);
db.Save();
}
public void Initialize()
{
int index = 0;
int max_index = 100;
db_user = DBCustomUser.GetInstance();
db_product = DB_Product.GetInstance();
db_userproduct = DB_UserProduct.GetInstance();
Product product;
user = new CustomUser
{
Username = "******",
Password = "******",
Email = "ClassLibriry1 - Test UserProduct Database - User",
Wallet = 5000.0,
IsActive = true,
LoggedIn = true
};
db_user.CreateUser(user);
while (index < max_index)
{
product = new Product
{
Name = "ClassLibriry1 - Test UserProduct Database - Product",
Price = 50.0 + (double)index
};
db_product.CreateProduct(product);
index++;
}
products = db_product.FindProductByPriceHigher(25.0);
}
/// <summary>
/// This is the constructor for the class CTR_Product.
/// </summary>
public CTR_Product()
{
this.db_product = DB_Product.GetInstance();
}
public void Initialize()
{
db_product = DB_Product.GetInstance();
product_price = 1000.0;
}
