/// <summary>
/// 构造查询条件
/// </summary>
public static string BindQueryCriteria(OrderChlidPM orderChildQueryDTO)
{
var stringBuilder = new StringBuilder(" where 1=1 ");
if (orderChildQueryDTO == null)
{
return(stringBuilder.ToString());
}
//TODO:在此加入查询条件构建代码
return(stringBuilder.ToString());
}
/// <summary>
/// 查询对象
/// </summary>
public IList <OrderChild> Query(OrderChlidPM orderChildPM)
{
IList <OrderChild> models = new List <OrderChild>();
string condition = BindQueryCriteria(orderChildPM);
string querysql = @"
select Id,OrderId,ChildId,TotalPrice,GoodPrice,DeliveryPrice,PayStyle,PayType,PayStatus,
PayBy,PayTime,PayPrice,HasUploadTicket,TicketUrl,CreateBy,CreateTime,UpdateBy,UpdateTime
from OrderChild (nolock)" + condition;
DataTable dt = DataTableHelper.GetTable(DbHelper.ExecuteDataset(SuperMan_Read, querysql));
if (DataTableHelper.CheckDt(dt))
{
models = DataTableHelper.ConvertDataTableList <OrderChild>(dt);
}
return(models);
}
