/// <summary> /// 显示订单信息 /// </summary> protected void initPage() { string id = Utils.GetQueryStringValue("id"); string ordertype = Utils.GetQueryStringValue("ordertype"); if (ordertype == "order") { var model = new Eyousoft_yhq.BLL.Order().GetModel(id); if (model == null) { lblxiaofei.Text = "未找到此订单!"; xiaofei.Visible = isXF.Visible = false; return; } if (model.XiaoFei == Eyousoft_yhq.Model.XFstate.已消费 && model.AvailNum <= 0) { lblxiaofei.Text = "此订单已消费!"; xiaofei.Visible = isXF.Visible = false; return; } else if (DateTime.Compare(model.ZCodeViaDate, DateTime.Now) < 0) { lblxiaofei.Text = "此订单已过期!"; xiaofei.Visible = isXF.Visible = false; return; } else { cusName.Value = model.MemberName; cusMob.Value = model.MemberTel; proName.Value = model.ProductName; if (model.JIESUAN == Eyousoft_yhq.Model.JSfangshi.预付 && model.PayState == Eyousoft_yhq.Model.PaymentState.已支付) fangshi = model.JIESUAN; lblxiaofei.Visible = false; } } else { var model = new Eyousoft_yhq.BLL.GYSticket().GetModel(id); if (model == null) { lblxiaofei.Text = "未找到此订单!"; xiaofei.Visible = isXF.Visible = false; return; } if (model.orderState == Eyousoft_yhq.Model.TickOrderState.已出票) { lblxiaofei.Text = "此订单已出票!"; xiaofei.Visible = isXF.Visible = false; return; } else { cusName.Value = model.CusName; cusMob.Value = model.CusMob; proName.Value = "机票:" + model.PlaneTicket; lblxiaofei.Visible = false; } } }
/// <summary> /// 修改消费状态,结算方式 /// </summary> /// <param name="model"></param> /// <returns></returns> public bool setConSumState(string orderid, string UserId, Eyousoft_yhq.Model.JSfangshi fangshi, string mobNo) { if (string.IsNullOrEmpty(orderid) || string.IsNullOrEmpty(UserId)) { return(false); } return(dal.setConSumState(orderid, UserId, fangshi, mobNo)); }
/// <summary> /// 修改消费状态,结算方式 /// </summary> /// <param name="model"></param> /// <returns></returns> public bool setConSumState(string orderid, string UserId, Eyousoft_yhq.Model.JSfangshi fangshi, string AppMobNo) { StringBuilder strSql = new StringBuilder(); strSql.AppendFormat("UPDATE tbl_Order SET ConSumState=1,AppUserId=@UserId,AppTime=getdate(),JState=@JState,AvailNum=AvailNum-1 WHERE OrderID =@OrderID;"); strSql.AppendFormat("INSERT INTO tbl_OrderAppScan (OrderID,OrderType,AppUserId,AppMobNo) VALUES(@OrderID,0,@UserId,@AppMobNo);"); DbCommand cmd = this._db.GetSqlStringCommand(strSql.ToString()); this._db.AddInParameter(cmd, "OrderID", DbType.AnsiStringFixedLength, orderid); this._db.AddInParameter(cmd, "UserId", DbType.AnsiStringFixedLength, UserId); this._db.AddInParameter(cmd, "JState", DbType.Byte, (int)fangshi); this._db.AddInParameter(cmd, "AppMobNo", DbType.AnsiStringFixedLength, AppMobNo); return(DbHelper.ExecuteSql(cmd, this._db) > 0 ? true : false); }
/// <summary> /// 显示订单信息 /// </summary> protected void initPage() { string id = Utils.GetQueryStringValue("id"); string ordertype = Utils.GetQueryStringValue("ordertype"); if (ordertype == "order") { var model = new Eyousoft_yhq.BLL.Order().GetModel(id); if (model == null) { lblxiaofei.Text = "未找到此订单!"; xiaofei.Visible = isXF.Visible = false; return; } if (model.XiaoFei == Eyousoft_yhq.Model.XFstate.已消费 && model.AvailNum <= 0) { lblxiaofei.Text = "此订单已消费!"; xiaofei.Visible = isXF.Visible = false; return; } else if (DateTime.Compare(model.ZCodeViaDate, DateTime.Now) < 0) { lblxiaofei.Text = "此订单已过期!"; xiaofei.Visible = isXF.Visible = false; return; } else { cusName.Value = model.MemberName; cusMob.Value = model.MemberTel; proName.Value = model.ProductName; if (model.JIESUAN == Eyousoft_yhq.Model.JSfangshi.预付 && model.PayState == Eyousoft_yhq.Model.PaymentState.已支付) { fangshi = model.JIESUAN; } lblxiaofei.Visible = false; } } else { var model = new Eyousoft_yhq.BLL.GYSticket().GetModel(id); if (model == null) { lblxiaofei.Text = "未找到此订单!"; xiaofei.Visible = isXF.Visible = false; return; } if (model.orderState == Eyousoft_yhq.Model.TickOrderState.已出票) { lblxiaofei.Text = "此订单已出票!"; xiaofei.Visible = isXF.Visible = false; return; } else { cusName.Value = model.CusName; cusMob.Value = model.CusMob; proName.Value = "机票:" + model.PlaneTicket; lblxiaofei.Visible = false; } } }