protected void btnBookTypeSave_Click(object sender, EventArgs e)
{
bool b;
if (Context.Request["bookTypeId"] != null)
{
bookType.BookTypeId = Convert.ToInt32(Context.Request["bookTypeId"]);
bookType.BookTypeName = tb_bookTypeName.Text;
bookType.BookTypeDesc = tb_bookTypeDesc.Text;
b = bookTypeDao.bookTypeUpdate(bookType);
}
else
{
bookType = new BookType();
bookType.BookTypeName = tb_bookTypeName.Text;
bookType.BookTypeDesc = tb_bookTypeDesc.Text;
b = bookTypeDao.bookTypeAdd(bookType);
}
if (b)
{
Response.Redirect("bookTypeList.aspx?flag=" + 1);
}
else
{
Alertfail.Visible = true;
}
}
protected void listBookType_ItemCommand(object source, RepeaterCommandEventArgs e)
{
//点击删除按钮，删除对应一条的信息
if (e.CommandName == "delete")
{
int bookTypeId = Convert.ToInt32(e.CommandArgument.ToString());
BookType bookType = new BookType();
bookType.BookTypeId = bookTypeId;
try
{
bookTypeDao.bookTypeDelete(bookType);
Response.Redirect("bookTypeList.aspx");
}
catch {
AlertFailure.Visible = true;
}
}
//点击修改，跳转到bookTypeModify,并且将bokTypeId作为参数传过去
else if (e.CommandName == "modify")
{
string url;
url = "bookTypeSave.aspx?bookTypeId=" + e.CommandArgument;
Response.Redirect(url);
}
}
//删除书籍类别信息,传入一个BookType对象，根据传入对象的bookTypeId进行删除查询，更新成功返回true，否则返回false
public bool bookTypeDelete(BookType bookType)
{
sqlCon = dbUtil.getCon();
string cmdText = "delete from t_bookType where bookTypeId=" + bookType.BookTypeId;
SqlCommand sqlcom = new SqlCommand(cmdText, sqlCon);
int n = sqlcom.ExecuteNonQuery();//返回受影响的行数
if (n == 1)
{
dbUtil.close(sqlCon);
return(true);
}
else
{
dbUtil.close(sqlCon);
return(false);
}
}
//更新书籍类别信息,传入一个BookType对象，根据传入对象的bookTypeId进行更新查询，更新成功返回true，否则返回false
public bool bookTypeUpdate(BookType bookType)
{
sqlCon = dbUtil.getCon();
string cmdText = "update t_bookType set bookTypeName='" + bookType.BookTypeName + "',bookTypeDesc='" + bookType.BookTypeDesc + "' where bookTypeId=" + bookType.BookTypeId;
SqlCommand sqlcom = new SqlCommand(cmdText, sqlCon);
int n = sqlcom.ExecuteNonQuery();//返回受影响的行数
if (n == 1)
{
dbUtil.close(sqlCon);
return(true);
}
else
{
dbUtil.close(sqlCon);
return(false);
}
}
//插入一个传进来的不含bookTypeId属性的bookType对象，插入成功返回true，否则返回false
public bool bookTypeAdd(BookType bookType)
{
sqlCon = dbUtil.getCon();
string cmdText = "insert into t_bookType (bookTypeName,bookTypeDesc) values('" + bookType.BookTypeName + "','" + bookType.BookTypeDesc + "')";
SqlCommand sqlcom = new SqlCommand(cmdText, sqlCon);
int n = sqlcom.ExecuteNonQuery();//返回受影响的行数
if (n == 1)
{
dbUtil.close(sqlCon);
return(true);
}
else
{
dbUtil.close(sqlCon);
return(false);
}
}
//根据主键查询某一个BookType
public BookType findById(int bookTypeId)
{
sqlCon = dbUtil.getCon();
BookType resultBookType = null;
string cmdText = "select * from t_bookType where bookTypeId=" + bookTypeId; //查询用户字符串
SqlCommand sqlCmd = new SqlCommand(cmdText, sqlCon); //查询对象
SqlDataReader sqlDr = sqlCmd.ExecuteReader(); //创建逐行数据读取器对象
if (sqlDr.Read())
{
resultBookType = new BookType();
resultBookType.BookTypeId = (int)sqlDr["bookTypeId"];
resultBookType.BookTypeName = (string)sqlDr["bookTypeName"];
resultBookType.BookTypeDesc = (string)sqlDr["bookTypeDesc"];
}
sqlDr.Close();
dbUtil.close(sqlCon);
return(resultBookType);
}
protected void Page_Load(object sender, EventArgs e)
{
int bookTypeId = Convert.ToInt32(Context.Request["bookTypeId"]);
//根据bookTypeList页面传过来的bookTypeId从数据库中获取bookType对象
bookType = bookTypeDao.findById(bookTypeId);
if (!IsPostBack)
{
if (Context.Request["bookTypeId"] == null)
{
tb_bookTypeDesc.Text = "";
tb_bookTypeName.Text = "";
}
else
{
tb_bookTypeName.Text = bookType.BookTypeName;
tb_bookTypeDesc.Text = bookType.BookTypeDesc;
}
}
}
//根据bookTypeName判断是否已经存在,返回true表示已经存在该书籍类别，否则不存在
public bool existBookType(BookType bookType)
{
sqlCon = dbUtil.getCon();
string cmdText = "select * from t_bookType where bookTypeName='" + bookType.BookTypeName + "'";
SqlCommand sqlCmd = new SqlCommand(cmdText, sqlCon); //查询对象
SqlDataReader sqlDr = sqlCmd.ExecuteReader(); //创建逐行数据读取器对象
if (sqlDr.Read())
{
sqlDr.Close();
dbUtil.close(sqlCon);
return(true);
}
else
{
sqlDr.Close();
dbUtil.close(sqlCon);
return(false);
}
}
