/// <summary>
/// 取得訂單資料 Order
/// </summary>
public static DataTable GetOrder()
{
DataTable dt = null;
try
{
SQLHandler sql = new SQLHandler();
sql._sql = @"
select o.*,c.CompanyName,EmpName=e.FirstName+e.LastName
from Orders o
Left Join Customers c on c.CustomerID=o.CustomerID
Left Join Employees e on e.EmployeeID=o.EmployeeID
order by o.OrderDate";
sql._type = CommandType.Text;
dt = sql.ExecuteGetDataTable();
}
catch (Exception ex)
{
_core.Common.WriteLogFile(string.Format("(Order.GetOrder)Error={0} ", ex.Message.ToString()));
}
return(dt);
}