private static DateTime GetCheckDate(Entity.Entities entity, DateTime checkDate) { var firstFinishedOrder = entity.OrderInfo.Where(c => c.OrderStatus == OrderInfo.OrderOperateStatus.Finish).OrderBy(c => c.FinishDate).FirstOrDefault(); // return order; // var firstFinishedOrder = new OrderService().GetFirstFinishedOrderForSettlement(); //var firstFinishedAgreement = entity.PurchaseAgreementInfo.Where(c => c.AgreementStatus == Himall.Model.PurchaseAgreementInfo.AgreementState.HasComplete).OrderBy(c => c.FinishDate).FirstOrDefault(); if (firstFinishedOrder != null) { checkDate = firstFinishedOrder.FinishDate.Value; } else if (firstFinishedOrder != null) { checkDate = firstFinishedOrder.FinishDate.Value; } //else if (firstFinishedAgreement != null) //{ // checkDate = firstFinishedAgreement.FinishDate.Value; //} else { checkDate = DateTime.MinValue; } return(checkDate); }
/// <summary> /// 取上一次统计时间 /// </summary> /// <returns></returns> DateTime GetStatisticDate() { DateTime startDate = DateTime.Now.Date; Entity.Entities entity = new Entity.Entities(); var lastRecord = entity.ShopVistiInfo.Where(item => item.StatisticFlag == false).FirstOrDefault(); if (lastRecord != null) { startDate = lastRecord.Date; } else { //是否第一次统计 var visitInfo = entity.ShopVistiInfo.FirstOrDefault(); if (visitInfo == null) {//取第一个订单时间 var firstOrder = entity.OrderInfo.FirstOrDefault(); if (firstOrder != null) { startDate = firstOrder.OrderDate.Date; } else { startDate = DateTime.Now.Date; } } else { startDate = visitInfo.Date; } } return(startDate); }
// GET: Teacher public ActionResult Create() { using (var db = new Entity.Entities()) { ViewBag.PreName = db.PreName.ToList(); } return(View()); }
public void Delete(T entity) { using (Entity.Entities context = new Entity.Entities()) { context.Detach(entity); context.SaveChanges(); } }
void StatisticPayProduct(DateTime statisticStartDate, DateTime statisticEndDate) { Entity.Entities entity = new Entity.Entities(); //时间段内已支付订单 var payOrders = from o in entity.OrderInfo join i in entity.OrderItemInfo on o.Id equals i.OrderId where o.PayDate.HasValue && o.PayDate.Value >= statisticStartDate && o.PayDate.Value < statisticEndDate select new { OrderId = o.Id, OrderDate = o.OrderDate, ShopId = o.ShopId, ProductId = i.ProductId, ProductName = i.ProductName, TotalAmount = i.RealTotalPrice, //实际上是金额 OrderProductQuantity = i.Quantity, UserId = o.UserId }; var payOrderGroups = payOrders.GroupBy(e => e.ProductId); List <ProductVistiInfo> productVisitRange = new List <ProductVistiInfo>(); var pids = payOrderGroups.Select(e => e.Key).Distinct(); var oldProductVisits = entity.ProductVistiInfo.Where(e => e.Date == statisticStartDate && pids.Contains(e.ProductId)).ToList(); foreach (var g in payOrderGroups) { ProductVistiInfo productVisit = oldProductVisits.FirstOrDefault(e => e.ProductId == g.Key); if (productVisit == null) { productVisit = new ProductVistiInfo(); productVisitRange.Add(productVisit); //销售量、销售金额在订单逻辑里有实时处理,如果没有记录则进行统计 productVisit.SaleCounts = g.Sum(e => e.OrderProductQuantity); productVisit.SaleAmounts = g.Sum(e => e.TotalAmount); } productVisit.Date = statisticStartDate; productVisit.ProductId = g.Key; productVisit.PayUserCounts = g.Select(e => e.UserId).Distinct().Count(); productVisit.StatisticFlag = true; var item = g.FirstOrDefault(); if (item != null) { productVisit.ShopId = item.ShopId; } } //将没有付款记录的统计信息,统一修改为已统计 var noPayOrdersStatistic = oldProductVisits.Where(e => !pids.Any(p => p == e.ProductId)); foreach (var v in noPayOrdersStatistic) { v.StatisticFlag = true; } entity.ProductVistiInfo.AddRange(productVisitRange); entity.SaveChanges(); }
public Entity.ProfileStudent Chkstud(Entity.ProfileStudent model) { var stud = new Entity.ProfileStudent(); using (var db = new Entity.Entities()) { stud = db.ProfileStudent.Where(a => a.Stud_id == model.Stud_id).FirstOrDefault(); } return(stud); }
public Entity.ProfileTeacher Searchteac(int id) { var teacher = new Entity.ProfileTeacher(); using (var db = new Entity.Entities()) { teacher = db.ProfileTeacher.Where(a => a.User_id == id).FirstOrDefault(); } return(teacher); }
public Entity.Open_Subjects ChkSub(Entity.Open_Subjects model) { var Sub = new Entity.Open_Subjects(); using (var db = new Entity.Entities()) { Sub = db.Open_Subjects.Where(a => a.Sub_id == model.Sub_id).FirstOrDefault(); } return(Sub); }
public T Create(T entity) { using (Entity.Entities context = new Entity.Entities()) { String entitySetName = typeof(T).Name; context.AddObject(entitySetName, entity); context.SaveChanges(); } return(entity); }
public Entity.ProfileTeacher Chkteac(Entity.ProfileTeacher model) { var teacher = new Entity.ProfileTeacher(); using (var db = new Entity.Entities()) { teacher = db.ProfileTeacher.Where(a => a.Teacher_id == model.Teacher_id).FirstOrDefault(); } return(teacher); }
public T Update(T entity) { using (Entity.Entities context = new Entity.Entities()) { String entitySetName = typeof(T).Name; context.AttachTo(entitySetName, entity); context.SaveChanges(); } return(entity); }
public List <Entity.User> UserList() { var user = new List <Entity.User>(); using (var db = new Entity.Entities()) { user = db.User.ToList(); } return(user); }
public Entity.ProfileStudent Searchstud(int id) { var stud = new Entity.ProfileStudent(); using (var db = new Entity.Entities()) { stud = db.ProfileStudent.Where(a => a.User_id == id).FirstOrDefault(); } return(stud); }
public Entity.User Search(int id) { var user = new Entity.User(); using (var db = new Entity.Entities()) { user = db.User.Where(a => a.User_id == id).FirstOrDefault(); } return(user); }
public Entity.User Chkuser(Entity.User model) { var user = new Entity.User(); using (var db = new Entity.Entities()) { user = db.User.Where(a => a.Username == model.Username).FirstOrDefault(); } return(user); }
public Entity.User Login(Models.Login model) { var user = new Entity.User(); using (var db = new Entity.Entities()) { user = db.User.Where(a => a.Username == model.Username && a.Password == model.Password).FirstOrDefault(); } return(user); }
public ActionResult EditGrad(int id) { using (var db = new Entity.Entities()) { ViewBag.PreName = db.PreName.ToList(); } var dal = new DAL.RegisterSubDAL(); var teacher = dal.Searchgrad(id); return(View(teacher)); }
public Entity.Open_Subjects Search(int id) { var sub = new Entity.Open_Subjects(); using (var db = new Entity.Entities()) { sub = db.Open_Subjects.Where(a => a.Sub_id == id).FirstOrDefault(); sub.ProfileTeacher = sub.ProfileTeacher; } return(sub); }
public ActionResult Edit(string id) { using (var db = new Entity.Entities()) { ViewBag.PreName = db.PreName.ToList(); } var dal = new DAL.TeacherDAL(); var teacher = dal.Search(id); return(View(teacher)); }
public Entity.Register_Subjects Searchgrad(int id) { var sub = new Entity.Register_Subjects(); using (var db = new Entity.Entities()) { sub = db.Register_Subjects.Where(a => a.id == id).FirstOrDefault(); sub.Open_Subjects = sub.Open_Subjects; } return(sub); }
public ActionResult Edit(string id) { using (var db = new Entity.Entities()) { ViewBag.PreName = db.PreName.ToList(); } var dal = new DAL.StudentDAL(); var stud = dal.Search(id); return(View(stud)); }
public void Delete(IList <T> entities) { using (Entity.Entities context = new Entity.Entities()) { foreach (var o in entities) { context.Detach(o); } context.SaveChanges(); } }
protected void Page_Load(object sender, EventArgs e) { using (var db = new Entity.Entities()) { var data = db.ViewOpenSub.ToList(); var rd = new ReportDataSource("DataSet1", data); // binding datatable ReportViewer1.LocalReport.ReportPath = Server.MapPath("~/Report/ReportSub.rdlc"); ReportViewer1.LocalReport.DataSources.Clear(); ReportViewer1.LocalReport.DataSources.Add(rd); // Add dataDataSource } }
public Entity.ProfileTeacher Search(string id) { var teacher = new Entity.ProfileTeacher(); using (var db = new Entity.Entities()) { teacher = db.ProfileTeacher.Where(a => a.Teacher_id == id).FirstOrDefault(); teacher.User = teacher.User; teacher.PreName = teacher.PreName; } return(teacher); }
public Entity.ProfileStudent Search(string id) { var stud = new Entity.ProfileStudent(); using (var db = new Entity.Entities()) { stud = db.ProfileStudent.Where(a => a.Stud_id == id).FirstOrDefault(); stud.PreName = stud.PreName; stud.User = stud.User; } return(stud); }
public List <Entity.Open_Subjects> SubList() { var Sub = new List <Entity.Open_Subjects>(); using (var db = new Entity.Entities()) { Sub = db.Open_Subjects.ToList(); foreach (var s in Sub) { s.ProfileTeacher = s.ProfileTeacher; } } return(Sub); }
private static DateTime GetDate(Entity.Entities entity, DateTime checkDate) { var firstFinishedOrder = entity.PendingSettlementOrdersInfo.OrderBy(c => c.OrderFinshTime).FirstOrDefault(); if (firstFinishedOrder != null) { checkDate = firstFinishedOrder.OrderFinshTime; } else { checkDate = DateTime.MinValue; } return(checkDate); }
public List <Entity.ProfileTeacher> TeacherList() { var teacher = new List <Entity.ProfileTeacher>(); using (var db = new Entity.Entities()) { teacher = db.ProfileTeacher.ToList(); foreach (var s in teacher) { s.PreName = s.PreName; s.User = s.User; } } return(teacher); }
public void AddProduct(Product newProduct) { Products products = new Products(); products.Code = newProduct.Code; products.Name = newProduct.Name; products.Price = newProduct.Price; products.Barcode = newProduct.Barcode; using (Store.Data_Access.Entity.Entities db = new Entity.Entities()) { db.Products.Add(products); db.SaveChanges(); } }
public List <Entity.ProfileStudent> StudentList() { var stud = new List <Entity.ProfileStudent>(); using (var db = new Entity.Entities()) { stud = db.ProfileStudent.ToList(); foreach (var s in stud) { s.PreName = s.PreName; s.User = s.User; } } return(stud); }