/// <summary> /// 购买会员卡成功后处理订单 /// </summary> /// <param name="orderNo"></param> public static void DoneOrderSuccess(string orderNo) { try { System.Data.DataTable dt = HotelCloud.SqlServer.SQLHelper.Get_DataTable("select * from MemberCardBuyRecord wiht(nolock) where orderno=@orderno and orderstatus=0 ", HotelCloud.SqlServer.SQLHelper.GetCon(), new Dictionary <string, HotelCloud.SqlServer.DBParam> { { "orderNo", new HotelCloud.SqlServer.DBParam { ParamValue = orderNo } } }); if (dt.Rows.Count == 0) { return; } int row = HotelCloud.SqlServer.SQLHelper.Run_SQL("update MemberCardBuyRecord set orderStatus=1,payTime=getdate() where orderno=@orderno", HotelCloud.SqlServer.SQLHelper.GetCon(), new Dictionary <string, HotelCloud.SqlServer.DBParam> { { "orderNo", new HotelCloud.SqlServer.DBParam { ParamValue = orderNo } } }); if (row > 0) { int levelRows = HotelCloud.SqlServer.SQLHelper.Run_SQL("update Member set viptype=@viptype where weixinId=@weixinId and userweixinno=@userweixinno ", HotelCloud.SqlServer.SQLHelper.GetCon(), new Dictionary <string, HotelCloud.SqlServer.DBParam> { { "viptype", new HotelCloud.SqlServer.DBParam { ParamValue = dt.Rows[0]["CardLevel"].ToString() } }, { "weixinId", new HotelCloud.SqlServer.DBParam { ParamValue = dt.Rows[0]["weixinId"].ToString() } }, { "userweixinno", new HotelCloud.SqlServer.DBParam { ParamValue = dt.Rows[0]["userweixinId"].ToString() } } }); DataTable db_member = WeiXin.Models.Home.RechargeCard.GetRechargeMemberInfo(dt.Rows[0]["weixinId"].ToString(), dt.Rows[0]["userweixinId"].ToString()); if (db_member.Rows[0]["cardNO"].ToString() == string.Empty) { //没有会员卡生成会员卡号 string cardNo = hotel3g.Repository.MemberHelper.GetNotUsedCard(dt.Rows[0]["hotelId"].ToString(), dt.Rows[0]["weixinId"].ToString()); if (!string.IsNullOrEmpty(cardNo)) { int updateRows = HotelCloud.SqlServer.SQLHelper.Run_SQL("update MemberCard set isuse=1 , binddate=getdate() where weixinId=@weixinId and cardno=@cardno ", HotelCloud.SqlServer.SQLHelper.GetCon(), new Dictionary <string, HotelCloud.SqlServer.DBParam> { { "cardno", new HotelCloud.SqlServer.DBParam { ParamValue = cardNo } }, { "weixinId", new HotelCloud.SqlServer.DBParam { ParamValue = dt.Rows[0]["weixinId"].ToString() } } }); if (updateRows > 0) { updateRows = HotelCloud.SqlServer.SQLHelper.Run_SQL("update Member set cardno=@cardno, name=@name,mobile=@mobile where weixinId=@weixinId and userweixinno=@userweixinno ", HotelCloud.SqlServer.SQLHelper.GetCon(), new Dictionary <string, HotelCloud.SqlServer.DBParam> { { "cardno", new HotelCloud.SqlServer.DBParam { ParamValue = cardNo } }, { "weixinId", new HotelCloud.SqlServer.DBParam { ParamValue = dt.Rows[0]["weixinId"].ToString() } }, { "userweixinno", new HotelCloud.SqlServer.DBParam { ParamValue = dt.Rows[0]["userweixinId"].ToString() } }, { "name", new HotelCloud.SqlServer.DBParam { ParamValue = dt.Rows[0]["name"].ToString() } }, { "mobile", new HotelCloud.SqlServer.DBParam { ParamValue = dt.Rows[0]["mobile"].ToString() } } }); if (updateRows > 0) { //会员注册赠送订房红包 MemberHelper.RegisterCouponGift(dt.Rows[0]["weixinId"].ToString(), dt.Rows[0]["userweixinId"].ToString()); //绑定推广员赠送订房红包 MemberHelper.UpdateCommission(dt.Rows[0]["hotelid"].ToString(), dt.Rows[0]["weixinId"].ToString(), dt.Rows[0]["userweixinId"].ToString()); //推广员送红包 int PromoterID = MemberHelper.GetPromoterID(dt.Rows[0]["userweixinId"].ToString(), dt.Rows[0]["weixinId"].ToString()); if (PromoterID > 0) { bool pstatus = false; string pstr = PromoterDAL.SendCustomCoupon(dt.Rows[0]["weixinId"].ToString(), dt.Rows[0]["mobile"].ToString(), Convert.ToInt32(db_member.Rows[0]["Id"].ToString()), Convert.ToInt32(dt.Rows[0]["hotelid"].ToString()), out pstatus); } } } } } //送红包 积分 DataTable dt_hb = HotelCloud.SqlServer.SQLHelper.Get_DataTable("select hongbaomoney,givejifen from MemberCardCustom with(nolock) where Id=@Id", HotelCloud.SqlServer.SQLHelper.GetCon(), new Dictionary <string, HotelCloud.SqlServer.DBParam> { { "Id", new HotelCloud.SqlServer.DBParam { ParamValue = dt.Rows[0]["CardId"].ToString() } } }); if (dt_hb.Rows.Count > 0) { string hongbaomoney = dt_hb.Rows[0]["hongbaomoney"].ToString(); if (!string.IsNullOrEmpty(hongbaomoney) && Convert.ToInt32(Convert.ToDecimal(hongbaomoney)) > 0) { int hbmoney = Convert.ToInt32(Convert.ToDecimal(hongbaomoney)); int rows = AddCardCoupon(dt.Rows[0]["weixinId"].ToString(), dt.Rows[0]["userweixinId"].ToString(), hbmoney, Convert.ToInt32(dt.Rows[0]["cardId"].ToString())); } int givejifen = Convert.ToInt32(dt_hb.Rows[0]["givejifen"].ToString()); if (givejifen > 0) { //重新获取会员最新信息 DataTable dbmember_new = WeiXin.Models.Home.RechargeCard.GetRechargeMemberInfo(dt.Rows[0]["weixinId"].ToString(), dt.Rows[0]["userweixinId"].ToString()); int userId = 0; string cardno = string.Empty; if (dbmember_new.Rows.Count > 0) { int.TryParse(dbmember_new.Rows[0]["Id"].ToString(), out userId); cardno = dbmember_new.Rows[0]["cardno"].ToString(); } int row_jifen = AddCardJifen(dt.Rows[0]["weixinId"].ToString(), dt.Rows[0]["userweixinId"].ToString(), userId, cardno, givejifen, Convert.ToInt32(dt.Rows[0]["cardId"].ToString())); if (row_jifen > 0) { row_jifen = MemberCardBuyRecord.UpdateUserJifen(dt.Rows[0]["weixinId"].ToString(), dt.Rows[0]["userweixinId"].ToString(), givejifen); } } } } } catch (Exception ex) { WeiXin.Common.Logger.Instance.Error(ex.ToString()); } }
public static int AddModel(MemberCardBuyRecord model) { return(MemberCardBuyRecordDAL.AddModel(model)); }