public DataSet orderGetByDate(DateTime date)
{
DataSet dt = new DataSet();
DAL2.onOnLine();
MySqlParameter[] param = new MySqlParameter[1];
param[0] = new MySqlParameter("@date", date);
dt = DAL2.SelectDataOnline("CALL orderGetByDate( @date);", param);
return(dt);
}