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.
77 lines
4.2 KiB
77 lines
4.2 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;
|
|
using System.IO;
|
|
using System.Xml;
|
|
using System.Data;
|
|
using System.Reflection;
|
|
|
|
namespace SiaSun.LMS.WPFClient.SYS
|
|
{
|
|
public partial class RECORD_SUMMARY : AvalonDock.DocumentContent
|
|
{
|
|
public RECORD_SUMMARY()
|
|
{
|
|
InitializeComponent();
|
|
}
|
|
|
|
private void DocumentContent_Loaded(object sender, RoutedEventArgs e)
|
|
{
|
|
this.dtpStart.SelectedDate = DateTime.Now;
|
|
this.dtpEnd.SelectedDate = DateTime.Now;
|
|
this.dgRecordSummary.U_WindowName = this.GetType().Name;
|
|
this.dgRecordSummary.U_TableName = "RECORD_SUMMARY";
|
|
this.dgRecordSummary.U_XmlTableName = "RECORD_SUMMARY";
|
|
this.dgRecordSummary.U_OrderField = "GOODS_NAME";
|
|
this.dgRecordSummary.U_Where = "1<>1";
|
|
this.dgRecordSummary.U_AllowOperatData = false;
|
|
this.dgRecordSummary.U_AllowChecked = false;
|
|
this.dgRecordSummary.U_InitControl();
|
|
}
|
|
|
|
private void WrapPanel_Click(object sender, RoutedEventArgs e)
|
|
{
|
|
Button btn = e.OriginalSource as Button;
|
|
if (btn != null)
|
|
{
|
|
switch (btn.Name)
|
|
{
|
|
case "btnSearch":
|
|
string sStart = string.Empty;
|
|
string sEnd = string.Empty;
|
|
if (this.dtpStart.SelectedDate.HasValue && this.dtpEnd.SelectedDate.HasValue)
|
|
{
|
|
sStart = this.dtpStart.SelectedDate.Value.ToString("yyyy-MM-dd 00:00:00");
|
|
sEnd = this.dtpEnd.SelectedDate.Value.ToString("yyyy-MM-dd 23:59:59");
|
|
}
|
|
else
|
|
{
|
|
MainApp._MessageDialog.ShowResult(false, "请选择时间段");
|
|
return;
|
|
}
|
|
//DataTable dtQuantity = MainApp._I_BaseService.GetList(string.Format(
|
|
// "select GOODS_NAME,(select count(0) as QUANTITY from V_RECORD_LIST where GOODS_ID=GOODS_MAIN.GOODS_ID and LEN(START_POSITION)=5 and LEN(END_POSITION)=8 and MANAGE_END_TIME>='{0}' and MANAGE_END_TIME<='{1}') as IN_QUANTITY,(select count(0) as QUANTITY from V_RECORD_LIST where GOODS_ID=GOODS_MAIN.GOODS_ID and LEN(START_POSITION)=8 and LEN(END_POSITION)=5 and MANAGE_END_TIME>='{0}' and MANAGE_END_TIME<='{1}') as OUT_QUANTITY from GOODS_MAIN order by GOODS_ORDER",
|
|
// sStart, sEnd));
|
|
DataTable dtQuantity = MainApp._I_BaseService.GetList(string.Format(
|
|
"select GOODS_NAME,GOODS_ORDER,(select count(0) as QUANTITY from V_RECORD_LIST where GOODS_ID=GOODS_MAIN.GOODS_ID and LEN(START_POSITION)=5 and LEN(END_POSITION)=8 and MANAGE_END_TIME>='{0}' and MANAGE_END_TIME<='{1}') as IN_QUANTITY,(select count(0) as QUANTITY from V_RECORD_LIST where GOODS_ID=GOODS_MAIN.GOODS_ID and LEN(START_POSITION)=8 and LEN(END_POSITION)=5 and MANAGE_END_TIME>='{0}' and MANAGE_END_TIME<='{1}') as OUT_QUANTITY from GOODS_MAIN " +
|
|
"union all select USER_NAME as GOODS_NAME, 10 as GOODS_ORDER,(select count(0) as QUANTITY from V_RECORD_LIST where RECORD_OPERATOR=SYS_USER.USER_NAME and LEN(START_POSITION)=5 and LEN(END_POSITION)=8 and MANAGE_END_TIME>='{0}' and MANAGE_END_TIME<='{1}') as IN_QUANTITY,(select count(0) as QUANTITY from V_RECORD_LIST where RECORD_OPERATOR=SYS_USER.USER_NAME and LEN(START_POSITION)=8 and LEN(END_POSITION)=5 and MANAGE_END_TIME>='{0}' and MANAGE_END_TIME<='{1}') as OUT_QUANTITY from SYS_USER where USER_ID>0 order by GOODS_ORDER",
|
|
sStart, sEnd));
|
|
this.dgRecordSummary.U_DataSource = dtQuantity.DefaultView;
|
|
break;
|
|
case "btnClear":
|
|
this.dgRecordSummary.U_InitControl();
|
|
break;
|
|
}
|
|
}
|
|
}
|
|
}
|
|
}
|