#region using System; using System.Data; using CSFrameworkV5.Business; using CSFrameworkV5.Common; using CSFrameworkV5.Core; using CSFrameworkV5.Library.CommonClass; using DevExpress.XtraGrid.Views.Base; #endregion ///*************************************************************************/ ///* ///* 文件名 :frmLogEditHistory.cs ///* 程序说明 : 修改历史记录查询窗体 ///* 原创作者 :www.csframework.com ///* ///* Copyright 2006-2021 C/S框架网 www.csframework.com ///* ///**************************************************************************/ namespace CSFrameworkV5.Library { /// /// 修改历史记录查询窗体 /// public partial class frmLogEditHistory : frmBaseChild { //最后一次搜索结果 private DataSet _LastSearch; public frmLogEditHistory() { InitializeComponent(); } private void btnEmpty_Click(object sender, EventArgs e) { CommonTools.ClearContainerEditorText(panelControl1); } //执行查询 private void btnQuery_Click(object sender, EventArgs e) { if (txtTableList.ItemIndex >= 0) { try { frmWaitingEx.ShowMe(this); var row = (DataRowView)txtTableList.Properties .GetDataSourceRowByKeyValue(txtTableList.EditValue); var tableName = ConvertEx.ToString(txtTableList.EditValue); var keyValue = txtKeyValue.Text; _LastSearch = LogEditHistory.SearchLog("", tableName, keyValue, txtDateFrom.DateTime, txtDateTo.DateTime); gcSummary.DataSource = _LastSearch.Tables[0]; gvSummary_FocusedRowChanged(gvSummary, new FocusedRowChangedEventArgs(-1, gvSummary.FocusedRowHandle)); gvSummary.OptionsView.RowAutoHeight = chkRowHeight.Checked; } finally { frmWaitingEx.HideMe(this); } if (gvSummary.RowCount == 0) { gcDetail.DataSource = null; Msg.Warning("没有修改历史记录!"); } } else { Msg.Warning("请选择单据!"); txtTableList.Focus(); txtTableList.ShowPopup(); } } private void chkRowHeight_CheckedChanged(object sender, EventArgs e) { gvSummary.OptionsView.RowAutoHeight = chkRowHeight.Checked; } private void frmModifyLog_Load(object sender, EventArgs e) { InitButtons(); txtDateTo.DateTime = DateTime.Today; var dt = new bllFieldNameDefs().GetTableNames(Loginer.CurrentUser .DBName); DataBinder.BindingLookupEditDataSource(txtTableList, dt, "TableName", "TableName"); } //移动主表记录自动显示明细记录 private void gvSummary_FocusedRowChanged(object sender, FocusedRowChangedEventArgs e) { if (_LastSearch != null && e.FocusedRowHandle >= 0) { var GUID32 = ConvertEx.ToString( gvSummary.GetDataRow(e.FocusedRowHandle)["GUID32"]); var detail = _LastSearch.Tables[1].DefaultView; detail.RowFilter = "GUID32='" + GUID32 + "'"; gcDetail.DataSource = detail; } } public void ShowData(string tableName, string keyValue, DateTime beginDate) { txtTableList.EditValue = tableName; txtDateFrom.EditValue = beginDate; txtKeyValue.EditValue = keyValue; btnQuery_Click(btnQuery, new EventArgs()); } } }