示例#1
0
        public List <Rule> GetRules(int locationId, string palletOrderStatusCode)
        {
            PalletOrderStatus palletOrderStatus = PalletOrderStatus.Find(palletOrderStatusCode);

            return(GetRules(
                       locationId,
                       palletOrderStatus?.Code ?? "",
                       palletOrderStatus != null ? "OMS" : "INT"));
        }
        /*
         *      <isNotEqual property="statusCode" compareValue="007">
         *              plto_lne pl,
         *      </isNotEqual>
         *      <isEqual property = "statusCode" compareValue="007">
         *              plto_prfl_lne pl,
         *      </isEqual>
         */

        #endregion


        #region -- Public Methods --

        public List <OrderLine> GetOrderLines(string orderId, PalletOrderStatus palletOrderStatus)
        {
            string sql = GET_ORDERLINES_FOR_ORDER_SQL.Replace(
                "PLTO_LINE_PLACEHOLDER",
                palletOrderStatus.Code == PalletOrderStatus.SET_FOR_MANUAL_RELEASE.Code ? "plto_prfl_lne pl" : "plto_lne pl");


            return(Select <OrderLine>
                   (
                       sql,
                       new
            {
                OrderId = orderId,
            }
                   ));
        }