public int AddSave(Book.Model.T_Base_Provider provider) { Book.DAL.T_Base_Provider providerAddSave = new DAL.T_Base_Provider(); int result = providerAddSave.AddSave(provider); return(result); }
public int GetCount(String Name = "") { Book.DAL.T_Base_Provider dal = new DAL.T_Base_Provider(); int count = dal.GetCount(Name); return(count); }
public List <Book.Model.T_Base_Provider> GetList(int PageNumber, int PageSize) { Book.DAL.T_Base_Provider dal = new DAL.T_Base_Provider(); List <Book.Model.T_Base_Provider> list = dal.GetList(PageNumber, PageSize); return(list); }
public int Delete(int Id) { Book.DAL.T_Base_Provider dal = new DAL.T_Base_Provider(); int result = dal.Delete(Id); return(result); }
public int GetCount() { Book.DAL.T_Base_Provider dal = new DAL.T_Base_Provider(); int result = dal.GetCount(); return(result); }
public List <Book.Model.T_Base_Provider> GetSearch(string Name, int matchCount) { Book.DAL.T_Base_Provider dal = new DAL.T_Base_Provider(); List <Book.Model.T_Base_Provider> lst = dal.GetSearch(Name, matchCount); return(lst); }
// GET: Provider public ActionResult index(string keyword, int pageNum = 1) { string where = ""; if (keyword == "") { where = "1 = 1"; } else { where = " name like '%" + keyword + "%'"; } int CurrentPageIndex = pageNum; book.DAL.T_Base_Provider dal = new DAL.T_Base_Provider(); //获取数据 int PageSize = Convert.ToInt32(System.Configuration.ConfigurationManager.AppSettings["PageSize"]); int RecordCount = dal.GetRecordCount(where); int startIndex = (CurrentPageIndex - 1) * PageSize + 1; int endIndex = CurrentPageIndex * PageSize; List <book.Model.T_Base_Provider> lst = dal.GetModelListByPage(where, " id desc", startIndex, endIndex); //展示数据 ViewBag.CurrentPageIndex = CurrentPageIndex; ViewBag.PageSize = PageSize; ViewBag.RecordCount = RecordCount; ViewBag.lst = lst; return(View()); }
public int Update(Book.Model.T_Base_Provider provider) { Book.DAL.T_Base_Provider dal = new DAL.T_Base_Provider(); int result = dal.Update(provider); return(result); }
public List <Book.Model.T_Base_Provider> GetList(int currentPage, int pageSize, String Name = "") { Book.DAL.T_Base_Provider dal = new DAL.T_Base_Provider(); List <Book.Model.T_Base_Provider> lst = dal.GetList(currentPage, pageSize, Name); return(lst); }
public int Add(Book.Model.T_Base_Provider provider) { Book.DAL.T_Base_Provider dal = new DAL.T_Base_Provider(); //用DAL层提供的添加方法添加 dal.Add(provider); return(0); }
public int Add(Book.Model.T_Base_Provider book) { int result = 0; Book.DAL.T_Base_Provider dal = new DAL.T_Base_Provider(); result = dal.Add(book); return(result); }
public int Delete(string[] Ids) { //防止注入式漏洞 string ids = string.Join(",", Ids); Book.DAL.T_Base_Provider dal = new DAL.T_Base_Provider(); return(dal.Delete(ids)); }
public Book.Model.T_Base_Provider_Page GetListPage(int CurrentPage, int PageSize, String Name = "") { Book.DAL.T_Base_Provider dal = new DAL.T_Base_Provider(); List <Book.Model.T_Base_Provider> list = dal.GetList(CurrentPage, PageSize, Name); int count = dal.GetCount(Name); Book.Model.T_Base_Provider_Page page = new Model.T_Base_Provider_Page(); page.list = list; page.count = count; return(page); }
public ActionResult Update(int id) { DAL.T_Base_Provider dal = new DAL.T_Base_Provider(); book.Model.T_Base_Provider book = new Model.T_Base_Provider(); book = dal.GetModel(id); ViewBag.book = book; if (book == null) { return(Content("资料不存在")); } return(View()); }
public Book.Model.Home GetCount() { Book.Model.Home home = new Model.Home(); Book.DAL.T_Base_Book book_dal = new DAL.T_Base_Book(); home.BookCount = book_dal.GetCount(); Book.DAL.T_Base_Provider provider_dal = new DAL.T_Base_Provider(); home.ProviderCount = provider_dal.GetCount(); Book.DAL.T_Base_Customer customer_dal = new DAL.T_Base_Customer(); home.CustomerCount = customer_dal.GetCount(); Book.DAL.T_Stock_In in_dal = new DAL.T_Stock_In(); home.InHeadCount = in_dal.GetCount(); Book.DAL.T_Stock_Out out_dal = new DAL.T_Stock_Out(); home.OutHeadCount = in_dal.GetCount(); return(home); }
public ActionResult Delete(string ids) { DAL.T_Base_Provider dal = new DAL.T_Base_Provider(); bool result = dal.DeleteList(ids); string tmp; if (result) { tmp = "{ \"statusCode\":\"200\", \"message\":\"删除成功\", \"navTabId\":\"booklist\", \"rel\":\"booklist\",\"callbackType\":\"\",\"forwardUrl\":\"\"}"; return(Content(tmp)); } else { tmp = "{ \"statusCode\":\"300\", \"message\":\"删除失败\", \"navTabId\":\"booklist\", \"rel\":\"booklist\",\"callbackType\":\"\",\"forwardUrl\":\"\"}"; } return(Content(tmp)); }
public ActionResult UpdateSave(book.Model.T_Base_Provider book) { DAL.T_Base_Provider dal = new DAL.T_Base_Provider(); bool result = dal.Update(book); string tmp; if (result) { tmp = "{ \"statusCode\":\"200\", \"message\":\"修改成功\", \"navTabId\":\"booklist\", \"rel\":\"booklist\",\"callbackType\":\"closeCurrent\",\"forwardUrl\":\"\"}"; return(Content(tmp)); } else { tmp = "{ \"statusCode\":\"300\", \"message\":\"修改失败\", \"navTabId\":\"booklist\", \"rel\":\"booklist\",\"callbackType\":\"closeCurrent\",\"forwardUrl\":\"\"}"; } return(Content(tmp)); }
public ActionResult GetAllProvider() { DAL.T_Base_Provider dal = new DAL.T_Base_Provider(); List <Model.T_Base_Provider> lst = dal.GetModelList("1=1"); String result = "["; foreach (var item in lst) { result += "{"; result += "\"Name\":\"" + item.Name + "\","; result += "\"Id\":\"" + item.Id + "\""; result += "},"; } if (lst.Count >= 1) { result = result.Substring(0, result.Length - 1); } result += "]"; return(Content(result)); }
public List <Book.Model.T_Base_Provider> GetList(int CurrentPage, int PageSize) { Book.DAL.T_Base_Provider dal = new DAL.T_Base_Provider(); return(dal.GetList(CurrentPage, PageSize)); }
public List <Model.T_Base_Provider> GetSearch(string Name, int matchCount) { // throw new NotImplementedException(); Book.DAL.T_Base_Provider dal = new DAL.T_Base_Provider(); return(dal.GetSearch(Name, matchCount)); }
public void AlterSave(Model.T_Base_Provider provider) { Book.DAL.T_Base_Provider dll = new DAL.T_Base_Provider(); dll.AlterSave(provider); }
public List <Model.T_Base_Provider> GetSearch(string query, int mathCount) { DAL.T_Base_Provider dal = new DAL.T_Base_Provider(); return(dal.GetSearch(query, mathCount)); }
public Book.Model.T_Base_Provider GetModal(int Id) { Book.DAL.T_Base_Provider dal = new DAL.T_Base_Provider(); return(dal.GetModal(Id)); }
public Book.Model.T_Base_Provider Alter(int Id) { Book.DAL.T_Base_Provider dal = new DAL.T_Base_Provider(); return(dal.Alter(Id)); }
public List <Book.Model.T_Base_Provider> GetAll() { Book.DAL.T_Base_Provider dal = new DAL.T_Base_Provider(); return(dal.GetAll()); }