WMS_DLRK/Client/SiaSun.LMS.WPFClient/TASK/ManageMerge.xaml.cs

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
{
    /// <summary>
    /// 
    /// </summary>
    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<DataRow> listRowManageList = new List<DataRow>();
                         
                         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);
                }
            }
        }

        /// <summary>
        /// 表单数据校验
        /// </summary>
        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);
            }
        }

        /// <summary>
        /// 配盘绑定
        /// </summary>
        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;
                }
            }
        }

        /// <summary>
        /// 确认
        /// </summary>
        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<Model.MANAGE_LIST> lsMANAGE_LIST = new SiaSun.LMS.Common.CloneObjectValues().GetListFromDataTable<Model.MANAGE_LIST>(tableSource, null);
                var list = from v in lsMANAGE_LIST
                           where v.MANAGE_LIST_QUANTITY > 0
                           select v;

                lsMANAGE_LIST = list.ToList<Model.MANAGE_LIST>();

                #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;
            }
        }

        /// <summary>
        /// 
        /// </summary>
        private void Refresh()
        {
            this.ucManagePosition.U_Update();
            this.ucManageIn.Data_Bind(" AREA_TYPE='XuNiKu' ");
            this.gridManageList.U_Update();
        }

        #endregion


    }
}