private string getQuery(InsertContext ic, string key, TableField[] fields)
{
string queryString = "INSERT INTO " + Constants.TEWDOCSPA_TABLE_NAME + " ([" + Constants.KEY_FIELD_NAME + "],";
for (int j = 0; j < fields.Length; j++)
{
queryString = queryString + "[" + fields[j].getFieldName() + "]";
if (j < fields.Length - 1)
{
queryString = queryString + ",";
}
}
queryString = queryString + ") VALUES (";
queryString = queryString + key + ",";
for (int j = 0; j < fields.Length; j++)
{
queryString = queryString + fields[j].getFieldSQLValue(ic);
if (j < fields.Length - 1)
{
queryString = queryString + ",";
}
}
queryString = queryString + ")";
return(queryString);
}
// protected override void OnExecutedCommand(DbCommand cmd)
// {
//#if DEBUG
// var date = DateTime.Now;
// //File.WriteAllText("//.txt", FormatCommand(cmd));
// var path = $"{AppDomain.CurrentDomain.BaseDirectory}SqlLogs\\Sql_{date.Year}-{date.Month:00}-{date.Day:00}.txt";
// if (!File.Exists(path))
// {
// File.Create(path).Dispose();
// using (var tw = File.AppendText(path))
// {
// tw.WriteLine($"[SQL] {date.TimeOfDay.ToString()}:");
// tw.WriteLine(FormatCommand(cmd));
// tw.WriteLine("--------------------------------------------------");
// tw.Close();
// }
// }
// else if (File.Exists(path))
// {
// using (var tw = File.AppendText(path))
// {
// tw.WriteLine($"[SQL] {date.TimeOfDay.ToString()}:");
// tw.WriteLine(FormatCommand(cmd));
// tw.WriteLine("--------------------------------------------------");
// tw.Close();
// }
// }
//#endif
// base.OnExecutedCommand(cmd);
// }
protected override bool OnInserting(InsertContext insertContext)
{
if (insertContext.Poco is BaseEntity entity)
{
entity.fFechaCrea = DateTime.UtcNow;
}
return(base.OnInserting(insertContext));
}
public bool OnInserting(IDatabase database, InsertContext insertContext)
{
var poco = insertContext.Poco; // ggfs. casting
if (poco != null)
{
// ...
}
return(true);
}
private System.Collections.ArrayList getQueryArray(string key, string operation, string folderCode, DocsPaVO.documento.SchedaDocumento schedaDoc)
{
logger.Debug("Costruzione queries");
System.Collections.ArrayList queries = new System.Collections.ArrayList();
TableField[] fields = new TableField[] { TableFieldAgent.getTableFieldInstance(Constants.JOUREC_FIELD_NAME),
TableFieldAgent.getTableFieldInstance(Constants.JOUDOC_FIELD_NAME),
TableFieldAgent.getTableFieldInstance(Constants.JOUCOD_FIELD_NAME),
TableFieldAgent.getTableFieldInstance(Constants.JOUPRO_FIELD_NAME),
TableFieldAgent.getTableFieldInstance(Constants.JOUTYP_FIELD_NAME),
TableFieldAgent.getTableFieldInstance(Constants.JOULEN_FIELD_NAME),
TableFieldAgent.getTableFieldInstance(Constants.JOUDES_FIELD_NAME), };
for (int i = 0; i <= Constants.NUM_CODES; i++)
{
//COSTRUZIONE DELLA SINGOLA QUERY
//costruzione insert context
InsertContext ic = new InsertContext();
ic.numRow = i;
ic.operation = operation;
ic.schedaDoc = schedaDoc;
ic.val = getValue(i, schedaDoc, folderCode, operation);
string queryString = getQuery(ic, key, fields);
logger.Debug("Creata query " + i + ": " + queryString);
queries.Add(queryString);
}
//INSERIMENTO DELL'OGGETTO
logger.Debug("Inserimento oggetto");
string oggettoString = schedaDoc.oggetto.descrizione;
Oggetto oggetto = new Oggetto(oggettoString);
ArrayList oggettoList = oggetto.split(Constants.OBJECT_ROW_LENGTH);
for (int i = 0; i < oggettoList.Count; i++)
{
InsertContext ic = new InsertContext();
ic.numRow = Constants.NUM_CODES + 1 + i;
ic.operation = operation;
ic.schedaDoc = schedaDoc;
ic.val = (string)oggettoList[i];
string queryString = getQuery(ic, key, fields);
logger.Debug("Creata query " + (Constants.NUM_CODES + 1 + i) + ": " + queryString);
queries.Add(queryString);
}
return(queries);
}
protected override bool OnInserting(InsertContext insertContext)
{
var PocoEntity = insertContext.Poco;
if (PocoEntity is IEntity <Guid> )
{
//GUID类型默认赋值
var entity = PocoEntity as IEntity <Guid>;
if (entity.IsTransient())
{
entity.Id = Guid.NewGuid();
}
}
if (OnInsertingFun != null)
{
var flag = OnInsertingFun(insertContext);
}
return(base.OnInserting(insertContext));
}
