进出站

ouyangqing

2021-02-25 dcbb1bd3499f2b90cc2a9457959c1f4dcab714a1

 WebAPI/Service/YqnDal.cs

@@ -47,7 +47,7 @@
        public static List<Models.M_StationBillMail> GetStationInBillMailList(string icBillNo)
        {
            StringBuilder sqlBuilder = new StringBuilder();
            sqlBuilder.Append("select HBillType,HInterID,HDate,HBillNo,HICMOBillNo,HEmpID,HProcID from Sc_StationInBillMain where HBillType='3790' and HICMOBillNo=@icBillNo");
            sqlBuilder.Append("select HBillType,HInterID,HDate,HBillNo,HICMOBillNo,HEmpID,HProcID from Sc_StationInBillMain where HBillType='3790' and HProcExchBillNo=@icBillNo");
            var list = SqlPools.GetInstance("YqnConn").GetModelList<Models.M_StationBillMail>(sqlBuilder.ToString(), new { icBillNo });
            return list;
        }
@@ -59,7 +59,7 @@
        public static List<Models.M_StationBillMail> GetStationOutBillMailList(string icBillNo)
        {
            StringBuilder sqlBuilder = new StringBuilder();
            sqlBuilder.Append("select HBillType,HInterID,HDate,HBillNo,HICMOBillNo,HEmpID,HProcID from Sc_StationOutBillMain where HBillType in ('3791','4788') and HICMOBillNo=@icBillNo");
            sqlBuilder.Append("select HBillType,HInterID,HDate,HBillNo,HICMOBillNo,HEmpID,HProcID from Sc_StationOutBillMain where HBillType in ('3791','4788') and HProcExchBillNo=@icBillNo");
            var list = SqlPools.GetInstance("YqnConn").GetModelList<Models.M_StationBillMail>(sqlBuilder.ToString(), new { icBillNo });
            return list;
        }