public override dynamic Get(RequestWrapper query)
{
query.SetXml(@"
<settings >
<select>
A.*, B.ProjectName, C.MerchantsName
</select>
<from>
mms_rentOff A
left join mms_project B on B.ProjectCode = A.ProjectCode
left join mms_merchants C on C.MerchantsCode = A.SupplierCode
</from>
<where>
<c column='BillNo' symbol='equal' ignore='empty'></c>
<c column='ProjectName' symbol='like' ignore='empty'></c>
<c column='DoPerson' symbol='like' ignore='empty'></c>
<c column='ContractCode' symbol='equal' ignore='empty'></c>
<c column='BeginDate' symbol='daterange' ignore='empty'></c>
<c column='EndDate' symbol='daterange' ignore='empty'></c>
</where>
<orderby>BillNo</orderby>
</settings>");
return(base.Get(query));
}
// 查询主表数据列表 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);
}
// 查询主表：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 override dynamic Get(RequestWrapper query)
{
query.SetXml(@"
<settings >
<select>
A.*, B.ProjectName, C.MerchantsName
</select>
<from>
mms_rentOut A
left join mms_project B on B.ProjectCode = A.ProjectCode
left join mms_merchants C on C.MerchantsCode = A.SupplierCode
</from>
<where>
<c column='BillNo' symbol='equal' ignore='empty'></c>
<c column='ProjectName' symbol='like' ignore='empty'></c>
<c column='C.MerchantsName' symbol='like' ignore='empty'></c>
<c column='ContractCode' symbol='like' ignore='empty'></c>
<c column='RentOutDate' symbol='daterange' ignore='empty'></c>
</where>
<orderby>BillNo</orderby>
</settings>");
var pQuery = query.ToParamQuery().Where(c => c.Sql(query.GetValue <bool>("IsTotal") ? "IsTotal=1" : "isnull(IsTotal,0)<>1"));
var result = masterService.GetDynamicListWithPaging(pQuery);
return(result);
}
// 查询主表：GET api/mms/send
public override dynamic Get(RequestWrapper query)
{
query.SetXml(@"
<settings>
<select>
A.*, B.ProjectName, C.MaterialTypeName, D.WarehouseName,E.MerchantsName as PickUnitName
</select>
<from>
mms_send 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.PickUnit
</from>
<where >
<c column='BillNo' symbol='equal' ignore='empty' ></c>
<c column='ProjectName' symbol='like' ignore='empty' ></c>
<c column='DoPerson' symbol='like' ignore='empty' ></c>
<c column='A.WarehouseCode' symbol='equal' ignore='empty' values='{WarehouseCode}' ></c>
<c column='E.MerchantsName' symbol='equal' ignore='empty' values='{PickUnitName}' ></c>
<c column='SendDate' symbol='daterange' ignore='empty' ></c>
<c column='PriceKind' symbol='equal' ignore='empty' ></c>
</where>
<orderby>BillNo</orderby>
</settings>");
var pQuery = query.ToParamQuery().Where("A.ProjectCode", MmsHelper.GetCurrentProject());
return(masterService.GetDynamicListWithPaging(pQuery));
}
public override dynamic Get(RequestWrapper query)
{
query.SetXml(@"
<settings>
<select>
A.*, B.ProjectName
</select>
<from>
mms_deal A
left join mms_project B on B.ProjectCode = A.ProjectCode
</from>
<where>
<c column='BillNo' symbol='equal' ignore='empty' ></c>
<c column='ProjectName' symbol='like' ignore='empty' ></c>
<c column='DoPerson' symbol='like' ignore='empty' ></c>
<c column='DealType' symbol='equal' ignore='empty' ></c>
<c column='DealKind' symbol='equal' ignore='empty' ></c>
<c column='ApplyDate' symbol='daterange' ignore='empty' ></c>
</where>
<orderby>BillNo</orderby>
</settings>");
var pQuery = query.ToParamQuery().Where("A.ProjectCode", MmsHelper.GetCurrentProject());
return(masterService.GetDynamicListWithPaging(pQuery));
}
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='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 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 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);
}
// 查询主表数据列表 GET api/trade/send
public virtual dynamic Get(RequestWrapper query)
{
//todo
//if (!query.IsLoadedSettings)
query.SetXml(string.Format(@"
<settings>
<select>*</select>
<from>{0}</from>
<where>
<c column='Jobno' ignore='empty'></c>
</where>
<orderby>Jobno</orderby>
</settings>", typeof(TMasterModel).Name));
var pQuery = query.ToParamQuery();
var result = masterService.GetDynamicListWithPaging(pQuery);
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_productTest</from>
<where>
<c column='ProductName' ignore='empty' cp='like'></c>
<c column='ProductCode' ignore='empty' cp='startwith'></c>
<c column='ProductColor' ignore='empty' cp='equal'></c>
<c column='ProductType' ignore='empty' cp='equal'></c>
<c column='ProductDate' ignore='empty' cp='daterange'></c>
</where>
<orderby>ID</orderby>
</settings>");
var service = new mms_productTestService();
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_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>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);
}
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);
}
public override dynamic Get(RequestWrapper query)
{
query.SetXml(@"
<settings>
<select>
A.*, B.ProjectName, C.MaterialTypeName, D.WarehouseName
</select>
<from>
mms_check 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
</from>
<where>
<c column='BillNo' symbol='equal' ignore='empty' ></c>
<c column='ProjectName' symbol='like' ignore='empty' ></c>
<c column='DoPerson' symbol='like' ignore='empty' ></c>
<c column='A.WarehouseCode' symbol='equal' ignore='empty' values='{WarehouseCode}'></c>
<c column='A.MaterialType' symbol='equal' ignore='empty' ></c>
<c column='CheckDate' symbol='daterange' ignore='empty' ></c>
</where>
<orderby>BillNo</orderby>
</settings>");
//if(query["IsShowDiff"] == "true")
// var a =0;
//var pQuery = query.ToParamQuery().Where("IsShowDiff", query["IsShowDiff"],
// x => "true".Equals(x.Value) ? "isnull(A.BookMoney,0)<>isnull(A.OperateMoney,0)" : "1=1").AndWhere("A.ProjectCode", MmsHelper.GetCurrentProject());
//.AndWhere("CheckDate", query["CheckDate"], x => x == null ? "1=1" : string.Format("CheckDate", x.Value));
var pQuery = query.ToParamQuery()
.Where(c => c.Sql("isnull(A.BookMoney,0)<>isnull(A.OperateMoney,0)").Ignore(x => query.GetValue("IsShowDiff").Equals("true")))
.Where("A.ProjectCode", MmsHelper.GetCurrentProject());
var result = masterService.GetDynamicListWithPaging(pQuery);
return(result);
}
