/// <summary>
/// 添加一条记录
/// </summary>
/// <param name="noteEntity">实体对象</param>
/// <returns>主键</returns>
public string AddEntity(BaseNoteEntity noteEntity)
{
string id = Guid.NewGuid().ToString();
SQLBuilder sqlBuilder = new SQLBuilder(DbHelper);
sqlBuilder.BeginInsert(this.CurrentTableName);
sqlBuilder.SetValue(BaseNoteEntity.FieldId, id);
this.SetEntity(sqlBuilder, noteEntity);
if (UserInfo != null)
{
sqlBuilder.SetValue(BaseNoteEntity.FieldCreateUserId, UserInfo.Id);
sqlBuilder.SetDBNow(BaseNoteEntity.FieldCreateOn);
}
sqlBuilder.SetDBNow(BaseNoteEntity.FieldModifiedOn);
return sqlBuilder.EndInsert() > 0 ? id : string.Empty;
}
/// <summary>
/// 添加员工
/// </summary>
/// <param name="DepartmentId">部门主键</param>
/// <param name="userName">用户名</param>
/// <param name="code">编号</param>
/// <param name="fullName">名称</param>
/// <param name="canVisit">允许登录</param>
/// <param name="isVirtual">虚拟用户</param>
/// <param name="isDimission">离职</param>
/// <param name="enabled">有效</param>
/// <param name="description">描述</param>
/// <returns>主键</returns>
public string Add(string departmentId, string userName, string code, string fullName, bool isVirtual, bool isDimission, bool enabled, string description)
{
SQLBuilder sqlBuilder = new SQLBuilder(DbHelper);
BaseSequenceManager sequenceManager = new BaseSequenceManager(DbHelper);
string sequence = sequenceManager.GetSequence(this.CurrentTableName);
sqlBuilder.BeginInsert(this.CurrentTableName);
sqlBuilder.SetValue(BaseStaffEntity.FieldId, sequence);
sqlBuilder.SetValue(BaseStaffEntity.FieldCode, code);
sqlBuilder.SetValue(BaseStaffEntity.FieldUserName, userName);
sqlBuilder.SetValue(BaseStaffEntity.FieldRealName, fullName);
sqlBuilder.SetValue(BaseStaffEntity.FieldDepartmentId, departmentId);
sqlBuilder.SetValue(BaseStaffEntity.FieldSortCode, sequence);
sqlBuilder.SetValue(BaseStaffEntity.FieldEnabled, enabled ? 1 : 0);
if (UserInfo != null)
{
sqlBuilder.SetValue(BaseStaffEntity.FieldCreateUserId, UserInfo.Id);
sqlBuilder.SetValue(BaseStaffEntity.FieldCreateOn, UserInfo.RealName);
}
sqlBuilder.SetDBNow(BaseStaffEntity.FieldCreateOn);
string returnValue = sqlBuilder.EndInsert() > 0 ? sequence : string.Empty;
return returnValue;
}
/// <summary>
/// 添加实体
/// </summary>
/// <param name="parameterEntity">实体对象</param>
/// <returns>主键</returns>
public string AddEntity(BaseParameterEntity parameterEntity)
{
if (string.IsNullOrEmpty(parameterEntity.Id))
{
parameterEntity.Id = Guid.NewGuid().ToString();
}
SQLBuilder sqlBuilder = new SQLBuilder(DbHelper);
sqlBuilder.BeginInsert(this.CurrentTableName);
sqlBuilder.SetValue(BaseParameterEntity.FieldId, parameterEntity.Id);
sqlBuilder.SetValue(BaseParameterEntity.FieldCategoryId, parameterEntity.CategoryId);
sqlBuilder.SetValue(BaseParameterEntity.FieldParameterId, parameterEntity.ParameterId);
sqlBuilder.SetValue(BaseParameterEntity.FieldParameterCode, parameterEntity.ParameterCode);
sqlBuilder.SetValue(BaseParameterEntity.FieldWorked, parameterEntity.Worked ? 1 : 0);
sqlBuilder.SetValue(BaseParameterEntity.FieldParameterContent, parameterEntity.ParameterContent);
sqlBuilder.SetValue(BaseParameterEntity.FieldEnabled, parameterEntity.Enabled ? 1 : 0);
sqlBuilder.SetValue(BaseParameterEntity.FieldDeletionStateCode, parameterEntity.DeletionStateCode);
sqlBuilder.SetValue(BaseParameterEntity.FieldDescription, parameterEntity.Description);
if (UserInfo != null)
{
sqlBuilder.SetValue(BaseParameterEntity.FieldCreateUserId, UserInfo.Id);
sqlBuilder.SetValue(BaseParameterEntity.FieldCreateBy, UserInfo.RealName);
}
sqlBuilder.SetDBNow(BaseParameterEntity.FieldCreateOn);
return sqlBuilder.EndInsert() > 0 ? parameterEntity.Id : string.Empty;
}
/// <summary>
/// 添加实体
/// </summary>
/// <param name="workFlowActivityEntity">实体</param>
public string AddEntity(BaseWorkFlowStepEntity workFlowActivityEntity)
{
string sequence = string.Empty;
if (workFlowActivityEntity.SortCode == null || workFlowActivityEntity.SortCode == 0)
{
BaseSequenceManager sequenceManager = new BaseSequenceManager(DbHelper, this.Identity);
sequence = sequenceManager.GetSequence(this.CurrentTableName);
workFlowActivityEntity.SortCode = int.Parse(sequence);
}
SQLBuilder sqlBuilder = new SQLBuilder(DbHelper, this.Identity, this.ReturnId);
sqlBuilder.BeginInsert(this.CurrentTableName, BaseWorkFlowStepEntity.FieldId);
if (!this.Identity)
{
sqlBuilder.SetValue(BaseWorkFlowStepEntity.FieldId, workFlowActivityEntity.Id);
}
else
{
if (!this.ReturnId && (DbHelper.CurrentDbType == DbTypes.Oracle || DbHelper.CurrentDbType == DbTypes.DB2))
{
if (DbHelper.CurrentDbType == DbTypes.Oracle)
{
sqlBuilder.SetFormula(BaseWorkFlowStepEntity.FieldId, "SEQ_" + this.CurrentTableName.ToUpper() + ".NEXTVAL ");
}
if (DbHelper.CurrentDbType == DbTypes.DB2)
{
sqlBuilder.SetFormula(BaseWorkFlowStepEntity.FieldId, "NEXT VALUE FOR SEQ_" + this.CurrentTableName.ToUpper());
}
}
else
{
if (this.Identity && (DbHelper.CurrentDbType == DbTypes.Oracle || DbHelper.CurrentDbType == DbTypes.DB2))
{
if (workFlowActivityEntity.Id == null)
{
if (string.IsNullOrEmpty(sequence))
{
BaseSequenceManager sequenceManager = new BaseSequenceManager(DbHelper, this.Identity);
sequence = sequenceManager.GetSequence(this.CurrentTableName);
}
workFlowActivityEntity.Id = int.Parse(sequence);
}
sqlBuilder.SetValue(BaseWorkFlowStepEntity.FieldId, workFlowActivityEntity.Id);
}
}
}
this.SetEntity(sqlBuilder, workFlowActivityEntity);
if (UserInfo != null)
{
sqlBuilder.SetValue(BaseWorkFlowStepEntity.FieldCreateUserId, UserInfo.Id);
sqlBuilder.SetValue(BaseWorkFlowStepEntity.FieldCreateBy, UserInfo.RealName);
}
sqlBuilder.SetDBNow(BaseWorkFlowStepEntity.FieldCreateOn);
if (UserInfo != null)
{
sqlBuilder.SetValue(BaseWorkFlowStepEntity.FieldModifiedUserId, UserInfo.Id);
sqlBuilder.SetValue(BaseWorkFlowStepEntity.FieldModifiedBy, UserInfo.RealName);
}
sqlBuilder.SetDBNow(BaseWorkFlowStepEntity.FieldModifiedOn);
if (DbHelper.CurrentDbType == DbTypes.SqlServer && this.Identity)
{
sequence = sqlBuilder.EndInsert().ToString();
}
else
{
sqlBuilder.EndInsert();
}
return sequence;
}
/// <summary>
/// 记录异常情况
/// </summary>
/// <param name="Exception">异常类</param>
/// <returns>主键</returns>
public string AddEntity(Exception ex)
{
// string sequence = BaseSequenceManager.Instance.GetSequence(DbHelper, BaseExceptionEntity.TableName);
string sequence = BaseBusinessLogic.NewGuid();
SQLBuilder sqlBuilder = new SQLBuilder(DbHelper);
sqlBuilder.BeginInsert(this.CurrentTableName);
sqlBuilder.SetValue(BaseExceptionEntity.FieldId, sequence);
// sqlBuilder.SetValue(BaseExceptionEntity.FieldTitle, UserInfo.ProcessName);
// sqlBuilder.SetValue(BaseExceptionEntity.FieldProcessId, UserInfo.ProcessId);
// sqlBuilder.SetValue(BaseExceptionEntity.FieldProcessName, UserInfo.ProcessName);
sqlBuilder.SetValue(BaseExceptionEntity.FieldMessage, ex.Message);
sqlBuilder.SetValue(BaseExceptionEntity.FieldThreadName, ex.Source);
sqlBuilder.SetValue(BaseExceptionEntity.FieldFormattedMessage, ex.StackTrace);
if (UserInfo != null)
{
sqlBuilder.SetValue(BaseExceptionEntity.FieldIPAddress, UserInfo.IPAddress);
sqlBuilder.SetValue(BaseExceptionEntity.FieldCreateUserId, UserInfo.Id);
sqlBuilder.SetValue(BaseExceptionEntity.FieldCreateBy, UserInfo.RealName);
}
sqlBuilder.SetDBNow(BaseExceptionEntity.FieldCreateOn);
return sqlBuilder.EndInsert() > 0 ? sequence : string.Empty;
}
/// <summary>
/// 添加实体
/// </summary>
/// <param name="baseMessageEntity">实体</param>
public string AddEntity(BaseMessageEntity baseMessageEntity)
{
string sequence = string.Empty;
this.Identity = false;
if (baseMessageEntity.SortCode == null || baseMessageEntity.SortCode == 0)
{
BaseSequenceManager sequenceManager = new BaseSequenceManager(DbHelper, this.Identity);
sequence = sequenceManager.GetSequence(this.CurrentTableName);
baseMessageEntity.SortCode = int.Parse(sequence);
}
if (baseMessageEntity.Id != null)
{
sequence = baseMessageEntity.Id.ToString();
}
SQLBuilder sqlBuilder = new SQLBuilder(DbHelper, this.Identity, this.ReturnId);
sqlBuilder.BeginInsert(this.CurrentTableName, BaseMessageEntity.FieldId);
if (!this.Identity)
{
if (string.IsNullOrEmpty(baseMessageEntity.Id))
{
sequence = BaseBusinessLogic.NewGuid();
baseMessageEntity.Id = sequence ;
}
sqlBuilder.SetValue(BaseMessageEntity.FieldId, baseMessageEntity.Id);
}
else
{
if (!this.ReturnId && (DbHelper.CurrentDbType == DbTypes.Oracle || DbHelper.CurrentDbType == DbTypes.DB2))
{
if (DbHelper.CurrentDbType == DbTypes.Oracle)
{
sqlBuilder.SetFormula(BaseMessageEntity.FieldId, "SEQ_" + this.CurrentTableName.ToUpper() + ".NEXTVAL ");
}
if (DbHelper.CurrentDbType == DbTypes.DB2)
{
sqlBuilder.SetFormula(BaseMessageEntity.FieldId, "NEXT VALUE FOR SEQ_" + this.CurrentTableName.ToUpper());
}
}
else
{
if (this.Identity && (DbHelper.CurrentDbType == DbTypes.Oracle || DbHelper.CurrentDbType == DbTypes.DB2))
{
if (string.IsNullOrEmpty(baseMessageEntity.Id))
{
if (string.IsNullOrEmpty(sequence))
{
BaseSequenceManager sequenceManager = new BaseSequenceManager(DbHelper, this.Identity);
sequence = sequenceManager.GetSequence(this.CurrentTableName);
}
baseMessageEntity.Id = sequence;
}
sqlBuilder.SetValue(BaseMessageEntity.FieldId, baseMessageEntity.Id);
}
}
}
this.SetEntity(sqlBuilder, baseMessageEntity);
if (UserInfo != null)
{
sqlBuilder.SetValue(BaseMessageEntity.FieldCreateUserId, UserInfo.Id);
sqlBuilder.SetValue(BaseMessageEntity.FieldCreateBy, UserInfo.RealName);
}
sqlBuilder.SetDBNow(BaseMessageEntity.FieldCreateOn);
if (UserInfo != null)
{
sqlBuilder.SetValue(BaseMessageEntity.FieldModifiedUserId, UserInfo.Id);
sqlBuilder.SetValue(BaseMessageEntity.FieldModifiedBy, UserInfo.RealName);
}
sqlBuilder.SetDBNow(BaseMessageEntity.FieldModifiedOn);
if (this.Identity && (DbHelper.CurrentDbType == DbTypes.SqlServer || DbHelper.CurrentDbType == DbTypes.Access))
{
sequence = sqlBuilder.EndInsert().ToString();
}
else
{
sqlBuilder.EndInsert();
}
return sequence;
}
/// <summary>
/// 添加
/// </summary>
/// <param name="workReportEntity">实体</param>
/// <returns>主键</returns>
private string AddEntity(BaseWorkReportEntity workReportEntity)
{
string returnValue = string.Empty;
BaseSequenceManager sequenceManager = new BaseSequenceManager(DbHelper);
string sequence = sequenceManager.GetSequence(BaseWorkReportTable.TableName);
workReportEntity.SortCode = sequence;
//获取职员的部门主键和公司主键
BaseStaffManager staffManager = new BaseStaffManager(DbHelper, UserInfo);
string CompanyId = staffManager.GetProperty(workReportEntity.StaffId, BaseStaffTable.FieldCompanyId);
string DepartmentId = staffManager.GetProperty(workReportEntity.StaffId, BaseStaffTable.FieldDepartmentId);
SQLBuilder sqlBuilder = new SQLBuilder(DbHelper);
sqlBuilder.BeginInsert(BaseWorkReportTable.TableName);
sqlBuilder.SetValue(BaseWorkReportTable.FieldId, sequence);
sqlBuilder.SetValue(BaseWorkReportTable.FieldCompanyId, CompanyId);
sqlBuilder.SetValue(BaseWorkReportTable.FieldDepartmentId, DepartmentId);
this.SetEntity(sqlBuilder, workReportEntity);
sqlBuilder.SetValue(BaseWorkReportTable.FieldCreateUserId, UserInfo.Id);
sqlBuilder.SetDBNow(BaseWorkReportTable.FieldCreateOn);
returnValue = sqlBuilder.EndInsert() > 0 ? sequence : string.Empty;
return returnValue;
}
/// <summary>
/// 添加日志
/// </summary>
/// <param name="logEntity">日志对象</param>
/// <returns>主键</returns>
public int AddEntity(BaseLogEntity logEntity)
{
int returnValue = 0;
// if (!BaseSystemInfo.RecordLog)
// {
// return string.Empty;
// }
// 由于并发控制，没有能获得有效ID的错误处理，测试一下错误发生的数量。
// if (Log.ID.Length == 0)
// {
// return returnValue;
// }
// string sequence = BaseSequenceManager.Instance.GetSequence(DbHelper, BaseLogEntity.TableName);
// string sequence = BaseSequenceManager.Instance.NewGuid();
string sequence = string.Empty;
SQLBuilder sqlBuilder = new SQLBuilder(DbHelper);
if (DbHelper.CurrentDbType == DbTypes.Access)
// sqlBuilder.BeginInsert(this.CurrentTableName, "LogId", this.Identity);
{
// 写入日志 04-24
dbHelper.Open(BaseSystemInfo.UserCenterDbConnection);
// 用户已经不存在的需要整理干净，防止数据不完整。
string sqlQuery = " INSERT INTO [BaseLog]([ProcessId],[ProcessName],[MethodId] " +
" ,[MethodName],[Parameters],[UserId],[UserRealName],[IPAddress],[UrlReferrer],[WebUrl],[Description],[CreateOn],[ModifiedOn]) VALUES " +
"( '" + logEntity.ProcessId + "','" + logEntity.ProcessName + "','" + logEntity.MethodId.ToString() + "','" + logEntity.MethodName + "','" +
logEntity.Parameters + "','" + logEntity.UserId + "','" + logEntity.UserRealName + "','" + logEntity.IPAddress + "','" + logEntity.UrlReferrer + "','" +
logEntity.WebUrl + " ','" + logEntity.Description + "'," + DbHelper.GetDBNow() + "," + DbHelper.GetDBNow() + ")";
return dbHelper.ExecuteNonQuery(sqlQuery); ;
}
else
sqlBuilder.BeginInsert(this.CurrentTableName, this.Identity);
if (!this.Identity)
{
sqlBuilder.SetValue(BaseLogEntity.FieldId, logEntity.Id);
}
else
{
if (!this.ReturnId && (DbHelper.CurrentDbType == DbTypes.Oracle || DbHelper.CurrentDbType == DbTypes.DB2))
{
if (DbHelper.CurrentDbType == DbTypes.Oracle)
{
sqlBuilder.SetFormula(BaseLogEntity.FieldId, "SEQ_" + this.CurrentTableName.ToUpper() + ".NEXTVAL ");
}
if (DbHelper.CurrentDbType == DbTypes.DB2)
{
sqlBuilder.SetFormula(BaseLogEntity.FieldId, "NEXT VALUE FOR SEQ_" + this.CurrentTableName.ToUpper());
}
}
else
{
if (this.Identity && (DbHelper.CurrentDbType == DbTypes.Oracle || DbHelper.CurrentDbType == DbTypes.DB2))
{
if (string.IsNullOrEmpty(logEntity.Id))
{
if (string.IsNullOrEmpty(sequence))
{
BaseSequenceManager sequenceManager = new BaseSequenceManager(DbHelper, this.Identity);
sequence = sequenceManager.GetSequence(this.CurrentTableName);
}
logEntity.Id = sequence;
}
sqlBuilder.SetValue(BaseLogEntity.FieldId, logEntity.Id);
}
}
}
if (String.IsNullOrEmpty(logEntity.UserId))
{
logEntity.UserId = logEntity.IPAddress;
}
sqlBuilder.SetValue(BaseLogEntity.FieldUserId, logEntity.UserId);
sqlBuilder.SetValue(BaseLogEntity.FieldUserRealName, logEntity.UserRealName);
sqlBuilder.SetValue(BaseLogEntity.FieldProcessId, logEntity.ProcessId);
sqlBuilder.SetValue(BaseLogEntity.FieldProcessName, logEntity.ProcessName);
sqlBuilder.SetValue(BaseLogEntity.FieldMethodId, logEntity.MethodId);
sqlBuilder.SetValue(BaseLogEntity.FieldMethodName, logEntity.MethodName);
sqlBuilder.SetValue(BaseLogEntity.FieldParameters, logEntity.Parameters);
sqlBuilder.SetValue(BaseLogEntity.FieldUrlReferrer, logEntity.UrlReferrer);
sqlBuilder.SetValue(BaseLogEntity.FieldWebUrl, logEntity.WebUrl);
sqlBuilder.SetValue(BaseLogEntity.FieldIPAddress, logEntity.IPAddress);
sqlBuilder.SetValue(BaseLogEntity.FieldDescription, logEntity.Description);
//if (logEntity.CreateUserId.Length == 0)
//{
// logEntity.CreateUserId = logEntity.IPAddress;
//}
//sqlBuilder.SetValue(BaseLogEntity.FieldCreateUserId, logEntity.CreateUserId);
sqlBuilder.SetDBNow(BaseLogEntity.FieldCreateOn);
// return sqlBuilder.EndInsert() > 0 ? sequence : string.Empty;
if (DbHelper.CurrentDbType == DbTypes.SqlServer)
{
returnValue = sqlBuilder.EndInsert();
}
else
{
sqlBuilder.EndInsert();
if (this.ReturnId)//如果需要反回值
{
returnValue = int.Parse(logEntity.Id);
}
else
{
returnValue = 0;
}
}
return returnValue;
}
/// <summary>
/// 添加实体
/// </summary>
/// <param name="baseContactEntity">实体</param>
public string AddEntity(BaseContactEntity baseContactEntity)
{
string sequence = string.Empty;
sequence = baseContactEntity.Id;
if (baseContactEntity.SortCode == 0)
{
BaseSequenceManager sequenceManager = new BaseSequenceManager(DbHelper, this.Identity);
sequence = sequenceManager.GetSequence(this.CurrentTableName);
baseContactEntity.SortCode = int.Parse(sequence);
}
SQLBuilder sqlBuilder = new SQLBuilder(DbHelper, this.Identity, this.ReturnId);
sqlBuilder.BeginInsert(BaseContactEntity.TableName, BaseContactEntity.FieldId);
if (baseContactEntity.Id is string)
{
this.Identity = false;
}
if (!this.Identity)
{
sqlBuilder.SetValue(BaseContactEntity.FieldId, baseContactEntity.Id);
}
else
{
if (!this.ReturnId && DbHelper.CurrentDbType == DbTypes.Oracle)
{
sqlBuilder.SetFormula(BaseContactEntity.FieldId, "SEQ_" + this.CurrentTableName.ToUpper() + ".NEXTVAL ");
}
else
{
if (this.Identity && DbHelper.CurrentDbType == DbTypes.Oracle)
{
if (string.IsNullOrEmpty(sequence))
{
BaseSequenceManager sequenceManager = new BaseSequenceManager(DbHelper, this.Identity);
sequence = sequenceManager.GetSequence(this.CurrentTableName);
}
baseContactEntity.Id = sequence;
sqlBuilder.SetValue(BaseContactEntity.FieldId, baseContactEntity.Id);
}
}
}
this.SetEntity(sqlBuilder, baseContactEntity);
if (UserInfo != null)
{
sqlBuilder.SetValue(BaseContactEntity.FieldCreateUserId, UserInfo.Id);
sqlBuilder.SetValue(BaseContactEntity.FieldCreateBy, UserInfo.RealName);
}
sqlBuilder.SetDBNow(BaseContactEntity.FieldCreateOn);
if (UserInfo != null)
{
sqlBuilder.SetValue(BaseContactEntity.FieldModifiedUserId, UserInfo.Id);
sqlBuilder.SetValue(BaseContactEntity.FieldModifiedBy, UserInfo.RealName);
}
sqlBuilder.SetDBNow(BaseContactEntity.FieldModifiedOn);
if (DbHelper.CurrentDbType == DbTypes.SqlServer && this.Identity)
{
sequence = sqlBuilder.EndInsert().ToString();
}
else
{
sqlBuilder.EndInsert();
}
return sequence;
}
/// <summary>
/// 设置属性
/// </summary>
/// <param name="dbHelper">数据库连接</param>
/// <param name="tableName">目标表名</param>
/// <param name="targetFields">更新字段</param>
/// <param name="targetValues">更新值</param>
/// <returns>影响行数</returns>
public static int Insert(IDbHelper dbHelper, string tableName, string[] targetFields, Object[] targetValues)
{
SQLBuilder sqlBuilder = new SQLBuilder(dbHelper);
sqlBuilder.BeginInsert(tableName);
for (int i = 0; i < targetFields.Length; i++)
{
sqlBuilder.SetValue(targetFields[i], targetValues[i]);
}
return sqlBuilder.EndInsert();
}