Esempio n. 1
0
        // 查询主表: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;
        }
Esempio n. 2
0
        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());
        }
Esempio n. 3
0
        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;
        }
Esempio n. 6
0
        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;
        }
Esempio n. 7
0
        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;
        }
Esempio n. 8
0
        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;
        }
Esempio n. 9
0
        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);
        }
Esempio n. 14
0
        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;
        }