/// <summary> /// 查询店内指定车辆在指定时间的存货 /// </summary> /// <param name="ShopID">店铺ID</param> /// <param name="VersionID">车的型号</param> /// <param name="StartYear">开始的年份(默认当前年份</param> /// <param name="StartMonth">开始的月份(默认当前月份</param> /// <param name="StartDay">开始的日(默认当前日</param> /// <param name="EndYear">结束的年份(默认当前年份</param> /// <param name="EndMonth">结束的月份(默认当前月份</param> /// <param name="EndDay">结束日(默认当前日</param> /// <returns></returns> public int SelectCarCount_ShopIDAndTime(int ShopID, int VersionID, int?StartYear, int?StartMonth, int?StartDay, int?EndYear, int?EndMonth, int?EndDay) { OrderSummery OrderSummery_Manager = new OrderSummery(); int OrderCount = OrderSummery_Manager.SelectRentaledCarCount_TimeAndVersion(ShopID, VersionID, StartYear, StartMonth, StartDay, EndYear, EndMonth, EndDay); int TatalCount = DB_ViewModel.Select(P => P.Shop_ID == ShopID && P.Version_ID == VersionID).First().Version_Count; return(TatalCount - OrderCount); }
/// <summary> /// 查找一个市内指定时间段里是否还有指定数量的某车型 /// </summary> /// <param name="CityID">城市ID</param> /// <param name="CarCount">所需该车的数量</param> /// <param name="VersionID">车的型号</param> /// <param name="StartYear">开始的年份(默认当前年份</param> /// <param name="StartMonth">开始的月份(默认当前月份</param> /// <param name="StartDay">开始的日(默认当前日</param> /// <param name="EndYear">结束的年份(默认当前年份</param> /// <param name="EndMonth">结束的月份(默认当前月份</param> /// <param name="EndDay">结束日(默认当前日</param> /// <returns></returns> public List <Car_Shop> SelectHasCar_CityIDAndTime(int CityID, int VersionID, int CarCount, int?StartYear, int?StartMonth, int?StartDay, int?EndYear, int?EndMonth, int?EndDay) { List <Car_Shop> List_Shop = new List <Car_Shop>(); OrderSummery OrderSummery_Manager = new OrderSummery(); //遍历在这个城市中每一个有该种类车型的店铺 foreach (Car_ViewModel CarInfo in DB_ViewModel.Select(P => P.Version_ID == VersionID && P.City_ID == CityID).ToList()) { //取得该店铺中剩余数量,当剩余数量大于所需数量时,返回该店铺 int LastCount = OrderSummery_Manager.SelectRentaledCarCount_TimeAndVersion(CarInfo.Shop_ID, VersionID, StartYear, StartMonth, StartDay, EndYear, EndMonth, EndDay); if (LastCount > CarCount) { List_Shop.Add(new Car_Shop() { Shop_ID = CarInfo.Shop_ID, Shop_Info = CarInfo.Shop_Info, Shop_Name = CarInfo.Shop_Name, Shop_Phone = CarInfo.Shop_Phone, Shop_City = CarInfo.City_ID }); } } return(List_Shop); }