Sunji-posv-net/pos/POSV.Template/WaiMai/DeliveryUtils.cs

using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using POSV.Entity;
using POSV.ShoppingCart;
using POSV.Utils;

namespace POSV.WaiMai
{
    public class DeliveryUtils
    {

        /// <summary>
        /// 根据电话号码获取熟客信息和最新的配送地址
        /// </summary>
        /// <param name="telephone"></param>
        /// <returns></returns>
        public static Tuple<Visitor , List<VisitorAddress> , List<VisitorTag>> GetVisitor(string telephone)
        {
            Visitor visitor = null;
            List<VisitorAddress> address = null;
            List<VisitorTag> tags = null;

            using (var db = Global.Instance.OpenDataBase)
            {
                visitor = db.FirstOrDefault<Visitor>("where tel = @0" , telephone);

                if (visitor != null)
                {
                    address = db.Query<VisitorAddress>("where visitorId = @0 order by createDate desc" , visitor.Id).ToList();

                    tags = db.Query<VisitorTag>("where visitorId = @0 order by createDate desc" , visitor.Id).ToList();
                }
                else
                {
                    address = new List<VisitorAddress>();

                    tags = new List<VisitorTag>();
                }
            }

            return new Tuple<Visitor , List<VisitorAddress> , List<VisitorTag>>(visitor , address , tags);

        }
        
    }
}