/// <summary> /// 获取帐套库的数据库写入HasTable /// </summary> public static void GetDbAccount() { if (SG.Parameters.SGParameter.hAccountConn != null) { SG.Parameters.SGParameter.hAccountConn.Clear(); } else { SG.Parameters.SGParameter.hAccountConn = new System.Collections.Hashtable(); } string dbType = DbConfiguration_Factory.DbType; string sConn = DbConfiguration_Factory.GetAccountConnString(); string sSQL = "SELECT T_Account.FID, T_Account.FNumber, T_Account.FName, T_Account.FDatabase, T_Account.FServerName, T_Account.FUser, T_Account.FPwd, T_Account.FDataType, " + " T_Account.FOrgID, T_Account.FCreateDate, T_Account.FBackUpDate, T_Account.FVer, T_Account.FProductName, T_Account.FOnlineCount, T_Account.FServerIP, T_DbType.FSign " + " FROM T_Account INNER JOIN T_DbType ON T_Account.FID = T_DbType.FID "; DataTable sAccount = new DataBaseLayer(sConn, dbType).ExecuteQueryDataTable(sSQL); foreach (DataRow myRow in sAccount.Rows) { SG.Parameters.SGParameter.sAccountConn sAC = new Parameters.SGParameter.sAccountConn(); sAC.sServer = myRow["FServerName"].ToString(); sAC.sDatabase = myRow["FDatabase"].ToString(); sAC.sUser = myRow["FUser"].ToString(); sAC.sPwd = myRow["FPwd"].ToString(); sAC.sDbType = myRow["FSign"].ToString(); SG.Parameters.SGParameter.hAccountConn.Add(myRow["FNumber"].ToString(), sAC); } }
/// <summary> /// 获取帐套库的数据库写入HasTable /// </summary> public static void GetDbAccount() { if (SG.Parameters.SGParameter.hAccountConn != null) SG.Parameters.SGParameter.hAccountConn.Clear(); else SG.Parameters.SGParameter.hAccountConn = new System.Collections.Hashtable(); string dbType = DbConfiguration_Factory.DbType; string sConn = DbConfiguration_Factory.GetAccountConnString(); string sSQL = "SELECT T_Account.FID, T_Account.FNumber, T_Account.FName, T_Account.FDatabase, T_Account.FServerName, T_Account.FUser, T_Account.FPwd, T_Account.FDataType, " + " T_Account.FOrgID, T_Account.FCreateDate, T_Account.FBackUpDate, T_Account.FVer, T_Account.FProductName, T_Account.FOnlineCount, T_Account.FServerIP, T_DbType.FSign " + " FROM T_Account INNER JOIN T_DbType ON T_Account.FID = T_DbType.FID "; DataTable sAccount = new DataBaseLayer(sConn, dbType).ExecuteQueryDataTable(sSQL); foreach(DataRow myRow in sAccount.Rows) { SG.Parameters.SGParameter.sAccountConn sAC = new Parameters.SGParameter.sAccountConn(); sAC.sServer = myRow["FServerName"].ToString(); sAC.sDatabase = myRow["FDatabase"].ToString(); sAC.sUser = myRow["FUser"].ToString(); sAC.sPwd = myRow["FPwd"].ToString(); sAC.sDbType = myRow["FSign"].ToString(); SG.Parameters.SGParameter.hAccountConn.Add(myRow["FNumber"].ToString(), sAC); } }