public List <book> GetBookByobj(bookSearch bs, int page = 1) { int RecordsPerPage = 10; using (CTyPHSachEntities db = new CTyPHSachEntities()) { var book = (from b in db.Books where (bs.ten == null || b.bookName.Contains(bs.ten)) && b.status != 2 && (bs.mota == null || b.description.Contains(bs.mota)) && (bs.id_danhmuc == null || b.CategoryID == bs.id_danhmuc.Value) && (bs.ma == null || b.BookID == bs.ma.Value) && (bs.id_nxb == null || b.PublisherID == bs.id_nxb.Value) && (bs.gianhap == null || b.receiptPrice >= bs.gianhap.Value) && (bs.gianhapden == null || b.receiptPrice <= bs.gianhapden.Value) && (bs.giaxuat == null || b.price >= bs.giaxuat.Value) && (bs.giaxuatden == null || b.price <= bs.giaxuatden.Value) select new book() { ma = b.BookID, ten = b.bookName, gianhap = b.receiptPrice, giaxuat = b.price, sl = b.amount, id_nxb = b.PublisherID, id_danhmuc = b.CategoryID, nhaxb = (from c in db.Publishers where c.PublisherID == b.PublisherID select new nxb() { id = c.PublisherID, name = c.publisherName }).FirstOrDefault(), cat = (from d in db.Categories where d.CategoryID == d.CategoryID select new category() { id = d.CategoryID, name = d.CategoryName }).FirstOrDefault() }).OrderBy(x => x.ten).Skip((page - 1) * RecordsPerPage).Take(RecordsPerPage).ToList(); return(book); } }
public void loadSachformsearch(bookSearch bs, int page = 1) { tb_trang.Text = "1"; DataTable table = new DataTable(); int stt = 0; table.Columns.Add("STT", typeof(int)); table.Columns.Add("Ma", typeof(int)); table.Columns.Add("Tên", typeof(string)); table.Columns.Add("Số Lượng", typeof(int)); table.Columns.Add("Giá nhập", typeof(decimal)); table.Columns.Add("Giá xuất", typeof(decimal)); table.Columns.Add("NXB", typeof(string)); table.Columns.Add("Danh mục", typeof(string)); var books = SachService.GetBookByobj(bs, page); foreach (var item in books) { stt++; table.Rows.Add(stt, item.ma, item.ten, item.sl, item.gianhap, item.giaxuat, item.nhaxb.name, item.cat.name); } dgv_sach.DataSource = table; }
public ActionResult Sach(bookSearch bk) { var sach = SachService.GetBookByobj(bk); return(PartialView(sach)); }
public ActionResult Create(bookSearch bk) { loadnxb(); return(View()); }
private void bt_timkiem_Click(object sender, EventArgs e) { bookSearch bs = new bookSearch(); if (tb_ten.TextLength > 0) { bs.ten = tb_ten.Text; } if (tb_ma.TextLength > 0) { try { bs.ma = Convert.ToInt16(tb_ma.Text.Trim()); } catch (Exception ex) { } } try { bs.gianhap = Convert.ToDecimal(tb_gianhap.Text.Trim()); bs.giaxuat = Convert.ToDecimal(tb_giaxuat.Text.Trim()); bs.gianhapden = Convert.ToDecimal(tb_gianhapden.Text.Trim()); bs.giaxuatden = Convert.ToDecimal(tb_giaxuatden.Text.Trim()); } catch (Exception ex) { } try { bs.gianhap = Convert.ToDecimal(tb_gianhap.Text.Trim()); bs.giaxuat = Convert.ToDecimal(tb_giaxuat.Text.Trim()); bs.gianhapden = Convert.ToDecimal(tb_gianhapden.Text.Trim()); bs.giaxuatden = Convert.ToDecimal(tb_giaxuatden.Text.Trim()); } catch (Exception ex) { } try { bs.gianhap = Convert.ToDecimal(tb_gianhap.Text.Trim()); } catch (Exception ex) { } try { bs.giaxuat = Convert.ToDecimal(tb_giaxuat.Text.Trim()); } catch (Exception ex) { } try { bs.gianhapden = Convert.ToDecimal(tb_gianhapden.Text.Trim()); } catch (Exception ex) { } try { bs.giaxuatden = Convert.ToDecimal(tb_giaxuatden.Text.Trim()); } catch (Exception ex) { } if (tb_mota.TextLength > 0) { bs.mota = tb_mota.Text; } bs.id_danhmuc = Convert.ToInt16(cb_danhmuc.SelectedValue); bs.id_nxb = Convert.ToInt16(cb_nhaxb.SelectedValue); loadSachformsearch(bs); }
public static List <book> GetBookByobj(bookSearch bs, int page = 1) { return(repository.GetBookByobj(bs, page)); }