public Utility.OpResult Deletes(int[] ids)
{
var op = new OpResult();
try
{
var devices = DevicesRepository.GetQuery(o => ids.Contains(o.Id));
if (!devices.Any())
{
op.Message = "查不到数据";
return(op);
}
var delDeviceId = devices.Select(o => o.DeviceId);
var authorize = DeviceAuthorizeRepository.GetQuery(o => delDeviceId.Contains(o.DeviceId));
if (authorize.Any())
{
op.Message = "无法删除，设备授权包含了要删除的设备";
return(op);
}
DevicesRepository.RemoveRange(devices.ToList());
op.Successed = true;
LogEngine.WriteDelete("移除设备", LogModule.设备管理);
}
catch (Exception ex)
{
op.Message = ex.Message;
LogEngine.WriteError(ex);
}
return(op);
}
public DevicesService(YoukerContext context, DevicesRepository devicesRepository) : base(context)
{
if (_devicesRepository == null)
{
_devicesRepository = devicesRepository;
}
}
public AddDevicePage()
{
InitializeComponent();
DevicesRepository viewModel = new DevicesRepository();
DevicesListView.ItemsSource = viewModel.DeviceList;
}
/// <summary>
/// 设置可用，设置停用
/// </summary>
/// <param name="ids"></param>
/// <param name="state"></param>
/// <returns></returns>
public OpResult SetState(string ids, short state)
{
var sId = ids.Split(',').Select(o => int.Parse(o));
var olist = DevicesRepository.GetQuery(o => sId.Contains(o.Id)).ToList();
olist.Each(o => o.Status = state);
return(OpResult.Result(DevicesRepository.SaveChanges()));
}
public DeviceTuner()
{
InitializeComponent();
ImageButtonAddDevice.Source = ImageSource.FromResource("App1.Resources.nightstand.png");
DevicesRepository viewModel = new DevicesRepository();
DeviceListView.ItemsSource = viewModel.DeviceList;
}
public UnitofWork(MusicDBContext musicDBContext)
{
_musicDBContext = musicDBContext;
OutletRepository = new OutletRepository(_musicDBContext);
DeviceRepository = new DevicesRepository(_musicDBContext);
PlaylistRepository = new PlaylistRepository(_musicDBContext);
TrackRepository = new GenericRepository <Track>(_musicDBContext);
}
public void Setup()
{
Context = GetShellDb();
deviceRepository = new DevicesRepository(Context);
foreach (DeviceInfo temp in devices)
{
deviceRepository.Create(temp);
}
}
public InitDeviceService(
IIteInteropService iteInteropService,
DevicesRepository devicesRepository,
PluginsRepository pluginsRepository)
{
_iteInteropService = iteInteropService;
_devicesRepository = devicesRepository;
_pluginsRepository = pluginsRepository;
}
public void When_GetDevice_by_sessionId_Should_Return_newDevice()
{
var repo = new DevicesRepository();
var device = repo.GetDevice("session-001");
Assert.IsNotNull(device);
Assert.IsTrue(device.SessionId == "session-001");
Assert.IsTrue(device.Id == "device-001");
}
/// <summary>
/// 获取品牌
/// </summary>
/// <param name="name"></param>
/// <returns></returns>
public List <Devices> getBrand(string brand)
{
if (brand.IsNullOrEmpty())
{
return(null);
}
brand = brand.Trim();
var query = DevicesRepository.GetQuery();
query = query.Where(o => o.Brand.Trim().StartsWith(brand));
return(query.Take(20).ToList());
}
public ConnectWindowVM(
DevicesRepository devicesRepository,
DevicePanelInstanceService devicePanelInstanceService,
PluginLoadService pluginLoadService)
{
_devicesRepository = devicesRepository;
_devicePanelInstanceService = devicePanelInstanceService;
_pluginLoadService = pluginLoadService;
SelectionsResetCommand = new(listBox => listBox.SelectedItem = null);
SelectionsConnectCommand = new(SelectionsConnect);
}
public MultiDevicesPanelWindowVM(
DevicesRepository devicesRepository,
DevicePanelsRepository devicePanelsRepository)
{
_devicesRepository = devicesRepository;
_devicePanelsRepository = devicePanelsRepository;
SelectionsResetCommand = new(listBox => listBox.SelectedItem = null);
SelectionsRunCommand = new(SelectionsRun);
SelectionsStopCommand = new(SelectionsStop);
SelectionsStopMonitorCommand = new(SelectionsStopMonitor);
}
public void BuildParametersForInsertingTest()
{
List<DbParam> expectedParametersForInserting = new List<DbParam>
{
new DbParam { Name = "@Name", Value = _device.Name, Type = SqlDbType.NVarChar},
new DbParam { Name = "@TypeId", Value = _device.TypeId, Type = SqlDbType.Int},
new DbParam { Name = "@OwnerId", Value = _device.OwnerId, Type = SqlDbType.Int}
};
DevicesRepository devicesRepository = new DevicesRepository(_dbWrapper);
List<DbParam> actualParametersForInserting = devicesRepository.BuildParametersForInserting(_device).ToList();
CollectionAssert.AreEqual(expectedParametersForInserting, actualParametersForInserting);
}
public MainWindowVM(
DeviceDetectService deviceDetectService,
DevicesRepository devicesRepository
)
{
_deviceDetectService = deviceDetectService;
_devicesRepository = devicesRepository;
foreach (Device device in _deviceDetectService.GetDevices())
{
_devicesRepository.DeviceOffline(device);
}
ShowConnectWindowCommand = new(ShowConnectWindow);
ShowDisconnectWindowCommand = new(ShowDisconnectWindow);
ShowMultiDevicesPanelWindowCommand = new(ShowMultiDevicesPanelWindow);
}
public IEnumerable <dynamic> GetList()
{
var queryDevice = DevicesRepository.GetQuery(o => o.Status == 1);
var queryDict = SysDataDictionaryRepository.GetQuery();
var query = from x in queryDevice
join y in queryDict on x.CategoryId equals y.DicSN
select new {
x.Id,
x.Brand,
x.CategoryId,
x.DeviceId,
x.Spec,
x.Status,
x.Title,
CategoryTitle = y.Title
};
var list = query.ToList();
return(list);
}
public OpResult SaveOrUpdate(DeviceAuthorize obj, string category, string brand, string spec)
{
//if (!TraderRepository.GetQuery(o => o.CID == obj.CID).Any())
//return OpResult.Fail("商户不存在!");
if (category.IsNullOrEmpty() || brand.IsNullOrEmpty() || spec.IsNullOrEmpty())
{
return(OpResult.Fail("设备分类等信息选择不完整！"));
}
var cate = short.Parse(category);
var device = DevicesRepository.Find(o => o.CategoryId == cate && o.Brand == brand && o.Spec == spec);
if (device == null)
{
return(OpResult.Fail("设备分类不存在，请重新选择！"));
}
obj.DeviceId = device.DeviceId;
if (DeviceAuthorRepository.GetQuery(o => o.DeviceId == obj.DeviceId && o.DeviceNo == obj.DeviceNo && o.Status != 2 && o.Id != obj.Id).Any())
{
return(OpResult.Fail("同设备和编码下不允许重复添加！"));
}
if (obj.Id == 0)
{
obj.CreateDT = DateTime.Now;
obj.CreateUID = CurrentUser.UID;
obj.ExpirationDT = DateTime.Parse(obj.EffectiveDT).AddMonths(obj.ValidityNum.GetValueOrDefault()).ToString("yyyy-MM-dd");
DeviceAuthorRepository.Add(obj);
}
else
{
var res = DeviceAuthorRepository.Get(obj.Id);
obj.ToCopyProperty(res, new List <string>()
{
"CreateDT", "CreateUID", "CID", "MachineSN", "SerialNo"
});
res.ExpirationDT = DateTime.Parse(obj.EffectiveDT).AddMonths(obj.ValidityNum.GetValueOrDefault()).ToString("yyyy-MM-dd");
DeviceAuthorRepository.SaveChanges();
}
return(OpResult.Success());
}
public UnitOfWork(
PatientsRepository patients,
PractitionersRepository practitioners,
PractitionerRolesRepository practitionerRoles,
RelatedPeopleRepository relatedPeople,
PeopleRepository people,
OrganizationsRepository organizations,
HealthcareServicesRepository healthcareServices,
LocationsRepository locations,
DevicesRepository devices,
TasksRepository tasks,
AppointmentsRepository appointments,
SchedulesRepository schedules,
EncountersRepository encounters,
EpisodesOfCareRepository episodesOfCare,
FlagsRepository flags
)
{
var database = new FhirDevelopment01DB();
Patients = patients;
Practitioners = practitioners;
PractitionerRoles = practitionerRoles;
RelatedPeople = relatedPeople;
People = people;
Organizations = organizations;
HealthcareServices = healthcareServices;
Locations = locations;
Devices = devices;
Tasks = tasks;
Appointments = appointments;
Schedules = schedules;
Encounters = encounters;
EpisodesOfCare = episodesOfCare;
Flags = flags;
}
public List <Devices> GetDeviceInput(string searchName)
{
if (searchName.IsNullOrEmpty())
{
return(null);
}
var queryDev = DevicesRepository.GetQuery();
var queryDict = SysDataDictionaryRepository.GetQuery();
var query = from x in queryDev
join y in queryDict on x.CategoryId equals y.DicSN
select new
{
x.DeviceId,
x.Title,
x.CategoryId,
CategoryTitle = y.Title
};
query = query.Where(o => o.Title.Contains(searchName) || o.CategoryTitle.Contains(searchName));
return(query.Take(20).AsEnumerable().Select(o => new Devices()
{
DeviceId = o.DeviceId, Title = o.Title, CategoryId = o.CategoryId
}).ToList());
}
public ActionResult <string> Gateway([FromBody] GatewayModel gateway)
{
string result = "error";
try
{
DevicesRepository devices = new DevicesRepository(_options);
if (devices.GetDeviceBySerial(gateway.Serial).Count == 0)
{
result = devices.InsertGateway(gateway.Serial, gateway.Brand, gateway.Ip, gateway.Port);
}
else
{
result = "The serial number entered was already registered. Please check the serial number.";
}
}
catch (Exception ex)
{
return(ex.Message);
}
return(result);
}
public Utility.OpResult SaveOrUpdate(Devices model)
{
IQueryable <Devices> isExist = null;
if (model.Id == 0)
{
isExist = DevicesRepository.GetQuery(o => o.CategoryId == model.CategoryId && o.Title == model.Title && o.Brand == model.Brand && o.Spec == model.Spec);
}
else
{
isExist = DevicesRepository.GetQuery(o => o.CategoryId == model.CategoryId && o.Title == model.Title && o.Brand == model.Brand && o.Spec == model.Spec && o.Id != model.Id);
}
if (isExist.Any())
{
return(OpResult.Fail("该条设备记录已经存在"));
}
if (model.Id == 0)
{
DevicesRepository.Add(model);
}
else
{
var source = DevicesRepository.Get(model.Id);
model.ToCopyProperty(source, new List <string>()
{
"DeviceId", "Status", "CreateUID"
});
}
if (DevicesRepository.SaveChanges())
{
LogEngine.WriteUpdate(model.Id + "," + model.Title, LogModule.设备管理);
}
return(OpResult.Success());
}
//[DisableCors]
public ActionResult <string> Counter([FromBody] CounterModel counter)
{
string result = "error";
try
{
DevicesRepository devices = new DevicesRepository(_options);
if (devices.GetDeviceBySerial(counter.Serial).Count == 0)
{
result = devices.InsertCounter(counter.Serial, counter.Brand, counter.Model, counter.Type);
}
else
{
result = "The serial number entered was already registered. Please check the serial number.";
}
}
catch (Exception ex)
{
return("Error: " + ex.Message);
}
return(result);
}
public IEnumerable <dynamic> GetPageList(System.Collections.Specialized.NameValueCollection nvl, out int recordCount)
{
var text = nvl["searchText"];
var category = nvl["category"];
var assigner = nvl["assigner"];
var searchField = nvl["searchField"];
var state = nvl["state"];
var queryDev = DevicesRepository.GetQuery();
var queryDict = DictRepository.GetQuery();
var queryUser = UserRepository.GetQuery();
var where = DynamicallyLinqHelper.Empty <DeviceAuthorize>();
if (!text.IsNullOrEmpty())
{
int cid = 0;
text = text.Trim();
int.TryParse(text, out cid);
if (searchField == "Cid")
{
where = where.And(o => o.CID == cid);
}
else if (searchField == "DeviceNo")
{
where = where.And(o => o.DeviceNo != null && o.DeviceNo.StartsWith(text));
}
else if (searchField == "ContractNo")
{
where = where.And(o => o.ContractNo != null && o.ContractNo.StartsWith(text));
}
}
if (!state.IsNullOrEmpty())
{
var st = short.Parse(state);
where = where.And(o => o.Status == st);
}
if (!assigner.IsNullOrEmpty())
{
where = where.And(o => o.AssignerUID == assigner);
}
var queryDevAuth = DeviceAuthorRepository.GetQuery(where);
var query = from x in queryDevAuth
join y in queryDev on x.DeviceId equals y.DeviceId
select new
{
x.Id,
x.CID,
x.Title,
x.Source,
Category = queryDict.Where(o => o.DicSN == y.CategoryId).Select(o => o.Title).FirstOrDefault(),
y.Spec,
y.Brand,
x.DeviceNo,
x.StoreName,
x.EffectiveDT,
x.ValidityNum,
x.ExpirationDT,
x.ContractNo,
x.Status,
y.CategoryId,
x.CreateDT,
x.MachineNo,
Assigner = queryUser.Where(o => o.UserId == x.AssignerUID).Select(o => o.FullName).FirstOrDefault()
};
if (!category.IsNullOrEmpty())
{
var st = short.Parse(category);
query = query.Where(o => o.CategoryId == st);
}
recordCount = query.Count();
return(query.ToPageList());
}
public void ReadSingleEntityAllNotNullTest()
{
_dataReader.Expect(x => x.IsDBNull(1)).Repeat.Once().Return(false);
_dataReader.Expect(x => x.GetInt32(0)).Return(_device.Key).Repeat.Once();
_dataReader.Expect(x => x.GetString(1)).Return(_device.Name).Repeat.Once();
_dataReader.Expect(x => x.GetInt32(2)).Return(_device.TypeId).Repeat.Once();
_dataReader.Expect(x => x.GetInt32(3)).Return(_device.OwnerId).Repeat.Once();
_mockRepository.ReplayAll();
DevicesRepository devicesRepository = new DevicesRepository(_dbWrapper);
Device actual = devicesRepository.ReadSingleEntity(_dataReader);
Assert.AreEqual(_device.Key, actual.Key);
Assert.AreEqual(_device.Name, actual.Name);
Assert.AreEqual(_device.TypeId, actual.TypeId);
Assert.AreEqual(_device.OwnerId, actual.OwnerId);
_mockRepository.VerifyAll();
}
public ConnectWindowVM(
DevicesRepository devicesRepository)
{
_devicesRepository = devicesRepository;
}
public Devices GetOneByuid(object uid)
{
return(DevicesRepository.Find(o => o.DeviceId == uid));
}
public IEnumerable <dynamic> GetPageList(System.Collections.Specialized.NameValueCollection nvl, out int recordCount)
{
//设备
var query = DevicesRepository.GetQuery();
//账户
var userInfo = SysUserInfoRepository.GetQuery();
//数据字典
var dataDictionary = SysDataDictionaryRepository.GetQuery(o => o.Status);
//设备授权信息
var dAuthorize = DeviceAuthorizeRepository.GetQuery();
//分类
var CategoryId = (nvl["CategoryId"] ?? "").Trim();
//品牌
var Brand = (nvl["Brand"] ?? "").Trim();
//维护人
var FullName = (nvl["FullName"] ?? "").Trim();
//设备名称
var Title = (nvl["Title"] ?? "").Trim();
if (!CategoryId.IsNullOrEmpty())
{
var c = short.Parse(CategoryId);
query = query.Where(w => w.CategoryId == c);
}
if (!Brand.IsNullOrEmpty())
{
query = query.Where(w => w.Brand.Contains(Brand));
}
if (!Title.IsNullOrEmpty())
{
query = query.Where(w => w.Title.Contains(Title) || w.Spec.Contains(Title));
}
var q = from quer in query
let da = from dAu in dAuthorize where dAu.DeviceId == quer.DeviceId select dAu
join u in userInfo on quer.CreateUID equals u.UserId
into v
from w in v.DefaultIfEmpty()
join d in dataDictionary on quer.CategoryId equals d.DicSN
into x
from y in x.DefaultIfEmpty()
select new
{
quer.Id,
quer.DeviceId,
quer.CategoryId,
quer.Title,
quer.Brand,
quer.Spec,
number = da.Count(),
quer.Status,
quer.CreateDT,
quer.CreateUID,
dTitle = y == null ? "" : y.Title,
FullName = w == null ? "" : w.FullName
};
if (!FullName.IsNullOrEmpty() && FullName.Trim() != "全部")
{
q = q.Where(w => w.FullName.Contains(FullName));
}
recordCount = q.Count();
return(q.ToPageList());
}
/// <summary>
/// 导入
/// </summary>
/// <param name="obj"></param>
/// <param name="httpFiles"></param>
/// <param name="fieldName"></param>
/// <param name="columnName"></param>
/// <returns></returns>
public OpResult Import(ImportSet obj, System.Web.HttpFileCollectionBase httpFiles, string fieldName, string columnName)
{
var op = new OpResult();
var errLs = new List <string>();
int count = 0;
try
{
Dictionary <string, char> fieldCols = null;
DataTable dt = null;
op = ImportSetService.ImportSet(obj, httpFiles, fieldName, columnName, ref fieldCols, ref dt);
if (!op.Successed)
{
return(op);
}
//数据字典
var dataDictionary = SysDataDictionaryRepository.GetQuery();
//设备分类名称
var CIdx = Convert.ToInt32(fieldCols["CategoryId"]) - 65;
//设备名称
var TitleIdx = Convert.ToInt32(fieldCols["Title"]) - 65;
//品牌
var BrandIdx = Convert.ToInt32(fieldCols["Brand"]) - 65;
//型号
var SpecIdx = Convert.ToInt32(fieldCols["Spec"]) - 65;
count = dt.Rows.Count;
for (int i = dt.Rows.Count - 1; i >= 0; i--)
{
try
{
var dr = dt.Rows[i];
#region 验证
//设备分类名称
var text = dr[CIdx].ToString().Trim();
if (text.IsNullOrEmpty())
{
errLs.Add("行号[" + (i + 1) + "]设备分类为空!");
dt.Rows.RemoveAt(i);
continue;
}
var dd = dataDictionary.Where(o => o.DicPSN == 197 && o.Title == text);
if (!dd.Any())
{
errLs.Add("行号[" + (i + 1) + "]设备分类在字典中不存在，请先添加!");
dt.Rows.RemoveAt(i);
continue;
}
else
{
dr[CIdx] = dd.Select(o => o.DicSN).FirstOrDefault();
}
//设备名称
var text2 = dr[TitleIdx].ToString().Trim();
if (text2.IsNullOrEmpty())
{
errLs.Add("行号[" + (i + 1) + "]设备名称为空!");
dt.Rows.RemoveAt(i);
continue;
}
//品牌
var text3 = dr[BrandIdx].ToString().Trim();
if (text3.IsNullOrEmpty())
{
errLs.Add("行号[" + (i + 1) + "]品牌为空!");
dt.Rows.RemoveAt(i);
continue;
}
//型号
var text4 = dr[SpecIdx].ToString().Trim();
if (text4.IsNullOrEmpty())
{
errLs.Add("行号[" + (i + 1) + "]型号为空!");
dt.Rows.RemoveAt(i);
continue;
}
//设备分类ID
var cid = dataDictionary.Where(o => o.DicPSN == 197 && o.Title == text).Select(o => o.DicSN).FirstOrDefault();
var isExist = DevicesRepository.GetQuery(o => o.CategoryId == cid && o.Title == text2 && o.Brand == text3 && o.Spec == text4);
if (isExist.Any())
{
errLs.Add("行号[" + (i + 1) + "]设备记录已经存在!");
dt.Rows.RemoveAt(i);
continue;
}
#endregion
}
catch (Exception e)
{
throw new Exception("创建相关记录失败," + e.Message, e);
}
}
StringBuilder sb = new StringBuilder();
sb.Append("begin tran ");
foreach (DataRow dr in dt.Rows)
{
Devices devices = new Devices();
devices.DeviceId = CommonService.GUID.ToUpper();
devices.CreateUID = CurrentUser.UID;
devices.CreateDT = DateTime.Now;
sb.Append("insert into ");
sb.Append(obj.TableName);
sb.Append("(Status,DeviceId,CreateDT,CreateUID,");
sb.Append(string.Join(",", fieldCols.Keys));
sb.Append(") values(1,'" + devices.DeviceId + "','" + devices.CreateDT + "','" + devices.CreateUID + "',");
foreach (var de in fieldCols)
{
var index = Convert.ToInt32(de.Value) - 65;
try
{
var text = dr[index].ToString().Trim();
sb.Append("'" + text + "',");
}
catch (Exception e)
{
throw new Exception("列选择超过范围!", e);
}
}
sb = sb.Remove(sb.Length - 1, 1);
sb.Append(");");
}
sb.Append(" commit tran");
new DBFramework.DBHelper().ExecuteNonQueryText(sb.ToString(), null);
}
catch (Exception ex)
{
op.Message = ex.Message;
op.Successed = false;
LogEngine.WriteError(ex);
errLs.Add("导入出现异常!");
}
return(CommonService.GenerateImportHtml(errLs, count));
}
public Devices GetOne(object id)
{
return(DevicesRepository.Get(id));
}
public DisconnectWindowVM(DevicesRepository devicesRepository)
{
_devicesRepository = devicesRepository;
SelectionsResetCommand = new(listBox => listBox.SelectedItem = null);
SelectionsDisconnectCommand = new(SelectionsDisconnect);
}
