MES_Client/TGMES/Core.StlMes.Client.PlnSaleOrd/FrmSaleOrderlog.cs

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 System.Collections;
using Infragistics.Win.UltraWinGrid;
using Infragistics.Win;
using CoreFS.CA06;
using CoreFS.SA06;
using Core.Mes.Client.Comm.Server;
using Core.Mes.Client.Comm.Control;
using Core.Mes.Client.Comm;

namespace Core.StlMes.Client.PlnSaleOrd
{
    /// <summary>
    /// 合同撤消接收日志查询界面
    /// @author：杨天海
    /// @version：v1.1
    /// @date:2015.06.22 
    /// </summary>
    public partial class FrmSaleOrderlog : FrmBase
    {
        public FrmSaleOrderlog()
        {
            this.IsLoadUserView = true;
            InitializeComponent();
        }

        private void checkBoxForReqDELVRY_EDATE_CheckedChanged(object sender, EventArgs e)
        {
            if (checkBoxForReqDELVRY_EDATE.Checked)
            {
                ctrlForQueryDELVRY_EDATEFrom.Enabled = true;
                ctrlForQueryDELVRY_EDATETo.Enabled = true;
            }
            else
            {
                ctrlForQueryDELVRY_EDATEFrom.Enabled = false;
                ctrlForQueryDELVRY_EDATETo.Enabled = false;
            }
        }

        private void checkBoxForReqORDER_NO_CheckedChanged(object sender, EventArgs e)
        {
            if (checkBoxForReqORDER_NO.Checked)
            {
                ctrlForQueryORDER_NO.Enabled = true;
            }
            else
            {
                ctrlForQueryORDER_NO.Enabled = false;
            }
        }

        private void ctrlForQueryDELVRY_EDATEFrom_ValueChanged(object sender, EventArgs e)
        {
            ctrlForQueryDELVRY_EDATETo.MinDate = ctrlForQueryDELVRY_EDATEFrom.DateTime.Date;
        }

        private void ctrlForQueryDELVRY_EDATETo_ValueChanged(object sender, EventArgs e)
        {
            ctrlForQueryDELVRY_EDATEFrom.MaxDate = ctrlForQueryDELVRY_EDATETo.DateTime.AddDays(1).Date.AddSeconds(-1);
        }

        /// <summary>
        /// 初始化加载
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        private void FrmSaleOrderlog_Load(object sender, EventArgs e)
        {
            ctrlForQueryDELVRY_EDATEFrom.Value = DateTime.Now.AddMonths(-1);
            ctrlForQueryDELVRY_EDATETo.Value = DateTime.Now;
            ultraDateTimeDayBack.Value = DateTime.Now.AddMonths(-1);
            ultraDateTimeDayBackTo.Value = DateTime.Now;
            PlanComm.setGridActivation(ultraGrid1.DisplayLayout.Bands[0], "CHECK");
            doQuery();
        }

        /// <summary>
        /// 系统菜单
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="ToolbarKey"></param>
        public override void ToolBar_Click(object sender, string ToolbarKey)
        {
            base.ToolBar_Click(sender, ToolbarKey);
            switch (ToolbarKey)
            {
                case "Query":
                    doQuery();
                    break;
                case "Delete":
                    Delete();
                    break;
                case "Export":
                    doExport();
                    break;
                case "Close":  //关闭
                    this.Close();
                    break;
            }
        }

        /// <summary>
        /// 查询
        /// </summary>
        private void doQuery()
        {
            try
            {
                ArrayList param = new ArrayList();
                string strDayback = "1000/01/01"; //退回日期
                string strDaybackTo = "9999/12/31"; //退回日期
                string strOrderNo = "";  //合同号
                string strDateForm = "1000/01/01";  //交货结束日期从，默认最小日期
                string strDateTo = "9999/12/31";   //交货结束日期到，默认最大日期

                if (checkBoxDayBack.Checked)
                {
                    strDayback = ultraDateTimeDayBack.DateTime.ToString("yyyy/MM/dd");
                    strDaybackTo = ultraDateTimeDayBackTo.DateTime.ToString("yyyy/MM/dd");
                }

                if (checkBoxForReqORDER_NO.Checked)
                {
                    strOrderNo = ctrlForQueryORDER_NO.Text.Trim();
                }

                if (checkBoxForReqDELVRY_EDATE.Checked)
                {
                    if (ctrlForQueryDELVRY_EDATEFrom.DateTime > ctrlForQueryDELVRY_EDATETo.DateTime)
                    {
                        Core.Mes.Client.Comm.Tool.MessageUtil.ShowError("查询日期区间有误，请重新选择！");
                        return;
                    }
                    strDateForm = ctrlForQueryDELVRY_EDATEFrom.DateTime.ToString("yyyy/MM/dd");
                    strDateTo = ctrlForQueryDELVRY_EDATETo.DateTime.ToString("yyyy/MM/dd");
                }

                param.Add(strDayback);
                param.Add(strDaybackTo);
                param.Add(strOrderNo);
                param.Add(strDateForm);
                param.Add(strDateTo);

                DataTable dt = ServerHelper.GetData("com.steering.pss.plnsaleord.order.CoreOrdCancelLog.queryCancelLog",
                    new object[] { param }, this.ob);
                GridHelper.CopyDataToDatatable(dt, dataTable1, true);
            }
            catch (Exception ex)
            {
                if (ex is MESException)
                {
                    MessageBox.Show(((MESException)ex).ExceptionInfo);
                }
                else
                {
                    MessageBox.Show(ex.Message);
                }
            }
        }

        /// <summary>
        /// 删除日志
        /// </summary>
        private void Delete()
        {
            try
            {
                bool isChecked = false;
                ArrayList list = new ArrayList();
                foreach (UltraGridRow uRow in ultraGrid1.Rows)
                {
                    if (Convert.ToBoolean(uRow.Cells["CHECK"].Text))
                    {
                        ArrayList param = new ArrayList();
                        isChecked = true;
                        param.Add(uRow.Cells["BACKLOG_ID"].Value.ToString());
                        list.Add(param);
                    }
                }
                ///如果没有勾选预处理的条目，提示。
                if (!isChecked)
                {
                    Core.Mes.Client.Comm.Tool.MessageUtil.ShowTips("未勾选条目，请重新选择！");
                    return;
                }

                if (ServerHelper.SetData("com.steering.pss.plnsaleord.order.CoreOrdCancelLog.updateDeletelog",
                    new object[] { list }, this.ob) > 0)
                {
                    Core.Mes.Client.Comm.Tool.MessageUtil.ShowTips("删除成功！");
                }
                else
                {
                    Core.Mes.Client.Comm.Tool.MessageUtil.ShowTips("删除失败！");
                }
            }
            catch (Exception ex)
            {
                if (ex is MESException)
                {
                    MessageBox.Show(((MESException)ex).ExceptionInfo);
                }
                else
                {
                    MessageBox.Show(ex.Message);
                }
            }
            doQuery();
        }

        /// <summary>
        /// 导出
        /// </summary>
        private void doExport()
        {
            GridHelper.ulGridToExcel(ultraGrid1, "销售合同回退日志");
        }

        private void checkBoxDayBack_CheckedChanged(object sender, EventArgs e)
        {
            if (checkBoxDayBack.Checked)
            {
                ultraDateTimeDayBack.Enabled = true;
                ultraDateTimeDayBackTo.Enabled = true;
            }
            else
            {
                ultraDateTimeDayBack.Enabled = false;
                ultraDateTimeDayBackTo.Enabled = false;
            }
        }

        private void ultraDateTimeDayBack_ValueChanged(object sender, EventArgs e)
        {
            ultraDateTimeDayBackTo.MinDate = ultraDateTimeDayBack.DateTime.Date;
        }

        private void ultraDateTimeDayBackTo_ValueChanged(object sender, EventArgs e)
        {
            ultraDateTimeDayBack.MaxDate = ultraDateTimeDayBackTo.DateTime.AddDays(1).Date.AddSeconds(-1);
        }

        private void ultraGrid1_AfterSelectChange(object sender, AfterSelectChangeEventArgs e)
        {
            foreach (UltraGridRow uRow in ultraGrid1.Selected.Rows)
            {
                if (uRow.GetType() != typeof(Infragistics.Win.UltraWinGrid.UltraGridGroupByRow))
                {
                    uRow.Cells["CHECK"].Value = true;
                }
            }
        }
    }
}