public List <String> ExecuteSerialize(X_DBASE x_dbase, int index)
{
List <String> ret = new List <string>();
if (x_dbase.sqlConnection.State != ConnectionState.Open)
{
x_dbase.sqlConnection.Open();
}
using (SqlDataReader reader = x_dbase.sqlCommand.ExecuteReader())
{
while (reader.Read())
{
if (!Convert.IsDBNull(reader[index]))
{
if (index != 0)
{
ret.Add((Convert.ToString(reader.GetString(index))));
}
else
{
ret.Add(Convert.ToString(reader.GetInt32(index)));
}
}
}
}
return(ret);
}
public String ExecuteWithoutClose(X_DBASE x_dbase)
{
if (x_dbase.sqlConnection.State != ConnectionState.Open)
{
x_dbase.sqlConnection.Open();
}
String ack = Convert.ToString(x_dbase.sqlCommand.ExecuteScalar());
return(ack);
}
public String ExecuteThenClose(X_DBASE x_dbase)
{
String ack = "";
if (x_dbase.sqlConnection.State != ConnectionState.Open)
{
x_dbase.sqlConnection.Open();
}
ack = Convert.ToString(x_dbase.sqlCommand.ExecuteScalar());
x_dbase.sqlConnection.Close();
x_dbase.sqlConnection.Dispose();
return(ack);
}
internal X_DBASE Initial()
{
X_DBASE x_dbase = new X_DBASE();
SqlConnection sc = new SqlConnection();
SqlCommand cmd = new SqlCommand();
sc.ConnectionString = sqlCommand.StringConnection;
cmd.Connection = sc;
cmd.CommandType = CommandType.Text;
x_dbase.sqlCommand = cmd;
x_dbase.sqlConnection = sc;
return(x_dbase);
}
public bool CheckConnectionDb()
{
bool ret = false;
X_DBASE x_dbase = Initial();
x_dbase.sqlCommand.CommandText = sqlCommand.Select(sqlCommand.Apk_Activity.TABLE_NAME);
try
{
x_dbase.sqlConnection.Open();
ret = true;
}
catch (Exception ex)
{
ret = false;
}
x_dbase.sqlConnection.Close();
x_dbase.sqlConnection.Dispose();
return(ret);
}
public void Close(X_DBASE x_dbase)
{
x_dbase.sqlConnection.Close();
x_dbase.sqlConnection.Dispose();
}
