Beispiel #1
0
        private void UpdateTradeSummaryGrid()
        {
            string tableName = "SummaryData";

            DevExpress.XtraGrid.Views.Base.BaseView activeView = null;
            DevExpress.XtraGrid.GridControl         activeGrid = null;
            try
            {
                foreach (DevExpress.XtraGrid.GridControl grid in managedGridList)
                {
                    DevExpress.XtraGrid.GridControlViewCollection views = grid.Views;
                    activeGrid = grid;
                    foreach (DevExpress.XtraGrid.Views.Base.BaseView view in views)
                    {
                        DataView dv = (DataView)view.DataSource;
                        if (dv.Table.TableName == tableName)
                        {
                            //                     view.BeginDataUpdate();
                            activeView = view;
                            foreach (SummaryData sumData in sumDataCache)
                            {
                                DataRow rowFound = dv.Table.Rows.Find(sumData.Id);
                                if (rowFound != null)
                                {
                                    string qryCode = (string)rowFound["QryCode"];
                                    CollectionHelper.UpdateDataRowFromObject <SummaryData>(sumData, ref rowFound);
                                    if (!((qryCode == null) || (qryCode == "")))
                                    {
                                        rowFound["QryCode"] = qryCode; // so as to not overwrite any "Get All" results.
                                    }
                                }
                                else
                                {
                                    DataRow newRow = dv.Table.NewRow();
                                    newRow = CollectionHelper.CreateDataRowFromObject <SummaryData>(sumData, newRow);
                                    dv.Table.Rows.Add(newRow);
                                }
                            }
                        }
                    }
                }
            }
            catch (Exception ex)
            {
                throw new Exception("An error occurred while updating the Trade Summary grid." + Environment.NewLine +
                                    "Error CNF-356 in " + PROJ_FILE_NAME + ".UpdateTradeRqmtGrid(): " + ex.Message);
            }
            finally
            {
                if (activeView != null)
                {
                    //                   activeGrid.Invoke(new EndDataGridUpdate(EndDataUpdate), activeView);
                    sumDataCache.Clear();
                }
            }
        }
Beispiel #2
0
        private void UpdateTradeRqmtGrid()
        {
            string tableName = "RqmtData";

            DevExpress.XtraGrid.Views.Base.BaseView activeView = null;
            DevExpress.XtraGrid.GridControl         activeGrid = null;
            try
            {
                foreach (DevExpress.XtraGrid.GridControl grid in managedGridList)
                {
                    DevExpress.XtraGrid.GridControlViewCollection views = grid.Views;
                    activeGrid = grid;
                    foreach (DevExpress.XtraGrid.Views.Base.BaseView view in views)
                    {
                        DataView dv = (DataView)view.DataSource;
                        if (dv.Table.TableName == tableName)
                        {
                            //                         view.BeginDataUpdate();
                            activeView = view;
                            foreach (RqmtData rqmtData in rqmtDataCache)
                            {
                                DataRow rowFound = dv.Table.Rows.Find(rqmtData.Id);
                                if (rowFound != null)
                                {
                                    CollectionHelper.UpdateDataRowFromObject <RqmtData>(rqmtData, ref rowFound);
                                }
                                else
                                {
                                    DataRow newRow = dv.Table.NewRow();
                                    newRow = CollectionHelper.CreateDataRowFromObject <RqmtData>(rqmtData, newRow);
                                    dv.Table.Rows.Add(newRow);
                                }
                            }
                        }
                    }
                }
            }
            catch (Exception ex)
            {
                throw new Exception("An error occurred while updating the Trade Rqmts grid." + Environment.NewLine +
                                    "Error CNF-355 in " + PROJ_FILE_NAME + ".UpdateTradeRqmtGrid(): " + ex.Message);
            }
            finally
            {
                if (activeView != null)
                {
                    //                   activeGrid.Invoke(new EndDataGridUpdate(EndDataUpdate), activeView);
                    rqmtDataCache.Clear();
                }
            }
        }
Beispiel #3
0
        private void UpdateInboundDocGrid()
        {
            string tableName = "InboundDocsView";

            DevExpress.XtraGrid.Views.Base.BaseView activeView = null;
            DevExpress.XtraGrid.GridControl         activeGrid = null;
            try
            {
                foreach (DevExpress.XtraGrid.GridControl grid in managedGridList)
                {
                    DevExpress.XtraGrid.GridControlViewCollection views = grid.Views;
                    activeGrid = grid;
                    foreach (DevExpress.XtraGrid.Views.Base.BaseView view in views)
                    {
                        DataView dv = (DataView)view.DataSource;
                        if (dv.Table.TableName == tableName)
                        {
                            //                         view.BeginDataUpdate();
                            activeView = view;
                            foreach (InboundDocsView data in inbDocViewCache)
                            {
                                DataRow rowFound = dv.Table.Rows.Find(data.Id);
                                if (rowFound != null)
                                {
                                    // because inbound_doc_user_flag data is not include, we must copy this data to
                                    // the "data" object that is being used to update the data row found.
                                    if (rowFound["IgnoreFlag"] != System.DBNull.Value)
                                    {
                                        data.IgnoreFlag = rowFound["IgnoreFlag"].ToString();
                                    }

                                    if (rowFound["BookmarkFlag"] != System.DBNull.Value)
                                    {
                                        data.BookmarkFlag = rowFound["BookmarkFlag"].ToString();
                                    }

                                    if (rowFound["CommentFlag"] != System.DBNull.Value)
                                    {
                                        data.CommentFlag = rowFound["CommentFlag"].ToString();
                                    }

                                    if (rowFound["CommentUser"] != System.DBNull.Value)
                                    {
                                        data.CommentUser = rowFound["CommentUser"].ToString();
                                    }
                                    CollectionHelper.UpdateDataRowFromObject <InboundDocsView>(data, ref rowFound);
                                }
                                else
                                {
                                    DataRow newRow = dv.Table.NewRow();
                                    newRow = CollectionHelper.CreateDataRowFromObject <InboundDocsView>(data, newRow);
                                    dv.Table.Rows.Add(newRow);
                                }
                            }
                        }
                    }
                }
            }
            catch (Exception ex)
            {
                throw new Exception("An error occurred while updating the Inbound Documents grid." + Environment.NewLine +
                                    "Error CNF-353 in " + PROJ_FILE_NAME + ".UpdateInboundDocGrid(): " + ex.Message);
            }
            finally
            {
                if (activeView != null)
                {
                    //                  activeGrid.Invoke(new EndDataGridUpdate(EndDataUpdate), activeView);
                    inbDocViewCache.Clear();
                }
            }
        }