public int SaveToDB(hssDB hDB)
{
if (hDB == null || !hDB.Connected)
{
return(-2);
}
List <SqlCommand> cmd_list = new List <SqlCommand>();
int count = 0;
foreach (I_DBcmd di in this.DBcmd_list)
{
di.SetDBname(hDB.DBname);
SqlCommand cmd = di.GetSQL_cmd();
cmd_list.Add(cmd);
if (cmd_list.Count >= this.OneTimeAmount)
{
count += hDB.ExeNonQuery(cmd_list);
cmd_list.Clear();
//Console.WriteLine("Bulk_DBcmd info: count=" + count);
}
}
if (cmd_list.Count > 0)
{
count += hDB.ExeNonQuery(cmd_list);
}
return(count);
}
public static void AllTrigers(string tableName, bool enable, hssDB hDB, string schema = "dbo")
{
if (string.IsNullOrEmpty(tableName) || string.IsNullOrEmpty(schema))
{
Console.WriteLine("Helper_SQLserver error 0: no table or schema");
return;
}
if (hDB == null)
{
Console.WriteLine("Helper_SQLserver error 1: no hssDB");
return;
}
StringBuilder sb = new StringBuilder();
if (enable)
{
sb.Append("Enable ");
}
else
{
sb.Append("Disable ");
}
sb.Append("TRIGGER ALL ON [");
sb.Append(hDB.DBname).Append("].[");
sb.Append(schema).Append("].[");
sb.Append(tableName).Append("]");
int count = hDB.ExeNonQuery(sb.ToString());
}
public static long Get_nextSequenceValue(string schema, string sequenceName, hssDB hDB)
{
if (string.IsNullOrEmpty(sequenceName) || string.IsNullOrEmpty(schema))
{
Console.WriteLine("Helper_SQLserver error 4: no table or schema");
return(-1);
}
if (hDB == null)
{
Console.WriteLine("Helper_SQLserver error 5: no hssDB");
return(-1);
}
sequenceName = sequenceName.Replace("]", "]]");
schema = schema.Replace("]", "]]");
string sql = "SELECT NEXT VALUE FOR [" + schema + "].[" + sequenceName + "]";
SqlCommand cmd = new SqlCommand(sql);
cmd.Connection = hDB.DB_connection;
cmd.CommandTimeout = hssDB.CommandTimeout;
SqlDataReader reader = cmd.ExecuteReader();
long val = -2;
if (reader.Read())
{
val = (long)reader[0];
}
reader.Close();
return(val);
}
public int SaveToDB(hssDB hDB)
{
if (hDB == null || !hDB.Connected)
{
return(-1);
}
this.DBname = hDB.DBname;
SqlCommand cmd = this.GetSQL_cmd();
cmd.Connection = hDB.DB_connection;
int count = hDB.ExeNonQuery(cmd, false);
return(count);
}
public DB_reader(DB_select selt, hssDB hDB)
{
if (hDB == null || !hDB.Connected)
{
return;
}
if (selt == null)
{
return;
}
selt.DBname = hDB.DBname;
this.db_sel = selt;
SqlCommand cmd = selt.GetSQL_cmd();
cmd.Connection = hDB.DB_connection;
cmd.CommandTimeout = hssDB.CommandTimeout;
this.reader = cmd.ExecuteReader();
}
public static void SetTriger(string tableName, string triggerName, bool enable, hssDB hDB, string schema = "dbo")
{
if (string.IsNullOrEmpty(tableName) || string.IsNullOrEmpty(schema) || string.IsNullOrEmpty(triggerName))
{
Console.WriteLine("Helper_SQLserver error 2: no table, triggerName or schema");
return;
}
if (hDB == null)
{
Console.WriteLine("Helper_SQLserver error 3: no hssDB");
return;
}
tableName = tableName.Replace("]", "]]");
triggerName = triggerName.Replace("]", "]]");
schema = schema.Replace("]", "]]");
StringBuilder sb = new StringBuilder();
if (enable)
{
sb.Append("Enable ");
}
else
{
sb.Append("Disable ");
}
sb.Append("TRIGGER [").Append(schema).Append("].[").Append(triggerName).Append("] ON [");
sb.Append(hDB.DBname).Append("].[").Append(schema).Append("].[").Append(tableName).Append("]");
int count = hDB.ExeNonQuery(sb.ToString());
}
