Пример #1
0
        /// <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);
            }
        }
Пример #2
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));
        }