// GET: Order
public ActionResult Index(int pageIndex = 1, int pageSize = 10)
{
var type = Convert.ToInt32(Request.Params["orderType"] ?? "0");
var orderId = Request.Params["orderId"];
var userName = Request.Params["userName"];
var mobile = Request.Params["mobile"];
var s_addDate = Request.Params["s_addDate"];
var e_addDate = Request.Params["e_addDate"];
var s_payDate = Request.Params["s_payDate"];
var e_payDate = Request.Params["e_payDate"];
var searchModel = new OrderMainRequest.PageRequest
{
PageIndex = pageIndex,
PageSize = pageSize,
OrderType = type,
OrderId = orderId,
UserName = userName,
Mobile = mobile,
SaddDate = s_addDate,
EaddDate = e_addDate,
SpayDate = s_payDate,
EpayDate = e_payDate
};
var result = orderMainService.PageList(searchModel);
ViewBag.SearchModel = searchModel;
if (result.Code == 0 && result.Data != null)
{
return(View(result.Data));
}
else
{
return(View(new PagedEntity <OrderMainListDTO>()));
}
}
/// <summary>
/// 主订单分页查询
/// </summary>
/// <param name="request"></param>
/// <returns></returns>
public ResultWithCodeEntity <PagedEntity <OrderMainListDTO> > PageList(OrderMainRequest.PageRequest request)
{
try
{
var data = orderMainRepository.PageInfo(request);
return(Result.Success(data));
}
catch (Exception ex)
{
return(Result.Error <PagedEntity <OrderMainListDTO> >(ResultCode.ExceptionError));
}
}
/// <summary>
/// 分页
/// </summary>
/// <param name="request"></param>
/// <returns></returns>
public PagedEntity <OrderMainListDTO> PageInfo(OrderMainRequest.PageRequest request)
{
StringBuilder strSql = new StringBuilder();
int PageIndex = (request.PageIndex - 1) * request.PageSize;
strSql.Append(" SELECT SQL_CALC_FOUND_ROWS o.*,u.userName,u.mobile");
strSql.Append(" FROM t_order_ordermain o ");
strSql.Append(" LEFT JOIN t_tour_user u ON o.userID=u.id ");
strSql.Append(" WHERE 1=1 ");
if (!string.IsNullOrEmpty(request.UserName))
{
strSql.Append(" AND username like CONCAT('%',@UserName,'%') ");
}
if (request.OrderType > 0)
{
strSql.Append(" AND orderType=@OrderType ");
}
if (!string.IsNullOrEmpty(request.Mobile))
{
strSql.Append(" AND mobile like CONCAT('%',@Mobile,'%') ");
}
if (!string.IsNullOrEmpty(request.OrderId))
{
strSql.Append(" AND orderId like CONCAT('%',@OrderId,'%') ");
}
if (!string.IsNullOrEmpty(request.SpayDate))
{
strSql.Append(" AND payDate>@SpayDate ");
}
if (!string.IsNullOrEmpty(request.EpayDate))
{
strSql.Append(" AND payDate<EpayDate ");
}
if (!string.IsNullOrEmpty(request.SaddDate))
{
strSql.Append(" AND addDate>@SaddDate ");
}
if (!string.IsNullOrEmpty(request.EaddDate))
{
strSql.Append(" AND payDate>EaddDate ");
}
strSql.Append(" ORDER BY payDate DESC ");
strSql.Append(" LIMIT @PageIndex,@PageSize;");
strSql.Append(" select found_rows() as TotalCount ;");
var parameters = new
{
request.UserName,
request.OrderType,
request.Mobile,
request.OrderId,
request.SpayDate,
request.EpayDate,
request.SaddDate,
request.EaddDate,
PageIndex,
request.PageSize
};
var list = new List <OrderMainListDTO>();
var pageCount = new PageCount();
OpenSlaveConnection(conn =>
{
using (var multiReader = conn.QueryMultiple(strSql.ToString(), parameters))
{
list = multiReader.Read <OrderMainListDTO>().ToList();
pageCount = multiReader.Read <PageCount>().FirstOrDefault();
}
});
return(new PagedEntity <OrderMainListDTO>(pageCount.TotalCount, list));
}
