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);
}
