/// <summary> /// 更新 /// </summary> /// <param name="fileEntity">文件夹的基类表结构定义</param> /// <param name="statusCode">状态返回码</param> /// <returns>影响行数</returns> public int Update(CiFileEntity fileEntity, out string statusCode) { var returnValue = 0; //if (DbLogic.IsModifed(DBProvider, CiFileTable.TableName, fileEntity.Id, fileEntity.ModifiedUserId, fileEntity.ModifiedOn)) //{ // // 数据已经被修改 // statusCode = StatusCode.ErrorChanged.ToString(); //} //else //{ // 检查文件夹名是否重复 if (this.Exists(CiFileTable.FieldFolderId, fileEntity.FolderId, CiFileTable.FieldFileName, fileEntity.FileName, fileEntity.Id)) { // 文件夹名已重复 statusCode = StatusCode.ErrorNameExist.ToString(); } else { returnValue = this.UpdateEntity(fileEntity); statusCode = returnValue == 1 ? StatusCode.OKUpdate.ToString() : StatusCode.ErrorDeleted.ToString(); } //} return(returnValue); }
/// <summary> /// 添加文件 /// </summary> /// <param name="folderId">文件夹主键</param> /// <param name="fileName">文件名</param> /// <param name="file">文件</param> /// <param name="byteFile"></param> /// <param name="description"></param> /// <param name="category">文件分类</param> /// <param name="enabled">有效</param> /// <param name="statusCode">状态</param> /// <returns>主键</returns> private string Add(string folderId, string fileName, string file, byte[] byteFile, string description, string category, bool enabled, out string statusCode) { statusCode = string.Empty; var fileEntity = new CiFileEntity { FolderId = folderId, FileName = fileName, FileContent = byteFile, Description = description, Category = category, Enabled = enabled ? 1 : 0 }; var returnValue = string.Empty; // 检查是否重复 if (this.Exists(CiFileTable.FieldFolderId, fileEntity.FolderId, CiFileTable.FieldFileName, fileEntity.FileName)) { // 名称已重复 statusCode = StatusCode.ErrorNameExist.ToString(); } else { returnValue = this.AddEntity(fileEntity); // 运行成功 statusCode = StatusCode.OKAdd.ToString(); } return(returnValue); }
/// <summary> /// 获取实体 /// </summary> /// <param name="userInfo">用户</param> /// <param name="id">主键</param> /// <returns>实体</returns> public CiFileEntity GetEntity(UserInfo userInfo, string id) { CiFileEntity fileEntity = null; var parameter = ParameterUtil.CreateWithMessage(userInfo, MethodBase.GetCurrentMethod(), this.serviceName, RDIFrameworkMessage.FileService_GetEntity); parameter.IsAddLog = false; ServiceUtil.ProcessRDIReadDb(userInfo, parameter, dbProvider => { var fileManager = new CiFileManager(dbProvider, userInfo); fileEntity = fileManager.GetEntity(id); }); return(fileEntity); }
/// <summary> /// 设置实体 /// </summary> /// <param name="sqlBuilder"></param> /// <param name="fileEntity">实体</param> private void SetEntity(SQLBuilder sqlBuilder, CiFileEntity fileEntity) { sqlBuilder.SetValue(CiFileTable.FieldFolderId, fileEntity.FolderId); sqlBuilder.SetValue(CiFileTable.FieldFileName, fileEntity.FileName); sqlBuilder.SetValue(CiFileTable.FieldFilePath, fileEntity.FilePath); sqlBuilder.SetValue(CiFileTable.FieldFileContent, fileEntity.FileContent); sqlBuilder.SetValue(CiFileTable.FieldFileSize, fileEntity.FileSize != null ? fileEntity.FileContent.Length : fileEntity.FileSize); sqlBuilder.SetValue(CiFileTable.FieldImageUrl, fileEntity.ImageUrl); sqlBuilder.SetValue(CiFileTable.FieldReadCount, fileEntity.ReadCount); sqlBuilder.SetValue(CiFileTable.FieldCategory, fileEntity.Category); sqlBuilder.SetValue(CiFileTable.FieldDescription, fileEntity.Description); sqlBuilder.SetValue(CiFileTable.FieldSortCode, fileEntity.SortCode); sqlBuilder.SetValue(CiFileTable.FieldDeleteMark, fileEntity.DeleteMark); }
/// <summary> /// 更新实体 /// </summary> /// <param name="fileEntity">实体</param> public int UpdateEntity(CiFileEntity fileEntity) { var sqlBuilder = new SQLBuilder(DBProvider); sqlBuilder.BeginUpdate(this.CurrentTableName); this.SetEntity(sqlBuilder, fileEntity); if (UserInfo != null) { sqlBuilder.SetValue(CiFileTable.FieldModifiedUserId, UserInfo.Id); sqlBuilder.SetValue(CiFileTable.FieldModifiedBy, UserInfo.RealName); } sqlBuilder.SetDBNow(CiFileTable.FieldModifiedOn); sqlBuilder.SetWhere(CiFileTable.FieldId, fileEntity.Id); return(sqlBuilder.EndUpdate()); }
/// <summary> /// 批量进行保存 /// </summary> /// <param name="dataTable">数据表</param> /// <returns>影响行数</returns> public override int BatchSave(DataTable dataTable) { var returnValue = 0; var fileEntity = new CiFileEntity(); foreach (DataRow dataRow in dataTable.Rows) { // 删除状态 if (dataRow.RowState == DataRowState.Deleted) { var id = dataRow[CiFileTable.FieldId, DataRowVersion.Original].ToString(); if (id.Length > 0) { returnValue += this.Delete(id); } } // 被修改过 if (dataRow.RowState == DataRowState.Modified) { var id = dataRow[CiFileTable.FieldId, DataRowVersion.Original].ToString(); if (id.Length > 0) { fileEntity.GetFrom(dataRow); // 判断是否允许编辑 returnValue += this.UpdateEntity(fileEntity); } } // 添加状态 if (dataRow.RowState == DataRowState.Added) { fileEntity.GetFrom(dataRow); returnValue += this.AddEntity(fileEntity).Length > 0 ? 1 : 0; } if (dataRow.RowState == DataRowState.Unchanged) { continue; } if (dataRow.RowState == DataRowState.Detached) { continue; } } return(returnValue); }
/// <summary> /// 添加文件 /// </summary> /// <param name="fileEntity">有效</param> /// <param name="statusCode">状态</param> /// <returns>主键</returns> public string Add(CiFileEntity fileEntity, out string statusCode) { statusCode = string.Empty; var returnValue = string.Empty; // 检查是否重复 string[] names = { CiFileTable.FieldFolderId, CiFileTable.FieldFileName, CiFileTable.FieldDeleteMark }; Object[] values = { fileEntity.FolderId, fileEntity.FileName, 0 }; if (this.Exists(names, values)) { // 名称已重复 statusCode = StatusCode.ErrorNameExist.ToString(); } else { returnValue = this.AddEntity(fileEntity); // 运行成功 statusCode = StatusCode.OKAdd.ToString(); } return(returnValue); }
/// <summary> /// 重命名 /// </summary> /// <param name="userInfo">用户</param> /// <param name="id">主键</param> /// <param name="newName">新名称</param> /// <param name="enabled">有效</param> /// <param name="statusCode">状态码</param> /// <param name="statusMessage">状态信息</param> /// <returns>影响行数</returns> public int Rename(UserInfo userInfo, string id, string newName, bool enabled, out string statusCode, out string statusMessage) { string returnCode = string.Empty; string returnMessage = string.Empty; int returnValue = 0; var parameter = ParameterUtil.CreateWithLog(userInfo, MethodBase.GetCurrentMethod()); ServiceUtil.ProcessRDIReadDb(userInfo, parameter, dbProvider => { var fileEntity = new CiFileEntity(); var fileManager = new CiFileManager(dbProvider, userInfo); var dataTable = fileManager.GetDTById(id); fileEntity.GetFrom(dataTable); fileEntity.FileName = newName; fileEntity.Enabled = enabled ? 1 : 0; returnValue = fileManager.Update(fileEntity, out returnCode); returnMessage = fileManager.GetStateMessage(returnCode); }); statusCode = returnCode; statusMessage = returnMessage; return(returnValue); }
public string Upload(string folderId, string fileName, byte[] file, bool enabled) { // 检查是否已经存在 var returnValue = this.GetId(CiFileTable.FieldFolderId, folderId, CiFileTable.FieldFileName, fileName); if (!String.IsNullOrEmpty(returnValue)) { // 更新数据 this.UpdateFile(returnValue, fileName, file); } else { // 添加数据 var fileEntity = new CiFileEntity { FolderId = folderId, FileName = fileName, FileContent = file, Enabled = enabled ? 1 : 0 }; returnValue = this.AddEntity(fileEntity); } return(returnValue); }
/// <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="fileEntity">实体</param> public int Update(CiFileEntity fileEntity) { return(this.UpdateEntity(fileEntity)); }
/// <summary> /// 添加 /// </summary> /// <param name="fileEntity">实体</param> /// <param name="identity">自增量方式</param> /// /// <param name="returnId">返回主鍵</param> /// <returns>主键</returns> public string Add(CiFileEntity fileEntity, bool identity, bool returnId) { this.Identity = identity; this.ReturnId = returnId; return(this.AddEntity(fileEntity)); }
/// <summary> /// 添加 /// </summary> /// <param name="fileEntity">实体</param> /// <returns>主键</returns> public string Add(CiFileEntity fileEntity) { return(this.AddEntity(fileEntity)); }