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; }