//InsertProduct
private void button12_Click(object sender, EventArgs e)
{
textBox1.Text = "Product";
Product product = new Product();
product.Id = 2;
product.ProductSn = "Product test" + System.DateTime.Now.ToString();
product.ProductName = "������";
product.Remark = "ûʲô��д��";
MessageBox.Show(dba.InsertProductFull(product));
}
public ProductInventoryEntry(Product product, int quantity)
{
try
{
Name = product.Name;
Price = product.Price;
Cost = product.Cost;
Quantity = quantity;
}
catch (ArgumentNullException)
{
Debug.WriteLine("ERROR: Invalid arguments to construct ProductInventoryEntry");
}
}
//У���Ƿ��в�Ʒ����һ���ģ� true-ͨ�����ԣ�û�����Ƶ�,false-û��ͨ�����ԣ������Ƶ�
public bool CheckProduct(Product product)
{
command.CommandText = "SELECT * FROM Product where ProductSn = '" + product.ProductSn + "'";
SQLiteDataAdapter da = new SQLiteDataAdapter(command);
DataTable dt = new DataTable("Product");
da.Fill(dt);
if (dt.Rows.Count > 0)
{
return false;
}
else
{
return true;
}
}
//SelectProduct
private void button13_Click_1(object sender, EventArgs e)
{
textBox1.Text = "Product";
Product product = new Product();
product.Id = 2;
product.ProductSn = "Product test" + System.DateTime.Now.ToString();
product.ProductName = "������";
product.Remark = "ûʲô��д��";
//MessageBox.Show(product.ToString());
MessageBox.Show(dba.SelectProduct(product).Rows[0][0].ToString());
MessageBox.Show(dba.SelectProductToClass(product).ToString());
List<Product> listProduct = new List<Product>();
listProduct = dba.SelectProductAllToList();
for (int i = 0; i < listProduct.Count; i++)
{
MessageBox.Show(listProduct[i].ToString());
}
}
//���²�Ʒ
public string UpdateProduct(Product product)
{
DataTable dt = new DataTable();
dt = SelectProduct(product);
if (dt.Rows.Count == 1)
{
dt.Rows[0][0] = product.Id;
dt.Rows[0][1] = product.ProductSn;
dt.Rows[0][2] = product.ProductName;
dt.Rows[0][3] = product.Remark;
dt.Rows[0][4] = product.UnitPerBox;
}
return UpdateTable(dt, "Product");
}
//��ѯij����Ʒ��Ϣ
public Product SelectProductToClass(Product product)
{
command.CommandText = "SELECT * FROM Product where Id = '" + product.Id + "'";
SQLiteDataAdapter da = new SQLiteDataAdapter(command);
DataTable dt = new DataTable("Product");
da.Fill(dt);
Product returnvalue = new Product();
if (dt.Rows.Count > 0)
{
returnvalue.Id = Convert.ToInt16(dt.Rows[0][0].ToString());
returnvalue.ProductSn = dt.Rows[0][1].ToString();
returnvalue.ProductName = dt.Rows[0][2].ToString();
returnvalue.Remark = dt.Rows[0][3].ToString();
returnvalue.UnitPerBox = Convert.ToInt16(dt.Rows[0][4].ToString());
}
return returnvalue;
}
//��ѯ�����в�Ʒ
public List<Product> SelectProductAllToList()
{
List<Product> listproduct = new List<Product>();
DataTable dt = new DataTable();
dt = ReadTableOrderByXXId("Product", "ProductSn");
for (int i = 0; i < dt.Rows.Count; i++)
{
Product returnvalue = new Product();
returnvalue.Id = Convert.ToInt16(dt.Rows[i][0].ToString());
returnvalue.ProductSn = dt.Rows[i][1].ToString();
returnvalue.ProductName = dt.Rows[i][2].ToString();
returnvalue.Remark = dt.Rows[i][3].ToString();
returnvalue.UnitPerBox = Convert.ToInt16(dt.Rows[i][4].ToString());
listproduct.Add(returnvalue);
}
return listproduct;
}
//��ѯij����Ʒ��Ϣ
public DataTable SelectProduct(Product product)
{
command.CommandText = "SELECT * FROM Product where Id = '" + product.Id + "'";
SQLiteDataAdapter da = new SQLiteDataAdapter(command);
DataTable dt = new DataTable("Product");
da.Fill(dt);
return dt;
}
//�������
public string InsertStocks()
{
command.CommandText = "SELECT max(Id) FROM Product";
SQLiteDataAdapter da = new SQLiteDataAdapter(command);
DataTable dtMaxId = new DataTable();
da.Fill(dtMaxId);
int productid;
Product productmax = new Product();
if(dtMaxId.Rows.Count>0)
{
productid = Convert.ToInt16(dtMaxId.Rows[0][0].ToString());
productmax.Id = productid;
productmax = SelectProductToClass(productmax);
}
else
{
productid = 1;
}
DataTable dt = new DataTable();
dt = CreateDataTable("Stocks");
DataRow datarow;
datarow = dt.NewRow();
datarow[0] = productmax.Id;
datarow[1] = 0;
datarow[2] = 0;
datarow[3] = DateTime.Now;
datarow[4] = productmax.ProductSn;
datarow[5] = productmax.ProductName;
dt.Rows.Add(datarow);
return UpdateTable(dt, "Stocks");
}
//������Ʒ�����ڿ�����Ҳ����һ��
public string InsertProductFull(Product product)
{
string returnflag = InsertProduct(product);
if (returnflag == "success")
{
return InsertStocks();
}
else
{
return returnflag;
}
}
//������Ʒ
public string InsertProduct(Product product)
{
DataTable dt = new DataTable();
dt = CreateDataTable("Product");
DataRow datarow;
datarow = dt.NewRow();
datarow[0] = product.Id;
datarow[1] = product.ProductSn;
datarow[2] = product.ProductName;
datarow[3] = product.Remark;
datarow[4] = product.UnitPerBox;
dt.Rows.Add(datarow);
return UpdateTable(dt, "Product");
}
