public void Update()
{
String Sql = String.Format("Update OrderDetail Set Seq=\"{0}\", ProductID='{1}', Quantity='{2}', Tax='{3}', QuantityInvoiced='{4}', Reserved='0', OrderID={5}" + " Where CompanyID=\"" + this.CompanyID + "\"" + " And CustomerID=\"" + this.CustomerID + "\"" + " And OrderID=\"" + this.OrderID + "\"" + " And ProductID=\"" + this.ProductID + "\"",
this.Seq, this.ProductID, this.Quantity, this.Tax, this.No_Invoiced, this.OrderID);
oMySql.exec_sql_afected(Sql);
}
public void Insert()
{
String Sql = String.Format("Insert into ReceiveDetail (CompanyID, ReceiveID, PurchaseID, ProductID, Quantity) Values (\"{0}\",\"{1}\",\"{2}\",'{3}','{4}')",
this.CompanyID, this.ReceiveID, this.PurchaseID, this.ProductID, this.Received);
oMySql.exec_sql_afected(Sql);
}
public void Insert()
{
String Sql = String.Format("Insert into PurchaseDetail (CompanyID, PurchaseID, ProductID, Cases, Units, Note) Values (\"{0}\",\"{1}\",\"{2}\",'{3}','{4}',\"{5}\")",
this.CompanyID, this.PurchaseID, this.ProductID, this.Cases, this.Units, this.Note);
oMySql.exec_sql_afected(Sql);
}
public void Insert()
{
String Sql = String.Format("Insert into PrizeDetail (CompanyID, PrizeID, ProductID, BreakLevel, BreakLevelDollars, Quantity) Values (\"{0}\",\"{1}\",\"{2}\",'{3}','{4}','{5}')",
this.CompanyID, this.PrizeID, this.ProductID, this.BreakLevel, this.Amount, this.Quantity);
//MessageBox.Show(Sql);
oMySql.exec_sql_afected(Sql);
}
