宜昌华友成品库管理软件
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.

691 lines
31 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.Data;
namespace SiaSun.LMS.WPFClient.MANAGE
{
/// <summary>
///
/// </summary>
public partial class MANAGE_OUT : AvalonDock.DocumentContent
{
Model.MANAGE_TYPE mMANAGE_TYPE = null;
List<Model.MANAGE_MAIN> listMANAGE_MAIN = null;
List<Model.MANAGE_LIST> listMANAGE_LIST = null;
DataRowView[] listDataRowView = null;
string STORAGE_AREA_TYPE = string.Empty;
string CELL_ADJUST = string.Empty;
/// <summary>
///
/// </summary>
public MANAGE_OUT(string MANAGE_TYPE_CODE, string AREA_TYPE, string cell_adjust)
{
InitializeComponent();
STORAGE_AREA_TYPE = AREA_TYPE;
CELL_ADJUST = cell_adjust;
this.mMANAGE_TYPE = (Model.MANAGE_TYPE)MainApp._I_BaseService.GetModel("MANAGE_TYPE_SELECT_BY_MANAGE_TYPE_CODE", MANAGE_TYPE_CODE).RequestObject;
this.ucQuery.U_Query += new UC.ucQuickQuery.U_QueryEventHandler
((QueryWhere) =>
{
QueryWhere = string.Format("{0} AND {1}{2}",
this.ucSplitPanel.U_GetSplitPropertyWhere(),
string.IsNullOrEmpty(QueryWhere) ? "1=1" : QueryWhere,
this.STORAGE_AREA_TYPE == string.Empty ? string.Empty : string.Format(" AND V_STORAGE_LIST.AREA_TYPE = '{0}'", this.STORAGE_AREA_TYPE));
//string.Format(" order by V_STORAGE_LIST.CELL_FORK_TYPE asc "));
this.StorageListBind(QueryWhere);
}
);
}
private void DocumentContent_Loaded(object sender, RoutedEventArgs e)
{
//输送位置
this.InitManagePosotion();
//属性控件
this.InitSplitPropertyPanel();
//查询控件
this.InitQueryControl();
}
private void Register_DataTable_Event()
{
//当输入列值改变后验证数据是否合法
foreach (TabItem tabItem in this.ucStorageGroup.tabSplitProperty.Items)
{
if (tabItem.HasContent)
{
DataTable tableSource = (tabItem.Content as UC.ucCommonDataGrid).U_DataSource.Table;
tableSource.ColumnChanged -= new DataColumnChangeEventHandler(table_ColumnChanged);
tableSource.ColumnChanged += new DataColumnChangeEventHandler(table_ColumnChanged);
}
}
}
/// <summary>
/// 表单数据校验
/// </summary>
private void table_ColumnChanged(object sender, DataColumnChangeEventArgs e)
{
bool bResult = true;
string sResult = string.Empty;
//判断列
switch (e.Column.ColumnName)
{
case "MANAGE_LIST_QUANTITY":
bResult = (Convert.ToDecimal(e.ProposedValue) <= Convert.ToDecimal(e.Row["STORAGE_LIST_QUANTITY"]));
sResult = string.Format("出库数量不能大于库存数量!");
e.Row.ClearErrors();
if (bResult)
{
e.Row.SetColumnError(e.Column, null);
}
else
{
e.Row.SetColumnError(e.Column, sResult);
}
break;
}
}
/// <summary>
/// 初始化输送位置控件
/// </summary>
private void InitManagePosotion()
{
this.ucManagePosition.U_InitControl(mMANAGE_TYPE.MANAGE_TYPE_ID);
}
/// <summary>
/// 初始化查询控件
/// </summary>
private void InitQueryControl()
{
this.ucQuery.U_WindowName = this.GetType().Name;
this.ucQuery.U_XmlTableName = "V_STORAGE_LIST";
this.ucQuery.U_InitControl();
}
/// <summary>
/// 初始化属性面板
/// </summary>
private void InitSplitPropertyPanel()
{
this.ucSplitPanel.U_SplitGroupColumn = "GOODS_TYPE_ID";
this.ucSplitPanel.U_SplitGroupHeader = "GOODS_TYPE_NAME";
this.ucSplitPanel.U_SplitPropertyColumn = "GOODS_PROPERTY";
this.ucSplitPanel.U_SplitPropertyType = "GOODS_TYPE";
this.ucSplitPanel.U_InitControl();
}
private void StorageListBind(string QueryWhere)
{
this.ucStorageGroup.U_WindowName = this.GetType().Name;
this.ucStorageGroup.U_TableName = "V_STORAGE_LIST";
this.ucStorageGroup.U_XmlTableName = "V_STORAGE_LIST";
//this.ucStorageGroup.U_AppendFieldStyles = this.GetColumnDescriptionList();
this.ucStorageGroup.U_TotalColumnName = "STORAGE_LIST_QUANTITY";
this.ucStorageGroup.U_OrderField = "STORAGE_LIST_ID";
//this.ucStorageGroup.U_Where = string.Format(" cell_status <> 'Pallet' and cell_id not in ( select start_cell_id from manage_main) and {0} ",QueryWhere);
if (CELL_ADJUST == "PanDian")
{
this.ucStorageGroup.U_Where = string.Format("cell_id not in ( select start_cell_id from manage_main) and {0}", QueryWhere);
}
else
{
if (MainApp._USER.USER_CODE == "hgx")
{
this.ucStorageGroup.U_Where = string.Format("(GOODS_CLASS_ID<>1 or AREA_TYPE='XuNiKu') and cell_id not in ( select start_cell_id from manage_main) and {0}", QueryWhere);
}
else
{
this.ucStorageGroup.U_Where = string.Format("(GOODS_CLASS_ID<>1 or GOODS_PROPERTY9='1' or AREA_TYPE='XuNiKu') and cell_id not in ( select start_cell_id from manage_main) and {0}", QueryWhere);
}
}
this.ucStorageGroup.U_AllowOperatData = false;
this.ucStorageGroup.U_AllowChecked = true;
this.ucStorageGroup.U_AllowShowPage = true;
//拆分列属性
this.ucStorageGroup.U_SplitPropertyType = "GOODS_TYPE";
this.ucStorageGroup.U_SplitGroupColumn = "GOODS_TYPE_ID";
this.ucStorageGroup.U_SplitGroupHeader = "GOODS_TYPE.GOODS_TYPE_NAME";
this.ucStorageGroup.U_SplitPropertyColumn = "GOODS_PROPERTY";
this.ucStorageGroup.U_InitControl();
Register_DataTable_Event();
}
private void DoubleCellBind(string QueryWhere)
{
this.ucStorageGroup.U_WindowName = this.GetType().Name;
this.ucStorageGroup.U_TableName = "V_WH_CELL_DOUBLE_TO_NORMAL";
this.ucStorageGroup.U_XmlTableName = "V_WH_CELL_DOUBLE_TO_NORMAL";
//this.ucStorageGroup.U_AppendFieldStyles = this.GetColumnDescriptionList();
//this.ucStorageGroup.U_TotalColumnName = "STORAGE_LIST_QUANTITY";
this.ucStorageGroup.U_OrderField = "CELL_ID_FAR";
//this.ucStorageGroup.U_Where = string.Format(" cell_status <> 'Pallet' and cell_id not in ( select start_cell_id from manage_main) and {0} ",QueryWhere);
this.ucStorageGroup.U_Where = string.Format(" cell_id not in ( select start_cell_id from manage_main) and {0} ", QueryWhere);
this.ucStorageGroup.U_AllowOperatData = false;
this.ucStorageGroup.U_AllowChecked = true;
this.ucStorageGroup.U_AllowShowPage = true;
//拆分列属性
//this.ucStorageGroup.U_SplitPropertyType = "GOODS_TYPE";
//this.ucStorageGroup.U_SplitGroupColumn = "GOODS_TYPE_ID";
//this.ucStorageGroup.U_SplitGroupHeader = "GOODS_TYPE.GOODS_TYPE_NAME";
//this.ucStorageGroup.U_SplitPropertyColumn = "GOODS_PROPERTY";
this.ucStorageGroup.U_InitControl();
Register_DataTable_Event();
}
/// <summary>
/// 按钮事件
/// </summary>
private void WrapPanel_Click(object sender, RoutedEventArgs e)
{
Button btn = e.OriginalSource as Button;
if (btn != null)
{
switch (btn.Name)
{
case "btnConfirm":
this.CreateTask();
break;
case "btnRefresh":
this.Refresh();
break;
}
}
}
/// <summary>
/// 创建输送任务
/// </summary>
private void CreateTask()
{
int i = 0;//记任务的数量
bool boolResult = true;
bool boolSingleResult = true;
string strResult = string.Empty;
string sSingleReslut = string.Empty;
try
{
//校验填写仓库信息是否合法
if (!this.ucManagePosition.U_CHECK_WAREHOUSE())
return;
//获得选中记录
listDataRowView = this.ucStorageGroup.U_GetCheckedDataRows();
this.ucStorageGroup.U_EndCurrentEdit();
//判断数据是否合法
if (this.ucStorageGroup.U_DataSource.HasErrors)
{
MainApp._MessageDialog.Show(Enum.MessageConverter.Data);
return;
}
//根据数据源获得数据列表
//校验是否选中记录
if (listDataRowView.Length == 0)
{
MainApp._MessageDialog.Show(Enum.MessageConverter.SelectCount);
return;
}
string sUnique = "CELL_ID";
if (STORAGE_AREA_TYPE == "XuNiKu")
{
sUnique = "STOCK_BARCODE";
}
var cell_id_group = from v in listDataRowView
group v by v[sUnique].ToString() into a
select a;
if (MainApp._MessageDialog.ShowDialog(Enum.MessageConverter.ConfirmCreateTask, this.Title) == Sid.Windows.Controls.TaskDialogResult.Ok)
{
if (STORAGE_AREA_TYPE == "XuNiKu")
{
foreach (var cell_id in cell_id_group)
{
//int intStartPositionID = Convert.ToInt32(cell_id.Key);
int intStartPositionID = 0;
var value_ceLl_id = from v in listDataRowView
where v[sUnique].ToString() == cell_id.Key
select v;
if (STORAGE_AREA_TYPE == "LiKu")
{
boolSingleResult = MainApp._I_ManageService.MANAGE_LIST_CREATE(intStartPositionID, out listMANAGE_LIST, out sSingleReslut);
if (!boolSingleResult)
{
MainApp._MessageDialog.ShowResult(boolSingleResult, sSingleReslut);
break;
}
}
else
{
listMANAGE_MAIN = new SiaSun.LMS.Common.CloneObjectValues().GetListFromDataTable<Model.MANAGE_MAIN>(value_ceLl_id.Cast<DataRowView>().ToArray(), null);
listMANAGE_LIST = new SiaSun.LMS.Common.CloneObjectValues().GetListFromDataTable<Model.MANAGE_LIST>(value_ceLl_id.Cast<DataRowView>().ToArray(), null);
}
SiaSun.LMS.Model.MANAGE_MAIN mMANAGE_MAIN = new Model.MANAGE_MAIN();
mMANAGE_MAIN.MANAGE_TYPE_CODE = mMANAGE_TYPE.MANAGE_TYPE_CODE.TrimEnd();
mMANAGE_MAIN.PLAN_ID = 0;
mMANAGE_MAIN.STOCK_BARCODE = cell_id.Key;
mMANAGE_MAIN.START_CELL_ID = intStartPositionID;
if (STORAGE_AREA_TYPE == "XuNiKu")
{
mMANAGE_MAIN.END_CELL_ID = this.ucManagePosition.U_END_POSITION_ID;
}
if (STORAGE_AREA_TYPE == "PingKu")
{
mMANAGE_MAIN.END_CELL_ID = intStartPositionID;
}
if (STORAGE_AREA_TYPE == "LiKu")
{
mMANAGE_MAIN.END_CELL_ID = this.ucManagePosition.U_END_POSITION_ID;
}
mMANAGE_MAIN.MANAGE_OPERATOR = MainApp._USER.USER_NAME;
mMANAGE_MAIN.MANAGE_BEGIN_TIME = SiaSun.LMS.Common.StringUtil.GetDateTime();
mMANAGE_MAIN.MANAGE_STATUS = SiaSun.LMS.Enum.MANAGE_STATUS.Executing.ToString();
mMANAGE_MAIN.MANAGE_LEVEL = string.Empty;
mMANAGE_MAIN.MANAGE_REMARK = string.Empty;
if (STORAGE_AREA_TYPE == "XuNiKu")
{
boolSingleResult = MainApp._I_BaseService.Invoke(mMANAGE_TYPE.MANAGE_TYPE_CLASS.TrimEnd(),
"ManageCreateWorkingArea",
new object[] { mMANAGE_MAIN,
listMANAGE_LIST,
true,
this.ucManagePosition.U_AutoDownloadControlTask,
this.ucManagePosition.U_AutoCompleteTask
},
out sSingleReslut);
}
if (!boolSingleResult)
{
strResult += value_ceLl_id.Cast<DataRowView>().ToArray()[0]["CELL_CODE"].ToString() + " 任务下达失败 " + sSingleReslut + "\n";
boolResult = false;
break;
}
else
{
strResult += value_ceLl_id.Cast<DataRowView>().ToArray()[0]["CELL_CODE"].ToString() + " 任务下达成功 " + "\n";
i = listMANAGE_MAIN.Count;
boolResult = true;
}
}
}
else
{
DataTable dt_wh_cell = MainApp._I_BaseService.GetList(string.Format(@"select * from wh_cell where cell_id = {0}", this.ucManagePosition.U_END_POSITION_ID));
if (dt_wh_cell != null && dt_wh_cell.Rows.Count > 0)
{
if (dt_wh_cell.Rows[0]["CELL_CODE"].ToString().Equals("100") || dt_wh_cell.Rows[0]["CELL_CODE"].ToString().Equals("101"))
{
if (dt_wh_cell.Rows[0]["RUN_STATUS"].ToString().Equals("Disable"))
{
MessageBox.Show("目标站台不是出库模式");
return;
}
}
}
//获得所有的选定的条码
foreach (var cell_id in cell_id_group)
{
//获得起始位置
//int intStartAearID = aa.Value.AREA_ID;
DataTable CellFork = MainApp._I_BaseService.GetList(string.Format(@"select * from wh_cell where cell_id = {0}", cell_id.Key));
if (CellFork.Rows.Count > 0)
{
if (CellFork.Rows[0]["CELL_FORK_TYPE"].ToString() == "Near" || CellFork.Rows[0]["CELL_FORK_TYPE"].ToString() == "Normal")
{
int intStartPositionID = Convert.ToInt32(cell_id.Key);
var value_ceLl_id = from v in listDataRowView
where v["CELL_ID"].ToString() == cell_id.Key
select v;
listMANAGE_LIST = new SiaSun.LMS.Common.CloneObjectValues().GetListFromDataTable<Model.MANAGE_LIST>(value_ceLl_id.Cast<DataRowView>().ToArray(), null);
if (STORAGE_AREA_TYPE == "LiKu")
{
boolSingleResult = MainApp._I_ManageService.MANAGE_LIST_CREATE(intStartPositionID, out listMANAGE_LIST, out sSingleReslut);
if (!boolSingleResult)
{
MainApp._MessageDialog.ShowResult(boolSingleResult, sSingleReslut);
break;
}
}
else
{
listMANAGE_LIST = new SiaSun.LMS.Common.CloneObjectValues().GetListFromDataTable<Model.MANAGE_LIST>(value_ceLl_id.Cast<DataRowView>().ToArray(), null);
}
SiaSun.LMS.Model.MANAGE_MAIN mMANAGE_MAIN = new Model.MANAGE_MAIN();
if (listMANAGE_LIST[0].GOODS_ID == 32778)
{
mMANAGE_MAIN.MANAGE_TYPE_CODE = "StockOut";
}
else
{
mMANAGE_MAIN.MANAGE_TYPE_CODE = mMANAGE_TYPE.MANAGE_TYPE_CODE.TrimEnd();
}
mMANAGE_MAIN.PLAN_ID = 0;
mMANAGE_MAIN.STOCK_BARCODE = this.ucManagePosition.U_STOCK_BARCODE;
mMANAGE_MAIN.CELL_MODEL = this.ucManagePosition.U_CELL_MODEL;
mMANAGE_MAIN.START_CELL_ID = intStartPositionID;
if (STORAGE_AREA_TYPE == "XuNiKu")
{
mMANAGE_MAIN.END_CELL_ID = intStartPositionID;
}
if (STORAGE_AREA_TYPE == "PingKu")
{
mMANAGE_MAIN.END_CELL_ID = intStartPositionID;
}
if (STORAGE_AREA_TYPE == "LiKu")
{
mMANAGE_MAIN.END_CELL_ID = this.ucManagePosition.U_END_POSITION_ID;
}
mMANAGE_MAIN.MANAGE_OPERATOR = MainApp._USER.USER_NAME;
mMANAGE_MAIN.MANAGE_BEGIN_TIME = SiaSun.LMS.Common.StringUtil.GetDateTime();
mMANAGE_MAIN.MANAGE_STATUS = SiaSun.LMS.Enum.MANAGE_STATUS.WaitingSend.ToString();
mMANAGE_MAIN.MANAGE_LEVEL = string.Empty;
mMANAGE_MAIN.MANAGE_REMARK = string.Empty;
boolSingleResult = MainApp._I_BaseService.Invoke(mMANAGE_TYPE.MANAGE_TYPE_CLASS.TrimEnd(),
"ManageCreate",
new object[] { mMANAGE_MAIN,
listMANAGE_LIST,
true,
this.ucManagePosition.U_AutoDownloadControlTask,
this.ucManagePosition.U_AutoCompleteTask
},
out sSingleReslut);
if (!boolSingleResult)
{
strResult += value_ceLl_id.Cast<DataRowView>().ToArray()[0]["CELL_CODE"].ToString() + " 任务下达失败 " + sSingleReslut + "\n";
break;
}
else
{
strResult += value_ceLl_id.Cast<DataRowView>().ToArray()[0]["CELL_CODE"].ToString() + " 任务下达成功 " + "\n";
i++;
boolResult = true;
}
}
else
{
continue;
}
}
else
{
boolResult = false;
strResult = string.Format("近端或正常货位ID出错");
MainApp._MessageDialog.ShowResult(boolResult, strResult);
}
}
//获得所有的选定的条码
foreach (var cell_id in cell_id_group)
{
//获得起始位置
//int intStartAearID = aa.Value.AREA_ID;
DataTable CellFork = MainApp._I_BaseService.GetList(string.Format(@"select * from wh_cell where cell_id = {0}", cell_id.Key));
if (CellFork.Rows.Count > 0)
{
if (CellFork.Rows[0]["CELL_FORK_TYPE"].ToString() == "Far")
{
int intStartPositionID = Convert.ToInt32(cell_id.Key);
var value_ceLl_id = from v in listDataRowView
where v["CELL_ID"].ToString() == cell_id.Key
select v;
listMANAGE_LIST = new SiaSun.LMS.Common.CloneObjectValues().GetListFromDataTable<Model.MANAGE_LIST>(value_ceLl_id.Cast<DataRowView>().ToArray(), null);
if (STORAGE_AREA_TYPE == "LiKu")
{
boolSingleResult = MainApp._I_ManageService.MANAGE_LIST_CREATE(intStartPositionID, out listMANAGE_LIST, out sSingleReslut);
if (!boolSingleResult)
{
MainApp._MessageDialog.ShowResult(boolSingleResult, sSingleReslut);
break;
}
}
else
{
listMANAGE_LIST = new SiaSun.LMS.Common.CloneObjectValues().GetListFromDataTable<Model.MANAGE_LIST>(value_ceLl_id.Cast<DataRowView>().ToArray(), null);
}
SiaSun.LMS.Model.MANAGE_MAIN mMANAGE_MAIN = new Model.MANAGE_MAIN();
if (listMANAGE_LIST[0].GOODS_ID == 32778)
{
mMANAGE_MAIN.MANAGE_TYPE_CODE = "StockOut";
}
else
{
mMANAGE_MAIN.MANAGE_TYPE_CODE = mMANAGE_TYPE.MANAGE_TYPE_CODE.TrimEnd();
}
mMANAGE_MAIN.PLAN_ID = 0;
mMANAGE_MAIN.STOCK_BARCODE = this.ucManagePosition.U_STOCK_BARCODE;
mMANAGE_MAIN.CELL_MODEL = this.ucManagePosition.U_CELL_MODEL;
mMANAGE_MAIN.START_CELL_ID = intStartPositionID;
if (STORAGE_AREA_TYPE == "XuNiKu")
{
mMANAGE_MAIN.END_CELL_ID = intStartPositionID;
}
if (STORAGE_AREA_TYPE == "PingKu")
{
mMANAGE_MAIN.END_CELL_ID = intStartPositionID;
}
if (STORAGE_AREA_TYPE == "LiKu")
{
mMANAGE_MAIN.END_CELL_ID = this.ucManagePosition.U_END_POSITION_ID;
}
mMANAGE_MAIN.MANAGE_OPERATOR = MainApp._USER.USER_NAME;
mMANAGE_MAIN.MANAGE_BEGIN_TIME = SiaSun.LMS.Common.StringUtil.GetDateTime();
mMANAGE_MAIN.MANAGE_STATUS = SiaSun.LMS.Enum.MANAGE_STATUS.WaitingSend.ToString();
mMANAGE_MAIN.MANAGE_LEVEL = string.Empty;
mMANAGE_MAIN.MANAGE_REMARK = string.Empty;
if (STORAGE_AREA_TYPE == "XuNiKu")
{
boolSingleResult = MainApp._I_BaseService.Invoke(mMANAGE_TYPE.MANAGE_TYPE_CLASS.TrimEnd(),
"ManageCreateWorkingArea",
new object[] { mMANAGE_MAIN,
listMANAGE_LIST,
true,
this.ucManagePosition.U_AutoDownloadControlTask,
this.ucManagePosition.U_AutoCompleteTask
},
out sSingleReslut);
}
else
{
boolSingleResult = MainApp._I_BaseService.Invoke(mMANAGE_TYPE.MANAGE_TYPE_CLASS.TrimEnd(),
"ManageCreate",
new object[] { mMANAGE_MAIN,
listMANAGE_LIST,
true,
this.ucManagePosition.U_AutoDownloadControlTask,
this.ucManagePosition.U_AutoCompleteTask
},
out sSingleReslut);
}
if (!boolSingleResult)
{
strResult += value_ceLl_id.Cast<DataRowView>().ToArray()[0]["CELL_CODE"].ToString() + " 任务下达失败 " + sSingleReslut + "\n";
break;
}
else
{
strResult += value_ceLl_id.Cast<DataRowView>().ToArray()[0]["CELL_CODE"].ToString() + " 任务下达成功 " + "\n";
i++;
boolResult = true;
}
}
else
{
continue;
}
}
else
{
boolResult = false;
strResult = string.Format("远端货位ID出错");
MainApp._MessageDialog.ShowResult(boolResult, strResult);
}
}
}
//刷新
this.Refresh();
}
//add by lhj 20200519
string sRnum = string.Empty;
sRnum = string.Format("共计'{0}'个任务", i);
strResult = strResult + sRnum;
MainApp._MessageDialog.ShowResult(boolResult, strResult);
}
catch (Exception ex)
{
MainApp._MessageDialog.ShowException(ex);
}
}
/// <summary>
/// 获得托盘集合列表
/// </summary>
private IDictionary<string, Model.WH_CELL> GetPalletKeyValuePair(DataRowView[] listDataRowView)
{
IDictionary<string, Model.WH_CELL> dicStack = new Dictionary<string, Model.WH_CELL>();
foreach (DataRowView rowView in listDataRowView)
{
string stack = rowView["STOCK_BARCODE"].ToString();
if (stack != string.Empty)
{
//获得货位编号
SiaSun.LMS.Model.WH_CELL mWH_CELL = (Model.WH_CELL)MainApp._I_BaseService.GetModel("WH_CELL_SELECT_BY_ID", Convert.ToInt32(rowView["CELL_ID"])).RequestObject;
if (mWH_CELL != null && !dicStack.ContainsKey(stack))
{
dicStack.Add(stack, mWH_CELL);
}
}
}
return dicStack;
}
/// <summary>
/// 刷新
/// </summary>
private void Refresh()
{
this.ucManagePosition.U_Update();
this.ucStorageGroup.U_InitControl();
}
}
}