C# (CSharp) mms_receiveService Beispiele

Beispiel #1

Datei: CheckController.cs Projekt: leo0530/Zephyr

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

            var listWrapper = RequestWrapper.Instance().LoadSettingXmlString(@"
<settings>
    <columns ignore='MaterialName,Model,Material'></columns>
    <table>
        mms_receiveDetail
    </table>
    <where>
        <field name='BillNo' cp='equal'></field>
        <field name='RowId'  cp='equal'></field>
    </where>
</settings>");

            var service = new mms_receiveService();
            var result  = service.Edit(formWrapper, listWrapper, data);
        }

Beispiel #2

Datei: CheckController.cs Projekt: leo0530/Zephyr

        // 地址：GET api/mms/send/getdetail 功能：取得收料单明细信息
        public dynamic GetDetail(string id)
        {
            var query = RequestWrapper
                        .InstanceFromRequest()
                        .SetRequestData("BillNo", id)
                        .LoadSettingXmlString(@"
<settings defaultOrderBy='MaterialCode'>
    <select>
        A.*, B.MaterialName,B.Model,B.Material
    </select>
    <from>
        mms_receiveDetail A
        left join mms_materialInfo B on B.MaterialCode = A.MaterialCode
    </from>
    <where>
        <field name='BillNo' cp='equal'></field>
    </where>
</settings>");

            var pQuery         = query.ToParamQuery();
            var ReceiveService = new mms_receiveService();
            var result         = ReceiveService.GetDynamicListWithPaging(pQuery);

            return(result);
        }

Beispiel #3

Datei: CheckController.cs Projekt: Johnnyfly/source20131023

 // GET api/mms/send/geteditmaster 取得编辑页面中的主表数据及上一页下一页主键
  public dynamic GetEditMaster(string id) {
     var projectCode = MmsHelper.GetCookies("CurrentProject");
     var masterService = new mms_receiveService();
     return new{
         form = masterService.GetModel(ParamQuery.Instance().AndWhere("BillNo", id)),
         scrollKeys = masterService.ScrollKeys("BillNo", id, ParamQuery.Instance().AndWhere("ProjectCode", projectCode))
     };
 }

Beispiel #4

Datei: CheckController.cs Projekt: leo0530/Zephyr

        // GET api/mms/send/geteditmaster 取得编辑页面中的主表数据及上一页下一页主键
        public dynamic GetEditMaster(string id)
        {
            var projectCode   = MmsHelper.GetCookies("CurrentProject");
            var masterService = new mms_receiveService();

            return(new{
                form = masterService.GetModel(ParamQuery.Instance().AndWhere("BillNo", id)),
                scrollKeys = masterService.ScrollKeys("BillNo", id, ParamQuery.Instance().AndWhere("ProjectCode", projectCode))
            });
        }

Beispiel #5

Datei: ReceiveController.cs Projekt: uwitec/web-mvc-logistics

        public dynamic Get(RequestWrapper query)
        {
            query.SetXml(@"
<settings>
    <select>*</select>
    <from>mms_receive</from>
    <where>
        <c column='BillNo'		symbol='equal' ignore='empty'></c>   
        <c column='BillDate'		symbol='equal' ignore='empty'></c>   
        <c column='ProjectCode'		symbol='equal' ignore='empty'></c>   
        <c column='DoPerson'		symbol='equal' ignore='empty'></c>   
        <c column='SupplierCode'		symbol='equal' ignore='empty'></c>   
        <c column='ReceiveDate'		symbol='equal' ignore='empty'></c>   
    </where>
    <orderby>BillNo</orderby>
</settings>");
            var service = new mms_receiveService();
            var pQuery = query.ToParamQuery();
            var result = service.GetDynamicListWithPaging(pQuery);
            return result;
        }

Beispiel #6

        public dynamic Get(RequestWrapper query)
        {
            query.SetXml(@"
<settings>
    <select>*</select>
    <from>mms_receive</from>
    <where>
        <c column='BillNo'		symbol='equal' ignore='empty'></c>   
        <c column='BillDate'		symbol='equal' ignore='empty'></c>   
        <c column='ProjectCode'		symbol='equal' ignore='empty'></c>   
        <c column='DoPerson'		symbol='equal' ignore='empty'></c>   
        <c column='SupplierCode'		symbol='equal' ignore='empty'></c>   
        <c column='ReceiveDate'		symbol='equal' ignore='empty'></c>   
    </where>
    <orderby>BillNo</orderby>
</settings>");
            var service = new mms_receiveService();
            var pQuery  = query.ToParamQuery();
            var result  = service.GetDynamicListWithPaging(pQuery);

            return(result);
        }

Beispiel #7

Datei: CheckController.cs Projekt: Johnnyfly/source20131023

        // 地址：GET api/mms/send/getdetail 功能：取得收料单明细信息
         public dynamic GetDetail(string id)
        {
            var query = RequestWrapper
                .InstanceFromRequest()
                .SetRequestData("BillNo",id)
                .LoadSettingXmlString(@"
<settings defaultOrderBy='MaterialCode'>
    <select>
        A.*, B.MaterialName,B.Model,B.Material
    </select>
    <from>
        mms_receiveDetail A
        left join mms_materialInfo B on B.MaterialCode = A.MaterialCode
    </from>
    <where>
        <field name='BillNo' cp='equal'></field>
    </where>
</settings>");

            var pQuery = query.ToParamQuery();
            var ReceiveService = new mms_receiveService();
            var result = ReceiveService.GetDynamicListWithPaging(pQuery);
            return result;
        }

Beispiel #8

Datei: CheckController.cs Projekt: Johnnyfly/source20131023

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

            var listWrapper = RequestWrapper.Instance().LoadSettingXmlString(@"
<settings>
    <columns ignore='MaterialName,Model,Material'></columns>
    <table>
        mms_receiveDetail
    </table>
    <where>
        <field name='BillNo' cp='equal'></field>
        <field name='RowId'  cp='equal'></field>
    </where>
</settings>");
             
            var service = new mms_receiveService();
            var result = service.Edit(formWrapper, listWrapper, data);
        }