Пример #1
0
        private void SyncSqlServer2SSCE(object sender, RoutedEventArgs e)
        {
            string server   = sqlServerLoginControl1.X_Result.Server;
            string database = sqlServerLoginControl1.X_Result.DbName;
            string username = sqlServerLoginControl1.X_Result.UID;
            string pwd      = sqlServerLoginControl1.X_Result.PWD;

            if (core == null)
            {
                "ImportNeedSelectTables".GetFromResourece().Notify();
                return;
            }

            if (string.IsNullOrEmpty(server) || string.IsNullOrEmpty(database) ||
                string.IsNullOrEmpty(username))
            {
                "ImportEachElement".GetFromResourece().Notify();
                return;
            }
            string sdfFile = txtTargetFile.Text;

            PageSwitchProgressBar dp     = PageSwitchProgressBar.X_BeginLoadingDialog();
            List <SyncResultArgs> result = null;

            try
            {
                List <string> proecssTableList = new List <string>();

                foreach (string item in tableList.SelectedItems)
                {
                    proecssTableList.Add(item);
                }

                result = CommonUtil.SyncDataFromSqlServerToSSCE(core, sdfFile, proecssTableList, (bool)chkIsNeedCopyData.IsChecked);
            }
            catch (Exception ee)
            {
                ee.HandleMyException();
            }
            finally
            {
                if (!dp.IsDisposed)
                {
                    dp.X_EndLoadingDialog();
                }
            }

            if (result != null)
            {
                ShowSyncResult rShow = new ShowSyncResult(result);
#if DEBUG
#else
                rShow.Owner = this;
#endif

                rShow.ShowDialog();
            }
        }
Пример #2
0
        /// <summary>
        /// Process CSV Type
        /// All args are checked external
        /// So here is no need to do again
        /// </summary>
        /// <param name="srcHandler"></param>
        /// <param name="targetHandler"></param>
        /// <param name="tableList"></param>
        private void PreProcessCSV(CoreEA.ICoreEAHander srcHandler, CoreEA.ICoreEAHander targetHandler, List <string> tableList)
        {
            List <SyncResultArgs> result = new List <SyncResultArgs>();

            tableList.ForEach((tableName) =>
            {
                SyncResultArgs curStatus = new SyncResultArgs();
                try
                {
                    BaseTableSchema tableSchmea = srcHandler.GetTableSchemaInfoObject(tableName);

                    if (tableName.Contains(" "))
                    {
                        tableName = tableName.Replace(" ", "");
                    }
                    using (StreamWriter sw = File.CreateText(targetHandler.CurDatabase.Append(tableName + ".csv")))
                    {
                        //Create Column Header
                        StringBuilder sb = new StringBuilder();
                        tableSchmea.Columns.ForEach((column) =>
                        {
                            sb.Append(column.ColumnName);
                            sb.Append(CultureInfo.CurrentCulture.TextInfo.ListSeparator);
                        });
                        sw.WriteLine(sb.ToString());

                        //Create Data
                        DataTable dt = srcHandler.GetAllDataFromTable(tableName);

                        foreach (DataRow row in dt.Rows)
                        {
                            StringBuilder builder = new StringBuilder();
                            foreach (var column in tableSchmea.Columns)
                            {
                                builder.Append(row[column.ColumnName]);
                                builder.Append(CultureInfo.CurrentCulture.TextInfo.ListSeparator);
                            }
                            sw.WriteLine(builder.ToString());
                        }
                    }

                    curStatus.ProcessStatus = true;
                    curStatus.TableName     = tableName;
                }
                catch (Exception accessEx)
                {
                    curStatus.LastErrorMsg  = accessEx.Message;
                    curStatus.ProcessStatus = false;
                    curStatus.TableName     = tableName;

                    accessEx.HandleMyException();
                    return;
                }
                finally
                {
                    result.Add(curStatus);
                    butNext.Content   = "End";
                    butNext.IsEnabled = false;
                }
            });

            if ("DataTransfer_ConfirmViewReport".GetFromResourece().Confirm())
            {
                ShowSyncResult rShow = new ShowSyncResult(result);
                rShow.ShowDialog();
            }
            else
            {
            }

            Close();
        }
Пример #3
0
        /// <summary>
        /// Finish Step
        /// Notice : Each table schema from Core can't be changed .
        /// We will filter the table schema for each target handler in this method.
        /// </summary>
        /// <param name="srcHandler"></param>
        /// <param name="targetHandler"></param>
        /// <param name="tableList"></param>
        /// <param name="isShowUI">This value will be false when UT</param>
        private bool DoExchangeData(CoreEA.ICoreEAHander srcHandler, CoreEA.ICoreEAHander targetHandler, List <string> tableList
                                    , bool isShowUI = true)
        {
            bool ret = false;
            //Due to the old code use .ForEach way, it is hard to detect the error position and status
            //So use this boolean object to indicate whether there has error in the for each cycle .
            //Is true,didn't show the UI error messgae when UI , just set this value to true .
            bool isHasError = false;

            if (tableList.Count < 1)
            {
                "DataTransferNoTableMsg".GetFromResourece().Show();
                return(false);
            }

            List <SyncResultArgs> result            = new List <SyncResultArgs>();
            List <string>         targetDbTableList = targetHandler.GetTableListInDatabase();
            PageSwitchProgressBar dp = null;

            if (isShowUI)
            {
                dp = PageSwitchProgressBar.X_BeginLoadingDialog();
            }
            try
            {
                foreach (string tableName in tableList)
                {
                    SyncResultArgs curStatus = new SyncResultArgs();

                    //Get target table schema info
                    BaseTableSchema tableSchmea = srcHandler.GetTableSchemaInfoObject(tableName);

                    try
                    {
                        //If table not existed ,then create it.
                        if (!targetDbTableList.Contains(tableName))
                        {
                            if (true)
                            {
                                switch (targetHandler.HostedType)
                                {
                                case CoreE.UsedDatabaseType.OleDb:
                                    throw new NotImplementedException();
                                    break;

                                case CoreE.UsedDatabaseType.SqlServer:
                                    targetHandler.CreateTable(tableSchmea);
                                    try
                                    {
                                        CommonUtil.ExchangeDataBetweenAnyDbs(srcHandler, targetHandler, tableName);
                                    }
                                    catch (Exception exee)
                                    {
                                        Debug.WriteLine(exee.Message);
                                        targetHandler.DeleteTable(tableSchmea.TableName);
                                    }
                                    break;

                                case CoreE.UsedDatabaseType.MySql:
                                    targetHandler.CreateTable(tableSchmea);
                                    try
                                    {
                                        CommonUtil.ExchangeDataBetweenAnyDbs(srcHandler, targetHandler, tableName);
                                    }
                                    catch (Exception exee)
                                    {
                                        Debug.WriteLine(exee.Message);
                                        targetHandler.DeleteTable(tableSchmea.TableName);
                                    }
                                    finally
                                    {
                                    }
                                    break;

                                case CoreE.UsedDatabaseType.SqlCE35:
                                    FilterTableSchemInfoWithSSCE(tableSchmea);
                                    targetHandler.CreateTable(tableSchmea);
                                    CommonUtil.CopyTable(srcHandler.GetConnection(), (SqlCeConnection)targetHandler.GetConnection(),
                                                         string.Format("Select * from {0}", srcHandler.GetMaskedTableName(tableName)), tableName);
                                    break;

                                case CoreE.UsedDatabaseType.Sqlite:
                                    targetHandler.CreateTable(tableSchmea);
                                    CommonUtil.ExchangeDataBetweenAnyDbs(srcHandler, targetHandler, tableName);
                                    break;

                                case CoreE.UsedDatabaseType.Firebird:
                                    throw new NotImplementedException();
                                    break;

                                case CoreE.UsedDatabaseType.CSV:
                                    targetHandler.CreateTable(tableSchmea);
                                    try
                                    {
                                        PreProcessCSV(srcHandler, targetHandler, tableName);
                                    }
                                    catch (Exception exee)
                                    {
                                        Debug.WriteLine(exee.Message);
                                        targetHandler.DeleteTable(tableSchmea.TableName);
                                    }
                                    break;

                                case CoreE.UsedDatabaseType.Excel:
                                    throw new NotImplementedException();

                                case CoreE.UsedDatabaseType.Oracle:
                                    throw new NotImplementedException();

                                default:
                                    break;
                                }
                            }

                            curStatus.ProcessStatus = true;
                            curStatus.TableName     = tableName;
                        }
                    }
                    catch (Exception sss)
                    {
                        curStatus.LastErrorMsg  = sss.Message;
                        curStatus.ProcessStatus = false;
                        curStatus.TableName     = tableName;
                        if (isShowUI)
                        {
                            sss.HandleMyException();
                        }
                        else
                        {
                            isHasError = true;
                        }
                        return(false);
                    }
                    finally
                    {
                        result.Add(curStatus);
                        butNext.Content   = "End";
                        butNext.IsEnabled = false;
                    }
                }
                ;
                if (isHasError)
                {
                    ret = false;
                }
                else
                {
                    ret = true;
                }
            }
            finally
            {
                if (isShowUI)
                {
                    if (!dp.IsDisposed)
                    {
                        dp.X_EndLoadingDialog();
                    }
                }
            }
            if (isShowUI)
            {
                if ("DataTransfer_ConfirmViewReport".GetFromResourece().Confirm())
                {
                    ShowSyncResult rShow = new ShowSyncResult(result);
                    rShow.ShowDialog();
                }

                Close();
            }

            return(ret);
        }