Esempi in C# (CSharp) per trade_schedulerService

Esempio n. 1

        //todo 改成支持多个Tab
        // 地址：GET api/mms/@(controller)/getnewrowid 预取得新的明细表的行号
        public string GetNewRowId(string type, string key, int qty = 1)
        {
            switch (type)
            {
            case "grid0":
                var service0 = new trade_schedulerService();
                return(service0.GetNewKey("SNO", "maxplus", qty, ParamQuery.Instance().Where("JOBNO", key)));

            default:
                return("");
            }
        }

Esempio n. 2

File: SchedulerController.cs Progetto: uwitec/web-mvc-logistics

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

Esempio n. 3

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

Esempio n. 4

File: TrailerController.cs Progetto: uwitec/web-mvc-logistics

 //todo 改成支持多个Tab
 // 地址：GET api/mms/@(controller)/getnewrowid 预取得新的明细表的行号
 public string GetNewRowId(string type,string key,int qty=1)
 {
     switch (type)
     {
         case "grid0":
             var service0 = new trade_schedulerService();
             return service0.GetNewKey("SNO", "maxplus", qty, ParamQuery.Instance().Where("JOBNO", key));
         default:
             return "";
     }
 }