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.Model; namespace SiaSun.LMS.WPFClient.TASK { /// /// /// public partial class ManageMerge : AvalonDock.DocumentContent { Model.MANAGE_TYPE mMANAGE_TYPE = null; #region 系统方法 public ManageMerge(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.ucManageIn.U_CheckedDataGridRows += new UC.ucManageInInput.U_CheckedDataGridRowsHandler (() => { try { DataRowView[] arRow = this.ucManageIn.U_CheckedDataRowViews; if (arRow.Length == 0) { MainApp._MessageDialog.Show(false,"请检查是否选中配盘数据!"); return; } List listRowManageList = new List(); foreach (DataRowView rowView in arRow) { if (rowView.Row.Table.Columns.Contains("STOCK_BARCODE") && (rowView["STOCK_BARCODE"].ToString() == this.ucManagePosition.U_STOCK_BARCODE.TrimEnd()) && (!string.IsNullOrEmpty(rowView["STOCK_BARCODE"].ToString()))) { MainApp._MessageDialog.Show(false, string.Format("容器[{0}]上已存在所选记录", rowView["STOCK_BARCODE"].ToString())); return; } DataRow rowManageList; using (DataTable tableManageList = MainApp._I_BaseService.GetList(string.Format("SELECT * FROM V_STORAGE_LIST WHERE STORAGE_ID={0}",0))) { rowManageList = tableManageList.NewRow(); rowManageList["GOODS_ID"] = rowView["GOODS_ID"].ToString(); rowManageList["STOCK_BARCODE"] = rowView["STOCK_BARCODE"].ToString(); rowManageList["GOODS_CODE"] = rowView["GOODS_CODE"].ToString(); rowManageList["GOODS_NAME"] = rowView["GOODS_NAME"].ToString(); rowManageList["GOODS_TYPE_ID"] = rowView["GOODS_TYPE_ID"].ToString(); rowManageList["MANAGE_LIST_QUANTITY"] = rowView["STORAGE_LIST_QUANTITY"].ToString(); rowManageList["STORAGE_LIST_ID"] = rowView["STORAGE_LIST_ID"].ToString(); rowManageList["STORAGE_LIST_QUANTITY"] = rowView["STORAGE_LIST_QUANTITY"].ToString(); rowManageList["GOODS_UNITS"] = rowView["GOODS_UNITS"].ToString(); rowManageList["ENTRY_TIME"] = rowView["ENTRY_TIME"].ToString(); rowManageList["UPDATE_TIME"] = rowView["UPDATE_TIME"].ToString(); rowManageList["GOODS_PROPERTY1"] = rowView["GOODS_PROPERTY1"].ToString(); rowManageList["GOODS_PROPERTY2"] = rowView["GOODS_PROPERTY2"].ToString(); rowManageList["GOODS_PROPERTY3"] = rowView["GOODS_PROPERTY3"].ToString(); rowManageList["GOODS_PROPERTY4"] = rowView["GOODS_PROPERTY4"].ToString(); rowManageList["GOODS_PROPERTY5"] = rowView["GOODS_PROPERTY5"].ToString(); rowManageList["GOODS_PROPERTY6"] = rowView["GOODS_PROPERTY6"].ToString(); rowManageList["GOODS_PROPERTY7"] = rowView["GOODS_PROPERTY7"].ToString(); rowManageList["GOODS_PROPERTY8"] = rowView["GOODS_PROPERTY8"].ToString(); tableManageList.Rows.Add(rowManageList); listRowManageList.Add(rowManageList); } } this.gridManageList.U_AddTabPageRows(listRowManageList.ToArray()); } catch (Exception ex) { MainApp._MessageDialog.ShowException(ex); } } ); } private void DocumentContent_Loaded(object sender, RoutedEventArgs e) { try { this.InitManagePosition(); this.ucManagePosition.U_StockBarcodeKeyDown += new UC.ucManagePosition.U_StockBarcodeKeyDownHandler (() => { this.ucManageIn.Data_Bind(string.Format(" STOCK_BARCODE='{0}'", ucManagePosition.U_STOCK_BARCODE.Trim())); } ); Area_Bind(); this.InitManageInControl(); ManageListBind(); Register_DataTable_Event(); } catch (Exception ex) { MainApp._MessageDialog.ShowException(ex); } } private void cbbAREA_SelectionChanged(object sender, SelectionChangedEventArgs e) { if (e.Source == null) return; this.cbbCELL.DisplayMemberPath = "CELL_NAME"; this.cbbCELL.SelectedValuePath = "CELL_ID"; try { string strSQL = string.Format(@"SELECT CELL_ID, CELL_NAME FROM WH_CELL WHERE CELL_TYPE = 'Cell' AND CELL_INOUT != 'Out' AND AREA_ID = {0} ORDER BY CELL_ID", this.cbbAREA.SelectedValue); this.cbbCELL.ItemsSource = MainApp._I_BaseService.GetList(strSQL).DefaultView; if (this.cbbCELL.Items.Count > 0) { this.cbbCELL.SelectedIndex = this.cbbCELL.SelectedIndex < 0 ? 0 : this.cbbCELL.SelectedIndex; } } catch (Exception ex) { MainApp._MessageDialog.ShowException(ex); } } #endregion #region 自定义方法 private void Register_DataTable_Event() { //当输入列值改变后验证数据是否合法 foreach (TabItem tabItem in this.gridManageList.tabSplitProperty.Items) { if (tabItem.HasContent) { DataTable tableSource = (tabItem.Content as UC.ucCommonDataGrid).U_DataSource.Table; tableSource.RowChanged -= new DataRowChangeEventHandler(tableSource_RowChanged); tableSource.RowChanged += new DataRowChangeEventHandler(tableSource_RowChanged); tableSource.ColumnChanged -= new DataColumnChangeEventHandler(table_ColumnChanged); tableSource.ColumnChanged += new DataColumnChangeEventHandler(table_ColumnChanged); } } } /// /// 表单数据校验 /// void tableSource_RowChanged(object sender, DataRowChangeEventArgs e) { if (e.Row.RowState == DataRowState.Added || e.Row.RowState == DataRowState.Modified) { //判断数量 if (e.Row.IsNull("MANAGE_LIST_QUANTITY") || (Convert.ToDecimal(e.Row["MANAGE_LIST_QUANTITY"]) > Convert.ToDecimal(e.Row["STORAGE_LIST_QUANTITY"])) || Convert.ToDecimal(e.Row["MANAGE_LIST_QUANTITY"]) <= 0 || string.IsNullOrEmpty(e.Row["MANAGE_LIST_QUANTITY"].ToString())) { e.Row.RowError = string.Format("请检查数量是否合法!"); } } } 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 InitManagePosition() { try { this.ucManagePosition.U_InitControl(mMANAGE_TYPE.MANAGE_TYPE_ID); } catch (Exception ex) { MainApp._MessageDialog.ShowException(ex); } } /// /// 配盘绑定 /// private void ManageListBind() { //if( !dicStoageLoad.ContainsKey(this.ucManagePosition.U_STOCK_BARCODE.TrimEnd())) //{ // dicStoageLoad.Clear(); // dicStoageLoad.Add(this.ucManagePosition.U_STOCK_BARCODE.TrimEnd(), true); //} this.gridManageList.U_WindowName = this.GetType().Name; this.gridManageList.U_TableName = "V_STORAGE_LIST"; this.gridManageList.U_XmlTableName = "V_STORAGE_LIST_LOCAL"; this.gridManageList.U_TotalColumnName = "MANAGE_LIST_QUANTITY"; this.gridManageList.U_OrderField = "STORAGE_LIST_ID"; this.gridManageList.U_Where = string.Format("STOCK_BARCODE='*'"); this.gridManageList.U_AllowOperatData = true; this.gridManageList.U_AllowChecked = false; this.gridManageList.U_AllowShowPage = false; this.gridManageList.U_AllowAdd = System.Windows.Visibility.Collapsed; this.gridManageList.U_AllowEdit = System.Windows.Visibility.Collapsed; this.gridManageList.U_AllowSave = System.Windows.Visibility.Collapsed; //拆分列属性 this.gridManageList.U_SplitPropertyType = "GOODS_TYPE"; this.gridManageList.U_SplitGroupColumn = "GOODS_TYPE_ID"; this.gridManageList.U_SplitPropertyColumn = "GOODS_PROPERTY"; this.gridManageList.U_SplitGroupHeader = "GOODS_TYPE.GOODS_TYPE_NAME"; this.gridManageList.U_InitControl(); } private void InitManageInControl() { this.ucManageIn.U_WindowName = this.GetType().ToString(); this.ucManageIn.U_ShowType = this.ucManagePosition.U_AssembleResource; this.ucManageIn.U_InitControl(); this.ucManageIn.Data_Bind(" AREA_TYPE='XuNiKu' "); } private void Area_Bind() { this.cbbAREA.DisplayMemberPath = "AREA_NAME"; this.cbbAREA.SelectedValuePath = "AREA_ID"; try { this.cbbAREA.ItemsSource = MainApp._I_CellService.AREA_GetList(0, "XuNiKu").DefaultView; if (this.cbbAREA.Items.Count > 0) { this.cbbAREA.SelectedIndex = this.cbbAREA.SelectedIndex < 0 ? 0 : this.cbbAREA.SelectedIndex; } } catch (Exception ex) { MainApp._MessageDialog.ShowException(ex); } } #endregion #region 按钮事件 private void Button_Click(object sender, RoutedEventArgs e) { Button btn = e.OriginalSource as Button; if (btn != null) { switch (btn.Name) { case "btnSave": this.Confirm(); break; case "btnRefresh": this.Refresh(); break; } } } /// /// 确认 /// private void Confirm() { bool bResult = true; string sResult = string.Empty; try { MainWindow.mainWin.Cursor = Cursors.Wait; this.gridManageList.U_EndCurrentEdit(); #region 校验数据表单 //检验数据是否合法 DataTable tableSource = this.gridManageList.U_DataSource; if (tableSource == null) { bResult = false; MainApp._MessageDialog.Show(bResult, "请填写数据表单"); return; } //根据数据源获得数据列表 List lsMANAGE_LIST = new SiaSun.LMS.Common.CloneObjectValues().GetListFromDataTable(tableSource, null); var list = from v in lsMANAGE_LIST where v.MANAGE_LIST_QUANTITY > 0 select v; lsMANAGE_LIST = list.ToList(); #region ------校验合法性 //判断是否填写数据 if (lsMANAGE_LIST.Count <= 0) { bResult = false; MainApp._MessageDialog.Show(bResult, "请填写【配盘数量】"); return; } //判断数据是否合法 if (tableSource.HasErrors) { bResult = false; MainApp._MessageDialog.Show(bResult, "表单存在不合法的数据"); return; } #endregion #endregion #region 校验配盘库区 if (this.cbbAREA.SelectedValue == null) { bResult = false; sResult = string.Format("请选择配盘库区"); MainApp._MessageDialog.Show(bResult, sResult); return; } #endregion #region 校验配盘地点 if (this.cbbCELL.SelectedValue == null) { bResult = false; sResult = string.Format("请选择配盘地点"); MainApp._MessageDialog.Show(bResult, sResult); return; } #endregion string STOCK_BARCODE = this.ucManagePosition.U_STOCK_BARCODE.ToUpper().Trim(); if (string.IsNullOrEmpty(STOCK_BARCODE)) { if (MainApp._MessageDialog.ShowDialog(string.Format("托盘条码为空,确定执行【取消配盘】操作", this.ucManagePosition.U_STOCK_BARCODE.ToUpper().Trim())) == Sid.Windows.Controls.TaskDialogResult.Cancel) { return; } } else { if (MainApp._MessageDialog.ShowDialog(string.Format("确认配盘[{0}]操作", STOCK_BARCODE)) == Sid.Windows.Controls.TaskDialogResult.Cancel) { return; } } #region 生成MANAGE_MAIN MANAGE_MAIN mMANAGE_MAIN = new Model.MANAGE_MAIN(); mMANAGE_MAIN.PLAN_ID = 0; mMANAGE_MAIN.PLAN_TYPE_CODE = string.Empty; mMANAGE_MAIN.MANAGE_TYPE_CODE = mMANAGE_TYPE.MANAGE_TYPE_CODE.TrimEnd(); mMANAGE_MAIN.STOCK_BARCODE = STOCK_BARCODE; mMANAGE_MAIN.CELL_MODEL = string.Empty; mMANAGE_MAIN.FULL_FLAG =string.IsNullOrEmpty(STOCK_BARCODE)?string.Empty: this.ucManagePosition.U_OCCUPY_PERCENT; mMANAGE_MAIN.START_CELL_ID = Convert.ToInt32(this.cbbCELL.SelectedValue); mMANAGE_MAIN.END_CELL_ID = Convert.ToInt32(this.cbbCELL.SelectedValue); 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; #endregion bResult = MainApp._I_BaseService.Invoke(mMANAGE_TYPE.MANAGE_TYPE_CLASS.TrimEnd(), "ManageCreate", new object[] { mMANAGE_MAIN, lsMANAGE_LIST}, out sResult); if (bResult) { this.gridManageList.U_Update(); this.ucManageIn.Data_Bind(" AREA_TYPE='XuNiKu' "); this.Refresh(); } MainApp._MessageDialog.Show(bResult, sResult); } catch (Exception ex) { MainApp._MessageDialog.ShowException(ex); } finally { MainWindow.mainWin.Cursor = Cursors.Arrow; } } /// /// /// private void Refresh() { this.ucManagePosition.U_Update(); this.ucManageIn.Data_Bind(" AREA_TYPE='XuNiKu' "); this.gridManageList.U_Update(); } #endregion } }