using System;
using System.Collections.Generic;
using System.ComponentModel.DataAnnotations.Schema;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using XYY.Core.Standard.Data.Infrastructure;
using XYY.Model.Standard.Order;

namespace XYY.Data.Standard.Order
{
    public interface IAlterExpressNoLogRepository : IBaseRepository<AlterExpressNoLog>
    { 
        //List<int> GetWiatSendEmailUsers(DateTime date);
         
    }
    public class AlterExpressNoLogRepository : BaseRepository<AlterExpressNoLog>, IAlterExpressNoLogRepository
    {
        public AlterExpressNoLogRepository(IUnitOfWork unitOfWork) : base(unitOfWork)
        {

        }
         
        //public List<User_Customer> GetWiatSendEmailUsers(DateTime date)
        //{
        //    DateTime start = new DateTime(date.Year, date.Month, date.Day);
        //    DateTime end = start.AddDays(1);
        //    string sql = @"
        //                    select CustomerId as Id  from View_AlterExpressNoLog(nolock) 
        //                    where ReceiveTime
        //                    between @start and @end
        //                    group by CustomerId";

        //    return _unitOfWork.QueryBySql<User_Customer>(sql, null, new { start, end }).ToList();
        //}


 

        [Table("#tempOrders")]
        public class tempOrder
        {
            public int OrderId
            {
                get; set;
            }
        }
    }
}
