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());
}
