/// <summary>
/// 增加一条数据
/// </summary>
public bool Add(BookShop.Model.Orders model)
{
StringBuilder strSql=new StringBuilder();
strSql.Append("insert into Orders(");
strSql.Append("OrderId,OrderDate,UserId,TotalPrice,PostAddress,state)");
strSql.Append(" values (");
strSql.Append("@OrderId,@OrderDate,@UserId,@TotalPrice,@PostAddress,@state)");
SqlParameter[] parameters = {
new SqlParameter("@OrderId", SqlDbType.NVarChar,50),
new SqlParameter("@OrderDate", SqlDbType.DateTime),
new SqlParameter("@UserId", SqlDbType.Int,4),
new SqlParameter("@TotalPrice", SqlDbType.Decimal,9),
new SqlParameter("@PostAddress", SqlDbType.NVarChar,255),
new SqlParameter("@state", SqlDbType.Int,4)};
parameters[0].Value = model.OrderId;
parameters[1].Value = model.OrderDate;
parameters[2].Value = model.UserId;
parameters[3].Value = model.TotalPrice;
parameters[4].Value = model.PostAddress;
parameters[5].Value = model.state;
int rows=DbHelperSQL.ExecuteSql(strSql.ToString(),parameters);
if (rows > 0)
{
return true;
}
else
{
return false;
}
}
/// <summary>
/// 增加一条数据
/// </summary>
public int Add(BookShop.Model.sysdiagrams model)
{
StringBuilder strSql=new StringBuilder();
strSql.Append("insert into sysdiagrams(");
strSql.Append("name,principal_id,version,definition)");
strSql.Append(" values (");
strSql.Append("@name,@principal_id,@version,@definition)");
strSql.Append(";select @@IDENTITY");
SqlParameter[] parameters = {
new SqlParameter("@name", SqlDbType.NVarChar,128),
new SqlParameter("@principal_id", SqlDbType.Int,4),
new SqlParameter("@version", SqlDbType.Int,4),
new SqlParameter("@definition", SqlDbType.VarBinary,-1)};
parameters[0].Value = model.name;
parameters[1].Value = model.principal_id;
parameters[2].Value = model.version;
parameters[3].Value = model.definition;
object obj = DbHelperSQL.GetSingle(strSql.ToString(),parameters);
if (obj == null)
{
return 0;
}
else
{
return Convert.ToInt32(obj);
}
}
/// <summary>
/// 增加一条数据
/// </summary>
public bool Add(BookShop.Model.SearchDetails model)
{
StringBuilder strSql=new StringBuilder();
strSql.Append("insert into SearchDetails(");
strSql.Append("Id,KeyWords,DateTime)");
strSql.Append(" values (");
strSql.Append("@Id,@KeyWords,@DateTime)");
SqlParameter[] parameters = {
new SqlParameter("@Id", SqlDbType.UniqueIdentifier,16),
new SqlParameter("@KeyWords", SqlDbType.NVarChar,50),
new SqlParameter("@DateTime", SqlDbType.DateTime)};
parameters[0].Value = Guid.NewGuid();
parameters[1].Value = model.KeyWords;
parameters[2].Value = model.DateTime;
int rows=DbHelperSQL.ExecuteSql(strSql.ToString(),parameters);
if (rows > 0)
{
return true;
}
else
{
return false;
}
}
/// <summary>
/// 增加一条数据
/// </summary>
public int Add(BookShop.Model.Articel_Words model)
{
StringBuilder strSql=new StringBuilder();
strSql.Append("insert into Articel_Words(");
strSql.Append("WordPattern,IsForbid,IsMod,ReplaceWord)");
strSql.Append(" values (");
strSql.Append("@WordPattern,@IsForbid,@IsMod,@ReplaceWord)");
strSql.Append(";select @@IDENTITY");
SqlParameter[] parameters = {
new SqlParameter("@WordPattern", SqlDbType.NVarChar,50),
new SqlParameter("@IsForbid", SqlDbType.Bit,1),
new SqlParameter("@IsMod", SqlDbType.Bit,1),
new SqlParameter("@ReplaceWord", SqlDbType.NVarChar,50)};
parameters[0].Value = model.WordPattern;
parameters[1].Value = model.IsForbid;
parameters[2].Value = model.IsMod;
parameters[3].Value = model.ReplaceWord;
object obj = DbHelperSQL.GetSingle(strSql.ToString(),parameters);
if (obj == null)
{
return 0;
}
else
{
return Convert.ToInt32(obj);
}
}
/// <summary>
/// 增加一条数据
/// </summary>
public int Add(BookShop.Model.Users model)
{
StringBuilder strSql=new StringBuilder();
strSql.Append("insert into Users(");
strSql.Append("LoginId,LoginPwd,Name,Address,Phone,Mail,UserStateId)");
strSql.Append(" values (");
strSql.Append("@LoginId,@LoginPwd,@Name,@Address,@Phone,@Mail,@UserStateId)");
strSql.Append(";select @@IDENTITY");
SqlParameter[] parameters = {
new SqlParameter("@LoginId", SqlDbType.NVarChar,50),
new SqlParameter("@LoginPwd", SqlDbType.NVarChar,50),
new SqlParameter("@Name", SqlDbType.NVarChar,50),
new SqlParameter("@Address", SqlDbType.NVarChar,200),
new SqlParameter("@Phone", SqlDbType.NVarChar,100),
new SqlParameter("@Mail", SqlDbType.NVarChar,100),
new SqlParameter("@UserStateId", SqlDbType.Int,4)};
parameters[0].Value = model.LoginId;
parameters[1].Value = model.LoginPwd;
parameters[2].Value = model.Name;
parameters[3].Value = model.Address;
parameters[4].Value = model.Phone;
parameters[5].Value = model.Mail;
parameters[6].Value = model.UserStateId;
object obj = DbHelperSQL.GetSingle(strSql.ToString(),parameters);
if (obj == null)
{
return 0;
}
else
{
return Convert.ToInt32(obj);
}
}
public ActionResult Autherize(TaiKhoan Account)
{
using (BookShop db = new BookShop())
{
var v = db.TaiKhoan.Where(x => x.Username == Account.Username && x.Pass == Account.Pass).FirstOrDefault();
if (v == null)
{
return(View("Login", Account));
}
else
{
var userSesstion = new TaiKhoan();
userSesstion.ID = v.ID;
userSesstion.Username = v.Username;
Session.Add(CommonConstant.USER_SESSION, userSesstion);
if (v.Quyen == 1)
{
Session["Session_ADMIN"] = v;
Session["Session_USER"] = v;
//var userSesstion = new TaiKhoan();
//userSesstion.ID = v.ID;
//userSesstion.Username = v.Username;
//Session.Add(CommonConstant.USER_SESSION, userSesstion);
return(Redirect("/Admin/Home/Index"));
}
else
{
Session["Session_USER"] = v;
Session["Session_ADMIN"] = null;
return(Redirect("/Users/Home/User_Home"));
}
}
}
}
/// <summary>
/// 增加一条数据
/// </summary>
public int Add(BookShop.Model.Cart model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into Cart(");
strSql.Append("UserId,BookId,Count)");
strSql.Append(" values (");
strSql.Append("@UserId,@BookId,@Count)");
strSql.Append(";select @@IDENTITY");
SqlParameter[] parameters = {
new SqlParameter("@UserId", SqlDbType.Int,4),
new SqlParameter("@BookId", SqlDbType.Int,4),
new SqlParameter("@Count", SqlDbType.Int,4)};
parameters[0].Value = model.UserId;
parameters[1].Value = model.Book.Id;
parameters[2].Value = model.Count;
object obj = DbHelperSQL.GetSingle(strSql.ToString(), parameters);
if (obj == null)
{
return 0;
}
else
{
return Convert.ToInt32(obj);
}
}
/// <summary>
/// 增加一条数据
/// </summary>
public int Add(BookShop.Model.OrderBook model)
{
StringBuilder strSql=new StringBuilder();
strSql.Append("insert into OrderBook(");
strSql.Append("OrderID,BookID,Quantity,UnitPrice)");
strSql.Append(" values (");
strSql.Append("@OrderID,@BookID,@Quantity,@UnitPrice)");
strSql.Append(";select @@IDENTITY");
SqlParameter[] parameters = {
new SqlParameter("@OrderID", SqlDbType.NVarChar,50),
new SqlParameter("@BookID", SqlDbType.Int,4),
new SqlParameter("@Quantity", SqlDbType.Int,4),
new SqlParameter("@UnitPrice", SqlDbType.Decimal,9)};
parameters[0].Value = model.OrderID;
parameters[1].Value = model.BookID;
parameters[2].Value = model.Quantity;
parameters[3].Value = model.UnitPrice;
object obj = DbHelperSQL.GetSingle(strSql.ToString(),parameters);
if (obj == null)
{
return 0;
}
else
{
return Convert.ToInt32(obj);
}
}
public UiConsoleBookShop(ICargo Cargo)
{
string verticalLine = "|\n";
for (byte i = 0; i < 44; ++i)
{
verticalLine += "|\n";
}
shop = new BookShop(Cargo);
head = new ActiveElementDraw(
new ActiveStaticElement("Main", new Coord(2, 1)),
new ActiveInputElement("Find: " + new string(' ', 75), new Coord(21, 1), new Coord(6, 0), 74),
new ActiveDoubleElement("Login/Register", new Coord(134, 1), "Logout", new Coord(134, 1)),
new StaticElement(new string('_', downRightCorner.x), new Coord(0, 0)),
new StaticElement(new string('_', downRightCorner.x), new Coord(0, downRightCorner.y)),
new StaticElement(new string('-', downRightCorner.x - 2), new Coord(1, 2)),
new StaticElement(verticalLine, new Coord(0, 1)),
new StaticElement(verticalLine, new Coord(downRightCorner.x, 1)),
new StaticElement("|", new Coord(7, 1)),
new StaticElement("|", new Coord(20, 1)),
new StaticElement("|", new Coord(102, 1)),
new StaticElement("|", new Coord(133, 1)),
new StaticElement("|", new Coord(148, 1))
);
}
/// <summary>
/// 增加一条数据
/// </summary>
public int Add(BookShop.Model.VidoFile model)
{
StringBuilder strSql=new StringBuilder();
strSql.Append("insert into VidoFile(");
strSql.Append("Title,FivPath,Status,FileExt)");
strSql.Append(" values (");
strSql.Append("@Title,@FivPath,@Status,@FileExt)");
strSql.Append(";select @@IDENTITY");
SqlParameter[] parameters = {
new SqlParameter("@Title", SqlDbType.NVarChar,50),
new SqlParameter("@FivPath", SqlDbType.NVarChar,255),
new SqlParameter("@Status", SqlDbType.NVarChar,50),
new SqlParameter("@FileExt", SqlDbType.NVarChar,50)};
parameters[0].Value = model.Title;
parameters[1].Value = model.FivPath;
parameters[2].Value = model.Status;
parameters[3].Value = model.FileExt;
object obj = DbHelperSQL.GetSingle(strSql.ToString(),parameters);
if (obj == null)
{
return 0;
}
else
{
return Convert.ToInt32(obj);
}
}
/// <summary>
/// 增加一条数据
/// </summary>
public bool Add(BookShop.Model.SysFun model)
{
StringBuilder strSql=new StringBuilder();
strSql.Append("insert into SysFun(");
strSql.Append("NodeId,DisplayName,NodeURL,DisplayOrder,ParentNodeId)");
strSql.Append(" values (");
strSql.Append("@NodeId,@DisplayName,@NodeURL,@DisplayOrder,@ParentNodeId)");
SqlParameter[] parameters = {
new SqlParameter("@NodeId", SqlDbType.Int,4),
new SqlParameter("@DisplayName", SqlDbType.NVarChar,50),
new SqlParameter("@NodeURL", SqlDbType.NVarChar,50),
new SqlParameter("@DisplayOrder", SqlDbType.Int,4),
new SqlParameter("@ParentNodeId", SqlDbType.Int,4)};
parameters[0].Value = model.NodeId;
parameters[1].Value = model.DisplayName;
parameters[2].Value = model.NodeURL;
parameters[3].Value = model.DisplayOrder;
parameters[4].Value = model.ParentNodeId;
int rows=DbHelperSQL.ExecuteSql(strSql.ToString(),parameters);
if (rows > 0)
{
return true;
}
else
{
return false;
}
}
/// <summary>
/// 增加一条数据
/// </summary>
public int Add(BookShop.Model.BookComment model)
{
StringBuilder strSql=new StringBuilder();
strSql.Append("insert into BookComment(");
strSql.Append("Msg,CreateDateTime,BookId)");
strSql.Append(" values (");
strSql.Append("@Msg,@CreateDateTime,@BookId)");
strSql.Append(";select @@IDENTITY");
SqlParameter[] parameters = {
new SqlParameter("@Msg", SqlDbType.NVarChar,-1),
new SqlParameter("@CreateDateTime", SqlDbType.DateTime),
new SqlParameter("@BookId", SqlDbType.Int,4)};
parameters[0].Value = model.Msg;
parameters[1].Value = model.CreateDateTime;
parameters[2].Value = model.BookId;
object obj = DbHelperSQL.GetSingle(strSql.ToString(),parameters);
if (obj == null)
{
return 0;
}
else
{
return Convert.ToInt32(obj);
}
}
static void Main(string[] args)
{
#region MyBusines
List <IBusiness> allMyProfitableBusiness = new List <IBusiness>();
BookShop bookShop1 = new BookShop(75);
AudioCDShop cd1Shop = new AudioCDShop(80);
EngineDesignPatent enginePatent = new EngineDesignPatent(1200);
BenzolMedicinePatent medicinePatent = new BenzolMedicinePatent(1450);
allMyProfitableBusiness.Add(bookShop1);
allMyProfitableBusiness.Add(cd1Shop);
allMyProfitableBusiness.Add(enginePatent);
allMyProfitableBusiness.Add(medicinePatent);
#endregion
List <InvestmentReturn> investmentReturns = new List <InvestmentReturn>();
foreach (IBusiness bus in allMyProfitableBusiness)
{
investmentReturns.Add(new InvestmentReturn(bus));
}
double totalProfit = 0;
foreach (var profitelement in investmentReturns)
{
totalProfit = totalProfit + profitelement.GetInvestmentProfit();
Console.WriteLine("Profit: {0:c}", profitelement.GetInvestmentProfit());
}
Console.ReadKey();
}
public void GetBillPriceTest1()
{
var books = new List <Book>()
{
new Book()
{
Count = 1, Name = "HollyPoter", SerialNo = 1, SinglePrice = 100.0m
},
new Book()
{
Count = 0, Name = "HollyPoter", SerialNo = 2, SinglePrice = 100.0m
},
new Book()
{
Count = 0, Name = "HollyPoter", SerialNo = 3, SinglePrice = 100.0m
},
new Book()
{
Count = 0, Name = "HollyPoter", SerialNo = 4, SinglePrice = 100.0m
},
new Book()
{
Count = 0, Name = "HollyPoter", SerialNo = 5, SinglePrice = 100.0m
},
};
var target = new BookShop();
var expected = 100.0m;
Assert.AreEqual(expected, target.GetBillPrice(books));
}
public void Notify()
{
foreach (IBookShop BookShop in _BookShops)
{
BookShop.Update(this);
}
Console.WriteLine("");
}
private static void SellBookTest(BookShop myBookShop, int id, string message)
{
using (var sw = new StringWriter())
{
Console.SetOut(sw);
myBookShop.SellBook(id);
sw.ToString().Should().Be(message);
}
}
private void btnGetBooks_Click(object sender, RoutedEventArgs e)
{
try
{
dgBooks.DataContext = BookShop.GetBooks(true);
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
private Book GetBookFromBookShopById(BookShop bookShop, int bookId)
{
var book = bookShop.Books.FirstOrDefault(b => b.Id == bookId);
if (book is null)
{
throw new NotFoundException(ExceptionMessage.BookNotFound);
}
return(book);
}
/// <summary>
/// 多线程执行计算图书库存（不做线程同步）
/// </summary>
static void SaleBook()
{
BookShop book = new BookShop();
//创建两个线程同时访问Sale方法
Thread t1 = new Thread(new ThreadStart(book.Sale));
Thread t2 = new Thread(new ThreadStart(book.Sale));
//启动线程
t1.Start();
t2.Start();
Console.ReadKey();
}
public void UnsuccessfulDeliveryTest()
{
var myBookShop = new BookShop(BookShop.StartingCapacity);
var delivery = new List <IBooksResponse.Book> {
new IBooksResponse.Book {
Id = 1, Title = "A", Genre = "fiction", Price = 5000000, IsNew = false, DateDelivery = DateTime.Now
}
};
myBookShop.ReceiveDelivery(delivery);
myBookShop.ShopBankAccount.Balance.Should().Be(100000);
myBookShop.ShopLibrary.Stock.Count.Should().Be(0);
}
static void Main(string[] args)
{
//1.--线程同步，指某一时刻只有一个线程能执行这个方法，线程调用这个方法必须是同步的（并发调用，导致数据出错）
BookShop book = new BookShop();
//创建两个线程同时访问Sale方法
Thread t1 = new Thread(new ThreadStart(book.Sale));
Thread t2 = new Thread(new ThreadStart(book.Sale));
//启动线程
t1.Start();
t2.Start();
Console.ReadKey();
}
public void GetTotal_只買哈利波特第一集共100元()
{
//Arrange
var target = new BookShop();
double expect = 100;
//Act
target.AddBookList(target.GetBook("哈利波特第一集"));
var actual = target.GetTotal();
//Assert
Assert.AreEqual(expect, actual);
}
public void GetTotal_買哈利波特_壹x1_貮x1_共190()
{
//Arrange
var target = new BookShop();
double expect = (100 + 100) * 0.95;
//Act
target.AddBookList(target.GetBook("哈利波特第一集"));
target.AddBookList(target.GetBook("哈利波特第二集"));
var actual = target.GetTotal();
//Assert
Assert.AreEqual(expect, actual);
}
static void Main22(string[] args)
{
BookShop book = new BookShop();
//创建两个线程同时访问Sale方法
Thread t1 = new Thread(new ThreadStart(book.Sale));
Thread t2 = new Thread(new ThreadStart(book.Sale));
//启动线程
t1.Start();
t2.Start();
Console.ReadKey();
}
public void NeedDeliveryTest()
{
var myBookShop = new BookShop(BookShop.StartingCapacity);
var delivery = new List <IBooksResponse.Book> {
new IBooksResponse.Book {
Id = 1, Title = "A", Genre = "fiction", Price = 5000000, IsNew = false, DateDelivery = DateTime.Now
},
new IBooksResponse.Book {
Id = 2, Title = "B", Genre = "encyclopedia", Price = 450, IsNew = true, DateDelivery = DateTime.Now
}
};
myBookShop.ReceiveDelivery(delivery);
myBookShop.NeedDelivery().Should().Be(true);
}
public void UnsuccessfulBookSoldTest()
{
var myBookShop = new BookShop(BookShop.StartingCapacity);
var delivery = new List <IBooksResponse.Book> {
new IBooksResponse.Book {
Id = 1, Title = "A", Genre = "fiction", Price = 350, IsNew = false, DateDelivery = DateTime.Now
},
new IBooksResponse.Book {
Id = 2, Title = "B", Genre = "encyclopedia", Price = 450, IsNew = true, DateDelivery = DateTime.Now
}
};
myBookShop.ReceiveDelivery(delivery);
SellBookTest(myBookShop, 3, "No book with this id.\n");
}
private void btnSave_Click(object sender, RoutedEventArgs e)
{
// Mistä tiedetään mitä muokata --> Book-olio
try
{
Book current = (Book)spBook.DataContext;
if (BookShop.UpdateBook(current) > 0)
{
MessageBox.Show(string.Format("Kirja {0} päivitetty tietokantaan onnistuneesti.", current.ToString()));
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
private BookShop GetMainBookShop()
{
var mainBookShop = new BookShop()
{
Name = "Copernicus Center Press",
Description = "Main bookshop",
Address = new Address()
{
City = "Wrocław",
Street = "Sztabowa",
StreetNumber = 98,
PostalCode = "53-310"
},
Contact = new Contact()
{
ContactEmail = "*****@*****.**",
ContactNumber1 = "71 354 72 71",
ContactNumber2 = "71 364 69 73"
},
Books = new List <Book>()
{
new Book()
{
Title = "Do końca czasu",
Description = "Umysł, materia i nasze poszukiwanie sensu w zmieniającym się Wszechświecie",
Author = "Brian Greene",
Price = 50,
ClassifiedInformation = "Something important"
},
new Book()
{
Title = "Wszechświat krok po kroku",
Author = "Łukasz Lamża",
Price = 30,
ClassifiedInformation = "Something important"
},
new Book()
{
Title = "Pan raczy żartować, panie Feynman! ",
Author = "Richard Feynman",
Price = 100
}
}
};
return(mainBookShop);
}
/// <summary>
/// 增加一条数据
/// </summary>
public int Add(BookShop.Model.Books model)
{
StringBuilder strSql=new StringBuilder();
strSql.Append("insert into Books(");
strSql.Append("Title,Author,PublisherId,PublishDate,ISBN,WordsCount,UnitPrice,ContentDescription,AurhorDescription,EditorComment,TOC,CategoryId,Clicks)");
strSql.Append(" values (");
strSql.Append("@Title,@Author,@PublisherId,@PublishDate,@ISBN,@WordsCount,@UnitPrice,@ContentDescription,@AurhorDescription,@EditorComment,@TOC,@CategoryId,@Clicks)");
strSql.Append(";select @@IDENTITY");
SqlParameter[] parameters = {
new SqlParameter("@Title", SqlDbType.NVarChar,200),
new SqlParameter("@Author", SqlDbType.NVarChar,200),
new SqlParameter("@PublisherId", SqlDbType.Int,4),
new SqlParameter("@PublishDate", SqlDbType.DateTime),
new SqlParameter("@ISBN", SqlDbType.NVarChar,50),
new SqlParameter("@WordsCount", SqlDbType.Int,4),
new SqlParameter("@UnitPrice", SqlDbType.Money,8),
new SqlParameter("@ContentDescription", SqlDbType.NVarChar,-1),
new SqlParameter("@AurhorDescription", SqlDbType.NVarChar,-1),
new SqlParameter("@EditorComment", SqlDbType.NVarChar,-1),
new SqlParameter("@TOC", SqlDbType.NVarChar,-1),
new SqlParameter("@CategoryId", SqlDbType.Int,4),
new SqlParameter("@Clicks", SqlDbType.Int,4)};
parameters[0].Value = model.Title;
parameters[1].Value = model.Author;
parameters[2].Value = model.PublisherId;
parameters[3].Value = model.PublishDate;
parameters[4].Value = model.ISBN;
parameters[5].Value = model.WordsCount;
parameters[6].Value = model.UnitPrice;
parameters[7].Value = model.ContentDescription;
parameters[8].Value = model.AurhorDescription;
parameters[9].Value = model.EditorComment;
parameters[10].Value = model.TOC;
parameters[11].Value = model.CategoryId;
parameters[12].Value = model.Clicks;
object obj = DbHelperSQL.GetSingle(strSql.ToString(),parameters);
if (obj == null)
{
return 0;
}
else
{
return Convert.ToInt32(obj);
}
}
public void GetTotal_買哈利波特全套75折共375()
{
//Arrange
var target = new BookShop();
double expect = (100 + 100 + 100 + 100 + 100) * 0.75;
//Act
target.AddBookList(target.GetBook("哈利波特第一集"));
target.AddBookList(target.GetBook("哈利波特第二集"));
target.AddBookList(target.GetBook("哈利波特第三集"));
target.AddBookList(target.GetBook("哈利波特第四集"));
target.AddBookList(target.GetBook("哈利波特第五集"));
var actual = target.GetTotal();
//Assert
Assert.AreEqual(expect, actual);
}
static void Main(string[] args)
{
//TestClass testClass = new TestClass();
//Thread thread1 = new Thread(testClass.TestMethod);
BookShop bookShop = new BookShop();
Thread t1 = new Thread(bookShop.Sale); //线程1
Thread t2 = new Thread(bookShop.Sale); //线程2
//t1.IsBackground = true;
//t2.IsBackground = true;
//开启线程
t1.Start();
t2.Start();
Thread.Sleep(1000);
Console.ReadKey();
}
private void btnDelete_Click(object sender, RoutedEventArgs e)
{
try
{
Book current = (Book)spBook.DataContext;
var retval = MessageBox.Show(
"Haluatko varmasti poistaa kirjan " + current.ToString(), "Wanhat kirjat kysyy",
MessageBoxButton.YesNo);
if (retval == MessageBoxResult.Yes)
{
BookShop.DeleteBook(current);
dgBooks.DataContext = BookShop.GetBooks(true);
MessageBox.Show(string.Format("Kirja {0} on poistettu kannasta onnistuneesti", current.ToString()));
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
private void btnNew_Click(object sender, RoutedEventArgs e)
{
if (btnNew.Content.ToString() == "Uusi")
{
// Luodaan uusi kirja-olio
Book newBook = new Book(0);
newBook.Name = "Anna kirjan nimi";
spBook.DataContext = newBook;
btnNew.Content = "Tallenna uusi kantaan";
}
else
{
// Tallennetaan
Book current = (Book)spBook.DataContext;
BookShop.InsertBook(current);
dgBooks.DataContext = BookShop.GetBooks(true);
MessageBox.Show(string.Format("Kirja {0} tallennettu kantaan onnistuneesti", current.ToString()));
btnNew.Content = "Uusi";
}
}
static void Main(string[] args)
{
List <Business> allMyProfitableBusiness = new List <Business>();
BookShop bookShop1 = new BookShop(75);
AudioCDShop cd1Shop = new AudioCDShop(80);
EngineDesignPatent enginePatent = new EngineDesignPatent(1200);
BenzolMedicinePatent medicinePatent = new BenzolMedicinePatent(1450);
allMyProfitableBusiness.Add(bookShop1);
allMyProfitableBusiness.Add(cd1Shop);
allMyProfitableBusiness.Add(enginePatent);
allMyProfitableBusiness.Add(medicinePatent);
double totalProfit = 0;
foreach (var business in allMyProfitableBusiness)
{
totalProfit = totalProfit + business.GetInvestmentProfit();
Console.WriteLine("Profit: {0:c}", business.GetInvestmentProfit());
}
Console.ReadKey();
}
public static void CreateOfferContainer(Domain domain, out Key contaierKey, out Key book0Key,
out Key bookShop0Key, out Key book1Key, out Key bookShop1Key)
{
using (var session = domain.OpenSession())
using (var tx = session.OpenTransaction()) {
var book0 = new Book {
Category = "abc", Title = new Title {
Text = "title"
}
};
book0Key = book0.Key;
var bookShop0 = new BookShop {
Name = "a"
};
bookShop0Key = bookShop0.Key;
var offer0 = new Offer {
Book = book0, BookShop = bookShop0, Number = 3
};
var book1 = new Book {
Category = "abc", Title = new Title {
Text = "title"
}
};
book1Key = book1.Key;
var bookShop1 = new BookShop {
Name = "a"
};
bookShop1Key = bookShop1.Key;
var offer1 = new Offer {
Book = book1, BookShop = bookShop1, Number = 5
};
var intermediateOffer = new IntermediateOffer {
RealOffer = offer1, Number = 15
};
contaierKey = new OfferContainer {
RealOffer = offer0, IntermediateOffer = intermediateOffer, AuxField = "test"
}.Key;
tx.Complete();
}
}
/// <summary>
/// 增加一条数据
/// </summary>
public int Add(BookShop.Model.Categories model)
{
StringBuilder strSql=new StringBuilder();
strSql.Append("insert into Categories(");
strSql.Append("Name)");
strSql.Append(" values (");
strSql.Append("@Name)");
strSql.Append(";select @@IDENTITY");
SqlParameter[] parameters = {
new SqlParameter("@Name", SqlDbType.NVarChar,200)};
parameters[0].Value = model.Name;
object obj = DbHelperSQL.GetSingle(strSql.ToString(),parameters);
if (obj == null)
{
return 0;
}
else
{
return Convert.ToInt32(obj);
}
}
public ActionResult Create([Bind(Include = "ID,Username,SDT,Pass,DiaChi,Email,Quyen,RePass")] TaiKhoan taiKhoan)
{
using (BookShop db = new BookShop())
{
var v = db.TaiKhoan.Where(x => x.Username == taiKhoan.Username).FirstOrDefault();
if (v != null)
{
ModelState.AddModelError("", "Tên đăng nhập đã tồn tại");
}
else
{
if (ModelState.IsValid)
{
taiKhoan.Quyen = 2;
db.TaiKhoan.Add(taiKhoan);
db.SaveChanges();
return(RedirectToAction("Index"));
}
}
}
ViewBag.Quyen = new SelectList(db.Quyen, "MaQuyen", "TenQuyen", taiKhoan.Quyen);
return(View(taiKhoan));
}
/// <summary>
/// 增加一条数据
/// </summary>
public int Add(BookShop.Model.CheckEmail model)
{
StringBuilder strSql=new StringBuilder();
strSql.Append("insert into CheckEmail(");
strSql.Append("Actived,ActiveCode)");
strSql.Append(" values (");
strSql.Append("@Actived,@ActiveCode)");
strSql.Append(";select @@IDENTITY");
SqlParameter[] parameters = {
new SqlParameter("@Actived", SqlDbType.Bit,1),
new SqlParameter("@ActiveCode", SqlDbType.NVarChar,50)};
parameters[0].Value = model.Actived;
parameters[1].Value = model.ActiveCode;
object obj = DbHelperSQL.GetSingle(strSql.ToString(),parameters);
if (obj == null)
{
return 0;
}
else
{
return Convert.ToInt32(obj);
}
}
public void SetUp()
{
var bookDataFile = File.ReadAllLines("BooksTest.txt");
_bookShop = new BookShop(bookDataFile);
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(BookShop.Model.Cart model)
{
return dal.Update(model);
}
public ProductDao()
{
db = new BookShop();
}
public FooterDao()
{
db = new BookShop();
}
/// <summary>
/// 增加一条数据
/// </summary>
public int Add(BookShop.Model.Cart model)
{
return dal.Add(model);
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(BookShop.Model.Books model)
{
StringBuilder strSql=new StringBuilder();
strSql.Append("update Books set ");
strSql.Append("Title=@Title,");
strSql.Append("Author=@Author,");
strSql.Append("PublisherId=@PublisherId,");
strSql.Append("PublishDate=@PublishDate,");
strSql.Append("WordsCount=@WordsCount,");
strSql.Append("UnitPrice=@UnitPrice,");
strSql.Append("ContentDescription=@ContentDescription,");
strSql.Append("AurhorDescription=@AurhorDescription,");
strSql.Append("EditorComment=@EditorComment,");
strSql.Append("TOC=@TOC,");
strSql.Append("CategoryId=@CategoryId,");
strSql.Append("Clicks=@Clicks");
strSql.Append(" where Id=@Id");
SqlParameter[] parameters = {
new SqlParameter("@Title", SqlDbType.NVarChar,200),
new SqlParameter("@Author", SqlDbType.NVarChar,200),
new SqlParameter("@PublisherId", SqlDbType.Int,4),
new SqlParameter("@PublishDate", SqlDbType.DateTime),
new SqlParameter("@WordsCount", SqlDbType.Int,4),
new SqlParameter("@UnitPrice", SqlDbType.Money,8),
new SqlParameter("@ContentDescription", SqlDbType.NVarChar,-1),
new SqlParameter("@AurhorDescription", SqlDbType.NVarChar,-1),
new SqlParameter("@EditorComment", SqlDbType.NVarChar,-1),
new SqlParameter("@TOC", SqlDbType.NVarChar,-1),
new SqlParameter("@CategoryId", SqlDbType.Int,4),
new SqlParameter("@Clicks", SqlDbType.Int,4),
new SqlParameter("@Id", SqlDbType.Int,4),
new SqlParameter("@ISBN", SqlDbType.NVarChar,50)};
parameters[0].Value = model.Title;
parameters[1].Value = model.Author;
parameters[2].Value = model.PublisherId;
parameters[3].Value = model.PublishDate;
parameters[4].Value = model.WordsCount;
parameters[5].Value = model.UnitPrice;
parameters[6].Value = model.ContentDescription;
parameters[7].Value = model.AurhorDescription;
parameters[8].Value = model.EditorComment;
parameters[9].Value = model.TOC;
parameters[10].Value = model.CategoryId;
parameters[11].Value = model.Clicks;
parameters[12].Value = model.Id;
parameters[13].Value = model.ISBN;
int rows=DbHelperSQL.ExecuteSql(strSql.ToString(),parameters);
if (rows > 0)
{
return true;
}
else
{
return false;
}
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(BookShop.Model.BookComment model)
{
StringBuilder strSql=new StringBuilder();
strSql.Append("update BookComment set ");
strSql.Append("Msg=@Msg,");
strSql.Append("CreateDateTime=@CreateDateTime,");
strSql.Append("BookId=@BookId");
strSql.Append(" where Id=@Id");
SqlParameter[] parameters = {
new SqlParameter("@Msg", SqlDbType.NVarChar,-1),
new SqlParameter("@CreateDateTime", SqlDbType.DateTime),
new SqlParameter("@BookId", SqlDbType.Int,4),
new SqlParameter("@Id", SqlDbType.Int,4)};
parameters[0].Value = model.Msg;
parameters[1].Value = model.CreateDateTime;
parameters[2].Value = model.BookId;
parameters[3].Value = model.Id;
int rows=DbHelperSQL.ExecuteSql(strSql.ToString(),parameters);
if (rows > 0)
{
return true;
}
else
{
return false;
}
}
/// <summary>
/// 增加一条数据
/// </summary>
public int Add(BookShop.Model.sysdiagrams model)
{
return dal.Add(model);
}
public UserDao()
{
db = new BookShop();
}
/// <summary>
/// 增加一条数据
/// </summary>
public bool Add(BookShop.Model.KeyWordsRank model)
{
return dal.Add(model);
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(BookShop.Model.KeyWordsRank model)
{
return dal.Update(model);
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(BookShop.Model.CheckEmail model)
{
StringBuilder strSql=new StringBuilder();
strSql.Append("update CheckEmail set ");
strSql.Append("Actived=@Actived,");
strSql.Append("ActiveCode=@ActiveCode");
strSql.Append(" where Id=@Id");
SqlParameter[] parameters = {
new SqlParameter("@Actived", SqlDbType.Bit,1),
new SqlParameter("@ActiveCode", SqlDbType.NVarChar,50),
new SqlParameter("@Id", SqlDbType.Int,4)};
parameters[0].Value = model.Actived;
parameters[1].Value = model.ActiveCode;
parameters[2].Value = model.Id;
int rows=DbHelperSQL.ExecuteSql(strSql.ToString(),parameters);
if (rows > 0)
{
return true;
}
else
{
return false;
}
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(BookShop.Model.Categories model)
{
StringBuilder strSql=new StringBuilder();
strSql.Append("update Categories set ");
#warning 系统发现缺少更新的字段，请手工确认如此更新是否正确！
strSql.Append("Id=@Id,");
strSql.Append("Name=@Name");
strSql.Append(" where Id=@Id");
SqlParameter[] parameters = {
new SqlParameter("@Id", SqlDbType.Int,4),
new SqlParameter("@Name", SqlDbType.NVarChar,200)};
parameters[0].Value = model.Id;
parameters[1].Value = model.Name;
int rows=DbHelperSQL.ExecuteSql(strSql.ToString(),parameters);
if (rows > 0)
{
return true;
}
else
{
return false;
}
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(BookShop.Model.OrderBook model)
{
return dal.Update(model);
}
/// <summary>
/// 增加一条数据
/// </summary>
public int Add(BookShop.Model.OrderBook model)
{
return dal.Add(model);
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(BookShop.Model.BookComment model)
{
return dal.Update(model);
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(BookShop.Model.Cart model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update Cart set ");
strSql.Append("UserId=@UserId,");
strSql.Append("BookId=@BookId,");
strSql.Append("Count=@Count");
strSql.Append(" where Id=@Id");
SqlParameter[] parameters = {
new SqlParameter("@UserId", SqlDbType.Int,4),
new SqlParameter("@BookId", SqlDbType.Int,4),
new SqlParameter("@Count", SqlDbType.Int,4),
new SqlParameter("@Id", SqlDbType.Int,4)};
parameters[0].Value = model.UserId;
parameters[1].Value = model.Book.Id;
parameters[2].Value = model.Count;
parameters[3].Value = model.Id;
int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return true;
}
else
{
return false;
}
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(BookShop.Model.Categories model)
{
return dal.Update(model);
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(BookShop.Model.sysdiagrams model)
{
return dal.Update(model);
}
internal GenericRepository(BookShop context)
{
this.context = context;
this.dbSet = context.Set <TEntity>();
}
/// <summary>
/// 增加一条数据
/// </summary>
public int Add(BookShop.Model.Categories model)
{
return dal.Add(model);
}
/// <summary>
/// 增加一条数据
/// </summary>
public int Add(BookShop.Model.BookComment model)
{
return dal.Add(model);
}
