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); }