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 { /// /// MANAGE_MOVE_OUT.xaml 的交互逻辑 /// public partial class MANAGE_DOWN : AvalonDock.DocumentContent { Model.MANAGE_TYPE mMANAGE_TYPE = null; List listMANAGE_LIST = null; /// /// /// public MANAGE_DOWN(string MANAGE_TYPE_CODE) { InitializeComponent(); 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}", this.ucSplitPanel.U_GetSplitPropertyWhere(), string.IsNullOrEmpty(QueryWhere) ? "1=1" : QueryWhere); this.StorageListBind(QueryWhere); } ); } //加载窗体 private void DocumentContent_Loaded(object sender, RoutedEventArgs e) { //输送位置 this.InitManagePosotion(); //属性控件 this.InitSplitPropertyPanel(); //查询控件 this.InitQueryControl(); } /// /// 初始化输送位置控件 /// 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 AREA_TYPE= 'LiKu' 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(); } /// /// 按钮事件 /// 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 = false; bool boolSingleResult = true; string strResult = "\n"; string sSingleReslut = string.Empty; try { //校验填写仓库信息是否合法 if (!this.ucManagePosition.U_CHECK_WAREHOUSE()) return; //获得选中记录 List listDataRowView = this.ucStorageGroup.U_GetCheckedDataRows().Cast().ToList(); foreach (DataRowView drv in listDataRowView) { drv["MANAGE_LIST_QUANTITY"] = drv["STORAGE_LIST_QUANTITY"]; } //校验是否选中记录 if (listDataRowView.Count == 0) { MainApp._MessageDialog.Show(Enum.MessageConverter.SelectCount); return; } var cell_id_group = from v in listDataRowView group v by v["CELL_ID"].ToString() into a select a; if (MainApp._MessageDialog.ShowDialog(Enum.MessageConverter.ConfirmCreateTask, this.Title) == Sid.Windows.Controls.TaskDialogResult.Ok) { //获得所有的选定的条码 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; DataRowView[] drvGroup = value_ceLl_id.Cast().ToArray(); listMANAGE_LIST = new SiaSun.LMS.Common.CloneObjectValues().GetListFromDataTable(drvGroup, 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 = drvGroup[0]["STOCK_BARCODE"].ToString(); mMANAGE_MAIN.CELL_MODEL = this.ucManagePosition.U_CELL_MODEL; mMANAGE_MAIN.START_CELL_ID = intStartPositionID; 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_AutoCompleteTask, this.ucManagePosition.U_AutoDownloadControlTask }, 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; DataRowView[] drvGroup = value_ceLl_id.Cast().ToArray(); listMANAGE_LIST = new SiaSun.LMS.Common.CloneObjectValues().GetListFromDataTable(drvGroup, 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 = drvGroup[0]["STOCK_BARCODE"].ToString(); mMANAGE_MAIN.CELL_MODEL = this.ucManagePosition.U_CELL_MODEL; mMANAGE_MAIN.START_CELL_ID = intStartPositionID; 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_AutoCompleteTask, this.ucManagePosition.U_AutoDownloadControlTask }, 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(List 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(); } } }