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