public ActionResult Order(int page, int limit, Order t)
{
OrderBll bll = new OrderBll();
var List = bll.SelectList()
.Where(i =>
isTrue(i.BarCode, t.BarCode) &&
IsTrue(i.OrderTime, t.OrderTime) &&
isTrue(i.address, t.address) &&
isTrue(i.Remarks, t.Remarks)
)
.Select(i => new
{
i.BarCode,
i.address,
i.OrderId,
OrderTime = i.OrderTime.ToString(),
i.Remarks
});
var ListJson = new
{
code = 0,
msg = "",
count = List.Count(),
data = List.Skip((page - 1) * limit).Take(limit).ToList()
};
return(Json(ListJson, JsonRequestBehavior.AllowGet));
}
/// <summary>
/// 我的订单分布视图
/// </summary>
/// <returns></returns>
public ActionResult MyOrder(string num = "0")
{
List <OrderTable> list = OrderBll.SelectUserOrder(Convert.ToInt32(Session["userid"]));
if (num == "1")
{
list = list.OrderBy(p => p.GetTime).ToList();
}
else if (num == "2")
{
list = list.OrderByDescending(p => p.OrderAmount).ToList();
}
else if (num == "3")
{
list = list.Where(p => p.IsReceiving == 0).ToList();
}
else if (num == "4")
{
list = list.Where(p => p.IsComment == 0).ToList();
}
else if (num == "5")
{
list = list.Where(p => p.IsReceiving == 1).ToList();
}
else if (num == "6")
{
list = list.Where(p => p.IsComment == 1).ToList();
}
Session["userorder"] = list;
ViewBag.index = Convert.ToInt32(num);
return(PartialView("MyOrder"));
}
protected void btnOK_OnClick(object sender, EventArgs e)
{
byte byteDeliveryStar = 1;
byte byteEatingStar = 1;
byte.TryParse(hfDeliveryStar.Value, out byteDeliveryStar);
byte.TryParse(hfEatingStar.Value, out byteEatingStar);
if (OrderBll.AddOrderResult(new Ye_OrderResult()
{
OrderID = Convert.ToInt32(Request.QueryString["orderId"]),
ShopID = ShopId,
UserID = YeUser.UserID,
EvaluationContent = tbxContent.Text,
DeliveryStar = byteDeliveryStar, //待修改
EatingStar = byteEatingStar, //待修改
CreateTime = DateTime.Now
}))
{
WebUtil.AlertAndRedirect("感谢您的支持！", "UserOrders.aspx");
}
else
{
WebUtil.AlertAndRedirect("用餐评价失败！", "UserOrders.aspx");
}
}
private void BindData()
{
pager1.DataItemCount = OrderBll.GetOrders().Count();
using (var entities = new YellEatEntities())
{
var query = from order in entities.Ye_Order
join user in entities.Ye_User
on order.UserID equals user.UserID
join shop in entities.Ye_Shop
on order.ShopID equals shop.ShopID
select new
{
order.OrderSN,
order.UserID,
order.OrderStatus,
order.OrderCreateTime,
order.Tax,
order.UnitCouponCost,
order.TotalPrice,
shop.ShopName,
user.UserName,
order.OrderID
};
rpt.DataSource =
query.OrderByDescending(p => p.OrderCreateTime)
.Skip(pager1.CurrentPagerIndex * pager1.PageSize)
.Take(pager1.PageSize)
.ToArray();
rpt.DataBind();
}
pager1.SetPagerControlState();
}
public string Submit([FromBody] QueryCreateOrder query)
{
query.Ssid = query.Ssid.Substring(1, query.Ssid.Length - 2);
var json = new OrderBll().SubimtOrder(query);
return(JsonConvert.SerializeObject(json));
}
/// <summary>
/// 立即购买
/// </summary>
/// <param name="GoodsId">商品id</param>
/// <param name="ShoppingNum">购买数量</param>
/// <param name="OrderAmount">小计</param>
/// <returns></returns>
public JsonResult AddOrder(string GoodsId, string ShoppingNum, string OrderAmount)
{
UserInfo user = Session["user"] as UserInfo;
//判断收货地址是否为空
if (user.ReceivingAddress == "")
{
return(Json(3, JsonRequestBehavior.AllowGet));
}
//余额是否满足
if (user.UserWallet < Convert.ToDecimal(OrderAmount))
{
return(Json(2, JsonRequestBehavior.AllowGet));
}
OrderTable ord = new OrderTable()
{
GoodsID = Convert.ToInt32(GoodsId),
UserID = Convert.ToInt32(Session["userid"]),
GoodsNum = Convert.ToInt32(ShoppingNum),
GetTime = DateTime.Now,
OrderAmount = Convert.ToDecimal(OrderAmount),
IsComment = 0,
IsReceiving = 0
};
if (OrderBll.AddOrder(ord))
{
return(Json(1, JsonRequestBehavior.AllowGet));
}
return(Json(0, JsonRequestBehavior.AllowGet));
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
var ltl = this.Master.FindControl("ltlSiteMapPath") as Literal;
ltl.Text = WebUtil.CreateBreadcrumbs(new List <Tuple <string, string> >()
{
new Tuple <string, string>("YellEat 后台管理系统", ""),
new Tuple <string, string>("餐馆管理首页", ""),
new Tuple <string, string>("订单管理", ""),
new Tuple <string, string>("订单详情", "")
});
var id = Convert.ToInt32(Request.QueryString["id"]);
var units = ProductBll.GetUnits().ToArray();
var orderDetails = OrderBll.GetOrderDetailsByOrderID(id).ToArray();
var details = from detail in orderDetails
join product in ProductBll.GetProducts()
on detail.ProductID equals product.ProductID
join unit in units
on product.UnitId equals unit.UnitID
select new { detail.Quantity, detail.UnitCost, unit.UnitPoint, product.ProductName, product.ProductID };
Order = OrderBll.GetOrders().SingleOrDefault(p => p.OrderID == id);
OrderResult = OrderBll.GetOrderResultByOrderID(id);
rptOrderDetail.DataSource = details.ToArray();
rptOrderDetail.DataBind();
}
}
private void BindList(int n)
{
OrderBll bll = new OrderBll();
this.orderlist.DataSource = bll.GetOrderList(n, 50);
this.orderlist.DataBind();
}
/// <summary>
/// 新增多个或单个订单
/// </summary>
/// <param name="OrderList">订单集合/对象</param>
/// <returns></returns>
public JsonResult AddOrder(string OrderList)
{
UserInfo user = Session["user"] as UserInfo;
//判断收货地址是否为空
if (user.ReceivingAddress == "")
{
return(Json(3, JsonRequestBehavior.AllowGet));
}
JavaScriptSerializer js = new JavaScriptSerializer();
List <OrderTable> list = js.Deserialize <List <OrderTable> >(OrderList);
//计算总金额
decimal price = 0;
list.ToList().ForEach(p => price += p.OrderAmount ?? 0);
if (user.UserWallet < price)
{
return(Json(2, JsonRequestBehavior.AllowGet));
}
if (OrderBll.AddOrders(list, Convert.ToInt32(Session["userid"]), price))
{
//修改购物车数量
Session["carcount"] = Convert.ToInt32(Session["carcount"]) - list.Count();
return(Json(1, JsonRequestBehavior.AllowGet));
}
return(Json(0, JsonRequestBehavior.AllowGet));
}
public FrmMain()
{
userInfoBll = new UserInfoBll();
orderBll = new OrderBll();
userInfos = new List <UserInfo>();
InitializeComponent();
}
/// <summary>
/// 直采订单取消
/// </summary>
/// <param name="orderid"></param>
/// <returns></returns>
public DataResult OrderCancel(string orderid)
{
var result = new DataResult();
var orderquery = new XiWanOrderQueryRequest {
OrderNo = orderid
};
//日志
var logmodel = new HO_HotelOrderLogModel
{
HOLOrderId = orderid,
HOLLogType = 1,//订单日志
HOLAddId = 0,
HOLRemark = "直采订单取消",
HOLAddName = "系统",
HOLAddDepartId = 0,
HOLAddDepartName = "系统",
HOLAddTime = DateTime.Now,
};
OrderLogBll.AddOrderModel(logmodel);
var rtn = OrderBll.SetOrder(orderid, 3);
if (rtn.IsSuccess == 1)
{
result.Code = DataResultType.Sucess;
}
else
{
result.Code = DataResultType.Fail;
result.Message = rtn?.Msg;
}
return(result);
}
/// <summary>
/// 喜玩操作订单
/// </summary>
/// <returns></returns>
public DataResult XiWanCancelOrder(string orderid)
{
var result = new DataResult();
var orderquery = new XiWanOrderQueryRequest {
OrderNo = orderid
};
//日志
var logmodel = new HO_HotelOrderLogModel
{
HOLOrderId = orderid,
HOLLogType = 1,//订单日志
HOLAddId = 0,
HOLAddName = "系统",
HOLAddDepartId = 0,
HOLAddDepartName = "系统",
HOLAddTime = DateTime.Now,
};
var rtn = XiWanAPI.XiWanPost <XiWanCancelOrderResponse, XiWanOrderQueryRequest>(orderquery, HotelCancelOrderUrl);
logmodel.HOLRemark = "喜玩取消请求：" + JsonConvert.SerializeObject(orderquery) + "||喜玩取消接口返回：" + JsonConvert.SerializeObject(rtn);
OrderLogBll.AddOrderModel(logmodel);
var order = rtn?.Result;
if (rtn.Code == "0")
{
result.Code = DataResultType.Sucess;
OrderBll.UpdatesSataus(orderid, 6);
}
else
{
result.Code = DataResultType.Fail;
result.Message = rtn?.Msg;
}
return(result);
}
/// <summary>
/// 全部订单
/// </summary>
/// <returns></returns>
public ActionResult OrderList()
{
var user = GetCurrentUser();
ViewBag.WaitOrder = OrderBll.LoadEntities(o => o.state == "0" && o.UserId == user.Id).Select(o => o.Id).Count(); //待发货的个数
ViewBag.WaitAcceptOrder = OrderBll.LoadEntities(o => o.state == "1 " && o.UserId == user.Id).Select(o => o.Id).Count();
return(View());
}
/// <summary>
/// 查询商品订单信息
/// </summary>
/// <param name="OrderId">订单id</param>
/// <returns></returns>
public JsonResult AjaxSelect(string OrderId)
{
OrderTable ord = OrderBll.SelectOneOrder(Convert.ToInt32(OrderId));
//获取图片路径
string filename = GoodsPhotoBll.SelectAllGoodsPhoto().FirstOrDefault(p => p.GoodsID == ord.GoodsID).PhotoPath;
return(Json(new { oid = OrderId, gid = ord.GoodsID, gname = ord.GoodsTable.GoodsName, gimg = filename }, JsonRequestBehavior.AllowGet));
}
public JsonResult GetOrderList(int?pageIndex, int?pageSize, string HyName)
{
OrderBll bll = new OrderBll();
int recordCounts = 0;
var result = bll.GetOrderDtoList(pageIndex, pageSize, HyName, ref recordCounts);
return(Json(new { messCode = 200, recordCount = recordCounts, data = result }));
}
/// <summary>
/// 删除订单
/// </summary>
/// <param name="OrderId">订单id</param>
/// <returns></returns>
public JsonResult OrderDel(string OrderId)
{
if (OrderBll.OrderDel(Convert.ToInt32(OrderId)))
{
return(Json(1, JsonRequestBehavior.AllowGet));
}
return(Json(0, JsonRequestBehavior.AllowGet));
}
public string AddOrder(int userid, int productid, int pronum)
{
string result = "1";
Order order = new Order();
OrderBll orderbll = new OrderBll();
OrderList orderlist = new OrderList();
OrderListBll orderlistbll = new OrderListBll();
ProductBll pbll = new ProductBll();
UsersBll ubll = new UsersBll();
try
{
//检查 当前用户是否有末完成的订单 有不能
//if (orderbll.GetAll("*", " [status]=1 and userid=" + userid, null, "id").Entity.Count <= 0)
//{
var p = pbll.GetByPrimaryKey(productid).Entity;
var u = ubll.GetByPrimaryKey(userid).Entity;
order.UserId = userid;
order.ReciverName = u.UserName;
order.PayMentTypeId = 1;//货到付款
order.RevicerAddress = u.Address;
order.RevicerTel = u.Mobile;
order.Status = 1;//
order.RealPrice = pronum * p.OemPrice;
order.TotalPrice = pronum * p.OemPrice;
order.Count = 1;
order.OrderTime = DateTime.Now;
order.OrderNo = OrderHelper.GetProNo();
//添加订单
int orderaddid = orderbll.AddAndReturn(order);
//添加订单详情
orderlist.Count = order.Count;
orderlist.Productid = productid;
orderlist.Orderid = orderaddid;
orderlist.OemPrice = p.OemPrice;
orderlist.MarketPrice = p.MarketPrice;
orderlistbll.Add(orderlist);
//}
//else
//{
// result = "-2";
//}
}
catch
{
result = "-1";
}
return(result);
}
protected void Button2_Click(object sender, EventArgs e)
{
string strkey = txtword.Text;
//this.datalist.Visible = true;
OrderBll bll = new OrderBll();
this.orderlist.DataSource = bll.GetOrderList(strkey);
this.orderlist.DataBind();
}
public void Bind(string ordercode)
{
List <T_OrderDetail> list = new List <T_OrderDetail>();
OrderBll bll = new OrderBll();
list = bll.GetOrderDetailList(ordercode);
dllist.DataSource = list;
dllist.DataBind();
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
var orderId = Convert.ToInt32(Request.QueryString["orderId"]);
var order = OrderBll.GetOrderByID(Convert.ToInt32(orderId));
Shop = ShopBll.GetShopById(order.ShopID);
ShopId = Shop.ShopID;
}
}
private void GetOrder()
{
string ordercode = "";
if (Request["code"] != null)
{
ordercode = Request["code"].ToString();
}
if (ordercode != "")
{
T_Order model = new T_Order();
T_OrderDetail detail = new T_OrderDetail();
OrderBll bll = new OrderBll();
model = bll.GetOrder(ordercode);
detail = bll.GetOrderDetailByCode(ordercode);
if (model != null)
{
//商户订单号，商户网站订单系统中唯一订单号，必填
out_trade_no = model.OrderCode;
//订单名称，必填
subject = detail.ProductName.Trim();
//付款金额，必填
total_fee = model.OrderPrice.ToString();
//收银台页面上，商品展示的超链接，必填
show_url = "http://m.makacake.com/productdetail.aspx?wd=" + detail.ProductId;
//商品描述，可空
body = detail.ProductName;
//把请求参数打包成数组
Config config = new Config();
SortedDictionary <string, string> sParaTemp = new SortedDictionary <string, string>();
sParaTemp.Add("partner", config.partner);
sParaTemp.Add("seller_id", config.seller_id);
sParaTemp.Add("_input_charset", config.input_charset.ToLower());
sParaTemp.Add("service", config.service);
sParaTemp.Add("payment_type", config.payment_type);
sParaTemp.Add("notify_url", config.notify_url);
sParaTemp.Add("return_url", config.return_url);
sParaTemp.Add("out_trade_no", out_trade_no);
sParaTemp.Add("subject", subject);
sParaTemp.Add("total_fee", total_fee);
sParaTemp.Add("show_url", show_url);
sParaTemp.Add("body", body);
//其他业务参数根据在线开发文档，添加参数.文档地址:https://doc.open.alipay.com/doc2/detail.htm?spm=a219a.7629140.0.0.2Z6TSk&treeId=60&articleId=103693&docType=1
//如sParaTemp.Add("参数名","参数值");
//建立请求
string sHtmlText = Submit.BuildRequest(sParaTemp, "get", "确认");
Response.Write(sHtmlText);
}
}
}
public ActionResult Welcome()
{
ViewBag.todayAllLeaveMsg = LeaveMsgBll.LoadEntities(m => true).Where(m => DbFunctions.DiffDays(m.InTime, DateTime.Now) == 0).Count();
ViewBag.todayAllOrder = OrderBll.LoadEntities(r => true).Where(r => DbFunctions.DiffDays(r.InTime, DateTime.Now) == 0).Count();
ViewBag.todayYj = FeedbackBll.LoadEntities(f => true).Where(f => DbFunctions.DiffDays(f.InTime, DateTime.Now) == 0).Count();
ViewBag.total = HttpContext.Application["total"];
ViewBag.onLine = HttpContext.Application["onLine"];
return(View());
}
private void BindData()
{
pager1.DataItemCount = OrderBll.GetOrdersByShopId(YeShopId).Count(p => p.IsShopDeleted == false);
rpt.DataSource = OrderBll.GetOrdersByShopId(YeShopId).
Where(p => p.IsShopDeleted == false)
.OrderBy(m => m.OrderCreateTime)
.Skip(pager1.PageSize * pager1.CurrentPagerIndex)
.Take(pager1.PageSize).ToArray();
rpt.DataBind();
pager1.SetPagerControlState();
}
public string AddOrder(int userid, string data, int price, string pno, string payMentType, int bananaCount)
{
string result = "0";
Order order = new Order();
OrderBll orderbll = new OrderBll();
UsersBll ubll = new UsersBll();
var u = ubll.GetByPrimaryKey(userid).Entity;
try
{
order.UserId = userid;
order.ReciverName = u.UserName;
order.PayMentTypeId = (byte?)(payMentType == "货到付款" ? 1 : 2);//货到付款
order.RevicerAddress = u.Address;
order.RevicerTel = u.Mobile;
order.Status = 0;//等待确认
order.RealPrice = price;
order.TotalPrice = price;
order.Count = 1;
order.OrderTime = DateTime.Now;
order.OrderNo = OrderHelper.GetProNo();
order.Pno = pno == "" ? null : pno;
order.BananaCount = bananaCount;
//添加订单
int orderaddid = orderbll.AddAndReturn(order);
sendYzm("18758177964", "26871", new string[] { u.UserName + u.Mobile, DateTime.Now.ToString() });
string[] dataArr = data.Split(',');
if (dataArr.Length > 0)
{
for (int d = 0; d < dataArr.Length; d++)
{
if (!string.IsNullOrEmpty(dataArr[d]))
{
if (dataArr[d].IndexOf("|") > -1)
{
string[] arr = dataArr[d].Split('|');
AddOrderList(u, Convert.ToInt32(arr[0]), Convert.ToInt32(arr[1]), orderaddid);
result = orderaddid.ToString();
}
}
}
}
}
catch
{
result = "-1";
}
return(result);
}
protected void Page_Load(object sender, EventArgs e)
{
OrderBll bll = new OrderBll();
List <T_Order> list = new List <T_Order>();
list = bll.GetOrderByUserId();
if (list != null)
{
dllist.DataSource = list;
dllist.DataBind();
}
}
protected void rpt_OnItemCommand(object source, RepeaterCommandEventArgs e)
{
var id = Convert.ToInt32(e.CommandArgument.ToString());
switch (e.CommandName)
{
case "del":
{
if (ProductBll.CheckProduct(id)) //菜单出现在订单中
{
List <int> lisOrderId = OrderBll.GetOrderIDsByProductId(id);
foreach (int orderId in lisOrderId)
{
OrderBll.ShopDeleteOrder(orderId);
}
//ProductBll.DeleteProduct(id);
WebUtil.Alert("菜单删除成功！", this);
pager1.CurrentPagerIndex = 0;
BindData();
}
else
{
if (ProductBll.DeleteProduct(id))
{
WebUtil.Alert("菜单成功删除！", this);
pager1.CurrentPagerIndex = 0;
BindData();
}
else
{
WebUtil.Alert("菜单删除失败！", this);
}
}
break;
}
case "sj":
{
if (ProductBll.SetProductSaleState(id, true))
{
WebUtil.Alert("菜单上架成功！", this);
pager1.CurrentPagerIndex = 0;
BindData();
}
else
{
WebUtil.Alert("菜单上架失败！", this);
}
break;
}
}
}
public void ProcessRequest(HttpContext context)
{
context.Response.ContentType = "text/plain";
context.Response.Write("Hello World");
int id = context.Request.QueryString["id"].ToInt();
var falg = 0;
if (id > 0)
{
falg = new OrderBll().DeleteList("id=" + id).ResultStatus.Code;
}
context.Response.Write(falg);
}
protected void Page_Load(object sender, EventArgs e)
{
if (Request.QueryString["wd"] != null && Request.QueryString["wd"].ToString() != "")
{
OrderBll bll = new OrderBll();
T_Order order = new T_Order();
order = bll.GetOrderByUserId(Request.QueryString["wd"].ToString());
if (order != null)
{
ordercode = order.OrderCode;
}
}
}
//数据绑定
private void BindData()
{
pager1.DataItemCount = OrderBll.GetOrdersByShopId(YeShopId).Count(o => o.IsShopDeleted == false && o.OrderStatus == 1);
var orders = OrderBll.GetOrdersByShopId(YeShopId).Where(o => o.IsShopDeleted == false).OrderBy(o => o.OrderCreateTime).Skip(pager1.PageSize * pager1.CurrentPagerIndex).Take(pager1.PageSize);
OrderDetails = (from detail in OrderBll.GetOrderDetails()
join order in OrderBll.GetOrders() on detail.OrderID equals order.OrderID
where order.ShopID == YeShopId
select detail).ToList();
rpt.DataSource = orders.ToArray();
rpt.DataBind();
pager1.SetPagerControlState();
}
private void BindList()
{
string id = Request["id"];
OrderBll bll = new OrderBll();
T_Order order = new T_Order();
order = bll.GetOrder(id);
if (order != null)
{
this.txtordercode.Value = id;
this.txtmobile.Value = order.Mobile;
this.txtaddress.Value = order.Adress;
}
this.orderlist.DataSource = bll.GetOrderDetailList(id);
this.orderlist.DataBind();
}
