/// <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", "");
}