/// <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="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="fullName">序列名称</param>
/// <returns>影响行数</returns>
protected int UpdateReduction(string fullName)
{
SQLBuilder sqlBuilder = new SQLBuilder(DBProvider);
sqlBuilder.BeginUpdate(CiSequenceTable.TableName);
sqlBuilder.SetFormula(CiSequenceTable.FieldReduction, CiSequenceTable.FieldReduction + " - " + CiSequenceTable.FieldStep);
sqlBuilder.SetWhere(CiSequenceTable.FieldFullName, fullName);
return(sqlBuilder.EndUpdate());
}
/// <summary>
/// 更新升序序列
/// </summary>
/// <param name="fullName">序列名称</param>
/// <param name="sequenceCount">序列个数</param>
/// <returns>影响行数</returns>
protected int UpdateSequence(string fullName, int sequenceCount)
{
// 更新数据库里的值
SQLBuilder sqlBuilder = new SQLBuilder(DBProvider);
sqlBuilder.BeginUpdate(CiSequenceTable.TableName);
sqlBuilder.SetFormula(CiSequenceTable.FieldSequence, CiSequenceTable.FieldSequence + " + " + sequenceCount.ToString() + " * " + CiSequenceTable.FieldStep);
sqlBuilder.SetWhere(CiSequenceTable.FieldFullName, fullName);
return(sqlBuilder.EndUpdate());
}
private int UpdateReadCount(string id)
{
// 阅读次数要加一
var sqlBuilder = new SQLBuilder(DBProvider);
sqlBuilder.BeginUpdate(CiFileTable.TableName);
sqlBuilder.SetFormula(CiFileTable.FieldReadCount, CiFileTable.FieldReadCount + " + 1 ");
sqlBuilder.SetWhere(CiFileTable.FieldId, id);
return(sqlBuilder.EndUpdate());
}
/// <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);
}
