/// <summary> /// UploadFileHandleRecord 数据赋值 /// </summary> /// <param name="record"></param> /// <param name="reader"></param> /// <param name="prefix"></param> public static void SetUploadFileHandleRecordFields(UploadFileHandleRecord record, DbDataReader reader, string prefix) { if (reader[string.Format("{0}id", prefix)] != DBNull.Value) { record.ID = (Guid)reader[string.Format("{0}id", prefix)]; } if (reader[string.Format("{0}UploadFileId", prefix)] != DBNull.Value) { record.UploadFileId = (Guid)reader[string.Format("{0}UploadFileId", prefix)]; } if (reader[string.Format("{0}ConfigurationName", prefix)] != DBNull.Value) { record.ConfigurationName = reader[string.Format("{0}ConfigurationName", prefix)].ToString(); } if (reader[string.Format("{0}Error", prefix)] != DBNull.Value) { record.Error = reader[string.Format("{0}Error", prefix)].ToString(); } if (reader[string.Format("{0}status", prefix)] != DBNull.Value) { record.Status = int.Parse(reader[string.Format("{0}status", prefix)].ToString()); } if (reader[string.Format("{0}UploadFileRegardingType", prefix)] != DBNull.Value) { record.UploadFileRegardingType = reader[string.Format("{0}UploadFileRegardingType", prefix)].ToString(); } if (reader[string.Format("{0}UploadFileRegardingKey", prefix)] != DBNull.Value) { record.UploadFileRegardingKey = reader[string.Format("{0}UploadFileRegardingKey", prefix)].ToString(); } if (reader[string.Format("{0}ExtensionInfo", prefix)] != DBNull.Value) { record.ExtensionInfo = reader[string.Format("{0}ExtensionInfo", prefix)].ToString(); } if (reader[string.Format("{0}ResultInfo", prefix)] != DBNull.Value) { record.ResultInfo = reader[string.Format("{0}ResultInfo", prefix)].ToString(); } if (reader[string.Format("{0}createtime", prefix)] != DBNull.Value) { record.CreateTime = (DateTime)reader[string.Format("{0}createtime", prefix)]; } if (reader[string.Format("{0}modifytime", prefix)] != DBNull.Value) { record.ModifyTime = (DateTime)reader[string.Format("{0}modifytime", prefix)]; } }
public async Task <UploadFileHandleRecord> QueryId(Guid recordId) { UploadFileHandleRecord record = null; await DBTransactionHelper.SqlTransactionWorkAsync(DBTypes.SqlServer, false, false, _fileManagementConnectionFactory.CreateAllForUploadFileHandle(), async (conn, transaction) => { SqlTransaction sqlTran = null; if (transaction != null) { sqlTran = (SqlTransaction)transaction; } await using (SqlCommand command = new SqlCommand() { Connection = (SqlConnection)conn, CommandType = CommandType.Text, CommandText = string.Format(@"SELECT {0} FROM UploadFileHandleRecord WHERE id=@id", StoreHelper.GetUploadFileHandleRecordSelectFields(string.Empty)), Transaction = sqlTran, }) { var parameter = new SqlParameter("@id", SqlDbType.UniqueIdentifier) { Value = recordId }; command.Parameters.Add(parameter); await command.PrepareAsync(); SqlDataReader reader = null; using (reader = await command.ExecuteReaderAsync()) { if (await reader.ReadAsync()) { record = new UploadFileHandleRecord(); StoreHelper.SetUploadFileHandleRecordFields(record, reader, string.Empty); } await reader.CloseAsync(); } } }); return(record); }
public async Task Add(UploadFileHandleRecord record) { await DBTransactionHelper.SqlTransactionWorkAsync(DBTypes.SqlServer, false, false, _fileManagementConnectionFactory.CreateAllForUploadFileHandle(), async (conn, transaction) => { //新增 SqlTransaction sqlTran = null; if (transaction != null) { sqlTran = (SqlTransaction)transaction; } await using (SqlCommand command = new SqlCommand() { Connection = (SqlConnection)conn, CommandType = CommandType.Text, Transaction = sqlTran, }) { SqlParameter parameter; if (record.ID == Guid.Empty) { command.CommandText = @" insert into [UploadFileHandleRecord] ( [id] ,[UploadFileId] ,[ConfigurationName] ,[Error] ,[Status] ,[UploadFileRegardingType] ,[UploadFileRegardingKey] ,[ExtensionInfo] ,[ResultInfo] ,[createtime] ,[modifytime] ) values ( default ,@UploadFileId ,@ConfigurationName ,@Error ,@Status ,@UploadFileRegardingType ,@UploadFileRegardingKey ,@ExtensionInfo ,@ResultInfo ,GETUTCDATE() ,GETUTCDATE() ); select @newid =[id] from UploadFileHandleRecord where [sequence] = SCOPE_IDENTITY()"; parameter = new SqlParameter("@newid", SqlDbType.UniqueIdentifier) { Direction = ParameterDirection.Output }; command.Parameters.Add(parameter); } else { command.CommandText = @"insert into[UploadFileHandleRecord] ( [id] ,[UploadFileId] ,[ConfigurationName] ,[Error] ,[Status] ,[UploadFileRegardingType] ,[UploadFileRegardingKey] ,[ExtensionInfo] ,[ResultInfo] ,[createtime] ,[modifytime] ) values ( @id , @UploadFileId , @ConfigurationName , @Error , @Status , @UploadFileRegardingType , @UploadFileRegardingKey , @ExtensionInfo , @ResultInfo , GETUTCDATE() , GETUTCDATE() )"; parameter = new SqlParameter("@id", SqlDbType.UniqueIdentifier) { Value = record.ID }; command.Parameters.Add(parameter); } parameter = new SqlParameter("@UploadFileId", SqlDbType.UniqueIdentifier) { Value = record.UploadFileId }; command.Parameters.Add(parameter); parameter = new SqlParameter("@ConfigurationName", SqlDbType.NVarChar, 2000) { Value = record.ConfigurationName }; command.Parameters.Add(parameter); parameter = new SqlParameter("@Error", SqlDbType.NVarChar, -1) { Value = (object)record.Error ?? DBNull.Value }; command.Parameters.Add(parameter); parameter = new SqlParameter("@Status", SqlDbType.Int) { Value = record.Status }; command.Parameters.Add(parameter); parameter = new SqlParameter("@UploadFileRegardingType", SqlDbType.NVarChar, 500) { Value = record.UploadFileRegardingType }; command.Parameters.Add(parameter); parameter = new SqlParameter("@UploadFileRegardingKey", SqlDbType.NVarChar, 500) { Value = record.UploadFileRegardingKey }; command.Parameters.Add(parameter); parameter = new SqlParameter("@ExtensionInfo", SqlDbType.NVarChar, 2000) { Value = (object)record.ExtensionInfo ?? DBNull.Value }; command.Parameters.Add(parameter); parameter = new SqlParameter("@ResultInfo", SqlDbType.NVarChar, 2000) { Value = (object)record.ResultInfo ?? DBNull.Value }; command.Parameters.Add(parameter); await command.PrepareAsync(); await command.ExecuteNonQueryAsync(); //如果用户未赋值ID则创建成功后返回ID if (record.ID == Guid.Empty) { record.ID = (Guid)command.Parameters["@newid"].Value; } ; } }); }