public void SetStatus(DiscrepancyActivity dActivity)
{
oMySql.exec_sql(String.Format("Update Orders Set Discrepancy='{0}' Where ID={1}", (int)dActivity, ID.ToString()));
}
public Int32 GetStatus(String CustomerID, DiscrepancyActivity dActivity)
{
String Sql = String.Format("Select count(*) From Orders Where CompanyID='{0}' And CustomerID = '{1}' And Discrepancy = '{2}')", _Company, CustomerID, (int)dActivity);
return(oMySql.exec_sql_no(Sql));
}