出站接收单

ouyangqing

2021-02-26 81f910a207cc9de19995e9aa06d4171ccc84ad62

出站接收单

 WebAPI/Service/YqnDal.cs

@@ -19,7 +19,7 @@
        {
            StringBuilder sqlBuilder = new StringBuilder();
            sqlBuilder.Append("select top 1 HBillType,HInterID,HDate,HBillNo,HICMOBillNo,HEmpID,HProcID from Sc_StationInBillMain where HBillType='3790' ");
            sqlBuilder.Append(" and HICMOBillNo=@icmoBillNo ");
            sqlBuilder.Append(" and HProcExchBillNo=@icmoBillNo ");
            sqlBuilder.Append(" and HProcID=@hProcID");
            var model = SqlPools.GetInstance("YqnConn").GetModel<Models.M_StationBillMail>(sqlBuilder.ToString(), new {  icmoBillNo,hProcID });
            return model;
@@ -34,7 +34,7 @@
        {
            StringBuilder sqlBuilder = new StringBuilder();
            sqlBuilder.Append("select top 1 HBillType,HInterID,HDate,HBillNo,HICMOBillNo,HEmpID,HProcID from Sc_StationOutBillMain where HBillType in ('3791','4788') ");
            sqlBuilder.Append(" and HICMOBillNo=@icmoBillNo ");
            sqlBuilder.Append(" and HProcExchBillNo=@icmoBillNo ");
            sqlBuilder.Append(" and HProcID=@hProcID");
            var model = SqlPools.GetInstance("YqnConn").GetModel<Models.M_StationBillMail>(sqlBuilder.ToString(), new { icmoBillNo, hProcID });
            return model;

 WebAPI/Service/YqnQbService.cs

@@ -190,10 +190,10 @@
                return new ApiResult { code = -1, msg = "服务器繁忙" };
            try
            {
                var stationInBillModel = YqnDal.GetStationInBillMail(omodel.HProcID, omodel.HICMOBillNo);
                var stationInBillModel = YqnDal.GetStationInBillMail(omodel.HProcID, omodel.HProcExchBillNo);
                if (stationInBillModel == null)
                    return new ApiResult { code = -1, msg = "该工序进站单不存在" };
                var stationOutBillModel = YqnDal.GetStationOutBillMail(omodel.HProcID, omodel.HICMOBillNo);
                var stationOutBillModel = YqnDal.GetStationOutBillMail(omodel.HProcID, omodel.HProcExchBillNo);
                if (stationOutBillModel != null)
                    return new ApiResult { code = -1, msg = "该工序已存在出站单" };
                omodel.HYear = DateTime.Now.Year;