/// <summary>
/// 更新状态
/// </summary>
/// <param name="book"></param>
/// <returns></returns>
public bool Update(LMS_Reder reder)
{
// update LMS_Reder set Bookstatu = 1 where Bookname = '在人间';
string sql = string.Format(@"update LMS_Reder set Userclass='{0}', Useridcard='{1}', Username='******',Usersex='{3}',Usertell ='{4}'where Usernumber={5} ", reder.Userclass, reder.Useridcard, reder.Username, reder.Usersex, reder.Usertell, reder.Usernumber);
return(DBHeper.SQL(sql));
}
public bool Insert(LMS_Reder reder)
{
//拼接SQL
string sql = string.Format(@"Insert into LMS_Reder( Userclass, Useridcard, Username,Usersex,Usertell) values('{0}',
'{1}',
'{2}','{3}','{4}')",
reder.Userclass, reder.Useridcard, reder.Username, reder.Usersex, reder.Usertell);
//连接数据库 执行SQL
return(DBHeper.SQL(sql));
}
public LMS_Reder Select(string sql)
{
LMS_Reder LMS_Reder = new LMS_Reder();
//从数据库获取信息
DataTable data = DBHeper.Select(sql);
//如果有数据 将DataTable载入到LMS_Reder对象
if (data.Rows.Count > 0)
{
var row = data.Rows[0];
LMS_Reder.Userclass = row["Userclass"].ToString();
LMS_Reder.Useridcard = row["Useridcard"].ToString();
LMS_Reder.Username = row["Username"].ToString();
LMS_Reder.Usernumber = (int)row["Usernumber"];
LMS_Reder.Usersex = row["Usersex"].ToString();
LMS_Reder.Usertell = row["Usertell"].ToString();
}
//返回书籍信息
return(LMS_Reder);
}
public List <LMS_Reder> SelectList(string sql)
{
List <LMS_Reder> list = new List <LMS_Reder>();
//从数据库获取信息
DataTable data = DBHeper.Select(sql);
foreach (DataRow row in data.Rows)
{
//利用将当前行数据 新建用户对象
LMS_Reder LMS_Reder = new LMS_Reder();
LMS_Reder.Userclass = row["UserClass"].ToString();
LMS_Reder.Useridcard = row["Useridcard"].ToString();
LMS_Reder.Username = row["Username"].ToString();
LMS_Reder.Usernumber = (int)row["Usernumber"];
LMS_Reder.Usersex = row["Usersex"].ToString();
LMS_Reder.Usertell = row["Usertell"].ToString();
//将用户对象 存入列表
list.Add(LMS_Reder);
}
//返回列表
return(list);
}
/// <summary>
/// 更新数据
/// </summry>
/// <param name="reder"></param>
/// <returns></returns>
public bool Update(LMS_Reder reder)
{
return(_dal.Update(reder));
}
/// <summary>
/// 添加一个读者
/// </summary>
/// <param name="reader"></param>
/// <returns></returns>
public bool AddReder(LMS_Reder reder)
{
return(_dal.Insert(reder));
}
