Ejemplos de trade_trailerService en C# (CSharp)

Ejemplo n.º 1

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

            var tabsWrapper = new List <RequestWrapper>();

            tabsWrapper.Add(RequestWrapper.Instance().SetXml(@"
<settings>
    <table>trade_scheduler</table>
    <where>
        <c column='JOBNO' symbol='equal'></c>      
        <c column='SNO' symbol='equal'></c>      
    </where>
</settings>"));

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

Ejemplo n.º 2

Archivo: TrailerController.cs Proyecto: uwitec/web-mvc-logistics

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

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

Ejemplo n.º 3

Archivo: TrailerController.cs Proyecto: uwitec/web-mvc-logistics

        public dynamic GetPageData(string id)
        {
            var masterService = new trade_trailerService();
            var pQuery = ParamQuery.Instance().Where("JOBNO", id);

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

                //明细数据
                tab0 = new trade_schedulerService().GetDynamicList(pQuery)
            };
            return result;
        }

Ejemplo n.º 4

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

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

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

Ejemplo n.º 5

        public dynamic GetPageData(string id)
        {
            var masterService = new trade_trailerService();
            var pQuery        = ParamQuery.Instance().Where("JOBNO", id);

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

                //明细数据
                tab0 = new trade_schedulerService().GetDynamicList(pQuery)
            };

            return(result);
        }

Ejemplo n.º 6

Archivo: TrailerController.cs Proyecto: uwitec/web-mvc-logistics

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

Ejemplo n.º 7

Archivo: TrailerController.cs Proyecto: uwitec/web-mvc-logistics

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

            var tabsWrapper = new List<RequestWrapper>();
            tabsWrapper.Add(RequestWrapper.Instance().SetXml(@"
<settings>
    <table>trade_scheduler</table>
    <where>
        <c column='JOBNO' symbol='equal'></c>      
        <c column='SNO' symbol='equal'></c>      
    </where>
</settings>"));
             
            var service = new trade_trailerService();
            var result = service.Edit(data, formWrapper, tabsWrapper);
        }

Ejemplo n.º 8

Archivo: TrailerController.cs Proyecto: uwitec/web-mvc-logistics

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