public book.Model.T_Base_Book getModelById(int id)
{
SqlConnection co = new SqlConnection();
co.ConnectionString = "server=10.132.239.215;uid=14jb;pwd=14jb;database=14211160205_book";
co.Open();
SqlCommand cm = new SqlCommand();
cm.CommandText = "select * from t_base_book where id =@id";
cm.Parameters.AddWithValue("@id", id);
cm.Connection = co;
SqlDataReader dr = cm.ExecuteReader();
book.Model.T_Base_Book book = null;
while (dr.Read())
{
book = new Model.T_Base_Book();
book.Id = Convert.ToInt32(dr["Id"]);
book.Code = Convert.ToString(dr["Code"]);
book.Author = Convert.ToString(dr["Author"]);
book.Price = Convert.ToDecimal(dr["Price"]);
book.PYear = Convert.ToDateTime(dr["PYear"]);
book.Version = Convert.ToString(dr["Version"]);
book.BookName = Convert.ToString(dr["BookName"]);
book.Pic = Convert.ToString(dr["Pic"]);
}
co.Close();
dr.Close();
return(book);
}
public bool Update(book.Model.T_Base_Book book)
{
SqlConnection co = new SqlConnection();
co.ConnectionString = "server=10.132.239.215;uid=14jb;pwd=14jb;database=14211160205_book";
co.Open();
SqlCommand cm = new SqlCommand();
cm.CommandText = "update t_base_book set Code=@Code,Author=@Author,Price=@Price,PYear=@PYear,Version=@Version,BookName=@BookName,Pic=@Pic where Id=@Id";
cm.Parameters.AddWithValue("@Code", book.Code);
cm.Parameters.AddWithValue("@Author", book.Author);
cm.Parameters.AddWithValue("@Price", book.Price);
cm.Parameters.AddWithValue("@PYear", book.PYear);
cm.Parameters.AddWithValue("@Version", book.Version);
cm.Parameters.AddWithValue("@BookName", book.BookName);
cm.Parameters.AddWithValue("@Pic", book.Pic);
cm.Parameters.AddWithValue("@Id", book.Id);
cm.Connection = co;
int result = cm.ExecuteNonQuery();
co.Close();
if (result > 0)
{
return(true);
}
else
{
return(false);
}
}
public bool add(book.Model.T_Base_Book book)
{
SqlConnection co = new SqlConnection();
co.ConnectionString = "server=10.132.239.215;uid=14jb;pwd=14jb;database=14211160205_book";
co.Open();
SqlCommand cm = new SqlCommand();
cm.CommandText = @"insert into t_base_book (Code,Author,Price,PYear,Version,BookName,Pic) Values (@Code,@Author,@Price,@PYear,@Version,@BookName,@Pic)";
cm.Connection = co;
cm.Parameters.AddWithValue("@Code", book.Code);
cm.Parameters.AddWithValue("@Author", book.Author);
cm.Parameters.AddWithValue("@Price", book.Price);
cm.Parameters.AddWithValue("@PYear", book.PYear);
cm.Parameters.AddWithValue("@Version", book.Version);
cm.Parameters.AddWithValue("@BookName", book.BookName);
cm.Parameters.AddWithValue("@Pic", book.Pic);
int result = cm.ExecuteNonQuery();
co.Close();
if (result > 0)
{
return(true);
}
return(false);
}
public ActionResult UpdateSave(book.Model.T_Base_Book book)
{
DAL.DalT_Base_Book dal = new DAL.DalT_Base_Book();
bool result = dal.Update(book);
string tmp;
if (result)
{
tmp = "{ \"statusCode\":\"200\", \"message\":\"修改成功\", \"navTabId\":\"buyer\", \"rel\":\"buyer\",\"callbackType\":\"closeCurrent\",\"forwardUrl\":\"\"}";
return(Content(tmp));
}
else
{
tmp = "{ \"statusCode\":\"300\", \"message\":\"修改失败\", \"navTabId\":\"buyer\", \"rel\":\"buyer\",\"callbackType\":\"closeCurrent\",\"forwardUrl\":\"\"}";
}
return(Content(tmp));
}
