public bool Update(Model.AdminAccount model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update [admin_account] set ");
strSql.Append("password=@Password");
strSql.Append(" where adminno=@AdminNo ");
SqlParameter[] parameters =
{
new SqlParameter("@Password", SqlDbType.VarChar, 50),
new SqlParameter("@AdminNo", SqlDbType.VarChar, 50)
};
parameters[0].Value = model.Password;
parameters[1].Value = model.AdminNo;
int rows = SqlDbHelper.ExecuteNonQuery(strSql.ToString(), CommandType.Text, parameters);
if (rows == 1)
{
return(true);
}
else
{
return(false);
}
}
//序列化存储文件
public static void saveDat(Model.AdminAccount model)
{
Stream s = File.Open("user.dat", FileMode.OpenOrCreate);
BinaryFormatter bf = new BinaryFormatter();
bf.Serialize(s, model);
s.Close();
}
public bool Add(Model.AdminAccount model)
{
//if(model.AdminNo)
//string strSql = "insert into [admin_account] values(@AdminNo,@Password)";
//SqlParameter[] parameters = {
// new SqlParameter("@AdminNo", SqlDbType.VarChar,50),
// new SqlParameter("@Password", SqlDbType.VarChar,50),};
//parameters[0].Value = model.AdminNo;
//parameters[1].Value = model.Password;
//int n = SqlDbHelper.ExecuteNonQuery(strSql, CommandType.Text, parameters);
//if (n == 1)
return(true);
//else
// return false;
}
public bool Login(Model.AdminAccount model)
{
//StringBuilder strSql = new StringBuilder();
//strSql.Append("select count(1) from [admin_account]");
//strSql.Append(" where adminno=@AdminNo and password=@Password");
//SqlParameter[] parameters = {
// new SqlParameter("@AdminNo", SqlDbType.VarChar,50),
// new SqlParameter("@Password", SqlDbType.VarChar,50),};
//parameters[0].Value = model.AdminNo;
//parameters[1].Value = model.Password;
//int n = Convert.ToInt32(SqlDbHelper.ExecuteScalar(strSql.ToString(), CommandType.Text, parameters));
//if (n == 1)
return(true);
//else
// return false;
}
public bool Add(Model.AdminAccount model)
{
string strSql = "insert into [admin_account] values(@AdminNo,@Password)";
SqlParameter[] parameters =
{
new SqlParameter("@AdminNo", SqlDbType.VarChar, 50),
new SqlParameter("@Password", SqlDbType.VarChar, 50),
};
parameters[0].Value = model.AdminNo;
parameters[1].Value = model.Password;
int n = SqlDbHelper.ExecuteNonQuery(strSql, CommandType.Text, parameters);
if (n == 1)
{
return(true);
}
else
{
return(false);
}
}
