public IActionResult Update(TASM_MACHINE model)
{
DataAccess.TASM_MACHINEManager manager = new DataAccess.TASM_MACHINEManager();
if (!manager.CurrentDb.Update(model))
{
return(FailMessage());
}
return(SuccessMessage("修改成功"));
}
public IActionResult ExportExcel(string keyword = "")
{
DataAccess.TASM_MACHINEManager manager = new DataAccess.TASM_MACHINEManager();
List <MachineModel> list = new List <MachineModel>();
manager.ListByWhere(keyword, ref list);
HSSFWorkbook excelBook = new HSSFWorkbook(); //创建工作簿Excel
ISheet sheet1 = excelBook.CreateSheet("项目履历表");
IRow row1 = sheet1.CreateRow(0);
row1.CreateCell(0).SetCellValue("设备名称");
row1.CreateCell(1).SetCellValue("设备类型");
row1.CreateCell(2).SetCellValue("设备序号");
row1.CreateCell(3).SetCellValue("客户名称");
row1.CreateCell(4).SetCellValue("合同编号");
row1.CreateCell(5).SetCellValue("订单时间");
row1.CreateCell(6).SetCellValue("送货时间");
row1.CreateCell(7).SetCellValue("送货单号");
row1.CreateCell(8).SetCellValue("验收时间");
row1.CreateCell(9).SetCellValue("创建时间");
for (int i = 0; i < list.Count(); i++)
{
NPOI.SS.UserModel.IRow rowTemp = sheet1.CreateRow(i + 1);
rowTemp.CreateCell(0).SetCellValue(list[i].NAME);
rowTemp.CreateCell(1).SetCellValue(list[i].TYPESNAME);
rowTemp.CreateCell(2).SetCellValue(list[i].SERIAL);
rowTemp.CreateCell(3).SetCellValue(list[i].CUSTOMER);
rowTemp.CreateCell(4).SetCellValue(list[i].CONTRACT);
rowTemp.CreateCell(5).SetCellValue(list[i].ORDERTIME.Value.ToString("yyyy-MM-dd"));
rowTemp.CreateCell(6).SetCellValue(list[i].DELIVERYTIME.Value);
rowTemp.CreateCell(7).SetCellValue(list[i].DELIVERYNUMBER);
rowTemp.CreateCell(8).SetCellValue(list[i].CHECKTIME.Value);
rowTemp.CreateCell(9).SetCellValue(list[i].CREATETIME.Value);
}
var fileName = "设备台账" + DateTime.Now.ToString("yyyy-MM-dd-HH-mm-ss-ffff") + ".xls";//文件名
//将Excel表格转化为流，输出
MemoryStream bookStream = new MemoryStream();
excelBook.Write(bookStream);
bookStream.Seek(0, SeekOrigin.Begin);
return(File(bookStream, "application/vnd.ms-excel", fileName));
}
public IActionResult ListByProjectId(ListMachineInputModel model)
{
DataAccess.TASM_MACHINEManager manager = new DataAccess.TASM_MACHINEManager();
SqlSugar.PageModel p = new SqlSugar.PageModel()
{
PageIndex = model.pageindex,
PageSize = model.pagesize
};
List <MachineModel> list = new List <MachineModel>();
manager.ListByProject(model.ProjectId, model.keywords, ref p, ref list);
return(SuccessResultList(list, p));
}
public IActionResult List(string keywords, int pageIndex, int pageSize)
{
DataAccess.TASM_MACHINEManager manager = new DataAccess.TASM_MACHINEManager();
SqlSugar.PageModel p = new SqlSugar.PageModel()
{
PageIndex = pageIndex,
PageSize = pageSize
};
List <MachineModel> list = new List <MachineModel>();
manager.ListByWhere(keywords, ref p, ref list);
return(SuccessResultList(list, p));
}
/// <summary>
/// 获取设备
/// </summary>
/// <param name="name"></param>
/// <returns></returns>
public int GetsMachineByName(string name)
{
if (string.IsNullOrEmpty(name))
{
return(default_machineId);
}
DataAccess.TASM_MACHINEManager manager = new DataAccess.TASM_MACHINEManager();
Machine = manager.SelectByName(name);
if (Machine == null)
{
return(default_machineId);
}
return(Machine.MID);
}
public IActionResult Add(TASM_MACHINE model)
{
model.CREATETIME = DateTime.Now;
model.ISDEL = 0;
model.STATUS = 0;
DataAccess.TASM_MACHINEManager manager = new DataAccess.TASM_MACHINEManager();
manager.Db.BeginTran();
int mid = manager.CurrentDb.InsertReturnIdentity(model);
manager.Db.CommitTran();
model.MID = mid;
model.SERIAL = model.NAME + "-" + model.MID;
manager.CurrentDb.Update(model);
return(SuccessMessage("添加成功"));
}
