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); }
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); }
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); }