static void Main(string[] args)
{
try
{
while (true)
{
TimeConvert convert = new TimeConvert();
Console.Write("Enter the hour and minutes in the format hh:mm (hour:minutes) : ");
string time = Convert.ToString(Console.ReadLine());
var result = convert.Convert(time);
Console.WriteLine("{0}\u00B0", result);
Console.WriteLine("---------");
}
}
catch (Exception e)
{
Console.WriteLine(e.Message);
}
Console.WriteLine("Press Enter to exit.");
Console.Read();
}
private void RemoveOldDevAlarms()
{
while (true)
{
try
{
//清除某一个时间之前的所有告警
Bll db = Bll.NewBllNoRelation();
DateTime nowTime = DateTime.Now;
DateTime starttime = DateTime.Now.AddDays(-DevAlarmKeepDays);
var starttimeStamp = TimeConvert.ToStamp(starttime);
var query = db.DevAlarms.DbSet.Where(i => i.AlarmTimeStamp < starttimeStamp);
var count = query.Count();
if (count > 0)
{
query.DeleteFromQuery();//这样删除效率高
//var alarms = db.DevAlarms.Where(i => i.AlarmTimeStamp < starttimeStamp);
//bool r = db.DevAlarms.RemoveList(alarms);
//MessageBox.Show("清空成功");
Log.Info("RemoveAlarm", "清除历史设备告警,数量:" + count);
}
Thread.Sleep(1000 * 3600);//一小时检查一次
}
catch (Exception ex)
{
Log.Error("RemoveAlarm", ex.ToString());
}
}
}
private void TicketIn_Click(object sender, RoutedEventArgs e)
{
TicketsService service = new TicketsService();
//List<TwoTickets> list = service.ListAll();
//List<OperationTicketSH> dbList = new List<OperationTicketSH>();
//foreach (TwoTickets ticket in list)
//{
// OperationTicketSH dbTable = ticket.ToDbModel();
// dbList.Add(dbTable);
//}
Bll bll = Bll.NewBllNoRelation();
//List<OperationTicketHistorySH> OperationHisList = bll.OperationTicketHistorySHs.ToList();
//List<OperationTicketHistorySH> newList = new List<OperationTicketHistorySH>();
//OperationHisList.Sort((a, b) => { return (int)a.Abutment_Id - (int)b.Abutment_Id; });
//int id = (int)OperationHisList.Last().Abutment_Id + 1;
//for (int i = 0; i < OperationHisList.Count; i++)
//{
// OperationTicketHistorySH ticket = OperationHisList[i];
// ticket.Abutment_Id = id;
// newList.Add(ticket);
// id = id + 1;
//}
//bool result = bll.OperationTicketHistorySHs.AddRange(newList);
// string sql = "delete from aa where id in(99,100)";
// string result= bll.WorkTicketHistorySHes.AddorEditBySql(sql);
DateTime now = DateTime.Now;
long a = TimeConvert.ToStamp(now);
}
public PersonnelHistory RemoveToHistory()
{
PersonnelHistory history = new PersonnelHistory();
history.Id = this.Id;
history.Abutment_Id = this.Abutment_Id;
history.Name = this.Name;
history.Sex = this.Sex;
history.Photo = this.Photo;
history.BirthDay = this.BirthDay;
history.BirthTimeStamp = this.BirthTimeStamp;
history.Nation = this.Nation;
history.Address = this.Address;
history.WorkNumber = this.WorkNumber;
history.Email = this.Email;
history.Phone = this.Phone;
history.Mobile = this.Mobile;
history.Enabled = this.Enabled;
history.ParentId = this.ParentId;
history.HistoryTime = DateTime.Now;
history.HistoryTimeStamp = TimeConvert.DateTimeToTimeStamp(history.HistoryTime);
return(history);
}
/// <summary>
/// 录像点播视频请求
/// </summary>
/// <param name="beginTime">开始时间</param>
/// <param name="endTime">结束时间</param>
public void BackVideoReq(DateTime beginTime, DateTime endTime)
{
lock (_msgCore.RemoteTrans)
{
if (!_msgCore.RemoteTrans.ContainsKey(_remoteEndPoint.ToString()))
{
OnSIPServiceChange(_deviceName + "-" + _deviceId + _remoteEndPoint.ToString(), SipServiceStatus.Wait);
return;
}
}
//if (_mediaPort == null)
//{
// _mediaPort = _msgCore.SetMediaPort();
//}
_mediaPort = _msgCore.SetMediaPort();
uint startTime = TimeConvert.DateToTimeStamp(beginTime);
uint stopTime = TimeConvert.DateToTimeStamp(endTime);
this.Stop();
SIPRequest realReq = BackVideoReq(_mediaPort, startTime, stopTime);
_msgCore.Transport.SendRequest(_remoteEndPoint, realReq);
//_realTask = new TaskTiming(realReq, _msgCore.Transport);
//_msgCore.SendRequestTimeout += _realTask.MessageSendRequestTimeout;
//_realTask.OnCloseRTPChannel += Task_OnCloseRTPChannel;
//_realTask.Start();
}
private void ApplyTest(int input, string expected)
{
TimeConvert calculator = new TimeConvert(input);
string result = calculator.GetResult();
//Assert.Fail();
}
public static DbModel.Location.Data.LocationCardPosition ToDbModel(
this Location.TModel.Location.Data.TagPosition item1)
{
if (item1 == null)
{
return(null);
}
var item2 = new DbModel.Location.Data.LocationCardPosition();
item2.Id = item1.Tag;
item2.X = item1.X;
item2.Y = item1.Y;
item2.Z = item1.Z;
item2.DateTime = TimeConvert.ToDateTime(item1.Time);
item2.DateTimeStamp = item1.Time;
item2.Power = item1.Power;
item2.Number = item1.Number;
item2.Flag = item1.Flag;
item2.Archors = item1.Archors;
item2.AreaId = item1.AreaId;
item2.AreaState = item1.AreaState;
item2.PowerState = item1.PowerState;
item2.MoveState = item1.MoveState;
return(item2);
}
void BtnMissionFinishOnClick(PointerEventData eventData, UI_Event ev)
{
int type = ev.GetData <int>("t");
Mission mis = ev.GetData <Mission>("d");
if (type == 1)
{
mis.mDateTime = TimeConvert.GetNow();
mis.mCount++;
}
else if (type == 2)
{
mis.mDateTime = TimeConvert.GetTommorrow();
mis.mFinished = TimeConvert.NowDay();
mis.mCount++;
}
mis.mLog = StatisticsManager.instance.AddLog(mis.mId, mis.mDesc);
StatisticsManager.instance.Save();
MissionManager.instance.Save();
List <Mission> lst_mis = MissionManager.instance.GetDailyMission();
float _pos = mContent.transform.localPosition.y;
ShowMission(lst_mis);
MoveScrollTo(_pos);
}
public LocationAlarmHistory RemoveToHistory()
{
LocationAlarmHistory history = new LocationAlarmHistory();
//history.Id = this.Id;
history.AlarmId = this.AlarmId;
history.AlarmType = this.AlarmType;
history.AlarmLevel = this.AlarmLevel;
history.LocationCardId = this.LocationCardId ?? 0;
history.PersonnelId = this.PersonnelId ?? 0;
history.AreadId = this.AreaId;
history.CardRoleId = this.CardRoleId;
history.Content = this.Content;
history.AlarmTime = this.AlarmTime;
history.AlarmTimeStamp = this.AlarmTimeStamp;
history.HandleTime = this.HandleTime;
history.HandleTimeStamp = this.HandleTimeStamp;
history.Handler = this.Handler;
history.HandleType = this.HandleType;
history.AuzId = this.AuzId;
history.AllAuzId = this.AllAuzId;
history.HistoryTime = DateTime.Now;
history.HistoryTimeStamp = TimeConvert.ToStamp(history.HistoryTime);
return(history);
}
/// <summary>
/// 控制录像点播播放速度
/// </summary>
/// <param name="scale">播放速度</param>
/// <param name="range">时间范围</param>
public void BackVideoPlaySpeedControlReq(string scale, DateTime range)
{
if (_msgCore.LocalEndPoint == null)
{
OnSIPServiceChange(_deviceName + "-" + _deviceId, SipServiceStatus.Wait);
return;
}
if (_mediaPort == null)
{
_mediaPort = _msgCore.SetMediaPort();
}
uint time = TimeConvert.DateToTimeStamp(range);
string localIp = _msgCore.LocalEndPoint.Address.ToString();
string fromTag = CallProperties.CreateNewTag();
int cSeq = CallProperties.CreateNewCSeq();
string callId = CallProperties.CreateNewCallId();
//this.Stop();
SIPRequest realReq = BackVideoPlaySpeedControlReq(localIp, _mediaPort, scale, time, fromTag, cSeq, callId);
_msgCore.Transport.SendRequest(_msgCore.RemoteEndPoint, realReq);
_realTask = new TaskTiming(realReq, _msgCore.Transport);
_msgCore.SendRequestTimeout += _realTask.MessageSendRequestTimeout;
_realTask.OnCloseRTPChannel += Task_OnCloseRTPChannel;
_realTask.Start();
}
public AreaStatistics GetAreaStatisticsCount(List <int?> lst)
{
try
{
var query = from t1 in db.LocationCardPositions.DbSet
join t2 in db.Personnels.DbSet on t1.PersonId equals t2.Id
where lst.Contains(t1.AreaId)
select t2;
var query2 = from t1 in db.DevInfos.DbSet
where lst.Contains(t1.ParentId) && t1.Local_TypeCode != 20180821 //把基站排除了
select t1;
var query3 = from t1 in db.LocationAlarms.DbSet
where lst.Contains(t1.AreaId) && t1.AlarmLevel != 0
select t1;
DateTime now = DateTime.Now;
DateTime todayStart = new DateTime(now.Year, now.Month, now.Day, 0, 0, 0, 0);
DateTime todayEnd = new DateTime(now.Year, now.Month, now.Day, 23, 59, 59, 999);
var startStamp = TimeConvert.ToStamp(todayStart);
var endStamp = TimeConvert.ToStamp(todayEnd);
var query4 = from t1 in db.DevInfos.DbSet
join t2 in db.DevAlarms.DbSet on t1.Id equals t2.DevInfoId
where lst.Contains(t1.ParentId) && t2.AlarmTimeStamp >= startStamp && t2.AlarmTimeStamp <= endStamp
select t2;
var query5 = (from t1 in db.LocationAlarms.DbSet
where lst.Contains(t1.AreaId) && t1.AlarmLevel != 0
select t1.PersonnelId).Distinct().ToList();
var ass = new AreaStatistics();
ass.PersonNum = query.Count();
ass.DevNum = query2.Count();
ass.LocationAlarmNum = query3.Count();
ass.DevAlarmNum = query4.Count();
ass.AlarmPersonNum = query5.Count();//只需要数量信息，不要用ToList()，避免大量数据时封装到实体类的消耗
PersonService personService = new PersonService(db);
var list = personService.GetList(false, false);
if (list != null)
{
ass.PersonNum = list.Count;
}
else
{
ass.PersonNum = 0;
}
return(ass);
}
catch (System.Exception ex)
{
Log.Error(tag, "GetAreaStatisticsCount", ex.ToString());
return(null);
}
}
public static DbEntity ToDbModel(this TEntity item1)
{
if (item1 == null)
{
return(null);
}
var item2 = new DbEntity();
item2.Id = item1.Id;
item2.Abutment_Id = item1.Abutment_Id;
item2.Name = item1.Name;
item2.Sex = item1.Sex == "男" ? Sexs.男 : item1.Sex == "女" ? Sexs.女 : Sexs.未知;
item2.Photo = item1.Photo;
item2.BirthDay = item1.BirthDay;
item2.BirthTimeStamp = TimeConvert.DateTimeToTimeStamp((DateTime)item1.BirthDay);
item2.Nation = item1.Nation;
item2.Address = item1.Address;
item2.WorkNumber = item1.WorkNumber;
item2.Email = item1.Email;
item2.Phone = item1.PhoneNumber;
item2.Mobile = item1.Mobile;
item2.Enabled = item1.Enabled;
item2.ParentId = item1.ParentId;
item2.Pst = item1.Pst;
return(item2);
}
public void Load()
{
string path = Misc.GetPersistentDataPath() + "/savedata.json";
if (File.Exists(path))
{
string json_str = File.ReadAllText(path);
List <object> lst = Json.Deserialize(json_str) as List <object>;
if (lst != null)
{
ToModel(lst);
}
}
else
{
Mission mis = new Mission();
mis.mId = MaxID++;
mis.mType = MissionType.Daily;
mis.mDateTime = TimeConvert.GetNow();
mis.mFinished = TimeConvert.NowDay();
mis.mDesc = "test1";
AddMission(mis);
mis = new Mission();
mis.mId = MaxID++;
mis.mType = MissionType.Daily;
mis.mDateTime = TimeConvert.GetNow();
mis.mFinished = TimeConvert.NowDay();
mis.mDesc = "test2";
AddMission(mis);
mis = new Mission();
mis.mId = MaxID++;
mis.mType = MissionType.Daily;
mis.mDateTime = new DateTime(2000, 1, 1, 8, 0, 0);
mis.mDesc = "test3";
AddMission(mis);
mis = new Mission();
mis.mId = MaxID++;
mis.mType = MissionType.Daily;
mis.mDateTime = new DateTime(2001, 1, 1, 8, 0, 0);
mis.mDesc = "test4";
AddMission(mis);
mis = new Mission();
mis.mId = MaxID++;
mis.mType = MissionType.Daily;
mis.mDateTime = TimeConvert.GetNow();
mis.mDesc = "test5";
AddMission(mis);
mis = new Mission();
mis.mId = MaxID++;
mis.mType = MissionType.Daily;
mis.mDateTime = TimeConvert.GetNow();
mis.mDesc = "test6";
AddMission(mis);
}
}
void BtnOkOnClick(PointerEventData eventData, UI_Event ev)
{
if (mIsEdit)
{
CloseScreen();
UIDailyMission ui_daily_mission = MenuManager.instance.FindMenu <UIDailyMission>();
if (ui_daily_mission != null)
{
ui_daily_mission.FinishEditMission(mMission);
}
}
else
{
Mission mis = new Mission();
mis.mId = MissionManager.instance.MaxID++;
mis.mType = MissionType.Daily;
mis.mTextureName = mMission.mTextureName;
mis.mDesc = mMission.mDesc;
mis.mDateTime = TimeConvert.GetNow();
MissionManager.instance.AddMission(mis);
CloseScreen();
UIDailyMission ui_daily_mission = MenuManager.instance.FindMenu <UIDailyMission>();
if (ui_daily_mission != null)
{
ui_daily_mission.FinishAddMission(mis);
}
}
}
private DevAlarm CreateDevAlarm(UDPArchor item)
{
DevAlarm alarm = new DevAlarm();
alarm.Level = Abutment_DevAlarmLevel.低;
alarm.Code = "基站离线";
alarm.Title = "基站离线";
alarm.Src = Abutment_DevAlarmSrc.人员定位;//其实应该加上“基站扫描”的
alarm.AlarmTime = DateTime.Now;
alarm.AlarmTimeStamp = TimeConvert.ToStamp(alarm.AlarmTime);
var clientIP = item.GetClientIP();
alarm.Msg = "基站离线:" + clientIP;
var anchor = DbArchorList.Find(i => i.Ip == clientIP);
if (anchor != null)
{
var devId = (int)anchor.DevId;
var dev = devDict[devId];
alarm.DevInfo = dev;
alarm.DevInfoId = devId;
alarm.Device_desc = dev.Name;
alarm.Title = string.Format("基站离线[{0},{1}]", anchor.Code.Trim(), anchor.Ip.Trim());
alarm.Msg = string.Format("基站离线[{0},{1}]", anchor.Code, anchor.Ip);
//alarm.AreaId
}
alarm.DictKey = alarm.Msg;
return(alarm);
}
public static string Encrypt(string key)
{
string timespan = TimeConvert.GetCurrentUTCTimeSpan();
string mixedKey = $"{timespan}&{key}&{_desKey}";
return(DESProvider.Encrypt(mixedKey, _desKey));
}
void BtnMissionCancelOnClick(PointerEventData eventData, UI_Event ev)
{
int type = ev.GetData <int>("t");
Mission mis = ev.GetData <Mission>("d");
if (type == 1)
{
mis.mDateTime = TimeConvert.GetNow();
}
else if (type == 3)
{
mis.mDateTime = TimeConvert.GetNow();
mis.mFinished = 0;
mis.mCount--;
StatisticsManager.instance.RemoveLog(mis.mLog);
StatisticsManager.instance.Save();
mis.mLog = null;
}
MissionManager.instance.Save();
List <Mission> lst_mis = MissionManager.instance.GetDailyMission();
float _pos = mContent.transform.localPosition.y;
ShowMission(lst_mis);
MoveScrollTo(_pos);
}
public void SetTime()
{
DateTime now = DateTime.Now;
DateTimeStamp = TimeConvert.ToStamp(now);
DateTime now2 = TimeConvert.ToDateTime(DateTimeStamp);
}
public void Add_TheHourAndMinutes_NegativeValues_FormatException(string time)
{
// Arrange
TimeConvert convert = new TimeConvert();
// Act
Assert.Throws <FormatException>(() => convert.Convert(time));
}
public Personnel()
{
BirthDay = DateTime.Now;
BirthTimeStamp = TimeConvert.ToStamp(BirthDay);
Enabled = true;
Sex = Sexs.男;
//Pst = "检修";
}
public DevInfo()
{
CreateTime = DateTime.Now;
ModifyTime = DateTime.Now;
CreateTimeStamp = TimeConvert.DateTimeToTimeStamp(CreateTime);
ModifyTimeStamp = TimeConvert.DateTimeToTimeStamp(ModifyTime);
}
private void SetTime()
{
AlarmTime = DateTime.Now;
AlarmTimeStamp = TimeConvert.ToStamp(AlarmTime);
HandleTime = new DateTime(2000, 1, 1);
HandleTimeStamp = TimeConvert.ToStamp(HandleTime);
}
public bool IsFinished()
{
int day1 = TimeConvert.NowDay();
if (day1 != mFinished)
{
return(false);
}
return(true);
}
public TEntity Put(TEntity item)
{
var dbItem = item.ToDbModel();
dbItem.ModifyTime = DateTime.Now;
dbItem.ModifyTimeStamp = TimeConvert.DateTimeToTimeStamp(dbItem.ModifyTime);
var result = dbSet.Edit(dbItem);
return(result ? dbItem.ToTModel() : null);
}
void BtnMissionFinishOnClick(PointerEventData eventData, UI_Event ev)
{
Mission mis = ev.GetData <Mission>("d");
//mis.mDateTime = DateTime.Now;
mis.mFinished = TimeConvert.NowDay();
List <Mission> lst_mis = MissionManager.instance.GetDailyMission();
ShowMission(lst_mis);
}
public void Add_TheHourAndMinutes_PositiveValues(double expected, string time)
{
// Arrange
TimeConvert convert = new TimeConvert();
// Act
var result = convert.Convert(time);
// Assert
Assert.AreEqual(expected, result);
}
/// <summary>
/// 获取单个设备信息
/// </summary>
/// <param name="id"></param>
/// <returns></returns>
public device GetSingleDeviceInfo(int id)
{
device recv = new device();
string strId = Convert.ToString(id);
try
{
string path = "api/devices/" + strId;
string url = BaseUri + path;
recv = GetEntityDetail <device>(url);
DevInfo devinfo = bll.DevInfos.DbSet.Where(p => p.KKS == recv.kksCode).FirstOrDefault();
int nFlag = 0;
if (devinfo == null)
{
devinfo = new DevInfo();
nFlag = 1;
}
devinfo.Abutment_Id = recv.id;
devinfo.Code = recv.code;
devinfo.KKS = recv.kksCode;
devinfo.Name = recv.name;
devinfo.Abutment_Type = (Abutment_DevTypes)recv.type;
devinfo.Status = (Abutment_Status)recv.state;
devinfo.RunStatus = (Abutment_RunStatus)recv.running_state;
devinfo.Placed = recv.placed;
devinfo.Abutment_DevID = recv.raw_id;
if (nFlag == 1)
{
devinfo.CreateTime = DateTime.Now;
devinfo.ModifyTime = DateTime.Now;
devinfo.CreateTimeStamp = TimeConvert.DateTimeToTimeStamp(devinfo.CreateTime);
devinfo.ModifyTimeStamp = TimeConvert.DateTimeToTimeStamp(devinfo.ModifyTime);
bll.DevInfos.Add(devinfo);
}
else
{
devinfo.ModifyTime = DateTime.Now;
devinfo.ModifyTimeStamp = TimeConvert.DateTimeToTimeStamp(devinfo.ModifyTime);
bll.DevInfos.Edit(devinfo);
}
}
catch (Exception ex)
{
string messgae = ex.Message;
}
return(recv);
}
public BaseTran <sis> GetSomesisList(string kks)
{
BaseTran <sis> recv = new BaseTran <sis>();
try
{
string path = "api/rt/sis?kks=" + kks;
string url = BaseUri + path;
recv = GetEntityList <sis>(url);
if (recv.data == null)
{
recv.data = new List <sis>();
}
foreach (sis item in recv.data)
{
DevInfo DevInfo = bll.DevInfos.DbSet.Where(p => p.KKS == item.kks).FirstOrDefault();
if (DevInfo == null)
{
continue;
}
DevInstantData did = bll.DevInstantDatas.DbSet.Where(p => p.Id == item.kks).FirstOrDefault();
if (did == null)
{
did = new DevInstantData();
did.Id = item.kks;
did.Value = item.value;
did.DateTime = DateTime.Now;
did.DateTimeStamp = TimeConvert.DateTimeToTimeStamp(did.DateTime);
bll.DevInstantDatas.Add(did);
}
else
{
DevInstantDataHistory didh = did.RemoveToHistory();
did.Value = item.value;
did.DateTime = DateTime.Now;
did.DateTimeStamp = TimeConvert.DateTimeToTimeStamp(did.DateTime);
bll.DevInstantDatas.Edit(did);
bll.DevInstantDataHistorys.Add(didh);
}
}
}
catch (Exception ex)
{
string messgae = ex.Message;
}
return(recv);
}
public EntranceGuardCardToPersonnelHistory RemoveToHistory()
{
EntranceGuardCardToPersonnelHistory history = new EntranceGuardCardToPersonnelHistory();
history.Id = this.Id;
history.EntranceGuardCardId = this.EntranceGuardCardId;
history.PersonnelId = this.PersonnelId;
history.HistoryTime = DateTime.Now;
history.HistoryTimeStamp = TimeConvert.DateTimeToTimeStamp(history.HistoryTime);
return(history);
}
private void MenuClearHisAlarms_Click(object sender, RoutedEventArgs e)
{
Bll db = Bll.NewBllNoRelation();
DateTime now = DateTime.Now;
//DateTime todayStart = new DateTime(now.Year, now.Month, now.Day, now.Hour, now.Minute, now.Second, now.Millisecond);
DateTime todayStart = new DateTime(now.Year, now.Month, now.Day, 0, 0, 0, 0);
DateTime todayEnd = new DateTime(now.Year, now.Month, now.Day, 23, 59, 59, 999);
var tamp = TimeConvert.ToStamp(todayStart);
var alarms = db.DevAlarms.Where(i => i.AlarmTimeStamp < tamp);
bool r = db.DevAlarms.RemoveList(alarms);
MessageBox.Show("清空成功");
}
