public static void Close()
{
if (Instance == null)
{
return;
}
Instance.sqlConnection.Close();
Instance.sqlConnection.Dispose();
Instance = null;
}
public static void RollBack()
{
if (Instance == null)
{
Instance = new CDBS();
}
if (Instance.tr != null)
{
Instance.tr.Rollback();
Instance.tr.Dispose();
Instance.tr = null;
}
}
public static void Commit()
{
if (Instance == null)
{
Instance = new CDBS();
}
if (Instance.tr != null)
{
Instance.tr.Commit();
Instance.tr.Dispose();
Instance.tr = null;
}
}
public static void BeginTransaction()
{
if (Instance == null)
{
Instance = new CDBS();
}
if (Instance.tr != null)
{
Instance.tr.Commit();
Instance.tr.Dispose();
}
Instance.tr = Instance.sqlConnection.BeginTransaction();
}
public static void Create(string _fname_udl)
{
Instance = new CDBS(_fname_udl);
}