/// <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); }