public ActionResult EqptBuy()
{
if (Request.Cookies["loginState"] == null)
{
return(RedirectToAction("../Login/Login"));
}
EntitieFinal entitieFinal = new EntitieFinal();
var address = Request.Form["Item1.ORDER_ADDRESS_DETAIL"];
var startDate = Request.Form["Item1.ORDER_START_DATE"];
var endDate = Request.Form["Item1.ORDER_END_DATE"];
int id = Int32.Parse(TempData["curData"].ToString());
if (address == "" || startDate == "" || endDate == "")
{
Response.Write("<script>alert('订单错误！')</script>");
var s = id.ToString();
return(RedirectToAction("EqptBuyPage", new { equID = s }));
}
ORDER_EQUIPMENT_INFO order = new ORDER_EQUIPMENT_INFO();
order.ORDER_ADDRESS_DETAIL = address;
order.ORDER_END_DATE = Convert.ToDateTime(endDate);
order.ORDER_START_DATE = Convert.ToDateTime(startDate);
string name = Request.Cookies["loginState"].Value;
order.ORDER_EQUIPMENT_ID = id;
order.ORDER_STATUS = 1;
var user_id = (from temp in entitieFinal.CUSTOMERs
where temp.CUSTOMER_NAME == name
select temp.CUSTOMER_ID).ToList().First();
order.ORDER_USER_ID = user_id;
var payment = (from temp in entitieFinal.EQUIPMENT_INFO
where temp.EQUIPMENT_ID == id
select temp.EQUIPMENT_RENT).ToList().First();
order.ORDER_PAYMENT = payment;
entitieFinal.ORDER_EQUIPMENT_INFO.Add(order);
entitieFinal.SaveChanges();
Response.Write("<script>alert('购买成功')</script>");
return(View("../Home/Index"));
}
public ActionResult EquAddOrSearch(string op)
{
ViewData["front"] = "1";
EntitieFinal entitie = new EntitieFinal();
if (op == "add")
{
var order = new ORDER_EQUIPMENT_INFO();
order.ORDER_USER_ID = long.Parse(Request["USER"]);
order.ORDER_EQUIPMENT_ID = long.Parse(Request["EQUID"]);
order.ORDER_START_DATE = Convert.ToDateTime(Request["START"]);
order.ORDER_END_DATE = Convert.ToDateTime(Request["END"]);
order.ORDER_PAYMENT = Convert.ToDecimal(Request["PAY"]);
order.ORDER_ADDRESS_DETAIL = "嘉定";
order.ORDER_STATUS = 1;
entitie.ORDER_EQUIPMENT_INFO.Add(order);
entitie.SaveChanges();
GetData();
return(RedirectToAction("AdminView"));
}
else
{
var orderList = from order in entitie.ORDER_EQUIPMENT_INFO
select order;
if (!string.IsNullOrEmpty(Request["ORDERID"]))
{
var p = long.Parse(Request["ORDERID"]);
orderList = from order in orderList
where order.ORDER_ID == p
select order;
}
if (!string.IsNullOrEmpty(Request["USER"]))
{
var p = long.Parse(Request["USER"]);
orderList = from order in orderList
where order.ORDER_USER_ID == p
select order;
}
if (!string.IsNullOrEmpty(Request["EQUID"]))
{
var p = long.Parse(Request["EQUID"]);
orderList = from order in orderList
where order.ORDER_EQUIPMENT_ID == p
select order;
}
if (!string.IsNullOrEmpty(Request["START"]))
{
var p = Convert.ToDateTime(Request["START"]);
orderList = from order in orderList
where order.ORDER_START_DATE == p
select order;
}
if (!string.IsNullOrEmpty(Request["END"]))
{
var p = Convert.ToDateTime(Request["END"]);
orderList = from order in orderList
where order.ORDER_END_DATE == p
select order;
}
if (!string.IsNullOrEmpty(Request["PAY"]))
{
var p = Convert.ToDecimal(Request["PAY"]);
orderList = from order in orderList
where order.ORDER_PAYMENT == p
select order;
}
GetData();
ViewData["EQU"] = orderList.ToList();
}
return(View("AdminView"));
}
