/// <summary> /// 买票信息记录到数据库 /// </summary> /// <param name="model"></param> /// <returns>返回成功与否</returns> public int AddBMOrderPW(BMOrderPW model) { SqlParameter[] para = { new SqlParameter("@ourterTid", model.OurterTid), new SqlParameter("@ctime", model.Ctime), new SqlParameter("@etime", model.Etime), new SqlParameter("@Number", model.Number), new SqlParameter("@itemId", model.ItemId), new SqlParameter("@passengerName", model.PassengerName), new SqlParameter("@passengerTel", model.PassengerTel), new SqlParameter("@startTime", model.StartTime), new SqlParameter("@startStation", model.StartStation), new SqlParameter("@recevieStation", model.RecevieStation), new SqlParameter("@flightCompanyName", model.FlightCompanyName), new SqlParameter("@depTime", model.DepTime), new SqlParameter("@arriTime", model.ArriTime), new SqlParameter("@flightCompanyCode", model.FlightCompanyCode), new SqlParameter("@flightNo", model.FlightNo), new SqlParameter("@seatMsg", model.SeatMsg), new SqlParameter("@seatStatus", model.SeatStatus), new SqlParameter("@parPrice", model.ParPrice), new SqlParameter("@EPmny", model.EPmny), new SqlParameter("@hl", model.Hl), new SqlParameter("@totalPayCash", model.TotalPayCash), new SqlParameter("@orderType", model.OrderType), new SqlParameter("@title", model.Title), }; return(DBHelper.ExecuteNonQuery("AddBMOrderPW", para, CommandType.StoredProcedure)); }
protected void ydcp_Click(object sender, EventArgs e) { if (ckxm.Text == "") { ClientScript.RegisterStartupScript(this.GetType(), "", "<script>alert('" + GetTran("010464", "乘客姓名不能为空!") + "')</script>", false); } if (cksj.Text == "") { ClientScript.RegisterStartupScript(this.GetType(), "", "<script>alert('" + GetTran("010465", "乘客手机号不能为空!") + "')</script>", false); } if (ckzj.Text == "") { ClientScript.RegisterStartupScript(this.GetType(), "", "<script>alert('" + GetTran("010466", "乘客证件号不能为空!") + "')</script>", false); } if (dplxr.Text == "") { dplxr.Text = ckxm.Text; } if (lxrdh.Text == "") { lxrdh.Text = cksj.Text; } IOpenClient client = new DefaultOpenClient(BMEshenghuo.serverUrl, BMEshenghuo.appKey, BMEshenghuo.appSecret); CoachCreateBillRequest req = new CoachCreateBillRequest(); req.StationCode = seatCode.Value;//商品编号 req.ContactName = dplxr.Text; req.ContactTel = lxrdh.Text; req.DptDateTime = DepTime.Value; req.DptStation = seatMsg.Value; req.ArrStation = seatStatus.Value; req.Departure = cfcs.SelectedValue; req.Destination = zdz.SelectedValue; req.ItemIdCoach = mc.SelectedValue; req.CoachNO = flightNo.Value; req.SeatPrice = parPrice.Value; req.Passagers = ckxm.Text + "," + cksj.Text + "," + ckzj.Text;//乘客信息,以英文逗号分隔, CoachCreateBillResponse response = client.Execute(req, BMEshenghuo.accessToken); BMOrderPW bo = new BMOrderPW(); if (!response.IsError) { seatStatus.Value = response.TicketTrade.TradeNo; ClientScript.RegisterStartupScript(this.GetType(), "", "<script>alertt('" + GetTran("010500", "预订成功请点击支付!") + "');</script>", false); } }
protected void ydcp_Click(object sender, EventArgs e) { if (ckxm.Text == "") { ClientScript.RegisterStartupScript(this.GetType(), "", "<script>alert('" + GetTran("010464", "乘客姓名不能为空!") + "')</script>", false); } if (cksj.Text == "") { ClientScript.RegisterStartupScript(this.GetType(), "", "<script>alert('" + GetTran("010465", "乘客手机号不能为空!") + "')</script>", false); } if (ckzj.Text == "") { ClientScript.RegisterStartupScript(this.GetType(), "", "<script>alert('" + GetTran("010466", "乘客证件号不能为空!") + "')</script>", false); } if (dplxr.Text == "") { dplxr.Text = ckxm.Text; } if (lxrdh.Text == "") { lxrdh.Text = cksj.Text; } IOpenClient client = new DefaultOpenClient(BMEshenghuo.serverUrl, BMEshenghuo.appKey, BMEshenghuo.appSecret); TrainOrderCreateRequest req = new TrainOrderCreateRequest(); req.ItemIdTrain = mc.SelectedValue;//商品编号 req.ContactName = dplxr.Text; req.ContactTel = lxrdh.Text; req.Date = txtBeginTime.Text; req.From = qdz.SelectedValue; req.To = zdz.SelectedValue; req.TrainNumber = flightNo.Value; req.StartTime = DepTime.Value; req.Passagers = ckxm.Text + "," + cksj.Text + "," + ckzj.Text;//乘客信息,以英文逗号分隔, TrainOrderCreateResponse response = client.Execute(req, BMEshenghuo.accessToken); BMOrderPW bo = new BMOrderPW(); if (!response.IsError) { seatStatus.Value = response.TicketTrade.TradeNo; } }
public void chongzhi() { DataTable dt_one = DAL.DBHelper.ExecuteDataTable("select MobileTele,TotalRemittances-TotalDefray as xf from memberinfo where Number='" + Session["Member"].ToString() + "'"); if (dt_one.Rows.Count > 0) { string ipn = dt_one.Rows[0]["MobileTele"].ToString(); decimal xf = Convert.ToDecimal(dt_one.Rows[0]["xf"].ToString()); if (xf < Convert.ToDecimal(lab.Text)) { ClientScript.RegisterStartupScript(this.GetType(), "", "<script>$('#tiaoz').show();document.getElementById('tiaoz').href = '../MemberMobile/MemberCZXF.aspx'; alertt('" + GetTran("000000", "账户金额不足,请先充值!") + "');</script>", false); } else { IOpenClient client = new DefaultOpenClient(BMEshenghuo.serverUrl, BMEshenghuo.appKey, BMEshenghuo.appSecret); CoachOrderPayRequest req = new CoachOrderPayRequest(); req.TradeNo = seatStatus.Value; //req.OuterTid = "YCZ" + Model.Other.MYDateTime.ToYYMMDDHHmmssString(); CoachOrderPayResponse response = client.Execute(req, BMEshenghuo.accessToken); BMOrderPW bo = new BMOrderPW(); if (!response.IsError) { bo.OurterTid = "FJP" + Model.Other.MYDateTime.ToYYMMDDHHmmssString();; bo.Ctime = DateTime.Now; bo.Etime = DateTime.Now; bo.Number = Session["Member"].ToString(); List <Qianmi.Api.Domain.Elife.TicketOrder> alist = response.TicketTrade.TicketOrders; foreach (Qianmi.Api.Domain.Elife.TicketOrder item in alist) { bo.ItemId = item.ItemId; bo.PassengerName = item.PassengerName + "," + item.PassengerTel + "," + item.IdcardNo; bo.PassengerTel = ""; } bo.StartTime = Convert.ToDateTime(response.TicketTrade.StartTime); bo.EPmny = Convert.ToDecimal(response.TicketTrade.TotalPayCash) / Common.GetnowPrice() / 7 * 4; bo.Hl = 4; bo.StartStation = response.TicketTrade.StartStation; bo.RecevieStation = response.TicketTrade.RecevieStation; bo.FlightCompanyName = FlightCompanyName.Value; bo.DepTime = Convert.ToDateTime(DepTime.Value); bo.ArriTime = Convert.ToDateTime(ArriTime.Value); bo.FlightCompanyCode = airlineCode.Value; bo.FlightNo = flightNo.Value; bo.SeatMsg = seatMsg.Value; bo.SeatStatus = seatStatus.Value; bo.ParPrice = response.TicketTrade.TotalFacePrice; bo.TotalPayCash = response.TicketTrade.TotalPayCash; bo.OrderType = 2; bo.Title = response.TicketTrade.Title; BMOrderBLL bob = new BMOrderBLL(); int abo = bob.AddBMOrderPW(bo); if (abo == 1) { ClientScript.RegisterStartupScript(this.GetType(), "", "<script>alert('" + GetTran("000000", "账户金额不足!") + "')</script>", false); } else { //DAL.CommonDataDAL.EncryptionAccount(1, Session["Member"].ToString(), "E生活操作", "", CommonDataBLL.OperateIP); ClientScript.RegisterStartupScript(this.GetType(), "", "<script>$('#tiaoz').show();document.getElementById('tiaoz').href = '../MemberMobile/First.aspx'; alertt('" + GetTran("010487", "订单已支付,请稍后查询!") + "');</script>", false); } } } } }
/// <summary> /// 充值信息记录到数据库 /// </summary> /// <returns></returns> public int AddBMOrderPW(BMOrderPW model) { return(aod.AddBMOrderPW(model)); }