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