/*===================================================================
 *   程序说明: WOMDAA的数据管理窗体
 *   作者资料: 孙中吕
 *   创建日期: 2024/05/20 05:58:20
 *   最后修改: 2024/05/20 05:58:20
 *
 *   注: 本文件由代码生成器(Code Generator)自动生成。
 *   版权所有 Copyright 2006~2024, C/S框架网(www.cscode.net)
 *===================================================================*/

using CSFramework.DB;
using CSFrameworkV5.Business;
using CSFrameworkV5.Common;
using CSFrameworkV5.Core;
using CSFrameworkV5.Interfaces;
using CSFrameworkV5.Library;
using CSFrameworkV5.Library.CommonClass;
using CSFrameworkV5.Models;
using CSFrameworkV5.Order.womdaa;
using DevExpress.XtraEditors;
using DevExpress.XtraEditors.Controls;
using DevExpress.XtraGrid;
using DevExpress.XtraGrid.Views.Base;
using DevExpress.XtraGrid.Views.Grid;
using NPOI.HSSF.UserModel;
using NPOI.SS.UserModel;
using NPOI.XSSF.UserModel;
using SqlSugar;
using System;
using System.Collections.Generic;
using System.Data;
using System.Drawing;
using System.IO;
using System.Linq;
using System.Windows.Forms;
using CSFrameworkV5.Language;

namespace CSFrameworkV5.Order
{
    ///<summary>
    /// WOMDAA的资料管理窗体，由代码生成器(Code Generator)自动生成
    /// </summary>
    public partial class frmOrder : frmBaseBusinessForm
    {
        private bllWOMDAA _BLLInstance; //业务逻辑层对象引用

        public frmOrder()
        {
            InitializeComponent();


            _BLLInstance = new bllWOMDAA();

            var sqlstr =
                "select LINE_NO 产线编码,LINE_NAME 产线名称,DeptName 车间名称,MEMO 备注 from MES_LINE";
            txtDAA042.Properties.ValueMember = "产线名称";
            txtDAA042.Properties.DisplayMember = "产线名称";
            txtDAA042.Properties.ShowClearButton = false;
            txtDAA042.Properties.DataSource = _BLLInstance.GETDAT(sqlstr);

            //长日期显示模式
            this.txtDAA020.Properties.VistaEditTime = DevExpress.Utils.DefaultBoolean.True;

            //显示当前时间
            this.txtDAA020.EditValue = DateTime.Now;

            //长日期显示模式
            this.txtDAA021.Properties.VistaEditTime = DevExpress.Utils.DefaultBoolean.True;

            //显示当前时间
            this.txtDAA021.EditValue = DateTime.Now;
        }

        private void frmOrder_Load(object sender, EventArgs e)
        {
            InitializeForm(); //自定义初始化操作

            Init();

            //筛选框
            gvSummary.OptionsView.ShowGroupPanel = false;
            gvSummary.OptionsView.ShowAutoFilterRow = true;

            if (splitContainerEditorAndDetailGrid != null &&
                layoutGroup.OptionsTableLayoutGroup.RowDefinitions.Count !=
                0)
                splitContainerEditorAndDetailGrid.SplitterPosition =
                    Convert.ToInt32(Math.Round(
                        layoutGroup.OptionsTableLayoutGroup.RowDefinitions
                            .Count *
                        layoutGroup.OptionsTableLayoutGroup
                            .RowDefinitions[0].Height, 0)) + 30;

            if (splitContainerSearchAndSummary != null && layoutGroupSearch
                    .OptionsTableLayoutGroup.RowDefinitions
                    .Count != 0)
                splitContainerSearchAndSummary.SplitterPosition =
                    Convert.ToInt32(Math.Round(
                        (layoutGroupSearch.OptionsTableLayoutGroup
                            .RowDefinitions.Count - 1) *
                        layoutGroupSearch.OptionsTableLayoutGroup
                            .RowDefinitions[0].Height, 0)) + 60;
        }

        private void Init()
        {
            var sql =
                "select * from WOMDAA order by DAA001 desc offset 0 rows fetch next 100 rows only";

            var dt = _BLLInstance.GETDAT(sql);
            DoBindingSummaryGrid(dt); //绑定主表的Grid
            ShowSummaryPage(true); //显示Summary页面.
        }

        protected override void InitializeForm()
        {
            _BLL = new bllWOMDAA(); //实例化基类的业务逻辑层
            _BLLInstance = _BLL as bllWOMDAA; //当前窗体的业务层逻辑层对象引用

            _SummaryView =
                new DevGridView(
                    gvSummary); //实例化数据视图，此接口可支持不同的视图，比如表格GridControl,树视图TreeList.
//_ActiveEditor = txtid;//进入修改状态，显示第一个焦点的输入框，可以不设置
//_KeyEditor = txtid;//主键字段输入框，可以不设置
            _DetailGroupControl = pcDetailEditor; //【资料编辑】页面所有文本输入框的容器

            base.InitializeForm();
            picNote.Image = Globals.LoadImage("32_Notes.png");

            frmGridCustomize.RegisterGrid(gvSummary); //注册表格组件，自动添加样式管理、弹出菜单
            DevStyle.SetGridControlLayout(gcSummary, false); //主表表格样式设置
            DevStyle.SetSummaryGridViewLayout(gvSummary); //主表表格样式设置
            BindingSummaryNavigator(controlNavigatorSummary,
                gcSummary); //绑定表格导航按钮的数据源.
            gvSummary.DoubleClick +=
                new EventHandler(OnGridViewDoubleClick); //绑定主表的DoubleClick事件

            DevStyle.SetGridControlLayout(gcDetail0, true); //明细表表格样式设置
            DevStyle.SetDetailGridViewLayout(gvDetail0); //明细表表格样式设置
            gcDetail0.EmbeddedNavigator.ButtonClick +=
                new NavigatorButtonClickEventHandler(
                    OnEmbeddedNavigatorButtonClick); //绑定明细表格的按钮事件
            gvDetail0.CellValueChanged +=
                new CellValueChangedEventHandler(
                    OnCellValueChanged); //绑定明细表格单元格数据修改时触发的事件

            #region 以下代码全自动生成，请调整排版和顺序

            #endregion

            ShowSummaryPage(true); //初始化完成后显示表格页    
        }


//修改单元格数据时触发的事件
        private void OnCellValueChanged(object sender,
            CellValueChangedEventArgs e)
        {
//开发实例：修改单元格关联更新其它列的值
//参考(frmPO/frmSO).OnCellValueChanged方法}
        }

        /// <summary>
        /// 明细表格按钮事件
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        private void OnEmbeddedNavigatorButtonClick(object sender,
            NavigatorButtonClickEventArgs e)
        {
            try
            {
                var gc =
                    (GridControl)((GridControlNavigator)sender).Parent;
                var
                    gridView =
                        (GridView)gc.Views[0]; //每个GridControl默认有一个GridView.
                if (e.Button.ImageIndex == DetailButtons.Add ||
                    e.Button.ImageIndex == DetailButtons.Insert)
                    CreateOneDetail(gridView, e.Button.ImageIndex);
                else if (e.Button ==
                         gc.EmbeddedNavigator.Buttons.CustomButtons[
                             DetailButtons.Delete])
                    if (Msg.AskQuestion("确定要删除这条记录?"))
                        gridView.DeleteRow(gridView.FocusedRowHandle);

                e.Handled = true;
            }
            catch (Exception ex)
            {
                LogUserOperate.Write(ex);
                Msg.ShowException(ex);
            }
        }

        /// <summary>
        /// 重要！！当按钮状态改变时触发的事件，
        /// </summary>
        /// <param name="currentState"></param>
        protected override void ButtonStateChanged(UpdateType currentState)
        {
            var isEditMode = currentState == UpdateType.Add ||
                             currentState == UpdateType.Modify;

//设置编辑页面的文本框控件只读和可编辑状态
            SetDetailEditorsAccessable(pcDetailEditor, isEditMode);
//设置明细表格的按钮禁用和可用状态
            SetGridCustomButtonAccessable(gcDetail0, isEditMode);
//设置明细表格的可修改状态
            gvDetail0.OptionsBehavior.Editable = isEditMode;
            lbStateName.Text = UpdateTypeName;
        }

//有明细表：绑定单据明细表的数据源.
        protected override void DoBindingDetailGrid(DataSet dataSource)
        {
            gcDetail0.DataSource = null;
            gcDetail0.DataSource = dataSource.Tables[DAA01.__TableName];
        }

        /// <summary>
        /// 绑定【编辑页面】所有文本输入框的数据源
        /// </summary>
        /// <param name="summary">数据源</param>
        protected override void DoBindingSummaryEditor(DataTable summary)
        {
            DoBindingEditorPanel(pcDetailEditor, summary);

            //在此绑定其它自定义组件的数据源,参考frmCustomer的DoBindingSummaryEditor方法
        }

        public override void DoAdd(IButtonInfo sender)
        {
            base.DoAdd(sender);
            if (_UpdateType == UpdateType.Add)
            {
                // 在此添加所需的代码
                txtDAA022.Properties.ReadOnly = true;
                txtDAA022.Enabled = false;
                SetEditorBindingValue(txtDAA022, "新建", true);

                var nextDaa001 = getNextDaa001();

                SetEditorBindingValue(txtDAA001, nextDaa001, true);
            }
        }

        public override void DoEdit(IButtonInfo sender)
        {
            base.DoEdit(sender);
            if (_UpdateType == UpdateType.Modify)
            {
                //点击修改按钮时先清空下拉框的值
                txtDAA022.Properties.Items.Clear();

                txtDAA022.Properties.ReadOnly = true;
                txtDAA022.Enabled = false;
                //手动填充下拉框的值
                txtDAA022.Properties.Items.AddRange(new object[]
                {
                    "新建",
                    "下达",
                    "开工",
                    "暂停",
                    "完工"
                });
                //将ComboboxEdit下拉框设置为不可手动输入
                txtDAA022.Properties.TextEditStyle =
                    TextEditStyles.DisableTextEditor;
            }
        }

//创建一条明细记录
        private void CreateOneDetail(GridView gridView, int buttonIndex)
        {
            var gridControl = gridView.GridControl;
            var detailTableName = (string)gridView.Tag;
//若要取排序序号,要将光标移到最后一行
            if (buttonIndex == DetailButtons.Add) gridView.MoveLast();

            //若表格无记录，转换为新增状态
            if (gridView.RowCount == 0) buttonIndex = DetailButtons.Add;

            var row = _BLL.CurrentBusiness.Tables[detailTableName].NewRow();
            row["ID"] = Guid.NewGuid();
            row["PID"] = _BLL.DataBindRow["ID"];
            row["DAA001"] = txtDAA001.Text;
            row["BGDATE"] = DateTime.Now.ToString("yyyy/MM/dd");
            //增加一条明细记录
            if (buttonIndex == DetailButtons.Add)
            {
                _BLL.CurrentBusiness.Tables[detailTableName].Rows.Add(row);
                gridControl.RefreshDataSource(); //立即刷新数据源
                gridView.FocusedRowHandle = gridView.RowCount - 1; //光标移到到最后一条记录
            }
            else if (buttonIndex == DetailButtons.Insert) //插入一条明细记录
            {
                _BLL.CurrentBusiness.Tables[detailTableName].Rows
                    .InsertAt(row, gridView.FocusedRowHandle);
                gridView.FocusedRowHandle = gridView.FocusedRowHandle - 1;
            }

            gridView.FocusedColumn = gridView.VisibleColumns[0];
        }

        public override void DoSave(IButtonInfo sender) // 保存数据
        {
            UpdateLastControl(); //更新最后一个文本输入框的数据

            try
            {
                frmWaitingEx.ShowMe(this);

                var dsTemplate =
                    _BLL.CreateSaveData(_BLL.CurrentBusiness); //创建用于保存的临时数据

                if (dsTemplate == null) return;

                var
                    result = _BLL.Update(dsTemplate); //调用业务逻辑层Update()方法保存数据

                if (result.Success) //保存成功, 不需要重新加载数据，更新缓存数据即可．
                {
                    if (_UpdateType == UpdateType.Add)
                        _BLL.DataBindRow[WOMDAA.__KeyName] =
                            result.DocNo; //更新单据号码
                    if (_UpdateType == UpdateType.Modify)
                        _BLL.NotifyUser(); //发送短信或Email通知制单人
                    UpdateSummaryCurrentRow(_BLL
                        .DataBindRow); //刷新表格当前记录的缓存数据.
                    DoBindingSummaryEditor(_BLL
                        .DataBinder); //重新绑定文本框的数据源，刷新数据
                    if (_UpdateType == UpdateType.Add)
                        gvSummary.MoveLast(); //若是新增操作,要移动到取后一条记录.

                    base.DoSave(sender); //调用基类的方法. 此行代码应放较后位置.

                    frmWaitingEx.HideMe(this);
                    try
                    {
                        frmWaitingEx.ShowMe(this);

                        //实例化查询参数
                        var P = new QueryWOMDAA
                        {
                            //DAA001 = ConvertEx.ToString(txt_DAA001.EditValue),
                            //DAA015 = ConvertEx.ToString(txt_DAA015.EditValue),
                            //DAA022 = ConvertEx.ToString(txt_DAA022.EditValue)
                        };


                        var dt = _BLLInstance.Query(P);
                        DoBindingSummaryGrid(dt); //绑定主表的Grid
                        ShowSummaryPage(true); //显示Summary页面.
                        if (gvSummary.RowCount == 0) Msg.Warning("没有找到数据!");
                    }
                    finally
                    {
                        frmWaitingEx.HideMe(this);
                    }

                    Msg.ShowInformation("保存成功!");
                }
                else
                {
                    Msg.Warning("保存失败!");
                }
            }
            finally
            {
                frmWaitingEx.HideMe(this);
            }
        }

        /// <summary>
        /// 保存数据后，更新表格中当前记录的数据(更新缓存资料）
        /// </summary>
        /// <param name="currentRow">当前修改的记录</param>
        /// <param name="docNo">当前单据号码</param>
        protected void UpdateSummaryCurrentRow(DataRow currentRow)
        {
//若表格没有数据源，要下载当前单据的数据
            if (gcSummary.DataSource == null || gvSummary.RowCount == 0)
            {
                //实例化查询参数
                var P = new QueryWOMDAA
                {
                    DAA001 = "",
                    DAA015 = "",
                    DAA022 = ""
                };

                var dt = _BLLInstance.Query(P); //获取数据
                DoBindingSummaryGrid(dt); //绑定主表表格的数据源
            }
            else
            {
                //调用基类方法更新表格中当前记录的缓存数据
                base.UpdateSummaryRow(currentRow);
            }
        }

        private void btnEmpty_Click(object sender, EventArgs e)
        {
            ClearContainerEditorText(pnlSearch);
        }

        private void btnQuery_Click(object sender, EventArgs e)
        {
//查询数据     
            try
            {
                frmWaitingEx.ShowMe(this);

                //实例化查询参数
                var P = new QueryWOMDAA
                {
                    //DAA001 = ConvertEx.ToString(txt_DAA001.EditValue),
                    //DAA015 = ConvertEx.ToString(txt_DAA015.EditValue),
                    //DAA022 = ConvertEx.ToString(txt_DAA022.EditValue)
                };


                var dt = _BLLInstance.Query(P);
                DoBindingSummaryGrid(dt); //绑定主表的Grid
                ShowSummaryPage(true); //显示Summary页面.
                if (gvSummary.RowCount == 0) Msg.Warning("没有找到数据!");
            }
            finally
            {
                frmWaitingEx.HideMe(this);
            }
        }


//给明细表绑定KeyDown事件,控制按回车事件
        private void gvDetail_KeyDown(object sender, KeyEventArgs e)
        {
            var gridView = (GridView)sender;
//表格按回车键自动跳转到下一个可编辑列, 若是最后一列,自动新增一条记录
            GridMovetor.OnGridViewKeyDown(gridView, e);
        }

        private void buttonEdit1_Click(object sender, EventArgs e)
        {
            var dlg = new OpenFileDialog();
            dlg.Filter = "所有EXCEL文件|*.xlsx;*.xls";
            dlg.FileName = "EXCEL文件";
            if (DialogResult.OK == dlg.ShowDialog())
                buttonEdit1.Text = dlg.FileName;
        }

        private void simpleButton1_Click(object sender, EventArgs e)
        {
            try
            {
                var DllNameT = "";
                var DllName = "";

                if (buttonEdit1.Text == "")
                {
                    Msg.Warning("请先选择文件！！！");
                    return;
                }

                var list = new List<Models.Order>();

                try
                {
                    DllNameT = buttonEdit1.Text;
                    DllName = DllNameT.Substring(DllNameT.LastIndexOf("\\") + 1)
                        .ToString();
                    //Console.OutputEncoding = System.Text.Encoding.UTF8;
                    IWorkbook workbook = null;
                    using (var file = new FileStream(DllNameT,
                               FileMode.Open, FileAccess.Read))
                    {
                        if (DllName.IndexOf(".xlsx") > 0) // 2007及以后版本
                            workbook = new XSSFWorkbook(file);
                        else if (DllName.IndexOf(".xls") > 0) // 2003版本
                            workbook = new HSSFWorkbook(file);
                    }

                    var db1 = SqlSugarHelper.GetInstance();
                    var date = DateTime.Now.ToString("yyyyMMdd");

                    var user = Loginer.CurrentUser.Account;

                    //NumberOfSheets sheet的总数,要注意是否有隐藏的sheet
                    for (var sheetNum = 0;
                         sheetNum < workbook.NumberOfSheets;
                         sheetNum++)
                    {
                        var sheet = workbook.GetSheetAt(sheetNum);
                        var rows =
                            sheet.GetRowEnumerator();

                        var headerRow = sheet.GetRow(sheet.FirstRowNum);
                        int cellCount = headerRow.LastCellNum;

                        //读取body
                        for (var i = sheet.FirstRowNum + 1;
                             i <= sheet.LastRowNum;
                             i++)
                        {
                            var order = new Models.Order();

                            order.id = GetUniqueIDTO22();

                            var row = sheet.GetRow(i);
                            //DataRow dataRow = dt.NewRow();
                            //for (int j = row.FirstCellNum; j < cellCount; j++)
                            for (var j = 0; j < cellCount; j++)
                            {
                                switch (j)
                                {
                                    case 0:

                                        order.Daa001 = row.GetCell(j) == null
                                            ? null
                                            : row.GetCell(j).ToString();

                                        if (string.IsNullOrEmpty(order.Daa001))
                                        {
                                            if (list.Count == 0)
                                            {
                                                order.Daa001 = getNextDaa001();
                                            }
                                            else
                                            {
                                                var max =
                                                    list.Max(s => s.Daa001);
                                                var number =
                                                    Convert.ToInt32(
                                                        max.Substring(
                                                            max.Length - 3)) +
                                                    1;

                                                order.Daa001 =
                                                    date + string.Format(
                                                        "{0:D3}", number);
                                            }
                                        }

                                        var count = db1
                                            .Queryable<Models.Order>()
                                            .Where(s =>
                                                s.Daa001 == order.Daa001)
                                            .Count();

                                        if (count > 0)
                                        {
                                            Msg.Warning(order.Daa001 + "工单号重复");
                                            return;
                                        }

                                        break;
                                    case 1:
                                        order.Daa014 =
                                            row.GetCell(j).ToString();
                                        break;
                                    case 2:
                                        order.Daa015 =
                                            row.GetCell(j).ToString();
                                        break;
                                    case 3:
                                        order.Daa016 =
                                            row.GetCell(j).ToString();
                                        break;
                                    case 4:
                                        order.Daa027 =
                                            Convert.ToInt32(row.GetCell(j)
                                                .ToString());
                                        break;
                                    case 5:
                                        order.ISOk = 0;
                                        break;
                                    case 6:
                                        order.Daa020 =
                                            row.GetCell(j).ToString();
                                        break;
                                    case 7:
                                        order.Daa021 =
                                            row.GetCell(j).ToString();
                                        break;
                                    case 8:
                                        order.LineNo =
                                            row.GetCell(j).ToString();
                                        break;
                                    case 9:
                                        order.DeptName =
                                            row.GetCell(j).ToString();
                                        break;
                                    case 10:
                                        order.Daa042 =
                                            row.GetCell(j).ToString();
                                        break;
                                    case 11:
                                        order.Daa022 =
                                            row.GetCell(j).ToString();
                                        break;
                                }

                                //dt.Rows.Add(dataRow);
                                order.Daa022Date =
                                    DateTime.Now.ToString(
                                        "yyyy-MM-dd HH:mm:ss");

                                order.Daa022By = user;
                            }

                            list.Add(order);
                        }

                        SqlSugarHelper.UseTransactionWithOracle(db =>
                            db.Insertable<Models.Order>(list).ExecuteCommand());
                    }
                }
                catch (Exception EE)
                {
                    Msg.Warning(EE.Message.ToString());
                    return;
                }

                // TestUpload();
                Msg.Warning("上传成功！！！");
                buttonEdit1.Text = "";

                var dt = _BLLInstance.Query(new QueryWOMDAA());
                DoBindingSummaryGrid(dt); //绑定主表的Grid
                ShowSummaryPage(true); //显示Summary页面.
                if (gvSummary.RowCount == 0) Msg.Warning("没有找到数据!");
            }
            catch (Exception ex)
            {
                Msg.Warning(ex.ToString());
                throw;
            }
        }

        /// <summary>
        /// 生成22位的唯一数字，并发可用
        /// </summary>
        /// <returns></returns>
        private string GetUniqueIDTO22()
        {
            //System.Threading.Thread.Sleep(1);
            //保证yyyyMMddHHmmssffff唯一
            var rd =
                new Random(
                    BitConverter.ToInt32(Guid.NewGuid().ToByteArray(), 0));
            var strUniqueID = DateTime.Now.ToString("yyyyMMddHHmmssffff") +
                              rd.Next(1000, 9999);
            return strUniqueID;
        }

        private void txtDAA020_EditValueChanged(object sender, EventArgs e)
        {
            if (!string.IsNullOrEmpty(txtDAA020.EditValue.ToString()))
            {
                var formattedDate = DateTime
                    .Parse(txtDAA020.EditValue.ToString())
                    .ToString("yyyy-MM-dd HH:mm:ss");
                SetEditorBindingValue(txtDAA020, formattedDate.ToString(),
                    true);
            }
        }

        private void txtDAA021_EditValueChanged(object sender, EventArgs e)
        {
            if (!string.IsNullOrEmpty(txtDAA021.EditValue.ToString()))
            {
                var formattedDate = DateTime
                    .Parse(txtDAA021.EditValue.ToString())
                    .ToString("yyyy-MM-dd HH:mm:ss");
                SetEditorBindingValue(txtDAA021, formattedDate.ToString(),
                    true);
            }
        }

        private string getNextDaa001()
        {
            var date = DateTime.Now.ToString("yyyyMMdd");
            var db = SqlSugarHelper.GetInstance();
            var max = db.Queryable<Models.Order>()
                .Where(s => SqlFunc.StartsWith(s.Daa001, date))
                .Max<string>(s => s.Daa001);

            if (string.IsNullOrEmpty(max)) return date + "001";

            var number = Convert.ToInt32(max.Substring(max.Length - 3)) + 1;

            return date + string.Format("{0:D3}", number);
        }

        private void gvSummary_RowStyle(object sender, RowStyleEventArgs e)
        {
            var hand = e.RowHandle; //行号
            if (hand < 0) return;

            var dr = gvSummary.GetDataRow(hand);
            if (dr == null)
                return;

            //int selectedHandle = gridView1.GetSelectedRows()[hand];
            var daa027 =
                Convert.ToInt32(gvSummary.GetRowCellValue(hand, "DAA027")
                    .ToString());
            var isok =
                Convert.ToInt32(gvSummary.GetRowCellValue(hand, "ISOk")
                    .ToString());
            if (isok > daa027)
            {
                e.Appearance.ForeColor = Color.Red; //字体颜色
                e.Appearance.BackColor = Color.Linen; //行背景颜色
                //e.Appearance.BackColor2 = Color.Blue;//渐变颜色
            }
        }

        private void gvSummary_RowCellStyle(object sender,
            RowCellStyleEventArgs e)
        {
            var hand = e.RowHandle; //行号
            if (hand < 0) return;

            var dr = gvSummary.GetDataRow(hand);
            if (dr == null)
                return;

            //int selectedHandle = gridView1.GetSelectedRows()[hand];
            var daa027 =
                Convert.ToInt32(gvSummary.GetRowCellValue(hand, "DAA027")
                    .ToString());
            var isok =
                Convert.ToInt32(gvSummary.GetRowCellValue(hand, "ISOk")
                    .ToString());
            if (isok > daa027)
            {
                e.Appearance.ForeColor = Color.Red; //字体颜色
                e.Appearance.BackColor = Color.Linen; //行背景颜色
                //e.Appearance.BackColor2 = Color.Blue;//渐变颜色
            }
        }

        private void txtDAA042_EditValueChanged(object sender, EventArgs e)
        {
            var s = txtDAA042.EditValue.ToString();

            if (string.IsNullOrEmpty(s)) return;

            var row =
                txtDAA042.Properties.GetRowByKeyValue(s) as DataRowView;
            SetEditorBindingValue(txtLINE_NO, row["产线编码"].ToString(), true);
            SetEditorBindingValue(txtDeptName, row["车间名称"].ToString(), true);
            SetEditorBindingValue(txtDAA042, row["产线名称"].ToString(), true);
        }

        public override void DoDelete(IButtonInfo sender)
        {
            var row = _SummaryView.GetDataRow(_SummaryView.FocusedRowHandle);

            if (row == null) return;

            var s = row["DAA022"].ToString();

            if ("新建".Equals(s))
                base.DoDelete(sender);
            else
                Msg.Warning("只允许删除新建的工单");
        }

        public override void InitButtons()
        {
            //base.InitButtons();
            Buttons.AddRange(GetBusinessButtons());
            Buttons.AddRange(GetPrintableButtons());

            var dataButton = GetDataOperatableButtons(); //数据操作按钮
            Buttons.AddRange(dataButton);

            var btnClose = ToolbarRegister.CreateButton("btnClose",
                LanLib.Get("关闭"), ToolBarGroup.关闭窗体,
                Globals.LoadBitmap("32_Exit.png"), new Size(57, 28), false,
                true,
                DoClose);

            var btnRefresh4 = ToolbarRegister.CreateButton("btnRefreshDataDict",
                LanLib.Get("刷新"), ToolBarGroup.数据操作,
                Globals.LoadBitmap("32_Refresh.png"), new Size(57, 28), true,
                true, DoRefreshData);

            //下达  SendOut
            var btnRefresh1 = ToolbarRegister.CreateButton("btnRefreshDataDict",
                LanLib.Get("下达"), ToolBarGroup.数据操作,
                Globals.LoadBitmap("32_Refresh.png"), new Size(57, 28), true,
                true, SendOut);

            //开工 Start
            var btnRefresh2 = ToolbarRegister.CreateButton("btnRefreshDataDict",
                LanLib.Get("开工"), ToolBarGroup.数据操作,
                Globals.LoadBitmap("32_Refresh.png"), new Size(57, 28), true,
                true, Start);

            //暂停后开工  StartWorkAfterSuspension
            var btnRefresh3 = ToolbarRegister.CreateButton("btnRefreshDataDict",
                LanLib.Get("暂停后开工"), ToolBarGroup.数据操作,
                Globals.LoadBitmap("32_Refresh.png"), new Size(57, 28), true,
                true, StartWorkAfterSuspension);

            // 暂停  suspend
            var btnRefresh5 = ToolbarRegister.CreateButton("btnRefreshDataDict",
                LanLib.Get("暂停"), ToolBarGroup.数据操作,
                Globals.LoadBitmap("32_Refresh.png"), new Size(57, 28), true,
                true, Suspend);

            //手动完工 End
            var btnRefresh6 = ToolbarRegister.CreateButton("btnRefreshDataDict",
                LanLib.Get("手动完工"), ToolBarGroup.数据操作,
                Globals.LoadBitmap("32_Refresh.png"), new Size(57, 28), true,
                true, End);

            //报工作废 Invalidate
            var btnRefresh7 = ToolbarRegister.CreateButton("btnRefreshDataDict",
                LanLib.Get("报工作废"), ToolBarGroup.数据操作,
                Globals.LoadBitmap("32_Refresh.png"), new Size(57, 28), true,
                true, Invalidate);

            if (Loginer.CurrentUser.Account != "查询")
            {
                _buttons.AddButton(btnClose);
                _buttons.AddButton(btnRefresh4);
                _buttons.AddButton(btnRefresh1);
                _buttons.AddButton(btnRefresh2);
                _buttons.AddButton(btnRefresh3);
                _buttons.AddButton(btnRefresh5);
                _buttons.AddButton(btnRefresh6);
                _buttons.AddButton(btnRefresh7);
            }
        }

        private void DoRefreshData(IButtonInfo sender)
        {
            var P = new QueryWOMDAA
            {
                //DAA001 = ConvertEx.ToString(txt_DAA001.EditValue),
                //DAA015 = ConvertEx.ToString(txt_DAA015.EditValue),
                //DAA022 = ConvertEx.ToString(txt_DAA022.EditValue)
            };
            var dt = _BLLInstance.Query(P);
            DoBindingSummaryGrid(dt); //绑定主表的Grid
        }

        private void SendOut(IButtonInfo sender)
        {
            var row = _SummaryView.GetDataRow(_SummaryView.FocusedRowHandle);

            if (row == null) return;

            var daa022 = row["DAA022"].ToString();

            if ("新建".Equals(daa022))
            {
                //获取当前用户
                var user = Loginer.CurrentUser.Account;
                var time = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss");

                var id = row["id"].ToString();

                var daa022New = "下达";

                var useTransactionWithOracle =
                    SqlSugarHelper.UseTransactionWithOracle(db =>
                    {
                        string text = daa022New + "-" + time + "-" + user + ";";

                        return db.Updateable<Models.Order>()
                            .SetColumns(order => order.Daa022 == daa022New)
                            .SetColumns(order => order.Daa022Date == time)
                            .SetColumns(order => order.Daa022By == user)
                            .SetColumns(order =>
                                order.Notes == order.Notes + text)
                            .Where(s => s.id == id).ExecuteCommand();
                    });

                if (useTransactionWithOracle > 0)
                {
                    Msg.Warning("审核成功,工单状态已修改");
                    var dt = _BLLInstance.Query(new QueryWOMDAA());
                    DoBindingSummaryGrid(dt); //绑定主表的Grid
                }
                else
                {
                    Msg.Warning("审核失败");
                }
            }
            else
            {
                Msg.Warning(daa022 + "状态无需下发");
            }
        }

        private void Start(IButtonInfo sender)
        {
            //审核  下一步
            var row = _SummaryView.GetDataRow(_SummaryView.FocusedRowHandle);

            if (row == null) return;

            var daa022 = row["DAA022"].ToString();

            if ("下达".Equals(daa022))
            {
                //获取当前用户
                var user = Loginer.CurrentUser.Account;
                var time = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss");

                var id = row["id"].ToString();

                var daa022New = "开工";

                var lineNo = row["LINE_NO"].ToString();
                var deptName = row["DeptName"].ToString();
                var daa042 = row["DAA042"].ToString();


                var db = SqlSugarHelper.GetInstance();
                var count = db.Queryable<Models.Order>()
                    .Where(s => s.Daa042 == daa042
                                && s.Daa022 == daa022New
                                && s.DeptName == deptName
                                && s.LineNo == lineNo).Count();
                if (count > 0)
                {
                    Msg.Warning("当前产线已经存在已开工的工单，无法审核");
                    return;
                }

                var useTransactionWithOracle =
                    SqlSugarHelper.UseTransactionWithOracle(db1 =>
                    {
                        string text = daa022New + "-" + time + "-" + user + ";";

                        return db1.Updateable<Models.Order>()
                            .SetColumns(order => order.Daa022 == daa022New)
                            .SetColumns(order => order.Daa022Date == time)
                            .SetColumns(order => order.Daa022By == user)
                            .SetColumns(order =>
                                order.Notes == order.Notes + text)
                            .Where(s => s.id == id).ExecuteCommand();
                    });

                if (useTransactionWithOracle > 0)
                {
                    Msg.Warning("审核成功,工单状态已修改");
                    var dt = _BLLInstance.Query(new QueryWOMDAA());
                    DoBindingSummaryGrid(dt); //绑定主表的Grid
                }
                else
                {
                    Msg.Warning("审核失败");
                }
            }
            else
            {
                Msg.Warning(daa022 + "状态无需审核");
            }
        }

        //StartWorkAfterSuspension
        private void StartWorkAfterSuspension(IButtonInfo sender)
        {
            //审核  下一步
            var row = _SummaryView.GetDataRow(_SummaryView.FocusedRowHandle);

            if (row == null) return;

            var daa022 = row["DAA022"].ToString();

            if ("暂停".Equals(daa022))
            {
                //获取当前用户
                var user = Loginer.CurrentUser.Account;
                var time = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss");

                var id = row["id"].ToString();

                var daa022New = "开工";


                var lineNo = row["LINE_NO"].ToString();
                var deptName = row["DeptName"].ToString();
                var daa042 = row["DAA042"].ToString();


                var db = SqlSugarHelper.GetInstance();
                var count = db.Queryable<Models.Order>()
                    .Where(s => s.Daa042 == daa042
                                && s.Daa022 == daa022New
                                && s.DeptName == deptName
                                && s.LineNo == lineNo).Count();
                if (count > 0)
                {
                    Msg.Warning("当前产线已经存在已开工的工单，无法审核");
                    return;
                }

                var useTransactionWithOracle =
                    SqlSugarHelper.UseTransactionWithOracle(db1 =>
                    {
                        string text = daa022New + "-" + time + "-" + user + ";";

                        return db1.Updateable<Models.Order>()
                            .SetColumns(order => order.Daa022 == daa022New)
                            .SetColumns(order => order.Daa022Date == time)
                            .SetColumns(order => order.Daa022By == user)
                            .SetColumns(order =>
                                order.Notes == order.Notes + text)
                            .Where(s => s.id == id).ExecuteCommand();
                    });

                if (useTransactionWithOracle > 0)
                {
                    Msg.Warning("审核成功,工单状态已修改");

                    var dt = _BLLInstance.Query(new QueryWOMDAA());
                    DoBindingSummaryGrid(dt); //绑定主表的Grid
                }
                else
                {
                    Msg.Warning("审核失败");
                }
            }
            else
            {
                Msg.Warning(daa022 + "状态无需审核");
            }
        }

        //Suspend
        private void Suspend(IButtonInfo sender)
        {
            //暂停
            var row = _SummaryView.GetDataRow(_SummaryView.FocusedRowHandle);

            if (row == null) return;

            var daa022 = row["DAA022"].ToString();

            if (!"开工".Equals(daa022))
            {
                Msg.Warning("只有开工状态下才允许暂停");
                return;
            }

            var user = Loginer.CurrentUser.Account;
            var time = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss");
            var id = row["id"].ToString();

            var useTransactionWithOracle =
                SqlSugarHelper.UseTransactionWithOracle(db =>
                {
                    string text = "暂停-" + time + "-" + user + ";";
                    return db.Updateable<Models.Order>()
                        .SetColumns(order => order.Daa022 == "暂停")
                        .SetColumns(order => order.Daa022Date == time)
                        .SetColumns(order => order.Daa022By == user)
                        .SetColumns(order => order.Notes == order.Notes + text)
                        .Where(s => s.id == id).ExecuteCommand();
                });

            if (useTransactionWithOracle > 0)
            {
                Msg.Warning("暂停成功,工单状态已修改");

                var dt = _BLLInstance.Query(new QueryWOMDAA());
                DoBindingSummaryGrid(dt); //绑定主表的Grid
            }
            else
            {
                Msg.Warning("暂停失败");
            }
        }

        private void End(IButtonInfo sender)
        {
            //获取选中行
            var row = _SummaryView.GetDataRow(_SummaryView.FocusedRowHandle);

            if (row == null) return;

            var id = row["id"].ToString();

            //获取当前用户
            var user = Loginer.CurrentUser.Account;
            var time = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss");

            var useTransactionWithOracle =
                SqlSugarHelper.UseTransactionWithOracle(db =>
                {
                    string text = "完工-" + time + "-" + user + ";";

                    return db.Updateable<Models.Order>()
                        .SetColumns(order => order.Daa022 == "完工")
                        .SetColumns(order => order.Daa022Date == time)
                        .SetColumns(order => order.Daa022By == user)
                        .SetColumns(order => order.Notes == order.Notes + text)
                        .Where(s => s.id == id).ExecuteCommand();
                });

            if (useTransactionWithOracle > 0)
            {
                Msg.Warning("手动结案成功");

                var dt = _BLLInstance.Query(new QueryWOMDAA());
                DoBindingSummaryGrid(dt); //绑定主表的Grid
            }
            else
            {
                Msg.Warning("手动结案失败");
            }
        }

        private void Invalidate(IButtonInfo sender)
        {
            //报废  回退到新建
            var row = _SummaryView.GetDataRow(_SummaryView.FocusedRowHandle);

            if (row == null) return;

            var daa022 = row["DAA022"].ToString();

            if ("完工".Equals(daa022) || "新建".Equals(daa022) ||
                "暂停".Equals(daa022))
            {
                Msg.Warning(daa022 + "状态不能作废");
                return;
            }

            var user = Loginer.CurrentUser.Account;
            var time = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss");
            var id = row["id"].ToString();

            var useTransactionWithOracle =
                SqlSugarHelper.UseTransactionWithOracle(db =>
                {
                    string text = "新建-" + time + "-" + user + ";";
                    return db.Updateable<Models.Order>()
                        .SetColumns(order => order.Daa022 == "新建")
                        .SetColumns(order => order.Daa022Date == time)
                        .SetColumns(order => order.Daa022By == user)
                        .SetColumns(order => order.Notes == order.Notes + text)
                        .Where(s => s.id == id).ExecuteCommand();
                });

            if (useTransactionWithOracle > 0)
            {
                Msg.Warning("作废成功,工单状态已修改");

                var dt = _BLLInstance.Query(new QueryWOMDAA());
                DoBindingSummaryGrid(dt); //绑定主表的Grid
            }
            else
            {
                Msg.Warning("作废失败");
            }
        }
    }
}