public void SetCriteria(QueryCriteria aCriteria)
{
throw new NotImplementedException();
}
private static string searchTable(QueryCriteria cirteria)
{
string search = @"select [Table].Id, Location, [Table].Name, SeatAmount, Status , TableType.Name as Type
from [Table], TableType
where and [Table].TableTypeId = TableType.Id";
if (cirteria != null)
{
search = search + " and " + cirteria.Name + " " + cirteria.Value;
}
return search;
}
public List<Table> QueryTableList(QueryCriteria condition)
{
FrontDeskRequest frontdesk = FrontDeskRequestControl.GetService(callBackId);
try
{
return TableDao.GetTable(condition);
}
catch (HCSMSException ex)
{
raiseError(ex);
if (frontdesk != null)
{
frontdesk.ErrorMessage(new ErrorEventArgs("", ex));
}
return null;
}
catch (Exception ex)
{
raiseError(ex);
return null;
}
}
public static List<Table> GetTable(QueryCriteria cirteria)
{
using (SqlConnection conn = Utilities.GetConnection())
{
SqlCommand comm = new SqlCommand(searchTable(cirteria), conn);
try
{
conn.Open();
List<Table> tableList = new List<Table>();
SqlDataReader reader = comm.ExecuteReader();
while (reader.Read())
{
tableList.Add(convertToTable(reader["ID"].ToString(), reader["Location"].ToString(), reader["Name"].ToString(), reader.GetInt32(3), reader["Status"].ToString(), reader["Type"].ToString()));
}
return tableList;
}
catch (SqlException sqlException)
{
throw new HCSMSException(sqlException.Message);
}
finally
{
if (conn != null)
{
conn.Close();
}
}
}
}
public List<SaleItem> QueryItemList(QueryCriteria queryConditon)
{
FrontDeskRequest frontdesk = FrontDeskRequestControl.GetService(callBackId);
try
{
HCSMSLog.OnWarningLog(this, new NotifyEventArgs("Query ItemList Request"));
return ItemDao.GetSaleItemByCondition(queryConditon);
}
catch (HCSMSException ex)
{
raiseError(ex);
if (frontdesk != null)
{
frontdesk.ErrorMessage(new ErrorEventArgs("", ex));
}
return null;
}
catch (Exception ex)
{
raiseError(ex);
return null;
}
}