private void trsMake()
{
___BASA__DataSet.StatTreatDataTable tabTR = statTreatTableAdapter.GetDataByTR();
trs = new string[tabTR.Rows.Count];
int ii = 0;
foreach (DataRow dr in tabTR.Rows)
{
trs[ii] = dr["TR"].ToString();
ii++;
}
}
void Fill2(___BASA__DataSet.StatTreatDataTable dataTable)
{
statTreatTableAdapter.Adapter.SelectCommand = new System.Data.OleDb.OleDbCommand();
statTreatTableAdapter.Adapter.SelectCommand.Connection = new System.Data.OleDb.OleDbConnection(DSS.Properties.Settings.Default.__BASA__ConnectionString1);
statTreatTableAdapter.Adapter.SelectCommand.CommandType = System.Data.CommandType.Text;
statTreatTableAdapter.Adapter.SelectCommand.CommandText = "SELECT Treat.Texts AS TR, COUNT(TreatTreat.Skolko) AS Many,SUM(Treat.[Money] * TreatTreat.Skolko) AS Suma " + select +
" FROM ((Treat RIGHT OUTER JOIN TreatTreat ON Treat.ID = TreatTreat.Treat) LEFT OUTER JOIN ((Patients RIGHT OUTER JOIN Posesenie ON Patients.PID = Posesenie.Patient) LEFT OUTER JOIN Personal ON Posesenie.Personal = Personal.DID) ON TreatTreat.Posesenie = Posesenie.ID) " +
" GROUP BY Treat.Texts " + group;
dataTable.Clear();
statTreatTableAdapter.Adapter.Fill(dataTable);
}
