C# (CSharp) REMP_StaffService 예제들

예제 #1

        public void Edit(dynamic data)
        {
            var formWrapper = RequestWrapper.Instance().LoadSettingXmlString(@"
<settings>
    <table>
        REMP_Staff
    </table>
    <where>
        <field name='EMPSID' cp='equal'></field>
    </where>
</settings>");

            var tabsWrapper = new List <RequestWrapper>();

            tabsWrapper.Add(RequestWrapper.Instance().LoadSettingXmlString(@"
<settings>
    <table>REMP_Change</table>
    <where>
        <field name='CHANID' cp='equal'></field>      
    </where>
</settings>"));

            var service = new REMP_StaffService();
            var result  = service.EditPage(data, formWrapper, tabsWrapper);
        }

예제 #2

        public void Audit(string id, JObject data)
        {
            var pUpdate = ParamUpdate.Instance()
                          .Update("REMP_Staff")
                          .Column("ApproveState", data["status"])
                          .Column("ApproveRemark", data["comment"])
                          .Column("ApprovePerson", FormsAuth.GetUserData().UserName)
                          .Column("ApproveDate", DateTime.Now)
                          .AndWhere("EMPSID", id);

            var service      = new REMP_StaffService();
            var rowsAffected = service.Update(pUpdate);

            MmsHelper.ThrowHttpExceptionWhen(rowsAffected < 0, "单据审核失败[BillNo={0}]，请重试或联系管理员！", id);
        }

예제 #3

파일: StaffController.cs 프로젝트: Johnnyfly/source20131023

        public dynamic GetPageData(string id)
        {
            var masterService = new REMP_StaffService();
            var pQuery = ParamQuery.Instance().AndWhere("EMPSID", id);

             var result = new {
                //主表数据
                form = masterService.GetModel(pQuery),
                scrollKeys = masterService.ScrollKeys("EMPSID", id),

                //明细数据
                tab0 = new REMP_ChangeService().GetDynamicList(ParamQuery.Instance().AndWhere("CHANID", id)),
            };
            return result;
        }

예제 #4

        public dynamic GetPageData(string id)
        {
            var masterService = new REMP_StaffService();
            var pQuery        = ParamQuery.Instance().AndWhere("EMPSID", id);

            var result = new {
                //主表数据
                form       = masterService.GetModel(pQuery),
                scrollKeys = masterService.ScrollKeys("EMPSID", id),

                //明细数据
                tab0 = new REMP_ChangeService().GetDynamicList(ParamQuery.Instance().AndWhere("CHANID", id)),
            };

            return(result);
        }

예제 #5

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

예제 #6

파일: StaffController.cs 프로젝트: uwitec/web-mvc-logistics

        public void Edit(dynamic data)
        {
            var formWrapper = RequestWrapper.Instance().SetXml(@"
<settings>
    <table>
        REMP_Staff
    </table>
    <where>
        <c column='EMPSID' symbol='equal'></c>
    </where>
</settings>");

            var tabsWrapper = new List <RequestWrapper>();

            tabsWrapper.Add(RequestWrapper.Instance().SetXml(@"
<settings>
    <table>REMP_Change</table>
    <where>
        <c column='CHANID' symbol='equal'></c>      
    </where>
</settings>"));
            tabsWrapper.Add(RequestWrapper.Instance().SetXml(@"
<settings>
    <table>REMP_Staff</table>
    <where>
        <c column='EMPSID' symbol='equal'></c>
    </where>
</settings>"));
            tabsWrapper.Add(RequestWrapper.Instance().SetXml(@"
<settings>
    <table>REMP_Staff</table>
    <where>
        <c column='EMPSID' symbol='equal'></c>
    </where>
</settings>"));

            var service = new REMP_StaffService();
            var result  = service.Edit(data, formWrapper, tabsWrapper);
        }

예제 #7

파일: StaffController.cs 프로젝트: uwitec/web-mvc-logistics

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

예제 #8

파일: StaffController.cs 프로젝트: Johnnyfly/source20131023

        public void Audit(string id, JObject data)
        {
            var pUpdate = ParamUpdate.Instance()
                .Update("REMP_Staff")
                .Column("ApproveState", data["status"])
                .Column("ApproveRemark", data["comment"])
                .Column("ApprovePerson", FormsAuth.GetUserData().UserName)
                .Column("ApproveDate", DateTime.Now)
                .AndWhere("EMPSID", id);

            var service = new REMP_StaffService();
            var rowsAffected = service.Update(pUpdate);
            MmsHelper.ThrowHttpExceptionWhen(rowsAffected < 0, "单据审核失败[BillNo={0}]，请重试或联系管理员！", id);
        }

예제 #9

파일: StaffController.cs 프로젝트: Johnnyfly/source20131023

        public void Edit(dynamic data)
        {
            var formWrapper = RequestWrapper.Instance().LoadSettingXmlString(@"
<settings>
    <table>
        REMP_Staff
    </table>
    <where>
        <field name='EMPSID' cp='equal'></field>
    </where>
</settings>");

            var tabsWrapper = new List<RequestWrapper>();
            tabsWrapper.Add(RequestWrapper.Instance().LoadSettingXmlString(@"
<settings>
    <table>REMP_Change</table>
    <where>
        <field name='CHANID' cp='equal'></field>      
    </where>
</settings>"));
             
            var service = new REMP_StaffService();
            var result = service.EditPage(data, formWrapper, tabsWrapper);
        }

예제 #10

파일: StaffController.cs 프로젝트: uwitec/web-mvc-logistics

        public void Edit(dynamic data)
        {
            var formWrapper = RequestWrapper.Instance().SetXml(@"
<settings>
    <table>
        REMP_Staff
    </table>
    <where>
        <c column='EMPSID' symbol='equal'></c>
    </where>
</settings>");

            var tabsWrapper = new List<RequestWrapper>();
            tabsWrapper.Add(RequestWrapper.Instance().SetXml(@"
<settings>
    <table>REMP_Change</table>
    <where>
        <c column='CHANID' symbol='equal'></c>      
    </where>
</settings>"));
            tabsWrapper.Add(RequestWrapper.Instance().SetXml(@"
<settings>
    <table>REMP_Staff</table>
    <where>
        <c column='EMPSID' symbol='equal'></c>
    </where>
</settings>"));
            tabsWrapper.Add(RequestWrapper.Instance().SetXml(@"
<settings>
    <table>REMP_Staff</table>
    <where>
        <c column='EMPSID' symbol='equal'></c>
    </where>
</settings>"));

            var service = new REMP_StaffService();
            var result = service.Edit(data, formWrapper, tabsWrapper);
        }

예제 #11

파일: StaffController.cs 프로젝트: uwitec/web-mvc-logistics

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

예제 #12

파일: StaffController.cs 프로젝트: Johnnyfly/source20131023

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