public bool ImportUsers()
{
int totalCount = 0;
if (LocatingServiceUtil.IsAvailable())
{
IServiceApi serviceApi = LocatingServiceUtil.Instance <IServiceApi>();
GeneralResult gr = serviceApi.LoadHostInfo();
CulpritRoomReference.RemoveCaching();
if (!gr.Suceess)
{
throw new Exception(gr.ErrText);
}
}
return(true);
}
private void LoadJailRoomList()
{
newJailRoom.Items.Clear();
newJailRoom.DataSource = MapArea.All;
newJailRoom.DataTextField = "AreaName";
newJailRoom.DataValueField = "Id";
newJailRoom.DataBind();
int roomId = CulpritRoomReference.GetRoomIdByCulpritId(_id);
ListItem listItem = newJailRoom.Items.FindByValue(roomId.ToString());
if (listItem == null)
{
newJailRoom.Items.Insert(0, new ListItem("请选择 ..", "-1"));
}
else
{
newJailRoom.SelectedIndex = -1;
listItem.Selected = true;
}
}
protected void saveButton_Click(object sender, EventArgs e)
{
if (name.Text.Trim().Length == 0)
{
feedbacks.Items.AddError("没有填写" + nameCalling.Text + "。");
}
//if (_userType == TagUserType.Cop && number.Text.Trim().Length != 6)
//{
// feedbacks.Items.AddError(numberCalling.Text + "必须是6位数字。");
//}
//if (_userType == TagUserType.Culprit && number.Text.Trim().Length != 5)
//{
// feedbacks.Items.AddError(numberCalling.Text + "必须是5位数字。");
//}
if (_userType != TagUserType.Position && number.Text.Trim().Length == 0)
{
feedbacks.Items.AddError("请输入编号");
}
if (_userType == TagUserType.Culprit && culpritRoom.Items.Count > 0 && culpritRoom.SelectedIndex < 1)
{
feedbacks.Items.AddError("没有选择该犯人所在的监舍。");
}
if (feedbacks.HasItems)
{
return;
}
//yyang 090916
//if (TagUser.All.Any(x => string.Compare(x.Number, number.Text.Trim(), true) == 0))
//{
// feedbacks.Items.AddError(numberCalling.Text + " " + number.Text.Trim() + " 已经存在在系统中, 请勿重复。");
// return;
//}
if (_userType != TagUserType.Position && HostTag.All.Any(x => string.Compare(x.HostExternalId, number.Text.Trim(), true) == 0))
{
feedbacks.Items.AddError(numberCalling.Text + " " + number.Text.Trim() + " 已经存在在系统中, 请勿重复。");
return;
}
if (BusSystemConfig.IsAutoSelectStrongestRssiTag() == false)
{
if (tagSelector.SelectedTagIdArray.Length > 0)
{
if (HostTag.All.Any(x => x.TagId == tagSelector.SelectedTagIdArray[0]))
{
feedbacks.Items.AddError("您选择的标签已经被别人领用，请核实。");
return;
}
}
}
string photoPath = "";
if (uploadPhoto.HasFile)
{
photoPath = CreatePhotoUploadPath() + "/" + Misc.CreateUniqueFileName() + Path.GetExtension(uploadPhoto.FileName);
try
{
using (System.Drawing.Image image = System.Drawing.Image.FromStream(uploadPhoto.FileContent))
{
if (image != null)
{
using (Bitmap bitmap = new Bitmap(image, 100, 120))
{
bitmap.Save(Fetch.MapPath(PathUtil.ResolveUrl(photoPath)), ImageFormat.Jpeg);
}
}
}
}
catch (Exception)
{
feedbacks.Items.AddError("上传照片出错，可能是图片体积过大，或者不是图片格式文件。");
return;
}
}
HostTag hostTag = new HostTag();
//TagUser user = new TagUser();
hostTag.HostName = name.Text.Trim();
hostTag.HostExternalId = number.Text.Trim();
hostTag.ImagePath = photoPath;
hostTag.HostType = 1;
hostTag.Description = Strings.Left(memo.Text, 500);
if (BusSystemConfig.IsAutoSelectStrongestRssiTag())
{
hostTag.TagId = tagSelectorAuto.GetStrongestRssiTagID();
}
else
{
if (tagSelector.SelectedTagIdArray.Length > 0)
{
hostTag.TagId = tagSelector.SelectedTagIdArray[0];
}
}
//TagUser.Insert(user);
//yzhu 090913
HostTagView oHostTag = new HostTagView();
try
{
int hostId = HostTag.AddOrUpdateHostTag(0, hostTag.TagId, hostTag.HostExternalId, hostTag.HostName, (int)HostTypeType.Unknown, hostTag.Description, hostTag.ImagePath);
hostTag.HostId = hostId;
//lyz 设置用户绑定的标签的名称
device_Tag tag = new device_Tag();
tag.Id = hostTag.TagId;
if (tag.Select())
{
tag.TagName = hostTag.HostName;
tag.Save();
}
HostTag.SetHostGroup(hostId, (int)_userType);
if (grouplist.SelectedIndex > 0)
{
HostTag.SetHostGroup(hostId, int.Parse(grouplist.SelectedItem.Value));
}
HostTag.SetHostStatus(hostId, (int)HostTagStatusType.Normal);
Caching.Remove(AppKeys.Cache_TagStatusDictionary);
}
catch { }
//记录日志
Diary.Insert(ContextUser.Current.Id, hostTag.TagId, oHostTag.HostId, "新增标签使用者, " + nameCalling.Text + ": " + hostTag.HostName + (hostTag.TagId == 0 ? "。" : "，并已为其绑定标签。"));
//清除缓存
//TagUser.ClearCache();
bool isServiceAvailable = LocatingServiceUtil.IsAvailable();
//更新标签信息
if (hostTag.TagId != 0)
{
//Tag.UpdateTagNameAndSerialNo(hostTag.TagId, hostTag.HostName, hostTag.HostExternalId);
//LocatingServiceUtil.Instance<IServiceApi>().UpdateTagNameAndSerialNo(hostTag.TagId, hostTag.HostName, hostTag.HostExternalId);
if (Config.Settings.ProjectType != ProjectTypeEnum.WXFactory)//无锡项目需要给标签设定参数，所以需要手动启动定位
{
//自定将标签启动定位
XDocument xDoc = XDocument.Load(Server.MapPath(PathUtil.ResolveUrl("Settings/LocateParameters.xml")));
XElement root = xDoc.Element("Parameters");
int surveyGroupId = int.Parse(root.Element("SurveyGroup").Value);
using (AppDataContext db = new AppDataContext())
{
SurveyGroup surveryGroupValue = db.SurveyGroups.FirstOrDefault();
if (surveryGroupValue != null)
{
surveyGroupId = surveryGroupValue.Id;
}
}
TagLocateSetting useSettingModel = new TagLocateSetting
{
LocatingMode = byte.Parse(root.Element("LocatingMode").Value),
RssiBackCount = int.Parse(root.Element("RssiBackCount").Value),
ScanInterval = int.Parse(root.Element("ScanInterval").Value),
ScanMode = byte.Parse(root.Element("ScanMode").Value),
ScanSsid = root.Element("ScanSsid").Value,
ScanChannels = root.Element("ScanChannels").Value,
ScanTarget = byte.Parse(root.Element("ScanTarget").Value),
SurveyGroupId = surveyGroupId,
UpdateTime = DateTime.Now,
CommandState = (byte)LocatingCommandState.WaitToStart
};
if (Config.Settings.ProjectType == ProjectTypeEnum.WXFactory)
{
useSettingModel.ScanMode = 1;
}
TagLocateSetting.StartLocating(new int[] { hostTag.TagId }, useSettingModel);
if (isServiceAvailable)
{
// Send a command to LocatingService.
LocatingServiceUtil.Instance <IServiceApi>().StartStopLocating();
LocatingServiceUtil.Instance <IServiceApi>().ReloadTagHost(hostTag.TagId);
}
TagStatusView tagView = TagStatusView.SelectTagStatus(hostTag.TagId);
tagView.HostTag = HostTagView.GetHostView(hostTag.TagId);
}
}
int groupId = 1;
//设置犯人所在监舍
if (_userType == TagUserType.Culprit)
{
groupId = 2;
int areaId = int.Parse(culpritRoom.SelectedValue);
CulpritRoomReference.ArrangeNewReference(hostTag.HostId, areaId);
//查询警告条件
int ruleId = AreaWarningRule.SelectRuleByAreaId(areaId).Select(x => x.Id).FirstOrDefault();
//如果警告条件不存在，则自动建立一条
if (ruleId == 0)
{
var rule = new AreaWarningRule
{
AreaEventType = (byte)AreaEventType.StayOutside,
AreaId = areaId,
EnableToAllTags = false,
IsDisabled = false
};
if (isServiceAvailable)
{
ruleId = LocatingServiceUtil.Instance <IServiceApi>().InsertWarningRule(rule).Id;
}
else
{
ruleId = AreaWarningRule.InsertAndReturnId(rule);
}
}
//为警告条件设置关联标签
var culpritIdArray = CulpritRoomReference.All.Where(x => x.JailRoomId == areaId).Select(x => x.CulpritId).ToArray();
var tagIdArray = HostTag.All.Where(x => culpritIdArray.Contains(x.HostId) && x.TagId > 0).Select(x => x.TagId).ToArray();
if (isServiceAvailable)
{
LocatingServiceUtil.Instance <IServiceApi>().SetWarningRuleCoverage(ruleId, tagIdArray);
}
else
{
AreaWarningRuleCoverage.SetCoverage(ruleId, tagIdArray);
}
}
else if (_userType == TagUserType.Cop)
{
groupId = 1;
}
/*if (hostTag.TagId != 0)
* {
* TagGroup oGroup = TagGroup.Select(groupId);
* if (oGroup == null)
* {
*
* }
* else
* {
* int[] tagIdArray = new int[1];
* int[] selectedTagIdArray = TagGroupCoverage.GetCoveredTagIdArray(groupId);
* bool bIncluded = false;
* if (selectedTagIdArray != null && selectedTagIdArray.Length > 0)
* {
* for (int i = 0; i < selectedTagIdArray.Length; i++)
* {
* if (selectedTagIdArray[i] == hostTag.TagId)
* {
* bIncluded = true;
* break;
* }
* }
* if (!bIncluded)
* {
* tagIdArray = new int[selectedTagIdArray.Length + 1];
* tagIdArray[selectedTagIdArray.Length] = hostTag.TagId;
* }
* }
* else
* {
*
* tagIdArray[0] = hostTag.TagId;
* }
* if (!bIncluded)
* TagGroup.UpdateById(groupId, oGroup.GroupName, oGroup.GroupDescription, tagIdArray);
* }
* }*/
//结束
ShowMessagePage(string.Format(
"{0}: <span class='bold'>{1}</span>, {2}: <span class='bold'>{3}</span> 的信息已成功添加到系统中。",
nameCalling.Text, name.Text.Trim(), numberCalling.Text, number.Text.Trim()
),
new Link("继续"// + Wrap.Title
, Fetch.CurrentUrl),
Config.Settings.ProjectType == ProjectTypeEnum.NMPrison?new Link():new Link("返回信息列表", WebPath.GetFullPath("TagUsers/TagUserList.aspx?type=" + (byte)_userType))
);
}
private void LoadRepeater(string p_keyword, string p_extandId, int p_jailRoomSelectedIndex, string p_jailRoomSelectedValue, string tagBindingSelectedValue, string tagOnlineSelectedValue)
{
// var query = HostTagGroupStatus.All().Where(u => u.HostGroupId == (byte)_userType);
using (AppDataContext db = new AppDataContext())
{
var query = db.HostPositionStatusViews.ToList().Where(u => u.HostGroupId == (byte)_userType);
if (!string.IsNullOrEmpty(p_keyword.Trim()))
{
query = query.Where(u => u.HostName.ToUpper().Contains(p_keyword.Trim().ToUpper()));
}
if (!string.IsNullOrEmpty(p_extandId.Trim()))
{
query = query.Where(u => u.HostExternalId.ToUpper().Contains(p_extandId.Trim().ToUpper()));
}
if (tagBindingSelectedValue == "1")
{
query = query.Where(u => u.TagId != 0);
}
if (tagBindingSelectedValue == "2")
{
query = query.Where(u => u.TagId == 0);
}
if (tagOnlineSelectedValue == "1")
{
IList <TagStatusView> tagList = new List <TagStatusView>();
string _keyword = "";
int[] _hostGroupArray = null;
int totalCount = 0;
if (LocatingServiceUtil.IsAvailable())
{
IServiceApi serviceApi = LocatingServiceUtil.Instance <IServiceApi>();
if (serviceApi != null)
{
tagList = serviceApi.SelectTagStatusList(
_keyword,
_hostGroupArray,
0,
true,
false, //SupportEvent.Absent),
false, //SupportEvent.BatteryInsufficient),
false, //SupportEvent.AreaEvent),
false, //SupportEvent.ButtonPressed),
false, //SupportEvent.WristletBroken),
"",
SortDirection.Ascending,
9999,
0,
out totalCount);
}
}
query = query.Where(u => tagList.Where(t => t.X > 0).Select(t => t.TagId).ToList().Contains(u.TagId));
}
if (tagOnlineSelectedValue == "2")
{
IList <TagStatusView> tagList = new List <TagStatusView>();
string _keyword = "";
int[] _hostGroupArray = null;
int totalCount = 0;
if (LocatingServiceUtil.IsAvailable())
{
IServiceApi serviceApi = LocatingServiceUtil.Instance <IServiceApi>();
if (serviceApi != null)
{
tagList = serviceApi.SelectTagStatusList(
_keyword,
_hostGroupArray,
0,
true,
false, //SupportEvent.Absent),
false, //SupportEvent.BatteryInsufficient),
false, //SupportEvent.AreaEvent),
false, //SupportEvent.ButtonPressed),
false, //SupportEvent.WristletBroken),
"",
SortDirection.Ascending,
9999,
0,
out totalCount);
}
}
query = query.Where(u => !tagList.Where(t => t.X > 0).Select(t => t.TagId).ToList().Contains(u.TagId));
}
if (_userType == TagUserType.Culprit && p_jailRoomSelectedIndex > 0)
{
int[] range = CulpritRoomReference.GetCulpritIdByRoomId(int.Parse(p_jailRoomSelectedValue));
query = query.Where(u => range.Contains(u.HostId));
}
p.RecordCount = query.Count();
//if (_sortDir == SortDirection.Ascending)
//{
// query = query.OrderBy(u => u.HostName);
//}
//else
//{
// query = query.OrderByDescending(u => u.HostName);
//}
list.DataSource = query.Skip(p.RecordOffset).Take(p.PageSize).ToList();
list.DataBind();
}
}
public static string ChangeJailRoom(int culpritId, int newJailRoomId)
{
//get Host
HostTag hostTag = HostTag.GetById(culpritId);
if (hostTag == null || hostTag.HostName == "")
{
return("");
}
//记录旧ID
var oldJailRoomId = CulpritRoomReference.GetRoomIdByCulpritId(culpritId);
//取得新监舍名称
string newName = MapArea.All.Where(x => x.Id == newJailRoomId).Select(x => x.AreaName).SingleOrDefault();
//判断是否相同
if (oldJailRoomId == newJailRoomId)
{
return(newName);
}
//执行更换
CulpritRoomReference.ChangeRoom(culpritId, newJailRoomId);
//警告条件绑定
var isServiceAvailable = LocatingServiceUtil.IsAvailable();
int ruleId = 0;
int[] culpritIdArray = null;
int[] tagIdArray = null;
//旧监舍 -------------------------------------
if (oldJailRoomId != 0)
{
//查询警告条件
ruleId = AreaWarningRule.SelectRuleByAreaId(oldJailRoomId).Select(x => x.Id).FirstOrDefault();
//如果警告条件不存在，则自动建立一条
if (ruleId == 0)
{
var rule = new AreaWarningRule
{
AreaEventType = (byte)AreaEventType.StayOutside,
AreaId = oldJailRoomId,
EnableToAllTags = false,
IsDisabled = false
};
if (isServiceAvailable)
{
ruleId = LocatingServiceUtil.Instance <IServiceApi>().InsertWarningRule(rule).Id;
}
else
{
ruleId = AreaWarningRule.InsertAndReturnId(rule);
}
}
//为警告条件设置关联标签
culpritIdArray = CulpritRoomReference.All.Where(x => x.JailRoomId == oldJailRoomId).Select(x => x.CulpritId).ToArray();
tagIdArray = HostTag.All.Where(x => culpritIdArray.Contains(x.HostId) && x.TagId > 0).Select(x => x.TagId).ToArray();
if (isServiceAvailable)
{
LocatingServiceUtil.Instance <IServiceApi>().SetWarningRuleCoverage(ruleId, tagIdArray);
}
else
{
AreaWarningRuleCoverage.SetCoverage(ruleId, tagIdArray);
}
}
//新监舍 -------------------------------------
//查询警告条件
ruleId = AreaWarningRule.SelectRuleByAreaId(newJailRoomId).Select(x => x.Id).FirstOrDefault();
//如果警告条件不存在，则自动建立一条
if (ruleId == 0)
{
var rule = new AreaWarningRule
{
AreaEventType = (byte)AreaEventType.StayOutside,
AreaId = newJailRoomId,
EnableToAllTags = false,
IsDisabled = false
};
if (isServiceAvailable)
{
ruleId = LocatingServiceUtil.Instance <IServiceApi>().InsertWarningRule(rule).Id;
}
else
{
ruleId = AreaWarningRule.InsertAndReturnId(rule);
}
}
//为警告条件设置关联标签
culpritIdArray = CulpritRoomReference.All.Where(x => x.JailRoomId == newJailRoomId).Select(x => x.CulpritId).ToArray();
tagIdArray = HostTag.All.Where(x => culpritIdArray.Contains(x.HostId) && x.TagId > 0).Select(x => x.TagId).ToArray();
if (isServiceAvailable)
{
LocatingServiceUtil.Instance <IServiceApi>().SetWarningRuleCoverage(ruleId, tagIdArray);
}
else
{
AreaWarningRuleCoverage.SetCoverage(ruleId, tagIdArray);
}
//记录日志，返回
Diary.Insert(ContextUser.Current.Id, 0, culpritId, "将犯人" + hostTag.HostName + "更换监舍到" + newName);
return(newName);
}
protected void deleteButton_Click(object sender, EventArgs e)
{
HostTag host = HostTag.GetById(_id);
if (host != null)
{
bool serviceAvailable = LocatingServiceUtil.IsAvailable();
var tagId = host.TagId;
if (tagId > 0)
{
using (AppDataContext db = new AppDataContext())
{
//更新标签名称
Tag tag = Tag.Select(tagId);
if (tag != null)
{
string mac = tag.TagMac;
if (serviceAvailable)
{
LocatingServiceUtil.Instance <IServiceApi>().UpdateTagNameAndSerialNo(tagId, "NewTag_" + mac.Substring(12), "");
}
else
{
Tag.UpdateTagNameAndSerialNo(tagId, "NewTag_" + mac.Substring(12), "");
}
}
//删除标签历史记录和相关信息
AreaEventLog.DeleteByTagId(tagId);
GenericEventLog.DeleteByTagId(tagId);
TagPositionLog.DeleteByTagId(tagId);
//LocationChangeLog.DeleteMany(tagId);
//LatestEvent.DeleteByTagId(tagId);
TagEventStatus.DeleteMany(tagId);
TagPositionStatus.DeleteMany(tagId);
AreaWarningRuleCoverage.DeleteMany(tagId);
InterrogationLog.DeleteMany(host.HostId);
TagAlert.DeleteTagAlerts(tagId);
//删除低电记录: 不执行删除
//db.ExecuteCommand("delete from history_BatteryResetLog where TagId=", tagId);
}
TagLocateSetting.StopLocating(tagId);
if (serviceAvailable)
{
var s = LocatingServiceUtil.Instance <IServiceApi>();
s.StartStopLocating();
}
int areaId = CulpritRoomReference.GetRoomIdByCulpritId(host.HostId);
if (areaId != 0)
{
//查询警告条件
var ruleId = AreaWarningRule.SelectRuleByAreaId(areaId).Select(x => x.Id).FirstOrDefault();
//如果警告条件不存在，则自动建立一条
if (ruleId != 0)
{
//为警告条件设置关联标签
var culpritIdArray = CulpritRoomReference.All.Where(x => x.JailRoomId == areaId).Select(x => x.CulpritId).ToArray();
var tagIdArray = HostTag.All.Where(x => culpritIdArray.Contains(x.HostId) && x.TagId > 0 && x.TagId != tagId).Select(x => x.TagId).ToArray();
if (serviceAvailable)
{
LocatingServiceUtil.Instance <IServiceApi>().SetWarningRuleCoverage(ruleId, tagIdArray);
}
else
{
AreaWarningRuleCoverage.SetCoverage(ruleId, tagIdArray);
}
}
}
}
//删除使用者信息
CulpritRoomReference.DeleteByCulpritId(_id);
//TagUser.DeleteById(_id);
HostTag.DeleteHostTag(_id);
TagStatusView.SelectTagStatus(tagId).HostTag = null;
if (tagId > 0 && serviceAvailable)
{
LocatingServiceUtil.Instance <IServiceApi>().ReloadTagHost(tagId);
}
//记录日志
Diary.Insert(ContextUser.Current.Id, tagId, _id, "删除犯人" + host.HostName + "的信息" + (host.TagId == 0 ? "" : "并解除标签绑定。") + "。");
}
ShowMessagePage("删除成功。");
}
