/// <summary> /// 案場修改 /// </summary> /// <param name="setting"></param> public void Update_CaseSetting(CaseSetting setting) { try { using (var Conn = new MySqlConnection(scsb.ConnectionString)) { string sql = "UPDATE casesetting SET " + "Address = @Address, " + "Contacter = @Contacter," + "Phone = @Phone," + "TitleName = @TitleName," + "NotifyTypeEnum = @NotifyTypeEnum," + "NotifyApi = @NotifyApi," + "NotifyToken = @NotifyToken," + "Longitude = @Longitude," + "Latitude = @Latitude" + " WHERE CaseNo = @CaseNo AND AiNo = @AiNo"; Conn.Execute(sql, setting); } } catch (Exception ex) { Log.Error(ex, "案場修改" + "錯誤(Ewatch)"); } }
/// <summary> /// AI資訊 /// </summary> /// <returns></returns> public List <AiSetting> AiLoad(CaseSetting casesetting) { List <AiSetting> setting = null; using (var Conn = new MySqlConnection(scsb.ConnectionString)) { string sql = "SELECT * FROM AiSetting Where CaseNo = @CaseNo"; setting = Conn.Query <AiSetting>(sql, new { CaseNo = casesetting.CaseNo }).ToList(); } return(setting); }
/// <summary> /// 案場新增 /// </summary> /// <param name="setting"></param> public void Insert_CaseSetting(CaseSetting setting) { try { using (var Conn = new MySqlConnection(scsb.ConnectionString)) { string sql = "INSERT IGNORE INTO casesetting (CaseNo,Address,Contacter,Phone,TitleName,NotifyTypeEnum,NotifyApi,NotifyToken,Longitude,Latitude)" + " VALUES(@CaseNo,@Address,@Contacter,@Phone,@TitleName,@NotifyTypeEnum,@NotifyApi,@NotifyToken,@Longitude,@Latitude) "; Conn.Execute(sql, setting); } } catch (Exception ex) { Log.Error(ex, "案場新增" + "錯誤(Ewatch)"); } }
/// <summary> /// 電表資訊查詢案場 /// </summary> /// <returns></returns> public List <ElectricSetting> ElectricLoad(CaseSetting casesetting) { List <ElectricSetting> setting = null; try { using (var Conn = new MySqlConnection(scsb.ConnectionString)) { string sql = "SELECT * FROM ElectricSetting Where CaseNo = @CaseNo"; setting = Conn.Query <ElectricSetting>(sql, new { CaseNo = casesetting.CaseNo }).ToList(); } } catch (Exception ex) { Log.Error(ex, "電表資訊查詢案場" + "錯誤(Ewatch)"); } return(setting); }
/// <summary> /// Receive資訊查案場 /// </summary> /// <param name="caseSetting"></param> /// <returns></returns> public List <ReceiveSetting> ReceiveLoad(CaseSetting casesetting) { List <ReceiveSetting> setting = null; try { using (var Conn = new MySqlConnection(scsb.ConnectionString)) { string sql = "SELECT * FROM ReceiveSetting Where CaseNo = @CaseNo"; setting = Conn.Query <ReceiveSetting>(sql, new { CaseNo = casesetting.CaseNo }).ToList(); } } catch (Exception ex) { Log.Error(ex, "Receive資訊查案場" + "錯誤(ChungHsin)"); } return(setting); }
/// <summary> /// 修改按鈕 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> 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) }; Ewatch_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(); }