/// <summary> /// 添加用户 /// </summary> /// <param name="name">Name</param> /// <param name="pass">Pass</param> /// <param name="question">Question</param> /// <param name="answer">Answer</param> /// <returns>bool</returns> public static bool AddCustomer(string name, string pass, string question, string answer) { try { string sql = "insert into tb_customer(customerName,customerPass,customerRegDate,customerQuestion,customerAnswer) values(?name,?pass,now(),?question,?answer);"; MySqlParameter[] para = new MySqlParameter[4]; para[0] = new MySqlParameter("?name", name); para[1] = new MySqlParameter("?pass", DAL_Safety.GetMD5(pass)); para[2] = new MySqlParameter("?question", question); para[3] = new MySqlParameter("?answer", DAL_Safety.EncodeBase64(answer)); int ret = DAL_MysqlHelper.ExecuteNonQuery(sql, para); if (ret == 1) { return(true); } else { return(false); } } catch (Exception e) { throw e; } }
/// <summary> /// 修改密码 /// </summary> /// <param name="name">Name</param> /// <param name="pass">Pass(新)</param> /// <returns>bool</returns> public static bool UpdatePassword(string name, string pass) { try { string sql = "update tb_customer set customerPass=?pass where customerName=?name;"; MySqlParameter[] para = new MySqlParameter[2]; para[0] = new MySqlParameter("?pass", DAL_Safety.GetMD5(pass)); para[1] = new MySqlParameter("?name", name); int ret = DAL_MysqlHelper.ExecuteNonQuery(sql, para); if (ret == 1) { return(true); } else { return(false); } } catch (Exception e) { throw e; } }
/// <summary> /// 查询用户是否存在(登录用) /// </summary> /// <param name="name">Name</param> /// <param name="pass">Pass</param> /// <returns>bool</returns> public static bool QueryCustomerExists(string name, string pass) { try { string sql = "select customerName from tb_customer where customerName=?name and customerPass=?pass;"; MySqlParameter[] para = new MySqlParameter[2]; para[0] = new MySqlParameter("?name", name); para[1] = new MySqlParameter("?pass", DAL_Safety.GetMD5(pass)); Object obj = DAL_MysqlHelper.ExecuteScalar(sql, para); if (Equals(obj, null)) { return(false); } else { return(true); } } catch (Exception e) { throw e; } }
/// <summary> /// 添加管理员 /// </summary> /// <param name="name"></param> /// <param name="pass"></param> /// <returns>bool</returns> public static bool AddManage(string name, string pass) { try { string sql = "insert into tb_manage(managerName,managerPWD) values(?name,?pass);"; MySqlParameter[] para = new MySqlParameter[2]; para[0] = new MySqlParameter("?name", name); para[1] = new MySqlParameter("?pass", DAL_Safety.GetMD5(pass)); int ret = DAL_MysqlHelper.ExecuteNonQuery(sql, para); if (ret == 1) { return(true); } else { return(false); } } catch (Exception e) { throw e; } }