Exemplo n.º 1
0
 public static string Empowers(string userlist, string relist)
 {
     try
     {
         BLL_UserBuyResources          bll       = new BLL_UserBuyResources();
         List <Model_UserBuyResources> listModel = new List <Model_UserBuyResources>();
         userlist = userlist.TrimEnd(',');
         relist   = relist.TrimEnd(',');
         string _dSql = "delete UserBuyResources where BuyType = 'NBSQ' and UserId in ('" + userlist.Replace(",", "','") + "') and book_id in ('" + relist.Replace(",", "','") + "');";
         foreach (string item in userlist.Split(','))
         {
             if (!string.IsNullOrEmpty(item))
             {
                 foreach (string itemR in relist.Split(','))
                 {
                     if (!string.IsNullOrEmpty(itemR))
                     {
                         if (new BLL_UserBuyResources().GetRecordCount("UserId='" + item + "' and Book_id='" + itemR + "'") > 0)
                         {
                         }
                         else
                         {
                             Model_UserBuyResources model = new Model_UserBuyResources();
                             model.UserBuyResources_ID = Guid.NewGuid().ToString();
                             model.UserId     = item;
                             model.Book_id    = itemR;
                             model.BuyType    = "NBSQ";//内部授权
                             model.CreateTime = DateTime.Now;
                             listModel.Add(model);
                         }
                     }
                 }
             }
         }
         if (listModel.Count > 0)
         {
             //Rc.Common.DBUtility.DbHelperSQL.Query(_dSql);
             if (bll.AddUserBuyResources(listModel))
             {
                 return("1");
             }
             else
             {
                 return("");
             }
         }
         else
         {
             return("1");
         }
     }
     catch (Exception ex)
     {
         return("2");
     }
 }
Exemplo n.º 2
0
 protected void btnBuy_Click(object sender, EventArgs e)
 {
     try
     {
         BLL_Bookshelves bll = new BLL_Bookshelves();
         DataTable       dt  = bll.GetList("ResourceFolder_Id='" + ResourceFolder_ID + "'").Tables[0];
         if (dt.Rows.Count > 0)
         {
             BookPrice = dt.Rows[0]["BookPrice"].ToString();
         }
         if (BookPrice == "0.00")
         {
             #region 用户购买资源表
             Model_UserBuyResources buyModel = new Model_UserBuyResources();
             buyModel.UserBuyResources_ID = Guid.NewGuid().ToString();
             buyModel.UserId     = FloginUser.UserId;
             buyModel.Book_id    = ResourceFolder_ID;
             buyModel.BookPrice  = 0;
             buyModel.BuyType    = UserOrder_PaytoolEnum.FREE.ToString();
             buyModel.CreateTime = DateTime.Now;
             buyModel.CreateUser = FloginUser.UserId;
             if (new BLL_UserBuyResources().Add(buyModel))
             {
                 new Rc.Cloud.BLL.BLL_clsAuth().AddLogFromBS(Request.Url.ToString(), string.Format("免费资源。购买资源成功,购买人:{0},资源标识:{1}"
                                                                                                   , FloginUser.UserId, ResourceFolder_ID));
                 ClientScript.RegisterStartupScript(this.GetType(), "save", "<script type='text/javascript'>layer.msg('购买成功',{icon:1,time:1000},function(){window.location.href=window.location;});</script>");
             }
             else
             {
                 ClientScript.RegisterStartupScript(this.GetType(), "save", "<script type='text/javascript'>layer.msg('购买失败',{icon:2,time:2000});</script>");
                 return;
             }
             #endregion
         }
         else
         {
             if (Type == "1")
             {
                 Response.Redirect("/student/Payment.aspx?orderType=2&rid=" + ResourceFolder_ID);
             }
             else
             {
                 Response.Redirect("/teacher/Payment.aspx?orderType=1&rid=" + ResourceFolder_ID);
             }
         }
     }
     catch (Exception)
     {
     }
 }
Exemplo n.º 3
0
        public bool Add(Model_UserBuyResources model)
        {
            StringBuilder builder = new StringBuilder();

            builder.Append("insert into UserBuyResources(");
            builder.Append("UserBuyResources_ID,UserId,Book_id,BookPrice,BuyType,CreateTime,CreateUser)");
            builder.Append(" values (");
            builder.Append("@UserBuyResources_ID,@UserId,@Book_id,@BookPrice,@BuyType,@CreateTime,@CreateUser)");
            SqlParameter[] cmdParms = new SqlParameter[] { new SqlParameter("@UserBuyResources_ID", SqlDbType.Char, 0x24), new SqlParameter("@UserId", SqlDbType.Char, 0x24), new SqlParameter("@Book_id", SqlDbType.Char, 0x24), new SqlParameter("@BookPrice", SqlDbType.Decimal, 5), new SqlParameter("@BuyType", SqlDbType.VarChar, 20), new SqlParameter("@CreateTime", SqlDbType.DateTime), new SqlParameter("@CreateUser", SqlDbType.Char, 0x24) };
            cmdParms[0].Value = model.UserBuyResources_ID;
            cmdParms[1].Value = model.UserId;
            cmdParms[2].Value = model.Book_id;
            cmdParms[3].Value = model.BookPrice;
            cmdParms[4].Value = model.BuyType;
            cmdParms[5].Value = model.CreateTime;
            cmdParms[6].Value = model.CreateUser;
            return(DbHelperSQL.ExecuteSql(builder.ToString(), cmdParms) > 0);
        }
Exemplo n.º 4
0
        public List <Model_UserBuyResources> DataTableToList(DataTable dt)
        {
            List <Model_UserBuyResources> list = new List <Model_UserBuyResources>();
            int count = dt.Rows.Count;

            if (count > 0)
            {
                for (int i = 0; i < count; i++)
                {
                    Model_UserBuyResources item = this.dal.DataRowToModel(dt.Rows[i]);
                    if (item != null)
                    {
                        list.Add(item);
                    }
                }
            }
            return(list);
        }
Exemplo n.º 5
0
        public bool Update(Model_UserBuyResources model)
        {
            StringBuilder builder = new StringBuilder();

            builder.Append("update UserBuyResources set ");
            builder.Append("UserId=@UserId,");
            builder.Append("Book_id=@Book_id,");
            builder.Append("BookPrice=@BookPrice,");
            builder.Append("BuyType=@BuyType,");
            builder.Append("CreateTime=@CreateTime,");
            builder.Append("CreateUser=@CreateUser");
            builder.Append(" where UserBuyResources_ID=@UserBuyResources_ID ");
            SqlParameter[] cmdParms = new SqlParameter[] { new SqlParameter("@UserId", SqlDbType.Char, 0x24), new SqlParameter("@Book_id", SqlDbType.Char, 0x24), new SqlParameter("@BookPrice", SqlDbType.Decimal, 5), new SqlParameter("@BuyType", SqlDbType.VarChar, 20), new SqlParameter("@CreateTime", SqlDbType.DateTime), new SqlParameter("@CreateUser", SqlDbType.Char, 0x24), new SqlParameter("@UserBuyResources_ID", SqlDbType.Char, 0x24) };
            cmdParms[0].Value = model.UserId;
            cmdParms[1].Value = model.Book_id;
            cmdParms[2].Value = model.BookPrice;
            cmdParms[3].Value = model.BuyType;
            cmdParms[4].Value = model.CreateTime;
            cmdParms[5].Value = model.CreateUser;
            cmdParms[6].Value = model.UserBuyResources_ID;
            return(DbHelperSQL.ExecuteSql(builder.ToString(), cmdParms) > 0);
        }
Exemplo n.º 6
0
        public bool UpdateAndAddUserBuyResources(Model_UserOrder modelUO, Model_UserBuyResources buyModel)
        {
            Dictionary <string, SqlParameter[]> dictionary = new Dictionary <string, SqlParameter[]>();
            StringBuilder builder = new StringBuilder();

            builder = new StringBuilder();
            builder.Append("update UserOrder set ");
            builder.Append("UserOrder_Paytool=@UserOrder_Paytool,");
            builder.Append("UsreOrder_Buyeremail=@UsreOrder_Buyeremail,");
            builder.Append("UserOrder_Status=@UserOrder_Status,");
            builder.Append("UserOrder_FinishTime=@UserOrder_FinishTime,");
            builder.Append("trade_no=@trade_no,");
            builder.Append("trade_status=@trade_status");
            builder.Append(" where UserOrder_Id=@UserOrder_Id ");
            SqlParameter[] parameterArray = new SqlParameter[] { new SqlParameter("@UserOrder_Paytool", SqlDbType.VarChar, 50), new SqlParameter("@UsreOrder_Buyeremail", SqlDbType.VarChar, 100), new SqlParameter("@UserOrder_Status", SqlDbType.Int, 4), new SqlParameter("@UserOrder_FinishTime", SqlDbType.DateTime), new SqlParameter("@trade_no", SqlDbType.NVarChar, 100), new SqlParameter("@trade_status", SqlDbType.NVarChar, 50), new SqlParameter("@UserOrder_Id", SqlDbType.Char, 0x24) };
            parameterArray[0].Value = modelUO.UserOrder_Paytool;
            parameterArray[1].Value = modelUO.UsreOrder_Buyeremail;
            parameterArray[2].Value = modelUO.UserOrder_Status;
            parameterArray[3].Value = modelUO.UserOrder_FinishTime;
            parameterArray[4].Value = modelUO.trade_no;
            parameterArray[5].Value = modelUO.trade_status;
            parameterArray[6].Value = modelUO.UserOrder_Id;
            dictionary.Add(builder.ToString(), parameterArray);
            builder = new StringBuilder();
            builder.Append("insert into UserBuyResources(");
            builder.Append("UserBuyResources_ID,UserId,Book_id,BookPrice,BuyType,CreateTime,CreateUser)");
            builder.Append(" values (");
            builder.Append("@UserBuyResources_ID,@UserId,@Book_id,@BookPrice,@BuyType,@CreateTime,@CreateUser)");
            SqlParameter[] parameterArray2 = new SqlParameter[] { new SqlParameter("@UserBuyResources_ID", SqlDbType.Char, 0x24), new SqlParameter("@UserId", SqlDbType.Char, 0x24), new SqlParameter("@Book_id", SqlDbType.Char, 0x24), new SqlParameter("@BookPrice", SqlDbType.Decimal, 5), new SqlParameter("@BuyType", SqlDbType.VarChar, 20), new SqlParameter("@CreateTime", SqlDbType.DateTime), new SqlParameter("@CreateUser", SqlDbType.Char, 0x24) };
            parameterArray2[0].Value = buyModel.UserBuyResources_ID;
            parameterArray2[1].Value = buyModel.UserId;
            parameterArray2[2].Value = buyModel.Book_id;
            parameterArray2[3].Value = buyModel.BookPrice;
            parameterArray2[4].Value = buyModel.BuyType;
            parameterArray2[5].Value = buyModel.CreateTime;
            parameterArray2[6].Value = buyModel.CreateUser;
            dictionary.Add(builder.ToString(), parameterArray2);
            return(DbHelperSQL.ExecuteSqlTran(dictionary) > 0);
        }
Exemplo n.º 7
0
        public Model_UserBuyResources DataRowToModel(DataRow row)
        {
            Model_UserBuyResources resources = new Model_UserBuyResources();

            if (row != null)
            {
                if (row["UserBuyResources_ID"] != null)
                {
                    resources.UserBuyResources_ID = row["UserBuyResources_ID"].ToString();
                }
                if (row["UserId"] != null)
                {
                    resources.UserId = row["UserId"].ToString();
                }
                if (row["Book_id"] != null)
                {
                    resources.Book_id = row["Book_id"].ToString();
                }
                if ((row["BookPrice"] != null) && (row["BookPrice"].ToString() != ""))
                {
                    resources.BookPrice = new decimal?(decimal.Parse(row["BookPrice"].ToString()));
                }
                if (row["BuyType"] != null)
                {
                    resources.BuyType = row["BuyType"].ToString();
                }
                if ((row["CreateTime"] != null) && (row["CreateTime"].ToString() != ""))
                {
                    resources.CreateTime = new DateTime?(DateTime.Parse(row["CreateTime"].ToString()));
                }
                if (row["CreateUser"] != null)
                {
                    resources.CreateUser = row["CreateUser"].ToString();
                }
            }
            return(resources);
        }
Exemplo n.º 8
0
 public bool UpdateAndAddUserBuyResources(Model_UserOrder model, Model_UserBuyResources buyModel)
 {
     return(this.dal.UpdateAndAddUserBuyResources(model, buyModel));
 }
Exemplo n.º 9
0
        protected void Page_Load(object sender, EventArgs e)
        {
            SortedDictionary <string, string> sPara = GetRequestPost();

            if (sPara.Count > 0)//判断是否有带返回参数
            {
                Notify aliNotify    = new Notify();
                bool   verifyResult = aliNotify.Verify(sPara, Request.Form["notify_id"], Request.Form["sign"]);

                if (verifyResult)//验证成功
                {
                    /////////////////////////////////////////////////////////////////////////////////////////////////////////////
                    //请在这里加上商户的业务逻辑程序代码


                    //——请根据您的业务逻辑来编写程序(以下代码仅作参考)——
                    //获取支付宝的通知返回参数,可参考技术文档中服务器异步通知参数列表

                    //商户订单号

                    string out_trade_no = Request.Form["out_trade_no"].Filter();

                    //支付宝交易号

                    string trade_no = Request.Form["trade_no"].Filter();

                    //交易状态
                    string trade_status = Request.Form["trade_status"].Filter();

                    //买家支付宝账号
                    string buyer_email = Request.Form["buyer_email"];

                    int orderStatus = 1;// (int)XHZ.Model.UOrderStatus.等待付款;
                    if (trade_status.ToUpper() == "TRADE_FINISHED")
                    {
                        //判断该笔订单是否在商户网站中已经做过处理
                        //如果没有做过处理,根据订单号(out_trade_no)在商户网站的订单系统中查到该笔订单的详细,并执行商户的业务程序
                        //如果有做过处理,不执行商户的业务程序

                        //注意:
                        //退款日期超过可退款期限后(如三个月可退款),支付宝系统发送该交易状态通知
                        orderStatus = (int)UOrderStatus.付款成功;
                    }
                    else if (trade_status.ToUpper() == "TRADE_SUCCESS")
                    {
                        //判断该笔订单是否在商户网站中已经做过处理
                        //如果没有做过处理,根据订单号(out_trade_no)在商户网站的订单系统中查到该笔订单的详细,并执行商户的业务程序
                        //如果有做过处理,不执行商户的业务程序

                        //注意:
                        //付款完成后,支付宝系统发送该交易状态通知
                        orderStatus = (int)UOrderStatus.付款成功;
                    }
                    else
                    {
                    }

                    //——请根据您的业务逻辑来编写程序(以上代码仅作参考)——

                    Rc.Web.Payment.Core.LogHandler.WriteLogForPay(out_trade_no, "付款成功", trade_no);

                    #region 付款成功 异步更新订单表 author:Ethan
                    Model_UserOrder model = new Model_UserOrder();
                    BLL_UserOrder   bll   = new BLL_UserOrder();
                    model = bll.GetModelByOrderNo(out_trade_no);

                    if (orderStatus == (int)UOrderStatus.付款成功 && model.UserOrder_Status == (int)UOrderStatus.待付款)
                    {
                        model.UserOrder_Paytool    = UserOrder_PaytoolEnum.ALIPAY.ToString();
                        model.UsreOrder_Buyeremail = buyer_email;
                        model.trade_no             = trade_no;
                        model.trade_status         = trade_status;
                        model.UserOrder_Status     = (int)UOrderStatus.完成;
                        model.UserOrder_FinishTime = DateTime.Now;

                        bool executeFlag = false;
                        if (new BLL_UserBuyResources().GetRecordCount(string.Format("UserId='{0}' and Book_id='{1}' ", model.UserId, model.Book_Id)) == 0)
                        {
                            #region 用户购买资源表
                            Model_UserBuyResources buyModel = new Model_UserBuyResources();
                            buyModel.UserBuyResources_ID = Guid.NewGuid().ToString();
                            buyModel.UserId     = model.UserId;
                            buyModel.Book_id    = model.Book_Id;
                            buyModel.BookPrice  = model.Book_Price;
                            buyModel.BuyType    = UserOrder_PaytoolEnum.ALIPAY.ToString();
                            buyModel.CreateTime = DateTime.Now;
                            buyModel.CreateUser = "******";
                            #endregion
                            executeFlag = bll.UpdateAndAddUserBuyResources(model, buyModel);
                        }
                        else
                        {
                            executeFlag = bll.Update(model);
                        }

                        if (executeFlag)
                        {
                            //try
                            //{
                            //    P_User userModel = new P_UserBLL().GetModel(model.user_id);
                            //    pfunction.SendSMS(userModel.moblie, "您的订单" + model.OrderNo + "已支付成功");
                            //}
                            //catch
                            //{

                            //}
                            //if (new U_OrdersHandleBLL().GetRecordCount("OrderId='" + model.OrderId + "' and OperateUser='******'") == 0)
                            //{
                            //    pfunction.InsertOrderHandle(model.OrderId, "您已" + XHZ.Common.EnumService.GetDescription<UOrderStatus>(orderStatus), "支付接口异步回调");
                            //}
                            new Rc.Cloud.BLL.BLL_clsAuth().AddLogFromBS(Request.Url.ToString(), string.Format("支付宝回调。购买资源成功,购买人:{0},资源标识:{1}"
                                                                                                              , model.UserId, model.Book_Id));
                            Response.Write("success");  //请不要修改或删除
                        }
                    }
                    #endregion

                    /////////////////////////////////////////////////////////////////////////////////////////////////////////////
                }
                else//验证失败
                {
                    Response.Write("fail");
                }
            }
            else
            {
                Response.Write("无通知参数");
            }
        }
Exemplo n.º 10
0
        protected void btnBePower_Click(object sender, EventArgs e)
        {
            BLL_UserBuyResources          bll       = new BLL_UserBuyResources();
            List <Model_UserBuyResources> listModel = new List <Model_UserBuyResources>();
            string _bid   = Request["bid"];
            string _IDs   = hidUserIDs.Value.TrimEnd(',');
            string _dSql  = "delete UserBuyResources where UserId in ('" + _IDs.Replace(",", "','") + "') and book_id ='" + _bid + "';";
            int    result = 0;

            foreach (string item in _IDs.Split(','))
            {
                if (!string.IsNullOrEmpty(item))
                {
                    Model_UserBuyResources model = new Model_UserBuyResources();
                    model.UserBuyResources_ID = Guid.NewGuid().ToString();
                    model.UserId     = item;
                    model.Book_id    = _bid;
                    model.BuyType    = UserOrder_PaytoolEnum.NBSQ.ToString();//内部授权
                    model.CreateTime = DateTime.Now;
                    model.CreateUser = loginUser.SysUser_ID;
                    listModel.Add(model);
                }
            }
            try
            {
                Rc.Common.DBUtility.DbHelperSQL.ExecuteSql(_dSql);
                foreach (var item in listModel)
                {
                    bool flag = bll.Add(item);
                    if (flag)
                    {
                        new Rc.Cloud.BLL.BLL_clsAuth().AddLogFromBS(Module_Id, string.Format("给老师授权成功,操作人:{0},资源标识:{1},老师标识:{2}"
                                                                                             , loginUser.SysUser_ID, item.Book_id, item.UserId));
                    }
                    else
                    {
                        new Rc.Cloud.BLL.BLL_clsAuth().AddLogErrorFromBS(Module_Id, string.Format("给老师授权失败,操作人:{0},资源标识:{1},老师标识:{2}"
                                                                                                  , loginUser.SysUser_ID, item.Book_id, item.UserId));
                    }
                    result += flag == true ? 1 : 0;
                }
                if (result > 0)
                {
                    ShowMsg(true, "操作成功!");
                }
                else
                {
                    ShowMsg(false, "操作失败!");
                }
            }
            catch (Exception ex)
            {
                //记录错误日志
                new Rc.Cloud.BLL.BLL_clsAuth().AddLogErrorFromBS(Module_Id, string.Format("给老师授权失败,操作人:{0},类:{1},方法{2},错误信息:{3}"
                                                                                          , loginUser.SysUser_ID
                                                                                          , ex.TargetSite.DeclaringType.ToString()
                                                                                          , ex.TargetSite.Name.ToString()
                                                                                          , ex.Message));
                ShowMsg(false, "操作失败!");
                return;
            }
        }
Exemplo n.º 11
0
        public override void ProcessNotify()
        {
            WxPayData notifyData = GetNotifyData();

            //检查支付结果中transaction_id是否存在
            if (!notifyData.IsSet("transaction_id"))
            {
                //若transaction_id不存在,则立即返回结果给微信支付后台
                WxPayData res = new WxPayData();
                res.SetValue("return_code", "FAIL");
                res.SetValue("return_msg", "支付结果中微信订单号不存在");
                Log.Error(this.GetType().ToString(), "The Pay result is error : " + res.ToXml());
                page.Response.Write(res.ToXml());
                page.Response.End();
            }

            string transaction_id = notifyData.GetValue("transaction_id").ToString();

            //查询订单,判断订单真实性
            if (!QueryOrder(transaction_id))
            {
                //若订单查询失败,则立即返回结果给微信支付后台
                WxPayData res = new WxPayData();
                res.SetValue("return_code", "FAIL");
                res.SetValue("return_msg", "订单查询失败");
                Log.Error(this.GetType().ToString(), "Order query failure : " + res.ToXml());
                page.Response.Write(res.ToXml());
                page.Response.End();
            }
            //查询订单成功
            else
            {
                Log.Info(this.GetType().ToString(), "订单支付成功,异步回调");

                #region 支付成功,异步更新订单表2016-06-30TS
                Model_UserOrder model = new Model_UserOrder();
                BLL_UserOrder   bll   = new BLL_UserOrder();
                model = bll.GetModelByOrderNo(notifyData.GetValue("out_trade_no").ToString());

                if (model.UserOrder_Status == (int)UOrderStatus.待付款 || string.IsNullOrEmpty(model.trade_no) || string.IsNullOrEmpty(model.trade_status))
                {
                    model.UserOrder_Paytool    = UserOrder_PaytoolEnum.WXPAY.ToString();
                    model.UsreOrder_Buyeremail = notifyData.GetValue("openid").ToString();
                    model.trade_no             = notifyData.GetValue("transaction_id").ToString();
                    model.trade_status         = notifyData.GetValue("return_code").ToString();
                    model.UserOrder_Status     = (int)UOrderStatus.完成;
                    model.UserOrder_FinishTime = DateTime.Now;

                    bool executeFlag = false;
                    if (new BLL_UserBuyResources().GetRecordCount(string.Format("UserId='{0}' and Book_id='{1}' ", model.UserId, model.Book_Id)) == 0)
                    {
                        #region 用户购买资源表
                        Model_UserBuyResources buyModel = new Model_UserBuyResources();
                        buyModel.UserBuyResources_ID = Guid.NewGuid().ToString();
                        buyModel.UserId     = model.UserId;
                        buyModel.Book_id    = model.Book_Id;
                        buyModel.BookPrice  = model.Book_Price;
                        buyModel.BuyType    = UserOrder_PaytoolEnum.WXPAY.ToString();
                        buyModel.CreateTime = DateTime.Now;
                        buyModel.CreateUser = "******";
                        #endregion
                        executeFlag = bll.UpdateAndAddUserBuyResources(model, buyModel);
                    }
                    else
                    {
                        executeFlag = bll.Update(model);
                    }
                    if (executeFlag)
                    {
                        new Rc.Cloud.BLL.BLL_clsAuth().AddLogFromBS(page.Request.Url.ToString(), string.Format("微信回调。购买资源成功,购买人:{0},资源标识:{1}"
                                                                                                               , model.UserId, model.Book_Id));
                    }
                }
                #endregion

                WxPayData res = new WxPayData();
                res.SetValue("return_code", "SUCCESS");
                res.SetValue("return_msg", "OK");

                page.Response.Write(res.ToXml());
                page.Response.End();
            }
        }
Exemplo n.º 12
0
 public bool Add(Model_UserBuyResources model)
 {
     return(this.dal.Add(model));
 }
Exemplo n.º 13
0
 public bool Update(Model_UserBuyResources model)
 {
     return(this.dal.Update(model));
 }