public static bool AddRank(Model.BookType book)
{
string sql = "insert into CustomType(C_Number,C_Name,C_Amount,C_Rate) values(@U_Number,@U_Name,@U_Sex,@U_Tel)";
/*构建sql参数*/
SqlParameter[] parm = new SqlParameter[] {
new SqlParameter("@U_Number", SqlDbType.VarChar),
new SqlParameter("@U_Name", SqlDbType.VarChar, 50),
new SqlParameter("@U_Sex", SqlDbType.Decimal),
new SqlParameter("@U_Tel", SqlDbType.Decimal),
};
/*给参数赋值*/
parm[0].Value = book.Number;
parm[1].Value = book.Name;
parm[2].Value = book.amount;
parm[3].Value = book.rateA;
foreach (SqlParameter p in parm) //没有对传入的数据作空值的处理
{
if (p.Value == null)
{
p.Value = DBNull.Value;
}
}
/*执行sql进行添加*/
return((DBHelp.ExecuteNonQuery(sql, parm) > 0) ? true : false);
}
public static Model.BookType getSomeRank(string barcode)
{
/*构建查询sql*/
string sql = "select * from CustomType where C_id=" + barcode;
SqlDataReader DataRead = DBHelp.ExecuteReader(sql, null);
Model.BookType book = new Model.BookType();
/*如果查询存在记录，就包装到对象中返回*/
if (DataRead.Read())
{
book.Id = Convert.ToInt32(DataRead["C_Id"]);
book.Number = DataRead["C_Number"].ToString();
book.Name = DataRead["C_Name"].ToString();
book.amount = double.Parse(DataRead["C_Amount"].ToString());
book.rateA = double.Parse(DataRead["C_Rate"].ToString());
}
DataRead.Close();
return(book);
}
public static bool EditRank(Model.BookType book)
{
string sql = "update CustomType set C_Number=@U_Number,C_Name=@U_Name,C_Amount=@U_Sex,C_Rate=@U_Tel where C_Id=@U_Id";
/*构建sql参数*/
SqlParameter[] parm = new SqlParameter[] {
new SqlParameter("@U_Number", SqlDbType.VarChar),
new SqlParameter("@U_Name", SqlDbType.VarChar, 50),
new SqlParameter("@U_Sex", SqlDbType.Decimal),
new SqlParameter("@U_Tel", SqlDbType.Decimal),
new SqlParameter("@U_Id", SqlDbType.Int)
};
/*给参数赋值*/
parm[0].Value = book.Number;
parm[1].Value = book.Name;
parm[2].Value = book.amount;
parm[3].Value = book.rateA;
parm[4].Value = book.Id;
/*执行更新*/
return((DBHelp.ExecuteNonQuery(sql, parm) > 0) ? true : false);
}
private void ShowInfo(int bookId)
{
BLL.BookInfo bll = new YueDuLibrary.BLL.BookInfo();
Model.BookInfo model = bll.GetModel(bookId);
BLL.BookType bllbooktype = new BLL.BookType();
Model.BookType modelbooktype = bllbooktype.GetModel(short.Parse(model.typeId));
BLL.BookCase bllbookcase = new BLL.BookCase();
Model.BookCase modelbookcase = bllbookcase.GetModel(model.bookCaseId);
this.lblbookId.Text = model.bookId.ToString();
this.lblbookCode.Text = model.bookCode;
this.lblbookName.Text = model.bookName;
this.lbltypeId.Text = modelbooktype.typeName;
this.lblauthor.Text = model.author;
this.lblprice.Text = model.price;
this.lblbookCaseId.Text = modelbookcase.caseName;
this.lblbookPage.Text = model.bookPage.ToString();
this.lblpublish.Text = model.publish;
//this.lbloperId.Text = model.operId.ToString();
this.lblstorage.Text = model.storage.ToString();
this.lblInCreateTime.Text = model.InCreateTime.ToString();
//this.lblbookImg.Text = model.bookImg;
}
