/// <summary>
/// 添加实体
/// </summary>
/// <param name="ciExceptionEntity">实体</param>
public string AddEntity(CiExceptionEntity ciExceptionEntity)
{
var sequence = string.Empty;
this.Identity = false;
var sqlBuilder = new SQLBuilder(DBProvider, this.Identity, this.ReturnId);
sqlBuilder.BeginInsert(this.CurrentTableName, CiExceptionTable.FieldId);
if (!this.Identity)
{
if (string.IsNullOrEmpty(ciExceptionEntity.Id))
{
sequence = BusinessLogic.NewGuid();
ciExceptionEntity.Id = sequence;
}
sqlBuilder.SetValue(CiExceptionTable.FieldId, ciExceptionEntity.Id);
}
this.SetEntity(sqlBuilder, ciExceptionEntity);
if (UserInfo != null)
{
sqlBuilder.SetValue(CiExceptionTable.FieldCreateUserId, UserInfo.Id);
sqlBuilder.SetValue(CiExceptionTable.FieldCreateBy, UserInfo.RealName);
}
sqlBuilder.SetDBNow(CiExceptionTable.FieldCreateOn);
if (this.Identity && (DBProvider.CurrentDbType == CurrentDbType.SqlServer || DBProvider.CurrentDbType == CurrentDbType.Access))
{
sequence = sqlBuilder.EndInsert().ToString();
}
else
{
sqlBuilder.EndInsert();
}
return(sequence);
}
/// <summary>
/// 添加实体
/// </summary>
/// <param name="ciSequenceEntity">实体</param>
public string AddEntity(CiSequenceEntity ciSequenceEntity)
{
string sequence = string.Empty;
this.Identity = false;
SQLBuilder sqlBuilder = new SQLBuilder(DBProvider, this.Identity, this.ReturnId);
sqlBuilder.BeginInsert(this.CurrentTableName, CiSequenceTable.FieldId);
if (!this.Identity)
{
if (string.IsNullOrEmpty(ciSequenceEntity.Id))
{
sequence = BusinessLogic.NewGuid();
ciSequenceEntity.Id = sequence;
}
sqlBuilder.SetValue(CiSequenceTable.FieldId, ciSequenceEntity.Id);
}
else
{
if (!this.ReturnId && (DBProvider.CurrentDbType == CurrentDbType.Oracle || DBProvider.CurrentDbType == CurrentDbType.DB2))
{
if (DBProvider.CurrentDbType == CurrentDbType.Oracle)
{
sqlBuilder.SetFormula(CiSequenceTable.FieldId, "SEQ_" + this.CurrentTableName.ToUpper() + ".NEXTVAL ");
}
if (DBProvider.CurrentDbType == CurrentDbType.DB2)
{
sqlBuilder.SetFormula(CiSequenceTable.FieldId, "NEXT VALUE FOR SEQ_" + this.CurrentTableName.ToUpper());
}
}
else
{
if (this.Identity && (DBProvider.CurrentDbType == CurrentDbType.Oracle || DBProvider.CurrentDbType == CurrentDbType.DB2))
{
if (string.IsNullOrEmpty(ciSequenceEntity.Id.ToString()))
{
if (string.IsNullOrEmpty(sequence))
{
CiSequenceManager sequenceManager = new CiSequenceManager(DBProvider, this.Identity);
sequence = sequenceManager.GetSequence(this.CurrentTableName);
}
ciSequenceEntity.Id = sequence;
}
sqlBuilder.SetValue(CiSequenceTable.FieldId, ciSequenceEntity.Id);
}
}
}
this.SetEntity(sqlBuilder, ciSequenceEntity);
sqlBuilder.SetDBNow(CiSequenceTable.FieldCreateOn);
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="testdemoEntity">实体</param>
public string AddEntity(testdemoEntity testdemoEntity)
{
string sequence = string.Empty;
SQLBuilder sqlBuilder = new SQLBuilder(DBProvider, this.Identity, this.ReturnId);
sqlBuilder.BeginInsert(this.CurrentTableName, testdemoTable.FieldID);
if (!this.Identity)
{
sqlBuilder.SetValue(testdemoTable.FieldID, testdemoEntity.ID);
}
else
{
if (!this.ReturnId && (DBProvider.CurrentDbType == CurrentDbType.Oracle || DBProvider.CurrentDbType == CurrentDbType.DB2))
{
if (DBProvider.CurrentDbType == CurrentDbType.Oracle)
{
sqlBuilder.SetFormula(testdemoTable.FieldID, "SEQ_" + this.CurrentTableName.ToUpper() + ".NEXTVAL ");
}
if (DBProvider.CurrentDbType == CurrentDbType.DB2)
{
sqlBuilder.SetFormula(testdemoTable.FieldID, "NEXT VALUE FOR SEQ_" + this.CurrentTableName.ToUpper());
}
}
else
{
if (this.Identity && (DBProvider.CurrentDbType == CurrentDbType.Oracle || DBProvider.CurrentDbType == CurrentDbType.DB2))
{
if (testdemoEntity.ID == null)
{
if (string.IsNullOrEmpty(sequence))
{
CiSequenceManager sequenceManager = new CiSequenceManager(DBProvider, this.Identity);
sequence = sequenceManager.GetSequence(this.CurrentTableName);
}
testdemoEntity.ID = int.Parse(sequence);
}
sqlBuilder.SetValue(testdemoTable.FieldID, testdemoEntity.ID);
}
}
}
this.SetEntity(sqlBuilder, testdemoEntity);
if (this.Identity && (DBProvider.CurrentDbType == CurrentDbType.SqlServer || DBProvider.CurrentDbType == CurrentDbType.Access))
{
sequence = sqlBuilder.EndInsert().ToString();
}
else
{
sqlBuilder.EndInsert();
}
return(sequence);
}
/// <summary>
/// 添加实体
/// </summary>
/// <param name="ciItemDetailsEntity">实体</param>
public string AddEntity(CiItemDetailsEntity ciItemDetailsEntity)
{
var returnValue = string.Empty;
if (DBProvider.CurrentDbType == CurrentDbType.SqlServer)
{
ciItemDetailsEntity.SortCode = BusinessLogic.ConvertToNullableInt(dbProvider.ExecuteScalar("SELECT SortCode = ISNULL(MAX(SortCode),0) + 1 FROM CIITEMDETAILS WHERE DELETEMARK=0 AND ITEMID = '" + ciItemDetailsEntity.ItemId + "'"));
}
if (DBProvider.CurrentDbType == CurrentDbType.Oracle)
{
ciItemDetailsEntity.SortCode = BusinessLogic.ConvertToNullableInt(DBProvider.ExecuteScalar("SELECT NVL(MAX(SORTCODE),0) + 1 AS SORTCODE FROM CIITEMDETAILS WHERE DELETEMARK=0 AND ITEMID = '" + ciItemDetailsEntity.ItemId + "'"));
}
this.Identity = false;
var sqlBuilder = new SQLBuilder(DBProvider, this.Identity, this.ReturnId);
sqlBuilder.BeginInsert(this.CurrentTableName, CiItemDetailsTable.FieldId);
if (!this.Identity)
{
if (string.IsNullOrEmpty(ciItemDetailsEntity.Id))
{
returnValue = BusinessLogic.NewGuid();
ciItemDetailsEntity.Id = returnValue;
}
sqlBuilder.SetValue(CiItemDetailsTable.FieldId, ciItemDetailsEntity.Id);
}
this.SetEntity(sqlBuilder, ciItemDetailsEntity);
if (UserInfo != null)
{
sqlBuilder.SetValue(CiItemDetailsTable.FieldCreateUserId, UserInfo.Id);
sqlBuilder.SetValue(CiItemDetailsTable.FieldCreateBy, UserInfo.RealName);
}
sqlBuilder.SetDBNow(CiItemDetailsTable.FieldCreateOn);
if (UserInfo != null)
{
sqlBuilder.SetValue(CiItemDetailsTable.FieldModifiedBy, UserInfo.RealName);
}
sqlBuilder.SetDBNow(CiItemDetailsTable.FieldModifiedOn);
if (this.Identity && (DBProvider.CurrentDbType == CurrentDbType.SqlServer || DBProvider.CurrentDbType == CurrentDbType.Access))
{
returnValue = sqlBuilder.EndInsert().ToString();
}
else
{
sqlBuilder.EndInsert();
}
return(returnValue);
}
/// <summary>
/// Add 添加的主键
/// </summary>
/// <param name="folderEntity">文件夹对象</param>
/// <returns>主键</returns>
public string AddEntity(CiFolderEntity folderEntity)
{
var sequence = string.Empty;
if (folderEntity.SortCode == null || folderEntity.SortCode == 0)
{
var sequenceManager = new CiSequenceManager(DBProvider, this.Identity);
sequence = sequenceManager.GetSequence(this.CurrentTableName, sequenceManager.DefaultSequence);
folderEntity.SortCode = BusinessLogic.ConvertToNullableInt32(sequence);
}
this.Identity = false;
var sqlBuilder = new SQLBuilder(DBProvider, this.Identity, this.ReturnId);
sqlBuilder.BeginInsert(CiFolderTable.TableName, CiFolderTable.FieldId);
if (!this.Identity)
{
if (string.IsNullOrEmpty(folderEntity.Id))
{
sequence = BusinessLogic.NewGuid();
folderEntity.Id = sequence;
}
sqlBuilder.SetValue(CiFolderTable.FieldId, folderEntity.Id);
}
this.SetEntity(sqlBuilder, folderEntity);
sqlBuilder.SetValue(CiFolderTable.FieldCreateUserId, UserInfo.Id);
sqlBuilder.SetValue(CiFolderTable.FieldCreateBy, UserInfo.RealName);
sqlBuilder.SetDBNow(CiFolderTable.FieldCreateOn);
sqlBuilder.SetValue(CiFolderTable.FieldModifiedUserId, UserInfo.Id);
sqlBuilder.SetValue(CiFolderTable.FieldModifiedBy, UserInfo.RealName);
sqlBuilder.SetDBNow(CiFolderTable.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="dbProvider">数据库连接</param>
/// <param name="tableName">目标表名</param>
/// <param name="targetFields">更新字段</param>
/// <param name="targetValues">更新值</param>
/// <returns>影响行数</returns>
public static int Insert(IDbProvider dbProvider, string tableName, string[] targetFields, Object[] targetValues)
{
SQLBuilder sqlBuilder = new SQLBuilder(dbProvider);
sqlBuilder.BeginInsert(tableName);
for (int i = 0; i < targetFields.Length; i++)
{
sqlBuilder.SetValue(targetFields[i], targetValues[i]);
}
return(sqlBuilder.EndInsert());
}
/// <summary>
/// 记录异常情况
/// </summary>
/// <param name="ex">异常类</param>
/// <returns>主键</returns>
public int AddEntity(Exception ex)
{
// string sequence = CiSequenceManager.Instance.GetSequence(DBProvider, BaseExceptionEntity.TableName);
//string sequence = BusinessLogic.NewGuid();
var sqlBuilder = new SQLBuilder(DBProvider);
sqlBuilder.BeginInsert(CiExceptionTable.TableName);
sqlBuilder.SetValue(CiExceptionTable.FieldId, BusinessLogic.NewGuid());
sqlBuilder.SetValue(CiExceptionTable.FieldTitle, UserInfo.ProcessName);
sqlBuilder.SetValue(CiExceptionTable.FieldProcessId, UserInfo.ProcessId);
sqlBuilder.SetValue(CiExceptionTable.FieldProcessName, UserInfo.ProcessName);
sqlBuilder.SetValue(CiExceptionTable.FieldMessage, ex.Message);
sqlBuilder.SetValue(CiExceptionTable.FieldThreadName, ex.Source);
sqlBuilder.SetValue(CiExceptionTable.FieldFormattedMessage, ex.StackTrace);
if (UserInfo != null)
{
//sqlBuilder.SetValue(CiExceptionTable.FieldIPAddress, UserInfo.IPAddress);
sqlBuilder.SetValue(CiExceptionTable.FieldCreateUserId, UserInfo.Id);
sqlBuilder.SetValue(CiExceptionTable.FieldCreateBy, UserInfo.RealName);
}
sqlBuilder.SetDBNow(CiExceptionTable.FieldCreateOn);
return(sqlBuilder.EndInsert());
}
public virtual int SetTableColumns(string tableCode, string tableName, string columnCode, string columnName)
{
//CiSequenceManager sequenceManager = new CiSequenceManager(this.DBProvider);
string sortCode = string.Empty;//sequenceManager.GetSequence(CiTableColumnsTable.TableName);
// 插入数据
SQLBuilder sqlBuilder = new SQLBuilder(DBProvider);
sqlBuilder.BeginInsert(CiTableColumnsTable.TableName);
sqlBuilder.SetValue(CiTableColumnsTable.FieldTableCode, tableCode);
sqlBuilder.SetValue(CiTableColumnsTable.FieldColumnCode, columnCode);
sqlBuilder.SetValue(CiTableColumnsTable.FieldColumnName, columnName);
sqlBuilder.SetValue(CiTableColumnsTable.FieldSortCode, sortCode);
sqlBuilder.SetValue(CiTableColumnsTable.FieldCreateUserId, UserInfo.Id);
sqlBuilder.SetValue(CiTableColumnsTable.FieldCreateBy, UserInfo.RealName);
sqlBuilder.SetDBNow(CiTableColumnsTable.FieldCreateOn);
sqlBuilder.SetValue(CiTableColumnsTable.FieldModifiedUserId, UserInfo.Id);
sqlBuilder.SetValue(CiTableColumnsTable.FieldModifiedBy, UserInfo.RealName);
sqlBuilder.SetDBNow(CiTableColumnsTable.FieldModifiedOn);
return(sqlBuilder.EndInsert());
}
/// <summary>
/// 添加实体
/// </summary>
/// <param name="userEntity">实体</param>
public string AddEntity(PiUserEntity userEntity)
{
string sequence = string.Empty;
if (userEntity.SortCode == 0 || userEntity.SortCode == null)
{
CiSequenceManager sequenceManager = new CiSequenceManager(DBProvider, this.Identity);
sequence = sequenceManager.GetSequence(this.CurrentTableName, sequenceManager.DefaultSequence);
userEntity.SortCode = int.Parse(sequence);
}
userEntity.QuickQuery = StringHelper.ToChineseSpell(userEntity.RealName);
this.Identity = false;
SQLBuilder sqlBuilder = new SQLBuilder(DBProvider, this.Identity, this.ReturnId);
sqlBuilder.BeginInsert(this.CurrentTableName, PiUserTable.FieldId);
if (!this.Identity)
{
if (string.IsNullOrEmpty(userEntity.Id))
{
sequence = BusinessLogic.NewGuid();
userEntity.Id = sequence;
}
sqlBuilder.SetValue(PiUserTable.FieldId, userEntity.Id);
}
else
{
if (!this.ReturnId && (DBProvider.CurrentDbType == CurrentDbType.Oracle || DBProvider.CurrentDbType == CurrentDbType.DB2))
{
if (DBProvider.CurrentDbType == CurrentDbType.Oracle)
{
sqlBuilder.SetFormula(PiUserTable.FieldId, "SEQ_" + this.CurrentTableName.ToUpper() + ".NEXTVAL ");
}
if (DBProvider.CurrentDbType == CurrentDbType.DB2)
{
sqlBuilder.SetFormula(PiUserTable.FieldId, "NEXT VALUE FOR SEQ_" + this.CurrentTableName.ToUpper());
}
}
else
{
if (this.Identity && (DBProvider.CurrentDbType == CurrentDbType.Oracle || DBProvider.CurrentDbType == CurrentDbType.DB2))
{
if (userEntity.Id == null)
{
if (string.IsNullOrEmpty(sequence))
{
CiSequenceManager sequenceManager = new CiSequenceManager(DBProvider, this.Identity);
sequence = sequenceManager.GetSequence(this.CurrentTableName);
}
userEntity.Id = sequence;
}
sqlBuilder.SetValue(PiUserTable.FieldId, userEntity.Id);
}
}
}
this.SetEntity(sqlBuilder, userEntity);
if (UserInfo != null)
{
sqlBuilder.SetValue(PiUserTable.FieldCreateUserId, UserInfo.Id);
sqlBuilder.SetValue(PiUserTable.FieldCreateBy, UserInfo.RealName);
}
sqlBuilder.SetDBNow(PiUserTable.FieldCreateOn);
if (UserInfo != null)
{
sqlBuilder.SetValue(PiUserTable.FieldModifiedUserId, UserInfo.Id);
sqlBuilder.SetValue(PiUserTable.FieldModifiedBy, UserInfo.RealName);
}
sqlBuilder.SetDBNow(PiUserTable.FieldModifiedOn);
if (DBProvider.CurrentDbType == CurrentDbType.SqlServer && this.Identity)
{
sequence = sqlBuilder.EndInsert().ToString();
}
else
{
sqlBuilder.EndInsert();
}
return(sequence);
}
/// <summary>
/// 添加实体
/// </summary>
/// <param name="workTaskInsNextOperEntity">实体</param>
public string AddEntity(WorkTaskInsNextOperEntity workTaskInsNextOperEntity)
{
var sequence = string.Empty;
this.Identity = false;
if (!string.IsNullOrEmpty(workTaskInsNextOperEntity.NextOperId))
{
sequence = workTaskInsNextOperEntity.NextOperId.ToString();
}
var sqlBuilder = new SQLBuilder(DBProvider, this.Identity, this.ReturnId);
sqlBuilder.BeginInsert(this.CurrentTableName, WorkTaskInsNextOperTable.FieldNextOperId);
if (!this.Identity)
{
if (string.IsNullOrEmpty(workTaskInsNextOperEntity.NextOperId))
{
sequence = BusinessLogic.NewGuid();
workTaskInsNextOperEntity.NextOperId = sequence;
}
sqlBuilder.SetValue(WorkTaskInsNextOperTable.FieldNextOperId, workTaskInsNextOperEntity.NextOperId);
}
else
{
if (!this.ReturnId && (DBProvider.CurrentDbType == CurrentDbType.Oracle || DBProvider.CurrentDbType == CurrentDbType.DB2))
{
if (DBProvider.CurrentDbType == CurrentDbType.Oracle)
{
sqlBuilder.SetFormula(WorkTaskInsNextOperTable.FieldNextOperId, "SEQ_" + this.CurrentTableName.ToUpper() + ".NEXTVAL ");
}
if (DBProvider.CurrentDbType == CurrentDbType.DB2)
{
sqlBuilder.SetFormula(WorkTaskInsNextOperTable.FieldNextOperId, "NEXT VALUE FOR SEQ_" + this.CurrentTableName.ToUpper());
}
}
else
{
if (this.Identity && (DBProvider.CurrentDbType == CurrentDbType.Oracle || DBProvider.CurrentDbType == CurrentDbType.DB2))
{
if (string.IsNullOrEmpty(workTaskInsNextOperEntity.NextOperId))
{
if (string.IsNullOrEmpty(sequence))
{
var sequenceManager = new CiSequenceManager(DBProvider, this.Identity);
sequence = sequenceManager.GetSequence(this.CurrentTableName);
}
workTaskInsNextOperEntity.NextOperId = sequence;
}
sqlBuilder.SetValue(WorkTaskInsNextOperTable.FieldNextOperId, workTaskInsNextOperEntity.NextOperId);
}
}
}
this.SetEntity(sqlBuilder, workTaskInsNextOperEntity);
if (UserInfo != null)
{
sqlBuilder.SetValue(WorkTaskInsNextOperTable.FieldCreateUserId, UserInfo.Id);
sqlBuilder.SetValue(WorkTaskInsNextOperTable.FieldCreateBy, UserInfo.RealName);
}
sqlBuilder.SetDBNow(WorkTaskInsNextOperTable.FieldCreateOn);
if (this.Identity && (DBProvider.CurrentDbType == CurrentDbType.SqlServer || DBProvider.CurrentDbType == CurrentDbType.Access))
{
sequence = sqlBuilder.EndInsert().ToString();
}
else
{
sqlBuilder.EndInsert();
}
return(sequence);
}
/// <summary>
/// 添加实体
/// </summary>
/// <param name="subWorkFlowEntity">实体</param>
public string AddEntity(SubWorkFlowEntity subWorkFlowEntity)
{
var sequence = string.Empty;
this.Identity = false;
if (subWorkFlowEntity.SubId != null)
{
sequence = subWorkFlowEntity.SubId.ToString();
}
var sqlBuilder = new SQLBuilder(DBProvider, this.Identity, this.ReturnId);
sqlBuilder.BeginInsert(this.CurrentTableName, SubWorkFlowTable.FieldSubId);
if (!this.Identity)
{
if (string.IsNullOrEmpty(subWorkFlowEntity.SubId))
{
sequence = BusinessLogic.NewGuid();
subWorkFlowEntity.SubId = sequence;
}
sqlBuilder.SetValue(SubWorkFlowTable.FieldSubId, subWorkFlowEntity.SubId);
}
else
{
if (!this.ReturnId && (DBProvider.CurrentDbType == CurrentDbType.Oracle || DBProvider.CurrentDbType == CurrentDbType.DB2))
{
if (DBProvider.CurrentDbType == CurrentDbType.Oracle)
{
sqlBuilder.SetFormula(SubWorkFlowTable.FieldSubId, "SEQ_" + this.CurrentTableName.ToUpper() + ".NEXTVAL ");
}
if (DBProvider.CurrentDbType == CurrentDbType.DB2)
{
sqlBuilder.SetFormula(SubWorkFlowTable.FieldSubId, "NEXT VALUE FOR SEQ_" + this.CurrentTableName.ToUpper());
}
}
else
{
if (this.Identity && (DBProvider.CurrentDbType == CurrentDbType.Oracle || DBProvider.CurrentDbType == CurrentDbType.DB2))
{
if (string.IsNullOrEmpty(subWorkFlowEntity.SubId))
{
if (string.IsNullOrEmpty(sequence))
{
var sequenceManager = new CiSequenceManager(DBProvider, this.Identity);
sequence = sequenceManager.GetSequence(this.CurrentTableName);
}
subWorkFlowEntity.SubId = sequence;
}
sqlBuilder.SetValue(SubWorkFlowTable.FieldSubId, subWorkFlowEntity.SubId);
}
}
}
this.SetEntity(sqlBuilder, subWorkFlowEntity);
if (this.Identity && (DBProvider.CurrentDbType == CurrentDbType.SqlServer || DBProvider.CurrentDbType == CurrentDbType.Access))
{
sequence = sqlBuilder.EndInsert().ToString();
}
else
{
sqlBuilder.EndInsert();
}
return(sequence);
}
/// <summary>
/// 添加实体
/// </summary>
/// <param name="workFlowEventEntity">实体</param>
public string AddEntity(WorkFlowEventEntity workFlowEventEntity)
{
string sequence = string.Empty;
this.Identity = false;
if (!string.IsNullOrEmpty(workFlowEventEntity.Guid))
{
sequence = workFlowEventEntity.Guid.ToString(CultureInfo.InvariantCulture);
}
SQLBuilder sqlBuilder = new SQLBuilder(DBProvider, this.Identity, this.ReturnId);
sqlBuilder.BeginInsert(this.CurrentTableName, WorkFlowEventTable.FieldGuid);
if (!this.Identity)
{
if (string.IsNullOrEmpty(workFlowEventEntity.Guid))
{
sequence = BusinessLogic.NewGuid();
workFlowEventEntity.Guid = sequence;
}
sqlBuilder.SetValue(WorkFlowEventTable.FieldGuid, workFlowEventEntity.Guid);
}
else
{
if (!this.ReturnId && (DBProvider.CurrentDbType == CurrentDbType.Oracle || DBProvider.CurrentDbType == CurrentDbType.DB2))
{
if (DBProvider.CurrentDbType == CurrentDbType.Oracle)
{
sqlBuilder.SetFormula(WorkFlowEventTable.FieldGuid, "SEQ_" + this.CurrentTableName.ToUpper() + ".NEXTVAL ");
}
if (DBProvider.CurrentDbType == CurrentDbType.DB2)
{
sqlBuilder.SetFormula(WorkFlowEventTable.FieldGuid, "NEXT VALUE FOR SEQ_" + this.CurrentTableName.ToUpper());
}
}
else
{
if (this.Identity && (DBProvider.CurrentDbType == CurrentDbType.Oracle || DBProvider.CurrentDbType == CurrentDbType.DB2))
{
if (string.IsNullOrEmpty(workFlowEventEntity.Guid))
{
if (string.IsNullOrEmpty(sequence))
{
CiSequenceManager sequenceManager = new CiSequenceManager(DBProvider, this.Identity);
sequence = sequenceManager.GetSequence(this.CurrentTableName);
}
workFlowEventEntity.Guid = sequence;
}
sqlBuilder.SetValue(WorkFlowEventTable.FieldGuid, workFlowEventEntity.Guid);
}
}
}
this.SetEntity(sqlBuilder, workFlowEventEntity);
if (this.Identity && (DBProvider.CurrentDbType == CurrentDbType.SqlServer || DBProvider.CurrentDbType == CurrentDbType.Access))
{
sequence = sqlBuilder.EndInsert().ToString(CultureInfo.InvariantCulture);
}
else
{
sqlBuilder.EndInsert();
}
return(sequence);
}
/// <summary>
/// 添加实体
/// </summary>
/// <param name="entity">实体</param>
public string AddEntity(CiItemsEntity entity)
{
var sequence = string.Empty;
if (string.IsNullOrEmpty(entity.SortCode.ToString()) || entity.SortCode == 0)
{
var sequenceManager = new CiSequenceManager(DBProvider, this.Identity);
sequence = sequenceManager.GetSequence(this.CurrentTableName);
entity.SortCode = int.Parse(sequence);
}
this.Identity = false;
var sqlBuilder = new SQLBuilder(DBProvider, this.Identity, this.ReturnId);
sqlBuilder.BeginInsert(this.CurrentTableName, CiItemsTable.FieldId);
if (!this.Identity)
{
if (string.IsNullOrEmpty(entity.Id))
{
sequence = BusinessLogic.NewGuid();
entity.Id = sequence;
}
sqlBuilder.SetValue(CiItemsTable.FieldId, entity.Id);
}
else
{
if (!this.ReturnId && (DBProvider.CurrentDbType == CurrentDbType.Oracle || DBProvider.CurrentDbType == CurrentDbType.DB2))
{
if (DBProvider.CurrentDbType == CurrentDbType.Oracle)
{
sqlBuilder.SetFormula(CiItemsTable.FieldId, "SEQ_" + this.CurrentTableName.ToUpper() + ".NEXTVAL ");
}
if (DBProvider.CurrentDbType == CurrentDbType.DB2)
{
sqlBuilder.SetFormula(CiItemsTable.FieldId, "NEXT VALUE FOR SEQ_" + this.CurrentTableName.ToUpper());
}
}
else
{
if (this.Identity && (DBProvider.CurrentDbType == CurrentDbType.Oracle || DBProvider.CurrentDbType == CurrentDbType.DB2))
{
if (string.IsNullOrEmpty(sequence))
{
var sequenceManager = new CiSequenceManager(DBProvider, this.Identity);
sequence = sequenceManager.GetSequence(this.CurrentTableName);
}
entity.Id = sequence;
sqlBuilder.SetValue(CiItemsTable.FieldId, entity.Id);
}
}
}
this.SetEntity(sqlBuilder, entity);
if (UserInfo != null)
{
sqlBuilder.SetValue(CiItemsTable.FieldCreateUserId, UserInfo.Id);
sqlBuilder.SetValue(CiItemsTable.FieldCreateBy, UserInfo.RealName);
}
sqlBuilder.SetDBNow(CiItemsTable.FieldCreateOn);
if (UserInfo != null)
{
sqlBuilder.SetValue(CiItemsTable.FieldModifiedUserId, UserInfo.Id);
sqlBuilder.SetValue(CiItemsTable.FieldModifiedBy, UserInfo.RealName);
}
sqlBuilder.SetDBNow(CiItemsTable.FieldModifiedOn);
if (DBProvider.CurrentDbType == CurrentDbType.SqlServer && this.Identity)
{
sequence = sqlBuilder.EndInsert().ToString();
}
else
{
sqlBuilder.EndInsert();
}
return(sequence);
}
/// <summary>
/// 添加实体
/// </summary>
/// <param name="piPlatFormAddInEntity">实体</param>
public string AddEntity(PiPlatFormAddInEntity piPlatFormAddInEntity)
{
string sequence = string.Empty;
this.Identity = false;
SQLBuilder sqlBuilder = new SQLBuilder(DBProvider, this.Identity, this.ReturnId);
sqlBuilder.BeginInsert(this.CurrentTableName, PiPlatFormAddInTable.FieldId);
if (!this.Identity)
{
if (String.IsNullOrEmpty(piPlatFormAddInEntity.Id))
{
sequence = BusinessLogic.NewGuid();
piPlatFormAddInEntity.Id = sequence;
}
sqlBuilder.SetValue(PiPlatFormAddInTable.FieldId, piPlatFormAddInEntity.Id);
}
else
{
if (!this.ReturnId && (DBProvider.CurrentDbType == CurrentDbType.Oracle || DBProvider.CurrentDbType == CurrentDbType.DB2))
{
if (DBProvider.CurrentDbType == CurrentDbType.Oracle)
{
sqlBuilder.SetFormula(PiPlatFormAddInTable.FieldId, "SEQ_" + this.CurrentTableName.ToUpper() + ".NEXTVAL ");
}
if (DBProvider.CurrentDbType == CurrentDbType.DB2)
{
sqlBuilder.SetFormula(PiPlatFormAddInTable.FieldId, "NEXT VALUE FOR SEQ_" + this.CurrentTableName.ToUpper());
}
}
else
{
if (this.Identity && (DBProvider.CurrentDbType == CurrentDbType.Oracle || DBProvider.CurrentDbType == CurrentDbType.DB2))
{
if (piPlatFormAddInEntity.Id == null)
{
if (string.IsNullOrEmpty(sequence))
{
CiSequenceManager sequenceManager = new CiSequenceManager(DBProvider, this.Identity);
sequence = sequenceManager.GetSequence(this.CurrentTableName);
}
piPlatFormAddInEntity.Id = sequence;
}
sqlBuilder.SetValue(PiPlatFormAddInTable.FieldId, piPlatFormAddInEntity.Id);
}
}
}
this.SetEntity(sqlBuilder, piPlatFormAddInEntity);
if (UserInfo != null)
{
sqlBuilder.SetValue(PiPlatFormAddInTable.FieldCreateUserId, UserInfo.Id);
sqlBuilder.SetValue(PiPlatFormAddInTable.FieldCreateBy, UserInfo.RealName);
}
sqlBuilder.SetDBNow(PiPlatFormAddInTable.FieldCreateOn);
if (UserInfo != null)
{
sqlBuilder.SetValue(PiPlatFormAddInTable.FieldModifiedUserId, UserInfo.Id);
sqlBuilder.SetValue(PiPlatFormAddInTable.FieldModifiedBy, UserInfo.RealName);
}
sqlBuilder.SetDBNow(PiPlatFormAddInTable.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="fileEntity">实体</param>
public string AddEntity(CiFileEntity fileEntity)
{
var sequence = string.Empty;
if (fileEntity.SortCode == null || fileEntity.SortCode == 0)
{
var sequenceManager = new CiSequenceManager(DBProvider, this.Identity);
sequence = sequenceManager.GetSequence(this.CurrentTableName, sequenceManager.DefaultSequence);
fileEntity.SortCode = BusinessLogic.ConvertToNullableInt32(sequence);
}
this.Identity = false;
var sqlBuilder = new SQLBuilder(DBProvider, this.Identity, false);
sqlBuilder.BeginInsert(this.CurrentTableName, CiFileTable.FieldId);
if (!this.Identity)
{
if (String.IsNullOrEmpty(fileEntity.Id))
{
sequence = BusinessLogic.NewGuid();
fileEntity.Id = sequence;
}
sqlBuilder.SetValue(CiFileTable.FieldId, fileEntity.Id);
}
else
{
if (!this.ReturnId && DBProvider.CurrentDbType == CurrentDbType.Oracle)
{
sqlBuilder.SetFormula(CiFileTable.FieldId, "SEQ_" + this.CurrentTableName.ToUpper() + ".NEXTVAL ");
}
else
{
if (this.Identity && DBProvider.CurrentDbType == CurrentDbType.Oracle)
{
if (string.IsNullOrEmpty(fileEntity.Id))
{
if (string.IsNullOrEmpty(sequence))
{
var sequenceManager = new CiSequenceManager(DBProvider, this.Identity);
sequence = sequenceManager.GetSequence(this.CurrentTableName);
}
fileEntity.Id = sequence;
}
sqlBuilder.SetValue(CiFileTable.FieldId, fileEntity.Id);
}
}
}
this.SetEntity(sqlBuilder, fileEntity);
if (UserInfo != null)
{
sqlBuilder.SetValue(CiFileTable.FieldCreateUserId, UserInfo.Id);
sqlBuilder.SetValue(CiFileTable.FieldCreateBy, UserInfo.RealName);
}
sqlBuilder.SetDBNow(CiFileTable.FieldCreateOn);
/*
* if (UserInfo != null)
* {
* sqlBuilder.SetValue(CiFileTable.FieldModifiedUserId, UserInfo.Id);
* sqlBuilder.SetValue(CiFileTable.FieldModifiedBy, UserInfo.RealName);
* }
* sqlBuilder.SetDBNow(CiFileTable.FieldModifiedOn);
*/
if (DBProvider.CurrentDbType == CurrentDbType.SqlServer && this.Identity)
{
sequence = sqlBuilder.EndInsert().ToString();
}
else
{
sqlBuilder.EndInsert();
}
return(sequence);
}
/// <summary>
/// 添加实体
/// </summary>
/// <param name="piOrganizeEntity">实体</param>
public string AddEntity(PiOrganizeEntity piOrganizeEntity, out string statusCode)
{
string sequence = string.Empty;
statusCode = string.Empty;
string[] names = new string[] { PiOrganizeTable.FieldParentId, PiOrganizeTable.FieldFullName, PiOrganizeTable.FieldDeleteMark };
object[] values = new object[] { piOrganizeEntity.ParentId, piOrganizeEntity.FullName, piOrganizeEntity.DeleteMark };
if (this.Exists(names, values))
{
// 名称已重复
statusCode = StatusCode.ErrorNameExist.ToString();
}
else
{
if (piOrganizeEntity.SortCode == null || piOrganizeEntity.SortCode == 0)
{
CiSequenceManager sequenceManager = new CiSequenceManager(DBProvider, this.Identity);
sequence = sequenceManager.GetSequence(this.CurrentTableName, sequenceManager.DefaultSequence);
piOrganizeEntity.SortCode = int.Parse(sequence);
}
this.Identity = false;
SQLBuilder sqlBuilder = new SQLBuilder(DBProvider, this.Identity, this.ReturnId);
sqlBuilder.BeginInsert(this.CurrentTableName, PiOrganizeTable.FieldId);
if (!this.Identity)
{
if (String.IsNullOrEmpty(piOrganizeEntity.Id))
{
sequence = BusinessLogic.NewGuid();
piOrganizeEntity.Id = sequence;
}
sqlBuilder.SetValue(PiOrganizeTable.FieldId, piOrganizeEntity.Id);
}
else
{
if (!this.ReturnId && (DBProvider.CurrentDbType == CurrentDbType.Oracle || DBProvider.CurrentDbType == CurrentDbType.DB2))
{
if (DBProvider.CurrentDbType == CurrentDbType.Oracle)
{
sqlBuilder.SetFormula(PiOrganizeTable.FieldId, "SEQ_" + this.CurrentTableName.ToUpper() + ".NEXTVAL ");
}
if (DBProvider.CurrentDbType == CurrentDbType.DB2)
{
sqlBuilder.SetFormula(PiOrganizeTable.FieldId, "NEXT VALUE FOR SEQ_" + this.CurrentTableName.ToUpper());
}
}
else
{
if (this.Identity && (DBProvider.CurrentDbType == CurrentDbType.Oracle || DBProvider.CurrentDbType == CurrentDbType.DB2))
{
if (piOrganizeEntity.Id == null)
{
if (string.IsNullOrEmpty(sequence))
{
CiSequenceManager sequenceManager = new CiSequenceManager(DBProvider, this.Identity);
sequence = sequenceManager.GetSequence(this.CurrentTableName);
}
piOrganizeEntity.Id = sequence;
}
sqlBuilder.SetValue(PiOrganizeTable.FieldId, piOrganizeEntity.Id);
}
}
}
this.SetEntity(sqlBuilder, piOrganizeEntity);
//if (UserInfo != null)
//{
// sqlBuilder.SetValue(PiOrganizeTable.FieldCreateUserId, UserInfo.Id);
// sqlBuilder.SetValue(PiOrganizeTable.FieldCreateBy, UserInfo.RealName);
//}
sqlBuilder.SetDBNow(PiOrganizeTable.FieldCreateOn);
sqlBuilder.SetDBNow(PiOrganizeTable.FieldModifiedOn);
if (this.Identity && (DBProvider.CurrentDbType == CurrentDbType.SqlServer || DBProvider.CurrentDbType == CurrentDbType.Access))
{
sequence = sqlBuilder.EndInsert().ToString();
// 运行成功
statusCode = StatusCode.OKAdd.ToString();
}
else
{
sqlBuilder.EndInsert();
// 运行成功
statusCode = StatusCode.OKAdd.ToString();
}
}
return(sequence);
}
