Exemple #1
0
        public async Task <UploadFileHandleConfiguration> QueryByNameStatus(string name, int status)
        {
            UploadFileHandleConfiguration conf = 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 UploadFileHandleConfiguration WHERE [name]=@name and [status] = @status", StoreHelper.GetUploadFileHandleConfigurationFields(string.Empty)),
                    Transaction = sqlTran,
                })
                {
                    var parameter = new SqlParameter("@name", SqlDbType.NVarChar, 100)
                    {
                        Value = name
                    };
                    command.Parameters.Add(parameter);


                    parameter = new SqlParameter("@status", SqlDbType.Int)
                    {
                        Value = status
                    };
                    command.Parameters.Add(parameter);

                    await command.PrepareAsync();
                    SqlDataReader reader = null;

                    await using (reader = await command.ExecuteReaderAsync())
                    {
                        if (await reader.ReadAsync())
                        {
                            conf = new UploadFileHandleConfiguration();

                            StoreHelper.SetUploadFileHandleConfigurationFields(conf, reader, string.Empty);
                        }
                        await reader.CloseAsync();
                    }
                }
            });

            return(conf);
        }
Exemple #2
0
        /// <summary>
        /// uploadFileHandleConfiguration数据赋值
        /// </summary>
        /// <param name="uploadFileHandleConfiguration"></param>
        /// <param name="reader"></param>
        /// <param name="prefix"></param>
        public static void SetUploadFileHandleConfigurationFields(UploadFileHandleConfiguration uploadFileHandleConfiguration, DbDataReader reader, string prefix)
        {
            if (reader[string.Format("{0}id", prefix)] != DBNull.Value)
            {
                uploadFileHandleConfiguration.ID = (Guid)reader[string.Format("{0}id", prefix)];
            }
            if (reader[string.Format("{0}name", prefix)] != DBNull.Value)
            {
                uploadFileHandleConfiguration.Name = reader[string.Format("{0}name", prefix)].ToString();
            }
            if (reader[string.Format("{0}AllowSuffixs", prefix)] != DBNull.Value)
            {
                uploadFileHandleConfiguration.AllowSuffixs = reader[string.Format("{0}AllowSuffixs", prefix)].ToString().Split(',');
            }

            if (reader[string.Format("{0}Configuration", prefix)] != DBNull.Value)
            {
                uploadFileHandleConfiguration.Configuration = reader[string.Format("{0}Configuration", prefix)].ToString();
            }
            if (reader[string.Format("{0}Description", prefix)] != DBNull.Value)
            {
                uploadFileHandleConfiguration.Description = reader[string.Format("{0}Description", prefix)].ToString();
            }

            if (reader[string.Format("{0}status", prefix)] != DBNull.Value)
            {
                uploadFileHandleConfiguration.Status = int.Parse(reader[string.Format("{0}status", prefix)].ToString());
            }
            if (reader[string.Format("{0}createtime", prefix)] != DBNull.Value)
            {
                uploadFileHandleConfiguration.CreateTime = (DateTime)reader[string.Format("{0}createtime", prefix)];
            }
            if (reader[string.Format("{0}modifytime", prefix)] != DBNull.Value)
            {
                uploadFileHandleConfiguration.ModifyTime = (DateTime)reader[string.Format("{0}modifytime", prefix)];
            }
        }