public override void Run()
{
if (Running)
{
if (q.Execute(clearBrLogDet))
{
Loging.Loging.WriteLog("OK: " + clearBrLogDet, false, false);
}
else
{
Loging.Loging.WriteLog("Error: " + clearBrLogDet, true, true);
}
if (q.Execute(clearBrLog))
{
Loging.Loging.WriteLog("OK: " + clearBrLog, false, false);
}
else
{
Loging.Loging.WriteLog("Error: " + clearBrLog, true, true);
}
}
Coordinator.ExecuteDelegateArgs args = new Coordinator.ExecuteDelegateArgs();
args.Maximum = 1;
args.Pos = 1;
args.runningAction = this;
args.Name = Name();
OnExecute(this, args);
}
public override void Run()
{
int count = 1;
StreamReader file = new StreamReader(fileName);
string SQL = "";
while (!file.EndOfStream)
{
string RSQL = file.ReadLine();
if (RSQL.ToUpper().Trim(' ') == "GO")
{
// run SQL
if (!QueryExec.Create(BaseType.PDA).Execute(SQL))
{
Loging.Loging.WriteLog("SQL Error: " + SQL, true, true);
}
// clear SQL
SQL = "";
// event
Coordinator.ExecuteDelegateArgs args = new Coordinator.ExecuteDelegateArgs();
args.Maximum = Lines;//передавать в args кол-во таблиц и номер текущей (для прогресс бара)
args.Pos = count;
args.runningAction = this;
args.Name = Name();
OnExecute(this, args);
count++;
}
else
{
SQL += RSQL;
}
}
}
public override void Run()
{
int count = 1;
StreamReader file = new StreamReader(fileName);
string SQL = "";
while (!file.EndOfStream)
{
string RSQL = file.ReadLine();
if(RSQL.ToUpper().Trim(' ') == "GO")
{
// run SQL
if(!QueryExec.Create(BaseType.PDA).Execute(SQL))
{
Loging.Loging.WriteLog("SQL Error: " + SQL, true, true);
}
// clear SQL
SQL = "";
// event
Coordinator.ExecuteDelegateArgs args = new Coordinator.ExecuteDelegateArgs();
args.Maximum = Lines;//передавать в args кол-во таблиц и номер текущей (для прогресс бара)
args.Pos = count;
args.runningAction = this;
args.Name = Name();
OnExecute(this, args);
count++;
}
else
{
SQL += RSQL;
}
}
}
public override void Run()
{
int count = 1;
foreach (PDATable table in tables)
{
// select data
QuerySelect query = QuerySelect.Create(BaseType.PDA);
query.Select("select * from " + table.Name);
List <DataRows> rows = query.GetRows();
foreach (DataRows row in rows)
{
// create insert script
writer.WriteLine("INSERT INTO " + table.Name + " ");
writer.WriteLine("( ");
string Fields = " ";
foreach (PDAField field in table.fields)
{
Fields += (field.Name + ", ");
}
Fields = Fields.Remove(Fields.Length - 2, 2);
writer.WriteLine(Fields);
writer.WriteLine(") ");
writer.WriteLine("VALUES ");
writer.WriteLine("( ");
string Values = " ";
foreach (PDAField field in table.fields)
{
string val = "'" + row.FieldByName(field.Name).Replace("'", "''") + "'";
if (val == "''")
{
if ((field.DataType == "numeric") || (field.DataType == "datetime"))
{
val = "NULL";
}
}
if ((field.DataType == "numeric"))
{
val = val.Replace(',', '.');
}
Values += (val + ", ");
}
Values = Values.Remove(Values.Length - 2, 2);
writer.WriteLine(Values);
writer.WriteLine(") ");
writer.WriteLine("GO");
}
Loging.Loging.WriteLog("TABLE: " + table.Name + " exported " + rows.Count + " rows", false, true);
Coordinator.ExecuteDelegateArgs args = new Coordinator.ExecuteDelegateArgs();
args.Maximum = tables.Count;//передавать в args кол-во таблиц и номер текущей (для прогресс бара)
args.Pos = count;
args.runningAction = this;
args.Name = Name();
OnExecute(this, args);
count++;
}
}
private void Exec()
{
count = 1;
foreach (TableInfo info in lst)
{
if (Running)
{
QueryExecOracle q = new QueryExecOracle();
string delete = info.sqlText[TableInfo.QryType.Clear];
List <string> del = new List <string>();
if (delete.Trim() != "") // Проверка на пустой запрос
{
if (delete.Contains("{0}"))
{
for (int i = 0; i < bridges.Count; i++)
{
del.Add(string.Format(delete, bridges[i].IDBR));
}
}
else
{
if (delete.Contains("{1}"))
{
del.Add(string.Format(delete, "", MainParams.GetParam(MainParams.ParamName.idGu)));
}
}
}
// else del.Add(delete);
foreach (string s in del)
{
if (Running)
{
if (q.Execute(s))
{
Loging.Loging.WriteLog("OK: " + s, false, false);
}
}
else
{
Loging.Loging.WriteLog("Error: " + s, true, true);
}
}
Coordinator.ExecuteDelegateArgs args = new Coordinator.ExecuteDelegateArgs();
args.runningAction = this;
args.Name = Name();
args.Maximum = lst.Count;//передавать в args кол-во таблиц и номер текущей (для прогресс бара)
args.Pos = count;
OnExecute(this, args);
count++;
}
else
{
break;
}
}
}
public void Exec()
{
count = 1;
foreach (TableInfo info in lst)
{
string ins = "";
if (Running)
{
QuerySelectPDA q = new QuerySelectPDA();
QueryExecOracle qu = new QueryExecOracle();
if (!q.Select("select * from " + info.tableName))
{
Loging.Loging.WriteLog("Error:select * from " + info.tableName, true, true);
}
else
{
Loging.Loging.WriteLog("OK:select * from " + info.tableName, false, false);
List <DataRows> dr = q.GetRows();
foreach (DataRows rows in dr)
{
string temp = "";
ins = "insert into " + info.tableName + "(";
foreach (FieldInfo field in info.fields)
{
ins += field.fieldName + ", ";
temp += "'" + rows.FieldByName(field.fieldName).Replace("'", "''") + "', ";
}
ins = ins.Remove(ins.LastIndexOf(','), 1);
temp = temp.Remove(temp.LastIndexOf(','), 1);
ins += ") values (" + temp + ")";
if (!qu.Execute(ins))
{
Loging.Loging.WriteLog("Error:" + ins, true, true);
}
else
{
Loging.Loging.WriteLog("OK:" + ins, false, false);
}
}
}
Coordinator.ExecuteDelegateArgs args = new Coordinator.ExecuteDelegateArgs();
args.Maximum = lst.Count;//передавать в args кол-во таблиц и номер текущей (для прогресс бара)
args.Pos = count;
args.runningAction = this;
args.Name = Name();
OnExecute(this, args);
count++;
}
else
{
break;
}
}
}
public void Exec()
{
count = 1;
foreach (TableInfo info in lst)
{
if (Running)
{
QueryExecOracle q = new QueryExecOracle();
string select = info.sqlText[TableInfo.QryType.SelectBM];
List <string> sel = new List <string>();
if (select.Contains("{0}"))
{
foreach (int i in idBr)
{
sel.Add(string.Format(select, i));
}
}
else
{
sel.Add(string.Format(select, "", MainParams.GetParam(MainParams.ParamName.idGu)));
}
List <string> ins = new List <string>();
foreach (string s in sel)
{
ins.Add("insert into BMEXPORT." + info.tableName + " " + s);
}
foreach (string s in ins)
{
if (q.Execute(s))
{
Loging.Loging.WriteLog("OK: " + s, false, false);
}
else
{
Loging.Loging.WriteLog("Error: " + s, true, true);
}
}
Coordinator.ExecuteDelegateArgs args = new Coordinator.ExecuteDelegateArgs();
args.runningAction = this;
args.Name = Name();
args.Maximum = lst.Count;//передавать в args кол-во таблиц и номер текущей (для прогресс бара)
args.Pos = count;
OnExecute(this, args);
count++;
}
else
{
break;
}
}
}
public void Exec()
{
count = 1;
foreach (TableInfo info in lst)
{
string ins = "";
if (Running)
{
QuerySelectPDA q = new QuerySelectPDA();
QueryExecOracle qu = new QueryExecOracle();
if (!q.Select("select * from " + info.tableName))
{
Loging.Loging.WriteLog("Error:select * from " + info.tableName, true, true);
}
else
{
Loging.Loging.WriteLog("OK:select * from " + info.tableName, false, false);
List<DataRows> dr = q.GetRows();
foreach (DataRows rows in dr)
{
string temp = "";
ins = "insert into " + info.tableName + "(";
foreach (FieldInfo field in info.fields)
{
ins += field.fieldName + ", ";
temp += "'" + rows.FieldByName(field.fieldName).Replace("'","''") + "', ";
}
ins = ins.Remove(ins.LastIndexOf(','), 1);
temp = temp.Remove(temp.LastIndexOf(','), 1);
ins += ") values (" + temp + ")";
if (!qu.Execute(ins))
{
Loging.Loging.WriteLog("Error:" + ins, true, true);
}
else Loging.Loging.WriteLog("OK:" + ins, false, false);
}
}
Coordinator.ExecuteDelegateArgs args = new Coordinator.ExecuteDelegateArgs();
args.Maximum = lst.Count;//передавать в args кол-во таблиц и номер текущей (для прогресс бара)
args.Pos = count;
args.runningAction = this;
args.Name = Name();
OnExecute(this, args);
count++;
}
else break;
}
}
public override void Run()
{
int count = 1;
foreach (PDATable table in tables)
{
writer.WriteLine("DROP TABLE " + table.Name);
writer.WriteLine("GO");
Coordinator.ExecuteDelegateArgs args = new Coordinator.ExecuteDelegateArgs();
args.Maximum = tables.Count;//передавать в args кол-во таблиц и номер текущей (для прогресс бара)
args.Pos = count;
args.runningAction = this;
args.Name = Name();
OnExecute(this, args);
count++;
}
}
public override void Run()
{
int count = 1;
foreach (PDATable table in tables)
{
writer.WriteLine("DROP TABLE " + table.Name);
writer.WriteLine("GO");
Coordinator.ExecuteDelegateArgs args = new Coordinator.ExecuteDelegateArgs();
args.Maximum = tables.Count;//передавать в args кол-во таблиц и номер текущей (для прогресс бара)
args.Pos = count;
args.runningAction = this;
args.Name = Name();
OnExecute(this, args);
count++;
}
}
public override void Run()
{
/// алгоритм
/// просто устанавливает в MainParams
/// - impDate = текущая дата и время
/// - impState = done если нет в логе ошибок (Logging.WasError)
/// event в самом конце (Max = 1 Pos = 1)
/// Running не обрабатывается
MainParams.SetParam(MainParams.ParamName.impDate, DateTime.Now.ToShortDateString());
if (!Loging.Loging.WasError())
MainParams.SetParam(MainParams.ParamName.impState, "done");
Coordinator.ExecuteDelegateArgs args = new Coordinator.ExecuteDelegateArgs();
args.Maximum = 1;
args.Pos = 1;
args.runningAction = this;
args.Name = Name();
Loging.Loging.WriteLog("DONE", false, true);
OnExecute(this, args);
}
public void Exec()
{
count = 1;
foreach (TableInfo info in lst)
{
if (Running)
{
QueryExecOracle q=new QueryExecOracle();
string select = info.sqlText[TableInfo.QryType.SelectBM];
List<string> sel = new List<string>();
if (select.Contains("{0}"))
{
foreach (int i in idBr)
{
sel.Add(string.Format(select, i));
}
}
else sel.Add(string.Format(select, "", MainParams.GetParam(MainParams.ParamName.idGu)));
List<string> ins = new List<string>();
foreach (string s in sel)
{
ins.Add("insert into BMEXPORT." + info.tableName + " " + s);
}
foreach (string s in ins)
{
if(q.Execute(s))
{
Loging.Loging.WriteLog("OK: " + s, false, false);
}
else Loging.Loging.WriteLog("Error: " + s, true, true);
}
Coordinator.ExecuteDelegateArgs args = new Coordinator.ExecuteDelegateArgs();
args.runningAction = this;
args.Name = Name();
args.Maximum = lst.Count;//передавать в args кол-во таблиц и номер текущей (для прогресс бара)
args.Pos = count;
OnExecute(this, args);
count++;
}
else break;
}
}
public override void Run()
{
int count = 1;
foreach (PDATable table in tables)
{
writer.WriteLine("CREATE TABLE " + table.Name + " (");
int i = 1;
int Count = table.fields.Count;
bool HasPK = false;
string PKStr = "";
foreach (PDAField field in table.fields)
{
writer.WriteLine(" " + field.Name + "\t\t " + field.FullDataType +
" \t" + (field.Nullable?"NULL":"NOT NULL") +
((i < Count)?", ":""));
i++;
if (field.IsPK)
{
HasPK = true;
PKStr += field.Name + ", ";
}
}
writer.WriteLine(")");
writer.WriteLine("GO");
if (HasPK)
{
PKStr = PKStr.Remove(PKStr.Length - 2, 2);
writer.WriteLine("ALTER TABLE " + table.Name + " ADD PRIMARY KEY (" + PKStr + ")");
writer.WriteLine("GO");
}
Coordinator.ExecuteDelegateArgs args = new Coordinator.ExecuteDelegateArgs();
args.Maximum = tables.Count;//передавать в args кол-во таблиц и номер текущей (для прогресс бара)
args.Pos = count;
args.runningAction = this;
args.Name = Name();
OnExecute(this, args);
count++;
}
}
public override void Run()
{
/// алгоритм
/// просто устанавливает в MainParams
/// - impDate = текущая дата и время
/// - impState = done если нет в логе ошибок (Logging.WasError)
/// event в самом конце (Max = 1 Pos = 1)
/// Running не обрабатывается
MainParams.SetParam(MainParams.ParamName.impDate, DateTime.Now.ToShortDateString());
if (!Loging.Loging.WasError())
{
MainParams.SetParam(MainParams.ParamName.impState, "done");
}
Coordinator.ExecuteDelegateArgs args = new Coordinator.ExecuteDelegateArgs();
args.Maximum = 1;
args.Pos = 1;
args.runningAction = this;
args.Name = Name();
Loging.Loging.WriteLog("DONE", false, true);
OnExecute(this, args);
}
public override void Run()
{
if (Running)
{
if (q.Execute(clearBrLogDet))
{
Loging.Loging.WriteLog("OK: " + clearBrLogDet, false, false);
}
else Loging.Loging.WriteLog("Error: " + clearBrLogDet, true, true);
if (q.Execute(clearBrLog))
{
Loging.Loging.WriteLog("OK: " + clearBrLog, false, false);
}
else Loging.Loging.WriteLog("Error: " + clearBrLog, true, true);
}
Coordinator.ExecuteDelegateArgs args = new Coordinator.ExecuteDelegateArgs();
args.Maximum = 1;
args.Pos = 1;
args.runningAction = this;
args.Name = Name();
OnExecute(this, args);
}
public void Exec()
{
count = 1;
foreach (TableInfo info in lst)
{
if (Running)
{
QueryExecOracle q = new QueryExecOracle();
QueryExecPDA qu = new QueryExecPDA();
if (!q.Execute("delete from BMEXPORT." + info.tableName))
{
Loging.Loging.WriteLog("Error:delete from BMEXPORT." + info.tableName, true, true);
}
else
{
Loging.Loging.WriteLog("OK:delete from BMEXPORT." + info.tableName, false, false);
}
if (!qu.Execute("delete from " + info.tableName))
{
Loging.Loging.WriteLog("Error:delete from " + info.tableName, true, true);
}
else
{
Loging.Loging.WriteLog("OK:delete from " + info.tableName, false, false);
}
Coordinator.ExecuteDelegateArgs args = new Coordinator.ExecuteDelegateArgs();
args.Maximum = lst.Count;//передавать в args кол-во таблиц и номер текущей (дл¤ прогресс бара)
args.Pos = count;
args.runningAction = this;
args.Name = Name();
OnExecute(this, args);
count++;
}
else
{
break;
}
}
}
public void Exec()
{
count = 1;
foreach (TableInfo info in lst)
{
if (Running)
{
QueryExecOracle q = new QueryExecOracle();
QueryExecPDA qu = new QueryExecPDA();
if (!q.Execute("delete from BMEXPORT." + info.tableName))
{
Loging.Loging.WriteLog("Error:delete from BMEXPORT." + info.tableName, true, true);
}
else
{
Loging.Loging.WriteLog("OK:delete from BMEXPORT." + info.tableName, false, false);
}
if(!qu.Execute("delete from " + info.tableName))
{
Loging.Loging.WriteLog("Error:delete from " + info.tableName, true, true);
}
else
{
Loging.Loging.WriteLog("OK:delete from " + info.tableName, false, false);
}
Coordinator.ExecuteDelegateArgs args = new Coordinator.ExecuteDelegateArgs();
args.Maximum = lst.Count;//передавать в args кол-во таблиц и номер текущей (дл¤ прогресс бара)
args.Pos = count;
args.runningAction = this;
args.Name = Name();
OnExecute(this, args);
count++;
}
else break;
}
}
public override void Run()
{
int count = 1;
foreach (PDATable table in tables)
{
// select data
QuerySelect query = QuerySelect.Create(BaseType.PDA);
query.Select("select * from " + table.Name);
List<DataRows> rows = query.GetRows();
foreach (DataRows row in rows)
{
// create insert script
writer.WriteLine("INSERT INTO " + table.Name + " ");
writer.WriteLine("( ");
string Fields = " ";
foreach (PDAField field in table.fields)
{
Fields +=(field.Name + ", " );
}
Fields = Fields.Remove(Fields.Length - 2, 2);
writer.WriteLine(Fields);
writer.WriteLine(") ");
writer.WriteLine("VALUES ");
writer.WriteLine("( ");
string Values = " ";
foreach (PDAField field in table.fields)
{
string val = "'" + row.FieldByName(field.Name).Replace("'", "''") + "'";
if(val == "''")
if((field.DataType == "numeric")||(field.DataType == "datetime"))
val = "NULL";
if((field.DataType == "numeric"))
val = val.Replace(',', '.');
Values += (val + ", " );
}
Values = Values.Remove(Values.Length - 2, 2);
writer.WriteLine(Values);
writer.WriteLine(") ");
writer.WriteLine("GO");
}
Loging.Loging.WriteLog("TABLE: " + table.Name + " exported " + rows.Count + " rows", false, true);
Coordinator.ExecuteDelegateArgs args = new Coordinator.ExecuteDelegateArgs();
args.Maximum = tables.Count;//передавать в args кол-во таблиц и номер текущей (для прогресс бара)
args.Pos = count;
args.runningAction = this;
args.Name = Name();
OnExecute(this, args);
count++;
}
}
public override void Run()
{
/// алгоритм
/// Disconnect от КПК базы
/// на основании ConnectionSettings скопировать
/// базу с винчейстера на КПК
/// event в самом конце (Max = 1 Pos = 1)
/// Running не обрабатывается
///
/// Дополнение: если ToPDA == true то копирование идет не на КПК а из КПК
DataBasePDA.Disconnect();
RAPI rapi = new RAPI();
if (!ToPDA)
{
try
{
if (rapi.DevicePresent)
{
rapi.Connect();
}
rapi.CopyFileToDevice(ConnectionSettings.GetSettings().PDAConnectionString,
ConnectionSettings.GetSettings().PDAConString, true);
Loging.Loging.WriteLog("Coping to PDA complete", false, true);
File.Delete(ConnectionSettings.GetSettings().PDAConnectionString);
}
catch (Exception e)
{
Loging.Loging.WriteLog("Coping to PDA failed: " + e.Message, false, true);
}
}
else
{
try
{
if (rapi.DevicePresent)
{
rapi.Connect();
}
rapi.CopyFileFromDevice(ConnectionSettings.GetSettings().PDAConnectionString,
ConnectionSettings.GetSettings().PDAConString, true);
Loging.Loging.WriteLog("Coping from PDA complete", false, true);
}
catch (Exception e)
{
if (e.Message == "Could not open remote file ")
{
if (ConnectionSettings.GetSettings().PDAConString == "\\Storage Card\\BelmostPDA.sdf")
{
ConnectionSettings.GetSettings().PDAConString = "\\Sd Card\\BelmostPDA.sdf";
}
else
{
ConnectionSettings.GetSettings().PDAConString = "\\Storage Card\\BelmostPDA.sdf";
}
try
{
rapi.CopyFileFromDevice(ConnectionSettings.GetSettings().PDAConnectionString,
ConnectionSettings.GetSettings().PDAConString, true);
Loging.Loging.WriteLog("Coping from PDA complete", false, true);
}
catch (Exception ex)
{
Loging.Loging.WriteLog("Coping from PDA failed: " + ex.Message, false, true);
Coordinator.Canceled = true;
}
}
else
{
Loging.Loging.WriteLog("Coping from PDA failed: " + e.Message, false, true);
Coordinator.Canceled = true;
}
}
}
Coordinator.ExecuteDelegateArgs args = new Coordinator.ExecuteDelegateArgs();
args.Maximum = 1;
args.Pos = 1;
args.runningAction = this;
args.Name = Name();
OnExecute(this, args);
}
private void Exec()
{
count = 1;
foreach (TableInfo info in lst)
{
if (Running)
{
QueryExecOracle q = new QueryExecOracle();
string delete = info.sqlText[TableInfo.QryType.Clear];
List<string> del = new List<string>();
if(delete.Trim() != "") // Проверка на пустой запрос
if (delete.Contains("{0}"))
{
for (int i = 0; i < bridges.Count; i++)
del.Add(string.Format(delete, bridges[i].IDBR));
}
else
{
if(delete.Contains("{1}"))
del.Add(string.Format(delete, "", MainParams.GetParam(MainParams.ParamName.idGu)));
}
// else del.Add(delete);
foreach (string s in del)
{
if (Running)
{
if (q.Execute(s))
{
Loging.Loging.WriteLog("OK: " + s, false, false);
}
}
else Loging.Loging.WriteLog("Error: " + s, true, true);
}
Coordinator.ExecuteDelegateArgs args = new Coordinator.ExecuteDelegateArgs();
args.runningAction = this;
args.Name = Name();
args.Maximum = lst.Count;//передавать в args кол-во таблиц и номер текущей (для прогресс бара)
args.Pos = count;
OnExecute(this, args);
count++;
}
else break;
}
}
public override void Run()
{
/// алгоритм
/// Disconnect от КПК базы
/// на основании ConnectionSettings скопировать
/// базу с винчейстера на КПК
/// event в самом конце (Max = 1 Pos = 1)
/// Running не обрабатывается
///
/// Дополнение: если ToPDA == true то копирование идет не на КПК а из КПК
DataBasePDA.Disconnect();
RAPI rapi=new RAPI();
if(!ToPDA)
try
{
if(rapi.DevicePresent)
rapi.Connect();
rapi.CopyFileToDevice(ConnectionSettings.GetSettings().PDAConnectionString,
ConnectionSettings.GetSettings().PDAConString, true);
Loging.Loging.WriteLog("Coping to PDA complete", false, true);
File.Delete(ConnectionSettings.GetSettings().PDAConnectionString);
}
catch (Exception e)
{
Loging.Loging.WriteLog("Coping to PDA failed: " + e.Message, false, true);
}
else
try
{
if(rapi.DevicePresent)
rapi.Connect();
rapi.CopyFileFromDevice(ConnectionSettings.GetSettings().PDAConnectionString,
ConnectionSettings.GetSettings().PDAConString, true);
Loging.Loging.WriteLog("Coping from PDA complete", false, true);
}
catch (Exception e)
{
if (e.Message == "Could not open remote file ")
{
if (ConnectionSettings.GetSettings().PDAConString == "\\Storage Card\\BelmostPDA.sdf")
{
ConnectionSettings.GetSettings().PDAConString = "\\Sd Card\\BelmostPDA.sdf";
}
else ConnectionSettings.GetSettings().PDAConString = "\\Storage Card\\BelmostPDA.sdf";
try
{
rapi.CopyFileFromDevice(ConnectionSettings.GetSettings().PDAConnectionString,
ConnectionSettings.GetSettings().PDAConString, true);
Loging.Loging.WriteLog("Coping from PDA complete", false, true);
}
catch(Exception ex)
{
Loging.Loging.WriteLog("Coping from PDA failed: " + ex.Message, false, true);
Coordinator.Canceled = true;
}
}
else
{
Loging.Loging.WriteLog("Coping from PDA failed: " + e.Message, false, true);
Coordinator.Canceled = true;
}
}
Coordinator.ExecuteDelegateArgs args = new Coordinator.ExecuteDelegateArgs();
args.Maximum = 1;
args.Pos = 1;
args.runningAction = this;
args.Name = Name();
OnExecute(this, args);
}
public override void Run()
{
int count = 1;
foreach (PDATable table in tables)
{
writer.WriteLine("CREATE TABLE " + table.Name + " (");
int i = 1;
int Count = table.fields.Count;
bool HasPK = false;
string PKStr = "";
foreach (PDAField field in table.fields)
{
writer.WriteLine(" " + field.Name + "\t\t " + field.FullDataType +
" \t" + (field.Nullable?"NULL":"NOT NULL") +
((i<Count)?", ":""));
i++;
if (field.IsPK)
{
HasPK = true;
PKStr += field.Name + ", ";
}
}
writer.WriteLine(")");
writer.WriteLine("GO");
if(HasPK)
{
PKStr = PKStr.Remove(PKStr.Length - 2, 2);
writer.WriteLine("ALTER TABLE " +table.Name + " ADD PRIMARY KEY (" + PKStr + ")");
writer.WriteLine("GO");
}
Coordinator.ExecuteDelegateArgs args = new Coordinator.ExecuteDelegateArgs();
args.Maximum = tables.Count;//передавать в args кол-во таблиц и номер текущей (для прогресс бара)
args.Pos = count;
args.runningAction = this;
args.Name = Name();
OnExecute(this, args);
count++;
}
}
