/// <summary> /// 登录方法 /// <para>返回列表:</para> /// <para>登录错误</para> /// <para>ErrorENUM.LOGINERROR</para> /// <para>未知错误</para> /// <para>ErrorENUM.UNLNOWNERROR</para> /// <para>登录成功</para> /// <para>ErrorENUM.OK</para> /// </summary> /// <param name="id">输入的账号</param> /// <param name="pwd">输入的密码</param> /// <param name="NickName">返回的昵称</param> /// <param name="LogonTime">返回的注册日期</param> /// <param name="LoginInfo">返回登录状态</param> /// <returns></returns> public ErrorENUM iniSignMethod(int id, string pwd, ref string NickName, ref string LogonTime, ref bool LoginInfo) { MySqlConnection mysqlconn = null; MySqlCommand mySqlCommand = null; try { mysqlconn = new MySqlConnection(SqlMain.SqlInfo); mysqlconn.Open(); mySqlCommand = new MySqlCommand(SqlMain.selectNickName(id, pwd), mysqlconn); try { NickName = mySqlCommand.ExecuteScalar().ToString(); } catch { } if (NickName != null) { mySqlCommand = new MySqlCommand(SqlMain.selectLogonTime(id.ToString()), mysqlconn); LogonTime = mySqlCommand.ExecuteScalar().ToString(); LoginInfo = true; return(ErrorENUM.OK);//登录成功 } else { return(ErrorENUM.LOGINERROR);//登录错误 } } catch (Exception err) { return(ErrorENUM.UNLNOWNERROR);//未知错误 } finally { if (mysqlconn != null) { mysqlconn.Close(); } } }
/// <summary> /// 以捐献金额为准,从高到低获取指定数量的捐献者邮箱 /// </summary> /// <returns>捐献者ID:捐献金额</returns> public static List <object> getDonateEmail(int count) { List <object> list = new List <object>(); MySqlConnection conn = null; MySqlCommand comm = null; MySqlDataReader read = null; try { conn = new MySqlConnection(SqlMain.SqlInfo); conn.Open(); comm = new MySqlCommand(SqlMain.getDonaceEmail(), conn); read = comm.ExecuteReader(); int index = 0; while (read.Read()) { list.Add(read[0].ToString()); index++; if (index == count) { break; } } } catch { } return(list); }
/// <summary> /// 以捐献金额为准,从高到低获取指定数量的捐献者ID:捐献金额 /// </summary> /// <returns>捐献者ID:捐献金额</returns> public static Dictionary <object, object> getDonateID(int count) { Dictionary <object, object> dic = new Dictionary <object, object>(); MySqlConnection conn = null; MySqlCommand comm = null; MySqlDataReader read = null; try { conn = new MySqlConnection(SqlMain.SqlInfo); conn.Open(); comm = new MySqlCommand(SqlMain.getDonaceIdAndMoney(), conn); read = comm.ExecuteReader(); int index = 0; while (read.Read()) { dic.Add(read[0].ToString(), read[1].ToString()); index++; if (index == count) { break; } } } catch { } return(dic); }
/// <summary> /// 更新密码 /// <para>返回列表:</para> /// <para>数据不存在</para> /// <para>ErrorENUM.NOONEINFO;</para> /// <para>复制表(%45)错误</para> /// <para>ErrorENUM.COPYFORGETERROR;</para> /// <para>更新失败</para> /// <para>ErrorENUM.UPDATEERRR;</para> /// <para>未知错误</para> /// <para>ErrorENUM.UNLNOWNERROR;</para> /// <para>更新成功</para> /// <para>ErrorENUM.UPOK;</para> /// </summary> /// <param name="id">Id</param> /// <param name="Email">邮箱</param> /// <param name="NickName">昵称</param> /// <param name="newPassword">新密码</param> /// <returns></returns> public ErrorENUM updatePassword(string id, string Email, string NickName, string newPassword) { string sql_ver = SqlMain.verIdAndEmail(id, Email, NickName); //查询条件是否符合 string sql_forget = SqlMain.insertForget(id, Email, newPassword, DateTime.Now.ToString()); //更新(%45)表 string sql_update = SqlMain.updatePassword(newPassword, id, Email, NickName); //更新密码 List <List <UserTable> > list = new List <List <UserTable> >(); int index = 0; MySqlConnection conn = null; MySqlCommand comm = null; MySqlDataReader read = null; try { //阶段1 conn = new MySqlConnection(SqlMain.SqlInfo); conn.Open(); comm = new MySqlCommand(sql_ver, conn); read = comm.ExecuteReader(); while (read.Read()) { list.Add(new List <UserTable>()); list[index].Add(new UserTable(read[0], read[1], read[2], read[3], read[4])); index++; } try { read.Close(); } catch (Exception) { } if (list.Count <= 0) { return(ErrorENUM.NOONEINFO); } //阶段2 comm = new MySqlCommand(sql_forget, conn); int v = comm.ExecuteNonQuery(); if (v <= 0) { return(ErrorENUM.COPYFORGETERROR); } //阶段3 comm = new MySqlCommand(sql_update, conn); int v1 = comm.ExecuteNonQuery(); if (v1 <= 0) { return(ErrorENUM.UPDATEERRR); } return(ErrorENUM.UPOK); } catch { return(ErrorENUM.UNLNOWNERROR); } finally { if (conn != null) { conn.Close(); } } }
private void AboutUser_Load(object sender, EventArgs e) { if (SqlMain.aboutUser(nickName, logonTime)) { System.IO.FileStream fs = new System.IO.FileStream("AboutUser.html", System.IO.FileMode.Open); this.webBrowser1.Url = new Uri(fs.Name); fs.Close(); } else { this.label1.Visible = true; } }
//--------------- /// <summary> /// 以捐献金额为准,从高到低获取指定数量的捐献者邮箱 /// </summary> /// <returns>捐献者ID:捐献金额</returns> public static Dictionary <object, object> getDonateEmail() { Dictionary <object, object> dic = new Dictionary <object, object>(); MySqlConnection conn = null; MySqlCommand comm = null; MySqlDataReader read = null; try { conn = new MySqlConnection(SqlMain.SqlInfo); conn.Open(); comm = new MySqlCommand(SqlMain.getDonaceEmail(), conn); read = comm.ExecuteReader(); while (read.Read()) { dic.Add(read[0].ToString(), read[1].ToString()); } } catch { } return(dic); }
/// <summary> /// 登录或注册方法 /// <para>返回列表:</para> /// <para>空指针</para> /// <para>ErrorENUM.NULL</para> /// <para>邮箱已存在</para> /// <para>ErrorENUM.ALREADYEXIST</para> /// <para>注册成功</para> /// <para>ErrorENUM.INOK</para> /// <para>登录错误</para> /// <para>ErrorENUM.LOGINERROR</para> /// <para>未知错误</para> /// <para>ErrorENUM.UNLNOWNERROR</para> /// <para>登录成功</para> /// <para>ErrorENUM.OK</para> /// </summary> /// <param name="tbId">ID的文本框</param> /// <param name="tbPwd">密码文本框</param> /// <param name="tbEmail">邮箱文本框</param> /// <param name="loginOrLogon">登录还是注册</param> /// <param name="NickName">昵称</param> /// <param name="LogonTime">登录时间</param> /// <param name="LoginInfo">登录状态</param> /// <returns>字符串</returns> /// <returns></returns> public ErrorENUM signinMethod(string tbId, string tbPwd, string tbEmail, bool loginOrLogon, ref string NickName, ref string LogonTime, ref bool LoginInfo) { if (tbId == "") { return(ErrorENUM.NULL);//空指针 } if (tbPwd == "") { return(ErrorENUM.NULL);//空指针 } MySqlConnection mysqlconn = null; MySqlCommand mySqlCommand = null; Object idOrNickName = null; if (loginOrLogon) { idOrNickName = tbId; } else { try { idOrNickName = int.Parse(tbId); } catch { } } string pwd = tbPwd; string time = DateTime.Now.ToString(); string Email = tbEmail.ToLower(); if (loginOrLogon) { if (tbEmail == "") { return(ErrorENUM.NULL);//空指针 } try { mysqlconn = new MySqlConnection(SqlMain.SqlInfo); mysqlconn.Open(); mySqlCommand = new MySqlCommand(SqlMain.selectEmail(Email), mysqlconn); if (Convert.ToInt32(mySqlCommand.ExecuteScalar()) >= 1) { return(ErrorENUM.ALREADYEXIST);//邮箱已存在 } mySqlCommand = new MySqlCommand(SqlMain.insertUser(idOrNickName.ToString(), pwd, time, Email), mysqlconn); if (mySqlCommand.ExecuteNonQuery() <= 0) { return(ErrorENUM.UNLNOWNERROR);//未知错误 } else { mySqlCommand = new MySqlCommand(SqlMain.selectEmail(Email), mysqlconn); mySqlCommand = new MySqlCommand(SqlMain.selectId(Email), mysqlconn); this.reId = Convert.ToString(mySqlCommand.ExecuteScalar()); return(ErrorENUM.INOK);//注册成功 } } catch { return(ErrorENUM.UNLNOWNERROR);//未知错误 } finally { if (mysqlconn != null) { mysqlconn.Close(); } } } else { return(iniSignMethod(Convert.ToInt32(tbId), pwd, ref NickName, ref LogonTime, ref LoginInfo)); } }