/// <summary>
/// 更新实体
/// </summary>
/// <param name="ciParameterEntity">实体</param>
public int UpdateEntity(CiParameterEntity ciParameterEntity)
{
SQLBuilder sqlBuilder = new SQLBuilder(DBProvider);
sqlBuilder.BeginUpdate(this.CurrentTableName);
this.SetEntity(sqlBuilder, ciParameterEntity);
if (UserInfo != null)
{
sqlBuilder.SetValue(CiParameterTable.FieldModifiedBy, UserInfo.RealName);
}
sqlBuilder.SetDBNow(CiParameterTable.FieldModifiedOn);
sqlBuilder.SetWhere(CiParameterTable.FieldId, ciParameterEntity.Id);
return(sqlBuilder.EndUpdate());
}
/// <summary>
/// 更新实体
/// </summary>
/// <param name="mainUserControlEntity">实体</param>
public int UpdateEntity(MainUserControlEntity mainUserControlEntity)
{
var sqlBuilder = new SQLBuilder(DBProvider);
sqlBuilder.BeginUpdate(this.CurrentTableName);
this.SetEntity(sqlBuilder, mainUserControlEntity);
if (UserInfo != null)
{
sqlBuilder.SetValue(MainUserControlTable.FieldModifiedUserId, UserInfo.Id);
sqlBuilder.SetValue(MainUserControlTable.FieldModifiedBy, UserInfo.RealName);
}
sqlBuilder.SetDBNow(MainUserControlTable.FieldModifiedOn);
sqlBuilder.SetWhere(MainUserControlTable.FieldId, mainUserControlEntity.Id);
return(sqlBuilder.EndUpdate());
}
/// <summary>
/// 更新实体
/// </summary>
/// <param name="piPlatFormAddInEntity">实体</param>
public int UpdateEntity(PiPlatFormAddInEntity piPlatFormAddInEntity)
{
SQLBuilder sqlBuilder = new SQLBuilder(DBProvider);
sqlBuilder.BeginUpdate(this.CurrentTableName);
this.SetEntity(sqlBuilder, piPlatFormAddInEntity);
if (UserInfo != null)
{
sqlBuilder.SetValue(PiPlatFormAddInTable.FieldModifiedBy, UserInfo.RealName);
sqlBuilder.SetValue(PiPlatFormAddInTable.FieldModifiedUserId, piPlatFormAddInEntity.ModifiedUserId);
}
sqlBuilder.SetDBNow(PiPlatFormAddInTable.FieldModifiedOn);
sqlBuilder.SetWhere(PiPlatFormAddInTable.FieldId, piPlatFormAddInEntity.Id);
return(sqlBuilder.EndUpdate());
}
/// <summary>
/// 更新实体
/// </summary>
/// <param name="workFlowTemplateEntity">实体</param>
public int UpdateEntity(WorkFlowTemplateEntity workFlowTemplateEntity)
{
var sqlBuilder = new SQLBuilder(DBProvider);
sqlBuilder.BeginUpdate(this.CurrentTableName);
this.SetEntity(sqlBuilder, workFlowTemplateEntity);
if (UserInfo != null)
{
sqlBuilder.SetValue(WorkFlowTemplateTable.FieldModifiedUserId, UserInfo.Id);
sqlBuilder.SetValue(WorkFlowTemplateTable.FieldModifiedBy, UserInfo.RealName);
}
sqlBuilder.SetDBNow(WorkFlowTemplateTable.FieldModifiedOn);
sqlBuilder.SetWhere(WorkFlowTemplateTable.FieldWorkFlowId, workFlowTemplateEntity.WorkFlowId);
return(sqlBuilder.EndUpdate());
}
/// <summary>
/// 更新实体
/// </summary>
/// <param name="permissionItemEntity">实体</param>
public int UpdateEntity(PiPermissionItemEntity permissionItemEntity)
{
SQLBuilder sqlBuilder = new SQLBuilder(DBProvider);
sqlBuilder.BeginUpdate(PiPermissionItemTable.TableName);
this.SetEntity(sqlBuilder, permissionItemEntity);
if (UserInfo != null)
{
sqlBuilder.SetValue(PiPermissionItemTable.FieldModifiedUserId, UserInfo.Id);
sqlBuilder.SetValue(PiPermissionItemTable.FieldModifiedBy, UserInfo.RealName);
}
sqlBuilder.SetDBNow(PiPermissionItemTable.FieldModifiedOn);
sqlBuilder.SetWhere(PiPermissionItemTable.FieldId, permissionItemEntity.Id);
return(sqlBuilder.EndUpdate());
}
public int UpdateFile(string id, string fileName, byte[] file)
{
var sqlBuilder = new SQLBuilder(DBProvider);
sqlBuilder.BeginUpdate(CiFileTable.TableName);
sqlBuilder.SetValue(CiFileTable.FieldFileName, fileName);
if (file != null)
{
sqlBuilder.SetValue(CiFileTable.FieldFileContent, file);
sqlBuilder.SetValue(CiFileTable.FieldFileSize, file.Length);
}
sqlBuilder.SetValue(CiFileTable.FieldModifiedUserId, UserInfo.Id);
sqlBuilder.SetValue(CiFileTable.FieldModifiedBy, UserInfo.RealName);
sqlBuilder.SetDBNow(CiFileTable.FieldModifiedOn);
sqlBuilder.SetWhere(CiFileTable.FieldId, id);
return(sqlBuilder.EndUpdate());
}
/// <summary>
/// 更新实体
/// </summary>
/// <param name="queryEngineDefineEntity">实体</param>
/// <param name="statusCode">返回状态码</param>
/// <returns>影响行数</returns>
public int UpdateEntity(QueryEngineDefineEntity queryEngineDefineEntity, out string statusCode)
{
SQLBuilder sqlBuilder = new SQLBuilder(DBProvider);
sqlBuilder.BeginUpdate(this.CurrentTableName);
this.SetEntity(sqlBuilder, queryEngineDefineEntity);
if (UserInfo != null)
{
sqlBuilder.SetValue(QueryEngineDefineTable.FieldModifiedUserId, UserInfo.Id);
sqlBuilder.SetValue(QueryEngineDefineTable.FieldModifiedBy, UserInfo.RealName);
}
sqlBuilder.SetDBNow(QueryEngineDefineTable.FieldModifiedOn);
sqlBuilder.SetWhere(QueryEngineDefineTable.FieldId, queryEngineDefineEntity.Id);
int returnValue = sqlBuilder.EndUpdate();
statusCode = returnValue == 1 ? StatusCode.OKUpdate.ToString() : StatusCode.ErrorDeleted.ToString();
return(returnValue);
}
//
// 重置序列(暂不考虑并发问题)
//
#region public int Reset(string[] ids) 批量重置
/// <summary>
/// 批量重置
/// </summary>
/// <param name="ids">主键数组</param>
/// <returns>影响行数</returns>
public int Reset(string[] ids)
{
int returnValue = 0;
SQLBuilder sqlBuilder = new SQLBuilder(DBProvider);
for (int i = 0; i < ids.Length; i++)
{
if (ids[i].Length > 0)
{
sqlBuilder.BeginUpdate(CiSequenceTable.TableName);
sqlBuilder.SetValue(CiSequenceTable.FieldSequence, this.DefaultSequence);
sqlBuilder.SetValue(CiSequenceTable.FieldReduction, this.DefaultReduction);
sqlBuilder.SetWhere(CiSequenceTable.FieldId, ids[i]);
returnValue += sqlBuilder.EndUpdate();
}
}
return(returnValue);
}
public int Update(string id, string folderId, string fileName, string description, bool enabled, out string statusCode)
{
statusCode = string.Empty;
var sqlBuilder = new SQLBuilder(DBProvider);
sqlBuilder.BeginUpdate(CiFileTable.TableName);
sqlBuilder.SetValue(CiFileTable.FieldFolderId, folderId);
sqlBuilder.SetValue(CiFileTable.FieldFileName, fileName);
sqlBuilder.SetValue(CiFileTable.FieldEnabled, enabled);
sqlBuilder.SetValue(CiFileTable.FieldDescription, description);
sqlBuilder.SetValue(CiFileTable.FieldModifiedUserId, UserInfo.Id);
sqlBuilder.SetValue(CiFileTable.FieldModifiedBy, UserInfo.RealName);
sqlBuilder.SetDBNow(CiFileTable.FieldModifiedOn);
sqlBuilder.SetWhere(CiFileTable.FieldId, id);
var returnValue = sqlBuilder.EndUpdate();
statusCode = returnValue > 0 ? StatusCode.OKUpdate.ToString() : StatusCode.ErrorDeleted.ToString();
return(returnValue);
}
