public ProfilePageVM(SQLiteDataService dataService, string username)
{
personService = dataService;
groupService = dataService;
markService = dataService;
this.username = username;
}
private void ListBoxRunnableActivityItem_MouseDoubleClick(object sender, MouseEventArgs e)
{
if (e.LeftButton == MouseButtonState.Pressed)
{
if (e.Source is ListBoxImageItem)
{
var activity = (e.Source as ListBoxImageItem).DataContext as Activity;
if (activity != null)
{
if (SQLiteDataService.IsExsitThisActivityFile(activity.Name))
{
if (MessageBox.Show(" 正在下载的'" + activity.Name + "'文件在系统中已存在，\r\n 若重新下载后，原文件中的数据将被清空。\r\n 是否重新下载?", "提示", MessageBoxButton.OKCancel) == MessageBoxResult.OK)
{
SQLiteDataService.WriteActivityToLocal(activity.Guid);
}
}
else
{
SQLiteDataService.WriteActivityToLocal(activity.Guid);
}
}
this.OpenActivity(activity);
//this.OpenActivity((e.Source as ListBoxImageItem).DataContext as Activity);
}
}
}
//private void SaveEmitInfoToSqLite(List<StationEmitInfo> p_emitList)
//{
// foreach (StationEmitInfo emitInfo in p_emitList)
// {
// SQLiteDataService.SaveEmitInfo(emitInfo);
// }
//}
private void SaveActivityToSqLite(List <Activity> activityList)
{
foreach (Activity activity in activityList)
{
SQLiteDataService.SaveActivity(activity);
}
}
public void DeleteProfile()
{
SQLiteDataService localBD = new SQLiteDataService();
//localBD.DeleteAllCurrentUsers();
CurrentUser curUS = localBD.GetCurrentUser();
using (var client = new HttpClient())
{
try
{
var response = client.DeleteAsync($"{APP_PATH}/api/user/DeleteUser?id={curUS.UserId}");
if (response.Result.StatusCode == HttpStatusCode.OK)
{
localBD.DeleteAllCurrentUsers();
localBD.DeleteAllCurrentNetworks();
}
else
{
System.Diagnostics.Debug.WriteLine($"Got wrong response StatusCode while creating new network: {response.Result.StatusCode}");
Log.Error($"Got wrong response StatusCode while deleting current user: {response.Result.StatusCode}");
}
}
catch (Exception e)
{
System.Diagnostics.Debug.WriteLine($"Couldn't delete user: {e}");
Log.Error(e, "Couldn't delete user");
}
}
}
public void RegisterNewUser(string userName)
{
User user = new User();
user.Name = userName;
using (var client = new HttpClient())
{
try
{
var response = client.PostAsJsonAsync <User>(APP_PATH + "/api/user/CreateNewUser", user);
User deserializedUser;
if (response.Result.StatusCode == HttpStatusCode.Created)
{
deserializedUser = JsonConvert.DeserializeObject <User>(response.Result.Content.ReadAsStringAsync().Result);
//MessagingCenter.Send<ServerConnection, string>(this, "UpdateUserName_NetworkActivity", $"{deserializedUser.Name} {deserializedUser.UserId}");
SQLiteDataService localBD = new SQLiteDataService();
localBD.AddCurrentUser(deserializedUser);
}
else
{
System.Diagnostics.Debug.WriteLine($"Got wrong response StatusCode while creating new user: {response.Result.StatusCode}");
Log.Error($"Got wrong response StatusCode while creating new user: {response.Result.StatusCode}");
}
}
catch (Exception e)
{
System.Diagnostics.Debug.WriteLine($"Couldn't create new user: {e}");
Log.Error(e, "Couldn't create new user");
}
}
}
private void BeginDownLoad()
{
_progressBar.Maximum = 4;
_progressBar.Value = 0;
OperateLog log = new OperateLog();
log.Guid = CO_IA.Client.Utility.NewGuid();
log.Operater = RiasPortal.Current.UserSetting.UserName;
log.OperateDate = DateTime.Now;
log.OperateType = OperateTypeEnum.DownLoad;
UpdateProgressBarDelegate updatePbDelegate = new UpdateProgressBarDelegate(_progressBar.SetValue);
SQLiteDataService.Transaction = SQLiteConnect.GetSQLiteTransaction(SystemLoginService.CurrentActivity.Name);
try
{
SQLiteDataService.DeleteStationBase(SystemLoginService.CurrentActivity.Guid, SystemLoginService.CurrentActivityPlace.Guid);
SQLiteDataService.DeleteFreqPlan(SystemLoginService.CurrentActivity.Guid, SystemLoginService.CurrentActivityPlace.Guid);
SQLiteDataService.DeletePlace(SystemLoginService.CurrentActivity.Guid);
for (int i = 0; i < 4; i++)
{
if (i == 0 && _statDownLoad.IsChecked == true)
{
_downLoadInfo.Text = "正在下载周围台站数据";
DownLoadStationBase();
log.OperateTables += "ACTIVITY_PLACE_STATION,";
}
//else if (i == 1 && _emitDownLoad.IsChecked == true)
//{
// _downLoadInfo.Text = "正在下载设备信息数据";
// DownLoadEquipInfo();
// log.OperateTables += "ACTIVITY_STATION_EMIT,";
//}
else if (i == 2 && _areaDownLoad.IsChecked == true)
{
_downLoadInfo.Text = "正在下载活动区域数据";
DownLoadActivityPlace();
log.OperateTables += "ACTIVITY_PLACE,ACTIVITY_PLACE_LOCATION,";
}
else if (i == 3 && _freqRangeDownLoad.IsChecked == true)
{
_downLoadInfo.Text = "正在下载频率预案数据";
DownLoadFreqPlan();
log.OperateTables += "activity_place_freq_plan, rias_equipment_freqplanning,";
}
Dispatcher.Invoke(updatePbDelegate, System.Windows.Threading.DispatcherPriority.Background, new object[] { System.Windows.Controls.ProgressBar.ValueProperty, Convert.ToDouble(i + 1) });
}
SQLiteDataService.SaveOperaterLog(log);
SQLiteDataService.Transaction.Commit();
_downLoadInfo.Text = "下载完成";
}
catch (Exception ex)
{
SQLiteDataService.Transaction.Rollback();
Console.WriteLine(ex.Message);
_downLoadInfo.Text = "下载失败";
MessageBox.Show("失败原因：\r\n" + ex.Message);
}
}
public void RegisterNewNetwork(string name, string pass)
{
try
{
localDb = new SQLiteDataService();
using (var client = new HttpClient())
{
var currentUser = localDb.GetCurrentUser();
Network net = new Network()
{
Name = name, Password = pass, CreatorUserId = currentUser.UserId
};
var response = client.PostAsJsonAsync <Network>(APP_PATH + "/api/network/CreateNewNetwork", net);
Network deserializedNetwork;
if (response.Result.StatusCode == HttpStatusCode.Created)
{
deserializedNetwork = JsonConvert.DeserializeObject <Network>(response.Result.Content.ReadAsStringAsync().Result);
SQLiteDataService localBD = new SQLiteDataService();
localBD.AddCurrentNetwork(deserializedNetwork);
currentUser.NetworkId = deserializedNetwork.NetworkId;
}
else
{
System.Diagnostics.Debug.WriteLine($"Got wrong response StatusCode while creating new network: {response.Result.StatusCode}");
Log.Error($"Got wrong response StatusCode while creating new network: {response.Result.StatusCode}");
}
}
}
catch (Exception e)
{
System.Diagnostics.Debug.WriteLine($"Couldn't create new network: {e}");
Log.Error(e, "Couldn't create new network");
}
}
private void SavePlaceFreqPlan(List <PlaceFreqPlan> freqList)
{
foreach (PlaceFreqPlan freq in freqList)
{
SQLiteDataService.SaveFreqPlan(freq);
}
}
private void SaveActivityPlaceLocationToSqLite(List <ActivityPlaceLocation> placeLocationList)
{
foreach (ActivityPlaceLocation location in placeLocationList)
{
SQLiteDataService.SaveActivityPlaceLocation(location);
}
}
void dataAanalysis_StationHyperlinkClick(string p_stationGuid)
{
if (string.IsNullOrEmpty(p_stationGuid))
{
return;
}
if (!SystemLoginService.IsLogin)//脱机
{
List <StationEmitInfo> listEmitInfo = SQLiteDataService.QueryEmitInfoByStatID(p_stationGuid);
List <ActivitySurroundStation> listStation = SQLiteDataService.QueryStationBaseInfo(p_stationGuid);
StationDetailDialog dialog1 = new StationDetailDialog(listStation, listEmitInfo);
dialog1.ShowDialog(this);
return;
}
StationDetailDialog dialog = new StationDetailDialog(p_stationGuid);
dialog.ShowDialog(this);
//List<RoundStationInfo> list = GetRoundStationInfos(p_freqGuid);
//if (list.Count > 0)
//{
// //AroundStationQueryDialog dialog = new AroundStationQueryDialog(list);
// //dialog.ShowDialog(this);
//}
//else
//{
// MessageBox.Show("数据库中没有找到频率ID为'" + p_freqGuid + "'的台站信息");
//}
}
/// <summary>
/// 加载活动
/// </summary>
/// <param name="activity"></param>
public void LoadActivity(CO_IA.Data.Activity activity)
{
SystemLoginService.CurrentActivity = activity;
SetNetLinkState(SystemLoginService.IsLogin);
_activityName.Text = activity.Name;
List <ActivityPlace> placeList = SQLiteDataService.QueryPlaceByActivityGuid(activity.Name, activity.Guid);
if (placeList.Count == 0)
{
_layerMask.Visibility = System.Windows.Visibility.Visible;
xCollect.Visibility = System.Windows.Visibility.Collapsed;
xAppButtonAnalysis.Visibility = System.Windows.Visibility.Collapsed;
xDataUpload.Visibility = System.Windows.Visibility.Collapsed;
_noPlaceTooltip.Text = "没有找到活动区域，请在保持联网的状态下，下载最新活动区域数据后，再重新启动系统";
return;
}
else
{
_layerMask.Visibility = System.Windows.Visibility.Collapsed;
xCollect.Visibility = System.Windows.Visibility.Visible;
xAppButtonAnalysis.Visibility = System.Windows.Visibility.Visible;
if (SystemLoginService.IsLogin == true)
{
xDataUpload.Visibility = System.Windows.Visibility.Visible;
}
_noPlaceTooltip.Text = "";
}
LoadAreaCbox(placeList);
}
private void SaveActivityPlaceToSqLite(List <ActivityPlaceInfo> placeList)
{
foreach (ActivityPlaceInfo place in placeList)
{
SQLiteDataService.DeletePlaceLocation(place.Guid);
SQLiteDataService.SaveActivityPlace(place);
}
}
private void SaveStationBaseToSqLite(List <ActivitySurroundStation> p_statList)
{
foreach (ActivitySurroundStation stationBase in p_statList)
{
SQLiteDataService.DeleteEmitInfo(stationBase.STATGUID, "");
SQLiteDataService.SaveStationBase(stationBase);
}
}
//定义命令属性
public void deleteStudent(object parameter)
{
if (ID == 0)
{
MessageBox.Show("请选择删除项");
return;
}
WriteLog("进行了删除操作");
SQLiteDataService ds = new SQLiteDataService();
ds.DeleteUser(ID);
LoadUserInfo();
ID = 0;
}
public void LoadUserInfo()
{
mylist.Clear();
SQLiteDataService ds = new SQLiteDataService();
var users = ds.GetAllUsers();
foreach (var user in users)
{
mylist.Add(new User()
{
ID = user.ID, Name = user.Name, Age = user.Age, Sex = user.Sex, Remarks = user.Remarks
});
}
}
private void BeginUpLoad()
{
_progressBar.Maximum = 2;
_progressBar.Value = 0;
UpdateProgressBarDelegate updatePbDelegate = new UpdateProgressBarDelegate(_progressBar.SetValue);
OperateLog log = new OperateLog();
log.Guid = CO_IA.Client.Utility.NewGuid();
log.Operater = RiasPortal.Current.UserSetting.UserName;
log.OperateDate = DateTime.Now;
log.OperateType = OperateTypeEnum.UpLoad;
try
{
for (int i = 0; i < 2; i++)
{
if (i == 0)
{
if (_analysisUpLoad.IsChecked == true)
{
_upLoadInfo.Text = "正在上传分析结果数据";
UpLoadAnalysisResult();
log.OperateTables += "ACTIVITY_ANALYSIS_RESULT,";
}
}
else if (i == 1)
{
if (_emitUpLoad.IsChecked == true)
{
_upLoadInfo.Text = "正在上传发射信息数据";
UpLoadEmitInfo();
log.OperateTables += "ACTIVITY_EMIT_INFO,";
}
}
Dispatcher.Invoke(updatePbDelegate, System.Windows.Threading.DispatcherPriority.Background, new object[] { System.Windows.Controls.ProgressBar.ValueProperty, Convert.ToDouble(i + 1) });
}
SQLiteDataService.Transaction = SQLiteConnect.GetSQLiteTransaction(SystemLoginService.CurrentActivity.Name);
SQLiteDataService.SaveOperaterLog(log);
SQLiteDataService.Transaction.Commit();
_upLoadInfo.Text = "上传成功";
}
catch (Exception ex)
{
_upLoadInfo.Text = "上传失败";
//MessageBox.Show("失败原因：\r\n" + ex.Message);
}
}
public void Register(object parameter)
{
if (Name == null)
{
MessageBox.Show("用户名不能为空");
return;
}
if (Password == null)
{
MessageBox.Show("密码不能为空");
return;
}
Regex reg = new Regex(@"[^0-9]"); // 排除型字符组(取反思想)
if (reg.IsMatch(Name))
{
MessageBox.Show("姓名中不能包含特殊符号！");
return;
}
if (reg.IsMatch(Password) || reg.IsMatch(Password2))
{
MessageBox.Show("密码中不能包含特殊符号！");
return;
}
if (Password != Password2)
{
MessageBox.Show("两次输入的密码不一致");
return;
}
SQLiteDataService ds = new SQLiteDataService();
if (ds.Register(Name, Password))
{
MessageBox.Show("注册成功");
RegisterWindow win = (RegisterWindow)parameter;
win.Close();
}
else
{
MessageBox.Show("注册失败，该用户名已存在");
return;
}
}
protected override void OnCreate(Bundle savedInstanceState)
{
base.OnCreate(savedInstanceState);
Xamarin.Forms.Forms.Init(this, savedInstanceState);
SetContentView(Resource.Layout.NetworkView);
FindViews();
HandleEvents();
serverConnection = new ServerConnection();
localDb = new SQLiteDataService();
SetupCurrentUserElementGroup();
SetupCurrentNetworkElementGroup();
//Xamarin.Forms.MessagingCenter.Subscribe<ServerConnection, string>(this, "UpdateUserName_NetworkActivity", (sender, user) => {
// CurrentUserText.Text = user;
//});
}
public void searchStudent(object parameter)
{
WriteLog("进行了查找操作");
if (Name.Length != 0)
{
SQLiteDataService ds = new SQLiteDataService();
int id = ds.FindUser(Name);
if (id == 0)
{
MessageBox.Show("未找到此人");
}
else
{
MessageBox.Show("查找成功，id=" + id);
}
}
else
{
MessageBox.Show("请填写要查找的姓名");
}
}
public void Login(object parameter)
{
LoginWindow win = (LoginWindow)parameter;
SQLiteDataService ds = new SQLiteDataService();
string _password = ds.GetPWD(Name);
if (_password == null)
{
MessageBox.Show("该账户不存在");
return;
}
password = win.passwordBox.Password;
if (password != _password)
{
MessageBox.Show("密码错误");
return;
}
MessageBox.Show("登录成功");
win.DialogResult = true;
win.Close();
}
public bool JoinToNetwork(string name, string pass)
{
try
{
localDb = new SQLiteDataService();
using (var client = new HttpClient())
{
var currentUser = localDb.GetCurrentUser();
var tt = $"{APP_PATH}/api/network/GetNetwork?name={name}&pass={pass}";
var response = client.GetAsync($"{APP_PATH}/api/network/GetNetwork?name={name}&pass={pass}");
Network deserializedNetwork;
if (response.Result.StatusCode == HttpStatusCode.Found)
{
deserializedNetwork = JsonConvert.DeserializeObject <Network>(response.Result.Content.ReadAsStringAsync().Result);
SQLiteDataService localBD = new SQLiteDataService();
localBD.AddCurrentNetwork(deserializedNetwork);
currentUser.NetworkId = deserializedNetwork.NetworkId;
return(true);
}
else if (response.Result.StatusCode == HttpStatusCode.NotFound)
{
return(false);
}
else
{
System.Diagnostics.Debug.WriteLine($"Got wrong response StatusCode while creating new network: {response.Result.StatusCode}");
Log.Error($"Got wrong response StatusCode while creating new network: {response.Result.StatusCode}");
return(false);
}
}
}
catch (Exception e)
{
System.Diagnostics.Debug.WriteLine($"Couldn't get a network: {e}");
Log.Error(e, "Couldn't get a network");
return(false);
}
}
/// <summary>
/// 导入频率规划
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void btn_ImportFreq_Click(object sender, RoutedEventArgs e)
{
//List<FreqPlanSegment> freqPlanList = GetFreqPartPlan();
//List<FreqPlanActivity> freqPlanList = GetActivityFreqPlanInfoSource(LoginService.CurrentActivityPlace.Guid);
List <FreqPlanSegment> freqPlanList = SQLiteDataService.QueryFreqPlanByPlaceID(LoginService.CurrentActivityPlace.Guid); //add by michael 17.07.20
if (freqPlanList != null && freqPlanList.Count > 0)
{
navBar.Groups.Clear();//add by michael
for (int i = 0; i < freqPlanList.Count; i++)
{
FreqPlanSegment fps = freqPlanList[i];
NavBarGroup nbg = new NavBarGroup();
AT_BC.Data.Range <double> freqValue = fps.FreqValue;
//nbg.Header = fps.FreqPlanName + " " + freqValue.Little / 1000000 + "--" + freqValue.Great / 1000000 + "MHz";
nbg.Header = fps.FreqPlanName + " " + freqValue.Little + "--" + freqValue.Great + "MHz";
FreqNavBar fnb = new FreqNavBar();
//fnb.FreqStart = (freqValue.Little / 1000000).ToString();
//fnb.FreqStop = (freqValue.Great / 1000000).ToString();
fnb.FreqStart = (freqValue.Little).ToString();
fnb.FreqStop = (freqValue.Great).ToString();
fnb.reAnalysisFreqRange.Click += new RoutedEventHandler(FreqNavBarButtonClick);
//fnb.BandWidth = (Convert.ToDouble(fps.FreqBand.Split('/')[0]) / 1000).ToString();
fnb.BandWidth = (Convert.ToDouble(fps.FreqBand)).ToString();
fnb.FreqGuid = fps.FreqId;
nbg.Items.Add(fnb);
nbg.Click += new EventHandler(NavBarGroup_Click);
nbg.IsExpanded = false;
navBar.Groups.Add(nbg);
}
}
else
{
MessageBox.Show("该活动区域没有频率规划！");
}
}
private void OnResetCommandExecuted()
{
SQLiteDataService.InitializeDatabase();
LoadAllPosts();
}
/// <summary>
/// Initializes the singleton application object. This is the first line of authored code
/// executed, and as such is the logical equivalent of main() or WinMain().
/// </summary>
public App()
{
this.InitializeComponent();
this.Suspending += OnSuspending;
SQLiteDataService.InitializeDatabase();
}
/// <summary>
/// 上传发射信息
/// </summary>
private void UpLoadEmitInfo()
{
List <StationEmitInfo> emitInfoList = SQLiteDataService.QueryEmitInfo(SystemLoginService.CurrentActivity.Guid, SystemLoginService.CurrentActivityPlace.Guid);
SaveEmitInfoToOracle(emitInfoList);
}
/// <summary>
/// 上传分析结果
/// </summary>
private void UpLoadAnalysisResult()
{
List <AnalysisResult> analysisList = SQLiteDataService.QueryAnalysisResult(SystemLoginService.CurrentActivityPlace.Guid);
SaveAnalysisToOracle(analysisList);
}
private void Init()
{
if (_isLoadUserInfo)
{
AsyncBatchOperationInvoker invoker = new AsyncBatchOperationInvoker(result =>
{
gridLogin.Visibility = System.Windows.Visibility.Collapsed;
if (!result.IsValid)
{
StringBuilder builder = new StringBuilder();
builder.AppendLine("加载启动信息出错,程序将自动关闭");
builder.AppendLine("错误信息:");
builder.AppendLine(result.Exception.GetExceptionMessage());
MessageBox.Show(this, builder.ToString());
App.Current.Shutdown();
}
},
hintInfo =>
{
this.textBlockHint.Text = hintInfo;
},
System.Threading.SynchronizationContext.Current);
#region 读取用户权限
invoker.Add <ISubsystem, StringList>(channel =>
{
return(channel.GetUsableAuthoritiesBySubsystemID(RiasPortal.Current.UserSetting.UserID, CO_IA.Public.SubSystemIDs.Rias));
},
result =>
{
if (result.IsValid)
{
var activities = result.Result;
RiasPortal.Current.UserSetting.UserRights = result.Result.ToArray();
}
}, "正在加载用户权限");
#endregion
#region 加载地图地址
invoker.Add <I_CO_IA.Setting.I_CO_IA_Setting, MapConfig>(channel =>
{
return(channel.GetMapConig());
},
result =>
{
if (result.IsValid)
{
RiasPortal.Current.MapConfig.ElectricUrl = result.Result.ElectricUrl;
RiasPortal.Current.MapConfig.SatelliteUrl = result.Result.SatelliteUrl;
RiasPortal.RegisterSessionParam(RiasPortal.MapDefaultArea, result.Result.DefaultGeoRange);
}
}, "读取地图配置信息");
#endregion
invoker.Invoke();
}
#region 加载活动列表
//List<Activity> activities2=null;
//if (this._isLoadUserInfo)
//{
// PT_BS_Service.Client.Framework.BeOperationInvoker.Invoke<I_CO_IA.ActivityManage.I_CO_IA_ActivityManage>(channel =>
// {
// activities2 = channel.GetActivities().ToList();
// });
//}
//else
//{
List <Activity> activities2 = SQLiteDataService.QueryActivitiesFromLocal();
//}
if (gridLogin.Visibility == System.Windows.Visibility.Visible)
{
gridLogin.Visibility = System.Windows.Visibility.Collapsed;
}
this.dicLocalActivity.Clear();
foreach (var activity in activities2)
{
this.dicLocalActivity[activity.Guid] = activity;
ListBoxImageItem item = new ListBoxImageItem();
item.DataContext = activity;
item.ToolTip = activity.Name;
if (activity.Icon != null && activity.Icon.Length > 100)
{
MemoryStream ms = new MemoryStream(activity.Icon);
BitmapImage bitmapImage = new BitmapImage();
bitmapImage.BeginInit();
bitmapImage.StreamSource = ms;
bitmapImage.EndInit();
item.ImageSource = bitmapImage;
}
else
{
item.ImageSource = new BitmapImage(new Uri(@"/CO_IA.MonitoringCollecting;component/Images/defaultActivity.png", UriKind.RelativeOrAbsolute));
}
item.Header = activity.Name;
//item.HorizontalContentAlignment = System.Windows.HorizontalAlignment.Left;
this.listBoxActivities.Items.Add(item);
}
#endregion
}
public void updateStudent(object parameter)
{
WriteLog("进行了修改操作");
List <User> list = new List <User>();
SQLiteDataService ds = new SQLiteDataService();
list.Add(new User()
{
ID = ID, Name = Name, Age = Age, Sex = Sex, Remarks = Remarks
});
if (Name.Length > 18)
{
MessageBox.Show("姓名过长！");
return;
}
if (Age > 100 || Age < 0)
{
MessageBox.Show("年龄输入有误！");
return;
}
if (Sex.Length == 0)
{
MessageBox.Show("请选择性别");
return;
}
if (Remarks.Length > 3)
{
MessageBox.Show("备注过长！");
return;
}
if (list[0].Name == null)
{
MessageBox.Show("姓名不能为空");
return;
}
Regex reg = new Regex(@"[^0-9]"); // 排除型字符组(取反思想)
if (!reg.IsMatch(list[0].Name))
{
MessageBox.Show("请输入正确姓名");
return;
}
if (list[0].Age <= 0 || list[0].Age >= 150 || list[0].Age.GetType() == list[0].Name.GetType())
{
MessageBox.Show("请输入正确年龄");
return;
}
ds.UpdateUser(list);
MessageBox.Show("修改成功");
UpdateUserWindow win = (UpdateUserWindow)parameter;
if (win != null)
{
win.Close();
}
}
/// <summary>
/// 电磁信号与台站信息比对
/// </summary>
/// <param name="dicOccupy"></param>
private void compareStationInfoForAll(List <AnalysisResult> dicOccupy, FreqNavBar navBar)
{
List <ActivitySurroundStation> stationBaseList = SQLiteDataService.QueryStatBaseByPlaceID(LoginService.CurrentActivityPlace.Guid); //modify by michael 17.07.20
ObservableCollection <AnalysisResult> freqList = new ObservableCollection <AnalysisResult>();
Dictionary <string, ActivitySurroundStation> stationDic = new Dictionary <string, ActivitySurroundStation>();
int occuDegreeLimit = Convert.ToInt16(navBar.OccuDegreeLimit);
int signalLimit = Convert.ToInt16(navBar.SignalLimit);
foreach (AnalysisResult kv in dicOccupy)
{
AnalysisResult analysisResult = new AnalysisResult();
analysisResult.Id = Guid.NewGuid().ToString();
analysisResult.Frequency = Convert.ToDouble(kv.Frequency.ToString("0.0000"));
//analysisResult.BandWidth = this.bandWidth;
analysisResult.BandWidth = Double.Parse(navBar.BandWidth);;
analysisResult.AnalysisBandWidth = Double.Parse(navBar.BandWidth);;
analysisResult.AmplitudeMidValue = kv.AmplitudeMidValue;
analysisResult.AmplitudeMaxValue = kv.AmplitudeMaxValue;
analysisResult.Occupy = Convert.ToInt32(kv.Occupy);
List <StationEmitInfo> tempList = new List <StationEmitInfo>();
foreach (ActivitySurroundStation sbe in stationBaseList)
{
tempList = sbe.EmitInfo.Where(x => (x.FreqEC - x.FreqBand / 1000) <= kv.Frequency && (x.FreqEC + x.FreqBand / 1000) >= kv.Frequency).ToList();
if (tempList.Count() > 0)
{
//analysisResult.FreqType = SignalTypeEnum.已占;
analysisResult.StationName = sbe.STAT_NAME;
analysisResult.StationGuid = sbe.STATGUID;
analysisResult.NeedClear = (int)sbe.EmitInfo[0].NeedClear;
analysisResult.FreqGuid = sbe.EmitInfo[0].Guid;
analysisResult.ClearResult = (int)sbe.EmitInfo[0].ClearResult;
if (!stationDic.Keys.Contains(sbe.STATGUID))
{
stationDic.Add(sbe.STATGUID, sbe);
}
break;
}
else
{
//analysisResult.FreqType = SignalTypeEnum.空闲;
}
}
if (analysisResult.Occupy >= occuDegreeLimit && analysisResult.AmplitudeMaxValue > signalLimit)
{
analysisResult.FreqType = SignalTypeEnum.已占;
}
else
{
analysisResult.FreqType = SignalTypeEnum.空闲;
}
analysisResult.MeasureId = MeasureId;
analysisResult.StartFreq = Convert.ToDouble(navBar.FreqStart);
analysisResult.EndFreq = Convert.ToDouble(navBar.FreqStop);
analysisResult.FreqGuid = navBar.FreqGuid;
freqList.Add(analysisResult);
}
foreach (ActivitySurroundStation sbe in stationBaseList)
{
if (stationDic.Keys.Contains(sbe.STATGUID))
{
continue;
}
else
{
if (sbe.EmitInfo != null && sbe.EmitInfo.Count > 0)
{
AnalysisResult analysisResult = new AnalysisResult();
analysisResult.Id = Guid.NewGuid().ToString();
analysisResult.Frequency = Convert.ToDouble(sbe.EmitInfo[0].FreqEC.ToString());
//analysisResult.BandWidth = Convert.ToDouble((sbe.EmitInfo[0].FreqBand * 1000).ToString());
analysisResult.BandWidth = Convert.ToDouble((sbe.EmitInfo[0].FreqBand).ToString());
analysisResult.FreqGuid = sbe.EmitInfo[0].Guid;
analysisResult.NeedClear = (int)sbe.EmitInfo[0].NeedClear;
analysisResult.ClearResult = (int)sbe.EmitInfo[0].ClearResult;
analysisResult.StationName = sbe.STAT_NAME;
analysisResult.StationGuid = sbe.STATGUID;
analysisResult.FreqType = SignalTypeEnum.已占;
analysisResult.MeasureId = MeasureId;
analysisResult.AnalysisBandWidth = Double.Parse(navBar.BandWidth);
analysisResult.StartFreq = Convert.ToDouble(navBar.FreqStart);
analysisResult.EndFreq = Convert.ToDouble(navBar.FreqStop);
analysisResult.FreqGuid = navBar.FreqGuid;
freqList.Add(analysisResult);
}
}
}
if (freqList.Count == 0)
{
initdata(freqList);
}
navBar.MeasureId = MeasureId;
navBar.freqList = freqList;
}
private static void InitializeData()
{
var db = new SQLiteDataService();
bool addData = db.Initialize();
if (addData)
{
var user = new User {
Username = "******", Password = "******", CreatedBy = "tester", CreatedDate = DateTime.Now
};
db.AddUser(user);
var flour = new Ingredient {
Title = "Flour", MeasureType = "Volume", CreatedBy = "test", CreatedDate = DateTime.Now
};
var bakingPowder = new Ingredient {
Title = "Baking Powder", MeasureType = "Volume", CreatedBy = "test", CreatedDate = DateTime.Now
};
var salt = new Ingredient {
Title = "Salt", MeasureType = "Volume", CreatedBy = "test", CreatedDate = DateTime.Now
};
var butter = new Ingredient {
Title = "Butter", MeasureType = "Volume", CreatedBy = "test", CreatedDate = DateTime.Now
};
var milk = new Ingredient {
Title = "Milk", MeasureType = "Volume", CreatedBy = "test", CreatedDate = DateTime.Now
};
db.AddIngredient(flour);
db.AddIngredient(bakingPowder);
db.AddIngredient(salt);
db.AddIngredient(butter);
db.AddIngredient(milk);
var recipe = new WebRecipe
{
Url = "https://www.food.com/recipe/biscuit-crust-17853",
Title = "Biscuit Crust",
Category = "Bread & Pizza",
Instructions = "In a medium bowl whisk together flour, salt and baking powder.\r\nCut in the butter to resemble coarse cornmeal.\r\nAdd the milk and quickly stir to gather dough into a ball.\r\nGently, on a lightly floured board roll out to fit the pie plate or top of a deep dish pie.\r\n* *Ifyou need this partially baked roll the biscuit dough 1 / 4 inch thick, place lined pie plate / dish in a 350 degree oven for 10 minutes, fill and continue recipe for pie.",
CreatedBy = "test",
CreatedDate = DateTime.Now,
UserId = user.Id
};
db.AddRecipe(recipe);
var ingredientByRecipe1 = new IngredientByRecipe {
IngredientId = flour.Id, MeasureAmount = Convert.ToDecimal(1), MeasureUnit = "cup", RecipeId = recipe.Id, CreatedDate = DateTime.Now, CreatedBy = "test"
};
var ingredientByRecipe2 = new IngredientByRecipe {
IngredientId = bakingPowder.Id, MeasureAmount = Convert.ToDecimal(2), MeasureUnit = "tsp", RecipeId = recipe.Id, CreatedDate = DateTime.Now, CreatedBy = "test"
};
var ingredientByRecipe3 = new IngredientByRecipe {
IngredientId = salt.Id, MeasureAmount = Convert.ToDecimal(0.5), MeasureUnit = "tsp", RecipeId = recipe.Id, CreatedDate = DateTime.Now, CreatedBy = "test"
};
var ingredientByRecipe4 = new IngredientByRecipe {
IngredientId = butter.Id, MeasureAmount = Convert.ToDecimal(0.25), MeasureUnit = "cup", RecipeId = recipe.Id, CreatedDate = DateTime.Now, CreatedBy = "test"
};
var ingredientByRecipe5 = new IngredientByRecipe {
IngredientId = milk.Id, MeasureAmount = Convert.ToDecimal(0.25), MeasureUnit = "cup", RecipeId = recipe.Id, CreatedDate = DateTime.Now, CreatedBy = "test"
};
db.AddIngredientByRecipe(ingredientByRecipe1);
db.AddIngredientByRecipe(ingredientByRecipe2);
db.AddIngredientByRecipe(ingredientByRecipe3);
db.AddIngredientByRecipe(ingredientByRecipe4);
db.AddIngredientByRecipe(ingredientByRecipe5);
var meal1 = new Meal {
Title = "Sample Meal1", Type = "Special Occasion", Notes = "Sample Notes", Date = DateTime.Now, UserId = user.Id, CreatedBy = "test", CreatedDate = DateTime.Now
};
var meal2 = new Meal {
Title = "Sample Meal2", Type = "Lunch", Notes = "Sample Notes", Date = DateTime.Now.AddDays(1), UserId = user.Id, CreatedBy = "test", CreatedDate = DateTime.Now
};
db.AddMeal(meal1);
db.AddMeal(meal2);
var recipeByMeal1 = new RecipeByMeal {
MealId = meal1.Id, RecipeId = recipe.Id, CreatedDate = DateTime.Now, CreatedBy = "test"
};
var recipeByMeal2 = new RecipeByMeal {
MealId = meal2.Id, RecipeId = recipe.Id, CreatedDate = DateTime.Now, CreatedBy = "test"
};
db.AddRecipeByMeal(recipeByMeal1);
db.AddRecipeByMeal(recipeByMeal2);
}
db.Close();
}
