private void UsingSql(object sender, RoutedEventArgs e)
{
if (SQLQuery.Text.StartsWith("SELECT"))
{
MySqlLib.MySqlData.MySqlExecuteData.MyResultData result = new MySqlLib.MySqlData.MySqlExecuteData.MyResultData();
result = MySqlLib.MySqlData.MySqlExecuteData.SqlReturnDataset(SQLQuery.Text, connectStrWithDb);
querySelected = true;
if (result.HasError == false)
{
sqlSelectGrid.ItemsSource = result.ResultData.DefaultView;
tabControl.SelectedIndex = 5;
}
else
{
MessageBox.Show(result.ErrorText);
}
}
else
{
MySqlLib.MySqlDataC.MySqlExecute.MyResult result = new MySqlLib.MySqlDataC.MySqlExecute.MyResult();
result = MySqlLib.MySqlDataC.MySqlExecute.SqlNoneQuery(SQLQuery.Text, connectStrWithDb);
if (result.HasError == false)
{
MessageBox.Show(result.ResultText);
}
else
{
MessageBox.Show(result.ErrorText);
}
}
}
private void Table_Open(object sender, RoutedEventArgs e)
{
if (table.SelectedItem == null)
{
somethingAintSelected("Таблица не выбрана", "Выберите таблицу, которую хотите открыть");
}
else
{
currentTable = ((DataRowView)table.SelectedItems[0]).Row[0].ToString();
MySqlLib.MySqlData.MySqlExecuteData.MyResultData result = new MySqlLib.MySqlData.MySqlExecuteData.MyResultData();
result = MySqlLib.MySqlData.MySqlExecuteData.SqlReturnDataset("SELECT * FROM " + currentTable, connectStrWithDb);
if (result.HasError == false)
{
tableSelected = true;
tabControl.SelectedIndex = 2;
tabControl.SelectedItem = openedTable;
openedTable.IsSelected = true;
RemovePunctiatonFromColumns(result, openedTableGrid);
DescribeTableFoo();
}
else
{
MessageBox.Show(result.ErrorText);
}
}
}
private void SearchEmployee()
{
string SQLQuery = "SELECT * FROM employees WHERE ";
TextBox[] textBoxes = { ID, FullName, Passport, Organization };
string[] attributesHeaders = { "ID", "Full_Name", "Serial_And_Passport_Number", "Organization" };
for (int i = 0; i < textBoxes.Length; i++)
{
if (textBoxes[i].Text != null && textBoxes[i].Text != "")
{
SQLQuery += "`" + attributesHeaders[i] + "` = '" + textBoxes[i].Text + "' AND ";
}
}
if (ConfirmedByTheOrganization.SelectedIndex != -1)
{
SQLQuery += "`Confirmed_By_The_Organization` = '" +
ConfirmedByTheOrganization.SelectedIndex + "'";
}
SQLQuery += "end";
SQLQuery = SQLQuery.Replace(" AND end", "");
MySqlLib.MySqlData.MySqlExecuteData.MyResultData result = new MySqlLib.MySqlData.MySqlExecuteData.MyResultData();
result = MySqlLib.MySqlData.MySqlExecuteData.SqlReturnDataset(SQLQuery, connectStr);
if (result.HasError == false)
{
grid.ItemsSource = result.ResultData.DefaultView;
Close();
}
else
{
MessageBox.Show(result.ErrorText);
MessageBox.Show(SQLQuery);
}
}
private void SearchInDB(object sender, RoutedEventArgs e)
{
string SQLQuery = "SELECT * FROM `literature` WHERE ";
string connStr = @"Database = listofsources; Data Source = localhost; User Id = root; Password ="******"")
{
SQLQuery += "`" + win.TableGrid.Columns[i].Header + "` = " + "'" + tb.Text + "' AND ";
}
}
SQLQuery += "replaceme";
SQLQuery = SQLQuery.Replace("AND replaceme", "");
MySqlLib.MySqlData.MySqlExecuteData.MyResultData result = new MySqlLib.MySqlData.MySqlExecuteData.MyResultData();
result = MySqlLib.MySqlData.MySqlExecuteData.SqlReturnDataset(SQLQuery, connStr);
if (result.HasError == false)
{
win.TableGrid.ItemsSource = result.ResultData.DefaultView;
win.Activate();
Close();
}
else
{
MessageBox.Show(result.ErrorText);
}
}
private void UpdateGrid(string TableName)
{
MySqlLib.MySqlData.MySqlExecuteData.MyResultData result = new MySqlLib.MySqlData.MySqlExecuteData.MyResultData();
DataGrid temp;
if (TableName.Equals("employees"))
{
result = MySqlLib.MySqlData.MySqlExecuteData.SqlReturnDataset("SELECT * FROM employees", connectStr);
temp = employeesGrid;
}
else
{
string SQLQuery =
@"SELECT report_IN.*, report_out.DateTime_OUT FROM `report_in`, `report_out` " +
"WHERE `report_out`.`Session_ID` = `report_in`.`Session_ID`";
result = MySqlLib.MySqlData.MySqlExecuteData.SqlReturnDataset(SQLQuery, connectStr);
temp = allReportsGrid;
}
if (result.HasError == false)
{
temp.ItemsSource = result.ResultData.DefaultView; // Fill DataGrid with [updated] SQL Query return data
}
else
{
MessageBox.Show(result.ErrorText);
}
}
private void DataBase_Open(object sender, RoutedEventArgs e)
{
if (dataBases.SelectedItem == null)
{
somethingAintSelected("База данных не выбрана", "Выберите базу данных, которую хотите открыть");
}
else
{
currentDataBase = ((DataRowView)dataBases.SelectedItems[0]).Row["DATABASE"].ToString();
connectStrWithDb = @"Database = " + currentDataBase + "; " + connectStr;
MySqlLib.MySqlData.MySqlExecuteData.MyResultData result = new MySqlLib.MySqlData.MySqlExecuteData.MyResultData();
result = MySqlLib.MySqlData.MySqlExecuteData.SqlReturnDataset("SHOW TABLES", connectStrWithDb);
if (result.HasError == false)
{
dataBaseSelected = true;
tabControl.SelectedIndex = 1;
tabControl.SelectedItem = tablesTab;
tablesTab.IsSelected = true;
RemovePunctiatonFromColumns(result, table);
}
else
{
MessageBox.Show(result.ErrorText);
}
}
}
public void updateCurrentTable()
{
MySqlLib.MySqlData.MySqlExecuteData.MyResultData result = new MySqlLib.MySqlData.MySqlExecuteData.MyResultData();
result = MySqlLib.MySqlData.MySqlExecuteData.SqlReturnDataset("SHOW TABLES", connectStrWithDb);
if (result.HasError == false)
{
table.ItemsSource = result.ResultData.DefaultView;
}
else
{
MessageBox.Show(result.ErrorText);
}
}
public void updateTable(object sender, RoutedEventArgs e)
{
MySqlLib.MySqlData.MySqlExecuteData.MyResultData result = new MySqlLib.MySqlData.MySqlExecuteData.MyResultData();
result = MySqlLib.MySqlData.MySqlExecuteData.SqlReturnDataset("SELECT * FROM " + currentTable, connectStrWithDb);
if (result.HasError == false)
{
RemovePunctiatonFromColumns(result, openedTableGrid);
}
else
{
MessageBox.Show(result.ErrorText);
}
}
private void SensorsGridUpdate()
{
MySqlLib.MySqlData.MySqlExecuteData.MyResultData result = new MySqlLib.MySqlData.MySqlExecuteData.MyResultData();
result = MySqlLib.MySqlData.MySqlExecuteData.SqlReturnDataset("SELECT * FROM sensors_data", connectStr);
if (result.HasError == false)
{
sensors_data_grid.ItemsSource = result.ResultData.DefaultView;
}
else
{
MessageBox.Show(result.ErrorText);
}
}
public void SelectDataBases()
{
MySqlLib.MySqlData.MySqlExecuteData.MyResultData result = new MySqlLib.MySqlData.MySqlExecuteData.MyResultData();
result = MySqlLib.MySqlData.MySqlExecuteData.SqlReturnDataset("SHOW DATABASES", connectStr);
if (result.HasError == false)
{
dataBases.ItemsSource = result.ResultData.DefaultView;
dataBases.UpdateLayout();
dataBases.Columns[0].Width = dataBases.Width - 1;
}
else
{
MessageBox.Show(result.ErrorText);
}
}
private void Report_Input(bool enterInput)
{
DataGrid temp = new DataGrid();
MySqlLib.MySqlData.MySqlExecuteData.MyResultData maxResult = new MySqlLib.MySqlData.MySqlExecuteData.MyResultData();
string queryMaxInSession_ID = "SELECT MAX(Session_ID) FROM report_IN WHERE report_IN.ID = "
+ currentEmployeeID;
string queryMaxOutSession_ID = "SELECT MAX(Session_ID) FROM report_OUT WHERE report_OUT.ID = "
+ currentEmployeeID;
maxResult = MySqlLib.MySqlData.MySqlExecuteData.SqlReturnDataset(queryMaxInSession_ID, connectStr);
temp.ItemsSource = maxResult.ResultData.DefaultView;
int maxInSession_ID;
int.TryParse(((DataRowView)temp.Items[0]).Row["MAX(Session_ID)"].ToString(), out maxInSession_ID);
maxResult = MySqlLib.MySqlData.MySqlExecuteData.SqlReturnDataset(queryMaxOutSession_ID, connectStr);
temp.ItemsSource = maxResult.ResultData.DefaultView;
int maxOutSession_ID;
int.TryParse(((DataRowView)temp.Items[0]).Row["MAX(Session_ID)"].ToString(), out maxOutSession_ID);
if (enterInput)
{
if (maxInSession_ID == maxOutSession_ID)
{
Report_Input_SQL("IN", -1);
}
else // if maxInSession_ID > maxOutSession_ID then the entry is already committed
{
MessageBox.Show("Вход работника уже зафиксирован");
}
}
else
{
if (maxInSession_ID > maxOutSession_ID)
{
Report_Input_SQL("OUT", maxInSession_ID);
}
else // if maxInSession_ID <= maxOutSession_ID then the entry isn't committed
// so they can't commit the exit
{
MessageBox.Show("Вход работника не зафиксирован, поэтому нельзя зафиксировать выход");
}
}
}
private void UpdateTable(object sender, RoutedEventArgs e)
{
string SQLQuery = "SELECT * FROM literature";
string connStr = @"Database = listofsources; Data Source = localhost; User Id = root; Password ="******"Что-то не так с базой данных", "", MessageBoxButton.OK, MessageBoxImage.Error);
}
}
private void Search_Click(object sender, System.Windows.RoutedEventArgs e)
{
string SQLQuery = "SELECT report_IN.*, report_out.DateTime_OUT FROM `report_in`, `report_out` WHERE " +
"`report_out`.`Session_ID` = `report_in`.`Session_ID` AND ";
TextBox[] textBoxes = { ID, Session_ID };
string[] attributesHeaders = { "report_in.ID", "report_in.Session_ID" };
for (int i = 0; i < 2; i++)
{
if (textBoxes[i].Text != null && textBoxes[i].Text != "")
{
SQLQuery += attributesHeaders[i] + " = '" + textBoxes[i].Text + "' AND ";
}
}
if (Date_In.SelectedDate != null)
{
string dateTime = getDateTime(Date_In);
SQLQuery += "`DateTime_In` = '" +
dateTime + "' AND ";
}
if (Date_Out.SelectedDate != null)
{
string dateTime = getDateTime(Date_Out);
SQLQuery += "`DateTime_Out` = '" +
dateTime + "' AND ";
}
SQLQuery += "end";
SQLQuery = SQLQuery.Replace(" AND end", "");
if (!SQLQuery.Contains("end"))
{
MySqlLib.MySqlData.MySqlExecuteData.MyResultData result = new MySqlLib.MySqlData.MySqlExecuteData.MyResultData();
result = MySqlLib.MySqlData.MySqlExecuteData.SqlReturnDataset(SQLQuery, connectStr);
if (result.HasError == false)
{
grid.ItemsSource = result.ResultData.DefaultView;
Close();
}
else
{
MessageBox.Show(result.ErrorText);
}
}
else
{
Close();
}
}
private void button1_Click(object sender, EventArgs e)
{
MySqlLib.MySqlData.MySqlExecuteData.MyResultData result = new MySqlLib.MySqlData.MySqlExecuteData.MyResultData();
result = MySqlLib.MySqlData.MySqlExecuteData.SqlReturnDataset("select * from market_cards", "Database=inventar_alleya;Data Source=localhost;User Id=root;Password=240580");
if (result.HasError == false)
{
dataGridView1.Columns.Clear();
dataGridView1.DataSource = result.ResultData.DefaultView;
MessageBox.Show(result.ResultData.Rows.Count.ToString());
}
else
{
MessageBox.Show(result.ErrorText);
}
}
private void SelectDataFromDB()
{
String sSQL = GetSQLString();
String sConnectionString = "Database=TestDB;Data Source=localhost;User Id=root;Password=qwerty789";
MySqlLib.MySqlData.MySqlExecuteData.MyResultData result = new MySqlLib.MySqlData.MySqlExecuteData.MyResultData();
result = MySqlLib.MySqlData.MySqlExecuteData.SqlReturnDataset(sSQL, sConnectionString);
if (result.HasError == false)
{
dataGridView1.Columns.Clear();
dataGridView1.DataSource = result.ResultData.DefaultView;
}
else
{
MessageBox.Show(result.ErrorText);
}
}
private void From_DB(object sender, RoutedEventArgs e)
{
string SQLQuery = "SELECT * FROM literature";
MySqlLib.MySqlData.MySqlExecuteData.MyResultData result = new MySqlLib.MySqlData.MySqlExecuteData.MyResultData();
result = MySqlLib.MySqlData.MySqlExecuteData.SqlReturnDataset(SQLQuery, connStr);
if (result.HasError == false)
{
SourcesTable win = new SourcesTable();
win.Show();
win.Owner = this;
win.TableGrid.ItemsSource = result.ResultData.DefaultView;
win.TableGrid.Columns[6].Width = 183;
}
else
{
MessageBox.Show("Что-то не так с базой данных", "", MessageBoxButton.OK, MessageBoxImage.Error);
}
}
private void UpdateGrid(int ID)
{
string SQLQuery =
@"SELECT report_IN.*, report_out.DateTime_OUT FROM `report_in`, `report_out` " +
"WHERE `report_out`.`Session_ID` = `report_in`.`Session_ID` " +
"AND `report_in`.`ID` = " + ID;
MySqlLib.MySqlData.MySqlExecuteData.MyResultData result = new MySqlLib.MySqlData.MySqlExecuteData.MyResultData();
result = MySqlLib.MySqlData.MySqlExecuteData.SqlReturnDataset(SQLQuery, connectStr);
if (result.HasError == false)
{
reportsGrid.ItemsSource = result.ResultData.DefaultView;
}
else
{
MessageBox.Show(result.ErrorText);
}
}
private void DescribeTableFoo()
{
if (tableSelected == false)
{
showChooseDialog(2);
}
else
{
MySqlLib.MySqlData.MySqlExecuteData.MyResultData result = new MySqlLib.MySqlData.MySqlExecuteData.MyResultData();
result = MySqlLib.MySqlData.MySqlExecuteData.SqlReturnDataset("DESCRIBE `" + currentTable + "`", connectStrWithDb);
if (result.HasError == false)
{
describeTable.ItemsSource = result.ResultData.DefaultView;
}
else
{
MessageBox.Show(result.ErrorText);
}
}
}
/// <summary>
/// Checks if there are incorrect numbers among the sensor numbers
/// </summary>
private bool AreThereIncorrectNumbers()
{
int.TryParse(NumberOfSensors.Text, out int numberOfSensors);
MySqlLib.MySqlData.MySqlExecuteData.MyResultData result =
new MySqlLib.MySqlData.MySqlExecuteData.MyResultData();
for (int i = 0; i < numberOfSensors; i++)
{
result = MySqlLib.MySqlData.MySqlExecuteData.SqlReturnDataset(
"SELECT number_of_sensor FROM sensors_data WHERE number_of_sensor = '" +
sensorsNumbersBoxes[i].Text + "'", connectStr);
try
{
bool isResultEmpty = result.ResultData.Rows[0] == null;
}
catch (System.IndexOutOfRangeException)
{
return(true);
}
}
return(false);
}
private void RemovePunctiatonFromColumns(MySqlLib.MySqlData.MySqlExecuteData.MyResultData result, DataGrid grid)
{
temp = new DataColumn[result.ResultData.Columns.Count];
for (int i = 0; i < temp.Length; i++)
{
temp[i] = new DataColumn();
temp[i].ColumnName = result.ResultData.Columns[i].ToString();
}
string pattern = @"[\p{P}]";
for (int i = 0; i < result.ResultData.Columns.Count; i++)
{
result.ResultData.Columns[i].ColumnName =
Regex.Replace(result.ResultData.Columns[i].ColumnName, pattern, "");
}
grid.ItemsSource = result.ResultData.DefaultView;
grid.UpdateLayout();
for (int i = 0; i < temp.Length - 1; i++)
{
grid.Columns[i].Header = temp[i].ColumnName;
}
}
private void listblagoorg_Load(object sender, EventArgs e)
{
String sSQL1 = "SELECT CharityId,CharityName,CharityDescription FROM charity";
String sConnectionString = "Database=prakt;Data Source=127.0.0.1;User Id=root";
MySqlLib.MySqlData.MySqlExecuteData.MyResultData result = new MySqlLib.MySqlData.MySqlExecuteData.MyResultData();
result = MySqlLib.MySqlData.MySqlExecuteData.SqlReturnDataset(sSQL1, sConnectionString);
if (result.HasError == false)
{
metroGrid1.Columns.Clear();
metroGrid1.DataSource = result.ResultData.DefaultView;
}
else
{
MessageBox.Show(result.ErrorText);
}
for (int i = 1; i < 14; i++)
{
metroGrid1.Rows[i].Cells[3].Value = Properties.Resources.arise_logo;
}
daytime.Start();
date = new DateTime(2020, 11, 24, 6, 00, 00);
}
private Table CustomTable_2()
{
Table table = new Table();
const int CELLS_IN_A_ROW = 6;
table.Append(StandardTableProperties());
int.TryParse(NumberOfSensors.Text, out int numberOfSensors);
TableRow[] tableRows = new TableRow[numberOfSensors];
TableCell[,] tableCells = new TableCell[numberOfSensors, CELLS_IN_A_ROW]; // 6 cells in a row
Paragraph[,] paragraphs = new Paragraph[numberOfSensors, CELLS_IN_A_ROW];
Run[,] runs = new Run[numberOfSensors, CELLS_IN_A_ROW];
string[] headers = { "№", "Номер датчика", "Имя датчика", "Тип датчика", "Срок годности", "F0" };
table.Append(Table_Headers(ref headers)); // set headers (1st row) to the table
string[] columnsNames = { "number_of_sensor", "name_of_sensor",
"type_of_sensor", "expiration_date", "zero_value" };
for (int i = 0; i < numberOfSensors; i++)
{
MySqlLib.MySqlData.MySqlExecuteData.MyResultData result =
new MySqlLib.MySqlData.MySqlExecuteData.MyResultData();
result = MySqlLib.MySqlData.MySqlExecuteData.SqlReturnDataset(
"SELECT number_of_sensor, name_of_sensor, type_of_sensor, expiration_date, zero_value " +
"FROM sensors_data WHERE number_of_sensor = '" + sensorsNumbersBoxes[i].Text + "'", connectStr);
if (result.HasError == false)
{
tableRows[i] = new TableRow();
string[] values =
{
result.ResultData.Rows[0].Field <string>(0),
result.ResultData.Rows[0].Field <string>(1),
result.ResultData.Rows[0].Field <string>(2)
};
DateTime dateTime = result.ResultData.Rows[0].Field <DateTime>(3);
double zero_value = result.ResultData.Rows[0].Field <double>(4);
for (int k = 0; k < CELLS_IN_A_ROW; k++)
{
runs[i, k] = new Run();
paragraphs[i, k] = new Paragraph();
tableCells[i, k] = new TableCell();
if (k == 0)
{
runs[i, k].Append(new Text((k + 1).ToString()));
}
else if (k == 4)
{
runs[i, k].Append(new Text(dateTime.ToString().Substring(0, 10)));
}
else if (k == 5)
{
runs[i, k].Append(new Text(zero_value.ToString()));
}
else
{
runs[i, k].Append(new Text(values[k - 1]));
}
paragraphs[i, k].Append(runs[i, k]);
tableCells[i, k].Append(paragraphs[i, k]);
tableRows[i].Append(tableCells[i, k]);
}
table.Append(tableRows[i]);
}
else
{
MessageBox.Show(result.ErrorText);
}
}
return(table);
}
private Table CustomTable_3()
{
Table table = new Table();
const int CELLS_IN_A_ROW = 5;
table.Append(StandardTableProperties());
int.TryParse(NumberOfSensors.Text, out int numberOfSensors);
TableRow[] tableRows = new TableRow[numberOfSensors];
TableCell[,] tableCells = new TableCell[numberOfSensors, CELLS_IN_A_ROW]; // 5 cells in a row
Paragraph[,] paragraphs = new Paragraph[numberOfSensors, CELLS_IN_A_ROW];
Run[,] runs = new Run[numberOfSensors, CELLS_IN_A_ROW];
string[] headers = { "№", "Значение A", "Значение B", "Значение C", "Значение D" };
table.Append(Table_Headers(ref headers)); // set headers (1st row) to the table
string[] columnsNames = { "value_a", "value_b", "value_c", "value_d" };
for (int i = 0; i < numberOfSensors; i++)
{
MySqlLib.MySqlData.MySqlExecuteData.MyResultData result =
new MySqlLib.MySqlData.MySqlExecuteData.MyResultData();
result = MySqlLib.MySqlData.MySqlExecuteData.SqlReturnDataset(
"SELECT value_a, value_b, value_c, value_d FROM " +
"sensors_data WHERE number_of_sensor = '" + sensorsNumbersBoxes[i].Text + "'", connectStr);
if (result.HasError == false)
{
tableRows[i] = new TableRow();
double[] values =
{
result.ResultData.Rows[0].Field <double>(0),
result.ResultData.Rows[0].Field <double>(1),
result.ResultData.Rows[0].Field <double>(2),
result.ResultData.Rows[0].Field <double>(3)
};
for (int k = 0; k < CELLS_IN_A_ROW; k++)
{
runs[i, k] = new Run();
paragraphs[i, k] = new Paragraph();
tableCells[i, k] = new TableCell();
if (k == 0)
{
runs[i, k].Append(new Text((k + 1).ToString()));
}
else
{
runs[i, k].Append(new Text(values[k - 1].ToString()));
}
paragraphs[i, k].Append(runs[i, k]);
tableCells[i, k].Append(paragraphs[i, k]);
tableRows[i].Append(tableCells[i, k]);
}
table.Append(tableRows[i]);
}
else
{
MessageBox.Show(result.ErrorText);
}
}
return(table);
}
private void AcceptChanges(object sender, EventArgs e)
{
string SQLQuery;
if (isWindowForSearch == false)
{
SQLQuery = "INSERT INTO `" + dataBase + "`.`" +
table + "`" + " (";
for (int i = 0; i < columns.Length; i++)
{
SQLQuery += "`" + columns[i] + "`, ";
}
SQLQuery += "replaceme";
SQLQuery = SQLQuery.Replace(", replaceme", ") ");
SQLQuery += "VALUES(";
int index = 5;
for (int i = 0; i < columns.Length; i++)
{
TextBox tb = (TextBox)MainGrid.Children[index];
SQLQuery += "'" + tb.Text + "', ";
index += 3;
}
SQLQuery += "replaceme";
SQLQuery = SQLQuery.Replace(", replaceme", ")");
MySqlLib.MySqlData.MySqlExecute.MyResult result =
MySqlLib.MySqlData.MySqlExecute.SqlNoneQuery(SQLQuery, connectString);
if (result.HasError == false)
{
this.Close();
}
else
{
MessageBox.Show(result.ErrorText);
}
}
else
{
SQLQuery = "SELECT * FROM `" + table + "`" + " WHERE ";
int index = 5;
for (int i = 0; i < columns.Length; i++)
{
TextBox tb = (TextBox)MainGrid.Children[index];
if (tb.Text != null && tb.Text != "")
{
SQLQuery += "`" + columns[i] + "` = " + "'" + tb.Text + "' AND ";
index += 3;
}
}
SQLQuery += "replaceme";
SQLQuery = SQLQuery.Replace("AND replaceme", " LIMIT 0, 30");
MySqlLib.MySqlData.MySqlExecuteData.MyResultData result = new MySqlLib.MySqlData.MySqlExecuteData.MyResultData();
result = MySqlLib.MySqlData.MySqlExecuteData.SqlReturnDataset(SQLQuery, connectStringWithDb);
if (result.HasError == false)
{
openedGrid.ItemsSource = result.ResultData.DefaultView;
this.Close();
}
else
{
MessageBox.Show(result.ErrorText);
}
}
}
