/// <summary>
/// 初始化数据
/// </summary>
/// <param name="grd"></param>
/// <param name="dtt"></param>
/// <param name="Num"></param>
public void Init(TableView view)
{
this._TableView = view;
var sqlCount = string.Empty;
switch (_TableView.DataType)
{
case DataTypes.SQLSERVER:
sqlCount = string.Format(Consts.Data.TableDataCount, _TableView.TableKey);
break;
case DataTypes.ORACLE:
sqlCount = string.Format(Consts.Data.TableDataCount, _TableView.TableKey);
break;
}
if (!string.IsNullOrEmpty(_TableView.SqlWhere))
{
sqlCount += " " + _TableView.SqlWhere;
}
this.allNum = BaseUnity.GetTValueData <int>(_TableView.ConnectionStr, _TableView.DataType, sqlCount, null);
ReadDataTable();
}
/// <summary>
/// 获取服务器信息
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void ServerClick(object sender, RoutedEventArgs e)
{
TreeViewExNode item = sender as TreeViewExNode;
if (!item.IsSelected)
{
return;
}
var dataBases = new List <string>();
string connStr = string.Empty;
var connection = LoadingConnection.GetConnectionById(item.ConnectionId, out connStr);
item.DataType = connection.DataType;
item.ConnectionStr = connStr;
if (BaseUnity.GetConnection(connection))
{
if (connection.DataType == DataTypes.ORACLE)
{
TreeItemClick(item, ItemTypes.DataBase);
}
else
{
TreeItemClick(item, ItemTypes.Server);
}
}
else
{
MessageBox.Show("无法与目标服务建立链接！");
}
}
private void Button_Test(object sender, RoutedEventArgs e)
{
var errMSG = LoginCheck();
if (!string.IsNullOrEmpty(errMSG))
{
ErrorMessage.Text = errMSG;
return;
}
var config = new ConnectConfig();
config.ConnectionName = ConnectionName.Text;
config.DataBase = DataBase.Text;
config.DataType = _dataType;
config.DataSource = DatabaseAddress.Text;
config.UserID = LoginName.Text;
config.PassWord = PassWord.Password;
config.Port = Port.Text;
if (BaseUnity.GetConnection(config))
{
ErrorMessage.Text = "链接成功！";
}
else
{
ErrorMessage.Text = "链接失败！";
}
}
/// <summary>
/// 画数据
/// </summary>
private void ReadDataTable()
{
try
{
var sqlData = string.Empty;
_TableView.TableFields = Service.GetTableColumns(_TableView.ConnectionStr, _TableView.DataType, _TableView.DataBase, _TableView.TableKey);
switch (_TableView.DataType)
{
case DataTypes.SQLSERVER:
var orderKey = string.Empty;
if (_TableView.TableFields.Where(s => "ID".Equals(s.ColumnName.ToUpper())).Any())
{
orderKey = "ID";
}
else
{
orderKey = _TableView.TableFields.FirstOrDefault().ColumnName;
}
sqlData = string.Format(Consts.Data.SqlTableData, string.Join(",", _TableView.TableFields.Select(s => s.ColumnName)), orderKey, _TableView.TableKey, (pIndex - 1) * pageNum + 1, pageNum * pIndex, _TableView.SqlWhere);
break;
case DataTypes.ORACLE:
sqlData = string.Format(Consts.Data.OracleTableData, string.Join(",", _TableView.TableFields.Select(s => s.ColumnName)), _TableView.TableKey, (pIndex - 1) * pageNum + 1, pageNum * pIndex, _TableView.SqlWhere);
break;
}
var dt = BaseUnity.QueryForDataTable(_TableView.ConnectionStr, _TableView.DataType, sqlData, null);
_TableView.TableData.ItemsSource = dt.DefaultView;
}
catch (Exception e)
{
throw (e);
}
finally
{
SetMaxIndex();
DisplayPagingInfo();
}
}
private void Execute_Click(object sender, RoutedEventArgs e)
{
try
{
TableData.Columns.Clear();
TableData.ItemsSource = null;
var sql = Context.Text;
var data = BaseUnity.QueryForDataTable(ConnectionStr, DataType, sql, null);
TableData.Visibility = Visibility.Visible;
ErrorText.Visibility = Visibility.Hidden;
if (data.Rows.Count > 0)
{
TableData.ItemsSource = data.DefaultView;
}
else
{
foreach (var item in data.Columns)
{
var column = new DataGridTextColumn();
column.IsReadOnly = false;
column.Header = item.ToString();
column.Width = 100;
TableData.Columns.Add(column);
}
}
}
catch (Exception ex)
{
TableData.Visibility = Visibility.Hidden;
ErrorText.Text = ex.Message;
ErrorText.Visibility = Visibility.Visible;
}
}
