public static void SqlCmdExample()
{
var transaction = new SqlTrans();
var cmd1 = new SqlCmd("UPDATE ... ");
var cmd2 = new SqlCmd("INSERT ...");
transaction.Add(cmd1);
transaction.Add(cmd2);
cmd1.ExecuteNonQuery();
cmd2.ExecuteNonQuery();
transaction.Commit();
}
public static void SqlCmdExample()
{
var transaction = new SqlTrans();
var cmd1 = new SqlCmd("UPDATE ... ");
var cmd2 = new SqlCmd("INSERT ...");
transaction.Add(cmd1);
transaction.Add(cmd2);
cmd1.ExecuteNonQuery();
cmd2.ExecuteNonQuery();
transaction.Commit();
}
public void SetTransaction(SqlTrans transaction)
{
this.transaction = transaction;
}
public void SetTransaction(SqlTrans transaction)
{
this.transaction = transaction;
}
public static void Unpack(Level level, BackgroundTask worker, bool insert)
{
SqlTrans transaction = new SqlTrans();
Assembly[] assemblies = SysExtension.GetInstalledAssemblies();
int i = 0;
foreach (Assembly asm in assemblies)
{
int progress = (int)(i * 100.0 / assemblies.Length);
worker.SetProgress(progress, 0, asm.GetName().Name);
Unpack(level, asm, worker, transaction, insert);
i++;
}
transaction.Commit();
return;
}
private static void Unpack(Level level, Assembly asm, BackgroundTask worker, SqlTrans transaction, bool insert)
{
foreach (Type type in asm.GetExportedTypes())
{
if (type.HasInterface<IPacking>() && type != typeof(BasePackage<>))
{
IPacking packing = (IPacking)Activator.CreateInstance(type);
if (level == packing.Level)
{
worker.SetProgress(0, string.Format("Unpacking #record={0} of table [{1}].", packing.Count, packing.TableName));
packing.Unpack(worker, transaction, insert);
}
}
}
return;
}
public static void Unpack(Assembly asm, bool insert)
{
SqlTrans transaction = new SqlTrans();
foreach (Type type in asm.GetExportedTypes())
{
if (type.HasInterface<IPacking>())
{
IPacking packing = (IPacking)Activator.CreateInstance(type);
packing.Unpack(transaction, insert);
}
}
transaction.Commit();
return;
}
