#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
|
{
|
/// <summary>
|
/// 修改历史记录查询窗体
|
/// </summary>
|
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());
|
}
|
}
|
}
|
