public dynamic GetDetail(string id)
{
var query = RequestWrapper
.InstanceFromRequest()
.SetRequestData("BillNo", id)
.LoadSettingXmlString(@"
<settings defaultOrderBy='RowId'>
<select>
A.*, B.Name,B.Catagory,B.Brand,B.Model,B.Unit
</select>
<from>
psi_receiveGoods A
left join psi_goods B on B.Id = A.GoodNo
</from>
<where>
<field name='BillNo' cp='equal'></field>
</where>
</settings>");
var pQuery = query.ToParamQuery();
var ReceiveService = new psi_receiveService();
var result = ReceiveService.GetDynamicListWithPaging(pQuery);
return(result);
}
public dynamic Get(RequestWrapper query)
{
query.LoadSettingXmlString(@"
<settings defaultOrderBy='BillNo'>
<select>
A.*,B.Name as WarehouseName,C.Name as SupplierName
</select>
<from>
psi_receive A
left join psi_warehouse B on B.Id = A.Warehouse
left join psi_supplier C on C.Id = A.Supplier
</from>
<where defaultForAll='true' defaultCp='equal' defaultIgnoreEmpty='true' >
<field name='BillNo' cp='equal' ></field>
<field name='Warehouse' cp='equal' ></field>
<field name='ReceivePerson' cp='like' ></field>
<field name='Contract' cp='like' ></field>
<field name='ReceiveDate' cp='daterange' ></field>
<field name='C.Name' cp='like' variable='SupplierName'></field>
</where>
</settings>");
var ReceiveService = new psi_receiveService();
var pQuery = query.ToParamQuery();
var result = ReceiveService.GetDynamicListWithPaging(pQuery);
return(result);
}
public dynamic GetDetail(string id)
{
var query = RequestWrapper
.InstanceFromRequest()
.SetRequestData("BillNo", id)
.LoadSettingXmlString(@"
<settings defaultOrderBy='RowId'>
<select>
A.*, B.Name,B.Catagory,B.Brand,B.Model,B.Unit
</select>
<from>
psi_receiveGoods A
left join psi_goods B on B.Id = A.GoodNo
</from>
<where>
<field name='BillNo' cp='equal'></field>
</where>
</settings>");
var pQuery = query.ToParamQuery();
var ReceiveService = new psi_receiveService();
var result = ReceiveService.GetDynamicListWithPaging(pQuery);
return result;
}
public dynamic Get(RequestWrapper query)
{
query.LoadSettingXmlString(@"
<settings defaultOrderBy='BillNo'>
<select>
A.*,B.Name as WarehouseName,C.Name as SupplierName
</select>
<from>
psi_receive A
left join psi_warehouse B on B.Id = A.Warehouse
left join psi_supplier C on C.Id = A.Supplier
</from>
<where defaultForAll='true' defaultCp='equal' defaultIgnoreEmpty='true' >
<field name='BillNo' cp='equal' ></field>
<field name='Warehouse' cp='equal' ></field>
<field name='ReceivePerson' cp='like' ></field>
<field name='Contract' cp='like' ></field>
<field name='ReceiveDate' cp='daterange' ></field>
<field name='C.Name' cp='like' variable='SupplierName'></field>
</where>
</settings>");
var ReceiveService = new psi_receiveService();
var pQuery = query.ToParamQuery();
var result = ReceiveService.GetDynamicListWithPaging(pQuery);
return result;
}
