/// <summary> /// 删除所有的过期订单 /// </summary> /// <returns></returns> public int Delete_OverTime(int ShopID) { TimeSpan TS_Now = new TimeSpan(DateTime.Now.Ticks); List <Car_Order> List_CarOrder = DB_CarOrder.Select(P => new TimeSpan(P.Order_Time.Ticks).Subtract(TS_Now).Duration().Days >= 2 && P.Order_Shop == ShopID).ToList(); List <Car_Checkout> List_Check = new List <Car_Checkout>(); foreach (Car_Order temp in List_CarOrder) { List_Check.Add(DB_Checkout.Select(P => P.Checkout_Order == temp.Order_ID).SingleOrDefault()); } if (DB_Checkout.Delete_ALL(List_Check)) { foreach (Car_Order temp in List_CarOrder) { DB_CarOrder.Delete(temp); } return(List_Check.Count()); } else { foreach (Car_Checkout Temp in List_Check) { DB_Checkout.Insert(Temp); } return(0); } }
/// <summary> /// 将员工开除出店铺 /// </summary> /// <param name="UserID">店铺ID</param> /// <returns></returns> public bool UserDropShop_ShopID(int ShopID) { List <UserInShop> new_UIS; try { new_UIS = DB_UserInShop.Select(P => P.ShopID == ShopID).ToList(); } catch (Exception) { return(true); } return(DB_UserInShop.Delete_ALL(new_UIS)); }