/// <summary>
/// 添加实体
/// </summary>
/// <param name="piRoleEntity">实体</param>
public string AddEntity(PiRoleEntity piRoleEntity)
{
string sequence = string.Empty;
if (piRoleEntity.SortCode == null || piRoleEntity.SortCode == 0)
{
CiSequenceManager sequenceManager = new CiSequenceManager(DBProvider, this.Identity);
sequence = sequenceManager.GetSequence(this.CurrentTableName, sequenceManager.DefaultSequence);
piRoleEntity.SortCode = int.Parse(sequence);
}
this.Identity = false;
SQLBuilder sqlBuilder = new SQLBuilder(DBProvider, this.Identity, this.ReturnId);
sqlBuilder.BeginInsert(this.CurrentTableName, PiRoleTable.FieldId);
if (!this.Identity)
{
if (String.IsNullOrEmpty(piRoleEntity.Id))
{
sequence = BusinessLogic.NewGuid();
piRoleEntity.Id = sequence;
}
sqlBuilder.SetValue(PiRoleTable.FieldId, piRoleEntity.Id);
}
else
{
if (!this.ReturnId && (DBProvider.CurrentDbType == CurrentDbType.Oracle || DBProvider.CurrentDbType == CurrentDbType.DB2))
{
if (DBProvider.CurrentDbType == CurrentDbType.Oracle)
{
sqlBuilder.SetFormula(PiRoleTable.FieldId, "SEQ_" + this.CurrentTableName.ToUpper() + ".NEXTVAL ");
}
if (DBProvider.CurrentDbType == CurrentDbType.DB2)
{
sqlBuilder.SetFormula(PiRoleTable.FieldId, "NEXT VALUE FOR SEQ_" + this.CurrentTableName.ToUpper());
}
}
else
{
if (this.Identity && (DBProvider.CurrentDbType == CurrentDbType.Oracle || DBProvider.CurrentDbType == CurrentDbType.DB2))
{
if (piRoleEntity.Id == null)
{
if (string.IsNullOrEmpty(sequence))
{
CiSequenceManager sequenceManager = new CiSequenceManager(DBProvider, this.Identity);
sequence = sequenceManager.GetSequence(this.CurrentTableName);
}
piRoleEntity.Id = sequence;
}
sqlBuilder.SetValue(PiRoleTable.FieldId, piRoleEntity.Id);
}
}
}
this.SetEntity(sqlBuilder, piRoleEntity);
if (UserInfo != null)
{
sqlBuilder.SetValue(PiRoleTable.FieldCreateUserId, UserInfo.Id);
sqlBuilder.SetValue(PiRoleTable.FieldCreateBy, UserInfo.RealName);
}
sqlBuilder.SetDBNow(PiRoleTable.FieldCreateOn);
if (UserInfo != null)
{
sqlBuilder.SetValue(PiRoleTable.FieldModifiedUserId, UserInfo.Id);
sqlBuilder.SetValue(PiRoleTable.FieldModifiedBy, UserInfo.RealName);
}
sqlBuilder.SetDBNow(PiRoleTable.FieldModifiedOn);
if (this.Identity && (DBProvider.CurrentDbType == CurrentDbType.SqlServer || DBProvider.CurrentDbType == CurrentDbType.Access))
{
sequence = sqlBuilder.EndInsert().ToString();
}
else
{
sqlBuilder.EndInsert();
}
// 运行成功
return(sequence);
}
/// <summary>
/// 添加日志
/// </summary>
/// <param name="logEntity">日志对象</param>
/// <returns>受影响的行数</returns>
public string AddEntity(CiLogEntity logEntity)
{
if (!SystemInfo.EnableRecordLog)
{
return(string.Empty);
}
string sequence = string.Empty;
this.Identity = false;
SQLBuilder sqlBuilder = new SQLBuilder(DBProvider, this.Identity, this.ReturnId);
sqlBuilder.BeginInsert(CiLogTable.TableName);
if (!this.Identity)
{
if (string.IsNullOrEmpty(logEntity.Id))
{
sequence = BusinessLogic.NewGuid();
logEntity.Id = sequence;
}
sqlBuilder.SetValue(CiLogTable.FieldId, logEntity.Id);
}
if (String.IsNullOrEmpty(logEntity.CreateUserId))
{
logEntity.CreateUserId = logEntity.IPAddress;
}
sqlBuilder.SetValue(CiLogTable.FieldUserRealName, logEntity.UserRealName);
sqlBuilder.SetValue(CiLogTable.FieldProcessId, logEntity.ProcessId);
sqlBuilder.SetValue(CiLogTable.FieldProcessName, logEntity.ProcessName);
sqlBuilder.SetValue(CiLogTable.FieldMethodEngName, logEntity.MethodEngName);
sqlBuilder.SetValue(CiLogTable.FieldMethodName, logEntity.MethodName);
sqlBuilder.SetValue(CiLogTable.FieldParameters, logEntity.Parameters);
sqlBuilder.SetValue(CiLogTable.FieldWebUrl, logEntity.WebUrl);
sqlBuilder.SetValue(CiLogTable.FieldIPAddress, logEntity.IPAddress);
sqlBuilder.SetValue(CiLogTable.FieldDescription, logEntity.Description);
if (logEntity.CreateUserId.Length == 0)
{
logEntity.CreateUserId = logEntity.IPAddress;
}
sqlBuilder.SetValue(CiLogTable.FieldCreateUserId, logEntity.CreateUserId);
sqlBuilder.SetValue(CiLogTable.FieldCreateBy, logEntity.CreateBy);
sqlBuilder.SetDBNow(CiLogTable.FieldCreateOn);
if (DBProvider.CurrentDbType == CurrentDbType.SqlServer && this.Identity)
{
sequence = sqlBuilder.EndInsert().ToString();
}
else
{
sqlBuilder.EndInsert();
}
return(sequence);
}
/// <summary>
/// 设置实体
/// </summary>
/// <param name="operatorInstanceEntity">实体</param>
private void SetEntity(SQLBuilder sqlBuilder, OperatorInstanceEntity operatorInstanceEntity)
{
sqlBuilder.SetValue(OperatorInstanceTable.FieldWorkFlowId, operatorInstanceEntity.WorkFlowId);
sqlBuilder.SetValue(OperatorInstanceTable.FieldWorkTaskId, operatorInstanceEntity.WorkTaskId);
sqlBuilder.SetValue(OperatorInstanceTable.FieldWorkFlowInsId, operatorInstanceEntity.WorkFlowInsId);
sqlBuilder.SetValue(OperatorInstanceTable.FieldWorkTaskInsId, operatorInstanceEntity.WorkTaskInsId);
sqlBuilder.SetValue(OperatorInstanceTable.FieldUserId, operatorInstanceEntity.UserId);
sqlBuilder.SetValue(OperatorInstanceTable.FieldOperType, operatorInstanceEntity.OperType);
sqlBuilder.SetValue(OperatorInstanceTable.FieldOperRealtion, operatorInstanceEntity.OperRealtion);
sqlBuilder.SetValue(OperatorInstanceTable.FieldOperContent, operatorInstanceEntity.OperContent);
sqlBuilder.SetValue(OperatorInstanceTable.FieldOperContentText, operatorInstanceEntity.OperContentText);
sqlBuilder.SetValue(OperatorInstanceTable.FieldOperStatus, operatorInstanceEntity.OperStatus);
if (DBProvider.CurrentDbType == CurrentDbType.Oracle)
{
sqlBuilder.SetValue(OperatorInstanceTable.FieldOperDateTime, operatorInstanceEntity.OperDateTime != null ? BusinessLogic.GetOracleDateFormat(System.DateTime.Parse(operatorInstanceEntity.OperDateTime.ToString()), "yyyy-mm-dd hh24:mi:ss") : operatorInstanceEntity.OperDateTime);
}
else
{
sqlBuilder.SetValue(OperatorInstanceTable.FieldOperDateTime, operatorInstanceEntity.OperDateTime);
}
sqlBuilder.SetValue(OperatorInstanceTable.FieldChangeOperator, operatorInstanceEntity.ChangeOperator);
}
/// <summary>
/// 添加实体
/// </summary>
/// <param name="operatorInstanceEntity">实体</param>
public string AddEntity(OperatorInstanceEntity operatorInstanceEntity)
{
var sequence = string.Empty;
this.Identity = false;
if (operatorInstanceEntity.OperatorInsId != null)
{
sequence = operatorInstanceEntity.OperatorInsId.ToString();
}
var sqlBuilder = new SQLBuilder(DBProvider, this.Identity, this.ReturnId);
sqlBuilder.BeginInsert(this.CurrentTableName, OperatorInstanceTable.FieldOperatorInsId);
if (!this.Identity)
{
if (string.IsNullOrEmpty(operatorInstanceEntity.OperatorInsId))
{
sequence = BusinessLogic.NewGuid();
operatorInstanceEntity.OperatorInsId = sequence;
}
sqlBuilder.SetValue(OperatorInstanceTable.FieldOperatorInsId, operatorInstanceEntity.OperatorInsId);
}
else
{
if (!this.ReturnId && (DBProvider.CurrentDbType == CurrentDbType.Oracle || DBProvider.CurrentDbType == CurrentDbType.DB2))
{
if (DBProvider.CurrentDbType == CurrentDbType.Oracle)
{
sqlBuilder.SetFormula(OperatorInstanceTable.FieldOperatorInsId, "SEQ_" + this.CurrentTableName.ToUpper() + ".NEXTVAL ");
}
if (DBProvider.CurrentDbType == CurrentDbType.DB2)
{
sqlBuilder.SetFormula(OperatorInstanceTable.FieldOperatorInsId, "NEXT VALUE FOR SEQ_" + this.CurrentTableName.ToUpper());
}
}
else
{
if (this.Identity && (DBProvider.CurrentDbType == CurrentDbType.Oracle || DBProvider.CurrentDbType == CurrentDbType.DB2))
{
if (string.IsNullOrEmpty(operatorInstanceEntity.OperatorInsId))
{
if (string.IsNullOrEmpty(sequence))
{
var sequenceManager = new CiSequenceManager(DBProvider, this.Identity);
sequence = sequenceManager.GetSequence(this.CurrentTableName);
}
operatorInstanceEntity.OperatorInsId = sequence;
}
sqlBuilder.SetValue(OperatorInstanceTable.FieldOperatorInsId, operatorInstanceEntity.OperatorInsId);
}
}
}
this.SetEntity(sqlBuilder, operatorInstanceEntity);
if (this.Identity && (DBProvider.CurrentDbType == CurrentDbType.SqlServer || DBProvider.CurrentDbType == CurrentDbType.Access))
{
sequence = sqlBuilder.EndInsert().ToString();
}
else
{
sqlBuilder.EndInsert();
}
return(sequence);
}
/// <summary>
/// 添加实体
/// </summary>
/// <param name="workLinkEntity">实体</param>
public string AddEntity(WorkLinkEntity workLinkEntity)
{
string sequence = string.Empty;
this.Identity = false;
if (!string.IsNullOrEmpty(workLinkEntity.WorkLinkId))
{
sequence = workLinkEntity.WorkLinkId.ToString(CultureInfo.InvariantCulture);
}
SQLBuilder sqlBuilder = new SQLBuilder(DBProvider, this.Identity, this.ReturnId);
sqlBuilder.BeginInsert(this.CurrentTableName, WorkLinkTable.FieldWorkLinkId);
if (!this.Identity)
{
if (string.IsNullOrEmpty(workLinkEntity.WorkLinkId))
{
sequence = BusinessLogic.NewGuid();
workLinkEntity.WorkLinkId = sequence;
}
sqlBuilder.SetValue(WorkLinkTable.FieldWorkLinkId, workLinkEntity.WorkLinkId);
}
else
{
if (!this.ReturnId && (DBProvider.CurrentDbType == CurrentDbType.Oracle || DBProvider.CurrentDbType == CurrentDbType.DB2))
{
if (DBProvider.CurrentDbType == CurrentDbType.Oracle)
{
sqlBuilder.SetFormula(WorkLinkTable.FieldWorkLinkId, "SEQ_" + this.CurrentTableName.ToUpper() + ".NEXTVAL ");
}
if (DBProvider.CurrentDbType == CurrentDbType.DB2)
{
sqlBuilder.SetFormula(WorkLinkTable.FieldWorkLinkId, "NEXT VALUE FOR SEQ_" + this.CurrentTableName.ToUpper());
}
}
else
{
if (this.Identity && (DBProvider.CurrentDbType == CurrentDbType.Oracle || DBProvider.CurrentDbType == CurrentDbType.DB2))
{
if (string.IsNullOrEmpty(workLinkEntity.WorkLinkId))
{
if (string.IsNullOrEmpty(sequence))
{
CiSequenceManager sequenceManager = new CiSequenceManager(DBProvider, this.Identity);
sequence = sequenceManager.GetSequence(this.CurrentTableName);
}
workLinkEntity.WorkLinkId = sequence;
}
sqlBuilder.SetValue(WorkLinkTable.FieldWorkLinkId, workLinkEntity.WorkLinkId);
}
}
}
this.SetEntity(sqlBuilder, workLinkEntity);
if (this.Identity && (DBProvider.CurrentDbType == CurrentDbType.SqlServer || DBProvider.CurrentDbType == CurrentDbType.Access))
{
sequence = sqlBuilder.EndInsert().ToString();
}
else
{
sqlBuilder.EndInsert();
}
return(sequence);
}
/// <summary>
/// 设置实体
/// </summary>
/// <param name="sqlBuilder">SQL语句生成器</param>
/// <param name="ciParameterEntity">实体</param>
private void SetEntity(SQLBuilder sqlBuilder, CiParameterEntity ciParameterEntity)
{
sqlBuilder.SetValue(CiParameterTable.FieldCategoryKey, ciParameterEntity.CategoryKey);
sqlBuilder.SetValue(CiParameterTable.FieldParameterId, ciParameterEntity.ParameterId);
sqlBuilder.SetValue(CiParameterTable.FieldParameterCode, ciParameterEntity.ParameterCode);
sqlBuilder.SetValue(CiParameterTable.FieldParameterContent, ciParameterEntity.ParameterContent);
sqlBuilder.SetValue(CiParameterTable.FieldWorked, ciParameterEntity.Worked);
sqlBuilder.SetValue(CiParameterTable.FieldEnabled, ciParameterEntity.Enabled);
sqlBuilder.SetValue(CiParameterTable.FieldAllowEdit, ciParameterEntity.AllowEdit);
sqlBuilder.SetValue(CiParameterTable.FieldAllowDelete, ciParameterEntity.AllowDelete);
sqlBuilder.SetValue(CiParameterTable.FieldDescription, ciParameterEntity.Description);
sqlBuilder.SetValue(CiParameterTable.FieldSortCode, ciParameterEntity.SortCode);
sqlBuilder.SetValue(CiParameterTable.FieldDeleteMark, ciParameterEntity.DeleteMark);
}
/// <summary>
/// 设置实体
/// </summary>
/// <param name="sqlBuilder">SQL语句生成器</param>
/// <param name="ciExceptionEntity">实体</param>
private void SetEntity(SQLBuilder sqlBuilder, CiExceptionEntity ciExceptionEntity)
{
sqlBuilder.SetValue(CiExceptionTable.FieldEventId, ciExceptionEntity.EventId);
sqlBuilder.SetValue(CiExceptionTable.FieldCategory, ciExceptionEntity.Category);
sqlBuilder.SetValue(CiExceptionTable.FieldPriority, ciExceptionEntity.Priority);
sqlBuilder.SetValue(CiExceptionTable.FieldSeverity, ciExceptionEntity.Severity);
sqlBuilder.SetValue(CiExceptionTable.FieldTitle, ciExceptionEntity.Title);
sqlBuilder.SetValue(CiExceptionTable.FieldTimestamp, ciExceptionEntity.Timestamp);
sqlBuilder.SetValue(CiExceptionTable.FieldMachineName, ciExceptionEntity.MachineName);
sqlBuilder.SetValue(CiExceptionTable.FieldAppDomainName, ciExceptionEntity.AppDomainName);
sqlBuilder.SetValue(CiExceptionTable.FieldProcessId, ciExceptionEntity.ProcessId);
sqlBuilder.SetValue(CiExceptionTable.FieldProcessName, ciExceptionEntity.ProcessName);
sqlBuilder.SetValue(CiExceptionTable.FieldThreadName, ciExceptionEntity.ThreadName);
sqlBuilder.SetValue(CiExceptionTable.FieldWin32ThreadId, ciExceptionEntity.Win32ThreadId);
sqlBuilder.SetValue(CiExceptionTable.FieldMessage, ciExceptionEntity.Message);
sqlBuilder.SetValue(CiExceptionTable.FieldFormattedMessage, ciExceptionEntity.FormattedMessage);
}
