Exemplo n.º 1
0
    protected void bt_submit_Click(object sender, EventArgs e)
    {
        MemberInfo memberInfo = MemberInfo.Read(int.Parse(this.Session["userId"].ToString()));
        int        num        = 0;

        if (!int.TryParse(this.tb_money.Value.Trim(), out num) || num <= 0)
        {
            this.Page.ClientScript.RegisterStartupScript(base.GetType(), "Ok", "alert('提现金额必须为正整数!');", true);
            return;
        }
        base.Response.Write("<script>location.href='Password.aspx?url=" + base.Request.Url.AbsolutePath.ToString() + "';</script>");
        if (num % 100 != 0)
        {
            this.Page.ClientScript.RegisterStartupScript(base.GetType(), "Ok", "alert('提现金额必须为100的整数倍!');", true);
            base.Response.Write("<script>location.href='Password.aspx?url=" + base.Request.Url.AbsolutePath.ToString() + "';</script>");
            return;
        }
        base.Response.Write("<script>location.href='Password.aspx?url=" + base.Request.Url.AbsolutePath.ToString() + "';</script>");
        if (memberInfo.JiangJin >= (double)num)
        {
            TiXianInfo tiXianInfo = new TiXianInfo(0, memberInfo.Id, memberInfo.UserName, this.kaihuname.Value, memberInfo.KaiHuBank, memberInfo.KaiHuAccount, this.zfbName.Value, this.zfb.Value, num, DateTime.Now, 0);
            tiXianInfo.Insert();
            memberInfo.JiangJin -= (double)num;
            memberInfo.Update();
            this.Page.ClientScript.RegisterStartupScript(base.GetType(), "Ok", "alert('提现成功!');", true);
            return;
        }
        base.Response.Write("<script>location.href='Password.aspx?url=" + base.Request.Url.AbsolutePath.ToString() + "';</script>");
        this.Page.ClientScript.RegisterStartupScript(base.GetType(), "Ok", "alert('提现金额不能大于当前余额!');", true);
    }
Exemplo n.º 2
0
    public static List <TiXianInfo> ReadList(string whereStr)
    {
        List <TiXianInfo> list        = new List <TiXianInfo>();
        Database          database    = new Database();
        DataView          defaultView = database.RunProc("select * from TiXian " + whereStr).Tables[0].DefaultView;

        for (int i = 0; i < defaultView.Count; i++)
        {
            list.Add(TiXianInfo.Read(int.Parse(defaultView[i]["id"].ToString())));
        }
        database.Dispose();
        return(list);
    }
Exemplo n.º 3
0
    public static TiXianInfo Read(int id)
    {
        TiXianInfo      result          = null;
        Database        database        = new Database();
        MySqlDataReader mySqlDataReader = database.RunProcGetReader("select * from TiXian where id=" + id);

        while (mySqlDataReader.Read())
        {
            result = new TiXianInfo(int.Parse(mySqlDataReader.GetValue(0).ToString()), int.Parse(mySqlDataReader.GetValue(1).ToString()), mySqlDataReader.GetValue(2).ToString(), mySqlDataReader.GetValue(3).ToString(), mySqlDataReader.GetValue(4).ToString(), mySqlDataReader.GetValue(5).ToString(), mySqlDataReader.GetValue(6).ToString(), mySqlDataReader.GetValue(7).ToString(), int.Parse(mySqlDataReader.GetValue(8).ToString()), DateTime.Parse(mySqlDataReader.GetValue(9).ToString()), int.Parse(mySqlDataReader.GetValue(10).ToString()));
        }
        mySqlDataReader.Close();
        database.Dispose();
        return(result);
    }