// 查询主表: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; }