//override public void onRecieveResult(Dictionary <String, Object> bundle) { Object senderName; Object resultValue; Object senderValue; bundle.TryGetValue(PageDataExchange.KEY_SENDER_NAME, out senderName); bundle.TryGetValue(PageDataExchange.KEY_RESULT_VALUE, out resultValue); bundle.TryGetValue(PageDataExchange.KEY_SENDER_VALUE, out senderValue); //beckhoff changed // if (WarnningDataSource.TAG.Equals(senderName) ) { WarnningDataSource.ErrorInfo infoChanged = (WarnningDataSource.ErrorInfo)senderValue; WarnningDataSource.ErrorInfo infoCurrent = (WarnningDataSource.ErrorInfo) this.cb_info.SelectedItem; WarnningDataSource data = WarnningDataSource.GetInstance(); if (data.IsWarnningAdded(infoChanged)) { this.cb_info.SelectedItem = infoChanged; } else if (infoChanged.level == infoCurrent.level)// item was removed { if (this.cb_info.SelectedIndex > 0) { this.cb_info.SelectedIndex = 0; } } this.cb_info.ItemsSource = data.mWarnningList; this.cb_info.Items.Refresh(); } }
//public class Record //{ // public int index{get;set;} // public String category{get;set;} // public string description { get; set; } // public string code { get; set; } // public DateTime whenhappened { get; set; } // public DateTime whenresolved { get; set; } //} //record infomation runtime public static int write(WarnningDataSource.ErrorInfo info) { ContentProvider provider = ContentProvider.getInstance(); string sql = String.Format(@"INSERT INTO [warnning] ([level],[category_id],[code],[description],[whenhappened] ) VALUES({0},{1},'{2}','{3}','{4}')", info.level, info.category_id, info.code, info.description, DateTime.Now.ToString()); int rowAffected = provider.insert(sql); return(rowAffected); }
private void btn_delete_Click(object sender, RoutedEventArgs e) { mWarnningDataSource = WarnningDataSource.GetInstance(); mStatusMap = mWarnningDataSource.mStatusMap; WarnningDataSource.ErrorInfo info = new WarnningDataSource.ErrorInfo() { level = 202, description = "add test" }; //test delete to list mWarnningDataSource.RemoveWarningItem(info); int count = mWarnningDataSource.mWarnningList.Count; PageDataExchange context = PageDataExchange.getInstance(); context.NotifyObserverChanged(PageWarnningHeader.TAG, WarnningDataSource.TAG, info); }
private void btn_delete_Click(object sender, RoutedEventArgs e) { mWarnningDataSource = WarnningDataSource.GetInstance(); mStatusMap = mWarnningDataSource.mStatusMap; WarnningDataSource.ErrorInfo info = new WarnningDataSource.ErrorInfo() { level = 202, description = "add test" }; //test delete to list mWarnningDataSource.RemoveWarningItem(info); int count = mWarnningDataSource.GetWarnningCount(); PageDataExchange context = PageDataExchange.getInstance(); context.NotifyObserverChanged(PageWarnningHeader.TAG, WarnningDataSource.TAG, info); }
//override beckhoff changed public void onRecieveResult(Dictionary <String, Object> bundle) { Object senderName; Object senderValue; bundle.TryGetValue(PageDataExchange.KEY_SENDER_NAME, out senderName); bundle.TryGetValue(PageDataExchange.KEY_SENDER_VALUE, out senderValue); WarnningDataSource.ErrorInfo info = (WarnningDataSource.ErrorInfo)senderValue; this.tb_code.Text = info.code; this.tb_solution.Text = info.solution; PageDataExchange context = PageDataExchange.getInstance(); context.NotifyObserverChanged(PageStatus.TAG, PageStatus.CODE, info.code); }
//override public void onRecieveResult(Dictionary <String, Object> bundle) { Object senderName; Object resultValue; Object senderValue; bundle.TryGetValue(PageDataExchange.KEY_SENDER_NAME, out senderName); bundle.TryGetValue(PageDataExchange.KEY_RESULT_VALUE, out resultValue); bundle.TryGetValue(PageDataExchange.KEY_SENDER_VALUE, out senderValue); //beckhoff changed if (WarnningDataSource.TAG.Equals(senderName)) { WarnningDataSource.ErrorInfo infoChanged = (WarnningDataSource.ErrorInfo)senderValue; WarnningDataSource.ErrorInfo infoCurrent = (WarnningDataSource.ErrorInfo) this.cb_info.SelectedItem; WarnningDataSource data = WarnningDataSource.GetInstance(); //if (data.IsWarnningAdded(infoChanged)) //{ // //this.cb_info.SelectedItem = infoChanged; //} //else if (infoCurrent != null && infoChanged.level == infoCurrent.level)// item was removed //{ // if (this.cb_info.SelectedIndex > 0) // { // this.cb_info.SelectedIndex = 0; // } //} PageDataExchange context = PageDataExchange.getInstance(); WarnningDataSource dataSource = WarnningDataSource.GetInstance(); if (dataSource.GetWarnningCount() == 0 && context.IsPageLoaded(PageWarningDetail.TAG)) { Utils.NavigatePageBack(); } this.cb_info.ItemsSource = data.GetWarnningList(); this.cb_info.Items.Refresh(); this.cb_info.SelectedIndex = 0; } }
private void infoPanel_SelectionChanged(object sender, SelectionChangedEventArgs e) { if (this.cb_info.SelectedIndex < 0) { this.cb_info.SelectedIndex = 0; } WarnningDataSource.ErrorInfo info = (WarnningDataSource.ErrorInfo) this.cb_info.SelectedItem; PageDataExchange context = PageDataExchange.getInstance(); if (info.level < 200) { Dictionary <String, Object> bundle = new Dictionary <string, object>(); bundle.Add(PageDataExchange.KEY_SENDER_NAME, WarnningDataSource.TAG); bundle.Add(PageDataExchange.KEY_SENDER_VALUE, info); context.putExtra(PageWarningDetail.TAG, bundle); Utils.NavigateToPage(MainWindow.sFrameReportName, PageWarningDetail.TAG); } context.NotifyObserverChanged(PageWarningDetail.TAG, WarnningDataSource.TAG, info); context.NotifyObserverChanged(PageStatus.TAG, PageStatus.CODE, info.code); }
public static int resolve(WarnningDataSource.ErrorInfo info) { ContentProvider provider = ContentProvider.getInstance(); String sqlQuery = String.Format(@"SELECT [_id],[whenresolved]FROM [warnning] where level={0} ORDER BY [whenhappened] desc", info.level); DataTable dt = provider.query(sqlQuery); int rowAffected = 0; foreach (DataRow row in dt.Rows) { string whenresolved = row["whenresolved"].ToString(); if (String.IsNullOrEmpty(whenresolved)) { string id = row["_id"].ToString(); string sql = String.Format(@"UPDATE [warnning] SET [whenresolved]='{0}' where [_id]={1} ", DateTime.Now.ToString(), id); rowAffected = provider.update(sql); break; } } return(rowAffected); }
public static List <WarnningDataSource.ErrorInfo> getAllRecords(String filter) { String where = ""; if (!String.IsNullOrEmpty(filter)) { where = " where " + filter; } string sql = @"SELECT [level] , [code] , [category.description] as category, [warnning.description] as description, [whenhappened] , [whenresolved] FROM [warnning] INNER JOIN [category] ON warnning.category_id=category.id" + where + " ORDER BY [whenhappened] desc "; ContentProvider provider = ContentProvider.getInstance(); DataTable dt = provider.query(sql); List <WarnningDataSource.ErrorInfo> records = new List <WarnningDataSource.ErrorInfo>(); for (int i = 0; i < dt.Rows.Count; i++) { DataRow row = dt.Rows[i]; WarnningDataSource.ErrorInfo record = new WarnningDataSource.ErrorInfo(); record.level = int.Parse(row["level"].ToString()); record.category = row["category"].ToString(); record.description = row["description"].ToString(); record.whenhappened = row["whenhappened"].ToString(); record.whenresolved = row["whenresolved"].ToString(); record.code = row["code"].ToString(); records.Add(record); } return(records); }
private void btn_add_Click(object sender, RoutedEventArgs e) { mWarnningDataSource = WarnningDataSource.GetInstance(); mStatusMap = mWarnningDataSource.mStatusMap; WarnningDataSource.ErrorInfo info = new WarnningDataSource.ErrorInfo() { level = 202, description = "add test" }; int count = mWarnningDataSource.mWarnningList.Count; //test add to list mListError.Add(null); mWarnningDataSource.AddWarningItem(info); count = mWarnningDataSource.mWarnningList.Count; PageDataExchange context = PageDataExchange.getInstance(); context.NotifyObserverChanged(PageWarnningHeader.TAG, WarnningDataSource.TAG, info); }
public static List<WarnningDataSource.ErrorInfo> getAllRecords(String filter) { String where = ""; if (!String.IsNullOrEmpty(filter)) { where = " where " + filter; } string sql = @"SELECT [level] , [code] , [category.description] as category, [warnning.description] as description, [whenhappened] , [whenresolved] FROM [warnning] INNER JOIN [category] ON warnning.category_id=category.id" + where + " ORDER BY [whenhappened] desc "; ContentProvider provider = ContentProvider.getInstance(); DataTable dt = provider.query(sql); List<WarnningDataSource.ErrorInfo> records = new List<WarnningDataSource.ErrorInfo>(); for (int i = 0; i < dt.Rows.Count; i++) { DataRow row = dt.Rows[i]; WarnningDataSource.ErrorInfo record = new WarnningDataSource.ErrorInfo(); record.level = int.Parse(row["level"].ToString()); record.category = row["category"].ToString(); record.description = row["description"].ToString(); record.whenhappened = row["whenhappened"].ToString(); record.whenresolved = row["whenresolved"].ToString(); record.code = row["code"].ToString(); records.Add(record); } return records; }