Esempio n. 1
0
 public MemberOrderEntity CreateEntityByOrderID(string orderid, ref string msg)
 {
     try
     {
         MemberOrderEntity orderEntity = new MemberOrderEntity();
         OrderDAL          orderDal    = new OrderDAL();
         var order = MemberOrderDAL.GetMemberOrder(orderid);
         if (order == null)
         {
             return(null);
         }
         orderEntity.Number             = order.Number;
         orderEntity.OrderDate          = order.OrderDate;
         orderEntity.OrderID            = order.OrderId;
         orderEntity.TotalMoney         = Convert.ToDouble(order.TotalMoney);
         orderEntity.TotalPv            = Convert.ToDouble(order.TotalPv);
         orderEntity.TotalMoneyReturned = Convert.ToDouble(order.TotalMoneyReturned);
         orderEntity.TotalPvReturned    = Convert.ToDouble(order.TotalPvReturned);
         List <MemberOrderDetailsEntity> details = orderDal.GetMemberOrderDetailsEntity(orderid);
         orderEntity.Details = details;
         return(orderEntity);
     }
     catch (Exception ex)
     {
         msg = "生成错误:" + ex.Message;
         return(null);
     }
 }
Esempio n. 2
0
        /// <summary>
        /// 删除复消单
        /// </summary>
        public string DelOredrAgain(string orderId, double totalPv, string number, int except, string storeId)
        {
            double           totalMoney = AddOrderDataDAL.GetTotalMoneyByOrderId(orderId);
            MemberOrderModel order      = MemberOrderDAL.GetMemberOrder(orderId);
            string           info       = null;

            using (SqlConnection conn = new SqlConnection(DAL.DBHelper.connString))
            {
                conn.Open();
                SqlTransaction tran = conn.BeginTransaction();
                try
                {
                    BLL.CommonClass.ChangeLogs cl_h_info = new BLL.CommonClass.ChangeLogs("memberorder", "orderid"); //实例日志类
                    cl_h_info.AddRecordtran(tran, orderId);                                                          //添加日志,修改前记录原来数据

                    //如果该订单不存在
                    if (!BrowsememberordersDAL.CheckOrderIdExists(orderId))
                    {
                        info = BLL.Translation.Translate("001661", "抱歉,该订单不存在!");
                        tran.Rollback();
                        conn.Close();
                        return(info);
                    }

                    if (order.DefrayState == 1)
                    {
                        if (totalMoney > 0)
                        {
                            D_AccountBLL.AddAccount(storeId, totalMoney, D_AccountSftype.StoreType, D_AccountKmtype.OrderDelete, DirectionEnum.AccountsIncreased, "会员【" + number + "】报单删除现金扣添加,订单号为【" + orderId + "】", tran);
                            if (order.DefrayType == 2)
                            {
                                IsElecPay(tran, order);
                                D_AccountBLL.AddAccount(order.Number, Convert.ToDouble(order.TotalMoney), D_AccountSftype.MemberType, D_AccountKmtype.OrderUpdateIn, DirectionEnum.AccountsIncreased, "会员【" + order.Number + "】报单删除现金扣添加,订单号为【" + order.OrderId + "】", tran);
                                D_AccountBLL.AddAccount(order.StoreId, Convert.ToDouble(order.TotalMoney), D_AccountSftype.StoreType, D_AccountKmtype.OrderUpdateOut, DirectionEnum.AccountReduced, "会员【" + order.Number + "】报单删除现金添加扣,订单号为【" + order.OrderId + "】", tran, true);
                            }
                        }

                        int result = addOrderDataDAL.Js_delfuxiao(number, totalPv, except, 1, tran);
                    }

                    //删除复消单
                    addOrderDataDAL.Del_Horder(tran, orderId, storeId, CommonDataBLL.OperateBh, CommonDataBLL.OperateIP);

                    cl_h_info.DeletedIntoLogstran(tran, BLL.CommonClass.ChangeCategory.store1, orderId, BLL.CommonClass.ENUM_USERTYPE.objecttype5);//插入日志
                    tran.Commit();
                }
                catch
                {
                    info = BLL.Translation.Translate("000417", "删除失败!");
                    tran.Rollback();
                }
                finally
                {
                    conn.Close();
                    conn.Dispose();
                }
            }
            return(info);
        }
Esempio n. 3
0
 //查询报单是否存在
 public static bool GetIsExistOrder(string orderid)
 {
     if (MemberOrderDAL.GetOrderCount(orderid) == 0)
     {
         return(false);
     }
     return(true);
 }
Esempio n. 4
0
    /// <summary>
    /// 购买矿机
    /// </summary>
    /// <param name="chosenum"></param>
    /// <returns></returns>
    public void GetRegSendPost()
    {
        if (Session["Member"] == null)
        {
            ClientScript.RegisterStartupScript(this.GetType(), "", "<script>showsuc('未登录!');</script>", false);
            return;  //未登录
        }
        string number = Session["Member"].ToString();

        int re = 0;
        ///获取usdt账户
        int    lv      = 0;
        string orderid = hidetp.Value;
        double neede   = 0;
        //檢測是否有未支付的單子 如果有則走未支付的訂單
        DataTable dt = DBHelper.ExecuteDataTable("select top 1  OrderID, TotalMoney   from  memberorder where  Number='" + number + "' and  DefrayState=1 and isactive=0 and ordertype  in (22,23,24) and  orderid='" + orderid + "' order by ID  ");

        double ttm = 0;
        string st  = " ";

        if (dt != null && dt.Rows.Count > 0)
        {
            double  eprice = Convert.ToDouble(DBHelper.ExecuteScalar("select  coinnewprice  from CoinPlant  where CoinIndex='CoinE'  "));
            DataRow dr     = dt.Rows[0];
            orderid = dr["OrderID"].ToString();
            ttm     = Convert.ToDouble(dr["TotalMoney"]);
            neede   = ((ttm * 0.05) / eprice);


            ///
            int ree = MemberOrderDAL.payOrderEcoin(number, orderid, neede, "会员激活矿机支付E币" + neede.ToString("0.0000"));

            if (ree == -1)
            {
                ClientScript.RegisterStartupScript(this.GetType(), "", "<script>showsuc('余额不足!');</script>", false);
                return;
            }
            else if (ree == 1)
            {
                ClientScript.RegisterStartupScript(this.GetType(), "", "<script>showsuc('激活成功!');</script>", false);
                Bind();
                return;
            }
            else
            {
                ClientScript.RegisterStartupScript(this.GetType(), "", "<script>showsuc('激活失败!');</script>", false);
                return;
            }
        }
        else
        {
            ClientScript.RegisterStartupScript(this.GetType(), "", "<script>showsuc('请选择需要激活矿机!');</script>", false);
            return;
        }
    }
Esempio n. 5
0
    protected void linkbtnOK_Click(object sender, CommandEventArgs e)
    {
        if (MemberOrderDAL.Getvalidteiscanpay(e.CommandArgument.ToString(), Session["Member"].ToString()))//限制订单必须有订货所属店铺推荐人协助人支付)
        {
            ClientScript.RegisterStartupScript(this.GetType(), "", "<script> alert('该订单不属于您的协助或推荐报单,不能完成支付!'); window.location.href='../Logout.aspx'; </script>");

            return;
        }
        ScriptManager.RegisterStartupScript(this, GetType(), "mag", "var formobj=document.createElement('form');"
                                            + "formobj.action='../payserver/chosepay.aspx?blif=" + EncryKey.GetEncryptstr(e.CommandArgument.ToString(), 1, 1) + "';" +
                                            "formobj.method='post';formobj.target='_blank';document.body.appendChild(formobj); formobj.submit();", true);

        //Response.Redirect("chosepay.aspx?rd=" + e.CommandArgument.ToString() + "&rt=1");
    }
Esempio n. 6
0
 public void BindDate()
 {
     if (Request.QueryString["orderid"] != null)
     {
         string           orderid = Request.QueryString["orderid"];
         MemberOrderModel mo      = MemberOrderDAL.GetMemberOrder(orderid);
         MemberInfoModel  mi      = MemberInfoDAL.getMemberInfo(mo.Number);
         lblxjnumber.Text = mo.Number;
         lblname.Text     = mi.PetName;
         lblphonenum.Text = mi.MobileTele;
         //txtplacement.Text = mi.Placement;
         hiddirect.Value  = mi.Direct;
         txtDirect.Text   = mi.Direct;
         hidorderid.Value = orderid;
         decimal nowpc = Common.GetnowPrice();
         decimal jf    = mo.TotalMoney / nowpc * 0.8m;
         lblkcjb.Text = jf.ToString("0.0000");
         decimal bdb = mo.TotalMoney * 0.2m;
         lblttmoney.Text = bdb.ToString("0.00");
     }
 }
Esempio n. 7
0
 public static System.Data.DataTable GetBankName(int countryCode)
 {
     return(MemberOrderDAL.GetBankName(countryCode));
 }
Esempio n. 8
0
 /// <summary>
 /// 是否足够支付订单
 /// </summary>
 /// <param name="OrderID">订单号</param>
 /// <param name="OrderID">店编号</param>
 /// <returns></returns>
 public static bool IsAdequate(string OrderID, string storeId)
 {
     return(MemberOrderDAL.IsAdequate(OrderID, storeId));
 }
Esempio n. 9
0
 /// <summary>
 /// 确认支付
 /// </summary>
 /// <param name="PayMentMoney">金额</param>
 /// <param name="ShouDateTime">收款日期</param>
 /// <param name="OrderID">店编号</param>
 /// <returns></returns>
 public static bool Batch(double PayMentMoney, DateTime ShouDateTime, string OrderID)
 {
     return(MemberOrderDAL.Batch(PayMentMoney, ShouDateTime, OrderID));
 }
Esempio n. 10
0
 public static DataSet GetAllList(string productid)
 {
     return(MemberOrderDAL.GetAllList(productid));
 }
Esempio n. 11
0
 /// <summary>
 /// 获取会员报单信息
 /// </summary>
 /// <param name="orderId">订单编号</param>
 /// <returns></returns>
 public static Model.MemberOrderModel GetMemberOrder(string orderId)
 {
     return(MemberOrderDAL.GetMemberOrder(orderId));
 }
Esempio n. 12
0
    /// <summary>
    /// 购买矿机
    /// </summary>
    /// <param name="chosenum"></param>
    /// <returns></returns>
    public void GetRegSendPost()
    {
        int chosenum = Convert.ToInt32(hidetp.Value);

        if (Session["Member"] == null)
        {
            ClientScript.RegisterStartupScript(this.GetType(), "", "<script>showsuc('未登录!');</script>", false);
            return;  //未登录
        }
        string number = Session["Member"].ToString();

        int cc = Convert.ToInt32(DBHelper.ExecuteScalar("select  count(0)  from memberorder where  DefrayState=1   and  isactive=0 and ordertype<>0  and  number='" + number + "' "));

        if (cc > 0)
        {
            ClientScript.RegisterStartupScript(this.GetType(), "", "<script>showsuc('您有未激活的矿机,请激活后再升级!'); setTimeout(function(){ window.location.href='orderlist.aspx'},2000);  </script>", false);
            return;
        }

        int re = 0;
        ///获取usdt账户
        int lv = 0;

        //檢測是否有未支付的單子 如果有則走未支付的訂單

        double ddmm    = 0;
        string orderid = "";

        //DataTable ddt = DBHelper.ExecuteDataTable("select  top 1 OrderID,TotalMoney from memberorder where  DefrayState=0 order by id  ");
        //if (ddt != null && ddt.Rows.Count > 0)
        //{
        //    DataRow dr = ddt.Rows[0];
        //    ddmm = Convert.ToDouble(dr["TotalMoney"]);
        //    orderid =  dr["orderid"].ToString();



        //    return;
        //}

        //清除未支付订单
        DBHelper.ExecuteNonQuery(@" insert  into   memberorderdel(id,[Number],[OrderID],[StoreID],[TotalMoney]
           ,[TotalPv],[CarryMoney],[OrderExpectNum],[PayExpectNum]
           ,[IsAgain],[OrderDate],[Error],[Remark],[DefrayState],[Consignee]
           ,[CCPCCode],[ConCity],[ConAddress]
           ,[ConZipCode],[ConTelphone]
           ,[ConMobilPhone],[ConPost]
           ,[DefrayType],[PayMoney]
           ,[PayCurrency],[StandardCurrency]
           ,[StandardCurrencyMoney],[OperateIP]
           ,[OperateNum],[RemittancesID],[ElectronicAccountID],[ordertype]
           ,[IsReceivables],[PayMentMoney],[ReceivablesDate],[EnoughProductMoney]
           ,[LackProductMoney],[IsReturn],[SendType],[SendWay],[TotalMoneyReturned]
           ,[TotalPvReturned],[OrderStatus],[TotalMoneyReturning],[TotalPvReturning]
           ,[OrderStatus_NR],[Isjjff],[trackingnum],[InvestJB]
           ,[PriceJB],[isSend],[xjpay],[xfpay],[bdpay],[ISSettle])
 select id,[Number],[OrderID],[StoreID],[TotalMoney]
           ,[TotalPv],[CarryMoney],[OrderExpectNum],[PayExpectNum]
           ,[IsAgain],[OrderDate],[Error],[Remark],[DefrayState],[Consignee]
           ,[CCPCCode],[ConCity],[ConAddress]
           ,[ConZipCode],[ConTelphone]
           ,[ConMobilPhone],[ConPost]
           ,[DefrayType],[PayMoney]
           ,[PayCurrency],[StandardCurrency]
           ,[StandardCurrencyMoney],[OperateIP]
           ,[OperateNum],[RemittancesID],[ElectronicAccountID],[ordertype]
           ,[IsReceivables],[PayMentMoney],[ReceivablesDate],[EnoughProductMoney]
           ,[LackProductMoney],[IsReturn],[SendType],[SendWay],[TotalMoneyReturned]
           ,[TotalPvReturned],[OrderStatus],[TotalMoneyReturning],[TotalPvReturning]
           ,[OrderStatus_NR],[Isjjff],[trackingnum],[InvestJB]
           ,[PriceJB],[isSend],[xjpay],[xfpay],[bdpay],[ISSettle]
 from MemberOrder where DefrayState = 0
 and number ='" + number + "'   ");
        //删除未支付的订单
        DBHelper.ExecuteNonQuery("delete  from   memberorder where  DefrayState=0 and number='" + number + "'   ");


        DataTable dt_one = DAL.DBHelper.ExecuteDataTable("select LevelInt from memberinfo where Number='" + number + "'");

        if (dt_one.Rows != null && dt_one.Rows.Count > 0)
        {
            lv = Convert.ToInt32(dt_one.Rows[0]["LevelInt"]);//获取账户等级
        }
        double zhye = 0;
        int    jd   = Common.GetcurJieDuan();//获取阶段状态

        if ((lv == 1 || (lv == 0 && chosenum > 1)) && jd == 1)
        {
            zhye = CommandAPI.GetActMoney();
        }
        if (chosenum < 0 || chosenum > 8 || lv > chosenum)
        {
            ClientScript.RegisterStartupScript(this.GetType(), "", "<script>showsuc('请选择矿机!');</script>", false);
            return;
        } //选择购买的矿机

        ConfigModel cm        = ConfigDAL.GetConfig();
        double      ttmoney   = 0;
        double      ttpv      = 0;
        int         ordertype = 22; // 0 第一次购买 1 补差升级
        int         isagain   = 0;
        double      yymoney   = 0;

        //   int ispay = 0; ///支付状态
        if (lv == 0)
        {
            ordertype = 22; //抢购20u
        }
        if (lv == 1 || (lv == 0 && chosenum > 1))
        {
            ordertype = 23; //购买
        }
        if (lv == 2)
        {
            yymoney = cm.Para2;
        }
        if (lv == 3)
        {
            yymoney = cm.Para3;
        }
        if (lv == 4)
        {
            yymoney = cm.Para4;
        }
        if (lv == 5)
        {
            yymoney = cm.Para5;
        }
        if (lv == 6)
        {
            yymoney = cm.Para6;
        }
        if (lv == 7)
        {
            yymoney = cm.Para7;
        }
        if (lv == 7)
        {
            ordertype = 25;           //复投
        }
        if (chosenum == 1)
        {
            ttmoney = cm.Para1; ttpv = 0;
        }                                                   //20u 不计算业绩
        if (chosenum == 2)
        {
            ttmoney = cm.Para2 - yymoney; ttpv = cm.Para2 - yymoney;
        }
        if (chosenum == 3)
        {
            ttmoney = cm.Para3 - yymoney; ttpv = cm.Para3 - yymoney;
        }
        if (chosenum == 4)
        {
            ttmoney = cm.Para4 - yymoney; ttpv = cm.Para4 - yymoney;
        }
        if (chosenum == 5)
        {
            ttmoney = cm.Para5 - yymoney; ttpv = cm.Para5 - yymoney;
        }
        if (chosenum == 6)
        {
            ttmoney = cm.Para6 - yymoney; ttpv = cm.Para6 - yymoney;
        }
        if (chosenum == 7)
        {
            ttmoney = cm.Para7 - yymoney; ttpv = cm.Para7 - yymoney;
        }
        //if (chosenum == 8) { ttmoney = cm.Para28 - yymoney; ttpv = cm.Para28 - yymoney; }
        if (yymoney > 0)
        {
            isagain = 1; ordertype = 24;
        }                                                //升级

        DataTable dtmb = DBHelper.ExecuteDataTable("select pointAin-pointAout  as  ablc,pointbin-pointbout  as  bblc,pointcin-pointcout  as  cblc,pointdin-pointdout  as  dblc,pointein-pointeout  as  eblc  from memberinfo where number='" + number + "'");
        DataTable conp = DBHelper.ExecuteDataTable("select CoinIndex ,coinnewprice  from CoinPlant  order by id ");
        double    ablc = 0; double bblc = 0; double cblc = 0; double dblc = 0; double eblc = 0;
        double    cap = 0; double cbp = 0; double ccp = 0; double cdp = 0; double cep = 0;

        if (dtmb != null && dtmb.Rows.Count > 0)
        {
            DataRow dr = dtmb.Rows[0];
            ablc = Convert.ToDouble(dr["ablc"]);
            bblc = Convert.ToDouble(dr["bblc"]);
            cblc = Convert.ToDouble(dr["cblc"]);
            dblc = Convert.ToDouble(dr["dblc"]);
            eblc = Convert.ToDouble(dr["eblc"]);
        }
        else
        {
            ClientScript.RegisterStartupScript(this.GetType(), "", "<script>showsuc('账户余额不足!');</script>", false);
            return;
        }
        if (conp != null && conp.Rows.Count > 0)
        {
            foreach (DataRow item in conp.Rows)
            {
                string s = item["CoinIndex"].ToString();
                if (s == "CoinA")
                {
                    cap = Convert.ToDouble(item["coinnewprice"]);
                }
                if (s == "CoinB")
                {
                    cbp = Convert.ToDouble(item["coinnewprice"]);
                }
                if (s == "CoinC")
                {
                    ccp = Convert.ToDouble(item["coinnewprice"]);
                }
                if (s == "CoinD")
                {
                    cdp = Convert.ToDouble(item["coinnewprice"]);
                }
                if (s == "CoinE")
                {
                    cep = Convert.ToDouble(item["coinnewprice"]);
                }
            }
        }
        else
        {
            ClientScript.RegisterStartupScript(this.GetType(), "", "<script>showsuc('账户余额不足!');</script>", false);
            return;
        }


        double aneed = 0;
        double bneed = 0;
        double cneed = 0;
        double eneed = 0;

        if (lv > 0)
        {
            if (jd == 1)
            {
                if (zhye < ttmoney)
                {
                    //ClientScript.RegisterStartupScript(this.GetType(), "", "<script>showsuc('账户余额不足!');</script>", false);
                    //return;
                }//余额不足
                else if (jd == 2 || jd == 3)
                {
                    aneed = ttmoney / cap;
                    if (aneed > ablc)
                    {
                        ClientScript.RegisterStartupScript(this.GetType(), "", "<script>showsuc('账户余额不足!');</script>", false);
                        return;
                    }
                    ; //余额不足
                }
                else if (jd == 4 || jd == 5)
                {
                    aneed = (ttmoney * 0.5) / cap;
                    bneed = (ttmoney * 0.5) / cbp;
                    if (aneed > ablc || bneed > bblc)
                    {
                        ClientScript.RegisterStartupScript(this.GetType(), "", "<script>showsuc('账户余额不足!');</script>", false);
                        return;
                    }//余额不足
                }
                else if (jd == 6 || jd == 7)
                {
                    aneed = (ttmoney * 0.2) / cap;
                    bneed = (ttmoney * 0.3) / cbp;
                    cneed = (ttmoney * 0.5) / ccp;
                    if (aneed > ablc || bneed > bblc || cneed > cblc)
                    {
                        ClientScript.RegisterStartupScript(this.GetType(), "", "<script>  showsuc('账户余额不足!');</script>", false);
                        return;
                    }//余额不足
                }
            }

            if (jd > 0 && chosenum > 1) ///  如果是20u以上 则需要额外支付 5% 的E
            {
                eneed = (ttmoney * 0.05) / cep;
                //if (eneed > eblc)
                //{
                //    ClientScript.RegisterStartupScript(this.GetType(), "", "<script>showsuc('火星币余额不足,请先去抢购兑换!');</script>", false);
                //    return;
                //}
                //余额不足

                Session["Eneed"] = eneed;
            }
        }

        RegistermemberBLL registermemberBLL = new RegistermemberBLL();

        orderid = registermemberBLL.GetOrderInfo("add", null);
        int maxexpt = ConfigDAL.GetMaxExpectNum();

        Boolean flag = new AddOrderDataDAL().AddOrderInfo(number, orderid, maxexpt, isagain, ttmoney, ttpv, ordertype);

        Session["choselv"] = chosenum;   //保存当前选中级别
        if (flag)                        //插入订单成功 开始支付
        {
            if (jd == 1 && chosenum > 1) //说明是第一阶段的所有购买都 必须使用USDT买
            {
                Session["orderid"] = orderid;
                string postf = CommandAPI.GetFunction(orderid, ttmoney.ToString(), "recast.aspx", RadioButtonList1.SelectedValue);
                ClientScript.RegisterStartupScript(this.GetType(), "", postf, false);
                return;
            }

            else
            {
                //本地支付开始
                int r = MemberOrderDAL.PayOrder(number, orderid, aneed, bneed, cneed, eneed, chosenum, "使用本地币种账户支付");
                if (r == 1)
                {
                    //销毁
                    if (aneed > 0)
                    {
                        CommandAPI.Destruction("A", aneed);
                    }
                    if (bneed > 0)
                    {
                        CommandAPI.Destruction("B", bneed);
                    }
                    if (cneed > 0)
                    {
                        CommandAPI.Destruction("C", cneed);
                    }
                    // if (eneed > 0) CommandAPI.Destruction("E", eneed);
                    if (eneed > 0)
                    {
                        int ee = MemberOrderDAL.payOrderEcoin(number, orderid, eneed, "E币支付,激活成功");
                        if (ee == 1)
                        {
                            ClientScript.RegisterStartupScript(this.GetType(), "", "<script>showsuc('购买矿机激活成功!');</script>", false);
                        }
                        else
                        {
                            ClientScript.RegisterStartupScript(this.GetType(), "", "<script>showsuc('支付成功,请使用E币激活矿机!'); setTimeout(function(){ window.location.href='orderlist.aspx'},3000); </script>", false);
                        }
                    }


                    ClientScript.RegisterStartupScript(this.GetType(), "", "<script>showsuc('购买成功!');</script>", false);
                    return;
                }
                else
                {
                    ClientScript.RegisterStartupScript(this.GetType(), "", "<script>showsuc('购买失败!');</script>", false);
                    return;
                }
            }
        }
    }
Esempio n. 13
0
        /// <summary>
        /// 审核支付报单
        /// </summary>
        /// <param name="orderid"> 报单编号 </param>
        /// <returns>是否审核成功</returns>
        public static string AuditingOrder(string orderid)
        {
            string error = "";                                            //返回错误信息

            MemberOrderModel mo = MemberOrderDAL.GetMemberOrder(orderid); //获取报单信息

            //判断报单是否支付
            if (mo.DefrayState != 0)
            {
                return("报单不可重复确认!");
            }

            //获得店铺不足货时可以报单的金额
            if (mo.DefrayType == 2)
            {
                double emoney = new AddOrderDataDAL().HaveMoney(mo.ElectronicaccountId);
                if (Convert.ToDouble(mo.TotalMoney) > emoney)
                {
                    return("电子账户余额不足,不能确认!");
                }
            }

            //更改--报单信息
            mo.RemittancesId = MYDateTime.ToYYMMDDHHmmssString();
            mo.DefrayState   = 1;
            mo.PayExpect     = CommonDataBLL.getMaxqishu();

            List <MemberDetailsModel> list = ViewFuXiaoBLL.GetDetails(mo.OrderId);//获取订单明细

            using (SqlConnection conn = new SqlConnection(DBHelper.connString))
            {
                conn.Open();
                SqlTransaction tran = conn.BeginTransaction();
                try
                {
                    //更新会员订单信息
                    CommonDataBLL.ConfirmMembersOrder(tran, mo.OrderId, mo.PayExpect);

                    //更新店铺库存
                    foreach (MemberDetailsModel memberDetailsModel in list)
                    {//循环根据订单明细跟新库存
                        int result = ViewFuXiaoBLL.UptStock(tran, memberDetailsModel.StoreId, memberDetailsModel.ProductId, memberDetailsModel.Quantity, memberDetailsModel.NotEnoughProduct);

                        //如果该店铺无盖商品记录,则在店库存表中加记录
                        if (result <= 0)
                        {
                            new BrowseMemberOrdersBLL().updateStore2(memberDetailsModel, tran);
                        }
                    }

                    //更新店铺报单款
                    new AddOrderDataDAL().updateStore3(mo.StoreId, tran, Convert.ToDouble(mo.TotalMoney));

                    if (mo.DefrayType == 2)
                    {
                        //更新电子账户余额
                        AddOrderDataDAL.UpdateECTPay(tran, mo.ElectronicaccountId, mo.TotalMoney);

                        //更新店铺汇款
                        new AddOrderDataDAL().Add_Remittances(tran, Convert.ToDouble(mo.TotalMoney), mo.StoreId);

                        //插入汇款信息
                        new AddOrderDataDAL().AddDataTORemittances(tran, mo);
                    }

                    //更新会员业绩
                    new AddOrderDataDAL().Js_addfuxiao(mo.Number, Convert.ToDouble(mo.TotalPv), mo.PayExpect, mo.DefrayType, tran);//添加网络业绩

                    //插入订货单
                    AddOrderGoods(list, tran, mo);

                    //提交事务
                    tran.Commit();
                }
                catch
                {
                    error = "确认失败!";
                    tran.Rollback();
                }
                finally
                {
                    conn.Close();
                }
            }

            return(error);
        }
Esempio n. 14
0
        /// <summary>
        /// 删除会员复销信息
        /// </summary>
        /// <param name="strId">报单编号</param>
        /// <returns></returns>
        public string DelMembersDeclaration(string orderId, double totalPv, string number, int except, string storeId, double lackproductmoney)
        {
            string           info  = null;
            MemberOrderModel order = MemberOrderDAL.GetMemberOrder(orderId);

            using (SqlConnection conn = new SqlConnection(DAL.DBHelper.connString))
            {
                conn.Open();
                SqlTransaction tran = conn.BeginTransaction();

                #region 处理组合商品库存

                /*
                 * List<MemberDetailsModel> groupItemList2 = new AddOrderBLL().GetDetails(orderId);
                 * List<OrderProduct3> oldSmallItem = new List<OrderProduct3>();
                 * for (int i = 0; i < groupItemList2.Count; i++)
                 * {
                 *  if (groupItemList2[i].IsGroupItem != "")
                 *  {
                 *      oldSmallItem = new AddMemberInfomDAL().GetSamllItemList(groupItemList2[i].ProductId.ToString());
                 *      for (int j = 0; j < oldSmallItem.Count; j++)
                 *      {
                 *          int hasOnly = new AddOrderDataDAL().SmallItemIsOnlyInGroup(oldSmallItem[j].Id, orderId);
                 *          if (hasOnly <= 0)
                 *          {
                 *              oldSmallItem[j].Count *= groupItemList2[i].Quantity;
                 *              int never = new AddOrderDataDAL().updateStore10(storeId, oldSmallItem[j], tran);
                 *              if (never <= 0)
                 *              {
                 *                  tran.Rollback();
                 *                  conn.Close();
                 *                  conn.Dispose();
                 *                  info = BLL.Translation.Translate("001730", "抱歉!系统异常!");
                 *                  return info;
                 *              }
                 *          }
                 *
                 *      }
                 *  }
                 * }*/

                #endregion

                //如果该订单不存在
                if (!BrowsememberordersDAL.CheckOrderIdExists(tran, orderId))
                {
                    info = BLL.Translation.Translate("001661", "抱歉,该订单不存在!");
                    tran.Rollback();
                    conn.Close();
                    conn.Dispose();
                    return(info);
                }

                //删除复消单
                if (order.DefrayState == 1)
                {
                    if (lackproductmoney > 0)
                    {
                        D_AccountBLL.AddAccount(storeId, lackproductmoney, D_AccountSftype.StoreType, D_AccountKmtype.OrderDelete, DirectionEnum.AccountsIncreased, "会员【" + number + "】报单删除现金返还,订单号为【" + orderId + "】", tran);
                    }
                }
                else if (order.DefrayState == 2)
                {
                    string electronicaccountid = order.ElectronicaccountId;;
                    if (lackproductmoney > 0)
                    {
                        IsElecPay(tran, order);
                        D_AccountBLL.AddAccount(storeId, lackproductmoney, D_AccountSftype.StoreType, D_AccountKmtype.OrderDelete, DirectionEnum.AccountsIncreased, "会员【" + number + "】报单删除现金返还,订单号为【" + orderId + "】", tran);
                        D_AccountBLL.AddAccount(electronicaccountid, lackproductmoney, D_AccountSftype.MemberType, D_AccountKmtype.OrderDelete, DirectionEnum.AccountsIncreased, "会员【" + number + "】报单删除现金返还,订单号为【" + orderId + "】", tran);
                    }
                }
                if (order.DefrayState == 1)
                {
                    int result = new AddOrderDataDAL().Js_delfuxiao(number, totalPv, except, order.DefrayState, tran);
                }

                try
                {
                    new AddOrderDataDAL().Del_Horder(tran, orderId, storeId, CommonDataBLL.OperateBh, CommonDataBLL.OperateIP);
                    tran.Commit();
                }
                catch (Exception)
                {
                    tran.Rollback();
                    info = BLL.Translation.Translate("001730", "抱歉!系统异常!");
                }
                finally
                {
                    conn.Close();
                    conn.Dispose();
                }
            }
            return(info);
        }
Esempio n. 15
0
    /// <summary>
    /// 支付按钮事件
    /// </summary>
    /// <param name="sender"></param>
    /// <param name="e"></param>
    protected void btnsure_Click(object sender, EventArgs e)
    {
        double currency = AjaxClass.GetCurrency(Convert.ToInt32(bzCurrency), Convert.ToInt32(Session["Default_Currency"].ToString()));
        int    res      = -1;
        string usemoney = lbltotalmoney.Text.Trim();
        string billid   = ViewState["billid"].ToString();
        int    roletype = Convert.ToInt32(ViewState["roletype"]);
        int    dotype   = Convert.ToInt32(ViewState["dotype"]);

        loginnumber = ViewState["loginnumber"].ToString();

        string curip = Request.UserHostAddress.ToString();

        if (!rdorempay.Checked)  //非离线支付
        {
            if (ViewState["remid"] != null)
            {
                RemittancesDAL.DelRemittancesrelationremtemp(ViewState["remid"].ToString());
            }
        }
        else //使用离线支付方式
        {
            if (ViewState["remid"] != null)
            {
                RemittancesDAL.UPRemittancesre(ViewState["remid"].ToString());
            }
        }

        if (rdoonlinepay.Checked)  //在线支付
        {
            string hkid = billid;
            ClientScript.RegisterStartupScript(GetType(), "msg", "alert('该功能正在开发中,请耐心等候!!!');", true);
            return;

            if (dotype == 1)
            {
                hkid = RemittancesDAL.AddRemittancebytypeOnline(billid, roletype, curip, loginnumber, 1);
            }
            else if (dotype == 2)
            {
                RemittancesDAL.UpdateOnlinepayway(billid, 4);
            }

            string posturl = Getposturl(hkid);

            ClientScript.RegisterStartupScript(this.GetType(), "", "<script>window.open ('" + posturl + "');</script>");
            this.btnsure.Enabled = false;
            return;
        }
        else if (rdorempay.Checked)  //离线支付
        {
            //usemoney = (double.Parse(lblrmb.Text.Trim()) * currency).ToString();
            usemoney = double.Parse(lblrmb.Text.Trim()).ToString("0.00");
            ClientScript.RegisterStartupScript(this.GetType(), "", "<script> window.location.href='payerror.aspx?ef=" + EncryKey.Encrypt("100" + "," + billid + "," + usemoney) + "';</script>");
            return;
        }
        else if (rdostorepay.Checked)  //去店铺支付
        {
            ClientScript.RegisterStartupScript(this.GetType(), "", "<script> window.location.href='payerror.aspx?ef=" + EncryKey.Encrypt("101" + "," + billid + "," + usemoney) + "';</script>");
            return;
        }
        else if (rdoectpay.Checked)                                     //会员电子货币支付
        {
            if (MemberOrderDAL.Getvalidteiscanpay(billid, loginnumber)) //限制订单必须有订货所属店铺推荐人协助人支付)
            {
                ClientScript.RegisterStartupScript(this.GetType(), "", "<script> alert('" + GetTran("007452", "该订单不属于您的协助或推荐报单,不能完成支付!") + "'); window.location.href='../Logout.aspx'; </script>");
                return;
            }
            if (ViewState["odnumber"].ToString() != loginnumber)//如果不是自己给自己支付
            {
                if (this.rdombsuregetmoney.SelectedValue == "0")
                {
                    ClientScript.RegisterStartupScript(this.GetType(), "", "<script> alert('" + GetTran("007455", "请确认已收到该会员支付的报单金额") + "');   </script>");
                    return;
                }
            }
            if (this.txtadvpass.Text == "")
            {
                ClientScript.RegisterStartupScript(this.GetType(), "", "<script>alert('" + GetTran("006656", "二级密码不能为空!") + "');</script>");
                return;
            }
            string oldPass = Encryption.Encryption.GetEncryptionPwd(this.txtadvpass.Text.ToString(), loginnumber);
            int    n       = PwdModifyBLL.check(loginnumber, oldPass, 1);
            if (n <= 0)
            {
                ClientScript.RegisterStartupScript(this.GetType(), "", "<script> alert('" + GetTran("006058", "二级密码不正确!") + "'); </script>");
                return;
            }

            if (MemberInfoDAL.CheckState(Session["Member"].ToString()))
            {
                ClientScript.RegisterStartupScript(this.GetType(), "", "<script> alert('" + GetTran("007456", "会员账户已冻结,不能完成支付!") + "'); </script>");
                return;
            }


            DataTable dt_one    = DAL.DBHelper.ExecuteDataTable("select ordertype from MemberOrder where OrderID=" + billid);
            string    ordertype = dt_one.Rows[0]["ordertype"].ToString();//订单类型
            int       act;
            if (ordertype == "22" || ordertype == "12")
            {
                act = Convert.ToInt32(rdoaccounttype2.SelectedValue);
            }
            else if (ordertype == "25")
            {
                act = Convert.ToInt32(rdoaccounttype3.SelectedValue);
            }
            else
            {
                act = Convert.ToInt32(rdoaccounttype.SelectedValue);
            }

            res = AddOrderDataDAL.OrderPayment(loginnumber, billid, curip, roletype, dotype, act, loginnumber, "", 2, -1, 1, 1, "", double.Parse(usemoney), "");
            this.btnsure.Enabled = false;
        }
        else if (rdostpaymb.Checked)                                    //店铺支付 会员订单
        {
            if (MemberOrderDAL.Getvalidteiscanpay(billid, loginnumber)) //限制订单必须有订货所属店铺推荐人协助人支付)
            {
                ClientScript.RegisterStartupScript(this.GetType(), "", "<script> alert('" + GetTran("007452", "该订单不属于您的协助或推荐报单,不能完成支付!") + "'); window.location.href='../Logout.aspx'; </script>");
                return;
            }
            if (this.rdoisagree.SelectedValue == "0") //验证是否确认收到款
            {
                ClientScript.RegisterStartupScript(this.GetType(), "", "<script> alert('" + GetTran("007455", "请确认已收到该会员支付的报单金额") + "!');   </script>");
                return;
            }
            if (this.txtpayadbpass.Text == "")
            {
                ClientScript.RegisterStartupScript(this.GetType(), "", "<script>alert('" + GetTran("006656", "二级密码不能为空!") + "');</script>");
                return;
            }
            string oldPass = Encryption.Encryption.GetEncryptionPwd(this.txtpayadbpass.Text.ToString(), Session["Store"].ToString());
            int    n       = PwdModifyBLL.checkstore(loginnumber, oldPass, 1);
            if (n <= 0)
            {
                ClientScript.RegisterStartupScript(this.GetType(), "", "<script> alert('" + GetTran("006058", "二级密码不正确!") + "'); </script>");
                return;
            }

            int act = Convert.ToInt32(rdostactypepaymb.SelectedValue);
            res = AddOrderDataDAL.OrderPayment(loginnumber, billid, curip, 2, 3, act, loginnumber, "", 5, -1, 1, 1, "", double.Parse(usemoney), "");
            this.btnsure.Enabled = false;
        }
        else if (rdostopayorder.Checked)  //店铺电子账户支付 订货单
        {
            if (this.txtstadvpass.Text == "")
            {
                ClientScript.RegisterStartupScript(this.GetType(), "", "<script>alert('" + GetTran("006656", "二级密码不能为空!") + "');</script>");
                return;
            }
            string oldPass = Encryption.Encryption.GetEncryptionPwd(this.txtstadvpass.Text.ToString(), Session["Store"].ToString());
            int    n       = PwdModifyBLL.checkstore(loginnumber, oldPass, 1);
            if (n <= 0)
            {
                ClientScript.RegisterStartupScript(this.GetType(), "", "<script> alert('" + GetTran("006058", "二级密码不正确!") + "'); </script>");

                return;
            }
            int act = Convert.ToInt32(rdostaccount.SelectedValue);

            res = AddOrderDataDAL.OrderPayment(loginnumber, billid, curip, roletype, dotype, act, loginnumber, "", 2, -1, 1, 1, "", double.Parse(usemoney), ""); this.btnsure.Enabled = false;
        }
        else
        {
            ClientScript.RegisterStartupScript(this.GetType(), "", "<script> alert('" + GetTran("000000", "请至少选择一种支付方式!") + "'); </script>");
            return;
        }

        PublicClass.SendMsg(1, billid, "");

        ClientScript.RegisterStartupScript(this.GetType(), "", "<script> window.location.href='payerror.aspx?ef=" + EncryKey.Encrypt(res.ToString() + "," + billid + "," + usemoney) + "';</script>");
        return;
    }
Esempio n. 16
0
    protected void Page_Load(object sender, EventArgs e)
    {
        /// Session["Member"] = "d2918447acbc262fbcb01efce558752c";
        if (!IsPostBack)
        {
            GetActMoney();
            if (Session["zfddh"] != null)
            {
                getzf();
            }
            else
            {
                string    number       = Session["Member"].ToString();
                DataTable dtordernopay = DBHelper.ExecuteDataTable("select top 1   dhorderid ,getplantE,useusdt  from dhlist where  number='" + number + "' and issuc=0   order by id desc");
                try
                {
                    string ddh  = "";
                    double getE = 0;
                    double usdt = 0;
                    if (dtordernopay.Rows.Count > 0)
                    {
                        ddh  = dtordernopay.Rows[0]["dhorderid"].ToString();
                        getE = Convert.ToDouble(dtordernopay.Rows[0]["getplantE"].ToString());
                        usdt = Convert.ToDouble(dtordernopay.Rows[0]["useusdt"].ToString());
                    }


                    string sl = GenerateCheckCodeNum(32);
                    //long mony = Convert.ToInt64(money.Text.Trim());
                    if (number == "")
                    {
                        System.Web.UI.ScriptManager.RegisterStartupScript(Page, GetType(), "success2", "showsuc('兑换状态未知,如果钱已扣除,请联系客服处理');", true);
                        return;
                    }
                    //string ddh = Session["zfddh"].ToString();

                    string postdz = "https://oauth.factorde.com/api/pay/queryOrder";
                    Dictionary <String, String> myDi = new Dictionary <String, String>();
                    Dictionary <String, Object> da   = new Dictionary <String, Object>
                    {
                        { "out_trade_no", ddh }
                    };

                    String jso = JsonConvert.SerializeObject(da, Formatting.Indented);

                    myDi.Add("nonce_str", sl);
                    myDi.Add("biz_content", jso);
                    myDi.Add("app_id", PublicClass.app_id);
                    myDi.Add("access_token", Session["access_token"].ToString());
                    myDi.Add("lang", "zh_CN");
                    myDi.Add("version", "1.0");
                    myDi.Add("charset", "utf8");
                    myDi.Add("openid", number);

                    string signj = PublicClass.GetSignContent(myDi);
                    string jsonS = PublicClass.HmacSHA256(signj + "&key=cd310d4c38d3b27dd9dfc069e559f73f", "cd310d4c38d3b27dd9dfc069e559f73f");

                    myDi.Add("sign", jsonS);

                    string  rspp   = PublicClass.doHttpPost(postdz, myDi);
                    JObject stJson = JObject.Parse(rspp);
                    // money.Text = rspp;
                    string zt     = stJson["data"]["trade_status"].ToString();
                    int    skje   = Convert.ToInt32(stJson["data"]["settle_trans_amount"]);
                    double dprice = Convert.ToDouble(DBHelper.ExecuteScalar("select  CoinnewPrice from CoinPlant where CoinIndex='CoinE' "));
                    skje = Convert.ToInt32(skje * dprice);
                    if (zt == "SUCCESS")
                    {
                        //if (skje == usdt)
                        //{
                        int rr = MemberOrderDAL.dhOrdersuc(number, ddh, getE);
                        if (rr > 0)
                        {
                            System.Web.UI.ScriptManager.RegisterStartupScript(Page, GetType(), "success2", "showsuc('兑换失败');", true);
                            Session["zfddh"] = "";
                            Session["USDT"]  = "";
                            Session["getE"]  = "";
                            return;
                        }
                        else
                        {
                            System.Web.UI.ScriptManager.RegisterStartupScript(Page, GetType(), "success2", "showsuc('兑换失败,如果钱已扣除,请联系客服处理');", true);
                        }

                        System.Web.UI.ScriptManager.RegisterStartupScript(Page, GetType(), "success2", "showsuc('兑换成功');", true);
                        return;
                        //}
                    }
                    else
                    {
                        System.Web.UI.ScriptManager.RegisterStartupScript(Page, GetType(), "success2", "showsuc('兑换失败,如果钱已扣除,请联系客服处理');", true);
                        // GetActMoney();
                        return;
                    }
                }
                catch (Exception)
                {
                }
            }
        }
    }
Esempio n. 17
0
    //提交保存
    protected void Button1_Click(object sender, EventArgs e)
    {
        string number = Session["member"].ToString();
        ///设置特定值防止重复提交

        double txMoney = 0; //購買金額

        if (!double.TryParse(this.txtneed.Text.Trim(), out txMoney))
        {
            System.Web.UI.ScriptManager.RegisterStartupScript(Page, GetType(), "success2", "showsuc('请正确输入!');", true);
            return;
        }
        if (txMoney <= 0)
        {
            System.Web.UI.ScriptManager.RegisterStartupScript(Page, GetType(), "success2", "showsuc('请正确输入!');", true);
            return;
        }

        double    coineblac    = Convert.ToDouble(DBHelper.ExecuteScalar("select  pointEin-pointEout as eblc from  memberinfo where number='" + number + "'"));
        double    actm         = CommandAPI.GetActMoney();
        double    dprice       = Convert.ToDouble(DBHelper.ExecuteScalar("select  CoinnewPrice from CoinPlant where CoinIndex='CoinE' "));
        double    kg           = 80 - coineblac;
        double    cuususdt     = txMoney * dprice; //需要使用的usdt數量
        DataTable dtordernopay = DBHelper.ExecuteDataTable("select top 1   dhorderid ,getplantE,useusdt  from dhlist where  number='" + number + "'  and issuc=1 and DateDiff(dd,dhdate,getdate())=0  order by id desc");

        if (dtordernopay.Rows.Count > 0)
        {
            System.Web.UI.ScriptManager.RegisterStartupScript(Page, GetType(), "success2", "showsuc('每天只能抢购一次');", true); txtneed.Text = kg.ToString("0.0000");
            return;
        }

        if (kg < txMoney)     //購買數量超過可購數量
        {
            System.Web.UI.ScriptManager.RegisterStartupScript(Page, GetType(), "success2", "showsuc('最多可购" + kg + " 枚火星币!');", true); txtneed.Text = kg.ToString("0.0000");
            return;
        }

        //if (actm < cuususdt) //usdt數量超多賬戶
        //{
        //    double zdkd = actm / dprice;
        //    System.Web.UI.ScriptManager.RegisterStartupScript(Page, GetType(), "success2", "showsuc('当前USDT账户最多可购"+ zdkd.ToString("0.0000") + "!');", true); txtneed.Text = zdkd.ToString("0.0000") ;
        //    return;
        //}


        //記錄兌換表中兌換情況
        string dhorderid = "DH" + DateTime.Now.ToString("yyMMddHHmmssms");

        Session["zfddh"] = dhorderid;
        Session["getE"]  = txMoney;
        Session["USDT"]  = cuususdt;
        int rr = MemberOrderDAL.createDHOrder(number, dhorderid, cuususdt, dprice, txMoney, "会员兑换Mars(火星币)");

        //請求執行支付
        if (rr == 1)
        {
            string postf = CommandAPI.GetFunction(dhorderid, cuususdt.ToString("0.0000"), "plantedh.aspx", RadioButtonList1.SelectedValue);
            ClientScript.RegisterStartupScript(this.GetType(), "", postf, false);
            return;
        }
        else
        {
            System.Web.UI.ScriptManager.RegisterStartupScript(Page, GetType(), "success2", "showsuc('兑换操作异常!');", true);
        }
    }
Esempio n. 18
0
        public static string AuditingOrder(string orderid)
        {
            string error = "";                                                       //返回错误信息

            MemberOrderModel          mo   = MemberOrderDAL.GetMemberOrder(orderid); //获取报单信息
            List <MemberDetailsModel> list = ViewFuXiaoBLL.GetDetails(mo.OrderId);   //获取订单明细

            //判断报单是否支付
            if (mo.DefrayState != 0)
            {
                return(BLL.Translation.Translate("000987", "报单不可重复确认"));// "报单不可重复确认!";
            }


            //验证店铺钱是否够支付保单
            double notEnoughmoney = new RegistermemberBLL().CheckMoneyIsEnough(list, mo.StoreId);
            double storeLeftMoney = new StoreDataDAL().GetLeftRegisterMemberMoney(mo.StoreId);

            if (storeLeftMoney < notEnoughmoney)
            {
                return(BLL.Translation.Translate("006018", "对不起,您的报单额不足!"));// "报单不可重复确认!";
            }


            //更改--报单信息
            mo.RemittancesId = MYDateTime.ToYYMMDDHHmmssString();
            mo.DefrayState   = 1;
            mo.PayExpect     = CommonDataBLL.getMaxqishu();

            //double notEnoughmoney = new RegistermemberBLL().CheckMoneyIsEnough(list, mo.StoreId);

            IList <MemberDetailsModel> listnew = CommonDataBLL.GetNewOrderDetail1(list);

            for (int i = 0; i < list.Count; i++)
            {
                int left = BLL.CommonClass.CommonDataBLL.GetLeftLogicProductInventory(Convert.ToInt32(listnew[i].ProductId));
                if (left < listnew[i].Quantity)
                {
                    return(BLL.Translation.Translate("005967", "对不起,公司库存不够") + "!" + listnew[i].ProductName + BLL.Translation.Translate("005970", "库存数只有") + ":" + left);
                }
            }
            //转化汇率
            notEnoughmoney = new RegistermemberBLL().ChangeNotEnoughMoney(mo.StoreId, notEnoughmoney);

            double EnoughProductMoney = Convert.ToDouble(new RegistermemberBLL().getEnoughProductMoney(list, mo.StoreId));

            mo.EnoughProductMoney = Convert.ToInt32(EnoughProductMoney);
            mo.LackProductMoney   = Convert.ToInt32(notEnoughmoney);

            //拆分组合产品
            IList <MemberDetailsModel> md = BLL.CommonClass.CommonDataBLL.GetNewOrderDetail1(list);

            System.Web.HttpContext.Current.Application.UnLock();
            System.Web.HttpContext.Current.Application.Lock();
            using (SqlConnection conn = new SqlConnection(DBHelper.connString))
            {
                conn.Open();
                SqlTransaction tran = conn.BeginTransaction();
                try
                {
                    //更新会员订单信息
                    if (!CommonDataBLL.ConfirmMembersOrder(tran, mo.OrderId, mo.PayExpect, mo.EnoughProductMoney, mo.LackProductMoney))
                    {
                        tran.Rollback();
                        System.Web.HttpContext.Current.Application.UnLock();
                        return(BLL.Translation.Translate("000993", "确认失败"));
                    }

                    //更新店铺库存
                    foreach (MemberDetailsModel memberDetailsModel in list)
                    {
                        //循环根据订单明细跟新库存
                        int result = ViewFuXiaoBLL.UptStock(tran, memberDetailsModel.StoreId, memberDetailsModel.ProductId, memberDetailsModel.Quantity, memberDetailsModel.NotEnoughProduct);

                        //如果该店铺无盖商品记录,则在店库存表中加记录
                        if (result <= 0)
                        {
                            new BrowseMemberOrdersBLL().updateStore2(memberDetailsModel, tran);
                        }

                        if (memberDetailsModel.NotEnoughProduct > 0)
                        {
                            if (!CommonDataBLL.ConfirmMembersDetails(tran, memberDetailsModel.ProductId, mo.OrderId, memberDetailsModel.NotEnoughProduct))
                            {
                                tran.Rollback();
                                System.Web.HttpContext.Current.Application.UnLock();
                                return(BLL.Translation.Translate("000993", "确认失败"));
                            }
                        }
                    }

                    //处理公司逻辑库存
                    int sd = new DAL.AddOrderDataDAL().updateStoreL(tran, md);



                    //报单生成订单
                    Insert_OrderGoods(list, mo, tran);

                    if (mo.DefrayType == 1)
                    {
                        if (Convert.ToDouble(mo.LackProductMoney) > 0)
                        {
                            //记录对账单明细
                            BLL.Logistics.D_AccountBLL.AddAccount(mo.StoreId, Convert.ToDouble(mo.LackProductMoney), D_AccountSftype.StoreType, D_AccountKmtype.Declarations, DirectionEnum.AccountReduced, "会员【" + mo.Number + "】报单现金扣除额,订单号为【" + mo.OrderId + "】", tran);
                        }
                    }
                    if (mo.DefrayType == 2)
                    {
                        //记录对账单明细
                        BLL.Logistics.D_AccountBLL.AddAccount(mo.ElectronicaccountId, Convert.ToDouble(mo.TotalMoney), D_AccountSftype.MemberType, D_AccountKmtype.Declarations, DirectionEnum.AccountReduced, "会员【" + mo.Number + "】用会员【" + mo.ElectronicaccountId + "】电子货币报单,订单号为【" + mo.OrderId + "】", tran);
                        BLL.Logistics.D_AccountBLL.AddAccount(mo.StoreId, Convert.ToDouble(mo.TotalMoney), D_AccountSftype.StoreType, D_AccountKmtype.Declarations, DirectionEnum.AccountsIncreased, "会员【" + mo.Number + "】用会员【" + mo.ElectronicaccountId + "】电子货币报单转入,订单号为【" + mo.OrderId + "】", tran);
                        if (Convert.ToDouble(mo.LackProductMoney) > 0)
                        {
                            BLL.Logistics.D_AccountBLL.AddAccount(mo.StoreId, Convert.ToDouble(mo.LackProductMoney), D_AccountSftype.StoreType, D_AccountKmtype.Declarations, DirectionEnum.AccountReduced, "会员【" + mo.Number + "】报单现金扣除额,订单号为【" + mo.OrderId + "】", tran);
                        }

                        //更新电子账户余额
                        AddOrderDataDAL.UpdateECTPay(tran, mo.ElectronicaccountId, mo.LackProductMoney);

                        //更新店铺汇款
                        new AddOrderDataDAL().Add_Remittances(tran, Convert.ToDouble(mo.LackProductMoney), mo.StoreId);

                        //插入汇款信息
                        new AddOrderDataDAL().AddDataTORemittances(tran, mo);
                    }

                    //更新店铺报单款
                    new AddOrderDataDAL().updateStore3(mo.StoreId, tran, Convert.ToDouble(mo.LackProductMoney));

                    //判断是否是注册的会员
                    if (mo.IsAgain == 0)
                    {
                        //获取会员信息
                        MemberInfoModel mi = MemberOrderDAL.GetMemberInfo(orderid, tran);
                        //更新会员业绩,会员进入网络图
                        new AddOrderDataDAL().Upt_UpdateNew1(mi, tran);
                        //激活会员
                        int resultActive = new GroupRegisterBLL().uptIsActive(mi.Number, tran);
                    }
                    //实时更新会员级别
                    CommonDataBLL.SetMemberLevel(tran, mo.Number, mo.OrderId);
                    //提交事务
                    tran.Commit();
                }
                catch (Exception ex)
                {
                    string sga = ex.Message;
                    error = BLL.Translation.Translate("000993", "确认失败");// "确认失败!";
                    tran.Rollback();
                }
                finally
                {
                    conn.Close();
                    conn.Dispose();
                    System.Web.HttpContext.Current.Application.UnLock();
                }
            }

            return(error);
        }
Esempio n. 19
0
        /// <summary>
        /// 删除报单信息
        /// </summary>
        /// <param name="strId">报单编号</param>
        /// <param name="maxExcept">当前期数</param>
        /// <returns></returns>
        public string DelMembersDeclaration(string number, int maxExcept, string orderId, string storeId, double lackproductmoney)
        {
            OrderDAL orderDAL = new OrderDAL();
            string   info     = null;

            MemberOrderModel order = MemberOrderDAL.GetMemberOrder(orderId);

            BLL.CommonClass.ChangeLogs cl_h_info  = new BLL.CommonClass.ChangeLogs("memberinfo", "number");   //申明日志对象
            BLL.CommonClass.ChangeLogs cl_h_order = new BLL.CommonClass.ChangeLogs("MemberOrder", "orderId"); //申明日志对象
            using (SqlConnection conn = new SqlConnection(DBHelper.connString))
            {
                conn.Open();
                SqlTransaction tran = conn.BeginTransaction();
                try
                {
                    //判断会员下是否有安置
                    //全球统一可以删除有下级的会员,如果有两个下级则注销,有一个下级则紧缩
                    info = new AddOrderBLL().GetHavePlace(number, tran);
                    if (info != null)
                    {
                        tran.Rollback();
                        conn.Close();
                        return(info);
                    }
                    ////判断会员下是否有推荐
                    info = new AddOrderBLL().GetHaveDirect(number, tran);
                    if (info != null)
                    {
                        tran.Rollback();
                        conn.Close();
                        return(info);
                    }

                    int cnt = new AddOrderBLL().GetHaveStore(number, tran);
                    if (cnt > 0)
                    {
                        info = this.GetTran("007097", "抱歉!该会员已经注册店铺,不可以删除!");// "抱歉!该会员有重复消费请先删除重复消费!";
                        tran.Rollback();
                        conn.Close();
                        return(info);
                    }
                    //判断该会员是否有复效单
                    int result = browsememberordersDAL.GetHasOrderAgain(number);
                    if (result > 0)
                    {
                        info = this.GetTran("000976", "抱歉!该会员有重复消费请先删除重复消费!");// "抱歉!该会员有重复消费请先删除重复消费!";
                        tran.Rollback();
                        conn.Close();
                        return(info);
                    }
                    else
                    {
                        string electronicaccountid = order.ElectronicaccountId;;
                        int    defrayState         = order.DefrayState;
                        int    defrayType          = order.DefrayType;
                        //if (defrayState == 1)
                        //{
                        //    if (lackproductmoney > 0)
                        //    {
                        //        int deliveryflag = BLL.Logistics.D_AccountBLL.GetDeliveryflag(orderId, tran);
                        //        if (deliveryflag == 0)
                        //        {
                        //            if (defrayType == 2)
                        //            {
                        //                IsElecPay(tran, order);
                        //                BLL.Logistics.D_AccountBLL.AddAccount(storeId, lackproductmoney, D_AccountSftype.StoreType, D_AccountKmtype.OrderDelete, DirectionEnum.AccountsIncreased, "会员【" + number + "】报单删除现金返还,订单号为【" + orderId + "】", tran);
                        //                BLL.Logistics.D_AccountBLL.AddAccount(electronicaccountid, lackproductmoney, D_AccountSftype.MemberType, D_AccountKmtype.OrderDelete, DirectionEnum.AccountsIncreased, "会员【" + number + "】报单删除现金返还,订单号为【" + orderId + "】", tran);
                        //            }
                        //            else if (defrayType == 1)
                        //            {
                        //                BLL.Logistics.D_AccountBLL.AddAccount(storeId, lackproductmoney, D_AccountSftype.StoreType, D_AccountKmtype.OrderDelete, DirectionEnum.AccountsIncreased, "会员【" + number + "】报单删除现金扣添加,订单号为【" + orderId + "】", tran);
                        //            }
                        //        }
                        //    }
                        //}



                        // cl_h_info.DeletedIntoLogstran(tran, CommonClass.ChangeCategory.Order, storeId, BLL.CommonClass.ENUM_USERTYPE.objecttype5);
                        browsememberordersDAL.DelNew(number, maxExcept, tran);

                        //添加日志
                        cl_h_info.AddRecordtran(tran, number);
                        cl_h_order.AddRecordtran(tran, orderId);
                        cl_h_order.DeletedIntoLogstran(tran, CommonClass.ChangeCategory.Order, storeId, BLL.CommonClass.ENUM_USERTYPE.objecttype5);

                        addOrderDataDAL.Del_Horder(tran, orderId, storeId, CommonDataBLL.OperateBh, CommonDataBLL.OperateIP);

                        ///删除后,把推荐或安置是他的err赋上值
                        int checkResult = addOrderDataDAL.Check_WhenDelete(tran, number);
                    }

                    tran.Commit();
                }
                catch (Exception ext)
                {
                    info = this.GetTran("000985", "抱歉!系统异常");// "抱歉!系统异常";
                    tran.Rollback();
                    conn.Close();
                    return(info);
                }
                finally
                {
                    conn.Close();
                    conn.Dispose();
                }
            }
            return(info);
        }
Esempio n. 20
0
    public void LoadData1()
    {
        double currency = AjaxClass.GetCurrency(int.Parse(Session["Default_Currency"] == null ? bzCurrency.ToString() : Session["Default_Currency"].ToString()));
        string billid   = ViewState["billid"].ToString();
        int    dotype   = Convert.ToInt32(ViewState["dotype"]);
        int    roletype = Convert.ToInt32(ViewState["roletype"]);

        this.lblorderid.Text = billid;


        MemberOrderModel memberorder     = null;
        DataTable        ordergoodstable = null;
        DataTable        dtcb            = null; //查询会员汇入银行
        string           paymentnumber   = "";   //被支付订单(汇款单)所属会员编号
        double           totalmoney      = 0;    // 被支付订单(汇款单)总金额

        if (dotype == 1)                         //订单支付
        {
            lbltype.Text = GetTran("000907", "订单支付");
            lblot.Text   = GetTran("000079", "订单号");
        }
        else if (dotype == 2)//充值
        {
            div_1.Style.Add("display", "none");
            div_2.Style.Add("display", "none");

            div_5.Style.Add("display", "none");
            div_6.Style.Add("display", "none");
            lbltype.Text       = GetTran("007451", "订单支付");
            lblot.Text         = GetTran("005854", "汇款单号");
            ViewState["remid"] = billid;

            RemittancesModel remittance = RemittancesDAL.GetRemitByHuidan(billid);
            paymentnumber = remittance.RemitNumber.ToString();                  //被支付订单(汇款单)所属会员编号
            totalmoney    = Convert.ToDouble(remittance.RemitMoney) * currency; // 被支付订单(汇款单)总金额
        }


        if (roletype == 1)  //会员
        {
            //隐藏店铺操作
            div_6.Style.Add("display", "none");
            div_5.Style.Add("display", "none");

            if (Session["Member"] != null)
            {
                loginnumber = Session["Member"].ToString();
            }
            else if (Session["Store"] != null)
            {
                loginnumber = Session["Store"].ToString();
                //店铺支付会员订单
                div_1.Style.Add("display", "none");
                div_2.Style.Add("display", "none");
                div_3.Style.Add("display", "none");
                div_4.Style.Add("display", "none");
                div_6.Style.Add("display", "none");
                div_5.Style.Add("display", "");
            }


            if (dotype == 1)                                                //订单支付
            {
                if (MemberOrderDAL.Getvalidteiscanpay(billid, loginnumber)) //限制订单必须有订货所属店铺中心支付)
                {
                    ClientScript.RegisterStartupScript(this.GetType(), "", "<script> alert('" + GetTran("007452", "该订单不属于您的协助或推荐报单,不能完成支付") + "'); window.location.href='../Logout.aspx'; </script>");

                    return;
                }
                memberorder = MemberOrderDAL.GetMemberOrder(billid);
                if (loginnumber == "")
                {
                    loginnumber = memberorder.Number;
                }
                else
                {
                    ViewState["odnumber"] = memberorder.Number;
                }
                if (memberorder.Number == loginnumber)//如果是自己支付自己的订单则不需要确认收到款
                {
                    div_sure.Visible = false; rdombsuregetmoney.Visible = false;
                }
                if (memberorder == null)
                {
                    ClientScript.RegisterStartupScript(this.GetType(), "", "<script> window.location.href='payerror.aspx?ef=" + EncryKey.Encrypt("1").ToLower() + "';</script>");
                    return;
                }
                if (memberorder.DefrayState == 1)
                {
                    ClientScript.RegisterStartupScript(this.GetType(), "", "<script>window.location.href='payerror.aspx?ef=" + EncryKey.Encrypt("2").ToLower() + "';</script>");
                    return;
                }
                paymentnumber = memberorder.Number.ToString();            //被支付订单(汇款单)所属会员编号
                totalmoney    = Convert.ToDouble(memberorder.TotalMoney); // 被支付订单(汇款单)总金额
            }
            dtcb = CompanyBankDAL.getdtcompanybankbynumber(loginnumber, 1);
        }
        else if (roletype == 2)  //店铺
        {
            //隐藏店铺操作
            div_2.Style.Add("display", "none");
            div_1.Style.Add("display", "none");
            div_5.Style.Add("display", "none");
            loginnumber = Session["Store"].ToString();
            dtcb        = CompanyBankDAL.getdtcompanybankbynumber(loginnumber, 2);
            if (dotype == 1)  //订单操作
            {
                ordergoodstable = OrderDetailDAL.Getordergoodstablebyorderid(billid);
                if (ordergoodstable != null && ordergoodstable.Rows.Count > 0)
                {
                    if (ordergoodstable.Rows[0]["IsCheckOut"].ToString() == "Y")
                    {
                        ClientScript.RegisterStartupScript(this.GetType(), "", "<script>window.location.href='payerror.aspx?ef=" + EncryKey.Encrypt("2").ToLower() + "';</script>");
                        return;
                    }
                }
                else
                {
                    ClientScript.RegisterStartupScript(this.GetType(), "", "<script> window.location.href='payerror.aspx?ef=" + EncryKey.Encrypt("1").ToLower() + "';</script>");
                    return;
                }
                //paymentnumber = ordergoodstable.Rows[0]["storeid"].ToString();//被支付订单(汇款单)所属会员编号
                totalmoney = Convert.ToDouble(ordergoodstable.Rows[0]["totalmoney"]);// 被支付订单(汇款单)总金额
            }
        }
        lblstoreid1.Text    = loginnumber;
        lblstoreID2.Text    = loginnumber;
        lblordernumber.Text = loginnumber;
        lbltotalmoney.Text  = totalmoney.ToString("0.00");
        lblordertmoney.Text = totalmoney.ToString("0.00");
        ViewState["tm"]     = totalmoney;
        string cardstr = "";
        int    i       = 1;

        if (dtcb != null && dtcb.Rows.Count > 0)
        {
            foreach (DataRow item in dtcb.Rows)
            {
                cardstr += " <div   id='bank" + i.ToString() + "'    >&nbsp;&nbsp;&nbsp;&nbsp;" + GetTran("001243", "开户行") + ":&nbsp;&nbsp;&nbsp;&nbsp;" + item["Bank"].ToString() + "<br/>&nbsp;&nbsp;&nbsp;&nbsp;" + GetTran("007506", "账") + "&nbsp;&nbsp;&nbsp;" + GetTran("007453", "号") + ":&nbsp;&nbsp;&nbsp;" + getsplit(item["BankBook"].ToString()) + "<br/>&nbsp;&nbsp;&nbsp;&nbsp;" + GetTran("000086", "开户名") + ":&nbsp;&nbsp;&nbsp;&nbsp;" + item["Bankname"].ToString() + "</div>"; i++;
            }
            this.cardlist.InnerHtml = cardstr;//绑定银行信息
        }
    }
Esempio n. 21
0
    protected void Page_Load(object sender, EventArgs e)
    {
        //  AjaxPro.Utility.RegisterTypeForAjax(typeof(AjaxClass));
        //Session["Member"] = "d2918447acbc262fbcb01efce558752c";
        //Permissions.MemRedirect(Page, Permissions.redirUrl);
        Response.Cache.SetExpires(DateTime.Now);
        if (!IsPostBack)
        {
            if (Session["orderid"] != null)
            {
                string orderid = Session["orderid"].ToString();
                try
                {
                    string   getresult = CommandAPI.getzf(orderid);
                    string[] rlist     = getresult.Split(',');
                    //修改订单状态
                    if (rlist[0] == "SUCCESS")
                    {
                        string number  = Session["Member"].ToString();
                        int    choselv = Convert.ToInt32(Session["choselv"]);
                        double eneed   = Convert.ToDouble(Session["Eneed"]);
                        int    rr      = MemberOrderDAL.PayOrder(number, orderid, 0, 0, 0, 0, choselv, "USDT账户支付成功");


                        if (rr == 1)
                        {
                            Session.Remove("orderid");
                            Session.Remove("choselv");
                            Session.Remove("Eneed");
                            if (eneed > 0)
                            {
                                int ee = MemberOrderDAL.payOrderEcoin(number, orderid, eneed, "E币支付,激活成功!");
                                if (ee == 1)
                                {
                                    ClientScript.RegisterStartupScript(this.GetType(), "", "<script>showsuc('购买矿机激活成功!');</script>", false);
                                }
                                else
                                {
                                    ClientScript.RegisterStartupScript(this.GetType(), "", "<script>showsuc('支付成功,请使用E币激活矿机!'); setTimeout(function(){ window.location.href='orderlist.aspx'},3000); </script>", false);
                                }
                            }
                            ClientScript.RegisterStartupScript(this.GetType(), "", "<script>showsuc('购买矿机支付成功!');</script>", false); Bind();
                            return;
                        }
                        else
                        {
                            ClientScript.RegisterStartupScript(this.GetType(), "", "<script>showsuc('付款成功但插入订单失败,请联系客服查询处理!');</script>", false);
                        }
                    }
                    else
                    {
                        ClientScript.RegisterStartupScript(this.GetType(), "", "<script>showsuc('购买矿机失败!');</script>", false);
                    }
                }
                catch (Exception)
                {
                }
            }
            else
            {
                //查询 当前会员未支付订单
                string    number       = Session["Member"].ToString();
                DataTable dtordernopay = DBHelper.ExecuteDataTable("select    orderid ,totalmoney  from memberorder where  number='" + number + "'  and DefrayState=0  ");
                try
                {
                    if (dtordernopay.Rows.Count > 0)
                    {
                        double cep = Convert.ToDouble(DBHelper.ExecuteScalar("select   coinnewprice  from CoinPlant where CoinIndex='CoinE'  "));
                        foreach (DataRow item in dtordernopay.Rows)
                        {
                            string orderid = item["orderid"].ToString();
                            double ttmoney = Convert.ToDouble(item["totalmoney"]);



                            string ddz = CommandAPI.getzf(orderid);
                            if (ddz == "SUCCESS")
                            {
                                int    choselv = 0;// Convert.ToInt32(Session["choselv"]);
                                double eneed   = (ttmoney * 0.05) / cep;
                                int    rr      = MemberOrderDAL.PayOrder(number, orderid, 0, 0, 0, 0, choselv, "USDT账户支付成功");

                                if (rr == 1 && eneed > 0)
                                {
                                    MemberOrderDAL.payOrderEcoin(number, orderid, eneed, "E币支付,激活成功!");
                                }

                                ClientScript.RegisterStartupScript(this.GetType(), "", "<script>showsuc('购买矿机激活成功!');</script>", false);
                            }
                            else
                            {
                                ClientScript.RegisterStartupScript(this.GetType(), "", "<script>showsuc('" + ddz + "');</script>", false);
                            }
                        }
                    }
                }
                catch (Exception)
                {
                }


                Bind();
            }
        }
    }
Esempio n. 22
0
    /// <summary>
    /// 获取标示码
    /// </summary>
    /// <param name="sender"></param>
    /// <param name="e"></param>
    protected void Loadmk()
    {
        string           billid           = ViewState["billid"].ToString();
        int              dotype           = Convert.ToInt32(ViewState["dotype"]);
        int              roletype         = Convert.ToInt32(ViewState["roletype"]);
        double           currency         = AjaxClass.GetCurrency(int.Parse(Session["Default_Currency"] == null ? bzCurrency.ToString() : Session["Default_Currency"].ToString()));
        string           ip               = Request.UserHostAddress.ToString();
        string           remark           = "";
        MemberOrderModel memberorder      = null;
        DataTable        ordergoodstable  = null;
        DataTable        ordergoodstable1 = null;
        double           ordertmoney      = 0;

        if (roletype == 1)  //会员订单
        {
            if (dotype == 1)
            {
                memberorder = MemberOrderDAL.GetMemberOrder(billid);
                ordertmoney = Convert.ToDouble(memberorder.TotalMoney);
            }
        }
        else
        if (roletype == 2)      //店铺
        {
            if (dotype == 1)
            {
                ordergoodstable  = OrderDetailDAL.Getordergoodstablebyorderid1(billid);
                ordergoodstable1 = OrderDetailDAL.Getordergoodstablebyorderid2(billid);
                if (ordergoodstable != null && ordergoodstable.Rows.Count > 0)
                {
                    ordertmoney = Convert.ToDouble(ordergoodstable.Rows[0]["totalmoney"]);
                }

                else
                {
                    if (ordergoodstable1 != null && ordergoodstable1.Rows.Count > 0)
                    {
                        ordertmoney = Convert.ToDouble(ordergoodstable1.Rows[0]["totalmoney"]);
                    }
                }
            }
        }
        string biaoshi = "";

        if (dotype == 1)  //订单支付生成尾数
        {
            remark = loginnumber + "汇款支付订单" + billid;
            int c = 1; //数据库中1代表会员 0代表店铺
            if (roletype == 2)
            {
                c = 0;
            }
            string rmid = RemittancesDAL.GetAddnewRemattice(loginnumber, ordertmoney, ip, billid, remark, c);
            ViewState["remid"] = rmid;
            DataTable dt = DBHelper.ExecuteDataTable("select totalrmbmoney ,totalmoney from  remtemp where remittancesid='" + rmid + "'");

            if (dt != null && dt.Rows.Count > 0)
            {
                //    biaoshi = Convert.ToDouble(dt.Rows[0]["totalrmbmoney"]).ToString("f2");
                biaoshi = Convert.ToDouble(dt.Rows[0]["totalmoney"]).ToString("#0.00");
            }
        }
        else
        if (dotype == 2)     //汇款充值生成尾数
        {
            RemittancesDAL.GetAddnewRetmp(loginnumber, billid, ip, remark, roletype);
            DataTable dt = DBHelper.ExecuteDataTable("select totalrmbmoney ,totalmoney from  remtemp where remittancesid='" + billid + "'");      //查找出标识

            if (dt != null && dt.Rows.Count > 0)
            {
                //biaoshi = Convert.ToDouble(dt.Rows[0]["totalrmbmoney"]).ToString("f2");
                biaoshi = Convert.ToDouble(dt.Rows[0]["totalmoney"]).ToString("#0.00");
            }
        }
        if (biaoshi != "" && biaoshi.ToString().IndexOf('.') > 0)
        {
            DataTable dt = new DataTable();
            if (dotype == 1)
            {
                remark = loginnumber + "汇款支付订单" + billid;
                int c = 1; //数据库中1代表会员 0代表店铺
                if (roletype == 2)
                {
                    c = 0;
                }
                string rmid = RemittancesDAL.GetAddnewRemattice(loginnumber, ordertmoney, ip, billid, remark, c);
                ViewState["remid"] = rmid;
                dt = DBHelper.ExecuteDataTable("select totalrmbmoney ,totalmoney from  remtemp where remittancesid='" + rmid + "'");
            }
            else if (dotype == 2)
            {
                RemittancesDAL.GetAddnewRetmp(loginnumber, billid, ip, remark, roletype);
                dt = DBHelper.ExecuteDataTable("select totalrmbmoney ,totalmoney from  remtemp where remittancesid='" + billid + "'");  //查找出标识
            }

            string bb = (double.Parse(biaoshi) * currency).ToString();
            //lblpartmoney.Text = (bb).Substring(0, (bb).IndexOf('.'));
            //string chart = bb.Substring(bb.IndexOf('.') + 1);
            this.lblmoneyre.Text = (double.Parse(bb)).ToString();
            this.lblrmb.Text     = double.Parse(lbltotalmoney.Text).ToString("#0.00");
            //lblchat.Text = (double.Parse(chart) ).ToString(); ;
            //lbljiao.Text = chart.Substring(0, 1);
            //lblfen.Text = chart.Substring(1);
        }
    }
Esempio n. 23
0
 /// <summary>
 /// 根据报单编号获取店铺编号
 /// </summary>
 /// <param name="orderid">报单编号</param>
 /// <returns>返回店铺编号</returns>
 public static string GetStoreIdByOrderId(string orderid)
 {
     return(MemberOrderDAL.GetStoreIdByOrderId(orderid));
 }
Esempio n. 24
0
    public void getzf()
    {
        string number = Session["member"].ToString();
        string sl     = GenerateCheckCodeNum(32);

        //long mony = Convert.ToInt64(money.Text.Trim());
        if (number == "")
        {
            System.Web.UI.ScriptManager.RegisterStartupScript(Page, GetType(), "success2", "showsuc('兑换状态未知,如果钱已扣除,请联系客服处理');", true);
            return;
        }
        string ddh    = Session["zfddh"].ToString();
        double getE   = Convert.ToDouble(Session["getE"]);
        double usdt   = Convert.ToDouble(Session["USDT"]);
        string postdz = "https://oauth.factorde.com/api/pay/queryOrder";
        Dictionary <String, String> myDi = new Dictionary <String, String>();
        Dictionary <String, Object> da   = new Dictionary <String, Object>
        {
            { "out_trade_no", ddh }
        };

        String jso = JsonConvert.SerializeObject(da, Formatting.Indented);

        myDi.Add("nonce_str", sl);
        myDi.Add("biz_content", jso);
        myDi.Add("app_id", PublicClass.app_id);
        myDi.Add("access_token", Session["access_token"].ToString());
        myDi.Add("lang", "zh_CN");
        myDi.Add("version", "1.0");
        myDi.Add("charset", "utf8");
        myDi.Add("openid", number);

        string signj = PublicClass.GetSignContent(myDi);
        string jsonS = PublicClass.HmacSHA256(signj + "&key=cd310d4c38d3b27dd9dfc069e559f73f", "cd310d4c38d3b27dd9dfc069e559f73f");

        myDi.Add("sign", jsonS);

        string  rspp   = PublicClass.doHttpPost(postdz, myDi);
        JObject stJson = JObject.Parse(rspp);
        // money.Text = rspp;
        string zt     = stJson["data"]["trade_status"].ToString();
        int    skje   = Convert.ToInt32(stJson["data"]["settle_trans_amount"]);
        double dprice = Convert.ToDouble(DBHelper.ExecuteScalar("select  CoinnewPrice from CoinPlant where CoinIndex='CoinE' "));

        skje = Convert.ToInt32(skje * dprice);
        if (zt == "SUCCESS")
        {
            //if (skje == usdt)
            //{
            int rr = MemberOrderDAL.dhOrdersuc(number, ddh, getE);
            if (rr > 0)
            {
                System.Web.UI.ScriptManager.RegisterStartupScript(Page, GetType(), "success2", "showsuc('兑换失败');", true);
                Session["zfddh"] = "";
                Session["USDT"]  = "";
                Session["getE"]  = "";
                return;
            }
            else
            {
                System.Web.UI.ScriptManager.RegisterStartupScript(Page, GetType(), "success2", "showsuc('兑换失败,如果钱已扣除,请联系客服处理');", true);
            }

            System.Web.UI.ScriptManager.RegisterStartupScript(Page, GetType(), "success2", "showsuc('兑换成功');", true);
            return;
            //}
        }
        else
        {
            System.Web.UI.ScriptManager.RegisterStartupScript(Page, GetType(), "success2", "showsuc('兑换失败,如果钱已扣除,请联系客服处理');", true);
            // GetActMoney();
            return;
        }
    }
Esempio n. 25
0
    protected void gv_browOrder_RowCommand(object sender, GridViewCommandEventArgs e)
    {
        if (e.CommandName == "P")
        {
            string    orderid = e.CommandArgument.ToString();
            string    num     = "";
            double    ttmoney = 0;
            DataTable dt      = DBHelper.ExecuteDataTable("select  number,TotalMoney  from memberorder where  orderid='" + orderid + "'");
            if (dt != null && dt.Rows.Count > 0)
            {
                DataRow dr = dt.Rows[0];
                num     = dr["number"].ToString();
                ttmoney = Convert.ToDouble(dr["TotalMoney"]);
                double nep     = Convert.ToDouble(DBHelper.ExecuteScalar("  select CoinnewPrice   from CoinPlant where CoinIndex = 'CoinE' "));
                double nedde   = (ttmoney * 0.05) / nep;
                int    choselv = 1;

                double eblace = Convert.ToDouble(DBHelper.ExecuteScalar("select  pointEin -pointEout as r from memberinfo where  number='" + num + "'"));
                if (nedde > eblace)
                {
                    ScriptHelper.SetAlert(Page, "火星币账户余额不足,不能完成协助支付!");
                    // btnSearch_Click(null, null);
                    return;
                }

                int rr = MemberOrderDAL.PayOrder(num, orderid, 0, 0, 0, nedde, choselv, "USDT账户支付订单,支付中断,后台协助支付");

                if (rr == 1)
                {
                    int ee = MemberOrderDAL.payOrderEcoin(num, orderid, nedde, "E币支付激活,激活成功!");  if (ee == 1)
                    {
                        ScriptHelper.SetAlert(Page, "协助支付成功");
                    }
                    btnSearch_Click(null, null);
                    return;
                }
                else
                {
                    ScriptHelper.SetAlert(Page, "协助支付失败!");
                    btnSearch_Click(null, null);
                    return;
                }
            }
            else
            {
                ClientScript.RegisterStartupScript(this.GetType(), "", "<script>showsuc('订单不存在!');</script>", false);
                btnSearch_Click(null, null);
                return;
            }
        }


        string[] args = e.CommandArgument.ToString().Split(':');
        //if (args.Length != 7)
        //{
        //    ScriptHelper.SetAlert(Page, this.GetTran("001089", "数据异常"));
        //    return;
        //}
        string           orderId     = args[0];//报单ID
        MemberOrderModel mOrderModel = new MemberOrderModel();
        MemberInfoModel  mInfoModel  = null;

        if (args[5].Trim() == "1")
        {
            MemberOrderAgainBLL memberOrderAgainBLL = new MemberOrderAgainBLL();
            memberOrderAgainBLL.WriterDataToPage(mOrderModel, args[6], args[0]);
        }
        else
        {
            mInfoModel = new MemberInfoModel();
            AddOrderBLL AddOrderBLL = new AddOrderBLL();
            AddOrderBLL.GetDataFormInfoAndOrder(args[1], int.Parse(args[4]), args[6], mInfoModel, mOrderModel);
        }
        if (mOrderModel == null)
        {
            ScriptHelper.SetAlert(Page, this.GetTran("001784", "当前报单已经不存在"));
            return;
        }
        string number         = args[1];
        string defrayname     = args[2];
        string payStatus      = args[3];
        string orderExpectNum = args[4];
        string isagain        = args[5].ToString();
        string storeId        = args[6].ToString();
        string SqlCon         = DAL.DBHelper.connString;

        if (e.CommandName == "OK")
        {
            int selectIndex = ((GridViewRow)((LinkButton)e.CommandSource).NamingContainer).RowIndex;
            Permissions.CheckManagePermission(Model.Other.EnumCompanyPermission.BalanceBrowseMemberOrdersEdit);
            if (payStatus == "0")
            {
                if (mOrderModel.IsAgain == 0)
                {
                    string info = MemberOrderAgainBLL.AuditingOrder((sender as LinkButton).CommandArgument.ToString());
                    if (info == "")
                    {
                        ScriptHelper.SetAlert(Page, "支付成功!");
                        btnSearch_Click(null, null);
                    }
                    else
                    {
                        ScriptHelper.SetAlert(Page, info);
                    }
                }
                else if (mOrderModel.IsAgain == 1)
                {
                    string info = MemberOrderAgainBLL.AuditingOrder((sender as LinkButton).CommandArgument.ToString());
                    if (info == "")
                    {
                        ScriptHelper.SetAlert(Page, "支付成功!");
                        btnSearch_Click(null, null);
                    }
                    else
                    {
                        ScriptHelper.SetAlert(Page, info);
                    }
                }
                else
                {
                    ScriptHelper.SetAlert(Page, this.GetTran("001786", "当前报单是否复销类型不正确."));
                    return;
                }
            }
            else
            {
                ScriptHelper.SetAlert(Page, this.GetTran("001789", "已经确认过的报单单不可再确认."));
                return;
            }
            btnSearch_Click(null, null);
        }
        else if (e.CommandName == "M")
        {
            if (payStatus == "0")
            {
                Response.Redirect("../RegisterUpdate1.aspx?OrderID=" + orderId + "&Number=" + number + "&CssType=3&storeId=" + storeId);
                //对未支付报单
                if (isagain == "0") //未确认注册修改
                {
                    Response.Redirect("../RegisterUpdate1.aspx?OrderID=" + orderId + "&Number=" + number + "&CssType=3&storeId=" + storeId);
                }
                else if (isagain == "1")          //未确认复销修改
                {
                    Response.Redirect("MemberOrderAgain.aspx?mode=edit&orderId=" + orderId + "&ordertype=" + mOrderModel.OrderType + "&flag=0&number=" + number + "&StoreID=" + storeId);
                }
                else
                {
                    return;
                }
            }
            else
            {
                ScriptHelper.SetAlert(Page, this.GetTran("000000", "无法对已支付的报单进行修改!"));
            }
        }
        else if (e.CommandName == "D")
        {
            //if (payStatus == "0")
            //{

            if (isagain == "0")
            {
                Application.Lock();
                //注册报单删除
                string result = bll.DelMembersDeclaration(number, mInfoModel.ExpectNum, orderId, mOrderModel.StoreId, Convert.ToDouble(mOrderModel.LackProductMoney));
                //返回null标识没有产生错误
                Application.UnLock();
                if (result == null)
                {
                    result = this.GetTran("000008", "删除成功");
                }
                ScriptHelper.SetAlert(Page, result);
            }
            else if (isagain == "1")
            {
                Application.Lock();
                string result = viewFuXiaoBLL.DelOredrAgain(orderId, double.Parse(mOrderModel.TotalPv.ToString()), number, mOrderModel.OrderExpect, mOrderModel.StoreId);
                Application.UnLock();
                if (result == null)
                {
                    result = this.GetTran("000008", "删除成功");
                }
                ScriptHelper.SetAlert(Page, result);
            }
            btnSearch_Click(null, null);
            //}
            //else
            //{



            //   // ScriptHelper.SetAlert(Page, this.GetTran("000000", "无法删除已支付的报单!"));
            //}
            //btnSearch_Click(null, null);
        }


        else if (e.CommandName == "E")
        {
            if (payStatus == "1")
            {
                string         sql  = @"UPDATE memberorder SET isSend = 1  WHERE OrderID = @orderId";
                SqlParameter[] para =
                {
                    new SqlParameter("@orderId", orderId)
                };
                int idd = DBHelper.ExecuteNonQuery(sql, para, CommandType.Text);
                if (idd == 1)
                {
                    ScriptHelper.SetAlert(Page, "发货成功!");
                }
                else
                {
                    ScriptHelper.SetAlert(Page, "发货失败!");
                }
            }
            else
            {
                ScriptHelper.SetAlert(Page, this.GetTran("000000", "未付款的报单没法发货!"));
            }
            btnSearch_Click(null, null);
        }
    }