尖叫 的一天
public class BookDAL{
public List<Model.Book>GetBook(string search=null){
List<Model.Book>books=new List<Model.Book>();
SQLHelp db=new=new SQHelp();
if(db.OpenConnection())
SqlDataReader dr=db.ExecReader("select*from[Books] where[Name] like '%"+search+"%"or[Author] like'%"+search+"%");
if(dr !=null)
{
while(dr.Read()){
Model.Book b=new Model.Book();
b.ID=(int)dr["ID"];
b.Type=dr["Type"]as string;
b.Name=dr["Name"]as string;
b.Author=dr["Author"]as string;
b.Cover=dr["Cover"]as string;
b.Price=(decimal)dr["Price"];
b.TotalNum=(long)dr["TotalNum"];
b.SaleNum=(long)dr["SaleNum"];
books.Add(b);
}
}
dr.Close();
db.CloseConnection();
}
db.CloseConnection();
}
return books;
public string InsertBook(Model.Book book){
string sql="p_InsertBook";
SqlParameter[ ] parms=new SqlParameter[7];
parms[0]=new SqlParameter("@type",book.Type);
parms[1]=new SqlParameter("@name",book.Name);
parms[2]=new SqlParameter("@author",book.Author);
parms[3]=new SqlParameter("@price", book.Price);
parms[4]=new SqlParameter("@cover",book.Cover);
parms[5]=new SqlParameter("@totalNum",book.TotalNum);
parms[6]=new SqlParameter("@saleNum",book.SaleNum);
int count=new SqlHelp().ExecQuery(sql,CommandType.StoredProcedure,parms);
switch(count){
case -1:
sql="数据库操作异常!请检查你输入的数据或者联系管理员!";
break:
case 0:
sql ="没有影响到任何数据!检查你输入的数据!";
break:
default:
sql="成功添加"+count+"条数据!";
break:
}
return sql:
}