#region
|
|
using System;
|
using System.ComponentModel;
|
using System.Data;
|
using CSFrameworkV5.Business;
|
using CSFrameworkV5.Common;
|
using CSFrameworkV5.Core;
|
using CSFrameworkV5.Library.CommonClass;
|
using CSFrameworkV5.Models;
|
|
#endregion
|
|
namespace CSFrameworkV5.Library
|
{
|
public partial class frmLogFieldConfig : frmBase
|
{
|
public frmLogFieldConfig()
|
{
|
InitializeComponent();
|
}
|
|
private void AddOtherDB(DataTable dtDB)
|
{
|
var R = dtDB.NewRow();
|
R["DBName"] = "OtherDB"; //例子：其他服务器的数据库（与账套数据库不在同一个服务器）
|
dtDB.Rows.InsertAt(R, 0);
|
dtDB.AcceptChanges();
|
}
|
|
private void btnAdd_Click(object sender, EventArgs e)
|
{
|
if (gcFields.DataSource == null)
|
{
|
Msg.Warning("请查询数据！");
|
return;
|
}
|
|
if (txtDBName.Text.Trim() == "" || txtTableName.Text.Trim() == "" ||
|
txtFieldName.Text.Trim() == "")
|
{
|
Msg.Warning("数据库、表名、字段名不能为空！");
|
txtFieldName.Focus();
|
return;
|
}
|
|
var R = (gcFields.DataSource as DataTable).Rows.Add();
|
R[sys_LogFields.RowID] = Guid.NewGuid().ToStringEx();
|
R[sys_LogFields.DBName] = txtDBName.Text;
|
R[sys_LogFields.TableName] = txtTableName.Text;
|
R[sys_LogFields.FieldName] = txtFieldName.Text;
|
R[sys_LogFields.FlagLog] = "Y";
|
|
//保存数据
|
if (DoSave()) txtFieldName.Text = "";
|
}
|
|
private void btnDel_Click(object sender, EventArgs e)
|
{
|
if (gvFields.FocusedRowHandle >= 0)
|
if (Msg.AskQuestion(
|
$"确定要删除{gvFields.GetFocusedRowCellDisplayText(colFieldCaption)}字段吗?"))
|
{
|
gvFields.GetFocusedDataRow().Delete();
|
|
//保存数据
|
DoSave();
|
}
|
}
|
|
private void btnRefresh_Click(object sender, EventArgs e)
|
{
|
if (txt_DBs.Text == "")
|
{
|
txt_DBs.Focus();
|
txt_DBs.ShowPopup();
|
return;
|
}
|
|
if (txtTableList.Text == "")
|
{
|
txtTableList.Focus();
|
txtTableList.ShowPopup();
|
return;
|
}
|
|
if (txtTableList.Text != "")
|
try
|
{
|
frmWaitingEx.ShowMe(this);
|
var tableName = txtTableList.Text;
|
var dt = new bllFieldNameDefs().GetTableFields(
|
Loginer.CurrentUser.DBName,
|
txt_DBs.EditValue.ToStringEx(), tableName);
|
gcFields.DataSource = dt;
|
gcFields.RefreshDataSource();
|
if (gvFields.RowCount == 0)
|
Msg.Warning(
|
$"资料表{txtTableList.Text}没有字段数据，请使用【字段名管理】工具导入字段！");
|
}
|
finally
|
{
|
frmWaitingEx.HideMe(this);
|
}
|
}
|
|
private void btnSave_Click(object sender, EventArgs e)
|
{
|
DoSave();
|
}
|
|
private bool DoSave()
|
{
|
try
|
{
|
frmWaitingEx.ShowMe(this);
|
|
var dt = (gcFields.DataSource as DataTable).GetChanges();
|
|
if (dt != null)
|
{
|
if (LogEditHistory.SaveFieldDef(dt))
|
{
|
(gcFields.DataSource as DataTable).AcceptChanges();
|
Msg.ShowInformation("保存成功！");
|
}
|
else
|
{
|
Msg.Warning("保存失败！");
|
}
|
}
|
else
|
{
|
Msg.Warning("你没有修改数据！");
|
}
|
|
return true;
|
}
|
catch
|
{
|
return false;
|
}
|
finally
|
{
|
frmWaitingEx.HideMe(this);
|
}
|
}
|
|
private void frmLogFieldConfig_Load(object sender, EventArgs e)
|
{
|
DataBinderTools.BoundCheckEdit(repCheck);
|
|
//加载数据库清单
|
var dtDB = new bllFieldNameDefs().GetDataBaseList();
|
AddOtherDB(dtDB);
|
DataBinder.BindingComboEditDataSource(txt_DBs, dtDB, "DBName");
|
}
|
|
private void LoadTable(string DBName)
|
{
|
if (ConvertEx.ToString(txtTableList.Tag) != DBName)
|
{
|
//加载数据表
|
var dtTB = new bllFieldNameDefs().GetTableNames(DBName);
|
DataBinder.BindingComboEditDataSource(txtTableList, dtTB,
|
"TableName");
|
txtTableList.Tag = DBName; //标记
|
}
|
}
|
|
private void txt_DBs_EditValueChanged(object sender, EventArgs e)
|
{
|
txtTableList.Properties.Items.Clear();
|
txtTableList.EditValue = null;
|
}
|
|
private void txtTableList_QueryPopUp(object sender, CancelEventArgs e)
|
{
|
if (txt_DBs.Text != "")
|
LoadTable(txt_DBs.Text);
|
else
|
txt_DBs.Focus();
|
}
|
}
|
}
|
