public DataTable GetData(string[] lot)
{
DataTable ret = new DataTable {
TableName = "MyTable"
};
ret.Columns.Add("Kod");
ret.Columns.Add("Name");
String sql = @"SELECT KodRKC as [Kod], (NRKC +' | ' + left(NameRKC,70)) as Name FROM RKC WHERE LotKod=" + lot[0] + " order by LotKod, Npp";
OleDbConnection connection = null;
try
{
connection = new OleDbConnection(MainWindow.GetConnectionString());
OleDbCommand Command = new OleDbCommand(sql, connection);
OleDbDataAdapter adRKC = new OleDbDataAdapter(Command);
connection.Open();
adRKC.Fill(ret);
}
catch (Exception ex)
{
Console.WriteLine(ex.Message);
throw;
}
finally
{
if (connection != null)
{
connection.Close();
}
}
return(ret);
}
public DataTable GetData(string[] lot)
{
DataTable ret = new DataTable {
TableName = "MyTable"
};
ret.Columns.Add("Kod");
ret.Columns.Add("Name");
String sql = @"SELECT КС.КодКС as [Kod], (КС.НомерКС & ' | ' & КС.ДатаДокумента & ' | ' & КС.Филиал) as Name FROM КС WHERE (КС.Лот)=" + lot[0] + " ORDER BY КС.[ДатаДокумента] DESC;";
OleDbConnection connection = null;
try
{
connection = new OleDbConnection(MainWindow.GetConnectionString());
OleDbCommand Command = new OleDbCommand(sql, connection);
OleDbDataAdapter adRKC = new OleDbDataAdapter(Command);
connection.Open();
adRKC.Fill(ret);
}
catch (Exception ex)
{
Console.WriteLine(ex.Message);
throw;
}
finally
{
if (connection != null)
{
connection.Close();
}
}
return(ret);
}
public DataTable GetData(string[] lot)
{
DataTable ret = new DataTable {
TableName = "MyTable"
};
ret.Columns.Add("Kod");
ret.Columns.Add("Name");
String sql = @"SELECT КодРКЦ as [Kod], ([РКЦ].№РКЦ +' | ' + left([РКЦ].НазваниеРКЦ,70)) as Name FROM РКЦ WHERE Лот=" + lot[0] + " order by Лот, №пп";
OleDbConnection connection = null;
try
{
connection = new OleDbConnection(MainWindow.GetConnectionString());
OleDbCommand Command = new OleDbCommand(sql, connection);
OleDbDataAdapter adapter = new OleDbDataAdapter(Command);
connection.Open();
adapter.Fill(ret);
}
catch (Exception ex)
{
Console.WriteLine(ex.Message);
throw;
}
finally
{
if (connection != null)
{
connection.Close();
}
}
return(ret);
}