private void PageInit()
{
OrderInfo item = new OrdersBLL().GetItem(orderno);
if (item != null)
{
L_OrderTime.Text = item.AddTime.ToString();
L_Address.Text = item.UserAddress;
L_UserName.Text = item.UserName;
L_Phone.Text = item.UserTel;
L_OrderPrice.Text = item.TotalPrice.ToString();
L_SumPrice.Text = item.TotalPrice.ToString();
L_SendTime.Text = item.Remark;
int ordercount = 0;
List <OrderItem> list = new OrderItemBLL().GetList(orderno);
foreach (OrderItem temp in list)
{
ordercount += temp.BuyNum;
}
L_OrderCount.Text = ordercount.ToString();
rpt_list.DataSource = list;
rpt_list.DataBind();
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (Session["Users"] != null)
{
users = (Users)Session["Users"];
}
else
{
users = null;
Response.Write("<script>parent.window.location.href='Login.aspx'</script>");
}
if (!IsPostBack)
{
BindType();
txtNo.Value = "RZ" + DateTime.Now.ToString("yyMMddHHmmss");
txtGetDate.Value = DateTime.Now.ToString("yyyy-MM-dd");
txtUserName.Value = users.U_Name.Trim();
if (Request.QueryString["id"] != null)
{
Orders ord = OrdersBLL.GetIdByOrders(Convert.ToInt32(Request.QueryString["id"]));
if (ord != null && ord.O_Id != 0)
{
txtName.Value = ord.O_Name.Trim();
txtTel.Value = ord.O_Tel.Trim();
ddlRt_Id.SelectedValue = ord.Rt_Id.ToString().Trim();
ddlR_Id.DataSource = RoomBLL.AllData(" and Rt_Id=" + ddlRt_Id.SelectedValue + " and R_State='空'");
ddlR_Id.DataTextField = "R_No";
ddlR_Id.DataValueField = "R_Id";
ddlR_Id.DataBind();
}
}
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (Session["isLogin"] == null)
{
Response.Redirect("Login.aspx");
}
UserAccount user = (UserAccount)Session["UserAccountObj"];
OrdersBLL odbll = new OrdersBLL();
txtTransactionID.Text = Request.QueryString["transactionid"].ToString();
Orders od = new Orders();
od = odbll.DoRetrieveOrderByTransactionId(txtTransactionID.Text);
CustomerBLL cbll = new CustomerBLL();
Customer cust = cbll.DoRetrieveCustomerByID(od.CId);
txtCustName.Text = cust.CName;
txtDeliverAddress.Text = od.DeliverAddress;
txtOrderStatus.Text = od.Status;
txtCustContact.Text = od.ContactNo;
txtTotalPayment.Text = (od.TotalCost + od.DeliveryFee).ToString();
DataTable dt = new DataTable();
OrderItemListBLL obll = new OrderItemListBLL();
dt = obll.DoRetrieveCustomerOrderItemByTransactionId(txtTransactionID.Text);
if (dt != null)
{
gv_orderlist.DataSource = dt;
gv_orderlist.DataBind();
}
}
static void Main(string[] args)
{
var storeUI = new StoreView();
var orderUI = new OrderView();
var storeBLL = new StoresBLL();
var ordersBLL = new OrdersBLL();
var Rozetka = new Store("Brain");
storeBLL.AddProduct(Rozetka, new Product(0, "Razer DeathAdderEssential ", 49.23m, ProductType.Mouse));
storeBLL.AddProduct(Rozetka, new Product(1, "Asus strix b250h gaming", 102, ProductType.Monitor));
storeBLL.AddProduct(Rozetka, new Product(2, "Samsung Curved", 430, ProductType.TV));
storeBLL.AddProduct(Rozetka, new Product(3, "Iphone 12", 1100, ProductType.Phone));
storeBLL.AddProduct(Rozetka, new Product(4, "Intel core I9", 733.50m, ProductType.Processor));
storeBLL.AddProduct(Rozetka, new Product(5, "Razer Kraken BRO", 79.99m, ProductType.Headphones));
storeBLL.AddProduct(Rozetka, 6, "Xiaomi notebook", 300, ProductType.Notebook);
storeUI.PrintAssortment(Rozetka);
var Eugene = new Client(1, "Eugene Rudenberg");
var order_Eugene = new Order(Rozetka, Eugene);
ordersBLL.AddProduct(order_Eugene, Rozetka.Products[2]);
ordersBLL.AddProduct(order_Eugene, Rozetka.Products[3]);
orderUI.PrintProducts(order_Eugene);
Console.WriteLine(order_Eugene.OrderPrice);
Console.ReadLine();
}
protected void Page_Load(object sender, EventArgs e)
{
if (Session["isLogin"] == null)
{
Response.Redirect("Login.aspx");
}
UserAccount user = (UserAccount)Session["UserAccountObj"];
txtOrderId.Text = Request.QueryString["orderid"].ToString();
Orders od = new Orders();
OrdersBLL odbll = new OrdersBLL();
od = odbll.DoRetrieveUserOrderDetails(int.Parse(txtOrderId.Text));
Rider rider = new Rider();
RiderBLL riderBLL = new RiderBLL();
rider = riderBLL.DoRetrieveRiderByID(od.RId);
txtTransactionID.Text = od.TransactionId;
txtRiderID.Text = od.RId.ToString();
txtRiderName.Text = rider.RName;
ReviewBLL reviewBLL = new ReviewBLL();
Review review = reviewBLL.DoRetrieveReviewByOrderID(Convert.ToInt32(txtOrderId.Text));
txtReview.Text = review.ReviewTxt.ToString();
ddlRestaurantRating.SelectedValue = review.RestaurantRating.ToString();
ddlRiderRating.SelectedValue = review.RiderRating.ToString();
}
private void PageInit()
{
UserInfo item = Session["cudoUser"] as UserInfo;
string starttime = txtstartdate.Value;
string endtime = txtenddate.Value;
PagedDataSource pdsdata = new PagedDataSource();
DataSet ds = new OrdersBLL().GetOrderReportListByShopId(item.ShopId, starttime, endtime);
pdsdata.DataSource = ds.Tables[0].DefaultView;
pdsdata.AllowPaging = true;
pdsdata.PageSize = WebPager.PageSize;
pdsdata.CurrentPageIndex = WebPager.CurrentPageIndex - 1; //设置PagedDataSource的当前页数据（PagedDataSource的页数索引是从0开始）
WebPager.RecordCount = pdsdata.DataSourceCount;
rpt_list.DataSource = pdsdata;
rpt_list.DataBind();
decimal sumprice = 0;
int ordercount = 0;
for (int i = 0; i < ds.Tables[0].Rows.Count; i++)
{
ordercount += Convert.ToInt32(ds.Tables[0].Rows[i]["ordercount"]);
sumprice += Convert.ToDecimal(ds.Tables[0].Rows[i]["sumprice"]);
}
L_ordercount.Text = ordercount.ToString();
L_sumprice.Text = sumprice.ToString();
}
/// <summary>
/// 添加，修改
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void btnUpdate_Click(object sender, EventArgs e)
{
if (btnUpdate.Text == "添加")
{
Orders model = new Orders();
model.O_Budget = Convert.ToDateTime(txtBudget.Value);
model.O_Name = txtName.Value.Trim();
model.O_No = txtNo.Value.Trim();
model.O_Time = DateTime.Now;
model.O_Tel = txtTel.Value.Trim();
model.U_Id = users.U_Id;
model.Rt_Id = Convert.ToInt32(ddlRt_Id.SelectedValue);
model.O_State = "未入住";
if (OrdersBLL.AddOrders(model) > 0)
{
this.Page.ClientScript.RegisterStartupScript(this.GetType(), "", "<script>alert('添加成功！');window.location.replace('OrdersManage.aspx');</script>");
return;
}
else
{
this.Page.ClientScript.RegisterStartupScript(this.GetType(), "", "<script>alert('添加失败！');</script>");
return;
}
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (Session["isLogin"] == null)
{
Response.Redirect("Login.aspx");
}
UserAccount user = (UserAccount)Session["UserAccountObj"];
if (!IsPostBack)
{
DataTable dt = new DataTable();
OrdersBLL obll = new OrdersBLL();
dt = obll.DoRetrieveRiderAllCompletedCustomerOrder(user.UserId);
if (dt != null)
{
gv_orderlist2.DataSource = dt;
gv_orderlist2.DataBind();
}
else
{
lblNotWorking.Text = "Unable to retrieve past deliveries";
}
}
}
public ActionResult AllOrders()
{
OrdersBLL bll = new OrdersBLL();
string mobileNo =Convert.ToString(Session["CustomerMobileNo"]);
List<OrderMaster> orders =bll.GetAllOrders(mobileNo);
return View(orders);
}
private void OrderInit()
{
OrdersBLL bll = new OrdersBLL();
WebPager.RecordCount = bll.GetCountByShopId(shopid);
rpt_orderlist.DataSource = bll.GetListByShopId(WebPager.CurrentPageIndex, WebPager.PageSize, shopid);
rpt_orderlist.DataBind();
}
private void PageInit()
{
UserInfo item = Session["cudoUser"] as UserInfo;
List <OrderInfo> list = new OrdersBLL().GetListByUserId(1, 10, item.Id);
rpt_list.DataSource = list.FindAll(delegate(OrderInfo ca) { return(ca.AddTime.ToString("yyyy-MM-dd") == DateTime.Now.ToString("yyyy-MM-dd")); });
rpt_list.DataBind();
}
//分页查找
private void BindData(string strClass)
{
int nowPage = 1;
switch (strClass)
{
case "next":
nowPage = Convert.ToInt32(HNowPage.Value) + 1;
break;
case "up":
nowPage = Convert.ToInt32(HNowPage.Value) - 1;
break;
case "end":
nowPage = Convert.ToInt32(HAllPage.Value);
break;
default:
nowPage = 1;
break;
}
if (Convert.ToInt32(HAllPage.Value) <= 1)
{
LBEnd.Enabled = false;
LBHome.Enabled = false;
LBNext.Enabled = false;
LBUp.Enabled = false;
}
else if (nowPage == 1)
{
LBHome.Enabled = false;
LBUp.Enabled = false;
LBNext.Enabled = true;
LBEnd.Enabled = true;
}
else if (nowPage == Convert.ToInt32(HAllPage.Value))
{
LBHome.Enabled = true;
LBUp.Enabled = true;
LBNext.Enabled = false;
LBEnd.Enabled = false;
}
else
{
LBEnd.Enabled = true;
LBHome.Enabled = true;
LBNext.Enabled = true;
LBUp.Enabled = true;
}
strWhere += " and O_State='未入住'";
this.RpNews.DataSource = OrdersBLL.PageSelectOrders(Convert.ToInt32(HCount.Value), nowPage, strWhere, "O_Time", "desc");
this.RpNews.DataBind();
HNowPage.Value = nowPage.ToString();
PageMes.Text = string.Format("每页{0}条 第{1}页/共{2}页 共{3}条", HCount.Value, nowPage.ToString(), HAllPage.Value, HPageSize.Value);
}
protected void btnCheckout_Click(object sender, EventArgs e)
{
string paymentMode;
string cardNum;
string hasPaid;
DateTime orderCreated = DateTime.Now;
if (txtDeliverAddress.Text.Length <= 0)
{
lblDeliverAddressMsg.Text = "Delivery Address cannot be blank";
}
if (txtContactNo.Text.Length <= 0)
{
lblContactNoMsg.Text = "Contact Number cannot be blank";
}
if (ddlPaymentMode.SelectedValue == "Cash")
{
paymentMode = ddlPaymentMode.SelectedValue;
cardNum = "0";
hasPaid = "NP";
}
else
{
paymentMode = ddlPaymentMode.SelectedValue;
cardNum = ddlCardNum.SelectedValue;
hasPaid = "P";
}
if (txtDeliverAddress.Text.Length > 0 && txtContactNo.Text.Length > 0)
{
DoCheckOutOperation(); //Change OrderItemList checkout status
DoUpdateOrderCountOperation(); //Increase the ordercounter in FoodItem
UserAccount user = (UserAccount)Session["UserAccountObj"];
OrdersBLL ordersBLL = new OrdersBLL();
int result = ordersBLL.DoCreateOrder(user.UserId, Session["generatedId"].ToString(), paymentMode, cardNum, txtDeliverAddress.Text,
txtContactNo.Text, double.Parse(lblDeliveryFee.Text), double.Parse(lblOrderTotalAmt.Text), orderCreated, hasPaid, "Pending Rider");
if (result > 0)
{
alertSuccess.Visible = true;
btnCheckout.Enabled = false;
btnBack.Enabled = false;
UpdateRewardPointRecentLocation(user);
}
else
{
alertFailure.Visible = true;
lblErrorRetrieve.Text = "Unable to create new order record";
}
}
}
/// <summary>
/// 加载绑定
/// </summary>
public void BindLoad()
{
strWhere += " and O_State='未入住'";
int DataCount = OrdersBLL.CountNumber(strWhere); //共多少条记录
int hPageSize = (DataCount % Convert.ToInt32(HCount.Value)) != 0 ? DataCount / Convert.ToInt32(HCount.Value) + 1 : DataCount / Convert.ToInt32(HCount.Value); //共多少页
HPageSize.Value = DataCount.ToString();
HAllPage.Value = hPageSize.ToString();
this.RpNews.DataSource = OrdersBLL.PageSelectOrders(Convert.ToInt32(HCount.Value), Convert.ToInt32(HNowPage.Value), strWhere, "O_Time", "desc");
this.RpNews.DataBind();
}
protected void btn_Review_Click(object sender, EventArgs e)
{
Orders od = new Orders();
OrdersBLL odbll = new OrdersBLL();
RestaurantBLL rbll = new RestaurantBLL();
od = odbll.DoRetrieveUserOrderDetails(int.Parse(txtOrderId.Text));
ReviewBLL reviewBLL = new ReviewBLL();
reviewBLL.DoCreateReview(od.OrderId, od.CId, od.RId, rbll.DoRetrieveRestIdByTransactionId(od.TransactionId), Convert.ToInt32(ddlRiderRating.SelectedValue), Convert.ToInt32(ddlRestaurantRating.SelectedValue), txtReview.Text);
Response.Redirect("UserRetrieveReview.aspx?orderid=" + od.OrderId);
}
protected void btnPastOrders_Click(object sender, EventArgs e)
{
UserAccount user = (UserAccount)Session["UserAccountObj"];
OrdersBLL ordersBLL = new OrdersBLL();
DataTable dt = new DataTable();
dt = ordersBLL.DoRetrieveCustomerCompletedOrder(user.UserId);
gv_pastOrders.DataSource = dt;
gv_pastOrders.DataBind();
gv_pastOrders.Visible = true;
}
//删除
protected void ibDel_ItemDeleting(object sender, EventArgs e)
{
try
{
int Id = Convert.ToInt32((sender as LinkButton).CommandArgument);
OrdersBLL.DeleteOrders(Id);
Response.Write("<script>alert('取消成功！');location=location;</script>");
}
catch
{
Response.Write("<script>alert('取消失败！');</script>");
}
}
public void ProcessRequest(HttpContext context)
{
context.Response.ContentType = "text/plain";
int userid = context.Request["userid"].ToInt32();
int orderid = context.Request["orderid"].ToInt32();
if (userid == 0 || orderid == 0)
{
context.Response.Redirect("../member/MyOrder.aspx");
}
OrdersBLL ordersBLL = new OrdersBLL();
ordersBLL.DeleteOrder(userid, orderid);
context.Response.Redirect("../member/MyOrder.aspx");
}
/// <summary>
/// 提取当前订单积分
/// </summary>
/// <param name="orderNo"></param>
/// <param name="?"></param>
private void fetchPoint(string orderNo)
{
OrdersBLL orderbll = new OrdersBLL();
OrderInfo orderItem = orderbll.GetItem(Convert.ToString(orderNo));
orderbll.UpdateItem(4, orderItem.Id);
UsersBLL ubll = new UsersBLL();
ubll.UpdatePoint(orderItem.OrderPoint, orderItem.UserId);
PageInit();
}
protected void btn_function_Click(object sender, EventArgs e)
{
UserAccount user = (UserAccount)Session["UserAccountObj"];
OrdersBLL odbll = new OrdersBLL();
if (btn_function.Text == "Accept")
{
odbll.DoUpdateOrderStatus(txtTransactionID.Text, "Accept", user.UserId);
txtOrderStatus.Text = "Arrived";
btn_function.Text = "Arrived";
}
else if (btn_function.Text == "Arrived")
{
odbll.DoUpdateOrderStatus(txtTransactionID.Text, "Arrived", user.UserId);
odbll.DoUpdateOrderArriveTime(txtTransactionID.Text, user.UserId, DateTime.Now);
btn_function.Text = "Delivering";
txtOrderStatus.Text = "Delivering";
}
else if (btn_function.Text == "Delivering")
{
odbll.DoUpdateOrderStatus(txtTransactionID.Text, "Delivering", user.UserId);
odbll.DoUpdateOrderDepartTime(txtTransactionID.Text, DateTime.Now);
btn_function.Text = "Completed";
txtOrderStatus.Text = "Completed";
}
else if (btn_function.Text == "Completed")
{
odbll.DoUpdateOrderStatus(txtTransactionID.Text, "Completed", user.UserId);
odbll.DoUpdateOrderDeliverTime(txtTransactionID.Text, DateTime.Now);
Orders od = odbll.DoRetrieveOrderByTransactionId(txtTransactionID.Text);
if (od.IsPaid == "NP")
{
btn_cashPaid.Visible = true;
}
btn_function.Text = "Back";
}
else if (btn_function.Text == "Back")
{
Response.Redirect("RiderReceiveOrder.aspx");
}
}
public async Task <HttpResponseMessage> BeeCommHook([FromBody] BeeComm.OrderHook model)
{
try
{
LoggerSingleton.Instance.Info("BeeCommHook", $"Order Arrived");
/* DUMP */
try
{
var payload = "";
using (var stream = await Request.Content.ReadAsStreamAsync())
{
stream.Seek(0, SeekOrigin.Begin);
using (var sr = new StreamReader(stream))
payload = sr.ReadToEnd();
}
File.AppendAllText($"{AppDomain.CurrentDomain.BaseDirectory}OrdersBK\\payload_{Guid.NewGuid()}.txt", payload);
}
catch { }
if (model.Details.SenderCompanyId == ConfigSingleton.Instance.BeecommSenderCompanyId) // MNEW
{
return(Request.CreateResponse(HttpStatusCode.OK));
}
if (string.IsNullOrEmpty(model.CustomerId))
{
model.CustomerId = "5fc517cb898f9173dbf4adc6"; // TODO ->> Temporary
}
var order = await OrdersBLL.BeeCommOrder2Order(model);
var orderId = await new OrdersBLL().Create(order, false);
LoggerSingleton.Instance.Info("BeeCommHook", $"Order {orderId} has created", new List <string> {
JsonConvert.SerializeObject(model)
});
File.AppendAllText($"{AppDomain.CurrentDomain.BaseDirectory}OrdersBK\\order_{Guid.NewGuid()}.txt", JsonConvert.SerializeObject(model));
return(Request.CreateResponse(HttpStatusCode.OK));
}
catch (Exception ex)
{
LoggerSingleton.Instance.Error("BeeCommHook", ex);
return(Request.CreateResponse(HttpStatusCode.InternalServerError, ex.Message));
}
}
private string GetList(HttpContext context)
{
int pageIndex = ObjectConvertHelper.ConvertToInt(context.Request["page"]);
int pageSize = ObjectConvertHelper.ConvertToInt(context.Request["limit"]);
string name = ObjectConvertHelper.ConvertToString(context.Request["txtName"]);
string strWhere = " and OrderType=1 ";
if (!string.IsNullOrEmpty(name))
{
strWhere += " and OrderType=1 and UserName like '%" + name + "%' ";
}
if (context.User != null)
{
OrdersBLL bll = new OrdersBLL();
List <Orders> list = bll.GetList(strWhere, pageIndex, pageSize);
var config = new MapperConfiguration(cfg => cfg.CreateMap <Orders, ViewOrders>()
.ForMember(dest => dest.Sex, opt => opt.MapFrom((src, des) => { if (src.Sex == 1)
{
return("男");
}
return("女"); }))
.ForMember(dest => dest.CreateTime, opt => opt.MapFrom((src, des) => src.CreateTime.ToString("yyyy-MM-dd HH:mm"))));
var mapper = config.CreateMapper();
List <ViewOrders> list2 = mapper.Map <List <Orders>, List <ViewOrders> >(list);
int count = bll.GetCount(strWhere);
return(JsonConvert.SerializeObject(new
{
code = "0",
msg = "",
count = count,
data = list2
}));
}
else
{
return(JsonConvert.SerializeObject(new
{
code = "0",
msg = "",
count = 0,
data = ""
}));
}
}
protected void btn_cashPaid_Click(object sender, EventArgs e)
{
OrdersBLL odbll = new OrdersBLL();
if (odbll.DoUpdatePaymentStatus(txtTransactionID.Text) != 0)
{
txtOrderStatus.Text = "Payment Is Made";
btn_cashPaid.Enabled = false;
lblSuccess.Text = "Order has been completed!";
lblError.Text = "";
}
else
{
txtOrderStatus.Text = "Issues With Payment";
lblError.Text = "There has been a problem with payment";
lblSuccess.Text = "";
}
}
protected void btnSend_Click(object sender, EventArgs e)
{
StringBuilder str = new StringBuilder(); //餐品内容
OrderInfo item = new OrdersBLL().GetItem(orderno);
Shop shopinfo = new ShopsBLL().GetShopItem(item.ShopId);
List <OrderItem> list = new OrderItemBLL().GetList(orderno);
foreach (OrderItem temp in list)
{
str.Append(temp.ProductName + "(" + temp.BuyNum + ") ");
}
string contentstr = Server.UrlEncode(shopinfo.ShopName + "：" + str.ToString() + "；合" + item.TotalPrice + "元；电话" + shopinfo.Phone);
string sendurl = "http://www.ums86.com:8899/sms/Api/Send.do?SpCode=001418&LoginName=fz_lx&Password=lx6856&MessageContent=" + contentstr + "&UserNumber=" + item.UserTel + "&SerialNumber=&ScheduleTime=&f=1";
GetHtmlFromUrl(sendurl);
Response.Write("<script>window.parent.tb_remove();</script>");
}
public bool AddOrder(OrdersBLL u)
{
bool isSuccess = false;
SqlConnection conn = new SqlConnection(myconnstrng);
try
{
string sql = "INSERT INTO Orders (taxi_contact, taxi_name, taxi_number, contact_user, user_name, add_from, add_to, class, distance, cost) VALUES(@taxi_contact, @taxi_name, @taxi_number, @contact_user, @user_name, @add_from, @add_to, @class, @distance, @cost) ";
SqlCommand cmd = new SqlCommand(sql, conn);
cmd.Parameters.AddWithValue("@taxi_contact", u.taxi_contact);
cmd.Parameters.AddWithValue("@taxi_name", u.taxi_name);
cmd.Parameters.AddWithValue("@taxi_number", u.taxi_number);
cmd.Parameters.AddWithValue("@user_name", u.user_name);
cmd.Parameters.AddWithValue("@contact_user", u.user_contact);
cmd.Parameters.AddWithValue("@add_from", u.from);
cmd.Parameters.AddWithValue("@add_to", u.to);
cmd.Parameters.AddWithValue("@class", u._class);
cmd.Parameters.AddWithValue("@distance", u.distance);
cmd.Parameters.AddWithValue("@cost", u.cost);
conn.Open();
int rows = cmd.ExecuteNonQuery();
if (rows > 0)
{
isSuccess = true;
}
else
{
isSuccess = false;
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
finally
{
conn.Close();
}
return(isSuccess);
}
public bool Insert(OrdersBLL obll)
{
bool IsSuccess = false;
SqlConnection con = new SqlConnection(_con.connection);
string sql = "INSERT INTO [dbo].[OrderDetails]" +
"([ORDERID]" +
",[PRODUCTID]" +
",[QUANTITY ORDERED]" +
",[PRICE EACH])" +
"VALUES" +
"(@ORDERID" +
",@PRODUCTID" +
",@QUANTITY" +
",@PRICEEACH)";
SqlCommand cmd = new SqlCommand(sql, con);
try
{
cmd.Parameters.AddWithValue("@ORDERID", obll.OrderID);
cmd.Parameters.AddWithValue("@PRODUCTID", obll.ProductID);
cmd.Parameters.AddWithValue("@QUANTITY", obll.QuantityOrdered);
cmd.Parameters.AddWithValue("@PRICEEACH", obll.PriceEach);
con.Open();
int i = cmd.ExecuteNonQuery();
if (i > 0)
{
IsSuccess = true;
}
else
{
IsSuccess = false;
}
}
catch (Exception ex)
{
MessageBox.Show(ex.ToString(), "Data Access Error", MessageBoxButtons.OK, MessageBoxIcon.Error, MessageBoxDefaultButton.Button1);
}
finally
{
con.Close();
}
return(IsSuccess);
}
public async Task <ActionResult> Pay(int Id)
{
var ordersBLL = new OrdersBLL();
var order = await ordersBLL.Get(Id);
if (order == null)
{
throw new Exception($"Order #{Id} Does Not Exist");
}
if (order.Details.Status != Entities.eOrderStatus.NONE)
{
throw new Exception($"Order #{Id} is already In-Progress");
}
var cardcomManager = new CardcomManager(
ConfigSingleton.Instance.CardcomTerminal,
ConfigSingleton.Instance.CardcomUserName,
ConfigSingleton.Instance.CardcomNotifyURL,
ConfigSingleton.Instance.CardcomSuccessURL,
ConfigSingleton.Instance.CardcomErrorURL
);
var response = cardcomManager.GenerateIFrameSource(
"הזמנת אוכל",
order.Rows?.Select(row => new CardcomIFrameSourceItem {
Quantity = 1,
Price = row.ItemPrice,
Description = row.ItemName
})?.ToList(),
$"{Id}",
Operation: 1,
InvoiceDetails: new CardcomInvoiceDetails {
CustomerName = order.Details.ClientName,
CustomerId = order.Details.ClientPhone,
Email = order.Details.ClientEmail,
SendEmail = true
}
);
return(View(new Models.PayDTO {
FrameURL = response.URL
}));
}
/**
* 判断是否能提取积分
* 交易状态显示为已完成,则可提示积分
*/
protected string isAbleGetPoint(object orderNo)
{
string result = "";
OrderInfo orderItem = new OrdersBLL().GetItem(Convert.ToString(orderNo));
TimeSpan timeSub = DateTime.Now - orderItem.AddTime;
if (orderItem.OrderStatus == 2)
{
result = "积分可提取";
}
else if (timeSub.Days >= 1)
{
result = "积分可提取";
}
else
{
result = "积分不可提取";
}
return(result);
}
private void ExportData(HttpContext context)
{
string strWhere = " and OrderType=1 ";
string userName = context.Request["UserName"];
if (!string.IsNullOrEmpty(userName))
{
strWhere += string.Format(" and UserName like '%{0}%'", userName);
}
OrdersBLL bll = new OrdersBLL();
List <Models.Orders_Detail> list = bll.GetOrder_DetailList(strWhere);
DataTable table = NPOIHelper.ToDataTable(list);//将list转化为table，转为NPOI需要的数据源格式
//列标题名称
string[] colTitles = { "序号", "认购时间", "姓名", "性别", "业务员代码", "总金额", "电话", "产品名称", "保费", "交费年限" };
//移除不需要导出的列
string[] removeCols = { "Destination", "API", "FMX_Money", "FMX_Count", "ProductType" };
NPOIHelper.InitTable(table, colTitles, removeCols);
NPOIHelper.ExportByWeb_Other(table, "客户认购信息", DateTime.Now.ToString("yyyyMMddHHmmss") + "_客户认购信息.xls", 7);
}
/// <summary>
/// 加载绑定
/// </summary>
public void BindLoad()
{
if (txtNo.Value.Trim().Length != 0)
{
strWhere += " and O_No like '%" + txtNo.Value.Trim() + "%'";
}
if (txtName.Value.Trim().Length != 0)
{
strWhere += " and O_Name like '%" + txtName.Value.Trim() + "%'";
}
if (txtTel.Value.Trim().Length != 0)
{
strWhere += " and O_Tel like '%" + txtTel.Value.Trim() + "%'";
}
if (ddlState.SelectedValue != "全部")
{
strWhere += " and O_State='" + ddlState.SelectedValue + "'";
}
if (txtBeginTime.Value.Trim().Length != 0 && txtEndTime.Value.Trim().Length != 0)
{
strWhere += " and (O_Time>='" + txtBeginTime.Value.Trim() + " 00:00:00' and O_Time<='" + txtEndTime.Value.Trim() + " 23:59:59')";
}
if (txtBeginBudget.Value.Trim().Length != 0 && txtEndBudget.Value.Trim().Length != 0)
{
strWhere += " and (O_Budget>='" + txtBeginBudget.Value.Trim() + "' and O_Budget<='" + txtEndBudget.Value.Trim() + "')";
}
int DataCount = OrdersBLL.CountNumber(strWhere); //共多少条记录
int hPageSize = (DataCount % Convert.ToInt32(HCount.Value)) != 0 ? DataCount / Convert.ToInt32(HCount.Value) + 1 : DataCount / Convert.ToInt32(HCount.Value); //共多少页
HPageSize.Value = DataCount.ToString();
HAllPage.Value = hPageSize.ToString();
this.RpNews.DataSource = OrdersBLL.PageSelectOrders(Convert.ToInt32(HCount.Value), Convert.ToInt32(HNowPage.Value), strWhere, "O_Time", "desc");
this.RpNews.DataBind();
}
/// <summary>
/// 添加，修改
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void btnUpdate_Click(object sender, EventArgs e)
{
if (btnUpdate.Text == "添加")
{
Live model = new Live();
model.L_Deposit = Convert.ToDecimal(txtDeposit.Value.Trim());
model.L_IdCard = txtIdCard.Value.Trim();
model.L_Name = txtName.Value.Trim();
model.L_No = txtNo.Value.Trim();
model.L_OutTime = Convert.ToDateTime("1900-01-01");
model.L_Pay = 0;
model.L_State = "未结算";
model.L_Tel = txtTel.Value.Trim();
model.L_Time = Convert.ToDateTime(txtTime.Value);
model.L_Total = 0;
model.R_Id = Convert.ToInt32(ddlR_Id.SelectedValue);
model.U_Id = users.U_Id;
if (LiveBLL.AddLive(model) > 0)
{
Room room = RoomBLL.GetIdByRoom(Convert.ToInt32(ddlR_Id.SelectedValue));
room.R_State = "入住";
RoomBLL.UpdateRoom(room);
Orders ord = OrdersBLL.GetIdByOrders(Convert.ToInt32(Request.QueryString["id"]));
ord.O_State = "已入住";
OrdersBLL.UpdateOrders(ord);
this.Page.ClientScript.RegisterStartupScript(this.GetType(), "", "<script>alert('添加成功！');window.location.replace('OrdersJoin.aspx');</script>");
return;
}
else
{
this.Page.ClientScript.RegisterStartupScript(this.GetType(), "", "<script>alert('添加失败！');</script>");
return;
}
}
}
public ActionResult PlaceOrder()
{
//OrderDetails order = new OrderDetails();
if (Session["CustomerName"] != null&& Session["CustomerMobileNo"]!= null )
{
OrdersBLL order = new OrdersBLL();
ViewBag.DeliveryAddress = order.getAddress(Session["CustomerMobileNo"].ToString());
}
else
{
return RedirectToAction("DoLogin", "Login");
}
return View();
}
public ActionResult PlaceOrder(FormCollection frm)
{
//OrderDetails order = new OrderDetails();
if (Session["CustomerName"] != null && Session["CustomerMobileNo"] != null)
{
string Name = Convert.ToString(frm["name"]);
string mobileNo = Convert.ToString(frm["mobileNo"]);
string deliveryAddress = Convert.ToString(frm["deliveryAddress"]);
List<Item> items = Session["cart"] as List<Item>;
OrdersBLL bll = new OrdersBLL();
int res = bll.PlaceOrder(Name, mobileNo, deliveryAddress, items);
if (res > 0)
{
Session["cart"] = null;
return RedirectToAction("OrderConfirmation", "Customer", new { orderId = res });
}
else
{
}
}
else
{
return RedirectToAction("DoLogin", "Login");
}
return View();
}
