public AccessSQL(Config.ConfigItem configSystem)
{
configSys = configSystem;
_sqlCommand = new SqlCommand();
_sqlDataAdapter = new SqlDataAdapter();
_sqlConnection = new SqlConnection();
}
public static string getNextIDTakeIn(Config.ConfigItem _confItem)
{
try
{
COMMAND.SQL.AccessSQL _sql = new SQL.AccessSQL(_confItem);
DataTable tb = _sql.GetDataByStoredProcedure("USP_SEL_TAKE_IN_ID");
return(Convert.Convert.CnvToString(tb.Rows[0][0]));
}
catch (Exception ex)
{
throw ex;
}
}
/// <summary>
/// Thiet lap ket noi
/// </summary>
///
public void Connect(Config.ConfigItem config)
{
try
{
if (_sqlConnection.State == ConnectionState.Open)
{
_sqlConnection.Close();
}
_sqlConnection = new SqlConnection(config.StrConnection);
_sqlConnection.Open();
}
catch
{
_sqlConnection.Dispose();
}
}
/// <summary>
/// Thiet lap ket noi
/// </summary>
///
public void Connect(SqlConnection cn, Config.ConfigItem config)
{
try
{
if (cn == null)
{
cn = new SqlConnection(config.StrConnection);
}
if (cn.State == ConnectionState.Open)
{
cn.Close();
}
cn = new SqlConnection(config.StrConnection);
cn.Open();
}
catch
{
cn.Dispose();
}
}
