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