#region
|
|
using System;
|
using System.ComponentModel;
|
using System.Data;
|
using System.Windows.Forms;
|
using CSFrameworkV5.Business;
|
using CSFrameworkV5.Common;
|
using CSFrameworkV5.Core;
|
using CSFrameworkV5.Core.Common;
|
using CSFrameworkV5.Library;
|
using CSFrameworkV5.Library.CommonClass;
|
using CSFrameworkV5.Models;
|
|
#endregion
|
|
namespace CSFrameworkV5.SystemModule
|
{
|
/// <summary>
|
/// 字段名对应的中文名称管理
|
/// </summary>
|
public partial class frmFieldNameMgr : frmBase
|
{
|
private bllFieldNameDefs _BLLInstance;
|
private string _DBID = "";
|
private string _TableName = "";
|
|
public frmFieldNameMgr()
|
{
|
InitializeComponent();
|
}
|
|
private void btnDel_Click(object sender, EventArgs e)
|
{
|
if (gvSummary.FocusedRowHandle >= 0)
|
{
|
if (Msg.AskQuestion("确定要删除当前记录吗?"))
|
try
|
{
|
frmWaitingEx.ShowMe(this);
|
|
var row = gvSummary.GetFocusedDataRow();
|
var key =
|
ConvertEx.ToString(
|
row[sys_FieldNameDefs.__KeyName]);
|
if (_BLLInstance.Delete(key)) //从物理表删除
|
{
|
gvSummary.DeleteRow(gvSummary
|
.FocusedRowHandle); //删除表格中缓存的记录
|
(gcSummary.DataSource as DataTable).AcceptChanges();
|
}
|
}
|
finally
|
{
|
frmWaitingEx.HideMe(this);
|
}
|
}
|
else
|
{
|
Msg.Warning("没有选择记录！");
|
}
|
}
|
|
private void btnEmpty_Click(object sender, EventArgs e)
|
{
|
txt_DisplayName.Text = "";
|
txt_FieldName.Text = "";
|
txt_TableName.Text = "";
|
txt_TableName.Focus();
|
}
|
|
private void btnFillCaption_Click(object sender, EventArgs e)
|
{
|
var dt = gcSummary.DataSource as DataTable;
|
|
foreach (DataRow R in dt.Rows)
|
{
|
var caption = R[sys_FieldNameDefs.DisplayName].ToStringEx();
|
var field = R[sys_FieldNameDefs.FieldName].ToStringEx();
|
var db = R[sys_FieldNameDefs.DBName].ToStringEx();
|
|
if (string.IsNullOrEmpty(caption) ||
|
caption.ToLower() == field.ToLower())
|
//获取字段标题
|
R[sys_FieldNameDefs.DisplayName] =
|
_BLLInstance.GetCaption(db, field);
|
}
|
}
|
|
private void btnQuery_Click(object sender, EventArgs e)
|
{
|
try
|
{
|
frmWaitingEx.ShowMe(this);
|
//搜索数据
|
var dt = _BLLInstance.Search(txt_TableName.Text,
|
txt_FieldName.Text, txt_DisplayName.Text);
|
gcSummary.DataSource = dt;
|
}
|
finally
|
{
|
frmWaitingEx.HideMe(this);
|
}
|
|
if (gvSummary.RowCount == 0 && txt_FieldName.Text == "" &&
|
txt_DisplayName.Text == "")
|
{
|
Msg.Warning("当前表没有字段资料，请确认表名是否输入正确，或者同步表结构！");
|
btnSync.Focus();
|
}
|
}
|
|
private void btnSave_Click(object sender, EventArgs e)
|
{
|
try
|
{
|
frmWaitingEx.ShowMe(this);
|
|
var data = (gcSummary.DataSource as DataTable).GetChanges();
|
if (data != null)
|
{
|
_BLLInstance.Update(data);
|
(gcSummary.DataSource as DataTable).AcceptChanges();
|
gcSummary.RefreshDataSource();
|
Msg.ShowInformation("保存成功！");
|
}
|
else
|
{
|
Msg.Warning("您没有修改数据！");
|
}
|
}
|
finally
|
{
|
frmWaitingEx.HideMe(this);
|
}
|
}
|
|
private void btnSync_Click(object sender, EventArgs e)
|
{
|
Assertion.AssertEditorEmpty(txt_DBs, "请选择数据库！", true);
|
Assertion.AssertEditorEmpty(txt_TableNameSync, "请输入表名！", true);
|
|
var msg = "确定要同步表结构数据吗? 注：保留中文字段描述";
|
|
if (Msg.AskQuestion(msg))
|
try
|
{
|
frmWaitingEx.ShowMe(this);
|
|
//同步表名
|
var dt = _BLLInstance.SyncTable(txt_DBs.Text,
|
txt_TableNameSync.Text);
|
|
if (dt.Rows.Count > 0)
|
{
|
gcSummary.DataSource = dt;
|
Msg.ShowInformation("同步完成，共生成" +
|
dt.Rows.Count.ToStringEx() +
|
"条记录！");
|
}
|
else
|
{
|
Msg.Warning("资料表不存在！");
|
}
|
}
|
catch (Exception ex)
|
{
|
Msg.ShowError(ex.Message);
|
}
|
finally
|
{
|
frmWaitingEx.HideMe(this);
|
}
|
}
|
|
/// <summary>
|
/// 由外部程序调用打开窗体
|
/// </summary>
|
/// <param name="ownerForm">父级窗体</param>
|
/// <param name="dataSetID">当前数据库</param>
|
/// <param name="dataSetDBName">当前数据库</param>
|
/// <param name="tableName">表名</param>
|
/// <param name="loginAccount">登录账号</param>
|
/// <param name="loginPwd">登录密码（明文密码）</param>
|
/// <param name="isExternalCall">是否外部调用</param>
|
public static void Exceute(
|
Form ownerForm,
|
string dataSetID,
|
string dataSetDBName,
|
string tableName,
|
string loginAccount,
|
string loginPwd,
|
bool isExternalCall)
|
{
|
//外部调用传入登录信息
|
if (isExternalCall)
|
{
|
KeyProvider.Default =
|
new KeyProviderRijndael("%SaFz$^p", "3aW%^&Fd");
|
|
var user = new Loginer();
|
user.Account = loginAccount;
|
user.Password = KeyProvider.Default.Encrypt(loginPwd); //test
|
user.AccountName = loginAccount;
|
user.DBID = dataSetID;
|
user.DBName = dataSetDBName;
|
user.LoginAuthType = LoginAuthType.LocalSystemAuth;
|
user.LoginTime = DateTime.Now;
|
|
Loginer.CurrentUser = user;
|
|
//外部调用，要初始化连接以及加载账套！
|
if (BridgeFactory.InitializeBridge())
|
{
|
Loginer.CurrentUser = user;
|
|
//未登陆:加载系统参数配置
|
var dtConfig = CommonData.GetSystemSettings4Program("", "");
|
SystemSettings.Current.Load(dtConfig);
|
}
|
else
|
{
|
throw new CustomException("初始化后连接连接策略失败！");
|
}
|
}
|
|
var form = new frmFieldNameMgr();
|
form.Owner = ownerForm;
|
form.ShowInTaskbar = true;
|
form.Init(dataSetDBName, tableName);
|
frmWaitingEx.HideMe(form);
|
form.ShowDialog();
|
}
|
|
private void frmFieldNameMgr_Load(object sender, EventArgs e)
|
{
|
CCursor.ShowDefaultCursor();
|
|
frmGridCustomize.RegisterGrid(gvSummary);
|
}
|
|
private void gcSummary_Click(object sender, EventArgs e)
|
{
|
}
|
|
/// <summary>
|
/// 外部调用初始化窗体
|
/// </summary>
|
/// <param name="DBName"></param>
|
/// <param name="tableName"></param>
|
private void Init(string DBName, string tableName)
|
{
|
_BLLInstance = new bllFieldNameDefs();
|
|
_DBID = DBName;
|
_TableName = tableName;
|
|
//加载数据库
|
LoadDB();
|
|
if (!string.IsNullOrEmpty(_DBID)) txt_DBs.EditValue = _DBID;
|
|
//加载数据表
|
if (!string.IsNullOrEmpty(DBName)) LoadTable(DBName);
|
|
if (!string.IsNullOrEmpty(_TableName))
|
{
|
txt_TableName.EditValue = _TableName;
|
txt_TableNameSync.EditValue = _TableName;
|
}
|
}
|
|
/// <summary>
|
/// 加载系统数据库所在服务器的全部数据库清单
|
/// </summary>
|
/// <param name="defaultDB"></param>
|
private void LoadDB()
|
{
|
txt_DBs.Properties.DisplayMember = "DBName";
|
txt_DBs.Properties.ValueMember = "DBName";
|
txt_DBs.Properties.DataSource = _BLLInstance.GetDataBaseList();
|
}
|
|
private void LoadTable(string DBName)
|
{
|
if (ConvertEx.ToString(txt_TableNameSync.Tag) != DBName)
|
{
|
txt_TableNameSync.Properties.DisplayMember = "TableName";
|
txt_TableNameSync.Properties.ValueMember = "TableName";
|
txt_TableNameSync.Properties.DataSource =
|
_BLLInstance.GetTableNames(DBName);
|
txt_TableNameSync.Tag = DBName; //标记
|
}
|
}
|
|
private void txt_DBs_EditValueChanged(object sender, EventArgs e)
|
{
|
txt_TableNameSync.Properties.DataSource = null;
|
txt_TableNameSync.EditValue = null;
|
}
|
|
private void txt_TableNameSync_EditValueChanged(object sender,
|
EventArgs e)
|
{
|
//清空记录
|
if (gcSummary.DataSource != null &&
|
gcSummary.DataSource is DataTable)
|
{
|
var dt = gcSummary.DataSource as DataTable;
|
dt.Rows.Clear();
|
dt.AcceptChanges();
|
gcSummary.RefreshDataSource();
|
}
|
}
|
|
private void txt_TableNameSync_QueryPopUp(object sender,
|
CancelEventArgs e)
|
{
|
if (txt_DBs.Text != "")
|
LoadTable(txt_DBs.Text);
|
else
|
txt_DBs.Focus();
|
}
|
}
|
}
|
