public dynamic Get(RequestWrapper request)
{
request.LoadSettingXmlString(@"
<settings defaultOrderBy='MerchantsCode'>
<where>
<field name='MerchantsTypeCode' cp='equal' ignoreEmpty='true'></field>
</where>
</settings>");
var service = new mms_merchantsService();
var result = service.GetModelListWithPaging(request.ToParamQuery());
return result;
}
public dynamic Get(RequestWrapper request)
{
request.LoadSettingXmlString(@"
<settings defaultOrderBy='UserSeq'>
<where>
<field name='UserCode' cp='mapchild' extend='sys_userOrganizeMap,OrganizeCode,sys_organize' variable='OrganizeCode' ignoreEmpty='true'></field>
</where>
</settings>");
var service = new sys_userService();
var result = service.GetModelListWithPaging(request.ToParamQuery());
return result;
}
public dynamic GetTypes(RequestWrapper request)
{
request.LoadSettingXmlString(@"
<settings defaultOrderBy='MerchantsTypeCode'>
<where defaultIgnoreEmpty='true'>
<field name='MerchantsTypeCode' cp='equal'></field>
<field name='MerchantsTypeName' cp='like' ></field>
</where>
</settings>
");
var result = new mms_merchantsTypeService().GetDynamicListWithPaging(request.ToParamQuery());
return result;
}
public List<dynamic> Get(RequestWrapper query)
{
query.LoadSettingXmlString(@"
<settings defaultOrderBy='DEPTID'>
<select>*</select>
<from>REMP_Department</from>
<where defaultForAll='true' defaultCp='equal' defaultIgnoreEmpty='true' >
</where>
</settings>");
var service = new REMP_DepartmentService();
var pQuery = query.ToParamQuery();
var result = service.GetDynamicListWithPaging(pQuery);
return result;
}
public dynamic Get(RequestWrapper query)
{
query.LoadSettingXmlString(@"
<settings defaultOrderBy='ID'>
<select>*</select>
<from>sys_code</from>
<where defaultForAll='true' defaultCp='equal' defaultIgnoreEmpty='true' >
<field name='Code' cp='equal'></field>
<field name='Text' cp='equal'></field>
</where>
</settings>");
var service = new sys_codeService();
var pQuery = query.ToParamQuery();
var result = service.GetDynamicListWithPaging(pQuery);
return result;
}
public dynamic Get(RequestWrapper query)
{
query.LoadSettingXmlString(@"
<settings defaultOrderBy='ID'>
<select>*</select>
<from>mms_merchants</from>
<where defaultForAll='true' defaultCp='equal' defaultIgnoreEmpty='true' >
<field name='MerchantsTypeName' cp='equal'></field>
<field name='RegisterFund' cp='equal'></field>
</where>
</settings>");
var service = new mms_merchantsService();
var pQuery = query.ToParamQuery();
var result = service.GetDynamicListWithPaging(pQuery);
return result;
}
public dynamic Get(RequestWrapper query)
{
query.LoadSettingXmlString(@"
<settings defaultOrderBy='ID'>
<select>*</select>
<from>mms_lossReport</from>
<where defaultForAll='true' defaultCp='equal' defaultIgnoreEmpty='true' >
<field name='BillNo' cp='equal'></field>
<field name='BillDate' cp='equal'></field>
<field name='DoPerson' cp='equal'></field>
</where>
</settings>");
var service = new mms_lossReportService();
var pQuery = query.ToParamQuery();
var result = service.GetDynamicListWithPaging(pQuery);
return result;
}
public dynamic GetOperateLog(RequestWrapper request)
{
var service = new sys_logService();
request.LoadSettingXmlString(@"
<settings defaultOrderBy='ID desc'>
<select>
A.*
</select>
<from>
sys_log A
</from>
<where defaultForAll='true' defaultCp='equal' defaultIgnoreEmpty='true' >
<field name='Date' cp='daterange' variable='LogDate' ></field>
</where>
</settings>");
return service.GetModelListWithPaging(request.ToParamQuery());
}
public dynamic Get(RequestWrapper query)
{
query.LoadSettingXmlString(@"
<settings defaultOrderBy='RowId'>
<select>*</select>
<from>mms_lossReportBatches</from>
<where defaultForAll='true' defaultCp='equal' defaultIgnoreEmpty='true' >
<field name='MaterialCode' cp='equal'></field>
<field name='Money' cp='equal'></field>
<field name='SrcRowId' cp='equal'></field>
</where>
</settings>");
var service = new mms_lossReportBatchesService();
var pQuery = query.ToParamQuery();
var result = service.GetDynamicListWithPaging(pQuery);
return result;
}
public dynamic Get(RequestWrapper query)
{
query.LoadSettingXmlString(@"
<settings defaultOrderBy='Id'>
<select>*</select>
<from>psi_supplier</from>
<where defaultForAll='true' defaultCp='equal' defaultIgnoreEmpty='true' >
<field name='Id' cp='equal'></field>
<field name='Name' cp='like' ></field>
<field name='ChargePerson' cp='like'></field>
<field name='Catagory' cp='equal'></field>
</where>
</settings>");
var service = new psi_supplierService();
var pQuery = query.ToParamQuery();
var result = service.GetDynamicListWithPaging(pQuery);
return result;
}
public dynamic Get(RequestWrapper query)
{
query.LoadSettingXmlString(@"
<settings defaultOrderBy='ID'>
<select>*</select>
<from>test_liy</from>
<where defaultForAll='true' defaultCp='equal' defaultIgnoreEmpty='true' >
<field name='DepartmentID' cp='equal'></field>
<field name='IsValid' cp='equal'></field>
<field name='ApproveState' cp='equal'></field>
<field name='Remark' cp='like'></field>
<field name='OutDateTime' cp='daterange'></field>
</where>
</settings>");
var service = new test_liyService();
var pQuery = query.ToParamQuery();
var result = service.GetDynamicListWithPaging(pQuery);
return result;
}
public dynamic Get(RequestWrapper query)
{
query.LoadSettingXmlString(@"
<settings defaultOrderBy='ID'>
<select>*</select>
<from>mms_productTest</from>
<where defaultForAll='true' defaultCp='equal' defaultIgnoreEmpty='true' >
<field name='ProductName' cp='like'></field>
<field name='ProductCode' cp='startwith'></field>
<field name='ProductColor' cp='equal'></field>
<field name='ProductType' cp='equal'></field>
<field name='ProductDate' cp='daterange'></field>
</where>
</settings>");
var service = new mms_productTestService();
var pQuery = query.ToParamQuery();
var result = service.GetDynamicListWithPaging(pQuery);
return result;
}
public dynamic Get(RequestWrapper query)
{
query.LoadSettingXmlString(@"
<settings defaultOrderBy='BillNo'>
<select>*</select>
<from>mms_deal</from>
<where defaultForAll='true' defaultCp='equal' defaultIgnoreEmpty='true' >
<field name='ProjectCode' cp='like'></field>
<field name='ApplyDate' cp='daterange'></field>
<field name='DealType' cp='equal'></field>
<field name='DealKind' cp='equal'></field>
<field name='TotalMoney' cp='equal'></field>
<field name='ApproveState' cp='equal'></field>
</where>
</settings>");
var service = new mms_dealService();
var pQuery = query.ToParamQuery();
var result = service.GetDynamicListWithPaging(pQuery);
return result;
}
public dynamic Get(RequestWrapper query)
{
query.LoadSettingXmlString(@"
<settings defaultOrderBy='ProjectCode'>
<select>*</select>
<from>mms_project</from>
<where defaultForAll='true' defaultCp='equal' defaultIgnoreEmpty='true' >
<field name='ParentCode' cp='equal'></field>
<field name='ShortName' cp='equal'></field>
<field name='ProjectName' cp='equal'></field>
<field name='OwnerUnit' cp='equal'></field>
<field name='DesignUnit' cp='equal'></field>
<field name='ConstructionUnit' cp='equal'></field>
</where>
</settings>");
var service = new mms_projectService();
var pQuery = query.ToParamQuery();
var result = service.GetDynamicListWithPaging(pQuery);
return result;
}
public dynamic Get(RequestWrapper query)
{
query.LoadSettingXmlString(@"
<settings defaultOrderBy='ID'>
<select>*</select>
<from>mms_test</from>
<where defaultForAll='true' defaultCp='equal' defaultIgnoreEmpty='true' >
<field name='ID' cp='equal'></field>
<field name='ProjectName' cp='like' ></field>
<field name='DeclaringUnits' cp='like'></field>
<field name='ProjectType' cp='equal'></field>
<field name='StartDate' cp='dtgreaterequal'></field>
<field name='EndDate' cp='dtlessequal'></field>
</where>
</settings>");
var service = new mms_testService();
var pQuery = query.ToParamQuery();
var result = service.GetDynamicListWithPaging(pQuery);
return result;
}
// 查询主表：GET api/mms/send
public dynamic Get(RequestWrapper query)
{
query.LoadSettingXmlString(@"
<settings defaultOrderBy='UserCode'>
<select>
*
</select>
<from>
test_user
</from>
<where defaultForAll='true' defaultCp='equal' defaultIgnoreEmpty='true' >
<field name='UserCode' cp='like' ></field>
<field name='UserName' cp='like' ></field>
<field name='Description' cp='like' ></field>
<field name='IsEnable' cp='equal' ></field>
<field name='LoginCount' cp='equal' ></field>
<field name='LastLoginDate' cp='daterange' ></field>
</where>
</settings>");
var pQuery = query.ToParamQuery();
var list = new mms_sendService().GetDynamicListWithPaging(pQuery);
return list;
}
public dynamic GetStockList(RequestWrapper query)
{
//stockstate :0:安全库存 1：库存即将不足 2：库存不足
query.LoadSettingXmlString(@"
<settings defaultOrderBy='A.Id'>
<select>A.*,C.Model,C.Unit,C.Catagory,C.Brand,C.Name as GoodName,
Case when A.Num>A.WarnStock
then
case when A.Num*0.8>A.WarnStock
then '安全库存'
else '库存即将不足'
end
else '库存不足'
end as StockState
</select>
<from>
psi_warehouseStock as A
left join psi_warehouse as B ON B.Id=A.Id
left join psi_goods as C ON C.Id=A.GoodNo
</from>
<where defaultForAll='true' defaultCp='equal' defaultIgnoreEmpty='true' >
<field name='C.Name' cp='like' variable='GoodName'></field>
<field name='B.Id' cp='equal' variable='Id' ></field>
<field name='B.ChargePerson' cp='like' variable='ChargePerson'></field>
</where>
</settings>");
var service = new psi_warehouseService();
var pQuery = query.ToParamQuery();
//if (query["stateItems"] == "true")
// pQuery.AndWhere("AuditState", "passed");
//else
// pQuery.AndWhere("isnull(AuditState,'')", "passed", Cp.notequal);
var result = service.GetDynamicListWithPaging(pQuery);
return result;
}
public dynamic Get(RequestWrapper query)
{
query.LoadSettingXmlString(@"
<settings defaultOrderBy='BillNo'>
<select>
A.*,B.Name as WarehouseName,C.Name as CustomerName
</select>
<from>
psi_picking A
left join psi_warehouse B on B.Id = A.Warehouse
left join psi_customer C on C.Id = A.CustomNo
left join psi_customerContract D on D.ContractNo = A.Contract
</from>
<where defaultForAll='true' defaultCp='equal' defaultIgnoreEmpty='true' >
<field name='BillNo' cp='equal' ></field>
<field name='Warehouse' cp='equal' ></field>
<field name='PickingPerson' cp='like' ></field>
<field name='PickingDate' cp='daterange' ></field>
<field name='C.Name' cp='like' variable='CustomerName'></field>
<field name='Contract' cp='like' ></field>
</where>
</settings>");
var PickingService = new psi_pickingService();
var pQuery = query.ToParamQuery();
var result = PickingService.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 Get(RequestWrapper query)
{
query.LoadSettingXmlString(@"
<settings defaultOrderBy='BillNo'>
<select>
A.*
</select>
<from>
psi_return A
</from>
<where defaultForAll='true' defaultCp='equal' defaultIgnoreEmpty='true' >
<field name='BillNo' cp='like' ></field>
<field name='PickingBillNo' cp='like' ></field>
<field name='ReturnPerson' cp='like' ></field>
<field name='Contract' cp='like' ></field>
<field name='ReturnDate' cp='daterange' ></field>
<field name='CustomNo' cp='like'></field>
</where>
</settings>");
var ReturnService = new psi_returnService();
var pQuery = query.ToParamQuery();
var result = ReturnService.GetDynamicListWithPaging(pQuery);
return result;
}
public dynamic Get(RequestWrapper request)
{
request.LoadSettingXmlString("<settings defaultOrderBy='ParamCode'></settings>");
return new sys_parameterService().GetModelListWithPaging(request.ToParamQuery());
}
public dynamic Get(RequestWrapper query)
{
query.LoadSettingXmlString(@"
<settings defaultOrderBy='EMPSID'>
<select>*</select>
<from>REMP_Staff</from>
<where defaultForAll='true' defaultCp='equal' defaultIgnoreEmpty='true' >
<field name='UserName' cp='equal'></field>
<field name='EmployeeName' cp='equal'></field>
<field name='DisplayName' cp='equal'></field>
<field name='UserType' cp='equal'></field>
<field name='EmployeeCode' cp='equal'></field>
<field name='Birthday' cp='daterange'></field>
</where>
</settings>");
var service = new REMP_StaffService();
var pQuery = query.ToParamQuery();
var result = service.GetDynamicListWithPaging(pQuery);
return result;
}
public dynamic Get(RequestWrapper query)
{
query.LoadSettingXmlString(@"
<settings defaultOrderBy='BillNo'>
<select>
A.*,B.Name as SupplierName,case when A.AuditState='passed' then 'true' else 'false' end as IsEffect
</select>
<from>
psi_purchase A
left join psi_supplier B on B.Id = A.Supplier
</from>
<where defaultForAll='false' defaultCp='equal' defaultIgnoreEmpty='true' >
<field name='BillNo' cp='equal' ></field>
<field name='PurchasePerson' cp='like' ></field>
<field name='Contract' cp='like' ></field>
<field name='PurchaseDate' cp='daterange' ></field>
<field name='C.Name' cp='like' variable='SupplierName'></field>
</where>
</settings>");
var PurchaseService = new psi_purchaseService();
var pQuery = query.ToParamQuery();
pQuery.AndWhere("AuditState", query["IsEffect"], x => x.Value == "true"?"AuditState='passed'":"isnull(AuditState,'') <> 'passed'");
var result = PurchaseService.GetDynamicListWithPaging(pQuery);
return result;
}
public IEnumerable<dynamic> Get(RequestWrapper req)
{
req.LoadSettingXmlString("<settings defaultOrderBy='RoleSeq'></settings>");
var result = new sys_roleService().GetModelList(req.ToParamQuery());
return result;
}
