public dynamic Get(RequestWrapper query)
{
query.SetXml(@"
<settings >
<select>*</select>
<from>trade_trailer</from>
<where>
<c column='TR_JOBNOIN' symbol='like' ignore='empty'></c>
<c column='TR_BLNO' symbol='like' ignore='empty'></c>
<c column='TR_CONNO' symbol='like' ignore='empty'></c>
<c column='TR_CARRI' symbol='equal' ignore='empty'></c>
<c column='TR_CARNO' symbol='like' ignore='empty'></c>
<c column='TR_ETSH' symbol='daterange' ignore='empty'></c>
</where>
<orderby>JOBNO</orderby>
</settings>");
var service = new trade_trailerService();
var pQuery = query.ToParamQuery();
var result = service.GetDynamicListWithPaging(pQuery);
return(result);
}
// 查询明细表 GET api/trade/send/getdetail
public virtual dynamic GetDetail(string id)
{
var query = RequestWrapper
.InstanceRequest()
.SetValue("Jobno", id)
.SetXml(string.Format(@"
<settings>
<select>A.*, B.*</select>
<from>
trade_trailer A
left join trade_scheduler B on B.jobno = A.jobno
</from>
<where>
<c column='A.Jobno' symbol='equal'></c>
</where>
<orderby>A.Jobno</orderby>
</settings>"));
var pQuery = query.ToParamQuery();
var result = masterService.GetDynamicListWithPaging(pQuery);
return(result);
}
public dynamic Get(RequestWrapper query)
{
query.SetXml(@"
<settings >
<select>*</select>
<from>trade_trailer</from>
<where>
<c column='TR_JOBNOIN' symbol='like' ignore='empty'></c>
<c column='TR_BLNO' symbol='like' ignore='empty'></c>
<c column='TR_CONNO' symbol='like' ignore='empty'></c>
<c column='TR_CARRI' symbol='equal' ignore='empty'></c>
<c column='TR_CARNO' symbol='like' ignore='empty'></c>
<c column='TR_ETSH' symbol='daterange' ignore='empty'></c>
</where>
<orderby>JOBNO</orderby>
</settings>");
var service = new trade_trailerService();
var pQuery = query.ToParamQuery();
var result = service.GetDynamicListWithPaging(pQuery);
return result;
}
