private void RefreshServer()
{
this.button_RefreshServer.Enabled = false;
this.comboBox_Server.Enabled = false;
this.comboBox_Server.Items.Clear();
this.comboBox_Server.Text = GetStringFromPublicResourceClass.GetStringFromPublicResource("PMSDBConnectCtrl_RetrievingDataSources");
System.Windows.Forms.Application.DoEvents();
Cursor.Current = Cursors.WaitCursor;
System.Data.DataTable dataTable = sqlAS.EnumSqlservers();
DisplayData(dataTable);
if (this.comboBox_Server.Items.Count > 0)
{
comboBox_Server.SelectedIndex = 0;
}
else
{
comboBox_Server.Text = "";
}
this.button_RefreshServer.Enabled = true;
this.comboBox_Server.Enabled = true;
Cursor.Current = Cursors.Default;
}
private bool IsAuthorized()
{
if (CurrentPrjInfo.CurrentEnvironment == MESEnvironment.MESReportDesigner ||
CurrentPrjInfo.CurrentEnvironment == MESEnvironment.MESDesigner ||
CurrentPrjInfo.CurrentEnvironment == MESEnvironment.MESDeveloper ||
CurrentPrjInfo.CurrentEnvironment == MESEnvironment.MESClient
)
{
return(true);
}
else if (CurrentPrjInfo.CurrentEnvironment == MESEnvironment.None)
{
if (_dogExpert.IsFieldRunning())
{
return(true);
}
}
if (_dogExpert.IsMESReportEnabled())
{
return(true);
}
else
{
if (_bAuthorized)
{
return(true);
}
ToolBarVisible = false;
Form f = this.FindForm();
f.Text += GetStringFromPublicResourceClass.GetStringFromPublicResource("MESReportIsNotAuthorized");
return(false);
}
}
private void SelectedForm_Load(object sender, EventArgs e)
{
switch (_doctype)
{
case byte.MaxValue:
this.Text = GetStringFromPublicResourceClass.GetStringFromPublicResource("MESPleaseSelectView");
break;
case 1:
this.Text = GetStringFromPublicResourceClass.GetStringFromPublicResource("MESPleaseSelectReport");
break;
case 2:
this.Text = GetStringFromPublicResourceClass.GetStringFromPublicResource("MESPleaseSelectForm");
break;
}
CurrentPrjInfo.GetFormTreeView(_doctype, ref this.treeView1);
if (null != Identity)
{
TreeNode node = FindNodeOnPath(this.treeView1.Nodes, Identity.FullPath);
if (null != node)
{
this.treeView1.SelectedNode = node;
node.EnsureVisible();
}
}
}
private void button_ConnectTest_Click(object sender, EventArgs e)
{
string myServerName = comboBox_Server.Text.Trim();
string myDBName = comboBox_DB.Text.Trim();
string userId = textBox_UserName.Text.Trim();
string passWord = textBox_Password.Text.Trim();
int ConnectType = comboBox_Protocol.SelectedIndex + 1;
string portID = textBox_PortID.Text;
string strConnect = "";
if (ConnectType == 1)
{
strConnect = "Pooling = 'false';Server=" + myServerName +
";Initial Catalog=" + myDBName +
";User Id=" + userId +
";Password="******";";
}
else if (ConnectType == 2)//Pooling = 'false';
{
strConnect = "Server=tcp:" + myServerName + "," + portID +
";Initial Catalog=" + myDBName +
";User Id=" + userId +
";Password="******";";
}
//strConnect = "Server=TCP:" + myServerName + "," + portID +
// ";Initial Catalog=" + myDBName +
// ";User Id=" + userId +
// ";Password="******";";
SqlConnection conn = null;
try
{
conn = new SqlConnection(strConnect);
conn.Open();
}
catch (System.Data.SqlClient.SqlException ex)
{
MessageBox.Show(ex.ToString());
return;
}
if (conn.State == ConnectionState.Open)
{
string strText = GetStringFromPublicResourceClass.GetStringFromPublicResource("PMSDBConnectCtrl_DBConTestSucceed");
string strCaption = GetStringFromPublicResourceClass.GetStringFromPublicResource("PMS_Succeed");
MessageBox.Show(strText, strCaption, MessageBoxButtons.OK, MessageBoxIcon.Asterisk);
conn.Close();
}
else
{
string strText = GetStringFromPublicResourceClass.GetStringFromPublicResource("PMSDBConnectCtrl_DBConTestFail");
string strCaption = GetStringFromPublicResourceClass.GetStringFromPublicResource("PMS_Fail");
MessageBox.Show(strText, strCaption, MessageBoxButtons.OK, MessageBoxIcon.Warning);
}
}
private void RefreshDB()
{
string myServerName = comboBox_Server.Text.Trim();
string userId = textBox_UserName.Text.Trim();
string passWord = textBox_Password.Text.Trim();
if (myServerName.CompareTo("") == 0)
{
string strText = GetStringFromPublicResourceClass.GetStringFromPublicResource("PMSDBConnectCtrl_DBServerNameIsNull");
string strCaption = GetStringFromPublicResourceClass.GetStringFromPublicResource("PMS_Warnning");
MessageBox.Show(strText, strCaption, MessageBoxButtons.OK, MessageBoxIcon.Warning);
return;
}
this.button_RefreshDB.Enabled = false;
this.comboBox_DB.Enabled = false;
this.comboBox_DB.Items.Clear();
this.comboBox_DB.Text = GetStringFromPublicResourceClass.GetStringFromPublicResource("PMSDBConnectCtrl_RetrievingDataSources");
System.Windows.Forms.Application.DoEvents();
Cursor.Current = Cursors.WaitCursor;
if (!sqlAS.ConnectSMOServer(myServerName, userId, passWord))
{
comboBox_DB.Text = "";
this.button_RefreshDB.Enabled = true;
this.comboBox_DB.Enabled = true;
Cursor.Current = Cursors.Default;
return;
}
List <string> databases = sqlAS.GetServerDatabases();
comboBox_DB.Items.Clear();
if (null != databases)
{
foreach (string dbName in databases)
{
comboBox_DB.Items.Add(dbName);
}
}
if (this.comboBox_DB.Items.Count > 0)
{
comboBox_DB.SelectedIndex = 0;
}
else
{
comboBox_DB.Text = "";
}
this.button_RefreshDB.Enabled = true;
this.comboBox_DB.Enabled = true;
Cursor.Current = Cursors.Default;
}
private void buttonOK_Click(object sender, EventArgs e)
{
if (string.IsNullOrEmpty(sourceName))
{
string strformat = string.Format(GetStringFromPublicResourceClass.GetStringFromPublicResource("NewDBSourceForm_DBSourceCantNull"));
MessageBox.Show(strformat, GetStringFromPublicResourceClass.GetStringFromPublicResource("PMS_Warnning"), MessageBoxButtons.OK, MessageBoxIcon.Warning);
return;
}
if (IsDBSourceNameExisted(sourceName))
{
string strformat = string.Format(GetStringFromPublicResourceClass.GetStringFromPublicResource("NewDBSourceForm_DBSourceExisted"), sourceName);
MessageBox.Show(strformat, GetStringFromPublicResourceClass.GetStringFromPublicResource("PMS_Warnning"), MessageBoxButtons.OK, MessageBoxIcon.Warning);
return;
}
this.DialogResult = DialogResult.OK;
}
private void button_ConnectAccessTest_Click(object sender, EventArgs e)
{
string strMsAccessPath = textBox_MSAccessPath.Text.Trim();
strMsAccessPath = ProjectPathClass.ParseStringWithMacro(strMsAccessPath);
if (string.IsNullOrEmpty(strMsAccessPath))
{
string strText = GetStringFromPublicResourceClass.GetStringFromPublicResource("PMSDBAccessPathNULL");
string strCaption = GetStringFromPublicResourceClass.GetStringFromPublicResource("PMS_Warnning");
MessageBox.Show(strText, strCaption, MessageBoxButtons.OK, MessageBoxIcon.Warning);
return;
}
string userId = textBox_MSAccessUID.Text.Trim();
string passWord = textBox_MSAccessPass.Text.Trim();
try
{
OleDbConnectionStringBuilder connectStringBuilder = new OleDbConnectionStringBuilder();
connectStringBuilder.DataSource = strMsAccessPath;
connectStringBuilder.Provider = "Microsoft.Jet.OLEDB.4.0";
OleDbConnection _OleDbConn = new OleDbConnection(connectStringBuilder.ConnectionString);
_OleDbConn.Open();
if (_OleDbConn == null)
{
string strCaption = GetStringFromPublicResourceClass.GetStringFromPublicResource("PMS_Warnning");
MessageBox.Show(_RefDBConnection.GetLastError(), strCaption, MessageBoxButtons.OK, MessageBoxIcon.Warning);
}
if (_OleDbConn.State == ConnectionState.Open)
{
string strText = GetStringFromPublicResourceClass.GetStringFromPublicResource("PMSDBConnectCtrl_DBConTestSucceed");
string strCaption = GetStringFromPublicResourceClass.GetStringFromPublicResource("PMS_Succeed");
MessageBox.Show(strText, strCaption, MessageBoxButtons.OK, MessageBoxIcon.Asterisk);
_OleDbConn.Close();
}
}
catch (System.Data.OleDb.OleDbException ex)
{
MessageBox.Show(ex.ToString());
}
}
private void button_OK_Click(object sender, EventArgs e)
{
int iret = ConnectDB();
if (iret == 2)
{
// 连接成功关闭ParentForm
this.Close();
this.DialogResult = DialogResult.OK;
}
else if (iret == 0)
{
string strText = GetStringFromPublicResourceClass.GetStringFromPublicResource("PMSDBConnectCtrl_DBConTestFail");
string strCaption = GetStringFromPublicResourceClass.GetStringFromPublicResource("PMS_Fail");
MessageBox.Show(strText, strCaption, MessageBoxButtons.OK, MessageBoxIcon.Error);
}
//else if(iret == 0)
//{
// string strText = GetStringFromPublicResourceClass.GetStringFromPublicResource("PMSDBConnectCtrl_UserLoginFail");
// string strCaption = GetStringFromPublicResourceClass.GetStringFromPublicResource("PMS_Fail");
// MessageBox.Show(strText, strCaption, MessageBoxButtons.OK, MessageBoxIcon.Error);
//}
}
private void Btn_OleDBTest_Click(object sender, EventArgs e)
{
string strOleConnectString = comboBox_ConnectString.Text.Trim();
if (string.IsNullOrEmpty(strOleConnectString))
{
string strText = GetStringFromPublicResourceClass.GetStringFromPublicResource("PMSOleDBConnectStringNull");
string strCaption = GetStringFromPublicResourceClass.GetStringFromPublicResource("PMS_Warnning");
MessageBox.Show(strText, strCaption, MessageBoxButtons.OK, MessageBoxIcon.Warning);
return;
}
try
{
OleDbConnection _OleDbConn = new OleDbConnection(strOleConnectString);
_OleDbConn.Open();
if (_OleDbConn == null)
{
string strCaption = GetStringFromPublicResourceClass.GetStringFromPublicResource("PMS_Warnning");
MessageBox.Show(_RefDBConnection.GetLastError(), strCaption, MessageBoxButtons.OK, MessageBoxIcon.Warning);
return;
}
if (_OleDbConn.State == ConnectionState.Open)
{
string strText = GetStringFromPublicResourceClass.GetStringFromPublicResource("PMSDBConnectCtrl_DBConTestSucceed");
string strCaption = GetStringFromPublicResourceClass.GetStringFromPublicResource("PMS_Succeed");
MessageBox.Show(strText, strCaption, MessageBoxButtons.OK, MessageBoxIcon.Asterisk);
_OleDbConn.Close();
}
}
catch (System.Data.OleDb.OleDbException ex)
{
MessageBox.Show(ex.ToString());
}
}
/// <summary>
///
/// </summary>
/// <returns>
/// 0 -- 数据库连接失败
/// 1 -- 用户登录失败
/// 2 -- 连接成功
/// </returns>
private int ConnectDB()
{
this.button_OK.Enabled = false;
bConnected = false;
if (_SelectDBType == RefDBType.MSSqlServer)
{
string myServerName = comboBox_Server.Text.Trim();
if (string.IsNullOrEmpty(myServerName))
{
string strText = GetStringFromPublicResourceClass.GetStringFromPublicResource("PMSDBServerNULL");
string strCaption = GetStringFromPublicResourceClass.GetStringFromPublicResource("PMS_Warnning");
MessageBox.Show(strText, strCaption, MessageBoxButtons.OK, MessageBoxIcon.Warning);
this.button_OK.Enabled = true;
return(0);
}
string myDBName = comboBox_DB.Text.Trim();
if (string.IsNullOrEmpty(myDBName))
{
string strText = GetStringFromPublicResourceClass.GetStringFromPublicResource("PMSDBDBNameNULL");
string strCaption = GetStringFromPublicResourceClass.GetStringFromPublicResource("PMS_Warnning");
MessageBox.Show(strText, strCaption, MessageBoxButtons.OK, MessageBoxIcon.Warning);
this.button_OK.Enabled = true;
return(0);
}
string userId = textBox_UserName.Text.Trim();
if (string.IsNullOrEmpty(userId))
{
string strText = GetStringFromPublicResourceClass.GetStringFromPublicResource("PMSDBUserIDNULL");
string strCaption = GetStringFromPublicResourceClass.GetStringFromPublicResource("PMS_Warnning");
MessageBox.Show(strText, strCaption, MessageBoxButtons.OK, MessageBoxIcon.Warning);
this.button_OK.Enabled = true;
return(0);
}
string passWord = textBox_Password.Text.Trim();
ConnectType iProtocolType = (ConnectType)(comboBox_Protocol.SelectedIndex + 1);
string portID = textBox_PortID.Text.Trim();
//string strConnect = "Data Source=" + myServerName +
// ";Initial Catalog=" + myDBName +
// ";User Id=" + userId +
// ";Password="******";";
try
{
_RefDBConnection = new PMSRefDBConnection();
_RefDBConnection.RefDBType = RefDBType.MSSqlServer;
_RefDBConnection.StrServerName = myServerName;
_RefDBConnection.StrDBName = myDBName;
_RefDBConnection.StrUserID = userId;
_RefDBConnection.StrPassWord = passWord;
_RefDBConnection.EConnectType = iProtocolType;
_RefDBConnection.StrPortID = portID;
_conn = _RefDBConnection.GetSqlConnection();
//sqlStructure = new SqlStructure(myServerName, myDBName, userId, passWord, iProtocolType, portID);
//_conn = SqlStructure.GetSqlConncetion();
if (_conn == null)
{
bConnected = false;
this.button_OK.Enabled = true;
return(0);
}
//if (!SqlStructure.ConnectSMOServer())
//{
// bConnected = false;
// this.button_OK.Enabled = true;
// return 0;
//}
//SqlStructure.PMSCenterDataContext = new PMSCenterDataContext(_conn);
}
catch (System.Data.SqlClient.SqlException ex)
{
MessageBox.Show(ex.ToString());
bConnected = false;
this.button_OK.Enabled = true;
return(0);
}
catch (Exception ex)
{
MessageBox.Show(ex.ToString());
bConnected = false;
this.button_OK.Enabled = true;
return(0);
}
if (_conn.State == ConnectionState.Open)
{
// 连接数据库成功
SaveSettings();
bConnected = true;
strServerName = myServerName;
strDBName = myDBName;
strUserID = userId;
strPassWord = passWord;
// 连接成功关闭
this.Close();
this.DialogResult = DialogResult.OK;
return(2);
}
else
{
bConnected = false;
return(0);
}
}
else if (_SelectDBType == RefDBType.Oracle)
{
string myServerName = comboBox_OracleServer.Text.Trim();
if (string.IsNullOrEmpty(myServerName))
{
string strText = GetStringFromPublicResourceClass.GetStringFromPublicResource("PMSDBServerNULL");
string strCaption = GetStringFromPublicResourceClass.GetStringFromPublicResource("PMS_Warnning");
MessageBox.Show(strText, strCaption, MessageBoxButtons.OK, MessageBoxIcon.Warning);
this.button_OK.Enabled = true;
return(0);
}
string userId = textBox_OracleUserID.Text.Trim();
if (string.IsNullOrEmpty(userId))
{
string strText = GetStringFromPublicResourceClass.GetStringFromPublicResource("PMSDBUserIDNULL");
string strCaption = GetStringFromPublicResourceClass.GetStringFromPublicResource("PMS_Warnning");
MessageBox.Show(strText, strCaption, MessageBoxButtons.OK, MessageBoxIcon.Warning);
this.button_OK.Enabled = true;
return(0);
}
string passWord = textBox_OracleUserPass.Text.Trim();
string OracleConnectAs = comboBox_ConnectAs.Text.Trim();
string OracleConnectMode = comboBox_ConnectMode.Text.Trim();
string OracleHome = comboBox_OracleHome.Text.Trim();
string OracleSID = string.Empty;
string OraclePortID = string.Empty;
string OracleOwner = textBox_Owner.Text.Trim();
bool OracleDirect = checkBox_Direct.Checked;
if (OracleDirect)
{
OracleSID = comboBox_SID.Text.Trim();
if (string.IsNullOrEmpty(OracleSID))
{
string strText = GetStringFromPublicResourceClass.GetStringFromPublicResource("PMSDBOracleSIDNULL");
string strCaption = GetStringFromPublicResourceClass.GetStringFromPublicResource("PMS_Warnning");
MessageBox.Show(strText, strCaption, MessageBoxButtons.OK, MessageBoxIcon.Warning);
this.button_OK.Enabled = true;
return(0);
}
OraclePortID = textBox_OracleProtID.Text.Trim();
if (string.IsNullOrEmpty(OraclePortID))
{
string strText = GetStringFromPublicResourceClass.GetStringFromPublicResource("PMSDBOraclePortIDNULL");
string strCaption = GetStringFromPublicResourceClass.GetStringFromPublicResource("PMS_Warnning");
MessageBox.Show(strText, strCaption, MessageBoxButtons.OK, MessageBoxIcon.Warning);
this.button_OK.Enabled = true;
return(0);
}
}
try
{
_RefDBConnection = new PMSRefDBConnection();
_RefDBConnection.RefDBType = RefDBType.Oracle;
_RefDBConnection.StrServerName = myServerName;
_RefDBConnection.StrDBName = OracleSID;
_RefDBConnection.StrUserID = userId;
_RefDBConnection.StrPassWord = passWord;
_RefDBConnection.BDirect = OracleDirect;
_RefDBConnection.StrConnectAs = OracleConnectAs;
_RefDBConnection.StrConnectMode = OracleConnectMode;
_RefDBConnection.StrPortID = OraclePortID;
_RefDBConnection.Owner = OracleOwner;
_conn = _RefDBConnection.GetOracleConnection();
if (_conn == null)
{
bConnected = false;
this.button_OK.Enabled = true;
return(0);
}
}
catch (Oracle.DataAccess.Client.OracleException ex)
{
MessageBox.Show(ex.ToString());
bConnected = false;
this.button_OK.Enabled = true;
return(0);
}
catch (Exception ex)
{
MessageBox.Show(ex.ToString());
bConnected = false;
this.button_OK.Enabled = true;
return(0);
}
if (_conn.State == ConnectionState.Open)
{
// 连接数据库成功
SaveSettings();
bConnected = true;
strServerName = myServerName;
strDBName = OracleSID;
strUserID = userId;
strPassWord = passWord;
// 连接成功关闭
this.Close();
this.DialogResult = DialogResult.OK;
return(2);
}
else
{
bConnected = false;
return(0);
}
}
else if (_SelectDBType == RefDBType.MSAccess)
{
strMsAccessPath = textBox_MSAccessPath.Text.Trim();
if (string.IsNullOrEmpty(strMsAccessPath))
{
string strText = GetStringFromPublicResourceClass.GetStringFromPublicResource("PMSDBAccessPathNULL");
string strCaption = GetStringFromPublicResourceClass.GetStringFromPublicResource("PMS_Warnning");
MessageBox.Show(strText, strCaption, MessageBoxButtons.OK, MessageBoxIcon.Warning);
this.button_OK.Enabled = true;
return(0);
}
string userId = textBox_MSAccessUID.Text.Trim();
string passWord = textBox_MSAccessPass.Text.Trim();
try
{
_RefDBConnection = new PMSRefDBConnection();
_RefDBConnection.RefDBType = RefDBType.MSAccess;
_RefDBConnection.StrDBPath = strMsAccessPath;
_OleDbConn = _RefDBConnection.GetOleConnection();
// 利用 OleDbConnectionStringBuilder 对象来构建
// 连接字符串。
//acsStructure = new AccessStructure(strMsAccessPath, userId, passWord);
//if (AccessStructure.ConnectDB())
// _OleDbConn = AccessStructure.OleDbConn;
if (_OleDbConn == null)
{
string strCaption = GetStringFromPublicResourceClass.GetStringFromPublicResource("PMS_Warnning");
MessageBox.Show(_RefDBConnection.GetLastError(), strCaption, MessageBoxButtons.OK, MessageBoxIcon.Warning);
bConnected = false;
this.button_OK.Enabled = true;
return(0);
}
}
catch (System.Data.OleDb.OleDbException ex)
{
MessageBox.Show(ex.ToString());
bConnected = false;
this.button_OK.Enabled = true;
return(0);
}
if (_OleDbConn.State == ConnectionState.Open)
{
// 连接数据库成功
SaveSettings();
bConnected = true;
return(2);
}
else
{
bConnected = false;
return(0);
}
}
else if (_SelectDBType == RefDBType.OleDB)
{
ConnectionString = comboBox_ConnectString.Text.Trim();
if (string.IsNullOrEmpty(ConnectionString))
{
bConnected = false;
return(0);
}
try
{
_RefDBConnection = new PMSRefDBConnection();
_RefDBConnection.RefDBType = RefDBType.OleDB;
_RefDBConnection.ConnectString = ConnectionString;
_OleDbConn = _RefDBConnection.GetOleConnection();
if (_OleDbConn == null)
{
string strCaption = GetStringFromPublicResourceClass.GetStringFromPublicResource("PMS_Warnning");
MessageBox.Show(_RefDBConnection.GetLastError(), strCaption, MessageBoxButtons.OK, MessageBoxIcon.Warning);
bConnected = false;
this.button_OK.Enabled = true;
return(0);
}
}
catch (System.Exception ex)
{
MessageBox.Show(ex.ToString());
bConnected = false;
this.button_OK.Enabled = true;
return(0);
}
if (_OleDbConn.State == ConnectionState.Open)
{
// 连接数据库成功
SaveSettings();
bConnected = true;
return(2);
}
else
{
bConnected = false;
return(0);
}
}
return(0);
}
private void button_ConnectOracleTest_Click(object sender, EventArgs e)
{
string OracleServerName = comboBox_OracleServer.Text.Trim();
string OracleUserId = textBox_OracleUserID.Text.Trim();
string OraclePassWord = textBox_OracleUserPass.Text.Trim();
string OracleConnectAs = comboBox_ConnectAs.Text.Trim();
string OracleConnectMode = comboBox_ConnectMode.Text.Trim();
string OracleHome = comboBox_OracleHome.Text.Trim();
string OracleSID = comboBox_SID.Text.Trim();
string OraclePortID = textBox_OracleProtID.Text.Trim();
bool OracleDirect = checkBox_Direct.Checked;
string strConnect = "";
if (OracleDirect == false)
{
strConnect = //Pooling = False;
"User Id=" + OracleUserId +
";Password="******";Data Source=" + OracleServerName +
";";
if (OracleConnectAs != "Normal" && OracleConnectAs != "")
{
strConnect += "DBA Privilege=" + OracleConnectAs +
";";
}
}
else
{
strConnect = "Data Source=(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=" + OracleServerName +
")(PORT=" + OraclePortID +
")))(CONNECT_DATA=(SERVER=" + OracleConnectMode +
")(SERVICE_NAME=" + OracleSID +
")));User Id=" + OracleUserId +
";Password="******";";
}
OracleConnection conn = null;
try
{
conn = new OracleConnection(strConnect);
conn.Open();
}
catch (Oracle.DataAccess.Client.OracleException ex)
{
MessageBox.Show(ex.ToString());
return;
}
catch (Exception ex)
{
MessageBox.Show(ex.ToString());
return;
}
if (conn.State == ConnectionState.Open)
{
string strText = GetStringFromPublicResourceClass.GetStringFromPublicResource("PMSDBConnectCtrl_DBConTestSucceed");
string strCaption = GetStringFromPublicResourceClass.GetStringFromPublicResource("PMS_Succeed");
MessageBox.Show(strText, strCaption, MessageBoxButtons.OK, MessageBoxIcon.Asterisk);
conn.Close();
}
else
{
string strText = GetStringFromPublicResourceClass.GetStringFromPublicResource("PMSDBConnectCtrl_DBConTestFail");
string strCaption = GetStringFromPublicResourceClass.GetStringFromPublicResource("PMS_Fail");
MessageBox.Show(strText, strCaption, MessageBoxButtons.OK, MessageBoxIcon.Warning);
}
}
private int ConnectSqlServer(string myServerName
, string myDBName
, string userId
, string passWord)
{
if (string.IsNullOrEmpty(myServerName))
{
string strText = GetStringFromPublicResourceClass.GetStringFromPublicResource("PMSDBServerNULL");
string strCaption = GetStringFromPublicResourceClass.GetStringFromPublicResource("PMS_Warnning");
MessageBox.Show(strText, strCaption, MessageBoxButtons.OK, MessageBoxIcon.Warning);
return(0);
}
if (string.IsNullOrEmpty(myDBName))
{
string strText = GetStringFromPublicResourceClass.GetStringFromPublicResource("PMSDBDBNameNULL");
string strCaption = GetStringFromPublicResourceClass.GetStringFromPublicResource("PMS_Warnning");
MessageBox.Show(strText, strCaption, MessageBoxButtons.OK, MessageBoxIcon.Warning);
return(0);
}
if (string.IsNullOrEmpty(userId))
{
string strText = GetStringFromPublicResourceClass.GetStringFromPublicResource("PMSDBUserIDNULL");
string strCaption = GetStringFromPublicResourceClass.GetStringFromPublicResource("PMS_Warnning");
MessageBox.Show(strText, strCaption, MessageBoxButtons.OK, MessageBoxIcon.Warning);
return(0);
}
ConnectType iProtocolType = (ConnectType)(1);
string portID = "1433";
//string strConnect = "Data Source=" + myServerName +
// ";Initial Catalog=" + myDBName +
// ";User Id=" + userId +
// ";Password="******";";
try
{
//SqlStructure sqlStructure = new SqlStructure(myServerName, myDBName, userId, passWord, iProtocolType, portID);
SqlStructure.InitSqlStructure(myServerName, myDBName, userId, passWord, iProtocolType, portID);
SqlConnection _conn = SqlStructure.GetSqlConncetion();
if (_conn == null)
{
return(0);
}
if (!SqlStructure.ConnectSMOServer())
{
return(0);
}
}
catch (System.Data.SqlClient.SqlException ex)
{
MessageBox.Show(ex.ToString());
return(0);
}
return(1);
}
