예제 #1
0
        public IEnumerable <Shfmst> GetTWLShifts(string coNum, string whNum, int batchsize = 0, string fldlist = "")
        {
            var getTWLShiftsApi = new GetTWLShiftsApi()
            {
                coNum     = coNum,
                whNum     = whNum,
                batchsize = batchsize,
                fldlist   = fldlist
            };

            return(this.shfmstService.GetTWLShifts(getTWLShiftsApi));
        }
예제 #2
0
        public IEnumerable <Shfmst> GetTWLShifts(GetTWLShiftsApi getTWLShiftsApi)
        {
            var sb = new StringBuilder();

            if (!string.IsNullOrWhiteSpace(getTWLShiftsApi.coNum))
            {
                sb.AppendFormatWithEscape("shfmst.co_num = '{0}'", getTWLShiftsApi.coNum);
                if (!string.IsNullOrWhiteSpace(getTWLShiftsApi.whNum))
                {
                    sb.AppendFormatWithEscape(" AND shfmst.wh_num = '{0}'", getTWLShiftsApi.whNum);
                }
                if (getTWLShiftsApi.shfNum > 0)
                {
                    sb.AppendFormatWithEscape(" AND shfmst.shf_num = '{0}'", getTWLShiftsApi.shfNum);
                }
            }
            var where = sb.ToString();
            return(this.shfmstRepository.GetList(where, getTWLShiftsApi.batchsize, getTWLShiftsApi.fldlist));
        }
예제 #3
0
 public IEnumerable <Shfmst> GetTWLShifts(GetTWLShiftsApi getTWLShiftsApi)
 {
     return(this.shfmstService.GetTWLShifts(getTWLShiftsApi));
 }