/// <summary>
/// 添加
/// </summary>
/// <param name="entity">实体</param>
/// <param name="statusCode">返回状态码</param>
/// <returns>主键</returns>
public string Add(BaseItemsEntity entity, out string statusCode)
{
string result = string.Empty;
// 检查编号是否重复
if (this.Exists(new KeyValuePair <string, object>(BaseItemsEntity.FieldParentId, entity.ParentId), new KeyValuePair <string, object>(BaseItemsEntity.FieldCode, entity.Code)))
{
// 编号已重复
statusCode = Status.ErrorCodeExist.ToString();
}
else
{
// 检查名称是否重复
if (this.Exists(new KeyValuePair <string, object>(BaseItemsEntity.FieldParentId, entity.ParentId), new KeyValuePair <string, object>(BaseItemsEntity.FieldFullName, entity.FullName)))
{
// 名称已重复
statusCode = Status.ErrorNameExist.ToString();
}
else
{
result = this.AddObject(entity);
// 运行成功
statusCode = Status.OKAdd.ToString();
}
}
return(result);
}
/// <summary>
/// 添加实体
/// </summary>
/// <param name="userInfo">用户</param>
/// <param name="entity">实体</param>
/// <param name="statusCode">返回状态码</param>
/// <param name="statusMessage">返回状态信息</param>
/// <returns>数据表</returns>
public string Add(BaseUserInfo userInfo, BaseItemsEntity entity, out string statusCode, out string statusMessage)
{
string result = string.Empty;
string returnCode = string.Empty;
string returnMessage = string.Empty;
var parameter = ServiceInfo.Create(userInfo, MethodBase.GetCurrentMethod());
ServiceUtil.ProcessUserCenterWriteDb(userInfo, parameter, (dbHelper) =>
{
string tableName = BaseItemsEntity.TableName;
if (userInfo != null && !string.IsNullOrEmpty(userInfo.SystemCode))
{
tableName = userInfo.SystemCode + "Items";
}
BaseItemsManager itemsManager = new BaseItemsManager(dbHelper, userInfo, tableName);
// 调用方法，并且返回运行结果
result = itemsManager.Add(entity, out returnCode);
returnMessage = itemsManager.GetStateMessage(returnCode);
});
statusCode = returnCode;
statusMessage = returnMessage;
return(result);
}
public List <BaseItemDetailsEntity> GetListByCode(IDbHelper dbHelper, BaseUserInfo userInfo, string code)
{
// 2013-09-07 吉日嘎拉 目标表，这样来个默认的表名，有助于提高稳定性，可以有一定的容错功能
string targetTable = "Items" + code;
// 检查有其他目标数据库表存储了数据
BaseItemsManager itemsManager = new BaseItemsManager(dbHelper, userInfo);
BaseItemsEntity itemsEntity = BaseEntity.Create <BaseItemsEntity>(itemsManager.GetDataTable(new KeyValuePair <string, object>(BaseItemsEntity.FieldCode, code)));
if (itemsEntity != null && !String.IsNullOrEmpty(itemsEntity.TargetTable))
{
targetTable = itemsEntity.TargetTable;
}
BaseItemDetailsManager itemDetailsManager = new BaseItemDetailsManager(dbHelper, userInfo);
itemDetailsManager = new BaseItemDetailsManager(dbHelper, userInfo, targetTable);
// 这里只要有效的，没被删除的
List <KeyValuePair <string, object> > parameters = new List <KeyValuePair <string, object> >();
// 管理的时候无效的也需要被管理
parameters.Add(new KeyValuePair <string, object>(BaseItemDetailsEntity.FieldEnabled, 1));
parameters.Add(new KeyValuePair <string, object>(BaseItemDetailsEntity.FieldDeletionStateCode, 0));
return(itemDetailsManager.GetList <BaseItemDetailsEntity>(parameters, BaseItemDetailsEntity.FieldSortCode));
}
public DataTable GetDataTableByCode(IDbHelper dbHelper, BaseUserInfo userInfo, string code)
{
// 加强安全验证防止未授权匿名调用
#if (!DEBUG)
LogOnService.UserIsLogOn(userInfo);
#endif
DataTable dataTable = new DataTable(BaseItemDetailsEntity.TableName);
BaseItemDetailsManager itemDetailsManager = new BaseItemDetailsManager(dbHelper, userInfo);
// 检查有其他目标数据库表存储了数据
BaseItemsManager itemsManager = new BaseItemsManager(dbHelper, userInfo);
BaseItemsEntity itemsEntity = new BaseItemsEntity(itemsManager.GetDataTable(new KeyValuePair <string, object>(BaseItemsEntity.FieldCode, code)));
if (!String.IsNullOrEmpty(itemsEntity.TargetTable))
{
itemDetailsManager = new BaseItemDetailsManager(dbHelper, userInfo, itemsEntity.TargetTable);
}
// 这里只要有效的，没被删除的
List <KeyValuePair <string, object> > parameters = new List <KeyValuePair <string, object> >();
parameters.Add(new KeyValuePair <string, object>(BaseItemDetailsEntity.FieldEnabled, 1));
parameters.Add(new KeyValuePair <string, object>(BaseItemDetailsEntity.FieldDeletionStateCode, 0));
dataTable = itemDetailsManager.GetDataTable(parameters, BaseItemDetailsEntity.FieldSortCode);
dataTable.TableName = itemsEntity.TargetTable;
return(dataTable);
}
/// <summary>
/// 批量进行保存
/// </summary>
/// <param name="result">数据表</param>
/// <returns>影响行数</returns>
public override int BatchSave(DataTable dt)
{
int result = 0;
BaseItemsEntity itemsEntity = new BaseItemsEntity();
foreach (DataRow dr in dt.Rows)
{
// 删除状态
if (dr.RowState == DataRowState.Deleted)
{
string id = dr[BaseItemsEntity.FieldId, DataRowVersion.Original].ToString();
if (id.Length > 0)
{
if (itemsEntity.AllowDelete == 1)
{
result += this.Delete(id);
}
}
}
// 被修改过
if (dr.RowState == DataRowState.Modified)
{
string id = dr[BaseItemsEntity.FieldId, DataRowVersion.Original].ToString();
if (id.Length > 0)
{
itemsEntity.GetFrom(dr);
// 判断是否允许编辑
if (itemsEntity.AllowEdit == 1)
{
result += this.UpdateObject(itemsEntity);
}
else
{
// 不允许编辑，但是排序还是允许的
result += this.SetProperty(itemsEntity.Id, new KeyValuePair <string, object>(BaseItemsEntity.FieldSortCode, itemsEntity.SortCode));
}
}
}
// 添加状态
if (dr.RowState == DataRowState.Added)
{
itemsEntity.GetFrom(dr);
result += this.AddObject(itemsEntity).Length > 0 ? 1 : 0;
}
if (dr.RowState == DataRowState.Unchanged)
{
continue;
}
if (dr.RowState == DataRowState.Detached)
{
continue;
}
}
return(result);
}
/// <summary>
/// 更新实体
/// </summary>
/// <param name="userInfo">用户</param>
/// <param name="itemsEntity">实体</param>
/// <param name="statusCode">返回状态码</param>
/// <param name="statusMessage">返回状态信息</param>
/// <returns>数据表</returns>
public int Update(BaseUserInfo userInfo, BaseItemsEntity itemsEntity, out string statusCode, out string statusMessage)
{
// 写入调试信息
#if (DEBUG)
int milliStart = BaseBusinessLogic.StartDebug(userInfo, MethodBase.GetCurrentMethod());
#endif
// 加强安全验证防止未授权匿名调用
#if (!DEBUG)
LogOnService.UserIsLogOn(userInfo);
#endif
statusCode = string.Empty;
statusMessage = string.Empty;
int returnValue = 0;
using (IDbHelper dbHelper = DbHelperFactory.GetHelper(BaseSystemInfo.UserCenterDbType))
{
try
{
dbHelper.Open(UserCenterDbConnection);
string tableName = BaseItemsEntity.TableName;
if (!string.IsNullOrEmpty(BaseSystemInfo.SystemCode))
{
tableName = BaseSystemInfo.SystemCode + "Items";
}
BaseItemsManager itemsManager = new BaseItemsManager(dbHelper, userInfo, tableName);
// 更新数据
returnValue = itemsManager.Update(itemsEntity, out statusCode);
statusMessage = itemsManager.GetStateMessage(statusCode);
BaseLogManager.Instance.Add(dbHelper, userInfo, this.serviceName, AppMessage.ItemsService_Update, MethodBase.GetCurrentMethod());
}
catch (Exception ex)
{
BaseExceptionManager.LogException(dbHelper, userInfo, ex);
throw ex;
}
finally
{
dbHelper.Close();
}
}
// 写入调试信息
#if (DEBUG)
BaseBusinessLogic.EndDebug(MethodBase.GetCurrentMethod(), milliStart);
#endif
return(returnValue);
}
/// <summary>
/// 获取实体
/// </summary>
/// <param name="userInfo">用户</param>
/// <param name="id">主键</param>
/// <returns>实体</returns>
public BaseItemsEntity GetObject(BaseUserInfo userInfo, string id)
{
BaseItemsEntity itemsEntity = null;
var parameter = ServiceInfo.Create(userInfo, MethodBase.GetCurrentMethod());
ServiceUtil.ProcessBusinessDb(userInfo, parameter, (dbHelper) =>
{
string tableName = userInfo.SystemCode + "Items";
var manager = new BaseItemsManager(dbHelper, userInfo, tableName);
itemsEntity = manager.GetObject(id);
});
return(itemsEntity);
}
/// <summary>
/// 设置实体
/// </summary>
/// <param name="entity">实体</param>
private void SetObject(SQLBuilder sqlBuilder, BaseItemsEntity entity)
{
sqlBuilder.SetValue(BaseItemsEntity.FieldParentId, entity.ParentId);
sqlBuilder.SetValue(BaseItemsEntity.FieldCode, entity.Code);
sqlBuilder.SetValue(BaseItemsEntity.FieldFullName, entity.FullName);
sqlBuilder.SetValue(BaseItemsEntity.FieldTargetTable, entity.TargetTable);
sqlBuilder.SetValue(BaseItemsEntity.FieldIsTree, entity.IsTree);
sqlBuilder.SetValue(BaseItemsEntity.FieldAllowEdit, entity.AllowEdit);
sqlBuilder.SetValue(BaseItemsEntity.FieldAllowDelete, entity.AllowDelete);
sqlBuilder.SetValue(BaseItemsEntity.FieldDeletionStateCode, entity.DeletionStateCode);
sqlBuilder.SetValue(BaseItemsEntity.FieldDescription, entity.Description);
sqlBuilder.SetValue(BaseItemsEntity.FieldEnabled, entity.Enabled);
sqlBuilder.SetValue(BaseItemsEntity.FieldSortCode, entity.SortCode);
SetObjectExpand(sqlBuilder, entity);
}
/// <summary>
/// 更新实体
/// </summary>
/// <param name="entity">实体</param>
public int UpdateObject(BaseItemsEntity entity)
{
SQLBuilder sqlBuilder = new SQLBuilder(DbHelper);
sqlBuilder.BeginUpdate(this.CurrentTableName);
this.SetObject(sqlBuilder, entity);
if (UserInfo != null)
{
sqlBuilder.SetValue(BaseItemsEntity.FieldModifiedUserId, UserInfo.Id);
sqlBuilder.SetValue(BaseItemsEntity.FieldModifiedBy, UserInfo.RealName);
}
sqlBuilder.SetDBNow(BaseItemsEntity.FieldModifiedOn);
sqlBuilder.SetWhere(BaseItemsEntity.FieldId, entity.Id);
return(sqlBuilder.EndUpdate());
}
/// <summary>
/// 获取实体
/// </summary>
/// <param name="userInfo">用户</param>
/// <param name="id">主键</param>
/// <returns>实体</returns>
public BaseItemsEntity GetObject(BaseUserInfo userInfo, string id)
{
BaseItemsEntity entity = null;
var parameter = ServiceInfo.Create(userInfo, MethodBase.GetCurrentMethod());
ServiceUtil.ProcessUserCenterReadDb(userInfo, parameter, (dbHelper) =>
{
string tableName = BaseItemsEntity.TableName;
if (userInfo != null && !string.IsNullOrEmpty(userInfo.SystemCode))
{
tableName = userInfo.SystemCode + "Items";
}
BaseItemsManager itemsManager = new BaseItemsManager(dbHelper, userInfo, tableName);
entity = itemsManager.GetObject(id);
});
return(entity);
}
public List <BaseItemDetailsEntity> GetListByTargetTable(IDbHelper dbHelper, BaseUserInfo userInfo, string tableName)
{
List <BaseItemDetailsEntity> result = null;
// 检查有其他目标数据库表存储了数据
var itemsManager = new BaseItemsManager(dbHelper, userInfo);
BaseItemsEntity itemsEntity = BaseEntity.Create <BaseItemsEntity>(itemsManager.GetDataTable(new KeyValuePair <string, object>(BaseItemsEntity.FieldTargetTable, tableName)));
if (!String.IsNullOrEmpty(itemsEntity.TargetTable))
{
BaseItemDetailsManager itemDetailsManager = new BaseItemDetailsManager(dbHelper, userInfo, itemsEntity.TargetTable);
// 这里只要有效的，没被删除的
List <KeyValuePair <string, object> > parameters = new List <KeyValuePair <string, object> >();
// 管理的时候无效的也需要被管理
parameters.Add(new KeyValuePair <string, object>(BaseItemDetailsEntity.FieldEnabled, 1));
parameters.Add(new KeyValuePair <string, object>(BaseItemDetailsEntity.FieldDeletionStateCode, 0));
result = itemDetailsManager.GetList <BaseItemDetailsEntity>(parameters, BaseItemDetailsEntity.FieldSortCode);
}
return(result);
}
public DataTable GetDataTableByCode(IDbHelper dbHelper, BaseUserInfo userInfo, string code)
{
// 2013-09-07 吉日嘎拉 目标表，这样来个默认的表名，有助于提高稳定性，可以有一定的容错功能
string targetTable = "Items" + code;
var dt = new DataTable(BaseItemDetailsEntity.TableName);
// 检查有其他目标数据库表存储了数据
BaseItemsManager itemsManager = new BaseItemsManager(dbHelper, userInfo);
BaseItemsEntity itemsEntity = BaseEntity.Create <BaseItemsEntity>(itemsManager.GetDataTable(new KeyValuePair <string, object>(BaseItemsEntity.FieldCode, code)));
if (itemsEntity != null && !String.IsNullOrEmpty(itemsEntity.TargetTable))
{
targetTable = itemsEntity.TargetTable;
}
BaseItemDetailsManager itemDetailsManager = new BaseItemDetailsManager(dbHelper, userInfo);
itemDetailsManager = new BaseItemDetailsManager(dbHelper, userInfo, targetTable);
// 这里只要有效的，没被删除的
List <KeyValuePair <string, object> > parameters = new List <KeyValuePair <string, object> >();
// 管理的时候无效的也需要被管理
parameters.Add(new KeyValuePair <string, object>(BaseItemDetailsEntity.FieldEnabled, 1));
parameters.Add(new KeyValuePair <string, object>(BaseItemDetailsEntity.FieldDeletionStateCode, 0));
// 管理员取得所有数据，没采用数据权限的开关
if (userInfo.IsAdministrator || !BaseSystemInfo.UsePermissionScope)
{
dt = itemDetailsManager.GetDataTable(parameters, BaseItemDetailsEntity.FieldSortCode);
}
else
{
// 按数据权限来过滤数据
BasePermissionScopeManager permissionScopeManager = new BasePermissionScopeManager(dbHelper, userInfo);
string[] ids = permissionScopeManager.GetResourceScopeIds(userInfo.SystemCode, userInfo.Id, itemsEntity.TargetTable, "Resource.ManagePermission");
dt = itemDetailsManager.GetDataTable(ids);
// 这里其实未必限制了有效的
// BaseBusinessLogic.SetFilter(result, BaseItemDetailsEntity.FieldDeletionStateCode, "0");
// BaseBusinessLogic.SetFilter(result, BaseItemDetailsEntity.FieldEnabled, "1");
}
dt.TableName = itemsEntity.TargetTable;
return(dt);
}
/// <summary>
/// 更新
/// </summary>
/// <param name="entity">实体</param>
/// <param name="statusCode">返回状态码</param>
/// <returns>影响行数</returns>
public int Update(BaseItemsEntity entity, out string statusCode)
{
int result = 0;
// 检查是否已被其他人修改
//if (DbLogic.IsModifed(DbHelper, this.CurrentTableName, itemsEntity.Id, itemsEntity.ModifiedUserId, itemsEntity.ModifiedOn))
//{
// // 数据已经被修改
// statusCode = StatusCode.ErrorChanged.ToString();
//}
//else
//{
// 检查编号是否重复
if (this.Exists(new KeyValuePair <string, object>(BaseItemsEntity.FieldParentId, entity.ParentId), new KeyValuePair <string, object>(BaseItemsEntity.FieldCode, entity.Code), entity.Id))
{
// 编号已重复
statusCode = Status.ErrorCodeExist.ToString();
}
else
{
// 检查名称是否重复
if (this.Exists(new KeyValuePair <string, object>(BaseItemsEntity.FieldParentId, entity.ParentId), new KeyValuePair <string, object>(BaseItemsEntity.FieldFullName, entity.FullName), entity.Id))
{
// 名称已重复
statusCode = Status.ErrorNameExist.ToString();
}
else
{
result = this.UpdateObject(entity);
if (result == 1)
{
statusCode = Status.OKUpdate.ToString();
}
else
{
statusCode = Status.ErrorDeleted.ToString();
}
}
}
//}
return(result);
}
/// <summary>
/// 添加实体
/// </summary>
/// <param name="userInfo">用户</param>
/// <param name="entity">实体</param>
/// <param name="statusCode">返回状态码</param>
/// <param name="statusMessage">返回状态信息</param>
/// <returns>数据表</returns>
public string Add(BaseUserInfo userInfo, BaseItemsEntity entity, out string statusCode, out string statusMessage)
{
string result = string.Empty;
string returnCode = string.Empty;
string returnMessage = string.Empty;
var parameter = ServiceInfo.Create(userInfo, MethodBase.GetCurrentMethod());
ServiceUtil.ProcessBusinessDb(userInfo, parameter, (dbHelper) =>
{
string tableName = userInfo.SystemCode + "Items";
var manager = new BaseItemsManager(dbHelper, userInfo, tableName);
// 调用方法，并且返回运行结果
result = manager.Add(entity, out returnCode);
returnMessage = manager.GetStateMessage(returnCode);
});
statusCode = returnCode;
statusMessage = returnMessage;
return(result);
}
/// <summary>
/// 添加实体
/// </summary>
/// <param name="itemsEntity">实体</param>
public string AddEntity(BaseItemsEntity itemsEntity)
{
string sequence = string.Empty;
if (itemsEntity.SortCode == 0)
{
BaseSequenceManager sequenceManager = new BaseSequenceManager(DbHelper, this.Identity);
sequence = sequenceManager.GetSequence(this.CurrentTableName);
itemsEntity.SortCode = int.Parse(sequence);
}
SQLBuilder sqlBuilder = new SQLBuilder(DbHelper, this.Identity, this.ReturnId);
sqlBuilder.BeginInsert(this.CurrentTableName, BaseItemsEntity.FieldId);
if (!this.Identity)
{
sqlBuilder.SetValue(BaseItemsEntity.FieldId, itemsEntity.Id);
}
else
{
if (!this.ReturnId && (DbHelper.CurrentDbType == CurrentDbType.Oracle || DbHelper.CurrentDbType == CurrentDbType.DB2))
{
if (DbHelper.CurrentDbType == CurrentDbType.Oracle)
{
sqlBuilder.SetFormula(BaseItemsEntity.FieldId, "SEQ_" + this.CurrentTableName.ToUpper() + ".NEXTVAL ");
}
if (DbHelper.CurrentDbType == CurrentDbType.DB2)
{
sqlBuilder.SetFormula(BaseItemsEntity.FieldId, "NEXT VALUE FOR SEQ_" + this.CurrentTableName.ToUpper());
}
}
else
{
if (this.Identity && (DbHelper.CurrentDbType == CurrentDbType.Oracle || DbHelper.CurrentDbType == CurrentDbType.DB2))
{
if (string.IsNullOrEmpty(sequence))
{
BaseSequenceManager sequenceManager = new BaseSequenceManager(DbHelper, this.Identity);
sequence = sequenceManager.GetSequence(this.CurrentTableName);
}
itemsEntity.Id = int.Parse(sequence);
sqlBuilder.SetValue(BaseItemsEntity.FieldId, itemsEntity.Id);
}
}
}
this.SetEntity(sqlBuilder, itemsEntity);
if (UserInfo != null)
{
sqlBuilder.SetValue(BaseItemsEntity.FieldCreateUserId, UserInfo.Id);
sqlBuilder.SetValue(BaseItemsEntity.FieldCreateBy, UserInfo.RealName);
}
sqlBuilder.SetDBNow(BaseItemsEntity.FieldCreateOn);
if (UserInfo != null)
{
sqlBuilder.SetValue(BaseItemsEntity.FieldModifiedUserId, UserInfo.Id);
sqlBuilder.SetValue(BaseItemsEntity.FieldModifiedBy, UserInfo.RealName);
}
sqlBuilder.SetDBNow(BaseItemsEntity.FieldModifiedOn);
if (DbHelper.CurrentDbType == CurrentDbType.SqlServer && this.Identity)
{
sequence = sqlBuilder.EndInsert().ToString();
}
else
{
sqlBuilder.EndInsert();
}
return(sequence);
}
/// <summary>
/// 添加
/// </summary>
/// <param name="entity">实体</param>
/// <returns>主键</returns>
public string Add(BaseItemsEntity entity)
{
return(this.AddObject(entity));
}
/// <summary>
/// 添加
/// </summary>
/// <param name="itemsEntity">实体</param>
/// <returns>主键</returns>
public string Add(BaseItemsEntity itemsEntity)
{
return(this.AddEntity(itemsEntity));
}
partial void SetObjectExpand(SQLBuilder sqlBuilder, BaseItemsEntity entity);
/// <summary>
/// 获取实体
/// </summary>
/// <param name="id">主键</param>
public BaseItemsEntity GetEntity(string id)
{
BaseItemsEntity itemsEntity = new BaseItemsEntity(this.GetDataTable(new KeyValuePair <string, object>(BaseItemsEntity.FieldId, id)));
return(itemsEntity);
}
/// <summary>
/// 更新
/// </summary>
/// <param name="itemsEntity">实体</param>
public int Update(BaseItemsEntity itemsEntity)
{
return(this.UpdateEntity(itemsEntity));
}
/// <summary>
/// 添加实体
/// </summary>
/// <param name="entity">实体</param>
public string AddObject(BaseItemsEntity entity)
{
string result = string.Empty;
if (entity.SortCode == 0)
{
BaseSequenceManager sequenceManager = new BaseSequenceManager(DbHelper, this.Identity);
result = sequenceManager.Increment(this.CurrentTableName);
entity.SortCode = int.Parse(result);
}
SQLBuilder sqlBuilder = new SQLBuilder(DbHelper, this.Identity, this.ReturnId);
sqlBuilder.BeginInsert(this.CurrentTableName, BaseItemsEntity.FieldId);
if (!this.Identity)
{
sqlBuilder.SetValue(BaseItemsEntity.FieldId, entity.Id);
}
else
{
if (!this.ReturnId && (DbHelper.CurrentDbType == CurrentDbType.Oracle || DbHelper.CurrentDbType == CurrentDbType.DB2))
{
if (DbHelper.CurrentDbType == CurrentDbType.Oracle)
{
// // 2015-09-25 吉日嘎拉 用一个序列就可以了，不用那么多序列了
// sqlBuilder.SetFormula(BaseItemsEntity.FieldId, "SEQ_" + this.CurrentTableName.ToUpper() + ".NEXTVAL ");
sqlBuilder.SetFormula(BaseItemsEntity.FieldId, "SEQ_" + BaseItemsEntity.TableName.ToUpper() + ".NEXTVAL ");
}
if (DbHelper.CurrentDbType == CurrentDbType.DB2)
{
// sqlBuilder.SetFormula(BaseItemsEntity.FieldId, "NEXT VALUE FOR SEQ_" + this.CurrentTableName.ToUpper());
sqlBuilder.SetFormula(BaseItemsEntity.FieldId, "NEXT VALUE FOR SEQ_" + BaseItemsEntity.TableName.ToUpper());
}
}
else
{
if (this.Identity && (DbHelper.CurrentDbType == CurrentDbType.Oracle || DbHelper.CurrentDbType == CurrentDbType.DB2))
{
if (string.IsNullOrEmpty(result))
{
BaseSequenceManager sequenceManager = new BaseSequenceManager(DbHelper, this.Identity);
result = sequenceManager.Increment(this.CurrentTableName);
}
entity.Id = int.Parse(result);
sqlBuilder.SetValue(BaseItemsEntity.FieldId, entity.Id);
}
}
}
this.SetObject(sqlBuilder, entity);
if (UserInfo != null)
{
sqlBuilder.SetValue(BaseItemsEntity.FieldCreateUserId, UserInfo.Id);
sqlBuilder.SetValue(BaseItemsEntity.FieldCreateBy, UserInfo.RealName);
}
sqlBuilder.SetDBNow(BaseItemsEntity.FieldCreateOn);
if (UserInfo != null)
{
sqlBuilder.SetValue(BaseItemsEntity.FieldModifiedUserId, UserInfo.Id);
sqlBuilder.SetValue(BaseItemsEntity.FieldModifiedBy, UserInfo.RealName);
}
sqlBuilder.SetDBNow(BaseItemsEntity.FieldModifiedOn);
if (DbHelper.CurrentDbType == CurrentDbType.SqlServer && this.Identity)
{
result = sqlBuilder.EndInsert().ToString();
}
else
{
sqlBuilder.EndInsert();
}
return(result);
}
/// <summary>
/// 更新
/// </summary>
/// <param name="entity">实体</param>
public int Update(BaseItemsEntity entity)
{
return(this.UpdateObject(entity));
}
/// <summary>
/// 添加
/// </summary>
/// <param name="entity">实体</param>
/// <param name="identity">自增量方式</param>
/// <param name="returnId">返回主鍵</param>
/// <returns>主键</returns>
public string Add(BaseItemsEntity entity, bool identity, bool returnId)
{
this.Identity = identity;
this.ReturnId = returnId;
return(this.AddObject(entity));
}
partial void SetEntityExpand(SQLBuilder sqlBuilder, BaseItemsEntity itemsEntity);
