public ActionResult MemberHome(int page = 1, int pageSize = 3)
{
ViewBag.pwdDisp = "none";
string[] orderStates = { "初始", "已付款", "已排产", "已生产", "已发送", "已签收", "已删除" };
string curName = User.Identity.Name;
MemberHomeModel mhm = new MemberHomeModel();
mhm.Orders = new List <OrderList>();
//mhm.PassWordModel = new LocalPasswordModel();
//var c =await _userManager.FindByNameAsync(curName);
Customer c = db.Customer.Single(m => m.UserName == curName);
int custId = ViewBag.uid = c.ObjId;
mhm.CustomerInfo = new RegisterModel {
UserName = c.UserName, Email = c.Email, MobilePhone = c.MobilePhone, OfficePhone = c.OfficePhone, HomePhone = c.HomePhone, QqNum = c.QqNumber
};
var orderlist = from a in db.Order
where a.OrderState < 6 && a.TheCustomer == custId
join b in db.ProductTable on a.TheProduct equals b.Id
join p in db.Payment on a.ThePayment equals p.ObjId
join d in db.Consignee on a.TheConsignee equals d.ObjId
orderby a.OrderTime descending
select new
{
orderTime = a.OrderTime,
amt = a.Amt,
orderState = (int)(a.OrderState),
productName = b.Name,
smallImg = b.Spicture1,
transTime = p.TransTime,
name = d.Name,
receiptFile = ""
}; //orderby a.OrderTime descending
var orders = orderlist.Skip((page - 1) * pageSize).Take(pageSize);
foreach (var o in orders)
{
mhm.Orders.Add(new OrderList
{
orderTime = o.orderTime == null ? default(DateTime) : o.orderTime.Value,
amt = (double)(o.amt),
orderState = orderStates[o.orderState],
productName = o.productName,
smallImg = o.smallImg,
transTime = o.transTime == null ? default(DateTime) : o.transTime.Value,
name = o.name,
receiptFile = ""
});
}
mhm.PagingInfo = new PagingInfo {
CurrentPage = page, ItemsPerPage = pageSize, TotalItems = orderlist.Count()
};
return(View("MemberHome", mhm));
}
public async Task <ActionResult> MemberHome(MemberHomeModel mhm, int page = 1, int pageSize = 3)
{
string curUser = User.Identity.Name;
var c = await _userManager.FindByNameAsync(curUser);
Customer cust = db.Customer.Single(m => m.UserName == curUser);
int custId = ViewBag.uid = cust.ObjId;
ViewBag.pwdDisp = "block";
IdentityResult r = await _userManager.ChangePasswordAsync(c, mhm.OldPassword, mhm.NewPassword);
if (r.Succeeded)
{
ViewBag.pwdDisp = "none";
}
else
{
await Response.WriteAsync("<script>alert('密码更新失败！');</script>");
}
string[] orderStates = { "初始", "已付款", "已排产", "已生产", "已发送", "已签收", "已删除" };
mhm.Orders = new List <OrderList>();
mhm.CustomerInfo = new RegisterModel {
UserName = cust.UserName, Email = cust.Email, MobilePhone = cust.MobilePhone, OfficePhone = cust.OfficePhone, HomePhone = cust.HomePhone, QqNum = cust.QqNumber
};
var orderlist = from a in db.Order
where a.OrderState < 6 && a.TheCustomer == custId
join b in db.ProductTable on a.TheProduct equals b.Id
join p in db.Payment on a.ThePayment equals p.ObjId
join d in db.Consignee on a.TheConsignee equals d.ObjId
join e in db.CustomerWords on a.ObjId equals e.TheOrder
orderby a.OrderTime descending
select new
{
orderTime = a.OrderTime,
amt = a.Amt,
orderState = (int)(a.OrderState),
productName = b.Name,
smallImg = b.Spicture1,
transTime = p.TransTime,
name = d.Name,
words = e.Words,
receiptFile = "" //o.ReceiptFile
}; //join f in db.Receipt on a.ObjId equals f.TheOrder into oList
//from o in oList.DefaultIfEmpty()
var orders = orderlist.Skip((page - 1) * pageSize).Take(pageSize);
foreach (var o in orders)
{
mhm.Orders.Add(new OrderList
{
orderTime = o.orderTime == null ? default(DateTime) : o.orderTime.Value,
amt = (double)(o.amt),
orderState = orderStates[o.orderState],
productName = o.productName,
smallImg = o.smallImg,
transTime = o.transTime == null ? default(DateTime) : o.transTime.Value,
name = o.name,
words = o.words,
receiptFile = ""//o.receiptFile
});
}
mhm.PagingInfo = new PagingInfo {
CurrentPage = page, ItemsPerPage = pageSize, TotalItems = orderlist.Count()
};
return(View("MemberHome", mhm));
}
public async Task <ActionResult> MemberHome(MemberHomeModel mhm, int page = 1, int pageSize = 3)
{
ViewBag.pwdDisp = "block";
string curUser = User.Identity.Name;
var c = await _userManager.FindByNameAsync(curUser);
Customer cust = db.Customer.Single(m => m.UserName == curUser);
int custId = ViewBag.uid = cust.ObjId;
IdentityResult r = await _userManager.ChangePasswordAsync(c, mhm.OldPassword, mhm.NewPassword);
if (r.Succeeded)
{
ViewBag.pwdDisp = "none";
}
else
{
await Response.WriteAsync("<script>alert('密码更新失败！');</script>");
}
string[] orderStates = { "初始", "已付款" };
mhm.Orders = new List <OrderList>();
mhm.CustomerInfo = new RegisterModel {
Email = cust.UserName, Conname = cust.Conname, MobilePhone = cust.MobilePhone, Adress = cust.Adress
};
var orderlist = from a in db.Orders
where a.OrderState < 6 && a.Customermessage == custId
join b in db.Product on a.TheProduct equals b.ObjId
//join p in db.Payment on a.ThePayment equals p.ObjId
join d in db.Customer on a.Customermessage equals d.ObjId
//orderby a.OrderTime descending
select new
{
name = d.Conname,
orderTime = a.OrderTime,
//amount = p.Amount,
orderState = (int)(a.OrderState),
productName = b.Productname,
product_Img = b.Product_Img
//transTime = p.TransTime
};
//var orders = orderlist.Skip((page - 1) * pageSize).Take(pageSize);
foreach (var o in orderlist)
{
mhm.Orders.Add(new OrderList
{
name = o.name,
orderTime = o.orderTime == null ? default(DateTime) : o.orderTime.Value,
orderState = orderStates[o.orderState],
productName = o.productName,
product_Img = o.product_Img
//amount = (double)(o.amount)
});
}
//var orderlist = from a in db.Orders
// where a.OrderState < 6 && a.Customermessage == custId
// join b in db.Product on a.TheProduct equals b.ObjId
// join p in db.Payment on a.ThePayment equals p.ObjId
// join d in db.Customer on a.Customermessage equals d.ObjId
// orderby a.OrderTime descending
// select new
// {
// name = d.Conname,
// orderTime = a.OrderTime,
// amount = p.Amount,
// orderState = (int)(a.OrderState),
// productName = b.Productname,
// product_Img = b.Product_Img,
// transTime = p.TransTime
// };
//foreach (var o in orderlist)
//{
// mhm.Orders.Add(new OrderList
// {
// name = o.name,
// orderTime = o.orderTime == null ? default(DateTime) : o.orderTime.Value,
// amount = (double)(o.amount),
// orderState = orderStates[o.orderState],
// productName = o.productName,
// product_Img = o.product_Img,
// transTime = o.transTime == null ? default(DateTime) : o.transTime.Value
// });
//}
//var orders = orderlist.Skip((page - 1) * pageSize).Take(pageSize);
//foreach (var o in orders)
//{
// mhm.Orders.Add(new OrderList
// {
// name = o.name,
// orderTime = o.orderTime == null ? default(DateTime) : o.orderTime.Value,
// amount = (double)(o.amount),
// orderState = orderStates[o.orderState],
// productName = o.productName,
// product_Img = o.product_Img,
// transTime = o.transTime == null ? default(DateTime) : o.transTime.Value
// });
//}
//mhm.PagingInfo = new PagingInfo { CurrentPage = page, ItemsPerPage = pageSize, TotalItems = orderlist.Count() };
return(View("MemberHome", mhm));
}
public ActionResult MemberHome(int page = 1, int pageSize = 3)
{
ViewBag.pwdDisp = "none";
string[] orderStates = { "初始", "已付款" };
string curName = User.Identity.Name;
MemberHomeModel mhm = new MemberHomeModel();
mhm.Orders = new List <OrderList>();
//var Orders = db.Orders.Where<Orders>(m => m.Customermessage = db.Customer.SingleOrDefault(n => n.UserName == curName).ObjId);
//var theCustomerId = db.Customer.SingleOrDefault(u => u.UserName == curName).ObjId;
//foreach (var p in Orders)
//{
// OrderList ol = new OrderList();
// ol = new OrderList { ObjId = p.}
//}
Customer c = db.Customer.Single(m => m.UserName == curName);
int custId = ViewBag.uid = c.ObjId;
mhm.CustomerInfo = new RegisterModel {
Email = c.UserName, Conname = c.Conname, Adress = c.Adress, MobilePhone = c.MobilePhone
};
var orderlist = from a in db.Orders
where a.OrderState < 6 && a.Customermessage == custId
join b in db.Product on a.TheProduct equals b.ObjId
//join p in db.Payment on a.ThePayment equals p.ObjId
join d in db.Customer on a.Customermessage equals d.ObjId
//orderby a.OrderTime descending
select new
{
name = d.Conname,
orderTime = a.OrderTime,
//amount = p.Amount,
orderState = (int)(a.OrderState),
productName = b.Productname,
product_Img = b.Product_Img,
//transTime = p.TransTime
};
//var orders = orderlist.Skip((page - 1) * pageSize).Take(pageSize);
foreach (var o in orderlist)
{
mhm.Orders.Add(new OrderList
{
name = o.name,
orderTime = o.orderTime == null ? default(DateTime) : o.orderTime.Value,
orderState = orderStates[o.orderState],
productName = o.productName,
product_Img = o.product_Img
//amount = (double)(o.amount)
});
}
//foreach (var o in orderlist)
//{
// mhm.Orders.Add(new OrderList
// {
// name = o.name,
// orderTime = o.orderTime == null ? default(DateTime) : o.orderTime.Value,
// amount = (double)(o.amount),
// orderState = orderStates[o.orderState],
// productName = o.productName,
// product_Img = o.product_Img,
// transTime = o.transTime == null ? default(DateTime) : o.transTime.Value
// });
//}
//foreach (var o in orders)
//{
// mhm.Orders.Add(new OrderList
// {
// name = o.name,
// orderTime = o.orderTime == null ? default(DateTime) : o.orderTime.Value,
// amount = (double)(o.amount),
// orderState = orderStates[o.orderState],
// productName = o.productName,
// product_Img = o.product_Img,
// transTime = o.transTime == null ? default(DateTime) : o.transTime.Value
// });
//}
//mhm.PagingInfo = new PagingInfo { CurrentPage = page, ItemsPerPage = pageSize, TotalItems = orderlist.Count() };
return(View("MemberHome", mhm));
}
