Esempio n. 1
0
    protected void Page_Load(object sender, EventArgs e)
    {
        Permissions.ComRedirect(Page, Permissions.redirUrl);
        Response.Cache.SetExpires(DateTime.Now);
        Permissions.CheckManagePermission(EnumCompanyPermission.BalanceDetialQuery);

        Response.Cache.SetExpires(DateTime.Now);

        if (!IsPostBack)
        {
            this.Panel1.Style.Add("display", "none");

            //绑定货币
            if (Session["Default_Currency"] == null)
            {
                Session["Default_Currency"] = "";
            }


            CommonDataBLL.BindCurrency_IDListBZ(this.DropCurrency, Session["Default_Currency"].ToString());

            double dpCurrency = AjaxClass.GetCurrency(Convert.ToInt32(DropCurrency.SelectedValue), Convert.ToInt32(DropCurrency.SelectedValue));

            Session["rate"] = dpCurrency;
            getTypeBind(Session["Company"].ToString());
            coll();
        }
        Translations();
    }
Esempio n. 2
0
    protected void Page_Load(object sender, EventArgs e)
    {
        bzCurrency = CommonDataBLL.GetStandard();
        huilv      = (AjaxClass.GetCurrency(Convert.ToInt32(bzCurrency), Convert.ToInt32(Session["Default_Currency"].ToString())));
        var hkid = Request.QueryString["hkid"];
        var hybh = Session["Member"].ToString();

        if (!IsPostBack)
        {
            //获取标准币种

            //string dt_one = "select w.id,w.hkid, w.bankcard,w.bankname,w.shenHestate,w.WithdrawMoney,m.name,w.auditingtime from memberinfo m, withdraw w,remittances r where m.Number=w.number and w.hkid=r.ID and (w.shenhestate=11 or w.shenhestate=2) order by auditingtime desc";
            //DataTable dt = DAL.DBHelper.ExecuteDataTable(dt_one);
            //Hkid.Value = hkid;
            //rep_km.DataSource = dt;
            //rep_km.DataBind();

            string dt_one = "select * from (select w.id,w.hkid,w.bankcard,w.bankname,w.shenHestate,w.WithdrawMoney,m.name,RemittancesDate,w.auditingtime,m.Number from memberinfo m, withdraw w,remittances r where m.Number = w.number and w.hkid = r.ID and  (w.shenhestate=11 or w.shenhestate=2)   and m.Number!='" + hybh + "' and r.RemitNumber='" + hybh + "' union select id,ID as hkid,ImportNumber as bankcard,ImportBank as bankname,shenhestate,RemitMoney as WithdrawMoney,name,RemittancesDate,ReceivablesDate as auditingtime,RemitNumber as Number from Remittances where isjl = 1 and  (shenhestate=11 or shenhestate=2) and RemitNumber='" + hybh + "'  ) as t order by auditingtime desc";
            //
            DataTable dt = DAL.DBHelper.ExecuteDataTable(dt_one);
            Hkid.Value = hkid;
            var count = dt.Rows.Count;
            rep_km.DataSource = dt;
            rep_km.DataBind();
        }
    }
Esempio n. 3
0
 public AjaxClass CheckUid(string uid)
 {
     AjaxClass ajaxClass = new AjaxClass();
     try
     {
         if (uid.Length < 8 || uid.Length > 20)
         {
             ajaxClass.Msg = "用户名长度为8-12个字符";
             ajaxClass.Result = 0;
         }
         else if (userbll.checkUser(uid))
         {
             ajaxClass.Msg = "该用户名已经被注册";
             ajaxClass.Result = 0;
         }
         else
         {
             ajaxClass.Msg = "格式正确";
             ajaxClass.Result = 1;
         }
     }
     catch
     {
         ajaxClass.Msg = "程序出现异常,请联系管理员";
         ajaxClass.Result = 0;
     }
     return ajaxClass;
 }
Esempio n. 4
0
 public AjaxClass CheckUid(string uid)
 {
     //return uid == "testuid" ? true : false;
     AjaxClass ajaxClass = new AjaxClass();
     try
     {
         if (uid == "testuid")
         {
             ajaxClass.Msg = "用户名已存在,请重新输入!";
             ajaxClass.Result = 0;
         }
         else if (uid.IndexOf("test") == -1)
         {
             ajaxClass.Msg = "用户名格式不正确,用户名必须包含test,请重新输入!";
             ajaxClass.Result = 0;
         }
         else
         {
             ajaxClass.Msg = "格式正确!";
             ajaxClass.Result = 1;
         }
     }
     catch
     {
         ajaxClass.Msg = "程序出现异常,请联系管理员!";
         ajaxClass.Result = 0;
     }
     return ajaxClass;
 }
Esempio n. 5
0
    //绑定信息
    public void readInfo()
    {
        MemberInfoModel memberInfoModel = MemberInfoModifyBll.getMemberInfo(Session["Member"].ToString());


        DataTable dt = DetialQueryBLL.GetMemberInfoBalanceByNumber(ExpectNum, Session["Member"].ToString());

        if (dt.Rows.Count > 0)
        {
            lblNewPeople.Text = dt.Rows[0]["CurrentNewNetNum"].ToString();
            if (AjaxClass.GetCurrency(Convert.ToInt32(bzCurrency), Convert.ToInt32(Session["Default_Currency"].ToString())) == 0)
            {
                lblNewYeji.Text         = "0.00";
                lblTotalYeji.Text       = "0.00";
                lblCurrentOneMark2.Text = "0.00";
                lblTotalOneMark2.Text   = "0.00";
            }
            else
            {
                lblNewYeji.Text         = (double.Parse(dt.Rows[0]["CurrentTotalNetRecord"].ToString())).ToString("0.00");
                lblTotalYeji.Text       = (double.Parse(dt.Rows[0]["TotalNetRecord"].ToString())).ToString("0.00");
                lblCurrentOneMark2.Text = (double.Parse(dt.Rows[0]["CurrentOneMark2"].ToString())).ToString("0.00");
                lblTotalOneMark2.Text   = (double.Parse(dt.Rows[0]["TotalOneMark2"].ToString())).ToString("0.00");
            }
            lblTotalPeople.Text = dt.Rows[0]["TotalNetNum"].ToString();
        }
    }
Esempio n. 6
0
    protected void Page_Load(object sender, EventArgs e)
    {
        Permissions.MemRedirect(Page, Permissions.redirUrl);
        //检查店铺权限
        Response.Cache.SetExpires(DateTime.Now);
        // Permissions.CheckMemberPermission();//检测是否已登录
        int bzCurrency = CommonDataBLL.GetStandard();

        if (!IsPostBack)
        {
            if (Request.QueryString["byy"] != null)
            {
                double currency = AjaxClass.GetCurrency(int.Parse(Session["Default_Currency"] == null ? bzCurrency.ToString() : Session["Default_Currency"].ToString()));
                ViewState["url"] = Request.UrlReferrer.ToString();
                string orderid = Request.QueryString["orderId"];
                if (orderid.Length > 0)
                {
                    BindData(orderid);
                }

                BLL.Registration_declarations.MemberOrderBLL memberOrderBLL = new BLL.Registration_declarations.MemberOrderBLL();
                DataTable dt = memberOrderBLL.GetMemberByOrderID1(orderid, currency);

                gvorder.DataSource = dt;
                gvorder.DataBind();
            }
        }
        Transllations();
    }
Esempio n. 7
0
    public string GetLiuLanPro(string oType)
    {
        oType = Session["LUOrder"].ToString().Split(',')[1];

        int mType1 = 0;

        if (HttpContext.Current.Session["Company"] != null)
        {
            mType1 = 1;
        }
        else if (HttpContext.Current.Session["Store"] != null)
        {
            mType1 = 2;
        }
        else if (HttpContext.Current.Session["Member"] != null)
        {
            mType1 = 3;
        }
        string number = "";

        if (Session["mbreginfo"] == null)
        {
            number = ((Model.MemberInfoModel)Session["fxMemberModel"]).Number;
        }
        else
        {
            number = ((Model.MemberInfoModel)Session["mbreginfo"]).Number;
        }
        string sql = "select top 7 * from MemShopCart,product where MemShopCart.proid=product.productid and memBh=@memBh and mType=@mType and odType=@odType  order by id desc";

        SqlParameter[] sp = new SqlParameter[] {
            new SqlParameter("@memBh", number),
            new SqlParameter("@mType", SqlDbType.Int),
            new SqlParameter("@odType", SqlDbType.Int)
        };
        sp[1].Value = mType1;
        sp[2].Value = Convert.ToInt32(oType);
        DataTable dt = DAL.DBHelper.ExecuteDataTable(sql, sp, CommandType.Text);

        System.Text.StringBuilder sb = new System.Text.StringBuilder();

        if (dt.Rows.Count == 0)
        {
            sb.Append("");
        }
        int    bzCurrency = CommonDataBLL.GetStandard();
        double currency   = AjaxClass.GetCurrency(int.Parse(Session["Default_Currency"] == null ? bzCurrency.ToString() : Session["Default_Currency"].ToString()));

        for (int i = 0; i < dt.Rows.Count; i++)
        {
            sb.Append(@" <div class='prcClassImg'><h6 class='pImages' style='margin-right: 30px;'><img src='" + FormatURL(dt.Rows[i]["ProductID"]) + "' width='64' height='54' /></h6> <ul>	<li><a href='#'>" + dt.Rows[i]["productname"].ToString() + "</a></li>"
                      + "<li><a href='#'>价格:" + (Convert.ToDouble(dt.Rows[i]["PreferentialPrice"]) * currency).ToString() + "</a></li> <li><a href='#'>PV:" + Convert.ToDouble(dt.Rows[i]["PreferentialPV"]).ToString() + "</a></li> </ul> <div style='clear:both'></div>  </div>");
            //            sb.Append(@"<dl>
            //              <dd><img src='" + FormatURL(dt.Rows[i]["ProductID"]) + "' width='55' height='55' /></dd><dt>" + dt.Rows[i]["productname"].ToString() + "<br />金额:¥" + Convert.ToDouble(dt.Rows[i]["PreferentialPrice"]).ToString("0.00") + "<br />PV:" + Convert.ToDouble(dt.Rows[i]["PreferentialPV"]).ToString("0.00") + "</dt></dl>");
        }

        return(sb.ToString());
    }
Esempio n. 8
0
    protected void Page_Load(object sender, EventArgs e)
    {
        //获取标准币种
        bzCurrency = CommonDataBLL.GetStandard();
        huilv      = (AjaxClass.GetCurrency(Convert.ToInt32(bzCurrency), Convert.ToInt32(Session["Default_Currency"].ToString())));
        string dt_one = "";
        var    hkid   = Request.QueryString["hkid"];
        var    hybh   = Session["Member"].ToString();
        var    time   = DateTime.Now.AddHours(-10);

        Hkid.Value = hkid;
        if (hybh == "8888888888")
        {
            dt_one = "select * from (select w.id,w.hkid,w.bankcard,w.bankname,w.shenHestate,w.WithdrawMoney,m.name,RemittancesDate,w.auditingtime,m.Number from memberinfo m, withdraw w,remittances r where m.Number = w.number and w.hkid = r.ID and w.shenhestate in(1, 3)and  m.Number!='" + hybh + "' and w.auditingtime>='" + time + "' union select id,ID as hkid,ImportNumber as bankcard,ImportBank as bankname,shenhestate,RemitMoney as WithdrawMoney,name,RemittancesDate,ReceivablesDate as auditingtime,RemitNumber as Number from Remittances where isjl = 1 and shenhestate in(1, 3) and ReceivablesDate>='" + time + "' ) as t order by auditingtime desc";
        }//
        else
        {
            dt_one = "select * from (select w.id,w.hkid,w.bankcard,w.bankname,w.shenHestate,w.WithdrawMoney,m.name,RemittancesDate,w.auditingtime,m.Number from memberinfo m, withdraw w,remittances r where m.Number = w.number and w.hkid = r.ID and w.shenhestate in(1, 3) and  m.Number!='" + hybh + "'  and   w.auditingtime>='" + time + "'    and  r.RemitNumber='" + hybh + "'  union select id,ID as hkid,ImportNumber as bankcard,ImportBank as bankname,shenhestate,RemitMoney as WithdrawMoney,name,RemittancesDate,ReceivablesDate as auditingtime,RemitNumber as Number from Remittances where isjl = 1 and shenhestate in(1, 3) and ReceivablesDate>='" + time + "'   ) as t order by auditingtime desc";
        }
        //3-16去掉时间限制,超时的也显示
        //

        DataTable dt    = DAL.DBHelper.ExecuteDataTable(dt_one);
        var       count = dt.Rows.Count;

        rep_km.DataSource = dt;
        rep_km.DataBind();



        //string sql1 = "select * from Withdraw where hkid='" + hkid + "'";
        //DataTable dt1 = DAL.DBHelper.ExecuteDataTable(sql1);


        //if (dt1.Rows.Count == 0)
        //{
        //    rep_km1.Visible = true;
        //    rep_km.Visible = false;
        //    dt_one = " select top(1)* from companybank  order by ID desc";
        //    DataTable dt = DAL.DBHelper.ExecuteDataTable(dt_one);
        //    rep_km1.DataSource = dt;
        //    rep_km1.DataBind();
        //}
        //else
        //{
        //    rep_km.Visible = true;
        //    rep_km1.Visible = false;
        //    dt_one = "select w.id,w.hkid,w.bankcard,w.bankname,w.shenHestate,w.WithdrawMoney,m.name,RemittancesDate,w.auditingtime from memberinfo m, withdraw w,remittances r where m.Number=w.number and w.hkid=r.ID and w.shenhestate=3 and w.auditingtime>='" + time + "' order by w.auditingtime  desc";
        //    DataTable dt = DAL.DBHelper.ExecuteDataTable(dt_one);
        //    rep_km.DataSource = dt;
        //    rep_km.DataBind();
        //}



        //this.ucPagerMb1.PageInit(dt_one, "rep_km");
    }
Esempio n. 9
0
    protected void button1_Click(object sender, EventArgs e)
    {
        int    cengshu = 0;
        string bianhao = "";

        if (this.txtbianhao.Text.Trim() == "")
        {
            Response.Write("<script>alert('请先填写网络起点ID!');</script>");
            return;
        }
        else
        {
            bianhao = this.txtbianhao.Text.Trim();
        }

        int  u    = Convert.ToInt32(Session["jgqs"]);
        bool flag = registermemberBLL.isNet(Session["jglx"].ToString(), Convert.ToString(Session["jgbh"]), getBH());

        // if (!Jiegou.isValid(Convert.ToString(Session["jgbh"]), getMemberBH(), isAnZhi(), Convert.ToInt32(Session["jgqs"])))
        if (flag == false)
        {
            Response.Write(GetTran("000892", "您不能查看该网络"));
            return;
        }

        if (this.txtceng.Text.Trim() == "")
        {
            cengshu = 3;
        }
        else
        {
            try
            {
                cengshu = Convert.ToInt32(this.txtceng.Text.Trim());
            }
            catch
            {
                Response.Write("<script>alert('" + GetTran("000897", "显示层数输入格式错误") + "!');</script>");
                return;
            }
        }

        string loginBh = GetLoginMember();
        int    bhCw    = AjaxClass.GetLogoutCw1(this.txtbianhao.Text.Trim(), Convert.ToInt32(this.dropdownlist_qishu.SelectedValue), true);
        int    loginCw = AjaxClass.GetLogoutCw1(loginBh, Convert.ToInt32(this.dropdownlist_qishu.SelectedValue), true);
        int    showCs  = AjaxClass.GetShowCengS1(0);

        if (showCs - (bhCw - loginCw) < cengshu)
        {
            cengshu = showCs - (bhCw - loginCw);
        }

        this.WangLuoTu(bianhao, "", Convert.ToInt32(ViewState["isanzhi"].ToString()), cengshu, Convert.ToInt32(dropdownlist_qishu.SelectedValue), "");

        //------------------------
        SetDaoHang();
    }
Esempio n. 10
0
    protected void Page_Load(object sender, EventArgs e)
    {
        //获取标准币种
        bzCurrency = CommonDataBLL.GetStandard();
        huilv      = (AjaxClass.GetCurrency(Convert.ToInt32(bzCurrency), Convert.ToInt32(Session["Default_Currency"].ToString())));
        if (!this.IsPostBack)
        {
            var HkID       = Request.QueryString["HkID"];
            var bishu      = Request.QueryString["bishu"];
            var RemitMoney = (Convert.ToDouble(Request.QueryString["RemitMoney"]) * huilv).ToString("f2");
            int bishu1     = int.Parse(bishu);
            rmoney.Text   = RemitMoney;
            rmoney1.Value = RemitMoney;
            hkid.Value    = HkID;
            DataTable dt = null;// RemittancesBLL.jinliucx(HkID);
            bishucount.Text = (dt.Rows.Count).ToString();

            string    sm      = "select describe from JLparameter where jlcid=8";
            DataTable sm2     = DAL.DBHelper.ExecuteDataTable(sm);
            var       shuomin = sm2.Rows[0]["describe"].ToString();
            Label2.Text = shuomin;


            if (bishucount.Text == "0")
            {
                bishucount.Text = "1";

                string    dt_one1 = "update Remittances set Ispipei=1 where ID=" + HkID;
                DataTable dt3     = DAL.DBHelper.ExecuteDataTable(dt_one1);

                DataTable dt_one3        = DAL.DBHelper.ExecuteDataTable("select * from remittances where ID=" + HkID);
                string    RemittancesID  = dt_one3.Rows[0]["RemittancesID"].ToString(); //汇款单号
                string    RemBankBook    = dt_one3.Rows[0]["ImportNumber"].ToString();  //汇款单号
                string    RemBankname    = dt_one3.Rows[0]["name"].ToString();          //汇款单号
                string    RemBankaddress = dt_one3.Rows[0]["ImportBank"].ToString();    //汇款单号
                RemittancesDAL.WithdrawMoney(Session["Member"].ToString(), Convert.ToDouble(RemitMoney) / huilv, RemittancesID, RemBankBook, RemBankname, RemBankaddress);

                string    dt_one = "select top(1) * from companybank order by ID desc";
                DataTable dt2    = DAL.DBHelper.ExecuteDataTable(dt_one);
                rep_km.Visible     = false;
                rep_km1.Visible    = true;
                rep_km1.DataSource = dt2;
                rep_km1.DataBind();
            }
            else
            {
                rep_km1.Visible   = false;
                rep_km.Visible    = true;
                rep_km.DataSource = dt;
                rep_km.DataBind();
            }
            Translations();
        }
    }
Esempio n. 11
0
    /*-------------------------------------------------------------------------------------------------------------------------------------------------------*/
    public void readBonus()
    {
        int       maxqs   = BLL.CommonClass.CommonDataBLL.GetMaxqishu();
        double    curreny = AjaxClass.GetCurrency(Convert.ToInt32(bzCurrency), Convert.ToInt32(Session["Default_Currency"].ToString()));
        DataTable dt      = MemberInfoModifyBll.getBonusTable(maxqs, Session["Member"].ToString());//第一个参数期数

        if (dt.Rows.Count > 0)
        {
            if (curreny == 0)
            {
                //this.Label1.Text = "0";
                this.Label1.Text  = "0";
                this.Label2.Text  = "0";
                this.Label3.Text  = "0";
                this.Label4.Text  = "0";
                this.Label5.Text  = "0";
                this.Label6.Text  = "0";
                this.Label7.Text  = "0";
                this.Label8.Text  = "0";
                this.Label9.Text  = "0";
                this.Label10.Text = "0";
            }
            else
            {
                //this.Label1.Text = (Convert.ToDouble(dt.Rows[0]["Bonus0"]) / AjaxClass.GetCurrency(Convert.ToInt32(bzCurrency), Convert.ToInt32(Session["Default_Currency"].ToString()))).ToString("0.00");
                this.Label1.Text = (Convert.ToDouble(dt.Rows[0]["Bonus1"]) *
                                    AjaxClass.GetCurrency(Convert.ToInt32(bzCurrency), Convert.ToInt32(Session["Default_Currency"].ToString()))).ToString("0.00");
                this.Label2.Text  = (Convert.ToDouble(dt.Rows[0]["Bonus2"]) * curreny).ToString("0.00");
                this.Label3.Text  = (Convert.ToDouble(dt.Rows[0]["Bonus3"]) * curreny).ToString("0.00");
                this.Label4.Text  = (Convert.ToDouble(dt.Rows[0]["Bonus4"]) * curreny).ToString("0.00");
                this.Label5.Text  = (Convert.ToDouble(dt.Rows[0]["Bonus5"]) * curreny).ToString("0.00");
                this.Label6.Text  = (Convert.ToDouble(dt.Rows[0]["Kougl"]) * curreny).ToString("0.00");
                this.Label7.Text  = (Convert.ToDouble(dt.Rows[0]["Koufl"]) * curreny).ToString("0.00");
                this.Label8.Text  = (Convert.ToDouble(dt.Rows[0]["Koufx"]) * curreny).ToString("0.00");
                this.Label9.Text  = (Convert.ToDouble(dt.Rows[0]["CurrentSolidSend"]) * curreny).ToString("0.00");
                this.Label10.Text = (Convert.ToDouble(dt.Rows[0]["CurrentSolidSend"]) * curreny).ToString("0.00");
            }
        }
        else
        {
            //this.Label1.Text = "0.00";
            this.Label1.Text  = "0.00";
            this.Label2.Text  = "0.00";
            this.Label3.Text  = "0.00";
            this.Label4.Text  = "0.00";
            this.Label5.Text  = "0.00";
            this.Label6.Text  = "0.00";
            this.Label7.Text  = "0.00";
            this.Label8.Text  = "0.00";
            this.Label9.Text  = "0.00";
            this.Label10.Text = "0.00";
        }
    }
Esempio n. 12
0
 protected void Page_Load(object sender, EventArgs e)
 {
     //获取标准币种
     bzCurrency = CommonDataBLL.GetStandard();
     huilv      = (AjaxClass.GetCurrency(Convert.ToInt32(bzCurrency), Convert.ToInt32(Session["Default_Currency"].ToString())));
     if (!this.IsPostBack)
     {
         var hkmoney = (Convert.ToDouble(Request.QueryString["hkmoney"]) * huilv).ToString();
         //HkTime.Text = (DateTime.Now).ToString();
         Money.Text = Math.Round(double.Parse(hkmoney)).ToString("#0.00");
     }
 }
Esempio n. 13
0
    protected void Page_Load(object sender, EventArgs e)
    {
        //获取标准币种
        bzCurrency = CommonDataBLL.GetStandard();
        huilv      = (AjaxClass.GetCurrency(Convert.ToInt32(bzCurrency), Convert.ToInt32(Session["Default_Currency"].ToString())));
        var       id     = Request.QueryString["id"];
        string    dt_one = "select * from Withdraw where shenhestate=11 and HkDj=1 and IsJL=1 and HkKhname is not  null and id=" + id;
        DataTable dt     = DAL.DBHelper.ExecuteDataTable(dt_one);

        rep_km.DataSource = dt;
        rep_km.DataBind();
    }
Esempio n. 14
0
    protected void Page_Load(object sender, EventArgs e)
    {
        //获取标准币种
        bzCurrency = CommonDataBLL.GetStandard();
        huilv      = (AjaxClass.GetCurrency(Convert.ToInt32(bzCurrency), Convert.ToInt32(Session["Default_Currency"].ToString())));
        var       hybh   = Session["Member"].ToString();
        string    dt_one = "select id,hkid,Khname,bankcard,bankname,shenHestate,Ppje,WithdrawTime from withdraw where shenhestate=20 and IsJL=1 and number='" + hybh + "' order by WithdrawTime desc";//and HkDj=1 and TxDj=1
        DataTable dt     = DAL.DBHelper.ExecuteDataTable(dt_one);

        rep_km.DataSource = dt;
        rep_km.DataBind();
    }
Esempio n. 15
0
    protected void Page_Load(object sender, EventArgs e)
    {
        //获取标准币种
        bzCurrency = CommonDataBLL.GetStandard();
        huilv      = (AjaxClass.GetCurrency(Convert.ToInt32(bzCurrency), Convert.ToInt32(Session["Default_Currency"].ToString())));
        var       id     = Request.QueryString["id"];
        string    dt_one = "select * from Withdraw where  id=" + id;
        DataTable dt     = DAL.DBHelper.ExecuteDataTable(dt_one);

        Image1.ImageUrl = "../hkpzimg/" + dt.Rows[0]["hkpzImglj"].ToString();
        //rep_km.DataSource = dt;
        //rep_km.DataBind();
    }
Esempio n. 16
0
    protected string GetWithdrawMoney(string WithdrawMoney)
    {
        string money = "";

        if (AjaxClass.GetCurrency(Convert.ToInt32(bzCurrency), Convert.ToInt32(Session["Default_Currency"].ToString())) == 0)
        {
            money = "0.00";
        }
        else
        {
            money = (double.Parse(WithdrawMoney) * AjaxClass.GetCurrency(Convert.ToInt32(bzCurrency), Convert.ToInt32(Session["Default_Currency"].ToString()))).ToString("f2");
        }
        return(money);
    }
Esempio n. 17
0
        public static string GetScript(string className)
        {
            AjaxConfiguration config = AjaxConfiguration.GetConfig();
            AjaxClass         c      = config.FindClass(className);

            if (c == null)
            {
                return(string.Empty);
            }

            StringBuilder script = new StringBuilder();

            AppendClassScript(c, ref script);

            return(script.ToString());
        }
Esempio n. 18
0
    protected void Page_Load(object sender, EventArgs e)
    {
        //获取标准币种
        bzCurrency = CommonDataBLL.GetStandard();
        huilv      = (AjaxClass.GetCurrency(Convert.ToInt32(bzCurrency), Convert.ToInt32(Session["Default_Currency"].ToString())));
        var    hybh   = Session["Member"].ToString();
        var    hkid   = Request.QueryString["hkid"];
        string dt_one = "select id,hkid,Ppje,Khname,bankcard,bankname,shenHestate,WithdrawMoney,HkDj,hkpzImglj from withdraw where shenhestate in(2,11) and IsJL=1 and Khname is not  null and number='" + hybh + "' order by WithdrawTime desc";

        if (!IsPostBack)
        {
            DataTable dt = DAL.DBHelper.ExecuteDataTable(dt_one);
            rep_km.DataSource = dt;
            rep_km.DataBind();
        }
    }
Esempio n. 19
0
    protected void Page_Load(object sender, EventArgs e)
    {
        Permissions.MemRedirect(Page, Permissions.redirUrl);
        //获取标准币种
        bzCurrency = CommonDataBLL.GetStandard();
        huilv      = (AjaxClass.GetCurrency(Convert.ToInt32(bzCurrency), Convert.ToInt32(Session["Default_Currency"].ToString())));
        if (!IsPostBack)
        {
            if (Session["Default_Currency"] == null)
            {
                Session["Default_Currency"] = bzCurrency;
            }

            setStoreInfo();
            search_rsj();
            Translations();
        }
    }
Esempio n. 20
0
        private static void AppendClassScript(AjaxClass c, ref StringBuilder script)
        {
            script.AppendFormat("function {0}Class()", c.Id);
            script.Append("{};");
            script.AppendFormat("{0}Class.prototype=", c.Id);
            script.Append("{");

            for (int i = 0; i < c.Methods.Count; i++)
            {
                if (i > 0)
                {
                    script.Append(",");
                }

                AppendMethodScript(c.Id, c.Methods[i], ref script);
            }

            script.Append("};");
            script.AppendFormat("var {0}=new {0}Class();", c.Id);
        }
Esempio n. 21
0
        public static string GetScript(string className, string methodName)
        {
            AjaxConfiguration config = AjaxConfiguration.GetConfig();
            AjaxClass         c_old  = config.FindClass(className);
            AjaxMethod        m      = config.FindMethod(c_old, methodName);

            if (m == null)
            {
                return(string.Empty);
            }

            AjaxClass c = c_old.Clone() as AjaxClass;

            c.Methods.Add(m);

            StringBuilder script = new StringBuilder();

            AppendClassScript(c, ref script);

            return(script.ToString());
        }
Esempio n. 22
0
    //发送系统邮件
    public static bool SendSystemEmail(string sendnumber, string sendrole, string content, string recivenumber)
    {
        MessageSendModel messagesend = new MessageSendModel();

        //邮件保存
        messagesend.Content      = content;
        messagesend.DropFlag     = 0;
        messagesend.InfoTitle    = "系统邮件";
        messagesend.LoginRole    = "2";
        messagesend.ReadFlag     = 0;
        messagesend.Sender       = sendnumber;
        messagesend.SenderRole   = "2";
        messagesend.LanguageCode = "L001";
        messagesend.CountryCode  = "1";
        messagesend.MessageType  = 'm';
        messagesend.Receive      = recivenumber;
        messagesend.SetNoCondition();
        bool bb = MessageSendBLL.Addsendaffiche(messagesend);

        HttpContext.Current.Session["EmailCount"] = AjaxClass.GetNewEmailCount( );
        return(bb);
    }
Esempio n. 23
0
    /// <summary>
    /// GridView行处理事件
    /// </summary>
    /// <param name="sender"></param>
    /// <param name="e"></param>
    protected void gv_browOrder_RowDataBound(object sender, GridViewRowEventArgs e)
    {
        if (e.Row.RowType == DataControlRowType.DataRow)
        {
            e.Row.Attributes.Add("onmouseover", "bg=this.style.backgroundColor;this.style.backgroundColor='#FFFFCC'");
            e.Row.Attributes.Add("onmouseout", "this.style.backgroundColor=bg");

            Label lblTotalMoney = e.Row.FindControl("lblTotalMoney") as Label;

            if (AjaxClass.GetCurrency(Convert.ToInt32(bzCurrency), Convert.ToInt32(Session["Default_Currency"].ToString())) == 0)
            {
                lblTotalMoney.Text = "0.00";
            }
            else
            {
                lblTotalMoney.Text = (Convert.ToDouble(lblTotalMoney.Text) * AjaxClass.GetCurrency(Convert.ToInt32(bzCurrency), Convert.ToInt32(Session["Default_Currency"].ToString()))).ToString("f2");
            }
        }
        else if (e.Row.RowType == DataControlRowType.Header)
        {
        }
    }
Esempio n. 24
0
    protected void gvorder_RowDataBound(object sender, GridViewRowEventArgs e)
    {
        if (e.Row.RowType == DataControlRowType.DataRow)
        {
            e.Row.Attributes.Add("onmouseover", "currentcolor=this.style.backgroundColor;this.style.backgroundColor='#FFFFCC'");
            e.Row.Attributes.Add("onmouseout", "this.style.backgroundColor=currentcolor");
            DataRowView drv         = (DataRowView)e.Row.DataItem;
            string      defrayType  = drv["defraytype"].ToString();
            string      defrayState = drv["zhifu"].ToString();
            string      OrderID     = drv["OrderID"].ToString();
            string      expectNum   = drv["OrderExpectNum"].ToString();
            double      totalmoney  = Convert.ToDouble(drv["totalmoney"]);


            double totalcomm = 0;
            double zongMoney = totalcomm + totalmoney;

            ImageButton LinkPM        = (ImageButton)e.Row.FindControl("HyperLinkPayMent");
            ImageButton linkbtnModify = (ImageButton)e.Row.FindControl("linkbtnModify");
            ImageButton linkbtnDelete = (ImageButton)e.Row.FindControl("linkbtnDelete");

            Label lblTotalMoney = e.Row.FindControl("lblTotalMoney") as Label;

            if (AjaxClass.GetCurrency(Convert.ToInt32(bzCurrency), Convert.ToInt32(Session["Default_Currency"].ToString())) == 0)
            {
                lblTotalMoney.Text = "0.00";
            }
            else
            {
                lblTotalMoney.Text = (Convert.ToDouble(lblTotalMoney.Text) * AjaxClass.GetCurrency(Convert.ToInt32(bzCurrency), Convert.ToInt32(Session["Default_Currency"].ToString()))).ToString("f2");
            }
        }
        else if (e.Row.RowType == DataControlRowType.Header)
        {
            Transllations();
        }
    }
Esempio n. 25
0
 protected void givStoreInfo_RowDataBound(object sender, GridViewRowEventArgs e)
 {
     if (e.Row.RowType == DataControlRowType.DataRow)
     {
         int curr = Convert.ToInt32(DBHelper.ExecuteScalar("select rate from Currency where id=standardMoney"));
         e.Row.Attributes.Add("onmouseover", "bg=this.style.backgroundColor;this.style.backgroundColor='#FFFFCC'");
         e.Row.Attributes.Add("onmouseout", "this.style.backgroundColor=bg");
         Label  lab = (Label)e.Row.FindControl("StoreLevelInt");
         string l   = DBHelper.ExecuteScalar("select levelstr from bsco_level where levelflag=1 and levelint = " + Convert.ToInt32(lab.Text.ToString()) + "").ToString();
         lab.Text            = l.ToString();
         e.Row.Cells[3].Text = Encryption.Encryption.GetDecipherName(e.Row.Cells[3].Text.ToString());
         e.Row.Cells[4].Text = Encryption.Encryption.GetDecipherName(e.Row.Cells[4].Text.ToString());
         e.Row.Cells[8].Text = Encryption.Encryption.GetDecipherName(e.Row.Cells[8].Text.ToString());
         if (AjaxClass.GetCurrency(curr, Convert.ToInt32(DropCurrency.SelectedValue)) == 0)
         {
             e.Row.Cells[5].Text = "0";
         }
         else
         {
             e.Row.Cells[5].Text = (Convert.ToDouble(e.Row.Cells[5].Text) * AjaxClass.GetCurrency(curr, Convert.ToInt32(DropCurrency.SelectedValue))).ToString("f2");
         }
     }
     Translations();
 }
Esempio n. 26
0
    protected void Page_Load(object sender, EventArgs e)
    {
        if (Session["Store"] != null)
        {
            Literal1.Text = "<a href='../Store/First.aspx'>我的首页</a><a href='../Store/auditingmemberorders.aspx'>注册确认</a><a href='../Store/auditingmemberagain.aspx'>复消确认</a><a href='../Store/CheckOutOrders.aspx'>订单支付</a><a href='../Store/ViewAccountCircs.aspx'>充值浏览</a><a href='../Logout.aspx'>退出系统</a>";
        }
        if (Session["Member"] != null)
        {
            Literal1.Text = "<a href='../Member/First.aspx'>我的首页</a><a href='../Member/AuditingMemberOrder.aspx'>报单支付</a><a href='../Member/ResultBrowse.aspx'>充值浏览</a><a href='../Logout.aspx'>退出系统</a>";
        }

        //获取标准币种
        bzCurrency = CommonDataBLL.GetStandard();
        if (!IsPostBack)
        {
            double currency = AjaxClass.GetCurrency(Convert.ToInt32(bzCurrency), Convert.ToInt32(Session["Default_Currency"].ToString()));
            if (Request.QueryString["ef"] != null)
            {
                string   ef    = EncryKey.Decrypt(Request.QueryString["ef"].ToUpper()).ToString();
                string   typ   = "";
                double   money = 0;
                string   bill  = "";
                string[] sf    = ef.Split(',');
                if (sf.Length >= 3)
                {
                    typ   = sf[0].ToString();
                    bill  = sf[1].ToString();
                    money = Convert.ToDouble(sf[2]);
                }
                else
                {
                    typ = ef;
                }
                string showinfo = "";

                switch (typ)
                {
                case "0":
                    //showinfo = GetTran("007512", "成功支付订单") + bill + " ," + GetTran("000789", "支付金额") + ":" + double.Parse(money.ToString("0.00")) / currency + GetTran("000564", "元");
                    showinfo = GetTran("007512", "成功支付订单") + bill + " ," + GetTran("000789", "支付金额") + ":" + double.Parse(money.ToString("0.00")) + GetTran("000564", "元");
                    break;

                case "1":
                    showinfo = GetTran("007513", "支付失败,订单已支付或订单号不存在");
                    break;

                case "2":
                    showinfo = GetTran("007514", "支付失败,账户可用余额不足");
                    break;

                case "3":
                    showinfo = GetTran("007515", "支付失败,账户类型不存在");
                    break;

                case "4":
                    showinfo = GetTran("007370", "未到账");
                    break;

                case "5":
                    showinfo = GetTran("007516", "支付失败,服务机构周转款不足");
                    break;

                case "6":
                    showinfo = GetTran("007517", "支付失败,服务机构订货款不足");
                    break;

                case "100":
                    //showinfo = GetTran("007518", "请您务必在 24 小时内完成向指定账户汇款") + double.Parse(money.ToString("0.00")) / currency + GetTran("000564", "元") + "," + GetTran("007519", "否则将视为您自动放弃汇款");
                    showinfo = GetTran("007518", "请您务必在 24 小时内完成向指定账户汇款") + double.Parse(money.ToString("0.00")) + GetTran("000564", "元") + "," + GetTran("007519", "否则将视为您自动放弃汇款");
                    break;

                case "101":
                    //showinfo = GetTran("007520", "请将") + bill + GetTran("007521", "订单款额") + double.Parse(money.ToString("0.00")) / currency + GetTran("000564", "元") + GetTran("007522", "交给您的购货店铺,并要求其为您支付订单");
                    showinfo = GetTran("007520", "请将") + bill + GetTran("007521", "订单款额") + double.Parse(money.ToString("0.00")) + GetTran("000564", "元") + GetTran("007522", "交给您的购货店铺,并要求其为您支付订单");
                    break;

                default:
                    showinfo = GetTran("007523", "未知错误");
                    break;
                }

                lblinfo.Text = showinfo;
            }
        }
    }
Esempio n. 27
0
    /// <summary>
    /// 转账
    /// </summary>
    /// <param name="sender"></param>
    /// <param name="e"></param>
    protected void btnE_Click(object sender, EventArgs e)
    {
        //设置特定值防止重复提交
        hid_fangzhi.Value = "0";

        //判断会员账户是否被冻结
        if (MemberInfoDAL.CheckState(Session["Member"].ToString()))
        {
            Page.ClientScript.RegisterStartupScript(GetType(), null, "<script language='javascript'>alert('您的账户被冻结,不能使用电子转账');window.location.href='First.aspx';</script>"); return;
        }

        ECTransferDetailModel detailmodel = new ECTransferDetailModel();

        try {
            //验证金额是否合法
            double money = 0.0;
            if (!double.TryParse(this.txtEmoney.Text.Trim(), out money))
            {
                ClientScript.RegisterStartupScript(this.GetType(), "", "<script>alert('金额必须是数字,请重新输入!');</script>");
                return;
            }
            //验证是否输入金额
            if (this.txtEmoney.Text.Length <= 0 || money <= 0)
            {
                ClientScript.RegisterStartupScript(this.GetType(), "", "<script>alert('转出金额必须大于0!');</script>");
                return;
            }
            //验证输入金额是否是10的倍数
            decimal mony = Convert.ToDecimal(this.txtEmoney.Text);
            if (mony % 10 != 0)
            {
                ClientScript.RegisterStartupScript(this.GetType(), "", "<script>alert('转出金额必须是10的倍数');</script>");
                return;
            }
            double Cash         = 0; //可用FTC账户
            double Declarations = 0; //消费账户
            ECRemitDetailBLL.GetCashDeclarations(Session["Member"].ToString(), out Cash, out Declarations);
            int       level2 = 0;
            double    djq    = 0;
            string    ssql   = "select level2,fuxiaoin-fuxiaoout+fuxiaothin-fuxiaothout as djq from MemberInfoBalance" + CommonDataBLL.getMaxqishu() + " a ,MemberInfo b where  a.number=b.Number and a.number='" + Session["Member"].ToString() + "'";
            DataTable dts    = DAL.DBHelper.ExecuteDataTable(ssql);
            if (dts.Rows.Count > 0)
            {
                level2 = Convert.ToInt16(dts.Rows[0]["Level2"].ToString());
                djq    = Convert.ToDouble(dts.Rows[0]["djq"].ToString());
            }
            double jdjy = 0;

            if (level2 > 0)
            {
                if (Convert.ToDouble(Cash) + djq > 30000)
                {
                    jdjy = (Convert.ToDouble(Cash) + djq) - 30000;
                    if (jdjy > Convert.ToDouble(Cash))
                    {
                        jdjy = Convert.ToDouble(Cash);
                    }
                }
                else
                {
                    jdjy = 0;
                }
                Cash = jdjy;
            }
            //验证转账金额最大值
            if (RadioButtonList1.SelectedValue == "1" && money > Cash)
            {
                ClientScript.RegisterStartupScript(this.GetType(), "", "<script>alert('转出金额必须小于当前FTC可用账户最大可转金额!');</script>");
                return;
            }
            else if (RadioButtonList1.SelectedValue == "3" && money > Declarations)
            {
                ClientScript.RegisterStartupScript(this.GetType(), "", "<script>alert('" + GetTran("000000", "转出金额必须小于当前消费账户最大可转金额!") + "');</script>");
                return;
            }
            else if (RadioButtonList1.SelectedValue == "2")
            {
                double    bd  = 0;
                string    sql = "select pointBIn-pointBOut as bd from MemberInfo where number='" + Session["Member"].ToString() + "'";
                DataTable shj = DBHelper.ExecuteDataTable(sql);
                if (shj.Rows.Count > 0)
                {
                    bd = Convert.ToDouble(shj.Rows[0][0].ToString());
                    if (money > bd)
                    {
                        ClientScript.RegisterStartupScript(this.GetType(), "", "<script>alert('" + GetTran("000000", "转出金额必须小于当前报单账户最大可转金额!") + "');</script>");
                        return;
                    }
                }
            }
            else if (RadioButtonList1.SelectedValue == "4")
            {
                double    bd  = 0;
                double    xj  = 0;
                string    sql = "select zzye-xuhao as bd,Jackpot-Out as xj from MemberInfo where number='" + Session["Member"].ToString() + "'";
                DataTable shj = DBHelper.ExecuteDataTable(sql);
                if (shj.Rows.Count > 0)
                {
                    bd = Convert.ToDouble(shj.Rows[0][0].ToString());
                    xj = Convert.ToDouble(shj.Rows[0][1].ToString());
                    if (money > bd)
                    {
                        ClientScript.RegisterStartupScript(this.GetType(), "", "<script>alert('" + GetTran("000000", "转出金额必须小于当前保险账户最大可转金额!") + "');</script>");
                        return;
                    }
                    if (xj > 10)
                    {
                        ClientScript.RegisterStartupScript(this.GetType(), "", "<script>alert('" + GetTran("000000", "可用FTC使用完才可以操作保险账户转账!") + "');</script>");
                        return;
                    }
                }
            }
            string number = "";
            if (RadioButtonList1.SelectedValue == "1" || RadioButtonList1.SelectedValue == "4")
            {
                string    sql = "select number from MemberInfo where MobileTele='" + txt_InNumber.Text + "'";
                DataTable shj = DBHelper.ExecuteDataTable(sql);
                if (shj.Rows.Count > 0)
                {
                    number = shj.Rows[0][0].ToString();
                }
                else
                {
                    ClientScript.RegisterStartupScript(this.GetType(), "", "<script>alert('无此编号,请检查后再重新输入111!')</script>");
                    return;
                }


                string GetError1 = new AjaxClass().CheckNumberNetTui(number, lbEnum.Text.Trim());
                string GetError2 = new AjaxClass().CheckNumberNetTui(lbEnum.Text.Trim(), number);

                if (RadioButtonList1.SelectedValue == "1" && ((GetError1 != null && GetError1 != "") && (GetError2 != null && GetError2 != "")))
                {
                    ClientScript.RegisterStartupScript(this.GetType(), "", "<script>alert('可用FTC只能转给同一网络下的用户!');</script>", false);
                    return;
                }
                if (RadioButtonList1.SelectedValue == "4" && ((GetError1 != null && GetError1 != "") && (GetError2 != null && GetError2 != "")))
                {
                    ClientScript.RegisterStartupScript(this.GetType(), "", "<script>alert('可用FTC只能转给同一网络下的用户!');</script>", false);
                    return;
                }
                //验证转入编号
                if (number == "")
                {
                    ScriptHelper.SetAlert(Page, "编号不能为空!");
                    return;
                }
            }
            else
            {
                number = Session["Member"].ToString();
            }


            string lll  = Request.Form["rad_Inzh"];
            string llll = rad_Outzh.SelectedValue;
            //验证会员是否自己给自己转入现金账户
            if (txt_InNumber.Text.Trim() == lbEnum.Text.Trim() && RadioButtonList1.SelectedValue == "1")
            {
                ScriptHelper.SetAlert(Page, "自己不能转入自己的FTC账户");
                return;
            }
            //验证会员是否自己给自己转入消费账户
            //if (txt_InNumber.Text.Trim() == lbEnum.Text.Trim() && RadioButtonList1.SelectedValue == "3")
            //{
            //    ScriptHelper.SetAlert(Page, GetTran("000000", "自己不能转入自己的消费积分账户"));
            //    return;
            //}

            //验证会员转入账户是否服务机构订货款和转入编号是否服务机构编号
            //if (Request.Form["rad_Inzh"] == "2" && (int)DAL.DBHelper.ExecuteScalar("select count(0) as count from storeinfo where storeid= '" + txt_InNumber.Text.Trim() + "'") <= 0)
            //{
            //    ScriptHelper.SetAlert(Page, GetTran("007696", "转入服务机构订货款,转入编号必须是服务机构编号"));
            //    return;
            //}
            //else if (Request.Form["rad_Inzh"] != "2" && (int)DAL.DBHelper.ExecuteScalar("select count(0) as count from memberinfo where number= '" + txt_InNumber.Text.Trim() + "'") <= 0)
            //{
            //    ScriptHelper.SetAlert(Page, GetTran("007697", "转入编号不正确,请重新填写!"));
            //    return;
            //}

            //验证备注do
            if (this.txtEnote.Text.Length > 500)
            {
                ClientScript.RegisterStartupScript(this.GetType(), "", "<script>alert('您输入的字符超出最大范围!');</script>");
                return;
            }
            //验证密码 非空
            //if (this.txtEpwd.Text.Trim() == "")
            //{
            //    ClientScript.RegisterStartupScript(this.GetType(), "", "<script>alert('" + GetTran("006662", "请输入二级密码!") + "');</script>");
            //    return;
            //}

            ////验证电子账户密码是否正确
            //string word = Encryption.Encryption.GetEncryptionPwd(this.txtEpwd.Text.Trim(), this.lbEnum.Text.Trim());
            //int blean = ECRemitDetailBLL.ValidatePwd(Session["Member"].ToString(), word);
            //if (blean == 1)
            //{
            //    System.Web.UI.ScriptManager.RegisterStartupScript(Page, GetType(), "success2", "alert('" + GetTran("001554", "电子账户密码不正确!") + "');", true);
            //    return;
            //}
            //else if (blean == 2)
            //{
            //    System.Web.UI.ScriptManager.RegisterStartupScript(Page, GetType(), "success2", "alert('" + GetTran("007162", "对不起,您连续5次输入密码错,请2小时候在登录!") + "');", true);
            //    return;
            //}
            //是否收到款项
            if (!cboyishd.Checked)
            {
                ScriptHelper.SetAlert(Page, "请先确认是否收到该会员支付的上数金额!");
                return;
            }


            detailmodel.OutNumber = Session["Member"].ToString();
            detailmodel.OutMoney  = double.Parse(this.txtEmoney.Text.Trim());
            detailmodel.ExpectNum = CommonDataBLL.getMaxqishu();

            detailmodel.OperateIP     = CommonDataBLL.OperateIP;      // 获取ip
            detailmodel.OperateNumber = Session["Member"].ToString(); // 获取当前会员编号
            detailmodel.Remark        = this.txtEnote.Text.Trim();
            if (RadioButtonList1.SelectedValue == "1")
            {
                detailmodel.InNumber       = number;
                detailmodel.outAccountType = OutAccountType.MemberCash;
                detailmodel.inAccountType  = InAccountType.MemberCash;
            }
            if (RadioButtonList1.SelectedValue == "2")
            {
                detailmodel.InNumber       = number;
                detailmodel.outAccountType = OutAccountType.MemberBD;
                detailmodel.inAccountType  = InAccountType.MemberCash;
            }
            if (RadioButtonList1.SelectedValue == "3")
            {
                detailmodel.InNumber       = number;
                detailmodel.outAccountType = OutAccountType.MemberCons;
                detailmodel.inAccountType  = InAccountType.MemberCash;
            }
            if (RadioButtonList1.SelectedValue == "4")
            {
                detailmodel.InNumber       = number;
                detailmodel.outAccountType = OutAccountType.MemberTypeFx;
                detailmodel.inAccountType  = InAccountType.MemberTypeFx;
            }
        }
        catch
        {
            ClientScript.RegisterStartupScript(this.GetType(), "", "<script>alert('请输入正确的参数!');</script>");
        }
        SqlTransaction tran = null;
        SqlConnection  conn = DAL.DBHelper.SqlCon();

        conn.Open();
        tran = conn.BeginTransaction();
        try
        {
            if (detailmodel.outAccountType == OutAccountType.MemberCash && detailmodel.inAccountType == InAccountType.MemberCash)
            {
                string    number = "";
                string    sql    = "select number from MemberInfo where MobileTele='" + txt_InNumber.Text + "'";
                DataTable shj    = DBHelper.ExecuteDataTable(sql);
                if (shj.Rows.Count > 0)
                {
                    number = shj.Rows[0][0].ToString();
                    detailmodel.InNumber = number;
                }
                else
                {
                    ClientScript.RegisterStartupScript(this.GetType(), "", "<script>alert('无此编号,请检查后再重新输入222!')</script>");
                    return;
                }
                //对会员现金账户转入会员现金账户
                if (ECRemitDetailBLL.AddMoneyManageTran(detailmodel, 1, 2, tran) == 0)
                {
                    //string mot = "";
                    //string sqll = "select MobileTele from MemberInfo where number='" + lbEnum.Text + "'";
                    //DataTable xsj = DBHelper.ExecuteDataTable(sqll);
                    //if (xsj.Rows.Count > 0)
                    //{
                    //    mot = xsj.Rows[0][0].ToString();
                    //}
                    int    ret  = D_AccountBLL.AddAccountWithdrawTran(Session["Member"].ToString(), detailmodel.OutMoney, D_AccountSftype.MemberType, D_Sftype.BounsAccount, D_AccountKmtype.AccountTransfer, DirectionEnum.AccountReduced, "会员可用FTC账户转入" + txt_InNumber.Text.Trim() + "~会员保险账户", tran);
                    string st   = "INSERT INTO MemberAccount(Number,HappenTime,HappenMoney,BalanceMoney,Direction,SfType,KmType,Remark) SELECT number,GETutcDATE()," + detailmodel.OutMoney + ",zzye-xuhao,0,8,4,'会员可用钱包转出" + detailmodel.OutMoney + "到" + txt_InNumber.Text + "保险钱包。' from memberinfo where Number='" + detailmodel.InNumber + "'";
                    int    ret1 = DBHelper.ExecuteNonQuery(tran, st);
                    if (ret > 0 && ret1 > 0)
                    {
                        tran.Commit();
                        conn.Close();
                        ClientScript.RegisterStartupScript(this.GetType(), "", "<script>alert('转帐成功!');$('#tourl').show();document.getElementById('tourl').href='AccountDetail.aspx?type=AccountXJ';</script>");
                    }
                    else
                    {
                        tran.Rollback();
                        conn.Close();
                        ClientScript.RegisterStartupScript(this.GetType(), "", "<script>alert('转帐失败2222!');</script>");
                    }
                }

                else
                {
                    tran.Rollback();
                    conn.Close();
                    ClientScript.RegisterStartupScript(this.GetType(), "", "<script>alert('转帐失败1111!');</script>");
                }
            }
            if (detailmodel.outAccountType == OutAccountType.MemberBD && detailmodel.inAccountType == InAccountType.MemberCash)
            {
                //对会员现金账户转入会员消费账户
                if (ECRemitDetailBLL.AddMoneyManageTran(detailmodel, 3, 2, tran) == 0)
                {
                    //string mot = "";
                    //string sqll = "select MobileTele from MemberInfo where number='" + lbEnum.Text + "'";
                    //DataTable xsj = DBHelper.ExecuteDataTable(sqll);
                    //if (xsj.Rows.Count > 0)
                    //{
                    //    mot = xsj.Rows[0][0].ToString();
                    //}
                    int ret  = D_AccountBLL.AddAccountWithdrawTran(Session["Member"].ToString(), detailmodel.OutMoney, D_AccountSftype.MemberTypeBd, D_Sftype.baodanFTC, D_AccountKmtype.AccountTransfer, DirectionEnum.AccountReduced, "会员报单账户转入" + detailmodel.InNumber + "~会员保险账户", tran);
                    int ret1 = D_AccountBLL.AddAccountTran(detailmodel.InNumber, detailmodel.OutMoney, D_AccountSftype.zzye, D_Sftype.zzye, D_AccountKmtype.RechargeByTransfer, DirectionEnum.AccountsIncreased, lbEnum.Text + "会员报单账户为" + detailmodel.InNumber + "会员保险账户转入" + detailmodel.OutMoney, tran);
                    if (ret > 0 && ret1 > 0)
                    {
                        tran.Commit();
                        conn.Close();
                        ClientScript.RegisterStartupScript(this.GetType(), "", "<script>alert('转帐成功!');$('#tourl').show();document.getElementById('tourl').href='AccountDetail.aspx?type=AccountXJ';</script>");
                    }
                    else
                    {
                        tran.Rollback();
                        conn.Close();
                        ClientScript.RegisterStartupScript(this.GetType(), "", "<script>alert('转帐失败2222!');</script>");
                    }
                }
                else
                {
                    tran.Rollback();
                    conn.Close();
                    ClientScript.RegisterStartupScript(this.GetType(), "", "<script>alert('转帐失败1111!');</script>");
                }
            }

            if (detailmodel.outAccountType == OutAccountType.MemberCons && detailmodel.inAccountType == InAccountType.MemberCash)
            {
                //对会员消费账户转入会员消费账户
                if (ECRemitDetailBLL.AddMoneyManageTran(detailmodel, 0, 2, tran) == 0)
                {
                    //string mot = "";
                    //string sqll = "select MobileTele from MemberInfo where number='" + lbEnum.Text + "'";
                    //DataTable xsj = DBHelper.ExecuteDataTable(sqll);
                    //if (xsj.Rows.Count > 0)
                    //{
                    //    mot = xsj.Rows[0][0].ToString();
                    //}
                    int ret  = D_AccountBLL.AddAccountWithdrawTran(Session["Member"].ToString(), detailmodel.OutMoney, D_AccountSftype.MemberCoshType, D_Sftype.EleAccount, D_AccountKmtype.AccountTransfer, DirectionEnum.AccountReduced, "会员消费账户转入" + txt_InNumber.Text.Trim() + "~会员可用FTC账户", tran);
                    int ret1 = D_AccountBLL.AddAccountTran(Session["Member"].ToString(), detailmodel.OutMoney, D_AccountSftype.zzye, D_Sftype.zzye, D_AccountKmtype.RechargeByTransfer, DirectionEnum.AccountsIncreased, lbEnum.Text + "会员消费账户为" + txt_InNumber.Text.Trim() + "会员可用FTC账户转入" + detailmodel.OutMoney, tran);
                    if (ret > 0 && ret1 > 0)
                    {
                        tran.Commit();
                        conn.Close();
                        ClientScript.RegisterStartupScript(this.GetType(), "", "<script>alert('转帐成功!');$('#tourl').show();document.getElementById('tourl').href='AccountDetail.aspx?type=AccountXJ';</script>");
                    }
                    else
                    {
                        tran.Rollback();
                        conn.Close();
                        ClientScript.RegisterStartupScript(this.GetType(), "", "<script>alert('转帐失败2222!');</script>");
                    }
                }
                else
                {
                    tran.Rollback();
                    conn.Close();
                    ClientScript.RegisterStartupScript(this.GetType(), "", "<script>alert('转帐失败1111!');</script>");
                }
            }
            if (RadioButtonList1.SelectedValue == "4")
            {
                //对会员保险账户转入会员保险账户

                string    mot  = "";
                int       ret  = 0;
                int       ret1 = 0;
                int       ret2 = 0;
                int       ret3 = 0;
                string    sqll = "select number from MemberInfo where MobileTele='" + txt_InNumber.Text + "'";
                DataTable xsj  = DBHelper.ExecuteDataTable(sqll);
                if (xsj.Rows.Count > 0)
                {
                    mot = xsj.Rows[0][0].ToString();

                    ret  = DBHelper.ExecuteNonQuery(tran, "update memberinfo set xuhao+=" + detailmodel.OutMoney + " where number='" + Session["Member"].ToString() + "'");
                    ret1 = DBHelper.ExecuteNonQuery(tran, "update memberinfo set zzye+=" + detailmodel.OutMoney + "  where number='" + mot + "'");
                    ret2 = DBHelper.ExecuteNonQuery(tran, "INSERT INTO MemberAccount(Number,HappenTime,HappenMoney,BalanceMoney,Direction,SfType,KmType,Remark) SELECT number,GETutcDATE()," + detailmodel.OutMoney + ",zzye-xuhao,1,8,4,'会员保险钱包转出" + detailmodel.OutMoney + "到" + txt_InNumber.Text + "保险钱包。' from memberinfo where Number='" + Session["Member"].ToString() + "'");
                    ret3 = DBHelper.ExecuteNonQuery(tran, "INSERT INTO MemberAccount(Number,HappenTime,HappenMoney,BalanceMoney,Direction,SfType,KmType,Remark) SELECT number,GETutcDATE()," + detailmodel.OutMoney + ",zzye-xuhao,0,8,4,'会员保险钱包转出" + detailmodel.OutMoney + "到" + txt_InNumber.Text + "保险钱包。' from memberinfo where Number='" + mot + "'");
                }
                if (ret > 0 && ret1 > 0)
                {
                    tran.Commit();
                    conn.Close();
                    ClientScript.RegisterStartupScript(this.GetType(), "", "<script>alert('转帐成功!');$('#tourl').show();document.getElementById('tourl').href='AccountDetail.aspx?type=AccountXJ';</script>");
                }
                else
                {
                    tran.Rollback();
                    conn.Close();
                    ClientScript.RegisterStartupScript(this.GetType(), "", "<script>alert('转帐失败2222!');</script>");
                }
            }
            else
            {
                ClientScript.RegisterStartupScript(this.GetType(), "", "<script>alert('转帐失败444!');</script>");
            }



            this.txtEmoney.Text    = string.Empty;
            this.txt_InNumber.Text = string.Empty;
            txtEnote.Text          = string.Empty;
        }
        catch {
            //tran.Rollback();
            conn.Close();
            ClientScript.RegisterStartupScript(this.GetType(), "", "<script>alert('转帐失败!123');</script>");
        }
    }
Esempio n. 28
0
    public void getTotalMoney(string number)
    {
        Label1.Text = "<b>" + GetTran("007591", "已支付付款金额") + "</b>" + ":<span style=\"color:red\">" +
                      (Convert.ToDouble(RemittancesBLL.GetTotalMoney("RemitMoney", " Remittances a left join Withdraw c on a.ID=c.hkid ", " where isgsqr=1 and isnull(c.shenhestate,-1)<>-1 and RemitStatus=1 and relationorderid='' and RemitNumber='" + number + "'")) * (AjaxClass.GetCurrency(Convert.ToInt32(bzCurrency), Convert.ToInt32(Session["Default_Currency"].ToString())))
                      ).ToString("f2")

                      + "</span>";
        Label2.Text = "<b>" + GetTran("007592", "未支付付款金额") + "</b>" + ":<span style=\"color:red\">" +
                      (Convert.ToDouble(RemittancesBLL.GetTotalMoney("RemitMoney", " Remittances a left join Withdraw c on a.ID=c.hkid ", " where isgsqr=0 and isnull(c.shenhestate,-1)<>-1 and RemitStatus=1 and relationorderid='' and RemitNumber='" + number + "'")) / (AjaxClass.GetCurrency(Convert.ToInt32(bzCurrency), Convert.ToInt32(Session["Default_Currency"].ToString())))
                      ).ToString("f2")

                      + "</span>";
    }
Esempio n. 29
0
    protected void Page_Load(object sender, EventArgs e)
    {
        //Response.Cache.SetExpires(DateTime.Now);
        Permissions.MemRedirect(Page, Permissions.redirUrl);
        if (Request.QueryString["bh"] != null)
        {
            Session["jgbh"] = Request.QueryString["bh"];

            string r = Convert.ToString(Session["jgbh"]);

            string s = getBH();
        }
        AjaxPro.Utility.RegisterTypeForAjax(typeof(AjaxClass));
        if (!Page.IsPostBack)
        {
            BLL.CommonClass.CommonDataBLL.BindQishuList(dropdownlist_qishu, false);

            if (Request.QueryString["cengshu"] == null)
            {
                if (Session["jgcw"] == null)
                {
                    this.txtceng.Text = "3";
                }
                else
                {
                    this.txtceng.Text = Session["jgcw"].ToString();
                }
            }
            else
            {
                this.txtceng.Text = Request.QueryString["cengshu"].ToString();
            }

            if (Session["jgbh"] == null || Session["jgqs"] == null || Session["jglx"] == null)
            {
                Response.Write(GetTran("000894", "调用错误"));
                Response.End();
            }

            int  u    = Convert.ToInt32(Session["jgqs"]);
            bool flag = registermemberBLL.isNet(Session["jglx"].ToString(), Convert.ToString(Session["jgbh"]), getBH());

            // if (!Jiegou.isValid(Convert.ToString(Session["jgbh"]), getMemberBH(), isAnZhi(), Convert.ToInt32(Session["jgqs"])))
            if (flag == false)
            {
                Response.Write(GetTran("000892", "您不能查看该网络"));
                return;
            }

            if (Request.QueryString["SelectGrass"] != null)
            {
                dropdownlist_qishu.SelectedIndex = Convert.ToInt32(Request.QueryString["SelectGrass"].ToString());
            }
            if (Request.QueryString["isanzhi"] != null)
            {
                ViewState["isanzhi"] = Request.QueryString["isanzhi"];
            }

            if (Session["jgbh"] != null)
            {
                if (Session["jgbh"].ToString() != "")
                {
                    this.txtbianhao.Text = Session["jgbh"].ToString();
                    int cengshu = 0;
                    if (this.txtceng.Text.Trim() == "")
                    {
                        cengshu = 3;
                    }
                    else
                    {
                        try
                        {
                            cengshu = Convert.ToInt32(this.txtceng.Text.Trim());
                        }
                        catch
                        {
                            Response.Write("<script>alert('" + GetTran("000897", "显示层数输入格式错误") + "!');</script>");
                            return;
                        }
                    }

                    string loginBh = GetLoginMember();
                    int    bhCw    = AjaxClass.GetLogoutCw1(this.txtbianhao.Text.Trim(), Convert.ToInt32(this.dropdownlist_qishu.SelectedValue), true);
                    int    loginCw = AjaxClass.GetLogoutCw1(loginBh, Convert.ToInt32(this.dropdownlist_qishu.SelectedValue), true);
                    int    showCs  = AjaxClass.GetShowCengS1(0);

                    if (showCs - (bhCw - loginCw) < cengshu)
                    {
                        cengshu = showCs - (bhCw - loginCw);
                    }

                    this.WangLuoTu(Session["jgbh"].ToString(), "", Convert.ToInt32(ViewState["isanzhi"].ToString()), cengshu, Convert.ToInt32(dropdownlist_qishu.SelectedValue), "");
                }
            }

            //------------------------
            SetDaoHang();
        }
        Translations();
    }
Esempio n. 30
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. 31
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. 32
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;//绑定银行信息
        }
    }