using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Linq;
using System.Text;
using System.Windows.Forms;
using WMS.Frm.Base;
using WMS.Common;
using WMS.Model.Base;
using WMS.Ctrl;
using System.Text.RegularExpressions;
using System.IO;
using DevExpress.XtraGrid.Views.Base;
using DevExpress.XtraGrid.Columns;
using DevExpress.XtraEditors.Repository;
using WMS.Model.SystemManage;
using WMS.Frm;
using NPOI.SS.UserModel;
using NPOI.HSSF.UserModel;
using System.Collections;
using System.Threading;
using DevExpress.XtraReports.UI;
using WMS.Business;
using WMS.Business.Base;
using WMS.Business.SystemManage;
using WMS.FrmPrint;
using WMS.Business.RK;
using DevExpress.DocumentServices.ServiceModel.DataContracts;


namespace WMS.FrmBaseData
{
    public partial class FrmPallet : FormBase
    {
        #region 全局变量声明
        /// <summary>
        /// 容器Model
        /// </summary>
        PalletModel model;
        /// <summary>
        /// 容器Model 集合(数据绑定)
        /// </summary>
        List<PalletModel> list;
        /// <summary>
        /// 容器Model集合(批量新增)
        /// </summary>
        List<PalletModel> sourceList;
        /// <summary>
        /// 容器管理Model
        /// </summary>
        FrmBaseCtlGoods baseCtlGoods;
        /// <summary>
        /// 复选框选中数据集合
        /// </summary>
        List<PalletModel> CheckList;
        /// <summary>
        /// 加一个int变量主要为了判断是否有checkbox选中项
        /// </summary>
        //int i = 0;

        /// <summary>
        /// 体积累加
        /// </summary>
        //decimal sumVolume;
        /// <summary>
        /// 表头全选判断
        /// </summary>
        bool m_status = false;
        /// <summary>
        /// 容器生成类型头文件拼音简称
        /// </summary>
        string PalletName = "";
        /// <summary>
        /// 标示符  0批量新增  1：修改
        /// </summary>
        int flag = 0;
        string path = string.Empty;
        private HSSFWorkbook _workbook;
        private ISheet _sheet;
        List<PalletModel> tabletolist;
        #endregion

        #region 构造函数
        /// <summary>
        /// 无参构造
        /// </summary>
        public FrmPallet()
        {
            InitializeComponent();
            ChangeControlState(false);
        }

        /// <summary>
        /// 有参构造
        /// </summary>
        /// <param name="frmParent"></param>
        public FrmPallet(FrmBaseCtlGoods frmParent)
        {
            InitializeComponent();
            baseCtlGoods = frmParent;
            //显示按钮
            this.btnSave.Visible = true;
        }
        #endregion

        #region 窗体加载
        /// <summary>
        /// 窗体加载
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        private void FrmPallet_Load(object sender, EventArgs e)
        {
            // WMS.Model.Base.PalletModel
            //通用查询 继承自 FormBase.cs 窗体
            FrmSelectModle = new PalletModel();
            BindPalletData();
            lkpPalletType.LoadData();
            //默认加载第一项
            this.txtStart.Text = null;
            this.txtEnd.Text = null;
            this.txtNum.Text = null;
            if (frmButtonItem.ContainsKey("Print")) { frmButtonItem["Print"].Enabled = true; }
            if (frmButtonItem.ContainsKey("Add")) { frmButtonItem["Add"].Enabled = true; }
            if (frmButtonItem.ContainsKey("Edit")) { frmButtonItem["Edit"].Enabled = true; }
            if (frmButtonItem.ContainsKey("Del")) { frmButtonItem["Del"].Enabled = true; }
            if (frmButtonItem.ContainsKey("Search")) { frmButtonItem["Search"].Enabled = true; }
            if (frmButtonItem.ContainsKey("Refresh")) { frmButtonItem["Refresh"].Enabled = true; }
            if (frmButtonItem.ContainsKey("Export")) { frmButtonItem["Export"].Enabled = true; }
            if (frmButtonItem.ContainsKey("Clear")) { frmButtonItem["Clear"].Enabled = false; }
            if (frmButtonItem.ContainsKey("Save")) { frmButtonItem["Save"].Enabled = false; }

        }
        #endregion

        #region 事件

        #region 没有查询到数据时，提示没有查询到符合条件的数据
        /// <summary>
        /// 未查询到数据时 的提示
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        private void gridViewPallet_CustomDrawEmptyForeground(object sender, DevExpress.XtraGrid.Views.Base.CustomDrawEventArgs e)
        {
            ColumnView columnView = sender as ColumnView;
            BindingSource bindingSource = this.gridViewPallet.DataSource as BindingSource;
            if (bindingSource.Count == 0)
            {
                string str = "<对不起,没有符合的数据!>";
                Font f = new Font("宋体", 11, FontStyle.Regular);
                Rectangle r = new Rectangle(e.Bounds.Top + 25, e.Bounds.Left + 25, e.Bounds.Right - 25, e.Bounds.Height - 25);
                e.Graphics.DrawString(str, f, Brushes.Gray, r);
            }
        }
        #endregion

        #region CheckBox全选的实现:3事件
        /// <summary>
        ///  Click 事件  调用DevControlHelper 帮助类
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        private void gridViewPallet_Click(object sender, EventArgs e)
        {
            //if (DevControlHelper.ClickGridCheckBox(this.gridViewPallet, "IsCheck", m_status))
            //{
            //    m_status = !m_status;
            //}
        }

        /// <summary>
        /// CustomDrawColumnHeader 事件
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>

        private void gridViewPallet_CustomDrawColumnHeader(object sender, DevExpress.XtraGrid.Views.Grid.ColumnHeaderCustomDrawEventArgs e)
        {
            //if (e.Column != null && e.Column.FieldName == "IsCheck")
            //{
            //    e.Info.InnerElements.Clear();
            //    e.Painter.DrawObject(e.Info);
            //    DevControlHelper.DrawCheckBox(e, m_status);
            //    e.Handled = true;
            //}
        }
        /// <summary>
        /// DataSourceChanged 事件
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        private void gridViewPallet_DataSourceChanged(object sender, EventArgs e)
        {
            //GridColumn column = this.gridViewPallet.Columns.ColumnByFieldName("IsCheck");
            //if (column != null)
            //{
            //    column.Width = 80;
            //    column.OptionsColumn.ShowCaption = m_status;
            //    column.ColumnEdit = new RepositoryItemCheckEdit();
            //}

        }


        #endregion

        #region decimal类型文本框 click事件
        //数量
        private void txtNum_Click(object sender, EventArgs e)
        {
            this.txtNum.SelectionStart = 0;
            this.txtNum.SelectAll();
        }
        //长
        private void txtPalletLong_Click(object sender, EventArgs e)
        {
            //光标起始位置
            this.txtPalletLong.SelectionStart = 0;
            //文本全选
            this.txtPalletLong.SelectAll();
        }
        //宽
        private void txtWidth_Click(object sender, EventArgs e)
        {
            this.txtWidth.SelectionStart = 0;
            this.txtWidth.SelectAll();
        }
        //高
        private void txtHeight_Click(object sender, EventArgs e)
        {
            this.txtHeight.SelectionStart = 0;
            this.txtHeight.SelectAll();
        }
        //承载重量
        private void txtBearweight_Click(object sender, EventArgs e)
        {
            this.txtBearweight.SelectionStart = 0;
            this.txtBearweight.SelectAll();
        }
        #endregion

        #region 界面隐藏按钮Click事件
        /// <summary>
        /// Click 事件 该按钮隐藏 当EnterNextControl属性 到该按钮后触发
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        private void btnSave_Click(object sender, EventArgs e)
        {
            if (frmButtonItem["Save"].Enabled == true)
            {
                Save();
            }
        }
        #endregion
        #endregion



        #region 辅助方法

        #region 公共菜单 按钮 方法
        /// <summary>
        /// 新增按钮
        /// </summary>
        public void Add()
        {
            flag = 0;
            if (frmButtonItem.ContainsKey("Save")) { frmButtonItem["Save"].Enabled = true; }
            if (frmButtonItem.ContainsKey("Edit")) { frmButtonItem["Edit"].Enabled = false; }
            if (frmButtonItem.ContainsKey("Clear")) { frmButtonItem["Clear"].Enabled = true; }
            ChangeControlState(true);

        }

        /// <summary>
        /// 更新编辑修改按钮
        /// </summary>
        public void Edit()
        {
            flag = 1;
            ChangeControlState(true);
            if (frmButtonItem.ContainsKey("Save")) { frmButtonItem["Save"].Enabled = true; }
            if (frmButtonItem.ContainsKey("Clear")) { frmButtonItem["Clear"].Enabled = true; }
            if (frmButtonItem.ContainsKey("Add")) { frmButtonItem["Add"].Enabled = false; }
            this.txtStart.Enabled = false;
            this.txtNum.Enabled = false;
            this.txtEnd.Enabled = false;


        }

        /// <summary>
        /// 删除按钮
        /// </summary>
        public void Del()
        {
            if (DialogResult.Yes == SystemCommon.ShowMessageBoxResult("确定要删除选中容器数据吗？"))
            {
                DelPallet();
            }
        }

        /// <summary>
        /// 查询按钮
        /// </summary>
        public void Search()
        {
            FrmSelect frm = new FrmSelect(this.FrmSelectModle);
            if (frm.ShowDialog() == System.Windows.Forms.DialogResult.OK)
            {
                this.LoadListData(frm.SelectData);
            }
        }

        /// <summary>
        /// 刷新按钮
        /// </summary>
        public void Refresh()
        {
            BindPalletData();
            lkpPalletType.LoadData();
            this.lkpPalletType.ItemIndex = 0;
            this.lkpPalletType.Focus();
            this.txtStart.Text = null;
            this.txtEnd.Text = null;
            this.txtNum.Text = null;

            //if (frmButtonItem.ContainsKey("Print")) { frmButtonItem["Print"].Enabled = false; }
            if (frmButtonItem.ContainsKey("Add")) { frmButtonItem["Add"].Enabled = true; }
            if (frmButtonItem.ContainsKey("Edit")) { frmButtonItem["Edit"].Enabled = true; }
            if (frmButtonItem.ContainsKey("Del")) { frmButtonItem["Del"].Enabled = true; }
            if (frmButtonItem.ContainsKey("Search")) { frmButtonItem["Search"].Enabled = true; }
            if (frmButtonItem.ContainsKey("Refresh")) { frmButtonItem["Refresh"].Enabled = true; }
            if (frmButtonItem.ContainsKey("Export")) { frmButtonItem["Export"].Enabled = true; }
            if (frmButtonItem.ContainsKey("Clear")) { frmButtonItem["Clear"].Enabled = false; }
            if (frmButtonItem.ContainsKey("Save")) { frmButtonItem["Save"].Enabled = false; }
        }

        /// <summary>
        /// 清空按钮
        /// </summary>
        public void Clear()
        {
            bgsCondition.DataSource = new PalletModel();
            if (flag == 0)
            {
                this.txtEnd.Text = string.Empty;
                this.txtNum.Text = string.Empty;
                this.cDictionaryUser.TextBoxFlag = string.Empty;
                this.cDictionaryUser.TextBoxValue = string.Empty;
            }
            else if (flag == 1)
            {
                this.txtStart.Text = string.Empty;
                this.txtEnd.Text = string.Empty;
                this.txtNum.Text = string.Empty;
                this.cDictionaryUser.TextBoxFlag = string.Empty;
                this.cDictionaryUser.TextBoxValue = string.Empty;
            }
        }
        /// <summary>
        /// 数据导出到Excel
        /// </summary>
        public void Export()
        {
            DataToExcel();
        }

        /// <summary>
        /// 打印按钮
        /// </summary>
        public void Print()
        {

            if (gridViewPallet.GetSelectedRows().Length == 0)
            {
                SystemCommon.ShowInfoMessageBox("选择要打印的数据");
                return;
            }
            LoadForm load = new LoadForm();
            DevExpress.XtraSplashScreen.SplashScreenManager.ShowForm(load, load.GetType(), false, true, false, 0);
            DevExpress.XtraSplashScreen.SplashScreenManager.Default.SetWaitFormDescription("正在打印条码请稍候....");
            List<PalletModel> pritModel = new List<PalletModel>();
            int[] selct = gridViewPallet.GetSelectedRows();
            for (int i = 0; i < selct.Length; i++)
            {
                int idx = selct[i];
                string printId = gridViewPallet.GetRowCellValue(idx, "PALLET_ID").ToString();
                //  PalletModel print = gridViewPallet.GetDataRow(i) as PalletModel;

                if (!string.IsNullOrEmpty(printId))
                {
                    //BarCodeReport br = new BarCodeReport();
                    //br.GetInstance(printId, 10);

                    BarCodeReport br2 = new BarCodeReport();
                    br2.GetInstance(printId, 10);

                    IBussFactory<BussCodeDisk>.Instance().UpdateCtl(printId);
                }
            }
            DevExpress.XtraSplashScreen.SplashScreenManager.CloseForm();
        }

        /// <summary>
        /// 保存
        /// </summary>
        public void Save()
        {
            OperotePallet();
        }



        /// <summary>
        /// 导入
        /// </summary>
        public void Import()
        {

            OpenFileDialog fileDialog = new OpenFileDialog();
            fileDialog.Title = "导入容器资料";
            fileDialog.Filter = "Excel文件(*.xls;*.xlsx)|*.xls;*.xlsx";
            DialogResult dialogResult = fileDialog.ShowDialog(this);
            if (dialogResult == DialogResult.OK)
            {

                Hashtable ht = new Hashtable();
                ht.Add("PALLET_ID", "容器编号");
                ht.Add("PALLET_NAME", "容器名称");
                ht.Add("PALLET_TYPE", "容器型号");
                ht.Add("PALLET_LONG", "长");
                ht.Add("PALLET_WIDTH", "宽");
                ht.Add("PALLET_HEIGHT", "高");
                ht.Add("VOLUME", "容积");
                ht.Add("BEARWEIGHT", "承载重量");
                ht.Add("STATUS", "状态");
                ht.Add("USER_ID", "占用人");
                ht.Add("OPERATORID", "操作人");
                ht.Add("OPERATEDATE", "操作日期");
                ht.Add("REMARK", "备注");
                List<PalletModel> addList = NPOIHelper<PalletModel>.Import(fileDialog, ht);

                //将addList存入数据库
                if (addList != null && addList.Count > 0)
                {
                    string errText = string.Empty;

                    try
                    {
                        errText = IBussFactory<BussPallet>.Instance().OperatePallet(addList, 0);
                        if (string.IsNullOrEmpty(errText))
                        {
                            Refresh();
                        }
                        else
                        {
                            SystemCommon.ShowErrorMessageBox("导入失败:" + errText);
                        }
                    }
                    catch (Exception ex)
                    {
                        SystemCommon.ShowErrorMessageBox("未知错误，请检查网络连接！如仍无法解决问题请联系我们！ " + ex);
                    }

                }

            }
        }

        #region  导入Excel 数据
        /// <summary>
        /// 导入Excel 到数据
        /// </summary>
        public void Audit()
        {
            if (openFileDialog1.ShowDialog() == System.Windows.Forms.DialogResult.OK)
            {
                path = openFileDialog1.FileName;
                ReadExecl(path);
            }
            tabletolist = ConvertHelper<PalletModel>.ConvertToList(table);
            bgsPallet.DataSource = tabletolist;
            this.gridViewPallet.RefreshData();
        }
        DataTable table = new DataTable();
        private DataTable ReadExecl(string path)
        {

            try
            {
                using (FileStream stream = new FileStream(path, FileMode.Open, FileAccess.Read))
                {

                    //HSSFWorkbook:是操作Excel2003以前（包括2003）的版本，扩展名是.xls 
                    //XSSFWorkbook:是操作Excel2007的版本，扩展名是.xlsx
                    _workbook = new HSSFWorkbook(stream);
                    //_xworkbookl = new XSSFWorkbook(stream);
                    _sheet = _workbook.GetSheetAt(0);
                    IRow headerRow = _sheet.GetRow(0);//第一行为标题行
                    int cellCount = headerRow.LastCellNum;//LastCellNum = PhysicalNumberOfCells
                    int rowCount = _sheet.LastRowNum;//LastRowNum = PhysicalNumberOfRows - 1
                    for (int i = headerRow.FirstCellNum; i < cellCount; i++)
                    {
                        DataColumn column = new DataColumn(headerRow.GetCell(i).StringCellValue);
                        table.Columns.Add(column);
                    }
                    for (int i = (_sheet.FirstRowNum + 1); i <= rowCount; i++)
                    {
                        IRow row = _sheet.GetRow(i);
                        DataRow dataRow = table.NewRow();
                        if (row != null)
                        {
                            for (int j = row.FirstCellNum; j < cellCount; j++)
                            {
                                if (row.GetCell(j) != null)
                                {
                                    dataRow[j] = row.GetCell(j).ToString();
                                }
                            }
                        }
                        table.Rows.Add(dataRow);
                    }
                    return table;
                }
            }
            catch (Exception e)
            {
                SystemCommon.ShowErrorMessageBox("读取EXCEL失败!" + e.Message);
                return table;
            }
        }
        #endregion

        #endregion


        #region 通用查询方法
        /// <summary>
        /// 通用查询 方法
        /// </summary>
        /// <param name="table"></param>
        public override void LoadListData(DataTable table)
        {
            list = ConvertHelper<PalletModel>.ConvertToList(table);
            bgsPallet.DataSource = list;
            gridViewPallet.RefreshData();

        }
        #endregion



        private void BindPalletData2()
        {
            DataTable dt = IBussFactory<BussPallet>.Instance().GetCtl(0);
            if (dt != null)
            {
                gridControlCustomPallet.DataSource = dt;
            }


        }
        #region 数据绑定
        /// <summary>
        ///  绑定容器数据
        /// </summary>
        private void BindPalletData()
        {
            string datetime = System.DateTime.Now.ToString("yyyyMMdd");

            DataTable dt = IBussFactory<BussPallet>.Instance().GetCtl(int.Parse(datetime));
            if (dt != null)
            {
                if (dt.Rows.Count > 0)
                {
                    gridControlCustomPallet.DataSource = dt;
                }
                else
                {
                    int seqid = 1;
                    string BarCode = "323" + datetime + seqid.ToString("0000");
                    IBussFactory<BussPallet>.Instance().Insert_T_BASE_PALLET(323, int.Parse(datetime), seqid, BarCode);
                    BindPalletData2();
                }
            }
            


            //ShowSplashForm("数据加载中");
            //model = new PalletModel();
            //model.STATUS = "0";
            //new Thread(delegate ()
            //{
            //    try
            //    {
            //        this.Invoke(new MethodInvoker(delegate
            //        {




            //            //list = IBussFactory<BussPallet>.Instance().GetPalletList(model);
            //            //if (list.Count != 0)
            //            //{
            //            //    bgsPallet.DataSource = list;
            //            //}
            //            //bgsPallet.DataSource = list;
            //            //this.gridViewPallet.RefreshData();
            //            //CloseSplashForm();

            //        }));
            //    }
            //    catch (Exception ex)
            //    {
            //        SystemCommon.ShowErrorMessageBox("GetPalletList出错了:" + ex.Message);
            //    }

            //}).Start();

        }

        private static void ShowSplashForm(string msg)
        {
            try
            {
                LoadForm load = new LoadForm();
                DevExpress.XtraSplashScreen.SplashScreenManager.ShowForm(load, load.GetType(), false, true, false, 70);
                DevExpress.XtraSplashScreen.SplashScreenManager.Default.SetWaitFormDescription(msg);
            }
            catch (Exception ex)
            {

            }
        }

        private static void CloseSplashForm()
        {
            try
            {
                DevExpress.XtraSplashScreen.SplashScreenManager.CloseForm();
            }
            catch (Exception ex)
            {
            }
        }
        #endregion

        #region 删除
        /// <summary>
        /// 删除容器数据
        /// </summary>
        private void DelPallet()
        {

            List<PalletModel> dellist = new List<PalletModel>();
            int[] selectRows = this.gridViewPallet.GetSelectedRows();
            this.lblType.Focus();
            foreach (int j in selectRows)
            {
                model = new PalletModel();
                model = this.gridViewPallet.GetRow(j) as PalletModel;
                dellist.Add(model);
            }
            if (dellist.Count == 0)
            {
                SystemCommon.ShowInfoMessageBox("请先选择要删除的数据！");
                return;
            }
            try
            {
                string errText = IBussFactory<BussPallet>.Instance().PalletDel(dellist);
                if (errText == "")
                {
                    SystemCommon.ShowInfoMessageBox("删除成功！");
                }
                else
                {
                    SystemCommon.ShowInfoMessageBox("删除失败！");
                }
            }
            catch (Exception ex)
            {
                SystemCommon.ShowErrorMessageBox("网络连接错误！请检查当前网络环境是否可用！");
            }
            BindPalletData();

            if (list != null)
            {
                if (list.FindAll(r => r.PALLET_TYPE == this.lkpPalletType.EditValue.ToString()).Count() == 0)
                {
                    model = new PalletModel();
                    model.PALLET_TYPE = this.lkpPalletType.EditValue.ToString();
                    bgsCondition.DataSource = model;
                    bgsPallet.DataSource = null;
                }
                else
                {
                    bgsPallet.DataSource = list.FindAll(r => r.PALLET_TYPE == this.lkpPalletType.EditValue.ToString());
                }
            }
        }
        #endregion

        #region 更新保存
        /// <summary>
        /// 更新容器数据
        /// </summary>
        /// <param name="flag">1：修改</param>
        private void FrmOperator(int flag)
        {
            try
            {
                string errtex = IBussFactory<BussPallet>.Instance().OperatePalletList(CheckList, flag);
                if (!string.IsNullOrEmpty(errtex))
                {
                    SystemCommon.ShowInfoMessageBox("操作失败！");
                }
                else
                {
                    SystemCommon.ShowInfoMessageBox("操作成功！");
                }
            }
            catch (Exception ex)
            {
                SystemCommon.ShowErrorMessageBox("网络连接错误！请检查当前网络环境是否可用！");
            }
            BindPalletData();
            if (list != null)
            {
                bgsPallet.DataSource = list.FindAll(r => r.PALLET_TYPE == this.lkpPalletType.EditValue.ToString());
            }
        }
        #endregion

        #region 导出数据到Excel文件方法
        /// <summary>
        /// 导出数据到Excel
        /// </summary>
        private void DataToExcel()
        {
            SaveFileDialog fileDialog = new SaveFileDialog();
            fileDialog.Title = "导出Excel";
            fileDialog.Filter = "Excel文件(*.xls)|*.xls";
            DialogResult dialogResult = fileDialog.ShowDialog(this);
            if (dialogResult == DialogResult.OK)
            {
                DevExpress.XtraPrinting.XlsExportOptions options = new DevExpress.XtraPrinting.XlsExportOptions();
                gridControlCustomPallet.ExportToXls(fileDialog.FileName);
                DevExpress.XtraEditors.XtraMessageBox.Show("保存成功！", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information);
            }
        }

        #endregion

        private void ExcelToGridView()
        {
            OpenFileDialog openDialog = new OpenFileDialog();
            openDialog.Title = "导入Excel";
            openDialog.Filter = "Excel文件(*.xls)|*.xls";
            DialogResult dialogResult = openDialog.ShowDialog(this);
            // NPOI.HSSF.UserModel.HSSFWorkbook.Create().
        }




        #region 打印方法
        /// <summary>
        /// 打印方法
        /// </summary>
        private void DataPrint()
        {
            //BarCodeReport BR = new BarCodeReport();
            


            //打印方法 暂无
            SystemCommon.ShowInfoMessageBox("打印功能暂无！");

        }

        #endregion

        #region 批量新增容器资料
        #region 批量新增
        /// <summary>
        /// 批量新增
        /// </summary>
        /// <param name="flag"></param>
        private void CreateMore(int flag)
        {
            string str = "";
            sourceList = new List<PalletModel>();
            int row = Convert.ToInt32(this.txtNum.Text.Trim());
            int star = Convert.ToInt32(this.txtStart.Text.Trim());
            if (row >= 1)
            {
                for (int i = star; i < row + star; i++)
                {
                    str = PalletName + i.ToString().PadLeft(txtStart.Text.Length, '0');
                    str = PalletNumberCount(str);

                }
            }
            else
            {
                SystemCommon.ShowInfoMessageBox("请您输入正确数量！");
            }
            try
            {

                string errtex = IBussFactory<BussPallet>.Instance().OperatePallet(sourceList, flag);
                if (!string.IsNullOrEmpty(errtex))
                {
                    SystemCommon.ShowInfoMessageBox("操作失败！" + errtex);
                }
                else
                {
                    SystemCommon.ShowInfoMessageBox("操作成功！");
                    if (frmButtonItem.ContainsKey("Save")) { frmButtonItem["Save"].Enabled = false; }
                }
            }
            catch (Exception ex)
            {
                SystemCommon.ShowErrorMessageBox("出错了BussPallet.OperatePallet:" + ex.Message);
            }
            BindPalletData();
            if (list != null)
            {
                bgsPallet.DataSource = list.FindAll(r => r.PALLET_TYPE == this.lkpPalletType.EditValue.ToString());
            }
        }
        #endregion

        #region 根据 传入参数判断生成数据格式
        /// <summary>
        /// 获得批量新增集合 容器ID 递增
        /// </summary>
        /// <param name="str">参数 ：用于判断生成的格式</param>
        /// <returns></returns>
        private string PalletNumberCount(string str)
        {
            model = new PalletModel();
            model.PALLET_ID = str;
            model.PALLET_NAME = "";
            model.PALLET_TYPE = this.lkpPalletType.EditValue.ToString();
            model.PALLET_LONG = Convert.ToDecimal(this.txtPalletLong.Text);
            model.PALLET_WIDTH = Convert.ToDecimal(this.txtWidth.Text);
            model.PALLET_HEIGHT = Convert.ToDecimal(this.txtHeight.Text);
            model.VOLUME = Convert.ToDecimal(Convert.ToDecimal(this.txtPalletLong.Text) * Convert.ToDecimal(this.txtWidth.Text) * Convert.ToDecimal(this.txtHeight.Text));
            model.BEARWEIGHT = Convert.ToDecimal(this.txtBearweight.Text);
            model.STATUS = this.rdoPalletStatus.EditValue.ToString();
            model.USER_ID = this.cDictionaryUser.TextBoxFlag;
            model.NAME = this.cDictionaryUser.TextBoxValue;
            model.OPERATORID = userData.USER_ID;
            model.OPERATEDATE = DateTime.Now;
            model.REMARK = this.txtRemark.Text;
            sourceList.Add(model);
            str = string.Empty;
            return str;
        }
        #endregion
        #endregion

        #region 新增 修改保存方法
        /// <summary>
        /// 新增 修改 保存方法
        /// </summary>
        private void OperotePallet()
        {
            if (flag == 0)
            {
                bgsCondition.EndEdit();
                if (frmButtonItem["Save"].Enabled == true)
                {
                    if (DialogResult.OK == SystemCommon.ShowMessageBoxResult("确定要批量生成该类容器？"))
                    {
                        CreateMore(flag);
                    }
                }
                this.txtStart.Text = string.Empty;
                this.txtEnd.Text = string.Empty;
                this.txtNum.Text = string.Empty;
                if (frmButtonItem.ContainsKey("Edit")) { frmButtonItem["Edit"].Enabled = true; }
                // frmButtonItem["Create"].Enabled = false;
                if (frmButtonItem.ContainsKey("Clear")) { frmButtonItem["Clear"].Enabled = false; }
                ChangeControlState(false);
            }
            else if (flag == 1)
            {
                CheckList = new List<PalletModel>();
                bgsCondition.EndEdit();
                foreach (PalletModel pal in list.FindAll(r => r.PALLET_TYPE == this.lkpPalletType.EditValue.ToString()))
                {
                    pal.PALLET_TYPE = this.lkpPalletType.EditValue.ToString();
                    pal.PALLET_LONG = Convert.ToDecimal(this.txtPalletLong.Text);
                    pal.PALLET_WIDTH = Convert.ToDecimal(this.txtWidth.Text);
                    pal.PALLET_HEIGHT = Convert.ToDecimal(this.txtHeight.Text);
                    pal.BEARWEIGHT = Convert.ToDecimal(this.txtBearweight.Text);
                    pal.USER_ID = this.cDictionaryUser.TextBoxFlag;
                    pal.STATUS = this.rdoPalletStatus.EditValue.ToString();
                    pal.REMARK = this.txtRemark.Text;
                    pal.OPERATORID = userData.USER_ID;
                    pal.OPERATEDATE = DateTime.Now;
                    pal.VOLUME = Convert.ToDecimal(this.txtPalletLong.Text.Trim()) * Convert.ToDecimal(this.txtWidth.Text.Trim()) * Convert.ToDecimal(this.txtHeight.Text.Trim());
                    CheckList.Add(pal);
                }
                if (CheckList == null)
                {
                    return;
                }

                if (DialogResult.Yes == SystemCommon.ShowMessageBoxResult("该操作会将该类别下所有容器更改为相同的规格。" + Environment.NewLine + "是否更改？"))
                {
                    FrmOperator(flag);
                }
                frmButtonItem["Save"].Enabled = false;
                if (frmButtonItem.ContainsKey("Add")) { frmButtonItem["Add"].Enabled = true; }
                ChangeControlState(false);
            }
        }
        #endregion


        #region 交互不可用
        /// <summary>
        /// 交互不可用
        /// </summary>
        private void ChangeControlState(bool r)
        {
            this.txtStart.Enabled = r;
            this.txtNum.Enabled = r;
            this.txtEnd.Enabled = r;
            this.txtPalletLong.Enabled = r;
            this.txtWidth.Enabled = r;
            this.txtHeight.Enabled = r;
            this.txtBearweight.Enabled = r;
            this.cDictionaryUser.Enabled = r;
            this.rdoPalletStatus.Enabled = r;
            this.txtRemark.Enabled = r;
        }
        #endregion


        #endregion

        private void txtStart_KeyPress(object sender, KeyPressEventArgs e)
        {
            if (!(e.KeyChar >= '0' && e.KeyChar <= '9')) e.Handled = true;

            if (e.KeyChar == '\b') e.Handled = false;
        }

        private void txtEnd_KeyPress(object sender, KeyPressEventArgs e)
        {
            if (!(e.KeyChar >= '0' && e.KeyChar <= '9')) e.Handled = true;

            if (e.KeyChar == '\b') e.Handled = false;
        }
        private void txtNum_KeyPress(object sender, KeyPressEventArgs e)
        {
            if (!(e.KeyChar >= '0' && e.KeyChar <= '9')) e.Handled = true;

            if (e.KeyChar == '\b') e.Handled = false;
        }

        /// <summary>
        /// txtEnd_TextChanged 事件
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        private void txtEnd_TextChanged(object sender, EventArgs e)
        {
            if (!string.IsNullOrEmpty(txtStart.Text) && !string.IsNullOrEmpty(txtEnd.Text))
            {
                int star = Convert.ToInt32(txtStart.Text);
                int end = Convert.ToInt32(txtEnd.Text);
                txtNum.Text = (end - star + 1).ToString();
            }

        }
        /// <summary>
        /// txtStart_TextChanged 事件
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        private void txtStart_TextChanged(object sender, EventArgs e)
        {
            if (!string.IsNullOrEmpty(txtEnd.Text) && !string.IsNullOrEmpty(txtStart.Text))
            {
                int star = Convert.ToInt32(txtStart.Text);
                int end = Convert.ToInt32(txtEnd.Text);
                txtNum.Text = (end - star + 1).ToString();
            }
        }

        /// <summary>
        /// lookUpedit EditValueChanged事件
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        private void lkpPalletType_EditValueChanged(object sender, EventArgs e)
        {
            switch (flag)
            {
                case 0:
                    model = new PalletModel();
                    model.PALLET_TYPE = this.lkpPalletType.EditValue.ToString();
                    bgsCondition.DataSource = model;
                    break;
                case 1:
                    break;
                default:
                    break;
            }
            if (list.Count != 0)
            {
                List<PalletModel> plis = list.FindAll(f => f.PALLET_TYPE == this.lkpPalletType.EditValue.ToString());
                if (!string.IsNullOrEmpty(this.lkpPalletType.EditValue.ToString()) && plis.Count != 0)
                {
                    //字符串 截取数字 部分
                    //if (frmButtonItem["Create"].Enabled == true)
                    if (flag == 0)
                    {
                        int aa = Convert.ToInt32(Regex.Match(plis.Max(a => a.PALLET_ID), "\\d+").Value.ToString());
                        this.txtStart.Text = (aa + 1).ToString();
                        this.txtStart.Enabled = false;
                        GetPalletHeadLetter();
                    }
                    //if (frmButtonItem["Save"].Enabled == true)
                    if (flag == 1)
                    {
                        txtStart.Text = Regex.Match(plis.Min(a => a.PALLET_ID), "\\d+").ToString();
                        txtEnd.Text = Regex.Match(plis.Max(b => b.PALLET_ID), "\\d+").ToString();
                    }
                    bgsCondition.DataSource = plis[0];
                    bgsCondition.EndEdit();
                    this.cDictionaryUser.TextBoxFlag = plis[0].USER_ID;
                    this.cDictionaryUser.TextBoxValue = plis[0].NAME;
                }
                return;
            }
            if(list.Count>0)
            {
                bgsPallet.DataSource = list.FindAll(r => r.PALLET_TYPE == this.lkpPalletType.EditValue.ToString());
                if (!string.IsNullOrEmpty(this.lkpPalletType.EditValue.ToString()) && this.gridViewPallet.RowCount == 0)
                {
                    model = new PalletModel();
                    model.PALLET_TYPE = this.lkpPalletType.EditValue.ToString();
                    bgsCondition.DataSource = model;
                }
                this.gridViewPallet.FocusedRowHandle = 0;

                gridControlCustomPallet_Click(null, null);
            }

         
        }


        /// <summary>
        /// 获得批量新增容器的头文件
        /// </summary>
        private void GetPalletHeadLetter()
        {
            string error = string.Empty;

            List<DictionaryTabModel> lsit = IBussFactory<BussDictionaryTab>.Instance().GetDictionaryTab("pallet_type");
            foreach (DictionaryTabModel model in lsit)
            {
                if (model.VC_DICTIONARY_ID == this.lkpPalletType.EditValue.ToString())
                {
                    PalletName = model.VC_PINYIN_CODE;
                }
            }
        }


        /// <summary>
        /// click 事件 显示明细容器 具体参数
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        private void gridControlCustomPallet_Click(object sender, EventArgs e)
        {
            //if (frmButtonItem.ContainsKey("Print")) { frmButtonItem["Print"].Enabled = false; }
            if (frmButtonItem.ContainsKey("Add")) { frmButtonItem["Add"].Enabled = true; }
            if (frmButtonItem.ContainsKey("Edit")) { frmButtonItem["Edit"].Enabled = true; }
            if (frmButtonItem.ContainsKey("Del")) { frmButtonItem["Del"].Enabled = true; }
            if (frmButtonItem.ContainsKey("Search")) { frmButtonItem["Search"].Enabled = true; }
            if (frmButtonItem.ContainsKey("Refresh")) { frmButtonItem["Refresh"].Enabled = true; }
            if (frmButtonItem.ContainsKey("Export")) { frmButtonItem["Export"].Enabled = true; }
            if (frmButtonItem.ContainsKey("Clear")) { frmButtonItem["Clear"].Enabled = false; }
            //if (frmButtonItem.ContainsKey("Create")) { frmButtonItem["Create"].Enabled = false; }
            if (frmButtonItem.ContainsKey("Save")) { frmButtonItem["Save"].Enabled = false; }
            ChangeControlState(false);
            model = this.gridViewPallet.GetRow(this.gridViewPallet.FocusedRowHandle) as PalletModel;
            if (model != null)
            {
                bgsCondition.DataSource = model;
                this.cDictionaryUser.TextBoxFlag = model.USER_ID;
                this.cDictionaryUser.TextBoxValue = model.NAME;
                this.txtStart.Text = string.Empty;
            }

        }

        /// <summary>
        /// 结束编号Leave事件 验证结束编号不小于起始编号
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        private void txtEnd_Leave(object sender, EventArgs e)
        {
            if (!string.IsNullOrEmpty(txtStart.Text) && !string.IsNullOrEmpty(txtEnd.Text))
            {
                int star = Convert.ToInt32(txtStart.Text);
                int end = Convert.ToInt32(txtEnd.Text);
                if (end < star)
                {
                    SystemCommon.ShowInfoMessageBox("结束编号不能小于起始编号！");
                    this.txtEnd.Focus();
                    return;
                }
            }
        }


        /// <summary>
        /// 长宽高Leave事件 带出体积Volume
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        private void GetVolume_Leave(object sender, EventArgs e)
        {

            this.labelControl1.Focus();
            if (Convert.ToDecimal(this.txtPalletLong.Text) != 0 && Convert.ToDecimal(this.txtWidth.Text) != 0 && Convert.ToDecimal(this.txtHeight.Text) != 0)
            {
                txtVolume.Text = (Convert.ToDecimal(txtPalletLong.Text) * Convert.ToDecimal(txtWidth.Text) * Convert.ToDecimal(txtHeight.Text)).ToString("F4");
                bgsCondition.EndEdit();
                bgsCondition.ResetBindings(true);
            }
        }

        private void gridViewPallet_FocusedRowChanged(object sender, FocusedRowChangedEventArgs e)
        {
            //if (e.FocusedRowHandle > -1)
            //{
            //    gridControlCustomPallet_Click(null, null);
            //    //bgsCondition.DataSource = this.gridViewPallet.GetRow(e.FocusedRowHandle);
            //}
        }

        private void btnAccept_Click(object sender, EventArgs e)
        {
            if (txtCtl.Text == "")
            {
                BarCodeReport br2 = new BarCodeReport();
                br2.GetInstance(txtCtl.Text, 10);
            }
        }

        private void gridViewPallet_RowClick(object sender, DevExpress.XtraGrid.Views.Grid.RowClickEventArgs e)
        {
            if (gridViewPallet.RowCount == 0)
            {
                return;
            }
            if (gridViewPallet.FocusedRowHandle < 0)
            {
                return;
            }
            string STORAGE_ID = gridViewPallet.GetFocusedRowCellValue("STORAGE_ID").ToString();
            string BARCODETIME = gridViewPallet.GetFocusedRowCellValue("BARCODETIME").ToString();
            string SEQID  = gridViewPallet.GetFocusedRowCellValue("SEQID").ToString();


            txtCtl.Text = gridViewPallet.GetFocusedRowCellValue("BARCODE").ToString();

        }

        private void ctrlButtons1_Click(object sender, EventArgs e)
        {
            string datetime = System.DateTime.Now.ToString("yyyyMMdd");
            DataTable dt = IBussFactory<BussPallet>.Instance().GetCtl2(int.Parse(datetime));
            if (dt != null)
            {
                if (dt.Rows.Count > 0)
                { 
                    int seqid= int.Parse(dt.Rows[0][0].ToString())+1;
                    
                    string BarCode = "323" + datetime + seqid.ToString("0000");

                    BarCodeReport br2 = new BarCodeReport();
                    br2.GetInstance(BarCode, 10);
                    IBussFactory<BussPallet>.Instance().Insert_T_BASE_PALLET(323, int.Parse(datetime), seqid, BarCode);

                    //
                }
            }
        }
    }
}