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.TASK
{
    public partial class ManagePlanDown_Out : AvalonDock.DocumentContent
    {
        int intPlanID = 0;

        Model.MANAGE_TYPE mMANAGE_TYPE = null;

        Model.PLAN_MAIN mPLAN_MAIN = null;

        DataRowView[] listDataRowView = null;

        string STORAGE_AREA_TYPE = string.Empty;

        #region 构造函数

        public ManagePlanDown_Out(int PLAN_ID, string MANAGE_TYPE_CODE, string AREA_TYPE)
        {
            InitializeComponent();

            intPlanID = PLAN_ID;

            STORAGE_AREA_TYPE = AREA_TYPE;

            this.mMANAGE_TYPE = (Model.MANAGE_TYPE)MainApp._I_BaseService.GetModel("MANAGE_TYPE_SELECT_BY_MANAGE_TYPE_CODE", MANAGE_TYPE_CODE).RequestObject;
        }

        #endregion

        #region 系统方法

        private void DocumentContent_Loaded(object sender, RoutedEventArgs e)
        {
            try
            {
                this.InitManagePosotion(0);

                if (intPlanID > 0)
                {
                    mPLAN_MAIN = MainApp._I_PlanService.PlanGetModel(intPlanID);

                    if (mPLAN_MAIN == null)
                    {
                        MainApp._MessageDialog.Show(false, string.Format("计划索引[{0}]不存在", intPlanID));
                    }
                }

                this.PLAN_LIST_Bind(intPlanID);
            }
            catch (Exception ex)
            {
                MainApp._MessageDialog.ShowException(ex);
            }
        }

        #endregion

        #region 自定义方法

        private void InitManagePosotion( int goods_id)
        {            
            //直接出库页面，不显示终止位置，不关联调度
            if (this.mMANAGE_TYPE.MANAGE_TYPE_CODE.Equals(SiaSun.LMS.Enum.MANAGE_TYPE.ManageOut.ToString()))
            {
                this.ucManagePosition.Visibility = System.Windows.Visibility.Collapsed;
                this.cbControl.IsChecked = false;
                this.cbControl.Visibility = Visibility.Collapsed;
            }
            else
            {
                this.ucManagePosition.U_InitControl(mMANAGE_TYPE.MANAGE_TYPE_ID);
                this.cbControl.IsChecked = true;
                this.cbControl.Visibility = Visibility.Visible;
                if (goods_id == 910)
                {
                    this.ucManagePosition.U_END_POSITION_ID = 14596;

                }
                else
                {
                    this.ucManagePosition.U_END_POSITION_ID = 13209;
                }
            }
        }

        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 PLAN_LIST_Bind(int PLAN_ID)
        {
            //数据源属性
            this.gridPlanList.U_Clear();
            this.gridPlanList.U_WindowName = this.GetType().Name;
            this.gridPlanList.U_TableName = "V_PLAN_LIST";
            this.gridPlanList.U_XmlTableName = "V_PLAN_LIST";
            this.gridPlanList.U_Fields = "*";
            this.gridPlanList.U_Where = string.Format("PLAN_ID ={0} AND (PLAN_LIST_QUANTITY>PLAN_LIST_ORDERED_QUANTITY)", PLAN_ID);
            this.gridPlanList.U_OrderField = "PLAN_LIST_ID";

            this.gridPlanList.U_AllowChecked = true;
            this.gridPlanList.U_AllowOperatData = false;
            this.gridPlanList.U_AllowShowPage = false;

            //拆分列属性
            this.gridPlanList.U_SplitPropertyType = "GOODS_TYPE";
            this.gridPlanList.U_SplitGroupColumn = "GOODS_TYPE_ID";
            this.gridPlanList.U_SplitPropertyColumn = "GOODS_PROPERTY";
            this.gridPlanList.U_SplitGroupHeader = "GOODS_TYPE.GOODS_TYPE_NAME";

            //明细属性
            //this.gridPlanList.U_DetailTableName = "PLAN_DETAIL";
            //this.gridPlanList.U_DetailRelatvieColumn = "PLAN_LIST_ID";

            try
            {
                this.gridPlanList.U_InitControl();
            }
            catch (Exception ex)
            {
                MainApp._MessageDialog.ShowException(ex);
            }
        }

        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 = "STOCK_BARCODE";
            this.ucStorageGroup.U_Where = string.Format(" {0} AND {1}", QueryWhere, this.STORAGE_AREA_TYPE.Equals("XuNiKu") ? "1=1" : "RUN_STATUS = 'Enable'");
            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();

            this.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.CreateTask();
                        break;
                    case "btnQuery":
                        this.Query();
                        break;
                }
            }
        }

        private void CreateTask()
        {
            bool boolResult = true;

            string strResult = string.Empty;

            try
            {
                if (this.ucManagePosition.Visibility == Visibility.Visible)
                {
                    if (!this.ucManagePosition.U_CHECK_WAREHOUSE())
                        return;
                }

                listDataRowView = this.ucStorageGroup.U_GetCheckedDataRows();

                this.ucStorageGroup.U_EndCurrentEdit();

                #region 校验库存表单

                if (listDataRowView.Length == 0)
                {
                    MainApp._MessageDialog.Show(false, "请选中要出库的记录");
                    return;
                }
               
                //var list = from v in listDataRowView
                //           where Convert.ToDecimal(v["MANAGE_LIST_QUANTITY"]) > 0
                //           select v;

                //if (list.Count() != listDataRowView.Length)
                //{
                //    MainApp._MessageDialog.Show(false, "选中记录的出库数量必须大于0");
                //    return;
                //}

                //判断数据是否合法
                if (this.ucStorageGroup.U_DataSource.HasErrors)
                {
                    MainApp._MessageDialog.Show(false, "库存表单存在不合法的数据");
                    return;
                }

                #endregion

                #region 获得所选托盘库存

                //获得列表
                IDictionary<string, Model.MANAGE_MAIN> dicStack = this.GetPalletKeyValuePair(listDataRowView);

                if (dicStack.Count == 0)
                {
                    MainApp._MessageDialog.Show(false, "检查所选库存是否存在");
                    return;
                }

                #endregion

                #region 校验计划表单

                DataRowView[] drvPLAN_LIST = this.gridPlanList.U_GetCheckedDataRows();

                if (drvPLAN_LIST.Length == 0)
                {
                    MainApp._MessageDialog.Show(false, "请选中计划明细记录");
                    return;
                }

                List<Model.PLAN_LIST> listPLAN_LIST = new SiaSun.LMS.Common.CloneObjectValues().GetListFromDataTable<Model.PLAN_LIST>(drvPLAN_LIST, null);
                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(listPLAN_LIST[0].GOODS_PROPERTY1))
                            {
                                //判断该盘是否进主线
                                if (dr["control_status"].ToString().Equals("50"))
                                {
                                    continue;
                                }
                                else
                                {
                                    MainApp._MessageDialog.Show(false, "当前有未执行完的其他批次物料，请稍后再进行出库");
                                    return;
                                }

                            }
                        }
                    }
                    else
                    {


                    }
                }
               
                #endregion

                if (MainApp._MessageDialog.ShowDialog("确认下达任务") == Sid.Windows.Controls.TaskDialogResult.Ok)
                {
                    //获得所有的选定的条码
                    foreach (KeyValuePair<string, Model.MANAGE_MAIN> stackCell in dicStack)
                    {
                        //获得起始位置
                        SiaSun.LMS.Model.MANAGE_MAIN mMANAGE_MAIN = new Model.MANAGE_MAIN();

                        var value_ceLl_id = from v in listDataRowView
                                            where v["STOCK_BARCODE"].ToString() == stackCell.Value.STOCK_BARCODE.ToString() 
                                            select v;

                       

                        List<Model.MANAGE_LIST> listMANAGE_LIST = new SiaSun.LMS.Common.CloneObjectValues().GetListFromDataTable<Model.MANAGE_LIST>(value_ceLl_id.Cast<DataRowView>().ToArray(), null);
                        
                        //if (this.ucManagePosition.U_END_POSITION_ID == 16646 || this.ucManagePosition.U_END_POSITION_ID == 13209)
                        //{
                            foreach(Model.MANAGE_LIST lst in listMANAGE_LIST)
                            {
                                DataTable dt = MainApp._I_BaseService.GetList(string.Format(@"select * from v_storage_list where stock_barcode='{0}' and goods_property1='{1}'", stackCell.Value.STOCK_BARCODE.ToString(), lst.GOODS_PROPERTY1));
                                lst.MANAGE_LIST_QUANTITY = Convert.ToDecimal(dt.Rows[0]["STORAGE_LIST_QUANTITY"].ToString());


                            }


                        //}
                        //else if (this.ucManagePosition.U_END_POSITION_ID == 14596)
                        //{
                        //    foreach (Model.MANAGE_LIST lst in listMANAGE_LIST)
                        //    {
                            
                        //    }


                        //}
                        mMANAGE_MAIN.MANAGE_TYPE_CODE = mMANAGE_TYPE.MANAGE_TYPE_CODE.TrimEnd();

                        mMANAGE_MAIN.PLAN_ID = intPlanID;

                        mMANAGE_MAIN.PLAN_TYPE_CODE = this.mPLAN_MAIN.PLAN_TYPE_CODE;

                        mMANAGE_MAIN.STOCK_BARCODE = stackCell.Value.STOCK_BARCODE;

                        mMANAGE_MAIN.START_CELL_ID = stackCell.Value.START_CELL_ID;

                        //直接出库，不显示终止位置
                        //下架出库，选择终止站台
                        if (!this.mMANAGE_TYPE.MANAGE_TYPE_CODE.Equals(SiaSun.LMS.Enum.MANAGE_TYPE.ManageOut.ToString()))
                        {
                            mMANAGE_MAIN.END_CELL_ID = this.ucManagePosition.U_END_POSITION_ID;
                        }
                        else
                        {
                            mMANAGE_MAIN.END_CELL_ID = mMANAGE_MAIN.START_CELL_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;

                        boolResult = MainApp._I_BaseService.Invoke(mMANAGE_TYPE.MANAGE_TYPE_CLASS.TrimEnd(), 
                                                                     "ManageCreate", 
                                                                      new object[] { 
                                                                                     mMANAGE_MAIN, 
                                                                                     listPLAN_LIST, 
                                                                                     listMANAGE_LIST,
                                                                                     true, 
                                                                                     this.cbControl.IsChecked 
                                                                                    }, 
                                                                     out strResult);

                        //判断结果
                        if (!boolResult)
                        {
                            break;
                        }
                        else
                        {
                            this.ucManagePosition.U_Update();
                            this.ucStorageGroup.U_Update();
                            this.gridPlanList.U_Update();
                        }
                    }

                    MainApp._MessageDialog.Show(boolResult, strResult);
                }
            }
            catch (Exception ex)
            {
                MainApp._MessageDialog.ShowException(ex);
            }
        }

        /// <summary>
        /// 获得托盘集合列表
        /// </summary>
        /// <param name="listDataRowView"></param>
        /// <returns></returns>
        private IDictionary<string, Model.MANAGE_MAIN> GetPalletKeyValuePair(DataRowView[] listDataRowView)
        {
            IDictionary<string, Model.MANAGE_MAIN> dicStack = new Dictionary<string, Model.MANAGE_MAIN>();
            foreach (DataRowView rowView in listDataRowView)
            {
                string stack = rowView["STOCK_BARCODE"].ToString();
                if (!dicStack.ContainsKey(stack))
                {
                    Model.MANAGE_MAIN mMANAGE_MAIN = new Model.MANAGE_MAIN();

                    mMANAGE_MAIN.CELL_MODEL = rowView["CELL_MODEL"].ToString();

                    mMANAGE_MAIN.STOCK_BARCODE = rowView["STOCK_BARCODE"].ToString();

                    mMANAGE_MAIN.START_CELL_ID = Convert.ToInt32(rowView["CELL_ID"]);

                    dicStack.Add(stack, mMANAGE_MAIN);
                }
            }
            return dicStack;
        }

        private void Query()
        {
            DataRowView[] checkDataRowView = this.gridPlanList.U_GetCheckedDataRows();

            if (checkDataRowView.Length == 0)
            {
                MainApp._MessageDialog.Show(false,"请选中计划明细记录");
                return;
            }

            this.ucManagePosition.U_Refresh();
            this.InitManagePosotion(Convert.ToInt32(checkDataRowView[0].Row.ItemArray[5]));
            string sPLAN_LIST_ID = string.Empty;

            foreach (DataRowView drv in checkDataRowView)
            {
                sPLAN_LIST_ID += drv["PLAN_LIST_ID"].ToString() + ",";
            }

            sPLAN_LIST_ID = sPLAN_LIST_ID.TrimEnd(',');

            string GOODS_PROPERTY = string.Empty;

            IList<SiaSun.LMS.Model.GOODS_PROPERTY> lsGOODS_PROPERTY = MainApp._I_GoodsService.GoodsPropertyGetListGoodsTypeID(this.gridPlanList.U_GetSelectedGoodsTypeID());

            foreach (SiaSun.LMS.Model.GOODS_PROPERTY mGOODS_PROPERTY in lsGOODS_PROPERTY)
            {
                if( mGOODS_PROPERTY.GOODS_PROPERTY_KEYFLAG=="1")
                    GOODS_PROPERTY += string.Format(" AND ISNULL({0}.{1},ISNULL({2}.{1},'')) = ISNULL({2}.{1},'')", "PLAN_LIST", mGOODS_PROPERTY.GOODS_PROPERTY_FIELD, "V_STORAGE_LIST");
            }

            string sPLAN = " (SELECT count(0) FROM PLAN_LIST WHERE V_STORAGE_LIST.GOODS_ID= PLAN_LIST.GOODS_ID and isnull(V_STORAGE_LIST.GOODS_PROPERTY1,'')= PLAN_LIST.GOODS_PROPERTY1 {2} {0} AND PLAN_LIST_ID in ({1}))>0";

            this.StorageListBind(string.Format(sPLAN, GOODS_PROPERTY, sPLAN_LIST_ID, this.STORAGE_AREA_TYPE == string.Empty ? string.Empty: string.Format(" AND V_STORAGE_LIST.AREA_TYPE = '{0}' ",this.STORAGE_AREA_TYPE) ));
        }

        #endregion


    }
}