public IActionResult Update(Team_Message model)
{
model.Createtime = DateTime.Now.ToLocalTime().ToDateTime();
var da = new Team_Message_Da();
da.Update(model);
return(SuccessMessage("成功！"));
}
public IActionResult Add(Team_Message model)
{
model.Createtime = DateTime.Now.ToLocalTime().ToDateTime();
model.Inbound_Date = DateTime.Now.ToShortDateString().ToDateTime();
var da = new Team_Message_Da();
da.Insert(model);
return(SuccessMessage("添加成功！"));
}
public IActionResult List(string keyword, int pageIndex, int pageSize)
{
PageModel page = new PageModel();
page.PageIndex = pageIndex;
page.PageSize = pageSize;
Team_Message_Da da = new Team_Message_Da();
list = da.ListByWhere(keyword, ref page);
if (page.PageIndex == 0)
{
return(SuccessResultList(list));
}
return(SuccessResultList(list, page));
}
private bool Import(string excelPath)
{
try
{
var dataTableT = ExcelHelper.ToEntityList <Team_Message>(excelPath);
//将实体类数据插入数据库；之前要进行查重.将可以导入的数据存为新的实体类
var data1 = new List <Team_Message>();
var da = new Team_Message_Da();
List(null, 0, 0);
foreach (var item in dataTableT)
{
data1.Add(item);
foreach (var item1 in list)
{
if ((item.Equipment_Numbers == item1.Equipment_Numbers) || (item.Id == item1.Id))
{
data1.Remove(item);
break;
}
}
}
if (data1.Count != 0)
{
foreach (var item2 in data1)
{
item2.Createtime = DateTime.Now.ToLocalTime().ToString("yyyy-MM-dd").ToDateTime();
item2.Inbound_Date = item2.Inbound_Date.ToString("yyyy-MM-dd").ToDateTime();
da.Insert(item2);
}
return(true);
}
else
{
return(false);
}
}
catch (Exception e)
{
return(false);
}
}
public IActionResult Del(int id)
{
var da = new Team_Message_Da();
return(da.Delete(s => s.Id == id) > 0 ? SuccessMessage("已删除！") : FailMessage());
}
