//linqtoExecl
//public Task<IApiResult> CheckImportFile(string filename, List<DAL.Devices> ds) {
// return Task.Run(() => {
// IApiResult ar = new IApiResult();
// try
// {
// using (DAL.CarRentEntities db = new CarRentEntities())
// {
// var targetFile = new FileInfo(filename);
// if (!targetFile.Exists)
// {
// ar.message = "导入的数据文件不存在";
// ar.code = StatusCode.error;
// }
// var excelFile = new ExcelQueryFactory(filename);
// excelFile.AddMapping<DAL.Devices>(d=>d.SerialNumber, "SerialNumber");
// excelFile.AddMapping<DAL.Devices>(d => d.DeviceName, "DeviceName");
// excelFile.AddMapping<DAL.Devices>(d => d.DevicePassword, "DevicePassword");
// excelFile.AddMapping<DAL.Devices>(d => d.CarUserName, "CarUserName");
// excelFile.AddMapping<DAL.Devices>(d => d.CarNum, "CarNum");
// excelFile.AddMapping<DAL.Devices>(d => d.CellPhone, "CellPhone");
// excelFile.AddMapping<DAL.Devices>(d => d.Status, "Status");
// excelFile.AddMapping<DAL.Devices>(d => d.PhoneNum, "PhoneNum");
// excelFile.AddMapping<DAL.Devices>(d => d.Model, "Model");
// excelFile.AddMapping<DAL.Devices>(d => d.Description, "Description");
// excelFile.AddMapping<DAL.Devices>(d => d.Created, "Created");
// excelFile.AddMapping<DAL.Devices>(d => d.Deleted, "Deleted");
// excelFile.AddMapping<DAL.Devices>(d => d.ActiveDate, "ActiveDate");
// excelFile.AddMapping<DAL.Devices>(d => d.HireStartDate, "HireStartDate");
// excelFile.AddMapping<DAL.Devices>(d => d.HireExpireDate, "HireExpireDate");
// excelFile.AddMapping<DAL.Devices>(d => d.SpeedLimit, "SpeedLimit");
// excelFile.AddMapping<DAL.Devices>(d => d.UserID, "UserID");
// excelFile.AddMapping<DAL.Devices>(d => d.GroupID, "GroupID");
// excelFile.AddMapping<DAL.Devices>(d => d.Icon, "Icon");
// excelFile.AddMapping<DAL.Devices>(d => d.BSJIP, "BSJIP");
// excelFile.AddMapping<DAL.Devices>(d => d.AddHireDay, "AddHireDay");
// excelFile.AddMapping<DAL.Devices>(d => d.Deleted, "Deleted");
// excelFile.AddMapping<DAL.Devices>(d => d.ServerID, "ServerID");
// excelFile.AddMapping<DAL.Devices>(d => d.OilPrice, "OilPrice");
// excelFile.AddMapping<DAL.Devices>(d => d.CreatedByUser, "CreatedByUser");
// excelFile.AddMapping<DAL.Devices>(d => d.ExpireByUser, "ExpireByUser");
// excelFile.AddMapping<DAL.Devices>(d => d.OilVolume, "OilVolume");
// excelFile.AddMapping<DAL.Devices>(d => d.OilLow, "OilLow");
// excelFile.AddMapping<DAL.Devices>(d => d.OilHigh, "OilHigh");
// excelFile.AddMapping<DAL.Devices>(d => d.CarImg, "CarImg");
// excelFile.AddMapping<DAL.Devices>(d => d.ServerID2, "ServerID2");
// excelFile.AddMapping<DAL.Devices>(d => d.ByDistance, "ByDistance");
// excelFile.AddMapping<DAL.Devices>(d => d.LastByDistance, "LastByDistance");
// //SheetName
// var excelContent = excelFile.Worksheet < DAL.Devices >(0);
// int rowIndex = 1;
// foreach (var item in excelContent)
// {
// var sb = new StringBuilder();
// DAL.Devices de = new DAL.Devices();
// de.SerialNumber = item.SerialNumber;
// de.PhoneNum = item.CellPhone;
// de.Description = item.Description;
// }
// }
// }
// catch (Exception ex)
// {
// Log.Error(this, ex);
// ar.message = ex.Message;
// ar.code = StatusCode.error;
// }
// return ar;
// });
//}
/// <summary>
/// 新增设备AddDevice
/// </summary>
/// <param name="arg"></param>
/// <returns></returns>
public Task <IApiResult> AddDevice(P_Devices.P_AddDevice arg)
{
return(Task.Run(() =>
{
IApiResult ar = new IApiResult();
try
{
using (DAL.CarRentEntities db = new CarRentEntities())//EF数据上下文
{
//将要添加的数据封装成对象
DAL.Devices ds = new DAL.Devices();
ds.UserID = arg.userid;
ds.SerialNumber = arg.imei;
ds.DeviceName = arg.devicename;
ds.PhoneNum = arg.phonenumber;
ds.GroupID = arg.groupid;
ds.Created = DateTime.Now;
ds.Status = 0;
ds.Model = 201;
ds.Deleted = false;
ds.ActiveDate = Convert.ToDateTime("1900-01-01 00:00:00.000");
ds.HireStartDate = DateTime.Now.AddHours(-8);
ds.HireExpireDate = Convert.ToDateTime("1900-01-01 00:00:00.000");
ds.DevicePassword = "******";
ds.Description = arg.remark;
db.Devices.Add(ds);
db.SaveChanges();
ar.message = $"added successfully!";
ar.result = new { url = "reload" };
}
}
catch (Exception ex)
{
Log.Error(this, ex);
ar.code = Interface.StatusCode.error;
ar.message = ex.Message;
}
return ar;
}));
}
public async Task <IApiResult> AddDevice([FromBody] P_Devices.P_AddDevice pars)
{
return(await ApiAsync(pars, new BLL.DeviceManager.Device().AddDevice));
}
