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 { /// /// /// public partial class MANAGE_OUT : AvalonDock.DocumentContent { Model.MANAGE_TYPE mMANAGE_TYPE = null; List listMANAGE_MAIN = null; List listMANAGE_LIST = null; DataRowView[] listDataRowView = null; string STORAGE_AREA_TYPE = string.Empty; string CELL_ADJUST = string.Empty; /// /// /// 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); } } } /// /// 表单数据校验 /// 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; } } /// /// 初始化输送位置控件 /// private void InitManagePosotion() { this.ucManagePosition.U_InitControl(mMANAGE_TYPE.MANAGE_TYPE_ID); } /// /// 初始化查询控件 /// private void InitQueryControl() { this.ucQuery.U_WindowName = this.GetType().Name; this.ucQuery.U_XmlTableName = "V_STORAGE_LIST"; this.ucQuery.U_InitControl(); } /// /// 初始化属性面板 /// 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(); } /// /// 按钮事件 /// 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; } } } /// /// 创建输送任务 /// 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(value_ceLl_id.Cast().ToArray(), null); listMANAGE_LIST = new SiaSun.LMS.Common.CloneObjectValues().GetListFromDataTable(value_ceLl_id.Cast().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().ToArray()[0]["CELL_CODE"].ToString() + " 任务下达失败 " + sSingleReslut + "\n"; boolResult = false; break; } else { strResult += value_ceLl_id.Cast().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(value_ceLl_id.Cast().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(value_ceLl_id.Cast().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().ToArray()[0]["CELL_CODE"].ToString() + " 任务下达失败 " + sSingleReslut + "\n"; break; } else { strResult += value_ceLl_id.Cast().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(value_ceLl_id.Cast().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(value_ceLl_id.Cast().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().ToArray()[0]["CELL_CODE"].ToString() + " 任务下达失败 " + sSingleReslut + "\n"; break; } else { strResult += value_ceLl_id.Cast().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); } } /// /// 获得托盘集合列表 /// private IDictionary GetPalletKeyValuePair(DataRowView[] listDataRowView) { IDictionary dicStack = new Dictionary(); 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; } /// /// 刷新 /// private void Refresh() { this.ucManagePosition.U_Update(); this.ucStorageGroup.U_InitControl(); } } }