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