예제 #1
0
        public List <prodRes> BGDprod([FromBody] prodPrm prm)
        {
            var model    = new BorgWarnerMisSQLContext();
            var testData = model.Database.SqlQuery <prodRes>($"EXECUTE dbo.QforProdStart @workNo='{prm.workNo}',@workMan='{prm.workman}',@cGroup='{prm.cgroup}',@startTime='{prm.workStime}',@prodTime='{prm.prodStime}'").ToList();

            return(testData);
        }
예제 #2
0
        public List <prodQueryRes> prodChart([FromBody] prodPrm prm)
        {
            var model    = new BorgWarnerMisSQLContext();
            var p1       = prm.date;
            var p2       = prm.dateunit;
            var p3       = prm.status;
            var testData = model.Database.SqlQuery <prodQueryRes>($"EXECUTE dbo.QforTopIssueProd @date='{p1}',@dateunit='{p2}',@status='{p3}'").ToList();

            return(testData);
        }