public static int ExecuteScalar(string sql, DatabaseConnectParams connectParams)
{
SqlConnection conn = OledbHelper.getSqlConnection(connectParams);
if (conn == null)
{
return(0);
}
SqlCommand sqlCmd = conn.CreateCommand();
sqlCmd.CommandText = sql;
int num = 0;
try
{
conn.Open();
num = Convert.ToInt32(sqlCmd.ExecuteScalar().ToString());
}
catch (Exception ex)
{
Log.PublishTxt(ex);
num = -1;
MessageBox.Show(ex.Message, "提示");
}
finally
{
if (conn.State == ConnectionState.Open)
{
conn.Close();
}
}
return(num);
}
public static int sqlExecuteNonQuery(string sql, DatabaseConnectParams connectParams)
{
SqlConnection conn = OledbHelper.getSqlConnection(connectParams);
if (conn == null)
{
return(0);
}
SqlCommand sqlCmd = conn.CreateCommand();
sqlCmd.CommandText = sql;
int rowCount = 0;
try
{
conn.Open();
rowCount = sqlCmd.ExecuteNonQuery();
}
catch (Exception ex)
{
Log.PublishTxt(ex);
MessageBox.Show(ex.Message, "提示");
}
finally
{
if (conn.State == ConnectionState.Open)
{
conn.Close();
}
}
return(rowCount);
}
private bool backupDB()
{
DatabaseConnectParams connectParams = Utility.getConnectParamsByDatasourceFullName(globeControl1, comboBoxDataSourceList.SelectedItem.ToString().Trim());
if (connectParams == null)
{
return(false);
}
conn = OledbHelper.getSqlConnection(connectParams);
SqlCommand cmdBK = new SqlCommand();
cmdBK.CommandType = CommandType.Text;
cmdBK.Connection = conn;
DateTime currentTime = DateTime.Now;
string Dtime = currentTime.GetDateTimeFormats('D')[0].ToString();
string Htime = DateTime.Now.ToString("HH时mm分ss秒").Trim();
string fileName = Dtime + "(" + Htime + ")";
string DBBackupPath = Application.StartupPath + "\\" + comboBoxDataSourceList.SelectedItem.ToString().Trim();
if (Directory.Exists(DBBackupPath) == false)
{
Directory.CreateDirectory(DBBackupPath);
}
string pathName = DBBackupPath + "\\" + fileName + ".bak";
string databaseName = connectParams.databaseName;
cmdBK.CommandText = "backup database " + databaseName + " to disk='" + pathName + "' with init";
try
{
if (conn.State == ConnectionState.Closed)
{
conn.Open();
}
cmdBK.ExecuteNonQuery();
return(true);
}
catch (Exception ex)
{
Log.PublishTxt(ex);
MessageBox.Show(ex.Message, "提示");
return(false);
}
finally
{
conn.Close();
}
}
public static DataTable QueryTable(string cmdText, DatabaseConnectParams connectParams)
{
SqlConnection conn = OledbHelper.getSqlConnection(connectParams);
if (conn == null)
{
return(null);
}
try
{
conn.Open();
SqlCommand sqlCmd = conn.CreateCommand();
sqlCmd.CommandText = cmdText;
SqlDataReader sqlReader = sqlCmd.ExecuteReader();
DataTable table = new DataTable();
table.Load(sqlReader);
sqlReader.Close();
conn.Close();
return(table);
}
catch (Exception ex)
{
Log.PublishTxt(ex);
MessageBox.Show(ex.Message, "提示");
return(null);
}
finally
{
if (conn.State == ConnectionState.Open)
{
conn.Close();
}
}
}
