/// <summary> /// 获取数据 /// </summary> /// <returns></returns> private IList <OrderDetailDTO> GetData() { int shopid = MXRequest.GetQueryInt("hotelid") == 0 ? this.GetHotelId() : MXRequest.GetQueryInt("hotelid"); string condition = ""; var moduleName = "hotel"; if (!String.IsNullOrEmpty(startDate.Text.Trim())) { condition += " modifytime>='" + startDate.Text.Trim() + "' "; } if (!String.IsNullOrEmpty(endDate.Text.Trim())) { if (!String.IsNullOrEmpty(condition)) { condition += " and "; } condition += " modifytime<='" + endDate.Text.Trim() + "' "; } if (!String.IsNullOrEmpty(dingdanId.Text.Trim())) { if (!String.IsNullOrEmpty(condition)) { condition += " and "; } condition += " orderNumber LIKE '%" + dingdanId.Text.Trim() + "%' "; } if (!String.IsNullOrEmpty(paidmin.Text.Trim())) { if (!String.IsNullOrEmpty(condition)) { condition += " and "; } condition += " payAmount>" + paidmin.Text.Trim() + " "; } if (!String.IsNullOrEmpty(paidmax.Text.Trim())) { if (!String.IsNullOrEmpty(condition)) { condition += " and "; } condition += " payAmount<" + paidmax.Text.Trim() + " "; } if (!String.IsNullOrEmpty(orderperson.Text.Trim())) { if (!String.IsNullOrEmpty(condition)) { condition += " and "; } condition += " customerName LIKE '%" + orderperson.Text.Trim() + "%' "; } var detail = IdentifyingCodeService.GetOrderDetail(shopid, moduleName, condition); return(detail); }
private IList <OrderDetailDTO> SearchData() { int shopid = MXRequest.GetQueryInt("shopid") == 0 ? GetShopId() : MXRequest.GetQueryInt("shopid"); string condition = ""; var moduleName = "restaurant"; if (!String.IsNullOrEmpty(startDate.Text.Trim())) { condition += " FinishTime>='" + startDate.Text.Trim() + "' "; } if (!String.IsNullOrEmpty(endDate.Text.Trim())) { if (!String.IsNullOrEmpty(condition)) { condition += " and "; } condition += " FinishTime<='" + endDate.Text.Trim() + "' "; } if (!String.IsNullOrEmpty(dingdanId.Text.Trim())) { if (!String.IsNullOrEmpty(condition)) { condition += " and "; } condition += " orderNumber LIKE '%" + dingdanId.Text.Trim() + "%' "; } if (!String.IsNullOrEmpty(paidmin.Text.Trim())) { if (!String.IsNullOrEmpty(condition)) { condition += " and "; } condition += " payAmount>" + paidmin.Text.Trim() + " "; } if (!String.IsNullOrEmpty(paidmax.Text.Trim())) { if (!String.IsNullOrEmpty(condition)) { condition += " and "; } condition += " payAmount<" + paidmax.Text.Trim() + " "; } if (!String.IsNullOrEmpty(orderperson.Text.Trim())) { if (!String.IsNullOrEmpty(condition)) { condition += " and "; } condition += " customerName LIKE '%" + orderperson.Text.Trim() + "%' "; } var result = IdentifyingCodeService.GetOrderDetail(shopid, moduleName, condition); return(result); }
public void GetOrderDetailForSearch_IdentifyingCode_ReturnDTO() { var result = IdentifyingCodeService.GetOrderDetail(8, "restaurant", ""); }