예제 #1
0
 private void button1_Click(object sender, EventArgs e)
 {
     Model.Book m_book = new Model.Book();
     m_book = getBook();
     if(CURRENT_TYPE == 1)
     {
         bool result = bll.AddBook(m_book);
         if(result)
         {
             MessageBox.Show("书籍添加成功!");
             this.Hide();
             this.DialogResult = DialogResult.OK;
         } else
         {
             MessageBox.Show("书籍添加失败...请检查书籍编号");
         }
     } else if (CURRENT_TYPE == 2)
     {
         bool result = bll.UpdateBook(m_book);
         if (result)
         {
             MessageBox.Show("书籍更新成功!");
             this.Hide();
             this.DialogResult = DialogResult.OK;
         }
         else
         {
             MessageBox.Show("书籍添加失败...");
         }
     }
 }
예제 #2
0
 public BorrowResult(Model.Viewer _viewer, Model.Book _book, Model.Manager _manager)
 {
     InitializeComponent();
     viewer = _viewer;
     book = _book;
     manager = _manager;
     RenderData(viewer, book, manager);
 }
예제 #3
0
        public void AddBook()
        {
            Model.Book book = new Model.Book();
            book = TestHelper.initBook();

            SQLDAL.Book target = new SQLDAL.Book();
            bool actual = target.AddBook(book);
            bool expected = true;
            Assert.AreEqual(expected, actual);
        }
예제 #4
0
        public void BorrowVIdErrTest()
        {
            Model.Book book = new Model.Book();
            Model.Viewer viewer = new Model.Viewer();
            Model.Manager manager = new Model.Manager();
            book.Id = "book";
            viewer.Id = "s000001";//学号错误
            manager.Id = "manager";

            //bool expected = false;    //期望值
            //bool actual;
            int expected = 0;    //期望值
            Hashtable actual;

            SQLDAL.Book target = new SQLDAL.Book();
            actual = target.Borrow(book, viewer, manager); //实际值
            Assert.AreEqual(expected, actual["result"]);
        }
        public static Model.Book CreateBookHeader(string title, long? isbn, double? price, string url)
        {
            var b = new Model.Book();

            b.Title = title;
            if (isbn.HasValue)
            {
                b.ISBN = isbn.Value;
            }

            if (price.HasValue)
            {
                b.Price = price.Value;
            }
            b.Url = url;

            return b;
        }
예제 #6
0
        public void BorrowTest()
        {
            Model.Book book = new Model.Book();
            Model.Viewer viewer = new Model.Viewer();
            Model.Manager manager = new Model.Manager();
            book.Id = "book";
            viewer.Id = "st";
            manager.Id = "manager";

              //  bool expected = false;    //期望值//因为数据库中已经存在这一项数据 所以为false
            //bool actual;

            int expected = 0;    //期望值//因为数据库中已经存在这一项数据 所以为false
            Hashtable actual;

            SQLDAL.Book target = new SQLDAL.Book();
            actual = target.Borrow(book, viewer, manager); //实际值
            Assert.AreEqual(expected, actual["result"]);
        }
예제 #7
0
 //-----------------------------------------------------------
 /// <summary>
 /// 生成静态页面 id:要生成静态页面的书的编号
 /// </summary>
 public bool CreateHtmlPage(int id)
 {
     Model.Book bookModel = dal.GetModel(id);
     if (bookModel != null)
     {
         //找到模板文件.
         string filePath    = HttpContext.Current.Request.MapPath("/Template/BookTemplate.html");
         string fileContent = File.ReadAllText(filePath);
         fileContent = fileContent.Replace("$author", bookModel.Author).Replace("$title", bookModel.Title).Replace("$wordCount", bookModel.WordsCount.ToString()).Replace("$publishDate", bookModel.PublishDate.ToShortDateString()).Replace("$isbn", bookModel.ISBN).Replace("$unitPrice", bookModel.UnitPrice.ToString("0.00")).Replace("$toc", bookModel.TOC).Replace("$content", bookModel.ContentDescription).Replace("$authorDesc", bookModel.AurhorDescription).Replace("$bookId", bookModel.Id.ToString());
         string dir = "/BookDetails/" + bookModel.PublishDate.Year + "/" + bookModel.PublishDate.Month + "/" + bookModel.PublishDate.Day + "/";
         Directory.CreateDirectory(Path.GetDirectoryName(HttpContext.Current.Request.MapPath(dir)));
         string fullDir = dir + bookModel.Id + ".html";
         File.WriteAllText(HttpContext.Current.Request.MapPath(fullDir), fileContent, System.Text.Encoding.UTF8);
         return(true);
     }
     else
     {
         return(false);
     }
 }
예제 #8
0
 public void ProcessRequest(HttpContext context)
 {
     context.Response.ContentType = "text/plain";
     BLL.UserManager userManager = new BLL.UserManager();
     if (userManager.ValidateUserLogin())//判断是否登录
     {
         int bookId = Convert.ToInt32(context.Request["bookId"]);
         //判断数据库中是否有该商品.
         BLL.BookManager bookManager = new BLL.BookManager();
         Model.Book      bookModel   = bookManager.GetModel(bookId);
         if (bookModel != null)
         {
             int             userId      = ((Model.User)context.Session["userInfo"]).Id;//获取登录用户登录的ID。
             BLL.CartManager cartManager = new BLL.CartManager();
             Model.Cart      cartModel   = cartManager.GetModel(userId, bookId);
             //如果购物车有该商品,更新数量加1,没有插入
             if (cartModel != null)
             {
                 cartModel.Count = cartModel.Count + 1;
                 cartManager.Update(cartModel);
             }
             else
             {
                 Model.Cart modelCart = new Model.Cart();
                 modelCart.Count = 1;
                 modelCart.Book  = bookModel;
                 modelCart.User  = ((Model.User)context.Session["userInfo"]);
                 cartManager.Add(modelCart);
             }
             context.Response.Write("ok:商品成功添加到购物车");
         }
         else
         {
             context.Response.Write("no:无此商品");
         }
     }
     else
     {
         context.Response.Write("login:没有登录");
     }
 }
예제 #9
0
        /// <summary>
        /// 将商品的信息生成静态页面
        /// </summary>
        public void CreateHtmlPage(int id)
        {
            //根据每一本书的 内容生成一个 静态页面。
            Model.Book model = dal.GetModel(id);
            //获取模板文件
            string template    = HttpContext.Current.Request.MapPath("/Template/BookTemplate.html");
            string fileContent = File.ReadAllText(template);

            fileContent = fileContent.Replace("$title", model.Title)
                          .Replace("$author", model.Author)
                          .Replace("$unitprice", model.UnitPrice.ToString("0.00"))
                          .Replace("$isbn", model.ISBN)
                          .Replace("$content", model.ContentDescription.Substring(0, 15))
                          .Replace("$bookId", model.Id.ToString());
            string dir = "/HtmlPage/" + model.PublishDate.Year + "/" + model.PublishDate.Month + "/" + model.PublishDate.Day + "/";

            Directory.CreateDirectory(Path.GetDirectoryName(HttpContext.Current.Request.MapPath(dir)));
            string fullDir = dir + model.Id + ".html";

            File.WriteAllText(HttpContext.Current.Request.MapPath(fullDir), fileContent, System.Text.Encoding.UTF8);
        }
예제 #10
0
        public ActionResult TestAddQueue()
        {
            Model.Book model = new Model.Book();
            model.AuthorDescription  = "adsfad";
            model.Author             = "老赵";
            model.CategoryId         = 1;
            model.Clicks             = 1;
            model.ContentDescription = "Asp.Net MVC高级编程";
            model.EditorComment      = "adfasdf";
            model.ISBN        = "984598234";
            model.PublishDate = DateTime.Now;
            model.PublisherId = 72;
            model.TOC         = "aaaaaaa";
            model.UnitPrice   = 22.3m;
            model.WordsCount  = 1234;

            //先将数据储存到数据库中
            //然后再向队列中添加
            SearchIndexManager.GetInstance().AddQueue("2323", model.Title, model.ContentDescription);

            return(Content("ok"));
        }
예제 #11
0
파일: Frm主面.cs 프로젝트: bxj975/photo1
        private void button1_Click(object sender, EventArgs e)
        {
            if (this.textBox1.Text == "")
            {
                MessageBox.Show("编码输入不能为空!");
                return;
            }
            string Uname = this.textBox1.Text.Trim();

            Model.Book book = DAL.dalCustom.getSomePhoto(Uname);
            if (book.bookPhoto == null)
            {
                MessageBox.Show("没有图片!");
                return;
            }
            else
            {
                byte[]       bookPhoto = (byte[])(book.bookPhoto);
                MemoryStream ms        = new MemoryStream(bookPhoto);
                pictureBox1.Image = Image.FromStream(ms);
            }
        }
예제 #12
0
 /// <summary>
 /// 向购物车中添加商品信息。
 /// </summary>
 protected void AddCart()
 {
     if (!string.IsNullOrEmpty(Request.QueryString["id"]))
     {
         int bookId = 0;
         if (!int.TryParse(Request.QueryString["id"], out bookId))
         {
             Response.Redirect("/showinfo.aspx?msg=" + Server.UrlEncode("参数错误") + "&url=BookList.aspx" + "&txt=" + Server.UrlEncode("返回图书列表"));
         }
         else
         {
             BLL.BookManager bll   = new BookShop.BLL.BookManager();
             Model.Book      model = bll.GetModel(bookId);//根据传递过来的书的编号查找该书.
             if (model != null)
             {
                 BLL.CartManager cartBll   = new BookShop.BLL.CartManager();
                 int             userId    = ((Model.User)Session["user"]).Id;   //得到了当前登录用户的编号.
                 Model.Cart      cartModel = cartBll.GetModel(model.Id, userId); //根据用户的编号,与书的编号,找出购物车中的商品项.
                 if (cartModel == null)                                          //如果该条件成立,向购物车表中插入一条记录
                 {
                     Model.Cart ModelCart = new BookShop.Model.Cart();
                     ModelCart.User  = (Model.User)Session["user"];
                     ModelCart.Book  = model;
                     ModelCart.Count = 1;
                     cartBll.Add(ModelCart);
                 }
                 else//更新该商品项的数量
                 {
                     cartModel.Count = cartModel.Count + 1;
                     cartBll.Update(cartModel);
                 }
             }
             else
             {
                 Response.Redirect("/showinfo.aspx?msg=" + Server.UrlEncode("该书不存在") + "&url=BookList.aspx" + "&txt=" + Server.UrlEncode("返回图书列表"));
             }
         }
     }
 }
예제 #13
0
        //EDIT BOOK
        public Book EditedBook(Model.Book edited)
        {
            using (var connection = GetConnection())
            {
                connection.Open();

                MySqlCommand command = new MySqlCommand(
                    "UPDATE tanya_project SET author = @a, title = @t, genre = @g, year=@y WHERE id = @id", connection);

                command.Parameters.AddWithValue("@a", edited.author);
                command.Parameters.AddWithValue("@t", edited.title);
                command.Parameters.AddWithValue("@g", edited.genre);
                command.Parameters.AddWithValue("@y", edited.year);
                command.Parameters.AddWithValue("@id", edited.id);

                var numUpdated = command.ExecuteNonQuery();

                Console.WriteLine("Updated {0} user records!", numUpdated);

                return(edited);
            }
        }
예제 #14
0
 protected void Page_Load(object sender, EventArgs e)
 {
     if (!string.IsNullOrEmpty(Request.QueryString["id"]))
     {
         int id = 0;
         if (!int.TryParse(Request.QueryString["id"], out id))
         {
             Response.Redirect("BookList2.aspx");
         }
         else
         {
             BLL.BookManager bll   = new BookShop.BLL.BookManager();
             Model.Book      model = bll.GetModel(id);//根据书的编号,查找该书.
             if (model != null)
             {
                 StringBuilder builder = new StringBuilder();
                 builder.Append("<table border='1' >");
                 builder.Append("<tr><th width='30px'>书名:</th><td>" + model.Title + "</td></tr>");
                 builder.Append("<tr><th>封面:</th><td><img src=/Images/BookCovers/" + model.ISBN + ".jpg/></td></tr>");
                 builder.Append("<tr><th>作者:</th><td>" + model.Author + "</td></tr>");
                 builder.Append("<tr><th>出版日期::</th><td>" + model.PublishDate.ToShortDateString() + "</td></tr>");
                 builder.Append("<tr><th>单价:</th><td>&yen;" + model.UnitPrice.ToString("0.00") + "<a href='cart.aspx?id=" + model.Id + "'><img src='/Images/sale.gif' border='0'/></a></td></tr>");
                 builder.Append("<tr><th>简介:</th><td>" + model.ContentDescription + "</td></tr>");
                 builder.Append("<tr><th>目录::</th><td>" + model.TOC + "</td></tr>");
                 builder.Append("</table>");
                 strHtml = builder.ToString();
             }
             else
             {
                 Response.Redirect("/showinfo.aspx?msg=" + Server.UrlEncode("图书部存在") + "&url=/BookList2.aspx" + "&txt=" + Server.UrlEncode("图书列表页面"));
             }
         }
     }
     else
     {
         Response.Redirect("BookList2.aspx");
     }
 }
예제 #15
0
        public async Task <IActionResult> OnGet(int?id)
        {
            Book = new Model.Book();

            if (!id.HasValue)
            {
                //Create
                return(Page());
            }

            //Update
            //You can use FindAsync or FirstOrDefaultAsync to get the book from the DB.
            Book = await _dbContext.Books.FindAsync(id);

            //Book = await _dbContext.Books.FirstOrDefaultAsync(b => b.Id == id);

            if (Book == null)
            {
                return(NotFound());
            }

            return(Page());
        }
예제 #16
0
 public async Task OnGet(int id)
 {
     Book = await _db.Book.FindAsync(id);
 }
예제 #17
0
        public void DeleteBook()
        {
            Model.Book book = new Model.Book();
            book = TestHelper.initBook();
            book.Id = book.Id + "TEST";

            //先添加这本书
            SQLDAL.Book target = new SQLDAL.Book();
            bool actual = target.AddBook(book);
            bool expected = true;
            Assert.AreEqual(expected, actual);

            //删除这本书
            bool actual_2 = target.DeleteBook(book);
            bool expected_2 = true;
            Assert.AreEqual(expected_2, actual_2);
        }
예제 #18
0
        public void MulBorrowTest()
        {
            Model.Book book = new Model.Book();
            Model.Viewer viewer = new Model.Viewer();
            Model.Manager manager = new Model.Manager();
            book.Id = "9787513318525";
            viewer.Id = "st";
            manager.Id = "manager";

               // bool expected = false;    //期望值
            //bool actual;
            int expected = -1;    //期望值 已经借过的返回值为-1
            Hashtable actual;

            SQLDAL.Book target = new SQLDAL.Book();
            target.Borrow(book, viewer, manager);//第一次借
            actual = target.Borrow(book, viewer, manager); //实际值//第二次借
            Assert.AreEqual(expected, actual["result"]);
            //由于系统限制每个人只能借同一本书一次 所以测试时只有第一次是能成功
        }
예제 #19
0
        public void UpdateBook()
        {
            Model.Book book = new Model.Book();
            book = TestHelper.initBook();
            book.Id = "DKLFJO2342";
            //测试用

            SQLDAL.Book target = new SQLDAL.Book();
            bool actual = target.UpdateBook(book);
            bool expected = true;
            Assert.AreEqual(expected, actual);
        }
예제 #20
0
        public void ReturnTest()
        {
            Model.Book book = new Model.Book();
            Model.Viewer viewer = new Model.Viewer();
            Model.Manager manager = new Model.Manager();
            book.Id = "9787569902921";
            viewer.Id = "s001";
            manager.Id = "manager";

            bool expected = false;    //期望值//因为数据库中已经存在这一项数据 所以为false
            bool actual;

            SQLDAL.Book target = new SQLDAL.Book();
            actual = target.ReturnBook(viewer, book, manager); //实际值
            Assert.AreEqual(expected, actual);
        }
예제 #21
0
        private Book ConvertToGraphQLBook(Model.Book modelBook, bool includeAuthor = false)
        {
            var modelAuthor = includeAuthor ? authorsDataSource.GetAuthor(modelBook.AuthorId) : null;

            return(BookMapper.ConvertModelBookToGraphQLBook(modelBook, modelAuthor));
        }
예제 #22
0
 public static void DeleteBook(Model.Book book)
 {
 }
예제 #23
0
 public Product(Book b)
 {
     book = b;
 }
예제 #24
0
파일: Book.cs 프로젝트: thanhphat/ibookstop
        public List<Model.Book> GetEnglishBook(Int64 _BookID, Int64 _CategoryID, string _CategoryName, string _Title, string _Author, string _Publisher, string _PublishYear, string _Language, int _Status, int _NewRelease, int _BookFeature, int _EnglishBook, int _Start, int _Limit)
        {
            List<Model.Book> lModel = new List<Model.Book>();

            try
            {

                SqlParameter[] p =  {
                                        new SqlParameter("@BookID", SqlDbType.Int, 4),
                                        new SqlParameter("@CategoryID", SqlDbType.Int, 4),
                                        new SqlParameter("@CategoryName", SqlDbType.NVarChar, 250),
                                        new SqlParameter("@Title", SqlDbType.NVarChar, 250),
                                        new SqlParameter("@Author", SqlDbType.NVarChar, 250),
                                        new SqlParameter("@Publisher", SqlDbType.NVarChar, 250),
                                        new SqlParameter("@PublishYear", SqlDbType.NVarChar, 250),
                                        new SqlParameter("@Language", SqlDbType.NVarChar, 250),
                                        new SqlParameter("@Status", SqlDbType.Int, 4),
                                        new SqlParameter("@NewRelease", SqlDbType.Int, 4),
                                        new SqlParameter("@BookFeature", SqlDbType.Int, 4),
                                        new SqlParameter("@Start", SqlDbType.Int, 4),
                                        new SqlParameter("@Limit", SqlDbType.Int, 4),
                                        new SqlParameter("@EnglishBook", SqlDbType.Int, 4)
                                    };

                p[0].Value = _BookID;
                p[1].Value = _CategoryID;
                p[2].Value = _CategoryName;
                p[3].Value = _Title;
                p[4].Value = _Author;
                p[5].Value = _Publisher;
                p[6].Value = _PublishYear;
                p[7].Value = _Language;
                p[8].Value = _Status;
                p[9].Value = _NewRelease;
                p[10].Value = _BookFeature;
                p[11].Value = _Start;
                p[12].Value = _Limit;
                p[13].Value = _EnglishBook;

                DataTable dt = db.ExcuteSelectReturnDataTable("EnglishBook_Select", CommandType.StoredProcedure, p);

                if (dt.Rows.Count > 0)
                {
                    foreach (DataRow dr in dt.Rows)
                    {
                        Model.Book model = new Model.Book();

                        model.Ind = Convert.ToInt32(dr["Ind"]);
                        model.BookID = Convert.ToInt64(dr["BookID"]);
                        model.Code = dr["Code"].ToString();
                        model.Title = dr["Title"].ToString();
                        model.TitleUrl = dr["TitleUrl"].ToString();
                        model.Author = dr["Author"].ToString();
                        model.Publisher = dr["Publisher"].ToString();
                        model.PublishYear = dr["PublishYear"].ToString();
                        model.Language = dr["Language"].ToString();
                        model.PageNumber = Convert.ToInt32(dr["PageNumber"]);
                        model.Price = Convert.ToInt32(dr["Price"]);
                        model.PriceText = dr["PriceText"].ToString();
                        model.Amount = Convert.ToInt32(dr["Amount"]);
                        model.Rating = Convert.ToInt16(dr["Rating"]);
                        model.SmallPicture = dr["SmallPicture"].ToString();
                        model.BigPicture = dr["BigPicture"].ToString();
                        model.Intro = dr["Intro"].ToString();
                        model.Content = dr["Content"].ToString();
                        model.Status = Convert.ToInt16(dr["Status"]);
                        model.BookFeature = Convert.ToInt16(dr["BookFeature"]);
                        model.NewRelease = Convert.ToInt16(dr["NewRelease"]);
                        model.EnglishBook = Convert.ToInt16(dr["EnglishBook"]);
                        model.Particular = dr["Particular"].ToString();
                        model.Deleted = Convert.ToInt32(dr["Deleted"]);
                        model.DeleteBy = dr["DeleteBy"].ToString();
                        model.DeleteTime = dr["DeleteTime"].ToString();
                        model.CreateBy = dr["CreateBy"].ToString();
                        model.CreateTime = dr["CreateTime"].ToString();
                        model.UpdateBy = dr["UpdateBy"].ToString();
                        model.UpdateTime = dr["UpdateTime"].ToString();
                        model.TotalRow = Convert.ToInt64(dr["TotalRow"]);

                        // Lay danh sach BookCategory
                        BLL.BookCategory bll_bookcategory = BLL.BookCategory.Instance;
                        List<Model.BookCategory> BookCategoryList = bll_bookcategory.GetList(-1, -1, _BookID, 1, 1, 1000);
                        model.BookCategory = BookCategoryList;

                        lModel.Add(model);
                    }

                }

            }
            catch (Exception ex)
            {
                PTSLog.Error(ex.Message);
            }

            return lModel;
        }
예제 #25
0
 private Model.Book getBook()
 {
     Model.Book book = new Model.Book();
     book.Name = textBox1.Text;
     book.Id = textBox2.Text;
     book.Author = textBox3.Text;
     book.Publisher = textBox4.Text;
     book.Amount = textBox5.Text;
     return book;
 }
예제 #26
0
        public static void InitTestDBContext(ECAEntities @this)
        {
            using (SpreadsheetDocument mySpreadsheet = SpreadsheetDocument.Open(@"../../TestData.xlsx", false))
            {
                var sheets = mySpreadsheet.WorkbookPart.Workbook.Sheets;
                SharedStringTable stringTable = mySpreadsheet.WorkbookPart.SharedStringTablePart.SharedStringTable;

                //Author
                Sheet sAuthor = sheets.Descendants<Sheet>().Where(s => s.Name == "Author").FirstOrDefault();
                WorksheetPart wsPart = mySpreadsheet.WorkbookPart.GetPartById(sAuthor.Id) as WorksheetPart;
                SheetData sheetData = wsPart.Worksheet.Elements<SheetData>().First();

                @this.Authors = new FakeDbSet<Model.Author>();
                foreach (Row r in sheetData.Elements<Row>())
                {
                    if (r.RowIndex == 1)
                        continue;

                    ECA.Model.Author author = new Model.Author();
                    author.AuthorId = GetStringValue(stringTable, r.Elements<Cell>().ElementAt(0), 0);
                    author.AuthorName = GetStringValue(stringTable, r.Elements<Cell>().ElementAt(1), 1);
                    @this.Authors.Add(author);
                }

                //Book
                Sheet sBook = sheets.Descendants<Sheet>().Where(s => s.Name == "Book").FirstOrDefault();
                wsPart = mySpreadsheet.WorkbookPart.GetPartById(sBook.Id) as WorksheetPart;
                sheetData = wsPart.Worksheet.Elements<SheetData>().First();

                @this.Books = new FakeDbSet<Model.Book>();

                foreach (Row r in sheetData.Elements<Row>())
                {
                    if (r.RowIndex == 1)
                        continue;
                    ECA.Model.Book book = new Model.Book();
                    book.ID = GetStringValue(stringTable, r.Elements<Cell>().ElementAt(0), 0);
                    book.Title = GetStringValue(stringTable, r.Elements<Cell>().ElementAt(1), 1);
                    book.Description = GetStringValue(stringTable, r.Elements<Cell>().ElementAt(2), 2);
                    book.AuthorId = GetStringValue(stringTable, r.Elements<Cell>().ElementAt(3), 3);
                    book.GenreId = GetStringValue(stringTable, r.Elements<Cell>().ElementAt(4), 4);
                    book.CategoryId = GetStringValue(stringTable, r.Elements<Cell>().ElementAt(5), 5);
                    book.ISBN = GetStringValue(stringTable, r.Elements<Cell>().ElementAt(6), 6);
                    @this.Books.Add(book);
                }
                //Book Category
                Sheet sBookCategory = sheets.Descendants<Sheet>().Where(s => s.Name == "BookCategory").FirstOrDefault();
                wsPart = mySpreadsheet.WorkbookPart.GetPartById(sBookCategory.Id) as WorksheetPart;
                sheetData = wsPart.Worksheet.Elements<SheetData>().First();

                @this.BookCategories  = new FakeDbSet<Model.BookCategory>();

                foreach (Row r in sheetData.Elements<Row>())
                {
                    if (r.RowIndex == 1)
                        continue;
                    ECA.Model.BookCategory category = new Model.BookCategory();
                    category.CategoryId = GetStringValue(stringTable, r.Elements<Cell>().ElementAt(0), 0);
                    category.CategoryName = GetStringValue(stringTable, r.Elements<Cell>().ElementAt(1), 1);

                    @this.BookCategories.Add(category);
                }

                //Genre
                Sheet sGenre = sheets.Descendants<Sheet>().Where(s => s.Name == "Genre").FirstOrDefault();
                wsPart = mySpreadsheet.WorkbookPart.GetPartById(sGenre.Id) as WorksheetPart;
                sheetData = wsPart.Worksheet.Elements<SheetData>().First();

                @this.Genres = new FakeDbSet<Model.Genre>();

                foreach (Row r in sheetData.Elements<Row>())
                {
                    if (r.RowIndex == 1)
                        continue;
                    ECA.Model.Genre genre = new Model.Genre();
                    genre.GenreId = GetStringValue(stringTable, r.Elements<Cell>().ElementAt(0), 0);
                    genre.GenreName = GetStringValue(stringTable, r.Elements<Cell>().ElementAt(1), 1);
                    @this.Genres.Add(genre);
                }
                //Shopping Cart
                Sheet sCart = sheets.Descendants<Sheet>().Where(s => s.Name == "Cart").FirstOrDefault();
                wsPart = mySpreadsheet.WorkbookPart.GetPartById(sCart.Id) as WorksheetPart;
                sheetData = wsPart.Worksheet.Elements<SheetData>().First();

                @this.Carts  = new FakeDbSet<Model.Cart>();

                foreach (Row r in sheetData.Elements<Row>())
                {
                    if (r.RowIndex == 1)
                        continue;
                    ECA.Model.Cart cart = new Model.Cart();

                    cart.UserId  =  Convert.ToInt32( r.Elements<Cell>().ElementAt(0).CellValue.Text);
                    cart.ItemCode = GetStringValue(stringTable, r.Elements<Cell>().ElementAt(1), 1);
                    cart.Quantity  = Convert.ToInt32(r.Elements<Cell>().ElementAt(2).CellValue.Text);
                    @this.Carts.Add(cart);
                }
                //Users
                Sheet sUser = sheets.Descendants<Sheet>().Where(s => s.Name == "User").FirstOrDefault();
                wsPart = mySpreadsheet.WorkbookPart.GetPartById(sUser.Id) as WorksheetPart;
                sheetData = wsPart.Worksheet.Elements<SheetData>().First();

                @this.Users  = new FakeDbSet<Model.User>();

                foreach (Row r in sheetData.Elements<Row>())
                {
                    if (r.RowIndex == 1)
                        continue;
                    ECA.Model.User  user = new Model.User();
                    user.UserId = Convert.ToInt32(r.Elements<Cell>().ElementAt(0).CellValue.Text);
                    user.UserName = GetStringValue(stringTable, r.Elements<Cell>().ElementAt(1), 1);
                    @this.Users.Add(user);

                }
                //Roles
                Sheet sRoles = sheets.Descendants<Sheet>().Where(s => s.Name == "Role").FirstOrDefault();
                wsPart = mySpreadsheet.WorkbookPart.GetPartById(sRoles.Id) as WorksheetPart;
                sheetData = wsPart.Worksheet.Elements<SheetData>().First();

                @this.webpages_Roles  = new FakeDbSet<Model.webpages_Roles>();

                foreach (Row r in sheetData.Elements<Row>())
                {
                    if (r.RowIndex == 1)
                        continue;
                    ECA.Model.webpages_Roles role = new Model.webpages_Roles();
                    role.RoleId  = Convert.ToInt32(r.Elements<Cell>().ElementAt(0).CellValue.Text);
                    role.RoleName = GetStringValue(stringTable, r.Elements<Cell>().ElementAt(1), 1);
                    @this.webpages_Roles.Add(role);

                }
                @this.webpages_Roles.Where(r => r.RoleId == 1).FirstOrDefault().Users = new List<User>()
                {
                    new User(){ UserId = 1, UserName = "******"},
                    new User(){ UserId = 2,UserName = "******"}
                };
                @this.webpages_Roles.Where(r => r.RoleId == 2).FirstOrDefault().Users = new List<User>()
                {
                    new User(){ UserId = 3, UserName = "******"}
                };
                //Membership
                Sheet sMembership = sheets.Descendants<Sheet>().Where(s => s.Name == "Membership").FirstOrDefault();
                wsPart = mySpreadsheet.WorkbookPart.GetPartById(sMembership.Id) as WorksheetPart;
                sheetData = wsPart.Worksheet.Elements<SheetData>().First();

                @this.webpages_Membership  = new FakeDbSet<Model.webpages_Membership>();

                foreach (Row r in sheetData.Elements<Row>())
                {
                    if (r.RowIndex == 1)
                        continue;
                    ECA.Model.webpages_Membership membership = new Model.webpages_Membership();
                    membership.UserId = Convert.ToInt32(r.Elements<Cell>().ElementAt(0).CellValue.Text);
                    membership.Password  = GetStringValue(stringTable, r.Elements<Cell>().ElementAt(6), 6);
                    @this.webpages_Membership.Add(membership);

                }
            }
        }
예제 #27
0
 public void ProcessRequest(HttpContext context)
 {
     if (!string.IsNullOrEmpty(context.Request.Form["action"]))
     {
         string action = context.Request.Form["action"];
         if (action == "change")//更新商品数量
         {
             int pk, bookId, count;
             if (!int.TryParse(context.Request.Form["pk"], out pk))
             {
                 context.Response.Write("no-参数错误!");
                 return;
             }
             if (!int.TryParse(context.Request.Form["count"], out count))
             {
                 context.Response.Write("no-参数错误!");
                 return;
             }
             if (!int.TryParse(context.Request.Form["bookId"], out bookId))
             {
                 context.Response.Write("no-参数错误!");
                 return;
             }
             BLL.BookManager bookBll   = new BookShop.BLL.BookManager();
             Model.Book      modelBook = bookBll.GetModel(bookId);
             if (modelBook != null)//看一下该书是否存在
             {
                 BLL.CartManager cartBll   = new BookShop.BLL.CartManager();
                 Model.Cart      cartModel = cartBll.GetModel(pk);
                 if (cartModel != null)//根据主键查找该购物车中商品项
                 {
                     cartModel.Count = count;
                     cartBll.Update(cartModel);//完成数量的更新
                     context.Response.Write("yes");
                 }
                 else
                 {
                     context.Response.Write("no");
                     return;
                 }
             }
             else
             {
                 context.Response.Write("no");
             }
         }
         //删除一条记录
         else if (action == "delete")
         {
             if (!string.IsNullOrEmpty(context.Request.Form["pk"]))
             {
                 int pkId = 0;
                 if (!int.TryParse(context.Request.Form["pk"], out pkId))
                 {
                     context.Response.Write("no");
                     return;
                 }
                 BLL.CartManager bllCart = new BookShop.BLL.CartManager();
                 bllCart.Delete(pkId);
                 context.Response.Write("yes");
             }
         }
     }
 }
예제 #28
0
        public void getRecordBorrowTime()
        {
            string b_id = "9787550264601";
            string r_id = "s001";
            Model.Viewer v = new Model.Viewer();
            v.Id = r_id;
            Model.Book b = new Model.Book();
            b.Id = b_id;

            DateTime expected = new DateTime();    //期望值
            expected = Convert.ToDateTime("2015-12-15");
            DateTime actual;

            SQLDAL.Record target = new SQLDAL.Record();
            actual = target.getRecordBorrowTime(b, v); //实际值
            Assert.AreEqual(expected, actual);
        }
예제 #29
0
        public void ReturnBIdErrTest()
        {
            string b_id = "9787550264";
            string r_id = "s001";
            Model.Viewer v = new Model.Viewer();
            v.Id = r_id;
            Model.Book b = new Model.Book();
            b.Id = b_id;
            Model.Manager m = new Model.Manager();
            //m.Id = m_id;
            //Model.Book book = new Model.Book();
            //Model.Viewer viewer = new Model.Viewer();
            Model.Manager manager = new Model.Manager();
            //book.Id = "boo";//书号错误
            //viewer.Id = "st";
            manager.Id = "manager";

            bool expected = false;    //期望值
            bool actual;

            SQLDAL.Book target = new SQLDAL.Book();
            actual = target.ReturnBook(v, b, manager); //实际值
            Assert.AreEqual(expected, actual);
        }
예제 #30
0
        public void MulReturnTest()
        {
            Model.Book book = new Model.Book();
            Model.Viewer viewer = new Model.Viewer();
            Model.Manager manager = new Model.Manager();
            book.Id = "9787513318525";
            viewer.Id = "st";
            manager.Id = "manager";

            bool expected = false;    //期望值
            bool actual;

            SQLDAL.Book target = new SQLDAL.Book();
            target.ReturnBook(viewer, book, manager); //第一次还
            actual = target.ReturnBook(viewer, book, manager); //实际值//第二次还
            Assert.AreEqual(expected, actual);
        }
예제 #31
0
 public void Delete(int id)
 {
     Model.Book book = Get(id);
     _dataContext.Books.Remove(book);
     _dataContext.SaveChanges();
 }
예제 #32
0
 public Boolean Delete(Model.Book book)
 {
     return(false);
 }
예제 #33
0
 public async Task OnGet(int id)
 {
     Book = await _dbContext.Books.FindAsync(id);
 }
예제 #34
0
 public IActionResult Get(int id)
 {
     Model.Book book = _bookRepository.Get(id);
     return(new JsonResult(book));
 }
예제 #35
0
파일: Book.cs 프로젝트: thanhphat/ibookstop
        public List<Model.Book> SearchResult(string _Keyword, int _Start, int _Limit)
        {
            List<Model.Book> lModel = new List<Model.Book>();

            try
            {

                SqlParameter[] p =  {
                                        new SqlParameter("@Keyword", SqlDbType.NVarChar, 250),
                                        new SqlParameter("@Start", SqlDbType.Int, 4),
                                        new SqlParameter("@Limit", SqlDbType.Int, 4)
                                    };

                p[0].Value = _Keyword;
                p[1].Value = _Start;
                p[2].Value = _Limit;

                DataTable dt = db.ExcuteSelectReturnDataTable("Book_Search", CommandType.StoredProcedure, p);

                if (dt.Rows.Count > 0)
                {
                    foreach (DataRow dr in dt.Rows)
                    {
                        Model.Book model = new Model.Book();

                        model.Ind = Convert.ToInt32(dr["Ind"]);
                        model.BookID = Convert.ToInt64(dr["BookID"]);
                        model.Code = dr["Code"].ToString();
                        model.Title = dr["Title"].ToString();
                        model.TitleUrl = dr["TitleUrl"].ToString();
                        model.Author = dr["Author"].ToString();
                        model.Publisher = dr["Publisher"].ToString();
                        model.PublishYear = dr["PublishYear"].ToString();
                        model.Language = dr["Language"].ToString();
                        model.PageNumber = Convert.ToInt32(dr["PageNumber"]);
                        model.Price = Convert.ToInt32(dr["Price"]);
                        model.PriceText = dr["PriceText"].ToString();
                        model.Amount = Convert.ToInt32(dr["Amount"]);
                        model.Rating = Convert.ToInt16(dr["Rating"]);
                        model.SmallPicture = dr["SmallPicture"].ToString();
                        model.BigPicture = dr["BigPicture"].ToString();
                        model.Intro = dr["Intro"].ToString();
                        model.Content = dr["Content"].ToString();
                        model.Status = Convert.ToInt16(dr["Status"]);
                        model.BookFeature = Convert.ToInt16(dr["BookFeature"]);
                        model.NewRelease = Convert.ToInt16(dr["NewRelease"]);
                        model.EnglishBook = Convert.ToInt16(dr["EnglishBook"]);
                        model.Particular = dr["Particular"].ToString();
                        model.Deleted = Convert.ToInt32(dr["Deleted"]);
                        model.DeleteBy = dr["DeleteBy"].ToString();
                        model.DeleteTime = dr["DeleteTime"].ToString();
                        model.CreateBy = dr["CreateBy"].ToString();
                        model.CreateTime = dr["CreateTime"].ToString();
                        model.UpdateBy = dr["UpdateBy"].ToString();
                        model.UpdateTime = dr["UpdateTime"].ToString();
                        model.TotalRow = Convert.ToInt64(dr["TotalRow"]);

                        lModel.Add(model);
                    }

                }

            }
            catch (Exception ex)
            {
                PTSLog.Error(ex.Message);
            }

            return lModel;
        }
예제 #36
0
 public IActionResult Insert([FromBody] Model.Book book)
 {
     _bookRepository.Insert(book);
     return(new JsonResult(book));
 }
예제 #37
0
 public static void SaveBook(Model.Book book)
 {
 }
예제 #38
0
 public IActionResult Update([FromBody] Model.Book book)
 {
     _bookRepository.Update(book);
     return(new JsonResult(book));
 }
예제 #39
0
        public static Model.Book initBook()
        {
            string b_id = TestHelper.getString(10);
            ChineseString.RandomChinese str = new ChineseString.RandomChinese();
            string book_name = str.GetRandomChinese(5);
            string author = str.GetRandomChinese(3);
            string publisher = str.GetRandomChinese(2) + "出版社";
            int amout = TestHelper.getRandomNum(20, 50);

            Model.Book book = new Model.Book();
            book.Id = b_id;
            book.Name = book_name;
            book.Author = author;
            book.Publisher = publisher;
            book.Amount = amout.ToString();
            return book;
        }
예제 #40
0
        public void ReturnVIdErrTest()
        {
            Model.Book book = new Model.Book();
            Model.Viewer viewer = new Model.Viewer();
            Model.Manager manager = new Model.Manager();
            book.Id = "book";
            viewer.Id = "s00001";//学号错误
            manager.Id = "manager";

            bool expected = false;    //期望值
            bool actual;

            SQLDAL.Book target = new SQLDAL.Book();
            actual = target.ReturnBook(viewer, book, manager); //实际值
            Assert.AreEqual(expected, actual);
        }
예제 #41
0
        protected void btnSubmit_Click(object sender, EventArgs e)
        {
            string _createBy = "";
            if (Utils.GetCookie(PTSKeys.ADMIN_NAME, PTSKeys.CDL_CMS_KEY) != null)
            {
                _createBy = Utils.GetCookie(PTSKeys.ADMIN_NAME, PTSKeys.CDL_CMS_KEY);
            }

            string[] albumArr = Request.Form.GetValues("hide_book_category");

            List<Model.BookCategory> bookCategory = new List<Model.BookCategory>();

            if (null != albumArr && albumArr.Length > 0)
            {
                for (int i = 0; i < albumArr.Length; i++)
                {
                    bookCategory.Add(new Model.BookCategory {
                                        BookID = this.id, CategoryID = Convert.ToInt32(albumArr[i]), Status = 1, CreateBy = _createBy });
                }
            }

            Model.Book model = new Model.Book();

            if (this.id > 0)
            {
               model = bll.GetModel(this.id, -1, "", "", "", "", "", "", -1, -1, -1, 1, 1);
            }

            model.Title = txtTitle.Text.Trim();
            model.TitleUrl = Utils.GenURL(txtTitle.Text.Trim());
            model.Author = txtAuthor.Text.Trim();
            model.Publisher = txtPublisher.Text.Trim();
            model.PublishYear = txtPublishYear.Text.Trim();
            model.Language = txtLanguage.Text.Trim();
            model.PageNumber = Convert.ToInt32(txtPageNumber.Text.Trim());
            model.Price = Convert.ToInt32(txtPrice.Text.Trim());
            model.Rating = Convert.ToInt32(txtRating.Text.Trim());
            model.Intro = txtIntro.Value;
            model.Content = txtContent.Value;
            model.Particular = txtParticular.Value;
            model.CreateBy = _createBy;
            model.UpdateBy = _createBy;
            model.Status = Convert.ToInt32(rbStatus.SelectedValue);
            model.NewRelease = Convert.ToInt32(rbNewRelease.SelectedValue);
            model.BookFeature = Convert.ToInt32(rbBookFeature.SelectedValue);
            model.EnglishBook = Convert.ToInt16(rbEnglishBook.SelectedValue);
            model.Deleted = 0; // Convert.ToInt32(rbDelete.SelectedValue);
            model.Amount = Convert.ToInt32(txtAmount.Text.Trim());
            model.SmallPicture = txtSmallImage.Value;
            model.BigPicture = txtBigImage.Value;

            int ErrCode = 0;
            int RowEffects = 0;

            bll.Update(model, ref ErrCode, ref RowEffects);

            if (RowEffects > 0)
            {
                ProcessBookCategory(bookCategory);

                JscriptMsg(ErrCode.ToString() , "List.aspx", "Success");
            }
            else
            {
                JscriptMsg(ErrCode.ToString(), "", "Error");
            }
        }
예제 #42
0
        public void Update(Model.Book book)
        {
            //foreach () {

            //}
        }