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