//增加售票员
public bool AddTicketing_seller(Model.ticketing_seller model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append(" insert into ticketing_seller(");
strSql.Append(" Name,Password,Super_seller)");
strSql.Append(" values (");
strSql.Append(" @Name,@Password,@Super_seller)");
SqlParameter[] parameters =
{
new SqlParameter("@Name", SqlDbType.VarChar, 20),
new SqlParameter("@Password", SqlDbType.VarChar, 20),
new SqlParameter("@Super_seller", SqlDbType.Int)
};
parameters[0].Value = model.Name;
parameters[1].Value = model.Password;
parameters[2].Value = model.Super_seller;
int rows = SqlDbHelper.ExecuteNonQuery(strSql.ToString(), CommandType.Text, parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
//更改售票员信息
public bool Updateseller_password(Model.ticketing_seller model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append(" update ticketing_seller set");
strSql.Append(" Name=@Name,");
strSql.Append(" Password=@Password,");
strSql.Append(" Super_seller=@Super_seller");
strSql.Append(" where T_id=@T_id ");
SqlParameter[] parameters =
{
new SqlParameter("@Name", SqlDbType.VarChar, 20),
new SqlParameter("@Password", SqlDbType.VarChar, 20),
new SqlParameter("@Super_seller", SqlDbType.Int),
new SqlParameter("@T_id", SqlDbType.Int)
};
parameters[0].Value = model.Name;
parameters[1].Value = model.Password;
parameters[2].Value = model.Super_seller;
parameters[3].Value = model.T_id;
int rows = SqlDbHelper.ExecuteNonQuery(strSql.ToString(), CommandType.Text, parameters);
if (rows == 1)
{
return(true);
}
else
{
return(false);
}
}