/// <summary> /// 编辑bookinformationdata数据集中指定的行数据 /// </summary> /// <param name="bookinformationdata">数据集对象</param> /// <param name="bookinformation">实体对象</param> public void EditRow(ref BookInformationData bookinformationdata, EntityBookInformation bookinformation) { #region if (bookinformationdata.Tables[0].Rows.Count <= 0) { bookinformationdata = this.getData(bookinformation.bookId); } DataRow dr = bookinformationdata.Tables[0].Rows.Find(new object[1] { bookinformation.bookId }); bookinformationdata.Assign(dr, BookInformationData.bookId, bookinformation.bookId); bookinformationdata.Assign(dr, BookInformationData.domainTypeId, bookinformation.domainTypeId); bookinformationdata.Assign(dr, BookInformationData.publisherId, bookinformation.publisherId); bookinformationdata.Assign(dr, BookInformationData.belongtoId, bookinformation.belongtoId); bookinformationdata.Assign(dr, BookInformationData.countryId, bookinformation.countryId); bookinformationdata.Assign(dr, BookInformationData.userId, bookinformation.userId); bookinformationdata.Assign(dr, BookInformationData.bookTitle, bookinformation.bookTitle); bookinformationdata.Assign(dr, BookInformationData.author, bookinformation.author); bookinformationdata.Assign(dr, BookInformationData.translator, bookinformation.translator); bookinformationdata.Assign(dr, BookInformationData.bookurl, bookinformation.bookurl); bookinformationdata.Assign(dr, BookInformationData.publishDate, bookinformation.publishDate); bookinformationdata.Assign(dr, BookInformationData.isbn, bookinformation.isbn); bookinformationdata.Assign(dr, BookInformationData.buyTime, bookinformation.buyTime); bookinformationdata.Assign(dr, BookInformationData.paymoney, bookinformation.paymoney); bookinformationdata.Assign(dr, BookInformationData.writeTime, bookinformation.writeTime); #endregion }
/// <summary> /// 保存bookinformationdata数据集数据 /// </summary> /// <param name="bookinformationdata">数据集对象</param> /// <returns>返回保存后的响应信息</returns> public String SaveBookInformation(BookInformationData bookinformationdata) { #region BookInformationClass bookinformationclass = new BookInformationClass(); return(base.Save(bookinformationdata, bookinformationclass)); #endregion }
/// <summary> /// 获取BookInformation数据表的全部数据 /// </summary> /// <returns>Json字符串</returns> public string GetJsonByAll() { #region int totalCount = 0; BookInformationData bookinformationdata = this.getData(null); totalCount = bookinformationdata.Tables[0].Rows.Count; return(base.GetJson(bookinformationdata, totalCount)); #endregion }
/// <summary> /// 根据主键值检索符合该条件的记录,用于编辑和删除记录时。 /// </summary> /// <param name="bookId">主键-</param> /// <returns></returns> private BookInformationData getData(string bookId) { #region BookInformationData bookinformationdata = new BookInformationData(); DBConditions querybusinessparams = new DBConditions(); querybusinessparams.Add(BookInformationData.bookId, EnumSqlType.sqlint, EnumCondition.Equal, bookId); this._bookinformationclass.GetSingleT(bookinformationdata, querybusinessparams); return(bookinformationdata); #endregion }
protected override void Seed(Bibliothek.DataAccess.LibraryDbContext context) { #region Instantiating Book book = new BookData() { ID = 1, Condition = "Mint", IsRented = true, Loans = new List <LoanData>() }; Author author = new Author() { ID = 1, BooksWritten = new List <BookInformationData>(), HasNobelPrize = true, IsAlive = false, Name = "John Doe", Nation = "se" }; BookInformationData bookInformation = new BookInformationData() { ID = 1, Title = "Sample Title", Description = "Sample Description", Category = Category.Horses, Position = "A1", PublishingYear = 1111, ISBN = "123-456-789", Authors = new List <Author>(), Books = new List <Book>() }; LoanData loan = new LoanData() { ID = 1, Start = DateTime.Now, End = DateTime.Now.AddMonths(3), IsReturned = false, Books = new List <Book>() }; CustomerData loanTaker = new CustomerData() { ID = 1, Name = "Some Loner", MembershipNumber = "12", Contact = "*****@*****.**", Loans = new List <LoanData>() }; #endregion #region Mapping book.BookInformation = bookInformation; bookInformation.Books.Add(book); bookInformation.Authors.Add(author); author.BooksWritten.Add(bookInformation); book.Loans.Add(loan); loan.Books.Add(book); loan.Customer = loanTaker; loanTaker.Loans.Add(loan); #endregion #region Add to database context.LoanTakers.AddOrUpdate(loanTaker); /* context.Database.ExecuteSqlCommand("Book_Insert @condition, @isrented, @BookInformationId", * new SqlParameter {ParameterName = "@condition", Value = book.Condition}, * new SqlParameter { ParameterName = "@isrented", Value = book.IsRented }, * new SqlParameter { ParameterName = "@BookInformationId", Value = book.BookInformation.ID });*/ #endregion }
/// <summary> /// 删除bookinformationdata数据集中指定的行数据 /// </summary> /// <param name="bookinformationdata">数据集对象</param> /// <param name="bookId">主键-</param> public void DeleteRow(ref BookInformationData bookinformationdata, string bookId) { #region if (bookinformationdata.Tables[0].Rows.Count <= 0) { bookinformationdata = this.getData(bookId); } DataRow dr = bookinformationdata.Tables[0].Rows.Find(new object[1] { bookId }); if (dr != null) { dr.Delete(); } #endregion }
/// <summary> /// 根据条件筛选所有BookInformation指定页码的数据(分页型) /// </summary> /// <param name="bookinformation">实体对象</param> /// <param name="pageparams">分页对象</param> /// <param name="totalCount">符合条件的记录总数量</param> /// <returns></returns> public DataSet GetData(EntityBookInformation bookinformation, PageParams pageparams, out int totalCount) { #region DBConditions querybusinessparams = new DBConditions(pageparams); querybusinessparams.Add(BookInformationData.bookId, EnumSqlType.sqlint, EnumCondition.Equal, bookinformation.bookId); querybusinessparams.Add(BookInformationData.domainTypeId, EnumSqlType.sqlint, EnumCondition.Equal, bookinformation.domainTypeId); querybusinessparams.Add(BookInformationData.publisherId, EnumSqlType.tinyint, EnumCondition.Equal, bookinformation.publisherId); querybusinessparams.Add(BookInformationData.belongtoId, EnumSqlType.sqlint, EnumCondition.Equal, bookinformation.belongtoId); querybusinessparams.Add(BookInformationData.countryId, EnumSqlType.sqlint, EnumCondition.Equal, bookinformation.countryId); querybusinessparams.Add(BookInformationData.userId, EnumSqlType.nvarchar, EnumCondition.Equal, bookinformation.userId); querybusinessparams.Add(BookInformationData.bookTitle, EnumSqlType.nvarchar, EnumCondition.Equal, bookinformation.bookTitle); querybusinessparams.Add(BookInformationData.author, EnumSqlType.nvarchar, EnumCondition.Equal, bookinformation.author); querybusinessparams.Add(BookInformationData.translator, EnumSqlType.nvarchar, EnumCondition.Equal, bookinformation.translator); querybusinessparams.Add(BookInformationData.bookurl, EnumSqlType.nvarchar, EnumCondition.Equal, bookinformation.bookurl); querybusinessparams.Add(BookInformationData.publishDate, EnumSqlType.datetime, EnumCondition.Equal, bookinformation.publishDate); querybusinessparams.Add(BookInformationData.isbn, EnumSqlType.nvarchar, EnumCondition.Equal, bookinformation.isbn); querybusinessparams.Add(BookInformationData.buyTime, EnumSqlType.datetime, EnumCondition.Equal, bookinformation.buyTime); querybusinessparams.Add(BookInformationData.paymoney, EnumSqlType.sqldecimal, EnumCondition.Equal, bookinformation.paymoney); querybusinessparams.Add(BookInformationData.writeTime, EnumSqlType.datetime, EnumCondition.Equal, bookinformation.writeTime); BookInformationData bookinformationdata = new BookInformationData(); totalCount = this._bookinformationclass.GetSingleT(bookinformationdata, querybusinessparams); return(bookinformationdata); #endregion }
/// <summary> /// 添加BookInformation表行数据(如主键为非自增型字段,则自行修改代码) /// </summary> /// <param name="bookinformationdata">数据集对象</param> /// <param name="bookinformation">实体对象</param> public void AddRow(ref BookInformationData bookinformationdata, EntityBookInformation bookinformation) { #region DataRow dr = bookinformationdata.Tables[0].NewRow(); bookinformationdata.Assign(dr, BookInformationData.bookId, bookinformation.bookId); bookinformationdata.Assign(dr, BookInformationData.domainTypeId, bookinformation.domainTypeId); bookinformationdata.Assign(dr, BookInformationData.publisherId, bookinformation.publisherId); bookinformationdata.Assign(dr, BookInformationData.belongtoId, bookinformation.belongtoId); bookinformationdata.Assign(dr, BookInformationData.countryId, bookinformation.countryId); bookinformationdata.Assign(dr, BookInformationData.userId, bookinformation.userId); bookinformationdata.Assign(dr, BookInformationData.bookTitle, bookinformation.bookTitle); bookinformationdata.Assign(dr, BookInformationData.author, bookinformation.author); bookinformationdata.Assign(dr, BookInformationData.translator, bookinformation.translator); bookinformationdata.Assign(dr, BookInformationData.bookurl, bookinformation.bookurl); bookinformationdata.Assign(dr, BookInformationData.publishDate, bookinformation.publishDate); bookinformationdata.Assign(dr, BookInformationData.isbn, bookinformation.isbn); bookinformationdata.Assign(dr, BookInformationData.buyTime, bookinformation.buyTime); bookinformationdata.Assign(dr, BookInformationData.paymoney, bookinformation.paymoney); bookinformationdata.Assign(dr, BookInformationData.writeTime, bookinformation.writeTime); bookinformationdata.Tables[0].Rows.Add(dr); #endregion }