/// <summary>
/// 根据用户所选的字段生成Column
/// </summary>
private void GenColumn()
{
if (listBox2.Items.Count > 0)
{
DataRow row = null;
for (var i = 0; i < listBox2.Items.Count; i++)
{
string newStr = ReplaceBracketsEmpty(listBox2.Items[i].ToString());
row = ExDtMethod.SingleOrDefault(dtFiled, "COLUMN_NAME", (string str) =>
{
return(str.Equals(newStr));
});
if (row != null)
{
GridColumn gridColumn = new GridColumn();
gv_PREVIEW.Columns.Add(gridColumn);
gridColumn.AppearanceHeader.Options.UseTextOptions = true;
gridColumn.Width = 120;
gridColumn.AppearanceHeader.TextOptions.HAlignment = DevExpress.Utils.HorzAlignment.Center;
gridColumn.Caption = string.IsNullOrWhiteSpace(Convert.ToString(row["COMMENTS"])) ? Convert.ToString(row["COLUMN_NAME"]) : Convert.ToString(row["COMMENTS"]);
gridColumn.FieldName = newStr;
gridColumn.Name = newStr;
gridColumn.Visible = true;
gridColumn.VisibleIndex = i;
}
}
}
}
private void LoadListBoxData()
{
if (ExDtMethod.GetRowCount(dtFiled) > 0)
{
//不太清楚为什么使用DataSource不能移除
//listBox1.DataSource = dtFiled;
//listBox1.ValueMember = "COLUMN_NAME";
//listBox1.DisplayMember = "COLUMN_NAME";
foreach (DataRow row in dtFiled.Rows)
{
if (row != null)
{
string comments = Convert.ToString(row["COMMENTS"]);
if (!string.IsNullOrWhiteSpace(comments))
{
listBox1.Items.Add(Convert.ToString(row["COLUMN_NAME"]) + "(" + comments + ")");
}
else
{
listBox1.Items.Add(Convert.ToString(row["COLUMN_NAME"]));
}
}
}
}
}
/// <summary>
/// 加载配置
/// </summary>
private void BindData()
{
DataTable dtTemp = sqlLite.GetSqlExec("SELECT * FROM TAB_LIB_CONFIG");
if (ExDtMethod.GetRowCount(dtTemp) > 0)
{
dtConfig = dtTemp;
}
}
/// <summary>
/// 生成脚本
/// </summary>
/// <param name="dtTemp"></param>
private void GenScript(DataTable dtTemp)
{
me_TEXT.Text = string.Empty;
if (ExDtMethod.GetRowCount(dtTemp) > 0)
{
me_TEXT.Text = new GenerateScript().GenScript(dtTemp, txt_GRID_VIEW.Text.Trim());
btn_WRITE.Enabled = true;
}
}
public DataTable ExcSql(string sql)
{
DataTable dtRes = oraBus.QueryToDataTable(sql);
if (ExDtMethod.IsTransOK(dtRes))
{
return(dtRes);
}
return(null);
}
public DataTable ExcSql(string sql)
{
DataTable dtRes = oraBus.QueryToDataTable(sql);
if (ExDtMethod.GetRowCount(dtRes) > 0)
{
return(dtRes);
}
return(null);
}
private void InitControl()
{
if (ExDtMethod.GetRowCount(dtConfig) > 0)
{
Utils.AddItemToComboxEdit(dtConfig, cbo_LIBRARY, "LIBRARY");
}
if (cbo_LIBRARY.Properties.Items.Count > 0)
{
cbo_LIBRARY.SelectedIndex = 0;
}
Utils.SetReadOnly(pan_ADD.Controls, true);
}
private void BindDtSerach()
{
if (ExDtMethod.GetRowCount(dtFiled) > 0)
{
foreach (DataRow row in dtFiled.Rows)
{
DataRow newRow = dtSerach.NewRow();
string comments = Convert.ToString(row["COMMENTS"]);
string columnName = Convert.ToString(row["COLUMN_NAME"]);
newRow["SERACH_FIELD"] = columnName + "(" + comments + ")";
dtSerach.Rows.Add(newRow);
}
}
}
/// <summary>
/// TextBox 实现模糊查询
/// </summary>
private async void InitTxtLikeSerach(DataTable dtTemp)
{
this.txt_SERACH.AutoCompleteMode = AutoCompleteMode.SuggestAppend;
this.txt_SERACH.AutoCompleteSource = AutoCompleteSource.CustomSource;
AutoCompleteStringCollection ac = new AutoCompleteStringCollection();
List <string> list = (List <string>)ExDtMethod.Select <string>(dtTemp, "TABLE_NAME");
if (list.Count > 0)
{
foreach (var it in list)
{
ac.Add(it);
}
}
this.txt_SERACH.AutoCompleteCustomSource = ac;
}
private async Task <DataTable> GetFieldData()
{
return(await Task.Factory.StartNew(() => {
StringBuilder sb = new StringBuilder();
sb.AppendFormat(@"SELECT T2.TABLE_NAME,T2.COMMENTS,ROWNUM AS SQE FROM USER_TABLES T1,USER_TAB_COMMENTS T2 WHERE T1.TABLE_NAME=T2.TABLE_NAME");
DataTable dtRes = oraBus.QueryToDataTable(sb.ToString(), "TAB_NAME");
if (ExDtMethod.GetRowCount(dtRes) > 0)
{
dtTable = dtRes;
}
else
{
dtTable.Rows.Clear();
}
return dtTable;
}));
}
/// <param name="sender"></param>
/// <param name="e"></param>
private void cbo_LIBRARY_SelectedIndexChanged(object sender, EventArgs e)
{
if (!string.IsNullOrWhiteSpace(cbo_LIBRARY.Text))
{
DataRow row = ExDtMethod.SingleOrDefault <string>(dtConfig, "LIBRARY", (string str) =>
{
return(str.Equals(cbo_LIBRARY.Text));
});
if (row != null)
{
guid = Convert.ToString(row["GUID"]);
txt_LIBRARY.Text = Convert.ToString(row["LIBRARY"]);
txt_SERVICE.Text = Convert.ToString(row["SERVICE"]);
txt_USERNAME.Text = Convert.ToString(row["USERNAME"]);
txt_HOST.Text = Convert.ToString(row["HOST"]);
txt_PORT.Text = Convert.ToString(row["PORT"]);
txt_PWD.Text = Convert.ToString(row["PWD"]);
}
}
}
private void btn_SERACH_Click(object sender, EventArgs e)
{
if (string.IsNullOrWhiteSpace(txt_SERACH.Text))
{
ShowMessage("搜索框不能为空！");
return;
}
if (ExDtMethod.GetRowCount(dtTable) > 0)
{
DataRow[] rows = dtTable.Select(string.Format("TABLE_NAME='{0}'", txt_SERACH.Text.Trim().ToUpper()));
if (rows.Length > 0)
{
this.gv_TABLE.FocusedRowHandle = int.Parse(rows[0]["SQE"].ToString()) - 1;
}
else
{
ShowMessage("找不到对应的表名！");
}
}
}
private void GenColumn(string qrySql)
{
ShowWait();
var txtObject = controlDic[xtra_SQL.SelectedTabPage];
Stopwatch sw = new Stopwatch();
sw.Start();
DataTable dtRes = ExecSql(qrySql, ck_MORE_NUMBER.Checked, ck_MORE_NUMBER.Checked ? Convert.ToInt32(txt_NUMBER.Text.Trim()) : 0);
sw.Stop();
if (ExDtMethod.IsTransOK(dtRes))
{
var costSeconds = sw.ElapsedMilliseconds / 1000.0 + "s";
//根据当前选择的Xtra加入到字典里面
if (!dtDic.ContainsKey(xtra_SQL.SelectedTabPage))
{
ExecSqlModel ex = new ExecSqlModel()
{
dt = dtRes,
rowCount = dtRes.Rows.Count,
execSeconds = costSeconds
};
dtDic.Add(xtra_SQL.SelectedTabPage, ex);
}
else
{
var exec = dtDic[xtra_SQL.SelectedTabPage];
exec.dt = dtRes;
exec.rowCount = dtRes.Rows.Count;
exec.execSeconds = costSeconds;
}
Utils.CloseForm(panelControl6);
ShowExceSqlView(dtDic[xtra_SQL.SelectedTabPage].dt);
SetBarValue(costSeconds, dtRes.Rows.Count);
}
else
{
ShowMessage("查询失败,错误原因请看日志");
}
CloseWait();
}
private void QryFiledAll()
{
StringBuilder sb = new StringBuilder();
sb.AppendFormat(@"SELECT T1.COLUMN_NAME,
T2.COMMENTS
FROM USER_TAB_COLUMNS T1, USER_COL_COMMENTS T2
WHERE T1.TABLE_NAME = '{0}'
AND T1.TABLE_NAME = T2.TABLE_NAME
AND T1.COLUMN_NAME = T2.COLUMN_NAME", qryStr);
DataTable dtRes = oraBus.QueryToDataTable(sb.ToString(), "TAB_FILED");
if (ExDtMethod.GetRowCount(dtRes) > 0)
{
dtFiled = dtRes;
}
else
{
dtFiled.Rows.Clear();
}
}
private void btn_GEN_DT_Click(object sender, EventArgs e)
{
if (string.IsNullOrWhiteSpace(txt_TABLE_NAME.Text))
{
ShowMessage("表名不能为空");
return;
}
StringBuilder sb = new StringBuilder();
sb.AppendFormat(@"SELECT T1.COLUMN_NAME,
T1.DATA_TYPE,
T2.COMMENTS
FROM USER_TAB_COLUMNS T1, USER_COL_COMMENTS T2
WHERE T1.TABLE_NAME = '{0}'
AND T1.TABLE_NAME = T2.TABLE_NAME
AND T1.COLUMN_NAME = T2.COLUMN_NAME", txt_TABLE_NAME.Text.Trim());
DataTable dtRes = oraBus.QueryToDataTable(sb.ToString(), "TAB_FILED");
if (ExDtMethod.GetRowCount(dtRes) > 0)
{
string res = string.Empty;
if (string.IsNullOrWhiteSpace(txt_GEN_DT.Text.Trim()))
{
res = new Convert2Dt().FiledConvert2Dt(dtRes);
}
else
{
res = new Convert2Dt().FiledConvert2Dt(dtRes, txt_GEN_DT.Text.Trim());
}
me_Dt.Text = res;
}
else
{
me_Dt.Text = string.Empty;
}
}
