// 查询主表：GET api/mms/send
public dynamic Get(RequestWrapper query)
{
query.SetXml(@"
<settings >
<select>
*
</select>
<from>
test_user
</from>
<where>
<c column='UserCode' ignore='empty' symbol='like' ></c>
<c column='UserName' ignore='empty' symbol='like' ></c>
<c column='Description' ignore='empty' symbol='like' ></c>
<c column='IsEnable' ignore='empty' symbol='equal' ></c>
<c column='LoginCount' ignore='empty' symbol='equal' ></c>
<c column='LastLoginDate' ignore='empty' symbol='daterange' ></c>
</where>
<orderby>UserCode</orderby>
</settings>");
var pQuery = query.ToParamQuery();
var list = new mms_sendService().GetDynamicListWithPaging(pQuery);
return list;
}
public dynamic GetLoginLog(RequestWrapper request)
{
var service = new sys_loginHistoryService();
request.SetXml(@"
<settings>
<select>A.*</select>
<from>sys_loginHistory A</from>
<where><c column='LoginDate' values='{LogDate}' symbol='daterange' ignore='empty'></c></where>
<orderby>ID desc</orderby>
</settings>");
return service.GetModelListWithPaging(request.ToParamQuery());
}
public dynamic Get(RequestWrapper request)
{
request.SetXml(@"
<settings>
<where>
<c column='UserCode' symbol='mapchild' values='{OrganizeCode},sys_userOrganizeMap,OrganizeCode,sys_organize' ignore='empty'></c>
</where>
<orderby>UserSeq</orderby>
</settings>");
var service = new sys_userService();
var result = service.GetModelListWithPaging(request.ToParamQuery());
return result;
}
public dynamic Get(RequestWrapper request)
{
request.SetXml(@"
<settings>
<where>
<c column='ProjectCode' symbol='equal' ignore='empty'></c>
</where>
<orderby>WarehouseCode</orderby>
</settings>");
var service = new mms_warehouseService();
var result = service.GetModelListWithPaging(request.ToParamQuery());
return result;
}
public dynamic GetTypes(RequestWrapper request)
{
request.SetXml(@"
<settings>
<where>
<c column='MerchantsTypeCode' symbol='equal' ignore='empty'></c>
<c column='MerchantsTypeName' symbol='like' ignore='empty'></c>
</where>
<orderby>MerchantsTypeCode</orderby>
</settings>
");
var result = new mms_merchantsTypeService().GetDynamicListWithPaging(request.ToParamQuery());
return result;
}
public dynamic Get(RequestWrapper query)
{
query.SetXml(@"
<settings >
<select>*</select>
<from>base_line</from>
<where>
<c column='linecd' symbol='like' ignore='empty'></c>
<c column='line' symbol='like' ignore='empty'></c>
<c column='bizlist' symbol='like' ignore='empty'></c>
</where>
<orderby>keyid</orderby>
</settings>");
var service = new base_lineService();
var pQuery = query.ToParamQuery();
var result = service.GetDynamicListWithPaging(pQuery);
return result;
}
public dynamic Get(RequestWrapper query)
{
query.SetXml(@"
<settings >
<select>*</select>
<from>base_area</from>
<where>
<c column='areacd' symbol='equal' ignore='empty'></c>
<c column='parentcd' symbol='equal' ignore='empty'></c>
<c column='areahelpcd' symbol='equal' ignore='empty'></c>
<c column='areaname' symbol='equal' ignore='empty'></c>
</where>
<orderby>keyid</orderby>
</settings>");
var service = new base_areaService();
var pQuery = query.ToParamQuery();
var result = service.GetDynamicListWithPaging(pQuery);
return result;
}
public dynamic Get(RequestWrapper query)
{
query.SetXml(@"
<settings>
<select>*</select>
<from>test_liy</from>
<where>
<c column='DepartmentID' cp='equal' ignore='empty'></c>
<c column='IsValid' cp='equal' ignore='empty'></c>
<c column='ApproveState' cp='equal' ignore='empty'></c>
<c column='Remark' cp='like' ignore='empty'></c>
<c column='OutDateTime' cp='daterange' ignore='empty'></c>
</where>
<orderby>ID</orderby>
</settings>");
var service = new test_liyService();
var pQuery = query.ToParamQuery();
var result = service.GetDynamicListWithPaging(pQuery);
return result;
}
public dynamic Get(RequestWrapper query)
{
query.SetXml(@"
<settings >
<select>*</select>
<from>mms_send</from>
<where>
<c column='BillNo' symbol='equal' ignore='empty'></c>
<c column='BillDate' symbol='equal' ignore='empty'></c>
<c column='DoPerson' symbol='equal' ignore='empty'></c>
<c column='ProjectCode' symbol='equal' ignore='empty'></c>
<c column='WarehouseCode' symbol='equal' ignore='empty'></c>
</where>
<orderby>BillNo</orderby>
</settings>");
var service = new mms_sendService();
var pQuery = query.ToParamQuery();
var result = service.GetDynamicListWithPaging(pQuery);
return result;
}
public dynamic Get(RequestWrapper query)
{
query.SetXml(@"
<settings>
<select>*</select>
<from>mms_product</from>
<where>
<c column='ProductName' ignore='empty' symbol='like'></c>
<c column='Color' ignore='empty' symbol='equal' ></c>
<c column='Price' ignore='empty' symbol='equal'></c>
<c column='Unit' ignore='empty' symbol='equal'></c>
<c column='Remark' ignore='empty' symbol='like'></c>
<c column='CreateDate' ignore='empty' symbol='daterange'></c>
</where>
<orderby>ID</orderby>
</settings>");
var service = new mms_productService();
var pQuery = query.ToParamQuery();
var result = service.GetDynamicListWithPaging(pQuery);
return result;
}
public dynamic Get(RequestWrapper query)
{
query.SetXml(@"
<settings>
<select>*</select>
<from>mms_test</from>
<where>
<c column='ID' ignore='empty' symbol='equal'></c>
<c column='ProjectName' ignore='empty' symbol='like' ></c>
<c column='DeclaringUnits' ignore='empty' symbol='like'></c>
<c column='ProjectType' ignore='empty' symbol='equal'></c>
<c column='StartDate' ignore='empty' symbol='dtgreaterequal'></c>
<c column='EndDate' ignore='empty' symbol='dtlessequal'></c>
</where>
<orderby>ID</orderby>
</settings>");
var service = new mms_testService();
var pQuery = query.ToParamQuery();
var result = service.GetDynamicListWithPaging(pQuery);
return result;
}
public dynamic Get(RequestWrapper query)
{
query.SetXml(@"
<settings>
<select>*</select>
<from>trade_scheduler</from>
<where>
<c column='JOBNO' symbol='equal' ignore='empty'></c>
<c column='SNO' symbol='equal' ignore='empty'></c>
<c column='SC_DRIVER' symbol='equal' ignore='empty'></c>
<c column='SC_TRUCKCD' symbol='equal' ignore='empty'></c>
<c column='SC_DISTANCEID' symbol='equal' ignore='empty'></c>
<c column='SC_ONCNTDATE' symbol='equal' ignore='empty'></c>
<c column='SC_ARRIVEDATE' symbol='equal' ignore='empty'></c>
</where>
<orderby>JOBNO</orderby>
</settings>");
var service = new trade_schedulerService();
var pQuery = query.ToParamQuery();
var result = service.GetDynamicListWithPaging(pQuery);
return result;
}
// 查询主表数据列表 GET api/mms/send
public dynamic Get(RequestWrapper query)
{
query.SetXml(@"
<settings>
<select>
A.*, B.ProjectName, C.MaterialTypeName, D.WarehouseName as WarehouseName, E.MerchantsName AS SupplierName
</select>
<from>
mms_receive A
left join mms_project B on B.ProjectCode = A.ProjectCode
left join mms_materialType C on C.MaterialType = A.MaterialType
left join mms_warehouse D on D.WarehouseCode = A.WarehouseCode
left join mms_merchants E on E.MerchantsCode = A.SupplierCode
</from>
<where>
<c column='BillNo' symbol='equal' ignore='empty' ></c>
<c column='DoPerson' symbol='like' ignore='empty' ></c>
<c column='E.MerchantsName' symbol='like' ignore='empty' values='{SupplierName}'></c>
<c column='A.WarehouseCode' symbol='equal' ignore='empty' ></c>
<c column='A.MaterialType' symbol='equal' ignore='empty' ></c>
<c column='ReceiveDate' symbol='daterange' ignore='empty' ></c>
<c column='ContractCode' symbol='like' ignore='empty' ></c>
</where>
<orderby>BillNo</orderby>
</settings>");
var pQuery = query.ToParamQuery().Where("A.ProjectCode", MmsHelper.GetCurrentProject());
var result = masterService.GetDynamicListWithPaging(pQuery);
return result;
//return base.Get(query);
}
public dynamic Get(RequestWrapper query)
{
query.SetXml(@"
<settings>
<select>*</select>
<from>REMP_Staff</from>
<where>
<c column='UserName' ignore='empty' cp='equal'></c>
<c column='EmployeeName' ignore='empty' cp='equal'></c>
<c column='DisplayName' ignore='empty' cp='equal'></c>
<c column='UserType' ignore='empty' cp='equal'></c>
<c column='EmployeeCode' ignore='empty' cp='equal'></c>
<c column='Birthday' ignore='empty' cp='daterange'></c>
</where>
<orderby>EMPSID</orderby>
</settings>");
var service = new REMP_StaffService();
var pQuery = query.ToParamQuery();
var result = service.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;
}