public void VisitorCountService_Test_UpdateOrderCount() { // arrange var options = new DbContextOptionsBuilder <ApplicationDbContext>() .UseInMemoryDatabase(databaseName: "VisitorCountService_Test_UpdateOrderCount") .Options; var orderCountEntity = new OrderCount { Date = DateTime.Now, Count = 100 }; using (var context = new ApplicationDbContext(options)) { context.OrderCounts.Add(orderCountEntity); context.SaveChanges(); } using (var context = new ApplicationDbContext(options)) { var service = new Service(context); // act service.OrderCountService.UpdateOrderCount(orderCountEntity); // assert Assert.Equal(101, service.OrderCountService.GetAllOrderCount().Single().Count); } }
public ActionResult OrderCount(DateTime st, DateTime et, string a, string p, string i) { var sqlWhere = SqlWhere(st, et, a, p); string sql = string.Format( "select Account,Count(Id),Platform,Sum(Amount),Min(CurrencyCode) from OrderType {0} group by Account,Platform", sqlWhere); if (!string.IsNullOrEmpty(i)) { sql += " ,CurrencyCode"; } IList<object[]> objs = NSession.CreateQuery(sql).List<object[]>(); List<OrderCount> list = new List<OrderCount>(); int sum = 0; foreach (object[] objectse in objs) { OrderCount oc = new OrderCount { Account = objectse[0].ToString(), OCount = Convert.ToInt32(objectse[1]), Platform = objectse[2].ToString(), TotalAmount = Math.Round(Convert.ToDouble(objectse[3].ToString()), 2), CurrencyCode = objectse[4].ToString() }; sum += Convert.ToInt32(objectse[1]); list.Add(oc); } List<object> footers = new List<object>(); footers.Add(new { OCount = sum }); return Json(new { rows = list.OrderByDescending(f => f.OCount), footer = footers, total = list.Count }); }
public void OrderCountService_Test_UpdateOrderCount() { var options = new DbContextOptionsBuilder <ApplicationDbContext>() .UseInMemoryDatabase("OrderCount_Service_UpdateOrderCount") .Options; var orderCountEntity = new OrderCount() { Date = DateTime.Now, Count = 100 }; using (var context = new ApplicationDbContext(options)) { context.Add(orderCountEntity); context.SaveChanges(); } using (var context = new ApplicationDbContext(options)) { var service = new Service(context); service.OrderCountService.UpdateOrderCount(orderCountEntity); //act Assert.Equal( 101, service.OrderCountService.GetOrderCountByDate(DateTime.Now).Count); } }
public void OrderCountService_Test_GetOrderCountByDate() { var options = new DbContextOptionsBuilder <ApplicationDbContext>() .UseInMemoryDatabase("OrderCount_Service_GetOrderCountByDate") .Options; var orderEntity = new OrderCount() { Date = DateTime.Now.Date, Count = 100 }; using (var context = new ApplicationDbContext(options)) { context.OrderCounts.Add(orderEntity); context.SaveChanges(); } using (var context = new ApplicationDbContext(options)) { var service = new Service(context); //assert Assert.NotNull( service.OrderCountService.GetOrderCountByDate(DateTime.Now)); } }
public ActionResult OrderCount(DateTime st, DateTime et, string a, string p, string i) { var sqlWhere = SqlWhere(st, et, a, p); string sql = string.Format( "select Account,Count(Id),Platform,Sum(Amount),Min(CurrencyCode) from OrderType {0} group by Account,Platform", sqlWhere); if (!string.IsNullOrEmpty(i)) { sql += " ,CurrencyCode"; } IList <object[]> objs = NSession.CreateQuery(sql).List <object[]>(); List <OrderCount> list = new List <OrderCount>(); int sum = 0; foreach (object[] objectse in objs) { OrderCount oc = new OrderCount { Account = objectse[0].ToString(), OCount = Convert.ToInt32(objectse[1]), Platform = objectse[2].ToString(), TotalAmount = Math.Round(Convert.ToDouble(objectse[3].ToString()), 2), CurrencyCode = objectse[4].ToString() }; sum += Convert.ToInt32(objectse[1]); list.Add(oc); } List <object> footers = new List <object>(); footers.Add(new { OCount = sum }); return(Json(new { rows = list.OrderByDescending(f => f.OCount), footer = footers, total = list.Count })); }
public void InsertOrder(Order order) { if (order == null) { throw new ArgumentNullException("order"); } _orderRepository.Insert(order); _orderItemRepository.SaveChanges(); //add or update order count var orderCountEntity = _orderCountService.GetOrderCountByDate(DateTime.Now); if (orderCountEntity != null) { _orderCountService.UpdateOrderCount(orderCountEntity); } else { var orderCountModel = new OrderCount { Date = DateTime.Now, Count = 1 }; _orderCountService.InsertOrderCount(orderCountModel); } }
public cPCLocal() { AllStatueTick = new StatueTick(); AllOrderCount = new OrderCount(); AllCountPerHour = new CountPerHour(); AllMcgs = new AllMcgsStatue(); AllStatueTestTime = new cAllStatueTestTime(); }
public virtual List <Message> UpdateOrderLine(Address address, Settings settings, Func <string, bool> confirm = null, string comment = null, bool edit = true) { var result = new List <Message>(); if (address == null) { OrderCount = null; return(result); } var order = Price.Order; if (OrderCount.GetValueOrDefault() > 0) { if (OrderLine == null) { if (order == null) { order = new Order(Price, address); Price.Order = order; address.Orders.Add(order); } OrderLine = new OrderLine(order, this, orderCount.Value); orderLine.Comment = comment; order.AddLine(OrderLine); } else { OrderLine.Count = OrderCount.Value; OrderLine.Comment = comment; order.UpdateStat(); } if (edit) { result.AddRange(OrderLine.EditValidate()); result.AddRange(EditValidate(address, settings)); } else { result = OrderLine.SaveValidate(confirmCallback: confirm); } OrderCount = OrderLine.Count; } if (OrderCount.GetValueOrDefault(0) == 0 && OrderLine != null) { if (address.RemoveLine(orderLine)) { Price.Order = null; } OrderLine = null; } return(result); }
public ActionResult Indexx() //我的人力服務瀏覽 { Session["CaseIDD"] = null; if (Session["MEMBERID"] == null) { Session["MEMBERID"] = 3;//先寫死 } int memberid = (int)Session["MEMBERID"]; List <CaseManPower> cms = new List <CaseManPower>(); var q = (from o in db.Cases join m in db.ManPower on o.CaseID equals m.CaseID where o.MemberID == memberid orderby o.StartDateTime select o).ToList(); List <OrderCount> oco = new List <OrderCount>(); foreach (var a in q) { OrderCount ocou = new OrderCount(); ocou.CaseID = a.CaseID; ocou.CaseTitle = a.CaseTitle; ocou.Cou = db.Orders.Where(o => o.CaseID == a.CaseID).Count(); oco.Add(ocou); CaseManPower cm = new CaseManPower(); cm.CaseID = a.CaseID; cm.CaseTitle = a.CaseTitle; cm.StartDateTime = a.StartDateTime; int caseid = a.CaseID; int stasid = a.StatusID; cm.StatusName = db.CaseStatus.Find(stasid).StatusName; var q2 = db.ManPower.Where(m => m.CaseID == caseid).Select(m => m); foreach (var x in q2) { cm.MPName = x.MPName; cm.MPPoint = x.MPPoint; cm.MPNeedCount = x.MPNeedCount; //需要的人數 cm.MPActuralCount = x.MPActuralCount; //實際徵求到的人數 cm.MPTime = x.MPTime; //徵求時間 cm.MPDate = x.MPDate; //徵求日期 } cms.Add(cm); } //MemberCaseCount mcc = new MemberCaseCount(); //var t = mcc.casecount(memberid); int ccount = db.Cases.Where(o => o.MemberID == memberid).Count(); ViewBag.allcase = ccount; ViewBag.MPcase = q.Count(); ViewBag.Count = oco; return(View(cms)); }
/// <summary> /// Insert OrderCount /// </summary> /// <param name="orderCount">OrderCount entity</param> public void InsertOrderCount(OrderCount orderCount) { if (orderCount == null) throw new ArgumentNullException("orderCount"); orderCount.Date = orderCount.Date.Date; _orderCountRepository.Insert(orderCount); _orderCountRepository.SaveChanges(); }
// GET: MyCaseCenter/MyGood public ActionResult Index() //我的物品瀏覽 { Session["CaseID"] = null; if (Session["MEMBERID"] == null) { Session["MEMBERID"] = 12;//先寫死 } int memberid = (int)Session["MEMBERID"]; List <CaseGood> cgs = new List <CaseGood>(); var q = (from o in db.Cases join c in db.Goods on o.CaseID equals c.CaseID where o.MemberID == memberid orderby o.StartDateTime select o).ToList(); List <OrderCount> oco = new List <OrderCount>(); foreach (var a in q) { OrderCount ocou = new OrderCount(); ocou.CaseID = a.CaseID; ocou.CaseTitle = a.CaseTitle; ocou.Cou = db.Orders.Where(o => o.CaseID == a.CaseID).Count(); oco.Add(ocou); CaseGood cg = new CaseGood(); cg.CaseID = a.CaseID; cg.CaseTitle = a.CaseTitle; cg.StartDateTime = a.StartDateTime; int caseid = a.CaseID; int stasid = a.StatusID; cg.StatusName = db.CaseStatus.Find(stasid).StatusName; var q2 = db.Goods.Where(m => m.CaseID == caseid).Select(m => m); foreach (var x in q2) { cg.GdsName = x.GdsName; cg.GdsPoint = x.GdsPoint; cg.GdsCount = x.GdsCount; } cgs.Add(cg); } //MemberCaseCount mcc = new MemberCaseCount(); //var t = mcc.casecount(memberid); int ccount = db.Cases.Where(o => o.MemberID == memberid).Count(); ViewBag.allcase = ccount; ViewBag.GDcase = q.Count(); ViewBag.Count = oco; return(View(cgs)); }
/// <summary> /// Update OrderCount /// </summary> /// <param name="orderCount">OrderCount entity</param> public void UpdateOrderCount(OrderCount orderCount) { if (orderCount == null) throw new ArgumentNullException("orderCount"); orderCount.Date = orderCount.Date.Date; orderCount.Count++; _orderCountRepository.Update(orderCount); _orderCountRepository.SaveChanges(); }
public override int GetHashCode() { unchecked { var hash = 17; hash = hash * 29 + MessageType.GetHashCode(); hash = hash * 29 + Symbol.GetHashCode(); hash = hash * 29 + Side.GetHashCode(); hash = hash * 29 + Price.GetHashCode(); hash = hash * 29 + Size.GetHashCode(); hash = hash * 29 + OrderCount.GetHashCode(); hash = hash * 29 + Precision.GetHashCode(); hash = hash * 29 + Time.GetHashCode(); hash = hash * 29 + Date.GetHashCode(); return(hash); } }
private List <Message> EditValidate(Address address, Settings settings) { var result = new List <Message>(); if (OrderCount.GetValueOrDefault(0) == 0 || OrderLine == null) { return(result); } if (Junk) { result.Add( Message.Warning("Вы заказали препарат с ограниченным сроком годности\r\nили с повреждением вторичной упаковки.")); } if (address.Orders.Where(o => o.Frozen).SelectMany(o => o.Lines).Any(l => l.ProductId == ProductId)) { result.Add(Message.Warning("Товар присутствует в замороженных заказах.")); } if (settings.WarnIfOrderedYesterday && address.YesterdayOrderedProductIds != null && address.YesterdayOrderedProductIds.Contains(ProductId)) { result.Add(Message.Warning(Util.HumanizeDaysAgo(settings.CountDayForWarnOrdered))); } if (PrevOrderAvgCount != null && OrderCount > PrevOrderAvgCount * settings.OverCountWarningFactor) { result.Add(Message.Warning("Превышение среднего заказа!")); } if (PrevOrderAvgCost != null && Cost > PrevOrderAvgCost * (1 + settings.OverCostWarningPercent / 100)) { result.Add(Message.Warning("Превышение средней цены!")); } if (BuyingMatrixType == BuyingMatrixStatus.Denied) { result.Clear(); OrderLine.Count = 0; result.Add(Message.Warning("Препарат запрещен к заказу.")); } return(result); }
public async Task <OrderCount> GetCurrentOrderActivity(Orders o) { try { if (o == null) { return(null); } using (var dc = new EntitiesWMS()) { var order = await dc.Orders .Where(p => p.ERP_ID == o.ERP_ID && p.OrderID == o.OrderID) .GroupBy( (by) => by.SubOrderID, (key, group) => new { Suborder = group.FirstOrDefault() }).ToListAsync(); var oc = new OrderCount { Status = order.Any(p => p.Suborder.Status > (int)EnumWMSOrderStatus.Waiting) ? order.Min(p => p.Suborder.Status > (int)EnumWMSOrderStatus.Waiting ? p.Suborder.Status : (int)EnumWMSOrderStatus.Active) : (int)EnumWMSOrderStatus.Waiting, // Status = order.Where(p => p.Suborder.Status > (int)EnumWMSOrderStatus.Waiting) // .DefaultIfEmpty() // .Min(p => p == null ? 0 : p.Suborder.Status), All = order.Count(), Active = order.Count(p => p.Suborder.Status == (int)EnumWMSOrderStatus.Active), Done = order.Count(p => p.Suborder.Status >= (int)EnumWMSOrderStatus.OnTarget && p.Suborder.Status <= (int)EnumWMSOrderStatus.ReadyToTake), Finished = order.Count(p => p.Suborder.Status >= (int)EnumWMSOrderStatus.Cancel) }; return(oc); } } catch (Exception e) { throw new Exception(string.Format("{0}.{1}: {2}", this.GetType().Name, (new StackTrace()).GetFrame(0).GetMethod().Name, e.Message)); } }
private void orderCount_Click(object sender, EventArgs e) { SqlOrderRepository orders = new SqlOrderRepository(connectionString); OrderCount oo = orders.RetrieveOrderCount(startDatePicker.Value, endDatePicker.Value); List <OrderCount> list = new List <OrderCount>(); list.Add(oo); dataGridView1.DataSource = list; for (int i = 0; i < dataGridView1.Columns.Count; i++) { DataGridViewColumn columnOne = dataGridView1.Columns[0]; columnOne.AutoSizeMode = DataGridViewAutoSizeColumnMode.Fill; DataGridViewColumn columnTwo = dataGridView1.Columns[1]; columnTwo.AutoSizeMode = DataGridViewAutoSizeColumnMode.Fill; DataGridViewColumn columnThree = dataGridView1.Columns[2]; columnThree.AutoSizeMode = DataGridViewAutoSizeColumnMode.Fill; } }
public void OrderCountService_Test_InsertOrderCount() { // arrange var options = new DbContextOptionsBuilder <ApplicationDbContext>() .UseInMemoryDatabase(databaseName: "OrderCountService_Test_InsertOrderCount") .Options; var orderCountEntity = new OrderCount { Date = DateTime.Now.Date, Count = 100 }; using (var context = new ApplicationDbContext(options)) { var service = new Service(context); // act service.OrderCountService.InsertOrderCount(orderCountEntity); // assert Assert.NotNull(service.OrderCountService.GetOrderCountByDate(DateTime.Now)); } }
public async Task <OrderCount> GetCurrentSubOrderActivity(Orders ord) { try { if (ord == null) { return(null); } using (var dc = new EntitiesWMS()) { var order = await dc.Orders .Where(p => p.ERP_ID == ord.ERP_ID && p.OrderID == ord.OrderID && p.SubOrderID == ord.SubOrderID) .Join(dc.Commands, o => o.ID, c => c.Order_ID, (o, c) => new { Order = o, Command = c }).ToListAsync(); var oc = new OrderCount { Status = order.FirstOrDefault().Order.Status, // order.Where(p => p.Command.Status > (int)EnumWMSCommandStatus.Waiting) // .DefaultIfEmpty() // .Min(p => (p == null || p.Command == null) ? 0 : p.Command.Status), All = order.Count(p => p.Command.Target.StartsWith("W:32")), Active = order.Count(p => p.Command.Status == (int)EnumWMSCommandStatus.Active), Done = order.Count(p => p.Command.Target.StartsWith("W:32") && p.Command.Status >= (int)EnumWMSCommandStatus.Canceled), Finished = order.Count(p => p.Command.Target.StartsWith("W:32") && p.Command.Status == (int)EnumWMSCommandStatus.Finished) }; return(oc); } } catch (Exception e) { throw new Exception(string.Format("{0}.{1}: {2}", this.GetType().Name, (new StackTrace()).GetFrame(0).GetMethod().Name, e.Message)); } }
public OrderCountModel(OrderCount orderCount) { this.Count = orderCount.count; this.Status = orderCount.status; this.RequestType = orderCount.requesttype; }