async Task AddMagneticCardNormalGroup()
{
db = slSecure.DB.GetDB();
//非同步模擬成同步
var q = await db.LoadAsync<tblMagneticCardNormalGroup>(from b in db.GetTblMagneticCardNormalGroupQuery() select b);
tblMagneticCardNormalGroup bc = q.Last();
db.tblMagneticCardNormalGroups.Add(
new tblMagneticCardNormalGroup()
{
//NormalID = bc.NormalID + 1,
NormalName = txt_NormalName.Text,
UpdateDate = DateTime.Now,
Memo = tb_Memo.Text
}
);
try
{
bool res = await db.SubmitChangesAsync();
MessageBox.Show("新增定期卡群組成功!");
}
catch (Exception ex)
{
MessageBox.Show("Adding Data failed due to " + ex.Message);
}
}
async void treeView_New()
{
slSecure.Web.SecureDBContext db;
db = slSecure.DB.GetDB();
TreeViewItem tvItem;
var ERNameData = await db.LoadAsync<tblEngineRoomConfig>(db.GetTblEngineRoomConfigQuery());
string sERName, sReadCardName, sControlID;
foreach (var tempERNameData in ERNameData)
{
sERName = tempERNameData.ERName;
tvItem = new TreeViewItem();
tvItem.Header = sERName;
foreach (var tempEntranceGuardData in tempERNameData.tblEntranceGuardConfig)
{
foreach (var tempControllerConfigData in tempERNameData.tblControllerConfig)
{
if (tempControllerConfigData.EntranceCode == tempEntranceGuardData.EntranceCode && (tempControllerConfigData.ControlType == 1 || tempControllerConfigData.ControlType == 2))
{
sControlID = tempControllerConfigData.ControlID;
sReadCardName = tempEntranceGuardData.Memo;
RadioButton ck1 = new RadioButton() { Content = sReadCardName, Tag = sControlID, GroupName = "Door" };
tvItem.Items.Add(ck1);
tvItem.Tag = sControlID;
}
}
}
tv_TreeView_New.Items.Add(tvItem);
}
}
async void QueryMagneticCardNormalGroup()
{
db = slSecure.DB.GetDB();
//非同步模擬成同步
var q = await db.LoadAsync<tblMagneticCardNormalGroup>(db.GetTblMagneticCardNormalGroupQuery());
dataGrid.ItemsSource = q;
NewMagneticCardNormalGroup();
}
async Task ModifyMagneticCardNormalGroup()
{
db = slSecure.DB.GetDB();
var normalID = int.Parse(txt_NormalID.Text);
//非同步模擬成同步
var q = await db.LoadAsync<tblMagneticCardNormalGroup>(from b in db.GetTblMagneticCardNormalGroupQuery() where b.NormalID == normalID select b);
tblMagneticCardNormalGroup bc = q.First();
bc.NormalName = txt_NormalName.Text;
bc.UpdateDate = DateTime.Now;
bc.Memo = tb_Memo.Text;
try
{
bool res = await db.SubmitChangesAsync();
MessageBox.Show("修改定期卡群組成功!");
}
catch (Exception ex)
{
MessageBox.Show("Data updation failed due to " + ex.Message);
}
}
async Task DeleteMagneticCardNormalGroup()
{
db = slSecure.DB.GetDB();
var normalID = int.Parse(txt_NormalID.Text);
//非同步模擬成同步
var q = await db.LoadAsync<tblMagneticCardNormalGroup>(from b in db.GetTblMagneticCardNormalGroupQuery() where b.NormalID == normalID select b);
tblMagneticCardNormalGroup bc = q.First();
db.tblMagneticCardNormalGroups.Remove(bc);
try
{
bool res = await db.SubmitChangesAsync();
MessageBox.Show("刪除定期卡群組成功!");
}
catch (Exception ex)
{
MessageBox.Show("Data deletion failed due to " + ex.Message);
}
}
// 使用者巡覽至這個頁面時執行。
protected async override void OnNavigatedTo(NavigationEventArgs e)
{
db = new slSecure.Web.SecureDBContext();
var q = from n in db.GetTblEngineRoomConfigQuery() select n;
var res=await db.LoadAsync<slSecure.Web.tblEngineRoomConfig>(q );
roomInfos = (from n in res
select new ControlRoomInfo()
{
ERID=n.ERID,
Type = "C",
AlarmStatus = 0,
Name = n.ERName,
X = n.GPSX,
Y = n.GPSY
}).ToArray();
foreach (ControlRoomInfo info in roomInfos)
{
mapctl.AddControllRoomPin(info);
}
//var q1 = from n in db.GetTblERPlaneQuery() select n;
//var res1= await db.LoadAsync<tblERPlane>(q1);
//planeInfos = (from n in res1
// select new PlaneInfo()
// {
// ERID=n.ERID,
// AlarmStatus=0,
// Name=n.PlaneName,
// PlaneID=n.PlaneID,
// Type="EP"
// }).ToArray();
client = new MyClient("CustomBinding_ISecureService", false);
client.SecureService.GetAllPlaneInfoCompleted += (s, a) =>
{
if (a.Error != null)
return;
lstMenu.ItemsSource = PlaneDegreeInfos=a.Result;
if (roomInfos != null)
foreach (ControlRoomInfo info in roomInfos)
{
try
{
info.AlarmStatus = PlaneDegreeInfos.Where(n => n.ERID == info.ERID).Max(n => n.AlarmStatus);
}
catch { ;}
}
};
if (!IsExit)
{
client.SecureService.GetAllPlaneInfoAsync();
tmr.Interval = TimeSpan.FromSeconds(10);
tmr.Tick += tmr_Tick;
tmr.Start();
}
// client.OnItemValueChangedEvent += client_OnItemValueChangedEvent;
}
protected async override void OnNavigatedTo(NavigationEventArgs e)
{
client = new MyClient("CustomBinding_ISecureService", false);
db = new SecureDBContext();
this.PlaneID = int.Parse(this.NavigationContext.QueryString["PlaneID"]);
this.image.Source = new BitmapImage(new Uri("/Diagrams/" + PlaneID + ".png", UriKind.Relative));
#if !R23
#endif
if (!IsExit)
await GetALLDoorBindingData(PlaneID);
if (!IsExit)
await GetALLCCTVBindingData(PlaneID);
if (!IsExit)
await GetAllItemBindingData(PlaneID);
if (!IsExit)
await GetAllItemGroupBindingData(PlaneID);
#if !R23
#endif
PlaceDoor();
PlaceCCTV();
PlaceItem();
PlaceItemGroup();
var erplanes= await db.LoadAsync<tblERPlane>(db.GetTblERPlaneQuery().Where(n=>n.PlaneID==this.PlaneID));
this.tblPlane= erplanes.FirstOrDefault();
this.DataContext = tblPlane;
// tblPlane.PlaneName
client.OnRegistEvent += async (s) =>
{
if (!IsExit)
await HookDoorEvent(PlaneID);
if (!IsExit)
await HookItemValueChangeEvent(PlaneID);
};
client.OnDoorEvent += client_OnDoorEvent;
client.OnItemValueChangedEvent += client_OnItemValueChangedEvent;
if (!IsExit)
await client.RegistAndGetKey();
}