public async Task <JObject> GetDataByOperationByIdAsync(CancellationToken cancellationToken, string tableName, int id, Stack <string> fields, bool ifIdIsNeed)
{
JObject _operation = null;
try
{
//name = "report" + name;
//logger.Log(NLog.LogLevel.Info, "Вызов ReportOperationDA.GetDataByOperationByIdAsync(" + name + " name," + id + " id ," + _reportRowStack + ", _reportRowStack, CancellationToken cancellationToken)");
using (SqlConnection _sqlConnection = new SqlConnection(connectionString))
{
IInformationSchemaDA _informationSchema = new InformationSchemaDA(connectionString);/* NinjectWebCommon.GetKernel().Get<IInformationSchemaService>("InformationSchemaService");*/
var _operationFieldsStack = await _informationSchema.GetAllFieldFromTableAsync(tableName, cancellationToken, ifIdIsNeed);
string _fieldNames = string.Empty;
if (_operationFieldsStack == null)
{
return(null);
}
while (_operationFieldsStack.Count > 0)
{
if (fields != null && fields.Count > 0 && fields.Any(x => 0 == string.Compare(x, _operationFieldsStack.Peek(), true)))
{
if (_fieldNames.Length > 0)
{
_fieldNames += "," + tableName + "." + fields.Pop();
}
else
{
_fieldNames += " " + tableName + "." + fields.Pop();
}
}
else
{
_operationFieldsStack.Pop();
}
}
if (_fieldNames == null)
{
return(null);
}
await _sqlConnection.OpenAsync();
SqlCommand _sqlCommand = new SqlCommand(@"select top 1 " + _fieldNames + " from " + tableName + " where id='" + id + "'", _sqlConnection);
using (SqlDataReader _sqlDataReader = await _sqlCommand.ExecuteReaderAsync())
{
while (await _sqlDataReader.ReadAsync())
{
_operation = new JObject();
for (int i = 0; i < _sqlDataReader.FieldCount; i++)
{
if (!_sqlDataReader.IsDBNull(_sqlDataReader.GetOrdinal(_sqlDataReader.GetName(i))))
{
_operation.Add(_sqlDataReader.GetName(i), _sqlDataReader.GetValue(_sqlDataReader.GetOrdinal(_sqlDataReader.GetName(i))).ToString());
}
else
{
_operation.Add(_sqlDataReader.GetName(i), null);
}
}
}
}
}
}
catch (SqlException ex)
{
//logger.Log(NLog.LogLevel.Error, "Вызов GetDataByOperationByIdAsync(" + name + " name," + id + " id ," + _reportRowStack + ", _reportRowStack, CancellationToken cancellationToken)");
throw;
}
catch (Exception ex)
{
//logger.Log(NLog.LogLevel.Error, "Вызов GetDataByOperationByIdAsync(" + name + " name," + id + " id ," + _reportRowStack + ", _reportRowStack, CancellationToken cancellationToken)");
throw;
}
return(_operation);
}
public async Task <List <JObject> > GetOperationDataAsync(string name, ICollection <string> fields, bool ifIdIsNeed, CancellationToken cancellationToken)
{
List <JObject> _operationList = new List <JObject>();
try
{
using (SqlConnection _sqlConnection = new SqlConnection(connectionString))
{
IInformationSchemaDA _informationSchema = new InformationSchemaDA(connectionString);
var _operationFieldsStack = await _informationSchema.GetAllFieldFromTableAsync(name, cancellationToken, ifIdIsNeed);
string _fieldNames = string.Empty;
if (_operationFieldsStack == null)
{
return(null);
}
while (_operationFieldsStack.Count > 0)
{
if (fields != null && fields.Count > 0 && fields.Any(x => 0 == string.Compare(x, _operationFieldsStack.Peek(), true)))
{
if (_fieldNames.Length > 0)
{
_fieldNames += "," + name + "." + _operationFieldsStack.Pop();
}
else
{
_fieldNames += " " + name + "." + _operationFieldsStack.Pop();
}
}
else
{
_operationFieldsStack.Pop();
}
}
await _sqlConnection.OpenAsync();
SqlCommand _sqlCommand = new SqlCommand(@"select " + _fieldNames + " from " + name, _sqlConnection);
using (SqlDataReader _sqlDataReader = await _sqlCommand.ExecuteReaderAsync())
{
while (await _sqlDataReader.ReadAsync())
{
JObject _operation = new JObject();
for (int i = 0; i < _sqlDataReader.FieldCount; i++)
{
if (!_sqlDataReader.IsDBNull(_sqlDataReader.GetOrdinal(_sqlDataReader.GetName(i))))
{
_operation.Add(_sqlDataReader.GetName(i), _sqlDataReader.GetValue(_sqlDataReader.GetOrdinal(_sqlDataReader.GetName(i))).ToString());
}
else
{
_operation.Add(_sqlDataReader.GetName(i), null);
}
}
_operationList.Add(_operation);
}
}
//SqlCommand _sqlCommand = new SqlCommand(@"select top(1) MachineName from Equipment order by DatatimeUpdate desc", _sqlConnection);
//_currentEquipmentName = new JObject();
//_currentEquipmentName.Add("MachineName", _sqlCommand.ExecuteScalar().ToString());
}
}
catch (SqlException ex)
{
// logger.Log(NLog.LogLevel.Error, "Вызов GetEquipmentNameAsync(" + ifIdIsNeed + " ifIdIsNeed,CancellationToken cancellationToken)");
throw;
}
catch (Exception ex)
{
// logger.Log(NLog.LogLevel.Error, "Вызов GetEquipmentNameAsync(" + ifIdIsNeed + " ifIdIsNeed,CancellationToken cancellationToken)");
throw;
}
return(_operationList);
}