Exemplo n.º 1
0
        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);
        }
Exemplo n.º 2
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);
        }
Exemplo n.º 3
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;
        }
Exemplo n.º 4
0
        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;
        }