/// <summary>
/// 传入用户账号取到账号和密码
/// </summary>
/// <param name="userID">用户账号</param>
/// <returns></returns>
public User getPwdByUserId(string userID)
{
string sql = "select userID,userName,roleId,roleName,regionName,regionId,userPwd from V_User where userID=@userID and deleteState=0";
string[] param = { "@userID" };
object[] values = { userID };
User user = new User();
MySqlDataReader reader = db.ExecuteReader(sql, param, values);
Role role = new Role();
Region region = new Region();
while (reader.Read())
{
user.UserId = reader.GetString(0);
user.UserName = reader.GetString(1);
role.RoleId = reader.GetInt32(2);
role.RoleName = reader.GetString(3);
region.RegionName = reader.GetString(4);
region.RegionId = reader.GetInt32(5);
user.RoleId = role;
user.ReginId = region;
user.Pwd = reader.GetString(6);
}
reader.Close();
return(user);;
}
/// <summary>
/// 取得最新书号
/// </summary>
/// <returns></returns>
public BookBasicData getBookNum()
{
string sql = "select bookNum from T_NewBook";
BookBasicData bookBasic = new BookBasicData();
MySqlDataReader reader = db.ExecuteReader(sql, null, null);
while (reader.Read())
{
bookBasic.NewBookNum = reader.GetString(0);
}
reader.Close();
return(bookBasic);;
}
/// <summary>
/// 获取折扣
/// </summary>
/// <param name="userID"></param>
/// <returns></returns>
public Monomers getDiscount()
{
string sql = "select disCount from T_NewBook";
Monomers monomers = new Monomers();
MySqlDataReader reader = db.ExecuteReader(sql, null, null);
while (reader.Read())
{
monomers.Discount = reader.GetDouble(0);
}
reader.Close();
return(monomers);;
}
