示例#1
0
 /// <summary>
 /// 测试数据连接通断
 /// </summary>
 /// <param name="idx">连接序号,0为第一个连接</param>
 /// <returns>True 通; False 断</returns>
 public static bool TestConnection(int idx = 0)
 {
     if (dataStatus == EDataStatus.数据库)
     {
         return(DirectDBAccessor.testConn(idx));
     }
     else
     {
         bool result = false;
         try
         {
             if (wcf == null)
             {
                 WCF.WinLogin login = new WCF.WinLogin();
                 if (login.ShowDialog() == false)
                 {
                     System.Windows.MessageBox.Show("WCF数据服务连接失败,退出程序!");
                     Environment.Exit(0);
                 }
             }
             result = true;
         }
         catch
         { }
         return(result);
     }
 }
示例#2
0
        /// <summary>
        /// 按给定的SQL语句查询数据,查询将依次尝试所有连接,直至获取数据,不通的连接在程序运行期间将不再尝试
        /// </summary>
        /// <param name="sql">SQL语句</param>
        /// <param name="isShowMessage">出错时,是否弹出错误信息窗体</param>
        /// <param name="groupNum">分组号,仅同时多种数据源时需给出此参数</param>
        /// <returns>返回DataTable</returns>
        public static DataTable getDataTableFromSQL(string sql, bool isShowMessage = true)
        {
            if (string.IsNullOrWhiteSpace(sql))
            {
                return(null);
            }

            DataTable dt = null;

            if (dataStatus == EDataStatus.WCF)
            {
                try
                {
                    if (wcf == null)
                    {
                        WCF.WinLogin login = new WCF.WinLogin();
                        if (login.ShowDialog() == false)
                        {
                            if (isShowMessage)
                            {
                                System.Windows.MessageBox.Show("WCF数据服务失败,退出程序!");
                                Environment.Exit(0);
                            }
                        }
                    }
                    dt = wcf.GetDataTable(sql, curDataSourceName);
                }
                catch (Exception ee)
                {
                    try
                    {
                        WCF.WinLogin login = new WCF.WinLogin();
                        if (login.ShowDialog() == false)
                        {
                            if (isShowMessage)
                            {
                                System.Windows.MessageBox.Show("WCF数据服务失败,退出程序!" + ee.Message);
                                Environment.Exit(0);
                            }
                        }
                        dt = wcf.GetDataTable(sql, curDataSourceName);
                    }
                    catch (Exception eee)
                    {
                        if (isShowMessage)
                        {
                            System.Windows.MessageBox.Show("WCF数据服务失败,退出程序!" + eee.Message);
                            Environment.Exit(0);
                        }
                    }
                }
            }
            else
            {
                dt = DirectDBAccessor.readDataBase(sql, isShowMessage, curDataSourceName);
            }
            return(dt);
        }
示例#3
0
 ///<summary>wcf提供验证的登录界面</summary>
 public static void Login()
 {
     if (wcf == null)
     {
         WCF.WinLogin login = new WCF.WinLogin();
         if (login.ShowDialog() == false)
         {
             System.Windows.MessageBox.Show("登录失败,退出程序!");
             Environment.Exit(0);
         }
     }
 }
示例#4
0
 /// <summary>
 /// 执行给定的SQL语句,程序尝试对所有连接执行该SQL语句,不通的连接在程序运行期间不再尝试。
 /// </summary>
 /// <param name="sql">SQL语句</param>
 public static bool ExecuteSQL(string sql, bool isShowMessage = true)
 {
     if (dataStatus != EDataStatus.WCF)
     {
         return(DirectDBAccessor.executeCommand(sql, isShowMessage, curDataSourceName));
     }
     else
     {
         try
         {
             if (wcf == null)
             {
                 WCF.WinLogin login = new WCF.WinLogin();
                 if (login.ShowDialog() == false)
                 {
                     if (isShowMessage)
                     {
                         System.Windows.MessageBox.Show("WCF数据服务连接失败,退出程序!");
                         Environment.Exit(0);
                     }
                 }
             }
             return(wcf.ExecuteCommand(sql, curDataSourceName));
         }
         catch
         {
             try
             {
                 WCF.WinLogin login = new WCF.WinLogin();
                 if (login.ShowDialog() == false)
                 {
                     if (isShowMessage)
                     {
                         System.Windows.MessageBox.Show("WCF数据服务连接失败,退出程序!");
                         Environment.Exit(0);
                     }
                 }
                 return(wcf.ExecuteCommand(sql, curDataSourceName));
             }
             catch
             {
                 System.Windows.MessageBox.Show("WCF数据服务连接失败,退出程序!");
                 Environment.Exit(0);
             }
             return(false);
         }
     }
 }