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.
115 lines
5.8 KiB
115 lines
5.8 KiB
using SSWMS.Common;
|
|
using System;
|
|
using System.Windows;
|
|
|
|
namespace SSWMS.Client
|
|
{
|
|
public partial class DateSectQueryWindow : AvalonDock.DocumentContent
|
|
{
|
|
private string U_DateSectColumn = string.Empty;
|
|
private string U_WindowName = "COMMON";
|
|
private string U_TableName = string.Empty;
|
|
private string U_XmlTableName = string.Empty;
|
|
private string U_DataSource_SQL = string.Empty;
|
|
private string U_Where = string.Empty;
|
|
private string U_OrderField = string.Empty;
|
|
private string U_TotalColumnName = string.Empty;
|
|
private bool U_AllowChecked = false;
|
|
private bool U_AllowOperatData = false;
|
|
|
|
public DateSectQueryWindow(string type)
|
|
{
|
|
InitializeComponent();
|
|
switch (type)
|
|
{
|
|
case "RECORD":
|
|
this.U_TableName = "V_RECORD_MANAGE";
|
|
this.U_XmlTableName = "V_RECORD_MANAGE";
|
|
this.U_DateSectColumn = "MANAGE_END_TIME";
|
|
this.U_OrderField = "RECORD_LIST_ID";
|
|
//this.U_TotalColumnName = "RECORD_LIST_QUANTITY";
|
|
this.dsDateSect.cbTime.Content = "完成时间区间";
|
|
break;
|
|
case "RECORD_SUMMARY":
|
|
this.U_DataSource_SQL = "select GOODS_CODE,GOODS_NAME,STORAGE_PROPERTY_01,STORAGE_PROPERTY_02," +
|
|
"sum(case when MANAGE_TYPE='InCell' and STOCK_BARCODE=GOODS_BARCODE then 1 else 0 end) IN_STOCK_QUANTITY," +
|
|
"sum(case when MANAGE_TYPE='InCell' or STOCK_BARCODE<>GOODS_BARCODE then 0 else 1 end) OUT_STOCK_QUANTITY," +
|
|
"sum(case when MANAGE_TYPE='InCell' then 1 else 0 end) IN_STORAGE_LIST_QUANTITY," +
|
|
"sum(case when MANAGE_TYPE='InCell' then 0 else 1 end) OUT_STORAGE_LIST_QUANTITY" +
|
|
$" from V_RECORD_MANAGE where MANAGE_STATUS<>'{SystemCode.MANAGE_STATUS.Delete}'" +
|
|
$" and (MANAGE_TYPE='{SystemCode.MANAGE_TYPE.InCell}' or MANAGE_TYPE='{SystemCode.MANAGE_TYPE.OutCell}' or MANAGE_TYPE='{SystemCode.MANAGE_TYPE.OutPick}')" +
|
|
" and {0} group by GOODS_CODE,GOODS_NAME,STORAGE_PROPERTY_01,STORAGE_PROPERTY_02";
|
|
this.U_TableName = "V_RECORD_SUMMARY";
|
|
this.U_XmlTableName = "V_RECORD_SUMMARY";
|
|
this.U_DateSectColumn = "MANAGE_END_TIME";
|
|
this.U_OrderField = "STORAGE_PROPERTY_01";
|
|
this.dsDateSect.cbTime.Content = "完成时间区间";
|
|
break;
|
|
case "PLAN":
|
|
this.U_TableName = "V_RECORD_PLAN";
|
|
this.U_XmlTableName = "V_RECORD_PLAN";
|
|
this.U_DateSectColumn = "PLAN_CREATE_TIME";
|
|
this.U_OrderField = "PLAN_LIST_ID";
|
|
//this.U_TotalColumnName = "PLAN_LIST_QUANTITY";
|
|
this.dsDateSect.cbTime.Content = "创建时间区间";
|
|
break;
|
|
}
|
|
DocumentContent_Loaded(null, null);
|
|
}
|
|
|
|
private void DocumentContent_Loaded(object sender, RoutedEventArgs e)
|
|
{
|
|
this.qqQuickQuery.U_Query += new UC.ucQuickQuery.U_QueryEventHandler((sQueryWhere) =>
|
|
{
|
|
string sAppendWhere = string.Empty;
|
|
if (true == this.dsDateSect.cbTime.IsChecked)
|
|
{
|
|
sAppendWhere = string.Format("{0}>='{1}' and {0}<='{2}' and {3}",
|
|
this.U_DateSectColumn,
|
|
this.dsDateSect.dtpStartTime.Value.ToString("yyyy-MM-dd HH:mm:ss"),
|
|
this.dsDateSect.dtpEndTime.Value.ToString("yyyy-MM-dd HH:mm:ss"),
|
|
string.IsNullOrWhiteSpace(sQueryWhere) ? "1=1" : sQueryWhere);
|
|
}
|
|
else
|
|
{
|
|
sAppendWhere = sQueryWhere;
|
|
}
|
|
if (this.U_TableName == "V_RECORD_SUMMARY")
|
|
{
|
|
this.dgDataGrid.U_DataSource_SQL = string.Format(this.U_DataSource_SQL, sAppendWhere);
|
|
}
|
|
else
|
|
{
|
|
this.dgDataGrid.U_AppendWhere = sAppendWhere;
|
|
}
|
|
this.dgDataGrid.U_InitControl();
|
|
});
|
|
this.qqQuickQuery.U_WindowName = this.U_WindowName;
|
|
this.qqQuickQuery.U_XmlTableName = this.U_XmlTableName;
|
|
this.qqQuickQuery.U_InitControl();
|
|
this.dgDataGrid.U_WindowName = this.U_WindowName;
|
|
this.dgDataGrid.U_TableName = this.U_TableName;
|
|
this.dgDataGrid.U_XmlTableName = this.U_XmlTableName;
|
|
this.dgDataGrid.U_Where = this.U_Where;
|
|
this.dsDateSect.dtpStartTime.Value = DateTime.Today;
|
|
this.dsDateSect.dtpEndTime.Value = this.dsDateSect.dtpStartTime.Value.AddDays(1);
|
|
string sAppendWhereToday = string.Format("{0}>='{1}' and {0}<='{2}'",
|
|
U_DateSectColumn,
|
|
this.dsDateSect.dtpStartTime.Value.ToString("yyyy-MM-dd HH:mm:ss"),
|
|
this.dsDateSect.dtpEndTime.Value.ToString("yyyy-MM-dd HH:mm:ss"));
|
|
if (this.U_TableName == "V_RECORD_SUMMARY")
|
|
{
|
|
this.dgDataGrid.U_DataSource_SQL = string.Format(this.U_DataSource_SQL, sAppendWhereToday);
|
|
}
|
|
else
|
|
{
|
|
this.dgDataGrid.U_AppendWhere = sAppendWhereToday;
|
|
}
|
|
this.dgDataGrid.U_OrderField = this.U_OrderField;
|
|
this.dgDataGrid.U_AllowChecked = this.U_AllowChecked;
|
|
this.dgDataGrid.U_AllowOperatData = this.U_AllowOperatData;
|
|
this.dgDataGrid.U_TotalColumnName = this.U_TotalColumnName;
|
|
this.dgDataGrid.U_InitControl();
|
|
}
|
|
}
|
|
}
|