public List <OrderRecordDetailDTO> GetList(OrderRecordSearchDTO req, out int total)
{
using (var db = new SqlSugarClient(Connection))
{
List <OrderRecordDetailDTO> list = new List <OrderRecordDetailDTO>();
string sql = "SELECT * FROM(" +
" SELECT RE.*, U.czdmmc00 AS UserName, ISNULL(T.Id, 0) AS TableId, T.Name AS TableName FROM dbo.R_OrderRecord RE" +
" LEFT JOIN dbo.czdm U ON U.Id = RE.CreateUser" +
" LEFT JOIN dbo.R_OrderTable OT ON OT.Id = RE.R_OrderTable_Id AND RE.R_OrderTable_Id > 0" +
" LEFT JOIN dbo.R_Table T ON T.Id = OT.R_Table_Id AND OT.R_Table_Id > 0" +
" ) Record "+
"WHERE Record.R_Order_Id = @orderId";
if (req.TableId > 0)
{
sql += " AND Record.TableId = @tableId";
list = db.SqlQuery <OrderRecordDetailDTO>(sql, new { orderId = req.OrderId, tableId = req.TableId });
}
else
{
list = db.SqlQuery <OrderRecordDetailDTO>(sql, new { orderId = req.OrderId });
}
total = list.Count();
return(list);
}
}
public ActionResult OrderSearchById(int orderId)
{
try
{
var ordTabList = _orderRepository.GetOrderTableListBy(orderId, SearchTypeBy.订单Id);
var tabIdList = ordTabList.Select(x => x.R_Table_Id).ToList();
var currentUser = OperatorProvider.Provider.GetCurrent();
var order = GetCheckOutOrder(new CheckoutReqDTO()
{
OrderId = orderId, TableIds = tabIdList
});
OrderSearchDTO orderSearchDTO = new OrderSearchDTO(order);
var recordSearch = new OrderRecordSearchDTO();
recordSearch.OrderId = orderId;
recordSearch.RestaurantId = currentUser.DepartmentId.ToInt();
var recordList = _orderRecordRepository
.GetList(recordSearch, out int total)
.OrderByDescending(x => x.Id);
orderSearchDTO.OrderRecordList = recordList.ToList();
orderSearchDTO.InvoiceList = _orderRepository.GetInvoiceList(orderId);
var user = _oldUserRepository.GetByUserId(order.CreateUser);
orderSearchDTO.CreateUserName = (user == null || user.UserId == 0) ? "Unknow" : user.UserName;
return(Json(orderSearchDTO));
}
catch (Exception ex)
{
return(Json(ex.Message));
}
}
public ActionResult OrderRecordSearch(OrderRecordSearchDTO searchDTO)
{
var list = _orderRecordRepository
.GetList(searchDTO, out int total)
.OrderByDescending(x => x.Id);
return(Json(new { rows = list, total = total }, JsonRequestBehavior.AllowGet));
}
