protected override void ApplyCommand(Session session, QueryJson query)
{
session.WriteLog("Select command: " + query.Message);
DataTableJson buf = DataBaseOperations.ExecuteDataTable(query);
buf.Dependence = DataTableDependeces.GetTableDependence(query.TableName);
session.Dialog.SendMessage(buf);
}
public void PrintListTables(string tableName, DataTableJson dt)
{
ListBox_Tables.Items.Clear();
DataTable dataTable = DataTableJson.Deserialize(tableName, dt);
foreach (DataRow row in dataTable.Rows)
{
ListBox_Tables.Items.Add(row[0].ToString());
}
}
public void PrintDataGridViewDataTable(DataTableJson data)
{
CurrentTable.Dependences = data.Dependence;
DataSet dataSet = new DataSet();
StringReader xmlreader = new StringReader(data.DataTable);
dataSet.ReadXml(xmlreader);
CurrentTable.CurTable = dataSet.Tables[CurrentTable.Name];
Binding.DataSource = CurrentTable.CurTable;
DataGridView_MainView.AutoResizeColumns(
DataGridViewAutoSizeColumnsMode.AllCells);
foreach (DataGridViewColumn c in DataGridView_MainView.Columns)
{
c.SortMode = DataGridViewColumnSortMode.NotSortable;
}
}
public static DataTableJson ExecuteDataTable(QueryJson command)
{
SqlDataAdapter adapter = new SqlDataAdapter(command.Message, Connection);
DataTable dataTable = new DataTable(command.TableName);
adapter.Fill(dataTable);
StringBuilder xmlString = new StringBuilder();
var xmlWriter = XmlWriter.Create(xmlString);
dataTable.WriteXml(xmlWriter);
DataTableJson dataTableJson = new DataTableJson()
{
Code = OperationCode.AnswerOK,
DataTable = xmlString.ToString(),
};
return(dataTableJson);
}
