public DeviceConfigUserControl1(ChungHsin_Field4UserControl UserControl, Form1 form1, ChungHsin_MySqlMethod chungHsin_MySqlMethod)
{
InitializeComponent();
caseUserControl = UserControl;
Form1 = form1;
ChungHsin_MySqlMethod = chungHsin_MySqlMethod;
}
public CH_CaseSettingUserControl1(ChungHsin_Field4UserControl CaseUserControl, Form1 form1, ChungHsin_MySqlMethod chungHsin_MySqlMethod)
{
InitializeComponent();
caseUserControl = CaseUserControl;
Form1 = form1;
ChungHsin_MySqlMethod = chungHsin_MySqlMethod;
}
private void ChangesimpleButton_Click(object sender, EventArgs e)
{
DeviceConfig deviceConfig = new DeviceConfig()
{
DeviceTypeEnum = Convert.ToInt32(DeviceTypeEnumtextEdit.Text),
DeviceName = DeviceNametextEdit.Text
};
ChungHsin_MySqlMethod.Update_DeviceConfig(deviceConfig);
Search_Setting();
}
private void SavesimpleButton_Click(object sender, EventArgs e)
{
DeviceConfig deviceConfig = new DeviceConfig()
{
DeviceTypeEnum = Convert.ToInt32(DeviceTypeEnumtextEdit.Text),
DeviceName = DeviceNametextEdit.Text
};
ChungHsin_MySqlMethod.Insert_DeviceConfig(deviceConfig);
caseUserControl.Search_Setting();
caseUserControl.FlyoutFlag = false;
caseUserControl.flyout.Close();
}
private void SavesimpleButton_Click(object sender, EventArgs e)
{
ReceiveSetting receiveSetting = new ReceiveSetting()
{
CaseNo = CaseNotextEdit.Text,
DeviceTypeEnum = DeviceTypeEnumcomboBoxEdit.SelectedIndex,
ReceiveNo = Convert.ToInt32(ReceiveNotextEdit.Text),
ReceiveName = ReceiveNametextEdit.Text,
NotifyFlag = NotifyFlagtoggleSwitch.IsOn,
HTimeoutSpan = Convert.ToInt32(TimeoutSpantextEdit.Text),
MTimeoutSpan = Convert.ToInt32(MTimeoutSpantextEdit.Text)
};
ChungHsin_MySqlMethod.Insert_ReceiveSettig(receiveSetting);
var aiconfig = ChungHsin_MySqlMethod.AiConfigLoad(receiveSetting.DeviceTypeEnum);
var stateconfig = ChungHsin_MySqlMethod.StateConfigLoad(receiveSetting.DeviceTypeEnum);
List <AiSetting> aiSettings = new List <AiSetting>();
List <StateSetting> stateSettings = new List <StateSetting>();
if (aiconfig != null)
{
foreach (var item in aiconfig)
{
AiSetting setting = new AiSetting()
{
CaseNo = receiveSetting.CaseNo,
ReceiveNo = receiveSetting.ReceiveNo,
AINo = item.AINo,
};
aiSettings.Add(setting);
}
ChungHsin_MySqlMethod.Insert_AiSetting(aiSettings);
}
if (stateconfig != null)
{
foreach (var item in stateconfig)
{
StateSetting setting = new StateSetting()
{
CaseNo = receiveSetting.CaseNo,
ReceiveNo = receiveSetting.ReceiveNo,
StateNo = item.StateNo
};
stateSettings.Add(setting);
}
ChungHsin_MySqlMethod.Insert_StateSetting(stateSettings);
}
caseUserControl.Search_Setting();
caseUserControl.FlyoutFlag = false;
caseUserControl.flyout.Close();
}
public ReceiveSettingUserControl1(ChungHsin_Field4UserControl CaseUserControl, Form1 form1, ChungHsin_MySqlMethod chungHsin_MySqlMethod)
{
InitializeComponent();
caseUserControl = CaseUserControl;
Form1 = form1;
ChungHsin_MySqlMethod = chungHsin_MySqlMethod;
var DeviceSetting = ChungHsin_MySqlMethod.DevicesLoad();
foreach (var item in DeviceSetting)
{
DeviceTypeEnumcomboBoxEdit.Properties.Items.Add(item.DeviceName);
}
DeviceTypeEnumcomboBoxEdit.SelectedIndex = 0;
}
private void ChangesimpleButton_Click(object sender, EventArgs e)
{
ReceiveSetting receiveSetting = new ReceiveSetting()
{
CaseNo = CaseNotextEdit.Text,
DeviceTypeEnum = Convert.ToInt32(DeviceTypeEnumcomboBoxEdit.SelectedIndex),
ReceiveNo = Convert.ToInt32(ReceiveNotextEdit.Text),
ReceiveName = ReceiveNametextEdit.Text,
NotifyFlag = NotifyFlagtoggleSwitch.IsOn,
HTimeoutSpan = Convert.ToInt32(TimeoutSpantextEdit.Text),
MTimeoutSpan = Convert.ToInt32(MTimeoutSpantextEdit.Text)
};
ChungHsin_MySqlMethod.Updata_ReceiveSetting(receiveSetting);
Search_Setting();
}
protected override void AfterMyWorkStateChanged(object sender, EventArgs e)
{
if (myWorkState)
{
CaseSettings = ChungHsin_MySqlMethod.CaseLoad();
ReceiveSettings = ChungHsin_MySqlMethod.ReceiveLoad();
DeviceConfigs = ChungHsin_MySqlMethod.DevicesLoad();
ConnectionThread = new Thread(Connection_Mysql);
ConnectionThread.Start();
}
else
{
if (ConnectionThread != null)
{
ConnectionThread.Abort();
}
}
}
private void ChangesimpleButton_Click(object sender, EventArgs e)
{
CaseSetting caseSetting = new CaseSetting()
{
CaseNo = CaseNotextEdit.Text,
Address = AddresstextEdit.Text,
Contacter = ContactertextEdit.Text,
Phone = PhonetextEdit.Text,
TitleName = TitleNametextEdit.Text,
NotifyTypeEnum = NotifyTypeEnumcomboBoxEdit.SelectedIndex,
NotifyApi = NotifyApitextEdit.Text,
NotifyToken = NotifyTokentextEdit.Text,
Longitude = Convert.ToSingle(LongitudetextEdit.Text),
Latitude = Convert.ToSingle(LatitudetextEdit.Text)
};
ChungHsin_MySqlMethod.Update_CaseSetting(caseSetting);
Search_Setting();
}
private void SavesimpleButton_Click(object sender, EventArgs e)
{
CaseSetting caseSetting = new CaseSetting()
{
CaseNo = CaseNotextEdit.Text,
Address = AddresstextEdit.Text,
Contacter = ContactertextEdit.Text,
Phone = PhonetextEdit.Text,
TitleName = TitleNametextEdit.Text,
NotifyTypeEnum = NotifyTypeEnumcomboBoxEdit.SelectedIndex,
NotifyApi = NotifyApitextEdit.Text,
NotifyToken = NotifyTokentextEdit.Text,
Longitude = Convert.ToSingle(LongitudetextEdit.Text),
Latitude = Convert.ToSingle(LatitudetextEdit.Text)
};
ChungHsin_MySqlMethod.Insert_CaseSetting(caseSetting);
caseUserControl.Search_Setting();
caseUserControl.FlyoutFlag = false;
caseUserControl.flyout.Close();
}
private void Connection_Mysql()
{
while (myWorkState)
{
TimeSpan timeSpan = DateTime.Now.Subtract(ConnectionTime);
if (timeSpan.TotalMilliseconds > 5000)
{
var NewCaseSettings = ChungHsin_MySqlMethod.CaseLoad();
var NewReceiveSettings = ChungHsin_MySqlMethod.ReceiveLoad();
var NewDeviceConfigs = ChungHsin_MySqlMethod.DevicesLoad();
foreach (var Caseitem in NewCaseSettings)
{
#region 接收
var ReceiveValue = ChungHsin_MySqlMethod.ReceiveLoad(Caseitem);
foreach (var Receiveitem in ReceiveValue)
{
if (Receiveitem.NotifyFlag)
{
if (ChungHsin_MySqlMethod.AI64Load(Receiveitem))
{
var TimeValue = ChungHsin_MySqlMethod.Receive_Time(Receiveitem);
if (TimeValue == null || TimeValue >= Receiveitem.HTimeoutSpan)
{
if (NewReceiveSettings.SingleOrDefault(g => g.PK == Receiveitem.PK) != null)
{
NewReceiveSettings.Single(g => g.PK == Receiveitem.PK).ConnectionFlag = "斷線";
NotifyTypeEnum notifyTypeEnum = (NotifyTypeEnum)Caseitem.NotifyTypeEnum;
switch (notifyTypeEnum)
{
case NotifyTypeEnum.None:
break;
case NotifyTypeEnum.Line:
{
LineNotifyClass lineNotifyClass = new LineNotifyClass();
lineNotifyClass.LineNotifyFunction(Caseitem.NotifyToken, $"設備名稱:{Receiveitem.ReceiveName} \r最後上傳時間 : {ChungHsin_MySqlMethod.AI_LastTime(Receiveitem)}\r上傳逾時請檢查");
}
break;
case NotifyTypeEnum.Telegram:
{
TelegramBotClass telegramBotClass = new TelegramBotClass(Caseitem.NotifyApi)
{
Chat_ID = Caseitem.NotifyToken
};
telegramBotClass.Send_Message_Group($"設備名稱:{Receiveitem.ReceiveName} \r最後上傳時間 : {ChungHsin_MySqlMethod.AI_LastTime(Receiveitem)}\r上傳逾時請檢查");
}
break;
}
ChungHsin_MySqlMethod.UpdataReceive_Time(Receiveitem, true);
}
}
else
{
NewReceiveSettings.Single(g => g.PK == Receiveitem.PK).ConnectionFlag = "斷線";
}
}
else
{
if (NewReceiveSettings.SingleOrDefault(g => g.PK == Receiveitem.PK) != null)
{
NewReceiveSettings.Single(g => g.PK == Receiveitem.PK).ConnectionFlag = "連線";
ChungHsin_MySqlMethod.UpdataReceive_Time(Receiveitem, false);
}
}
}
else
{
if (ChungHsin_MySqlMethod.AI64Load(Receiveitem))
{
if (NewReceiveSettings.SingleOrDefault(g => g.PK == Receiveitem.PK) != null)
{
NewReceiveSettings.Single(g => g.PK == Receiveitem.PK).ConnectionFlag = "斷線";
//ChungHsin_MySqlMethod.UpdataReceive_Time(Receiveitem, true);
}
}
else
{
if (NewReceiveSettings.SingleOrDefault(g => g.PK == Receiveitem.PK) != null)
{
NewReceiveSettings.Single(g => g.PK == Receiveitem.PK).ConnectionFlag = "連線";
ChungHsin_MySqlMethod.UpdataReceive_Time(Receiveitem, false);
}
}
}
}
#endregion
}
CaseSettings = NewCaseSettings;
ReceiveSettings = NewReceiveSettings;
DeviceConfigs = NewDeviceConfigs;
ConnectionTime = DateTime.Now;
}
else
{
Thread.Sleep(80);
}
}
}
public ChungHsin_MySqlComponent(ChungHsin_MySqlMethod chungHsin_MySqlMethod)
{
InitializeComponent();
ChungHsin_MySqlMethod = chungHsin_MySqlMethod;
}
public Form1()
{
Log.Logger = new LoggerConfiguration()
.WriteTo.Console()
.WriteTo.File($"{AppDomain.CurrentDomain.BaseDirectory}\\log\\log-.txt",
rollingInterval: RollingInterval.Day,
outputTemplate: "{Timestamp:yyyy-MM-dd HH:mm:ss.fff zzz} [{Level:u3}] {Message:lj}{NewLine}{Exception}")
.CreateLogger(); //宣告Serilog初始化
MySqlSetting = InitialMethod.MySqlLoad();
ButtonSetting = InitialMethod.InitialButtonLoad();
InitializeComponent();
NavigationFrame = new NavigationFrame()
{
Dock = DockStyle.Fill
};
NavigationFrame.Parent = DisPlaypanelControl;
ButtonMethod = new ButtonMethod()
{
Form1 = this, navigationFrame = NavigationFrame
};
ButtonMethod.AccordionLoad(accordionControl1, ButtonSetting);
#region Ewatch平台
Ewatch_MySqlMethod = new Ewatch_MySqlMethod(MySqlSetting);
Ewatch_MySqlComponent = new Ewatch_MySqlComponent(Ewatch_MySqlMethod);
Ewatch_MySqlComponent.MyWorkState = true;
Ewatch_Field4Component.Add(Ewatch_MySqlComponent);
Ewatch_AlarmComponent = new Ewatch_AlarmComponent(Ewatch_MySqlMethod);
Ewatch_AlarmComponent.MyWorkState = true;
Ewatch_Field4Component.Add(Ewatch_AlarmComponent);
EwatchConnectionUserControl ewatchConnectionUserControl = new EwatchConnectionUserControl(Ewatch_MySqlComponent)
{
Dock = DockStyle.Fill
};
NavigationFrame.AddPage(ewatchConnectionUserControl);
Ewatch_Field4UserControl.Add(ewatchConnectionUserControl);
CaseUserControl caseUserControl = new CaseUserControl(Ewatch_MySqlMethod)
{
Form1 = this, Dock = DockStyle.Fill
};
NavigationFrame.AddPage(caseUserControl);
Ewatch_Field4UserControl.Add(caseUserControl);
AiSettingUserControl aiSettingUserControl = new AiSettingUserControl(Ewatch_MySqlMethod)
{
Form1 = this, Dock = DockStyle.Fill
};
NavigationFrame.AddPage(aiSettingUserControl);
Ewatch_Field4UserControl.Add(aiSettingUserControl);
AiConfigUserControl aiConfigUserControl = new AiConfigUserControl(Ewatch_MySqlMethod)
{
Form1 = this, Dock = DockStyle.Fill
};
NavigationFrame.AddPage(aiConfigUserControl);
Ewatch_Field4UserControl.Add(aiConfigUserControl);
ElectricSettingUserControl electricSettingUserControl = new ElectricSettingUserControl(Ewatch_MySqlMethod)
{
Form1 = this, Dock = DockStyle.Fill
};
NavigationFrame.AddPage(electricSettingUserControl);
Ewatch_Field4UserControl.Add(electricSettingUserControl);
StateSettingUserControl stateSettingUserControl = new StateSettingUserControl(Ewatch_MySqlMethod)
{
Form1 = this, Dock = DockStyle.Fill
};
NavigationFrame.AddPage(stateSettingUserControl);
Ewatch_Field4UserControl.Add(stateSettingUserControl);
#endregion
#region ChungHsin平台
ChungHsin_MySqlMethod = new ChungHsin_MySqlMethod(MySqlSetting);
ChungHsin_MySqlComponent = new ChungHsin_MySqlComponent(ChungHsin_MySqlMethod);
ChungHsin_MySqlComponent.MyWorkState = true;
ChungHsin_Field4Component.Add(ChungHsin_MySqlComponent);
ChumgHsinConnectionUserControl chumgHsinConnectionUserControl = new ChumgHsinConnectionUserControl(ChungHsin_MySqlComponent)
{
Dock = DockStyle.Fill
};
NavigationFrame.AddPage(chumgHsinConnectionUserControl);
ChungHsin_Field4UserControl.Add(chumgHsinConnectionUserControl);
DeviceConfigUserControl deviceConfigUserControl = new DeviceConfigUserControl(ChungHsin_MySqlMethod)
{
Dock = DockStyle.Fill
};
NavigationFrame.AddPage(deviceConfigUserControl);
ChungHsin_Field4UserControl.Add(deviceConfigUserControl);
CH_CaseSettingUserControl cH_CaseSettingUserControl = new CH_CaseSettingUserControl(ChungHsin_MySqlMethod)
{
Dock = DockStyle.Fill
};
NavigationFrame.AddPage(cH_CaseSettingUserControl);
ChungHsin_Field4UserControl.Add(cH_CaseSettingUserControl);
ReceiveSettingUserControl receiveSettingUserControl = new ReceiveSettingUserControl(ChungHsin_MySqlMethod)
{
Dock = DockStyle.Fill
};
NavigationFrame.AddPage(receiveSettingUserControl);
ChungHsin_Field4UserControl.Add(receiveSettingUserControl);
#endregion
timer1.Interval = 1000;
timer1.Enabled = true;
}
public override void Search_Setting()
{
var DeviceConfig = ChungHsin_MySqlMethod.DevicesLoad();
gridControl1.DataSource = DeviceConfig;
if (!Flag)
{
gridView1.OptionsBehavior.Editable = false;
gridView1.OptionsSelection.EnableAppearanceFocusedCell = false;
for (int i = 0; i < gridView1.Columns.Count; i++)
{
gridView1.Columns[i].BestFit();
}
gridView1.Columns["PK"].Visible = false;
gridView1.Columns["DeviceTypeEnum"].Caption = "設備類型";
gridView1.Columns["DeviceName"].Caption = "設備名稱";
#region 報表行聚焦
gridView1.FocusedRowChanged += (s, ex) =>
{
ColumnView view = (ColumnView)s;
if ((view.FindFilterText == "" || view.ActiveFilterString != "") & !SortGlyphFlag)
{
if (ex.FocusedRowHandle > -1)
{
DeviceTypeEnumtextEdit.Text = view.GetListSourceRowCellValue(ex.FocusedRowHandle, "DeviceTypeEnum").ToString();
DeviceNametextEdit.Text = view.GetListSourceRowCellValue(ex.FocusedRowHandle, "DeviceName").ToString();
}
}
else
{
if (ex.FocusedRowHandle > -1)
{
if (FilterDeviceConfig.Count > 0 && FilterDeviceConfig.Count > ex.FocusedRowHandle)
{
DeviceTypeEnumtextEdit.Text = FilterDeviceConfig[ex.FocusedRowHandle].DeviceName;
DeviceNametextEdit.Text = FilterDeviceConfig[ex.FocusedRowHandle].DeviceTypeEnum.ToString();
}
}
}
};
#endregion
#region 報表行刪除
gridView1.RowDeleting += (s, ex) =>
{
ColumnView view = (ColumnView)s;
int DeviceTypeEnum = Convert.ToInt32(DeviceTypeEnumtextEdit.Text);
ChungHsin_MySqlMethod.Delete_DeviceConfig(DeviceTypeEnum);
};
#endregion
#region 關鍵字搜尋
gridView1.ColumnFilterChanged += (s, e) =>
{
GridView view = s as GridView;
if (view.FindFilterText != "" || view.ActiveFilterString != "")
{
FilterDeviceConfig = new List <DeviceConfig>();
for (int i = 0; i < view.RowCount; i++)
{
if (view.IsGroupRow(i))
{
continue;
}
var entity = view.GetRow(i) as DeviceConfig;
if (entity == null)
{
continue;
}
FilterDeviceConfig.Add(entity);
}
}
if (FilterDeviceConfig.Count > 0)
{
DeviceNametextEdit.Text = FilterDeviceConfig[0].DeviceName;
DeviceTypeEnumtextEdit.Text = FilterDeviceConfig[0].DeviceTypeEnum.ToString();
}
};
#endregion
#region 表頭篩選
gridView1.EndSorting += (s, e) =>
{
GridView view = s as GridView;
FilterDeviceConfig = new List <DeviceConfig>();
for (int i = 0; i < view.RowCount; i++)
{
if (view.IsGroupRow(i))
{
continue;
}
var entity = view.GetRow(i) as DeviceConfig;
if (entity == null)
{
continue;
}
FilterDeviceConfig.Add(entity);
}
SortGlyphFlag = true;
gridView1.FocusedRowHandle = 0;
};
#endregion
gridView1.FocusedRowHandle = 1;
Flag = true;
}
else
{
gridControl1.Refresh();
}
}
public CH_CaseSettingUserControl(ChungHsin_MySqlMethod chungHsin_MySqlMethod)
{
InitializeComponent();
ChungHsin_MySqlMethod = chungHsin_MySqlMethod;
Search_Setting();
}
public override void Search_Setting()
{
var ReceiveSetting = ChungHsin_MySqlMethod.ReceiveLoad();
gridControl1.DataSource = ReceiveSetting;
var DeviceConfig = ChungHsin_MySqlMethod.DevicesLoad();
foreach (var item in DeviceConfig)
{
DeviceTypeEnumcomboBoxEdit.Properties.Items.Add(item.DeviceName);
}
if (!Flag)
{
gridView1.OptionsBehavior.Editable = false;
gridView1.OptionsSelection.EnableAppearanceFocusedCell = false;
for (int i = 0; i < gridView1.Columns.Count; i++)
{
gridView1.Columns[i].BestFit();
}
RepositoryItemToggleSwitch toggleSwitch = new RepositoryItemToggleSwitch();
gridControl1.RepositoryItems.Add(toggleSwitch);
gridView1.Columns["PK"].Visible = false;
gridView1.Columns["NotifyFlag"].ColumnEdit = toggleSwitch;
gridView1.Columns["CaseNo"].Caption = "案場編號";
gridView1.Columns["DeviceTypeEnum"].Caption = "設備類型";
gridView1.Columns["ReceiveNo"].Caption = "接收編號";
gridView1.Columns["ReceiveName"].Caption = "接收名稱";
gridView1.Columns["NotifyFlag"].Caption = "推播功能";
gridView1.Columns["HTimeoutSpan"].Caption = "延遲推播(h)";
gridView1.Columns["MTimeoutSpan"].Caption = "延遲推播(m)";
gridView1.Columns["SendTime"].Visible = false;
gridView1.Columns["ConnectionFlag"].Visible = false;
gridView1.CustomColumnDisplayText += (s, ex) =>
{
if (ex.Column.FieldName == "DeviceTypeEnum")
{
int val = (int)ex.Value;
ex.DisplayText = DeviceConfig.Single(g => g.DeviceTypeEnum == val).DeviceName;
}
};
#region 報表行聚焦
gridView1.FocusedRowChanged += (s, ex) =>
{
ColumnView view = (ColumnView)s;
if ((view.FindFilterText == "" || view.ActiveFilterString != "") & !SortGlyphFlag)
{
if (ex.FocusedRowHandle > -1)
{
CaseNotextEdit.Text = view.GetListSourceRowCellValue(ex.FocusedRowHandle, "CaseNo").ToString();
DeviceTypeEnumcomboBoxEdit.SelectedIndex = Convert.ToInt32(view.GetListSourceRowCellValue(ex.FocusedRowHandle, "DeviceTypeEnum"));
ReceiveNotextEdit.Text = view.GetListSourceRowCellValue(ex.FocusedRowHandle, "ReceiveNo").ToString();
ReceiveNametextEdit.Text = view.GetListSourceRowCellValue(ex.FocusedRowHandle, "ReceiveName").ToString();
NotifyFlagtoggleSwitch.IsOn = Convert.ToBoolean(view.GetListSourceRowCellValue(ex.FocusedRowHandle, "NotifyFlag"));
TimeoutSpantextEdit.Text = view.GetListSourceRowCellValue(ex.FocusedRowHandle, "HTimeoutSpan").ToString();
MTimeoutSpantextEdit.Text = view.GetListSourceRowCellValue(ex.FocusedRowHandle, "MTimeoutSpan").ToString();
}
}
else
{
if (ex.FocusedRowHandle > -1)
{
if (FilterReceiveSetting.Count > 0 && FilterReceiveSetting.Count > ex.FocusedRowHandle)
{
CaseNotextEdit.Text = FilterReceiveSetting[ex.FocusedRowHandle].CaseNo;
DeviceTypeEnumcomboBoxEdit.SelectedIndex = Convert.ToInt32(FilterReceiveSetting[ex.FocusedRowHandle].DeviceTypeEnum);
ReceiveNotextEdit.Text = FilterReceiveSetting[ex.FocusedRowHandle].ReceiveNo.ToString();
ReceiveNametextEdit.Text = FilterReceiveSetting[ex.FocusedRowHandle].ReceiveName;
NotifyFlagtoggleSwitch.IsOn = FilterReceiveSetting[ex.FocusedRowHandle].NotifyFlag;
TimeoutSpantextEdit.Text = FilterReceiveSetting[ex.FocusedRowHandle].HTimeoutSpan.ToString();
MTimeoutSpantextEdit.Text = FilterReceiveSetting[ex.FocusedRowHandle].MTimeoutSpan.ToString();
}
}
}
};
#endregion
#region 報表行刪除
gridView1.RowDeleting += (s, ex) =>
{
ColumnView view = (ColumnView)s;
string CaseNo = CaseNotextEdit.Text;
int ReceiveNo = Convert.ToInt32(ReceiveNotextEdit.Text);
ChungHsin_MySqlMethod.Delete_ReceiveSetting(CaseNo, ReceiveNo);
ChungHsin_MySqlMethod.Delete_AiSetting(CaseNo, ReceiveNo);
ChungHsin_MySqlMethod.Delete_StateSetting(CaseNo, ReceiveNo);
};
#endregion
#region 關鍵字搜尋
gridView1.ColumnFilterChanged += (s, e) =>
{
GridView view = s as GridView;
if (view.FindFilterText != "")
{
FilterReceiveSetting = new List <ReceiveSetting>();
for (int i = 0; i < view.RowCount; i++)
{
if (view.IsGroupRow(i))
{
continue;
}
var entity = view.GetRow(i) as ReceiveSetting;
if (entity == null)
{
continue;
}
FilterReceiveSetting.Add(entity);
}
}
if (FilterReceiveSetting.Count > 0)
{
CaseNotextEdit.Text = FilterReceiveSetting[0].CaseNo;
DeviceTypeEnumcomboBoxEdit.SelectedIndex = FilterReceiveSetting[0].DeviceTypeEnum;
ReceiveNotextEdit.Text = FilterReceiveSetting[0].ReceiveNo.ToString();
ReceiveNametextEdit.Text = FilterReceiveSetting[0].ReceiveName;
NotifyFlagtoggleSwitch.IsOn = FilterReceiveSetting[0].NotifyFlag;
TimeoutSpantextEdit.Text = FilterReceiveSetting[0].HTimeoutSpan.ToString();
MTimeoutSpantextEdit.Text = FilterReceiveSetting[0].MTimeoutSpan.ToString();
}
};
#endregion
#region 表頭篩選
gridView1.EndSorting += (s, e) =>
{
GridView view = s as GridView;
FilterReceiveSetting = new List <ReceiveSetting>();
for (int i = 0; i < view.RowCount; i++)
{
if (view.IsGroupRow(i))
{
continue;
}
var entity = view.GetRow(i) as ReceiveSetting;
if (entity == null)
{
continue;
}
FilterReceiveSetting.Add(entity);
}
SortGlyphFlag = true;
gridView1.FocusedRowHandle = 0;
};
#endregion
gridView1.FocusedRowHandle = 1;
Flag = true;
}
else
{
gridControl1.Refresh();
}
}
/// <summary>
/// 查詢案場
/// </summary>
public override void Search_Setting()
{
var CaseSetting = ChungHsin_MySqlMethod.CaseLoad();
gridControl1.DataSource = CaseSetting;
if (!Flag)
{
gridView1.CustomColumnDisplayText += (s, ex) =>
{
if (ex.Column.FieldName == "NotifyTypeEnum")
{
int val = (int)ex.Value;
switch (val)
{
case 0:
{
ex.DisplayText = "None";
}
break;
case 1:
{
ex.DisplayText = "LineNotify";
}
break;
case 2:
{
ex.DisplayText = "TelegramBot";
}
break;
}
}
};
gridView1.OptionsBehavior.Editable = false;
gridView1.OptionsSelection.EnableAppearanceFocusedCell = false;
for (int i = 0; i < gridView1.Columns.Count; i++)
{
gridView1.Columns[i].BestFit();
}
gridView1.Columns["PK"].Visible = false;
gridView1.Columns["CaseNo"].Caption = "案場編號";
gridView1.Columns["Address"].Caption = "地址";
gridView1.Columns["Contacter"].Caption = "聯絡人";
gridView1.Columns["Phone"].Caption = "聯絡電話";
gridView1.Columns["TitleName"].Caption = "案場名稱";
gridView1.Columns["NotifyTypeEnum"].Caption = "推播類型";
gridView1.Columns["NotifyApi"].Caption = "推播網址";
gridView1.Columns["NotifyToken"].Caption = "推播權杖";
gridView1.Columns["Longitude"].Caption = "經度";
gridView1.Columns["Latitude"].Caption = "緯度";
#region 報表行聚焦
gridView1.FocusedRowChanged += (s, ex) =>
{
ColumnView view = (ColumnView)s;
if ((view.FindFilterText == "" || view.ActiveFilterString != "") & !SortGlyphFlag)
{
if (ex.FocusedRowHandle > -1)
{
CaseNotextEdit.Text = view.GetListSourceRowCellValue(ex.FocusedRowHandle, "CaseNo").ToString();
AddresstextEdit.Text = view.GetListSourceRowCellValue(ex.FocusedRowHandle, "Address").ToString();
ContactertextEdit.Text = view.GetListSourceRowCellValue(ex.FocusedRowHandle, "Contacter").ToString();
PhonetextEdit.Text = view.GetListSourceRowCellValue(ex.FocusedRowHandle, "Phone").ToString();
TitleNametextEdit.Text = view.GetListSourceRowCellValue(ex.FocusedRowHandle, "TitleName").ToString();
NotifyTypeEnumcomboBoxEdit.SelectedIndex = Convert.ToInt32(view.GetListSourceRowCellValue(ex.FocusedRowHandle, "NotifyTypeEnum"));
NotifyApitextEdit.Text = view.GetListSourceRowCellValue(ex.FocusedRowHandle, "NotifyApi").ToString();
NotifyTokentextEdit.Text = view.GetListSourceRowCellValue(ex.FocusedRowHandle, "NotifyToken").ToString();
LongitudetextEdit.Text = view.GetListSourceRowCellValue(ex.FocusedRowHandle, "Longitude").ToString();
LatitudetextEdit.Text = view.GetListSourceRowCellValue(ex.FocusedRowHandle, "Latitude").ToString();
}
}
else
{
if (ex.FocusedRowHandle > -1)
{
if (FilterCaseSetting.Count > 0 && FilterCaseSetting.Count > ex.FocusedRowHandle)
{
CaseNotextEdit.Text = FilterCaseSetting[ex.FocusedRowHandle].CaseNo;
AddresstextEdit.Text = FilterCaseSetting[ex.FocusedRowHandle].Address;
ContactertextEdit.Text = FilterCaseSetting[ex.FocusedRowHandle].Contacter;
PhonetextEdit.Text = FilterCaseSetting[ex.FocusedRowHandle].Phone;
TitleNametextEdit.Text = FilterCaseSetting[ex.FocusedRowHandle].TitleName;
NotifyTypeEnumcomboBoxEdit.SelectedIndex = FilterCaseSetting[ex.FocusedRowHandle].NotifyTypeEnum;
NotifyApitextEdit.Text = FilterCaseSetting[ex.FocusedRowHandle].NotifyApi;
NotifyTokentextEdit.Text = FilterCaseSetting[ex.FocusedRowHandle].NotifyToken;
LongitudetextEdit.Text = FilterCaseSetting[ex.FocusedRowHandle].Longitude.ToString();
LatitudetextEdit.Text = FilterCaseSetting[ex.FocusedRowHandle].Latitude.ToString();
}
}
}
};
#endregion
#region 報表行刪除
gridView1.RowDeleting += (s, ex) =>
{
ColumnView view = (ColumnView)s;
string CaseNo = CaseNotextEdit.Text;
ChungHsin_MySqlMethod.Delete_CaseSetting(CaseNo);
};
#endregion
#region 關鍵字搜尋
gridView1.ColumnFilterChanged += (s, e) =>
{
GridView view = s as GridView;
if (view.FindFilterText != "" || view.ActiveFilterString != "")
{
FilterCaseSetting = new List <CaseSetting>();
for (int i = 0; i < view.RowCount; i++)
{
if (view.IsGroupRow(i))
{
continue;
}
var entity = view.GetRow(i) as CaseSetting;
if (entity == null)
{
continue;
}
FilterCaseSetting.Add(entity);
}
}
if (FilterCaseSetting.Count > 0)
{
CaseNotextEdit.Text = FilterCaseSetting[0].CaseNo;
AddresstextEdit.Text = FilterCaseSetting[0].Address;
ContactertextEdit.Text = FilterCaseSetting[0].Contacter;
PhonetextEdit.Text = FilterCaseSetting[0].Phone;
TitleNametextEdit.Text = FilterCaseSetting[0].TitleName;
NotifyTypeEnumcomboBoxEdit.SelectedIndex = FilterCaseSetting[0].NotifyTypeEnum;
NotifyApitextEdit.Text = FilterCaseSetting[0].NotifyApi;
NotifyTokentextEdit.Text = FilterCaseSetting[0].NotifyToken;
LongitudetextEdit.Text = FilterCaseSetting[0].Longitude.ToString();
LatitudetextEdit.Text = FilterCaseSetting[0].Latitude.ToString();
}
};
#endregion
#region 表頭篩選
gridView1.EndSorting += (s, e) =>
{
GridView view = s as GridView;
FilterCaseSetting = new List <CaseSetting>();
for (int i = 0; i < view.RowCount; i++)
{
if (view.IsGroupRow(i))
{
continue;
}
var entity = view.GetRow(i) as CaseSetting;
if (entity == null)
{
continue;
}
FilterCaseSetting.Add(entity);
}
SortGlyphFlag = true;
gridView1.FocusedRowHandle = 0;
};
#endregion
gridView1.FocusedRowHandle = 1;
Flag = true;
}
else
{
gridControl1.Refresh();
}
}
