public static int AddRechargeCard(RechargeCard model) { return(RechargeCardDAL.AddRechargeCard(model)); }
public static int UpdateRechargeCard(RechargeCard model) { return(RechargeCardDAL.UpdateRechargeCard(model)); }
/// <summary> /// 微信支付成功后处理 /// </summary> /// <param name="ordeNO"></param> /// <returns></returns> public static bool DoUserRechargeSuccess(string ordeNO) { bool flag = false; try { string sql = "select cardId,hotelweixinId,userweixinId,Mprice from RechargeUser with(nolock) where orderNO=@orderNo and orderStatus=0 "; DataTable db_RechargeOrder = HotelCloud.SqlServer.SQLHelper.Get_DataTable(sql, HotelCloud.SqlServer.SQLHelper.GetCon(), new Dictionary <string, HotelCloud.SqlServer.DBParam> { { "orderNo", new HotelCloud.SqlServer.DBParam { ParamValue = ordeNO } }, }); if (db_RechargeOrder.Rows.Count == 0) { return(flag); } DataTable dbMember = RechargeCard.GetRechargeMemberInfo(db_RechargeOrder.Rows[0]["hotelweixinId"].ToString(), db_RechargeOrder.Rows[0]["userweixinId"].ToString()); if (dbMember.Rows.Count != 1) { return(false); } using (TransactionScope scop = new TransactionScope()) { //销售数量+1 sql = "update RechargeCard set saleNum=saleNum+1 where weixinId=@weixinId and Id=@Id "; int row = HotelCloud.SqlServer.SQLHelper.Run_SQL(sql, HotelCloud.SqlServer.SQLHelper.GetCon(), new Dictionary <string, HotelCloud.SqlServer.DBParam> { { "weixinId", new HotelCloud.SqlServer.DBParam { ParamValue = db_RechargeOrder.Rows[0]["hotelweixinId"].ToString() } }, { "Id", new HotelCloud.SqlServer.DBParam { ParamValue = db_RechargeOrder.Rows[0]["cardId"].ToString() } }, }); if (row > 0) { //更新订单状态及金额 sql = "update RechargeUser set orderStatus=1,Beforebalance=@Beforebalance,Balance=Mprice + @Beforebalance,addTime=getdate() where orderNo=@orderNo "; row = HotelCloud.SqlServer.SQLHelper.Run_SQL(sql, HotelCloud.SqlServer.SQLHelper.GetCon(), new Dictionary <string, HotelCloud.SqlServer.DBParam> { { "orderNo", new HotelCloud.SqlServer.DBParam { ParamValue = ordeNO } }, { "Beforebalance", new HotelCloud.SqlServer.DBParam { ParamValue = dbMember.Rows[0]["balance"].ToString() } } }); if (row > 0) { //充值账户 row = RechargeCard.UpdateRechargeMemberBalance(db_RechargeOrder.Rows[0]["hotelweixinId"].ToString(), db_RechargeOrder.Rows[0]["userweixinId"].ToString(), Convert.ToDecimal(db_RechargeOrder.Rows[0]["Mprice"].ToString())); //三部曲完成提交 if (row > 0) { flag = true; scop.Complete(); } } } } } catch (Exception ex) { Logger.Instance.Error(ex.ToString()); } return(flag); }