public ActionResult upDateSave(Book.Model.T_Base_Book book)
{
Book.BLL.T_Base_Book updatebook = new Book.BLL.T_Base_Book();
int result = updatebook.upDate(book);
return(Redirect("/Book/Index"));
}
public ActionResult UpdateSave(Book.Model.T_Base_Book book)
{
Book.BLL.T_Base_Book bll = new BLL.T_Base_Book();
int result = bll.Update(book);
return(Redirect("Index"));
}
public int Update(Book.Model.T_Base_Book book)
{
Book.DAL.T_Base_Book dal = new DAL.T_Base_Book();
int result = dal.Update(book);
return(result);
}
public int Add(Book.Model.T_Base_Book book)
{
Book.DAL.T_Base_Book dal = new DAL.T_Base_Book();
//用DAL层提供的添加方法添加
dal.Add(book);
return(0);
}
public Book.Model.T_Base_Book GetModel(int Id)
{
SqlConnection co = new SqlConnection();
co.ConnectionString = "server=10.132.239.3;uid=sa;pwd=Jsj123456;database=152111160209";
co.Open();
SqlCommand cmd = new SqlCommand();
cmd.Connection = co;
cmd.CommandText = "select * from t_base_book where id=@Id";
cmd.Parameters.AddWithValue("@Id", Id);
SqlDataReader dr = cmd.ExecuteReader();
Book.Model.T_Base_Book book = null;
while (dr.Read())
{
book = new Book.Model.T_Base_Book();
book.Id = Convert.ToInt32(dr["Id"]);
book.BookName = Convert.ToString(dr["BookName"]);
book.PressName = Convert.ToString(dr["PressName"]);
book.Author = Convert.ToString(dr["Author"]);
book.Version = Convert.ToInt32(dr["Version"]);
book.SN = Convert.ToString(dr["SN"]);
book.Price = Convert.ToDecimal(dr["Price"]);
}
dr.Close();
co.Close();
return(book);
}
public int upDate(Book.Model.T_Base_Book book)
{
int result = 0;
Book.DAL.T_Base_Book dal = new DAL.T_Base_Book();
result = dal.upDate(book);
return(result);
}
public int Add(Book.Model.T_Base_Book book)
{
SqlConnection co = new SqlConnection();
co.ConnectionString = "server=10.132.239.3;uid=sa;pwd=Jsj123456;database=15211160113";
co.Open();
SqlCommand cm = new SqlCommand();
cm.Connection = co;
cm.CommandText = "Insert into T_Base_Book(BookName,PressName,SN,Author,Version,Price) values (@BookName,@PressName,@SN,@Author,@Version,@Price)";
cm.Parameters.AddWithValue("@BookName", book.BookName);
cm.Parameters.AddWithValue("@PressName", book.PressName);
cm.Parameters.AddWithValue("@SN", book.SN);
cm.Parameters.AddWithValue("@Author", book.Author);
cm.Parameters.AddWithValue("@Version", book.Version);
cm.Parameters.AddWithValue("@Price", book.Price);
int result = cm.ExecuteNonQuery();
co.Close();
return(result);
}
public int upDate(Book.Model.T_Base_Book book)
{
SqlConnection co = new SqlConnection();
co.ConnectionString = "server=10.132.239.3;uid=sa;pwd=Jsj123456;database=152111160209";
co.Open();
SqlCommand cm = new SqlCommand();
cm.Connection = co;
cm.CommandText = "update t_base_book set BookName=@BookName, Author=@Author, PressName=@PressName,[Version]=@Version,Price=@Price,SN=@SN where Id=@Id";
cm.Parameters.AddWithValue("@BookName", book.BookName);
cm.Parameters.AddWithValue("@Author", book.Author);
cm.Parameters.AddWithValue("@PressName", book.PressName);
cm.Parameters.AddWithValue("@Version", book.Version);
cm.Parameters.AddWithValue("@Price", book.Price);
cm.Parameters.AddWithValue("@SN", book.SN);
cm.Parameters.AddWithValue("@Id", book.Id);
int result = cm.ExecuteNonQuery();
co.Close();
return(result);
}
public ActionResult update(int Id)
{
Book.Model.T_Base_Book book = (new Book.BLL.T_Base_Book()).GetModel(Id);
ViewBag.Book = book;
return(View());
}
