public List <MyOrder> getMyOrderListData(string MemberCardNo, string Type = null)
{
List <MyOrder> list = null;
try
{
IParameterMapper ipmapper = new getMyOrderListDataParameterMapper();
DataAccessor <MyOrder> tableAccessor;
string strSql = null;
if (!string.IsNullOrEmpty(Type) && Type == "FastFood")
{
// strSql = @"select r.Name,o.PersonCount,o.DiningDate,o.Id ,o.status,r.RstType from Restaurant r, Orders o
// where r.Id=o.RstId and o.MemberCardNo=@MemberCardNo and r.RstType=01 ";
//and o.status=0
strSql = @"select r.Name,o.PersonCount,o.DiningDate,o.Id ,o.status, os.OrderStatus, r.RstType ,od.ProductId,p.ProductName" +
" from Restaurant r, Orders o left join OrderDetails od on o.Id=od.OrderId left join OrderStatus os on os.OrderId = o.Id,Product p" +
" where r.Id=o.RstId and o.MemberCardNo=@MemberCardNo and od.productid=p.id" +
" and r.RstType=01 ";
}
else
{
strSql = @"select r.Name,o.PersonCount,o.DiningDate,o.Id ,o.status, os.OrderStatus, r.RstType ,od.ProductId,p.ProductName" +
" from Restaurant r, Orders o left join OrderDetails od on o.Id=od.OrderId left join OrderStatus os on os.OrderId = o.Id,Product p" +
" where r.Id=o.RstId and o.MemberCardNo=@MemberCardNo and od.productid=p.id" +
" and r.RstType=02 ";
// strSql = @"select r.Name,o.PersonCount,o.DiningDate,o.Id ,o.status,r.RstType from Restaurant r, Orders o
// where r.Id=o.RstId and o.MemberCardNo=@MemberCardNo and o.status=1 and r.RstType=02 and dateAdd(hh,5,o.DiningDate)>=getdate() ";
}
tableAccessor = db.CreateSqlStringAccessor(strSql, ipmapper, MapBuilder <MyOrder> .MapAllProperties()
.Map(t => t.DiningDate).ToColumn("DiningDate")
.Map(t => t.OrderId).ToColumn("Id")
.Map(t => t.PersonCount).ToColumn("PersonCount")
.Map(t => t.name).ToColumn("name")
.Map(t => t.status).ToColumn("OrderStatus")
.Map(t => t.RstType).ToColumn("RstType")
.Map(t => t.ProductId).ToColumn("ProductId")
.Map(t => t.ProductName).ToColumn("ProductName")
.Build());
list = tableAccessor.Execute(new string[] { MemberCardNo }).ToList();
return(list);
}
catch (Exception ex)
{
Logger.Log(ex);
return(null);
}
}
public List<MyOrder> getMyOrderListData(string MemberCardNo, string Type = null)
{
List<MyOrder> list = null;
try
{
IParameterMapper ipmapper = new getMyOrderListDataParameterMapper();
DataAccessor<MyOrder> tableAccessor;
string strSql = null;
if (!string.IsNullOrEmpty(Type) && Type == "FastFood")
{
// strSql = @"select r.Name,o.PersonCount,o.DiningDate,o.Id ,o.status,r.RstType from Restaurant r, Orders o
// where r.Id=o.RstId and o.MemberCardNo=@MemberCardNo and r.RstType=01 ";
//and o.status=0
strSql = @"select r.Name,o.PersonCount,o.DiningDate,o.Id ,o.status, os.OrderStatus, r.RstType ,od.ProductId,p.ProductName" +
" from Restaurant r, Orders o left join OrderDetails od on o.Id=od.OrderId left join OrderStatus os on os.OrderId = o.Id,Product p"+
" where r.Id=o.RstId and o.MemberCardNo=@MemberCardNo and od.productid=p.id" +
" and r.RstType=01 ";
}
else
{
strSql = @"select r.Name,o.PersonCount,o.DiningDate,o.Id ,o.status, os.OrderStatus, r.RstType ,od.ProductId,p.ProductName" +
" from Restaurant r, Orders o left join OrderDetails od on o.Id=od.OrderId left join OrderStatus os on os.OrderId = o.Id,Product p" +
" where r.Id=o.RstId and o.MemberCardNo=@MemberCardNo and od.productid=p.id" +
" and r.RstType=02 ";
// strSql = @"select r.Name,o.PersonCount,o.DiningDate,o.Id ,o.status,r.RstType from Restaurant r, Orders o
// where r.Id=o.RstId and o.MemberCardNo=@MemberCardNo and o.status=1 and r.RstType=02 and dateAdd(hh,5,o.DiningDate)>=getdate() ";
}
tableAccessor = db.CreateSqlStringAccessor(strSql, ipmapper, MapBuilder<MyOrder>.MapAllProperties()
.Map(t => t.DiningDate).ToColumn("DiningDate")
.Map(t => t.OrderId).ToColumn("Id")
.Map(t => t.PersonCount).ToColumn("PersonCount")
.Map(t => t.name).ToColumn("name")
.Map(t => t.status).ToColumn("OrderStatus")
.Map(t => t.RstType).ToColumn("RstType")
.Map(t => t.ProductId).ToColumn("ProductId")
.Map(t => t.ProductName).ToColumn("ProductName")
.Build());
list = tableAccessor.Execute(new string[] { MemberCardNo }).ToList();
return list;
}
catch (Exception ex)
{
Logger.Log(ex);
return null;
}
}
