/// <summary> /// 添加一个红包 /// </summary> /// <param name="info">红包</param> /// <returns></returns> public int Insert(HongBao info) { if (string.IsNullOrEmpty(info.UserID)) { return(0); } info.ID = Guid.NewGuid().ToString(); info.IssueTime = DateTime.Now; int result = dal.Insert(info); if (result == 1)//修改账户金额 { Eyousoft_yhq.BLL.BConDetaile bll = new Eyousoft_yhq.BLL.BConDetaile(); Eyousoft_yhq.Model.MConDetaile con = new Eyousoft_yhq.Model.MConDetaile(); con.JiaoYiHao = info.IssueTime.ToString("yyyyMMddhhmmssfff"); con.DingDanBianHao = info.IssueTime.ToString("yyyyMMddhhmmssfff"); con.JinE = info.HongBaoJinE; con.JiaoYiShiJian = DateTime.Now; con.XFway = Eyousoft_yhq.Model.XFfangshi.红包抽奖; con.HuiYuanID = info.UserID; bll.Add(con); } return(result); }
/// <summary> /// 转账 /// </summary> void PayOther() { string userTo = Utils.GetQueryStringValue("a"); decimal moneys = Utils.GetDecimal(Utils.GetQueryStringValue("m")); int result = new Eyousoft_yhq.BLL.Member().UpdatePayState(HuiYuanInfo.UserID, userTo, moneys); if (result == -102) Utils.RCWE(UtilsCommons.AjaxReturnJson("0", "转账金额不能为0!")); if (result == -101) Utils.RCWE(UtilsCommons.AjaxReturnJson("0", "转账账户错误")); if (result == -100) Utils.RCWE(UtilsCommons.AjaxReturnJson("0", "登陆失败,请重新登陆!")); if (result == -99) Utils.RCWE(UtilsCommons.AjaxReturnJson("0", "可用余额不足!")); if (result == -98) Utils.RCWE(UtilsCommons.AjaxReturnJson("0", "不能给本人转账")); if (result == 0) Utils.RCWE(UtilsCommons.AjaxReturnJson("0", "转帐失败")); if (result == 1) { Eyousoft_yhq.BLL.BConDetaile ser = new Eyousoft_yhq.BLL.BConDetaile(); Eyousoft_yhq.Model.MConDetaile model = new MConDetaile(); model.HuiYuanID = userInfo.UserID; model.XFway = (Model.XFfangshi)XFfangshi.转帐; Random rn = new Random(); model.DingDanBianHao = DateTime.Now.ToString("yyyyMMddHHmm") + rn.Next(10000, 99999).ToString(); model.JiaoYiHao = DateTime.Now.ToString("yyyyMMddHHmm") + rn.Next(10000, 99999).ToString(); model.JiaoYiShiJian = DateTime.Now; string Mobile = Utils.GetQueryStringValue("a"); var modelUser = new Eyousoft_yhq.BLL.Member().GetModelByName(Mobile); model.JiaoYiDuiXiang = modelUser.UserID; model.JinE = moneys; new Eyousoft_yhq.BLL.BConDetaile().Add(model); } Utils.RCWE(UtilsCommons.AjaxReturnJson("1", "转帐成功")); }
/// <summary> /// 增加一条数据 /// </summary> public int Add(MConDetaile model) { StringBuilder strSql = new StringBuilder(); strSql.Append("INSERT INTO tbl_ConDetailed( HuiYuanID, JiaoYiHao ,JinE ,JiaoYiShiJian, XiaoFeiFangShi ,DingDanBianHao ,JiaoYiDuiXiang, DingDanLeiBie) VALUES ( @HuiYuanID, @JiaoYiHao,@JinE,@JiaoYiShiJian, @XiaoFeiFangShi,@DingDanBianHao,@JiaoYiDuiXiang,@DingDanLeiBie)"); DbCommand cmd = this._db.GetSqlStringCommand(strSql.ToString()); this._db.AddInParameter(cmd, "HuiYuanID", DbType.AnsiStringFixedLength, model.HuiYuanID); this._db.AddInParameter(cmd, "JiaoYiHao", DbType.String, model.JiaoYiHao); this._db.AddInParameter(cmd, "JinE", DbType.Decimal, model.JinE); this._db.AddInParameter(cmd, "JiaoYiShiJian", DbType.DateTime, model.JiaoYiShiJian); this._db.AddInParameter(cmd, "XiaoFeiFangShi", DbType.Byte, model.XFway); this._db.AddInParameter(cmd, "DingDanBianHao", DbType.String, model.DingDanBianHao); this._db.AddInParameter(cmd, "JiaoYiDuiXiang", DbType.String, model.JiaoYiDuiXiang); this._db.AddInParameter(cmd, "DingDanLeiBie", DbType.Byte, model.DDCarrtes); return DbHelper.ExecuteSql(cmd, this._db); }
/// <summary> /// 获取分页数据 /// </summary> /// <param name="PageSize"></param> /// <param name="PageIndex"></param> /// <param name="RecordCount"></param> /// <param name="serModel"></param> /// <returns></returns> public IList <Eyousoft_yhq.Model.MConDetaile> GetModelList(int PageSize, int PageIndex, ref int RecordCount, Eyousoft_yhq.Model.MConDetaile serModel) { IList <Eyousoft_yhq.Model.MConDetaile> list = new List <Eyousoft_yhq.Model.MConDetaile>(); string tableName = "tbl_ConDetailed"; string fileds = " ID,HuiYuanID,(select UserName from tbl_Member where UserId=tbl_ConDetailed.HuiYuanID ) as HuiYuanName, JiaoYiHao ,JinE ,JiaoYiShiJian, XiaoFeiFangShi ,DingDanBianHao ,JiaoYiDuiXiang,(select UserName from tbl_Member where UserId=tbl_ConDetailed.JiaoYiDuiXiang ) as DXName, DingDanLeiBie "; string orderByString = "JiaoYiShiJian desc "; StringBuilder query = new StringBuilder(); query.AppendFormat(" 1=1 "); if (serModel != null) { } using (IDataReader dr = DbHelper.ExecuteReader1(this._db, PageSize, PageIndex, ref RecordCount, tableName, fileds, query.ToString(), orderByString, null)) { while (dr.Read()) { Eyousoft_yhq.Model.MConDetaile model = new Eyousoft_yhq.Model.MConDetaile(); model.ID = dr.GetInt32(dr.GetOrdinal("ID")); model.HuiYuanID = dr.GetString(dr.GetOrdinal("HuiYuanID")); model.HuiYuanName = dr.GetString(dr.GetOrdinal("HuiYuanName")); model.JiaoYiHao = dr.GetString(dr.GetOrdinal("JiaoYiHao")); model.JinE = dr.GetDecimal(dr.GetOrdinal("JinE")); model.JiaoYiShiJian = dr.GetDateTime(dr.GetOrdinal("JiaoYiShiJian")); model.XFway = (Eyousoft_yhq.Model.XFfangshi)dr.GetByte(dr.GetOrdinal("XiaoFeiFangShi")); model.DingDanBianHao = dr.GetString(dr.GetOrdinal("DingDanBianHao")); model.DuiXiangName = dr.IsDBNull(dr.GetOrdinal("DXName")) ? "" : dr.GetString(dr.GetOrdinal("DXName")); model.DDCarrtes = (Eyousoft_yhq.Model.DDleibie)dr.GetByte(dr.GetOrdinal("DingDanLeiBie")); list.Add(model); } } return(list); }
/// <summary> /// 添加一个红包 /// </summary> /// <param name="info">红包</param> /// <returns></returns> public int Insert(HongBao info) { if (string.IsNullOrEmpty(info.UserID)) return 0; info.ID = Guid.NewGuid().ToString(); info.IssueTime = DateTime.Now; int result = dal.Insert(info); if (result == 1)//修改账户金额 { Eyousoft_yhq.BLL.BConDetaile bll = new Eyousoft_yhq.BLL.BConDetaile(); Eyousoft_yhq.Model.MConDetaile con = new Eyousoft_yhq.Model.MConDetaile(); con.JiaoYiHao = info.IssueTime.ToString("yyyyMMddhhmmssfff"); con.DingDanBianHao = info.IssueTime.ToString("yyyyMMddhhmmssfff"); con.JinE = info.HongBaoJinE; con.JiaoYiShiJian = DateTime.Now; con.XFway = Eyousoft_yhq.Model.XFfangshi.红包抽奖; con.HuiYuanID = info.UserID; bll.Add(con); } return result; }
/// <summary> /// 获取分页数据 /// </summary> /// <param name="PageSize"></param> /// <param name="PageIndex"></param> /// <param name="RecordCount"></param> /// <param name="serModel"></param> /// <returns></returns> public IList<Eyousoft_yhq.Model.MConDetaile> GetModelList(int PageSize, int PageIndex, ref int RecordCount, Eyousoft_yhq.Model.MConDetaile serModel) { IList<Eyousoft_yhq.Model.MConDetaile> list = new List<Eyousoft_yhq.Model.MConDetaile>(); string tableName = "tbl_ConDetailed"; string fileds = " ID,HuiYuanID,(select UserName from tbl_Member where UserId=tbl_ConDetailed.HuiYuanID ) as HuiYuanName, JiaoYiHao ,JinE ,JiaoYiShiJian, XiaoFeiFangShi ,DingDanBianHao ,JiaoYiDuiXiang,(select UserName from tbl_Member where UserId=tbl_ConDetailed.JiaoYiDuiXiang ) as DXName, DingDanLeiBie "; string orderByString = "JiaoYiShiJian desc "; StringBuilder query = new StringBuilder(); query.AppendFormat(" 1=1 "); if (serModel != null) { } using (IDataReader dr = DbHelper.ExecuteReader1(this._db, PageSize, PageIndex, ref RecordCount, tableName, fileds, query.ToString(), orderByString, null)) { while (dr.Read()) { Eyousoft_yhq.Model.MConDetaile model = new Eyousoft_yhq.Model.MConDetaile(); model.ID = dr.GetInt32(dr.GetOrdinal("ID")); model.HuiYuanID = dr.GetString(dr.GetOrdinal("HuiYuanID")); model.HuiYuanName = dr.GetString(dr.GetOrdinal("HuiYuanName")); model.JiaoYiHao = dr.GetString(dr.GetOrdinal("JiaoYiHao")); model.JinE = dr.GetDecimal(dr.GetOrdinal("JinE")); model.JiaoYiShiJian = dr.GetDateTime(dr.GetOrdinal("JiaoYiShiJian")); model.XFway = (Eyousoft_yhq.Model.XFfangshi)dr.GetByte(dr.GetOrdinal("XiaoFeiFangShi")); model.DingDanBianHao = dr.GetString(dr.GetOrdinal("DingDanBianHao")); model.DuiXiangName = dr.IsDBNull(dr.GetOrdinal("DXName")) ? "" : dr.GetString(dr.GetOrdinal("DXName")); model.DDCarrtes = (Eyousoft_yhq.Model.DDleibie)dr.GetByte(dr.GetOrdinal("DingDanLeiBie")); list.Add(model); } } return list; }
/// <summary> /// 支付订单 /// </summary> void Save() { var order = new Eyousoft_yhq.BLL.Order().GetModel(Utils.GetQueryStringValue("id")); if (order == null) Utils.RCWE(UtilsCommons.AjaxReturnJson("0", "数据丢失,请刷新页面")); order.PayState = Eyousoft_yhq.Model.PaymentState.已支付; int i = new Eyousoft_yhq.BLL.Order().XiaoFei(order, HuiYuanInfo.UserID); if (i == 1) { Eyousoft_yhq.Model.MConDetaile model = new MConDetaile(); model.HuiYuanID = HuiYuanInfo.UserID; model.XFway = (Model.XFfangshi)XFfangshi.消费; Random rn = new Random(); model.DingDanBianHao = order.OrderCode; model.JiaoYiHao = DateTime.Now.ToString("yyyyMMddHHmm") + rn.Next(10000, 99999).ToString(); model.JiaoYiShiJian = DateTime.Now; model.DDCarrtes = DDleibie.旅游订单; model.JinE = order.OrderPrice; new Eyousoft_yhq.BLL.BConDetaile().Add(model); } if (i == -99) Utils.RCWE(UtilsCommons.AjaxReturnJson("0", "已支付")); if (i == -98) Utils.RCWE(UtilsCommons.AjaxReturnJson("0", "余额不足")); if (i == 0) Utils.RCWE(UtilsCommons.AjaxReturnJson("0", "支付失败")); if (i == 1) Utils.RCWE(UtilsCommons.AjaxReturnJson("0", "支付成功")); }
/// <summary> /// 支付 /// </summary> void setZF() { decimal money = Utils.GetDecimal(Utils.GetQueryStringValue("op")); string orderid = Utils.GetQueryStringValue("id"); var order = new Eyousoft_yhq.BLL.BJiPiaoBaoCun().GetModel(orderid); if (order == null) Utils.RCWE(UtilsCommons.AjaxReturnJson("0", "数据丢失,请重新操作")); int result = new Eyousoft_yhq.BLL.BJiPiaoBaoCun().ZhiFu(new MJiPiaoBaoCun() { OpeatorID = userInfo.UserID, OrderID = orderid, payState = TickOrderPayState.已支付, OrderPrice = money }); if (result == -99) Utils.RCWE(UtilsCommons.AjaxReturnJson("0", "账户余额不足,请联系4008005216进行充值!")); if (result == -98) Utils.RCWE(UtilsCommons.AjaxReturnJson("0", "已支付!")); if (result == 0) Utils.RCWE(UtilsCommons.AjaxReturnJson("0", "支付失败!")); if (result == 1) { Eyousoft_yhq.BLL.BConDetaile ser = new Eyousoft_yhq.BLL.BConDetaile(); Eyousoft_yhq.Model.MConDetaile model = new MConDetaile(); model.HuiYuanID = userInfo.UserID; model.XFway = (Model.XFfangshi)XFfangshi.消费; Random rn = new Random(); model.DingDanBianHao = order.OrderCode; model.JiaoYiHao = DateTime.Now.ToString("yyyyMMddHHmm") + rn.Next(10000, 99999).ToString(); model.JiaoYiShiJian = DateTime.Now; model.DDCarrtes = DDleibie.机票订单; model.JinE = money; new Eyousoft_yhq.BLL.BConDetaile().Add(model); } if (result == 1) { var model = new Eyousoft_yhq.BLL.BJiPiaoBaoCun().GetModel(orderid); if (model == null) Utils.RCWE(UtilsCommons.AjaxReturnJson("0", "数据丢失,请重新操作")); StringBuilder strbu = new StringBuilder(); strbu.Append("<?xml version=\"1.0\"?>"); strbu.Append("<AskOrderTicket_1_1>"); strbu.AppendFormat("<SubsOrderNo>{0}</SubsOrderNo>", model.OrderCode); strbu.AppendFormat("<ModifyTag>{0}</ModifyTag>", model.ModifyTag); strbu.AppendFormat("<NotifyURL>{0}</NotifyURL>", "http://www.4008005216.com/webMaster/JPBackRequest.aspx"); strbu.AppendFormat("<NotifyType>{0}</NotifyType>", "post"); strbu.AppendFormat("<BankCode>{0}</BankCode>", ""); strbu.AppendFormat("<BankNo>{0}</BankNo>", ""); strbu.AppendFormat("<BalanceDate>{0}</BalanceDate>", ""); strbu.AppendFormat("<PayType>{0}</PayType>", "QK"); strbu.AppendFormat("<PrintTktType>{0}</PrintTktType>", "B"); strbu.Append("</AskOrderTicket_1_1>"); var Result = new com._8222666.fxb2b.Service().XmlSubmit(getIdentityXMLString(), strbu.ToString(), ""); XmlDocument doc = new XmlDocument(); doc.LoadXml(Result); if (doc.SelectSingleNode("AskOrderTicket_1_1") != null && doc.SelectSingleNode("AskOrderTicket_1_1").SelectSingleNode("Status").InnerText == "OK") { model.payState = Eyousoft_yhq.Model.TickOrderPayState.出票中; bool mark = new Eyousoft_yhq.BLL.BJiPiaoBaoCun().setState(model); if (mark) Utils.RCWE(UtilsCommons.AjaxReturnJson("1", "支付成功,自动出票失败!")); } else { Utils.RCWE(UtilsCommons.AjaxReturnJson("1", "支付成功,自动出票失败!")); } } if (result == 1) Utils.RCWE(UtilsCommons.AjaxReturnJson("1", "支付成功,申请自动出票!")); }