/// <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));
}
