宜昌华友成品库管理软件
You can not select more than 25 topics Topics must start with a letter or number, can include dashes ('-') and can be up to 35 characters long.

126 lines
4.0 KiB

using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Windows;
using System.Windows.Controls;
using System.Windows.Data;
using System.Windows.Documents;
using System.Windows.Input;
using System.Windows.Media;
using System.Windows.Media.Imaging;
using System.Windows.Shapes;
namespace SiaSun.LMS.WPFClient.SYS
{
/// <summary>
/// DataGridWindow.xaml 的交互逻辑
/// </summary>
public partial class SYS_USER : AvalonDock.DocumentContent
{
bool boolAllowEdit = true;
string strTableName = string.Empty;
string strOrderField = string.Empty;
string strTotalColumn = string.Empty;
string strWhere = string.Empty;
/// <summary>
/// 构造函数
/// </summary>
/// <param name="TabText">窗体显示名</param>
/// <param name="TableName">数据库表名</param>
/// <param name="QueryWhere">查询条件</param>
/// <param name="AllowChecked">是否显示选择列</param>
/// <param name="AllowEdit">是否允许编辑数据</param>
/// <param name="TotalColumnName">计算数量总和的列名</param>
public SYS_USER(string TabText,
string TableName,
string QueryWhere,
string OrderField,
bool AllowEdit,
string TotalColumnName)
{
InitializeComponent();
//设置空间属性
this.Title = TabText;
this.boolAllowEdit = AllowEdit;
this.strTableName = TableName;
this.strOrderField = OrderField;
this.strTotalColumn = TotalColumnName;
this.strWhere = QueryWhere;
this.ucQKQuery.U_Query += new UC.ucQuickQuery.U_QueryEventHandler(ucQKQuery_U_Query);
}
/// <summary>
/// 初始化窗体
/// </summary>
private void DocumentContent_Loaded(object sender, RoutedEventArgs e)
{
//初始化查询控件
InitQueryControl();
//加载数据
LoadDataGrid();
}
/// <summary>
/// 初始化查询控件
/// </summary>
private void InitQueryControl()
{
try
{
this.ucQKQuery.U_WindowName = this.GetType().Name;
this.ucQKQuery.U_XmlTableName = this.strTableName;
this.ucQKQuery.U_InitControl();
}
catch (Exception ex)
{
MainApp._MessageDialog.ShowException(ex);
}
}
/// <summary>
/// 加载数据
/// </summary>
private void LoadDataGrid()
{
try
{
this.gridQuery.U_WindowName = this.GetType().Name;
this.gridQuery.U_TableName = this.strTableName;
this.gridQuery.U_Where = this.strWhere;
this.gridQuery.U_OrderField = this.strOrderField;
this.gridQuery.U_TotalColumnName = this.strTotalColumn;
this.gridQuery.U_AllowOperatData = this.boolAllowEdit;
this.gridQuery.U_AllowPage = true;
this.gridQuery.U_AllowChecked= this.boolAllowEdit;
this.gridQuery.U_InitControl();
}
catch (Exception ex)
{
MainApp._MessageDialog.ShowException(ex);
}
}
//查询数据
void ucQKQuery_U_Query(string QueryWhere)
{
try
{
//查询
this.strWhere = string.IsNullOrEmpty(strWhere) ? "1=1" : strWhere;
this.gridQuery.U_Where = string.IsNullOrEmpty(QueryWhere) ? strWhere : (QueryWhere.Length == 0 ? string.Empty : QueryWhere + " AND " + strWhere);
this.gridQuery.U_InitControl();
}
catch (Exception ex)
{
MainApp._MessageDialog.ShowException(ex);
}
}
}
}