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; using SiaSun.LMS.Common; namespace SiaSun.LMS.WPFClient.TASK { /// /// /// public partial class ManageDownOut : AvalonDock.DocumentContent { Model.MANAGE_TYPE mMANAGE_TYPE = null; List listMANAGE_LIST = null; DataRowView[] listDataRowView = null; #region 构造函数 public ManageDownOut(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}{2}", this.ucSplitPanel.U_GetSplitPropertyWhere(), string.IsNullOrEmpty(QueryWhere) ? "1=1" : QueryWhere, string.Format(" AND AREA_TYPE = 'LiKu' ")); this.StorageListBind(QueryWhere); } ); } #endregion #region 系统方法 private void DocumentContent_Loaded(object sender, RoutedEventArgs e) { this.InitManagePosotion(); //属性控件 this.InitSplitPropertyPanel(); //查询控件 this.InitQueryControl(); Plan_Type_Bind(); } #endregion #region 自定义方法 /// /// 初始化输送位置控件 /// private void InitManagePosotion() { //初始化 this.ucManagePosition.U_InitControl(mMANAGE_TYPE.MANAGE_TYPE_ID); this.ucManagePosition.U_END_POSITION_ID = 14596; } /// /// 初始化查询控件 /// 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 Plan_Type_Bind() { this.cbbPLAN_TYPE.DisplayMemberPath = "PLAN_TYPE_NAME"; this.cbbPLAN_TYPE.SelectedValuePath = "PLAN_TYPE_CODE"; try { string strSQL = string.Format(@"SELECT PLAN_TYPE_CODE, PLAN_TYPE_NAME FROM PLAN_TYPE WHERE PLAN_TYPE_INOUT = '2' AND PLAN_TYPE_FLAG= '1' ORDER BY PLAN_TYPE_ORDER"); this.cbbPLAN_TYPE.ItemsSource = MainApp._I_BaseService.GetList(strSQL).DefaultView; if (this.cbbPLAN_TYPE.Items.Count > 0) { this.cbbPLAN_TYPE.SelectedIndex = this.cbbPLAN_TYPE.SelectedIndex < 0 ? 0 : this.cbbPLAN_TYPE.SelectedIndex; } } catch (Exception ex) { MainApp._MessageDialog.ShowException(ex); } } 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 = (string.Empty != e.ProposedValue.ToString()) && Convert.ToDecimal(e.ProposedValue) > 0; //sResult = "请输入大于0的数量"; //bResult = (Convert.ToDecimal(e.ProposedValue) <= Convert.ToDecimal(e.Row["STORAGE_LIST_QUANTITY"])); //sResult = string.Format("出库数量不能大于库存数量!"); break; } if (bResult) { e.Row.RowError = null; e.Row.SetColumnError(e.Column, null); } else { e.Row.RowError = "数据校验失败"; e.Row.SetColumnError(e.Column, sResult); } } 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_STATUS <> 'PalletH' and GOODS_CONST_PROPERTY7=1 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(); } #endregion #region 按钮事件 private void WrapPanel_Click(object sender, RoutedEventArgs e) { Button btn = e.OriginalSource as Button; if (btn != null) { switch (btn.Name) { case "btnConfirm": this.CreateTaskOut(); break; case "btnRefresh": this.Refresh(); break; } } } ///// ///// 创建下架出库任务 ///// //private void CreateTaskOut() //{ // bool boolResult = false; // bool boolSingleResult = true; // string strResult = string.Empty; // string sSingleReslut = string.Empty; // try // { // //获得选中记录 // listDataRowView = this.ucStorageGroup.U_GetCheckedDataRows(); // this.ucStorageGroup.U_EndCurrentEdit(); // boolResult = this.ucManagePosition.U_CHECK_WAREHOUSE(); // if (!boolResult) // return; // #region 校验表单数据 // if (this.ucStorageGroup.U_DataSource.HasErrors) // { // MainApp._MessageDialog.Show(false, "表单存在不合法的数据"); // return; // } // if (listDataRowView.Length == 0) // { // MainApp._MessageDialog.Show(false,"请选中要出库的记录"); // return; // } // #endregion // #region 校验出库类型 // if (this.cbbPLAN_TYPE.SelectedValue == null) // { // MainApp._MessageDialog.Show(false, "请选择出库类型"); // return; // } // #endregion // var storage_id_group = from v in listDataRowView // group v by v["STORAGE_ID"].ToString() into a // select a; // if (MainApp._MessageDialog.ShowDialog("确认下达【下架出库】任务") == Sid.Windows.Controls.TaskDialogResult.Ok) // { // //获得所有的选定的条码 // foreach (var storage_id in storage_id_group) // { // var value_storage_id = from v in listDataRowView // where v["STORAGE_ID"].ToString() == storage_id.Key // select v; // listMANAGE_LIST = new SiaSun.LMS.Common.CloneObjectValues().GetListFromDataTable(value_storage_id.Cast().ToArray(), null); // var list = listMANAGE_LIST.Where(v => v.MANAGE_LIST_QUANTITY >= 0); // listMANAGE_LIST = list.ToList(); // //无计划下架出库,清空计划 // foreach (Model.MANAGE_LIST mMANAGE_LIST in listMANAGE_LIST) // { // mMANAGE_LIST.PLAN_LIST_ID = 0; // mMANAGE_LIST.MANAGE_LIST_QUANTITY = 0; // DataTable dt_whcell = MainApp._I_BaseService.GetList(string.Format(@"select * from wh_cell where cell_id = {0}", this.ucManagePosition.U_END_POSITION_ID)); // if (dt_whcell != null && dt_whcell.Rows[0]["CELL_CODE"].ToString().Equals("12043")) // { // DataTable dtcontrol = MainApp._I_BaseService.GetList(string.Format(@"select * from io_control where end_device_code='12043'")); // if (dtcontrol.Rows.Count > 0) // { // foreach (DataRow dr in dtcontrol.Rows) // { // if (!dr["control_remark"].Equals(mMANAGE_LIST.GOODS_PROPERTY1)) // { // //判断该盘是否进主线 // if (dr["control_status"].ToString().Equals("50")) // { // continue; // } // else // { // MainApp._MessageDialog.Show(false, "当前有未执行完的其他批次物料,请稍后再进行出库"); // return; // } // } // } // } // else // { // } // } // } // SiaSun.LMS.Model.MANAGE_MAIN mMANAGE_MAIN = new Model.MANAGE_MAIN(); // SiaSun.LMS.Model.STORAGE_MAIN mSTORAGE_MAIN = (Model.STORAGE_MAIN)MainApp._I_BaseService.GetModel("STORAGE_MAIN_SELECT_BY_ID", Convert.ToInt32(storage_id.Key)).RequestObject; // mMANAGE_MAIN.PLAN_ID = 0; // mMANAGE_MAIN.MANAGE_TYPE_CODE = mMANAGE_TYPE.MANAGE_TYPE_CODE.TrimEnd(); // mMANAGE_MAIN.PLAN_TYPE_CODE = this.cbbPLAN_TYPE.SelectedValue.ToString(); // mMANAGE_MAIN.STOCK_BARCODE = mSTORAGE_MAIN.STOCK_BARCODE; // mMANAGE_MAIN.CELL_MODEL = mSTORAGE_MAIN.CELL_MODEL; // mMANAGE_MAIN.FULL_FLAG = mSTORAGE_MAIN.FULL_FLAG; // mMANAGE_MAIN.START_CELL_ID = mSTORAGE_MAIN.CELL_ID; // 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.Waiting.ToString(); // mMANAGE_MAIN.MANAGE_LEVEL = string.Empty; // mMANAGE_MAIN.MANAGE_REMARK = string.Empty; // //未输入出库数量,下达【实盘下架】任务 // if (listMANAGE_LIST.Count == 0) // { // //#region ManageDown类型 // //Model.MANAGE_TYPE mNEW_MANAGE_TYPE = (Model.MANAGE_TYPE)MainApp._I_BaseService.GetModel("MANAGE_TYPE_SELECT_BY_MANAGE_TYPE_CODE", Enum.MANAGE_TYPE.ManageDown.ToString()).RequestObject; // //mMANAGE_MAIN.MANAGE_TYPE_CODE = SiaSun.LMS.Enum.MANAGE_TYPE.ManageDown.ToString(); // //mMANAGE_MAIN.PLAN_TYPE_CODE = string.Empty; // //#endregion // //listMANAGE_LIST = new SiaSun.LMS.Common.CloneObjectValues().GetListFromDataTable(value_storage_id.Cast().ToArray(), null); // //boolSingleResult = MainApp._I_BaseService.Invoke(mNEW_MANAGE_TYPE.MANAGE_TYPE_CLASS.TrimEnd(), // // "ManageCreate", // // new object[] {mMANAGE_MAIN, // // listMANAGE_LIST, // // true, // // this.cbControl.IsChecked // // }, // // out sSingleReslut); // boolSingleResult = false; // sSingleReslut = "请输入数量"; // } // else // { // boolSingleResult = MainApp._I_BaseService.Invoke(mMANAGE_TYPE.MANAGE_TYPE_CLASS.TrimEnd(), // "ManageCreate", // new object[] { mMANAGE_MAIN, // listMANAGE_LIST, // true, // this.cbControl.IsChecked // }, // out sSingleReslut); // } // if (!boolSingleResult) // { // strResult += value_storage_id.Cast().ToArray()[0]["CELL_CODE"].ToString() + " 任务下达失败 " + sSingleReslut + "\n"; // boolResult = false; // break; // } // else // { // strResult += value_storage_id.Cast().ToArray()[0]["CELL_CODE"].ToString() + " 任务下达成功 " + "\n"; // boolResult = true; // } // } // if (boolResult) // { // //刷新 // this.Refresh(); // } // MainApp._MessageDialog.Show(boolResult, strResult); // } // } // catch (Exception ex) // { // MainApp._MessageDialog.ShowException(ex); // } //} /// /// 创建下架出库任务 /// private void CreateTaskOut() { bool boolResult = false; bool boolSingleResult = true; string strResult = string.Empty; string sSingleReslut = string.Empty; ////待下达的数量 //decimal MANAGE_LIST_QUANTITY = mPLAN_LIST.PLAN_LIST_QUANTITY - mPLAN_LIST.PLAN_LIST_ORDERED_QUANTITY; ////累加本次下达的数量,在客户端体现 //decimal SUM_ORDER_QUANTITY = 0; try { //获得选中记录 listDataRowView = this.ucStorageGroup.U_GetCheckedDataRows(); this.ucStorageGroup.U_EndCurrentEdit(); boolResult = this.ucManagePosition.U_CHECK_WAREHOUSE(); if (!boolResult) return; #region 校验表单数据 if (this.ucManagePosition.U_END_POSITION_ID != 14596) { MainApp._MessageDialog.Show(false, "五金件类别的物料只能出库到12097出库站台,请重新选择目标位置"); return; } if (this.ucStorageGroup.U_DataSource.HasErrors) { MainApp._MessageDialog.Show(false, "表单存在不合法的数据"); return; } if (listDataRowView.Length == 0) { MainApp._MessageDialog.Show(false, "请选中要出库的记录"); return; } #endregion #region 校验出库类型 if (this.cbbPLAN_TYPE.SelectedValue == null) { MainApp._MessageDialog.Show(false, "请选择出库类型"); return; } #endregion var storage_id_group = from v in listDataRowView group v by v["STORAGE_ID"].ToString() into a select a; if (MainApp._MessageDialog.ShowDialog("请确认是否是料架,纸箱不允许出到叠料架出口!确认下达【下架出库】任务") == Sid.Windows.Controls.TaskDialogResult.Ok) { //while (MANAGE_LIST_QUANTITY > 0) //{ //if (!bResult) //{ // if (SUM_ORDER_QUANTITY > 0) // { // //表示本次已下达部分数量,但是库存数量小于计划未下达数量 // bResult = true; // return bResult; // } // else // { // return bResult; // } //} ////更新-待下达数量 //MANAGE_LIST_QUANTITY -= MANAGE_ORDER_QUANTITY; ////求取累加和 //SUM_ORDER_QUANTITY += MANAGE_ORDER_QUANTITY; //} //获得所有的选定的条码 foreach (var storage_id in storage_id_group) { var value_storage_id = from v in listDataRowView where v["STORAGE_ID"].ToString() == storage_id.Key select v; listMANAGE_LIST = new SiaSun.LMS.Common.CloneObjectValues().GetListFromDataTable(value_storage_id.Cast().ToArray(), null); var list = listMANAGE_LIST.Where(v => v.MANAGE_LIST_QUANTITY >= 0); listMANAGE_LIST = list.ToList(); //无计划下架出库,清空计划 foreach (Model.MANAGE_LIST mMANAGE_LIST in listMANAGE_LIST) { DataTable dt_GOODS_MAIN = MainApp._I_BaseService.GetList(string.Format(@"select * from GOODS_MAIN where GOODS_ID = {0}", mMANAGE_LIST.GOODS_ID)); if (dt_GOODS_MAIN.Rows.Count <= 0) { MainApp._MessageDialog.Show(false, "未找到该物料属性,系统无此物料"); return; } mMANAGE_LIST.PLAN_LIST_ID = 0; mMANAGE_LIST.MANAGE_LIST_QUANTITY =0; mMANAGE_LIST.GOODS_PROPERTY2 = dt_GOODS_MAIN.Rows[0]["GOODS_CODE"].ToString(); DataTable dt_whcell = MainApp._I_BaseService.GetList(string.Format(@"select * from wh_cell where cell_id = {0}", this.ucManagePosition.U_END_POSITION_ID)); if (dt_whcell != null && dt_whcell.Rows[0]["CELL_CODE"].ToString().Equals("12043")) { DataTable dtcontrol = MainApp._I_BaseService.GetList(string.Format(@"select * from io_control where end_device_code='12043'")); if (dtcontrol.Rows.Count > 0) { foreach (DataRow dr in dtcontrol.Rows) { if (!dr["control_remark"].Equals(mMANAGE_LIST.GOODS_PROPERTY2)) { //判断该盘是否进主线 if (dr["control_status"].ToString().Equals("50")) { continue; } else { MainApp._MessageDialog.Show(false, "当前有未执行完的其他批次物料,请稍后再进行出库"); return; } } } } else { } } } SiaSun.LMS.Model.MANAGE_MAIN mMANAGE_MAIN = new Model.MANAGE_MAIN(); SiaSun.LMS.Model.STORAGE_MAIN mSTORAGE_MAIN = (Model.STORAGE_MAIN)MainApp._I_BaseService.GetModel("STORAGE_MAIN_SELECT_BY_ID", Convert.ToInt32(storage_id.Key)).RequestObject; mMANAGE_MAIN.PLAN_ID = 0; mMANAGE_MAIN.MANAGE_TYPE_CODE = mMANAGE_TYPE.MANAGE_TYPE_CODE.TrimEnd(); mMANAGE_MAIN.PLAN_TYPE_CODE = this.cbbPLAN_TYPE.SelectedValue.ToString(); mMANAGE_MAIN.STOCK_BARCODE = mSTORAGE_MAIN.STOCK_BARCODE; mMANAGE_MAIN.CELL_MODEL = mSTORAGE_MAIN.CELL_MODEL; mMANAGE_MAIN.FULL_FLAG = mSTORAGE_MAIN.FULL_FLAG; mMANAGE_MAIN.START_CELL_ID = mSTORAGE_MAIN.CELL_ID; 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.Waiting.ToString(); mMANAGE_MAIN.MANAGE_LEVEL = string.Empty; mMANAGE_MAIN.MANAGE_REMARK = string.Empty; //未输入出库数量,下达【实盘下架】任务 if (listMANAGE_LIST.Count == 0) { //#region ManageDown类型 //Model.MANAGE_TYPE mNEW_MANAGE_TYPE = (Model.MANAGE_TYPE)MainApp._I_BaseService.GetModel("MANAGE_TYPE_SELECT_BY_MANAGE_TYPE_CODE", Enum.MANAGE_TYPE.ManageDown.ToString()).RequestObject; //mMANAGE_MAIN.MANAGE_TYPE_CODE = SiaSun.LMS.Enum.MANAGE_TYPE.ManageDown.ToString(); //mMANAGE_MAIN.PLAN_TYPE_CODE = string.Empty; //#endregion //listMANAGE_LIST = new SiaSun.LMS.Common.CloneObjectValues().GetListFromDataTable(value_storage_id.Cast().ToArray(), null); //boolSingleResult = MainApp._I_BaseService.Invoke(mNEW_MANAGE_TYPE.MANAGE_TYPE_CLASS.TrimEnd(), // "ManageCreate", // new object[] {mMANAGE_MAIN, // listMANAGE_LIST, // true, // this.cbControl.IsChecked // }, // out sSingleReslut); boolSingleResult = false; sSingleReslut = "请输入数量"; } else { boolSingleResult = MainApp._I_BaseService.Invoke(mMANAGE_TYPE.MANAGE_TYPE_CLASS.TrimEnd(), "ManageCreate", new object[] { mMANAGE_MAIN, listMANAGE_LIST, true, this.cbControl.IsChecked }, out sSingleReslut); } if (!boolSingleResult) { strResult += value_storage_id.Cast().ToArray()[0]["CELL_CODE"].ToString() + " 任务下达失败 " + sSingleReslut + "\n"; boolResult = false; break; } else { strResult += value_storage_id.Cast().ToArray()[0]["CELL_CODE"].ToString() + " 任务下达成功 " + "\n"; boolResult = true; } } if (boolResult) { //刷新 this.Refresh(); } MainApp._MessageDialog.Show(boolResult, strResult); } } catch (Exception ex) { MainApp._MessageDialog.ShowException(ex); } } /// /// 刷新 /// private void Refresh() { this.ucStorageGroup.U_Update(); //this.ucManagePosition.U_Update(); //this.Plan_Type_Bind(); } #endregion } }