MES_Client/TGMES/Core.StlMes.Client.Pms/Report/FrmOrderReport1.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 CoreFS.CA06;
using Pur.Entity;
using System.Collections;
using Infragistics.Win.UltraWinGrid;
using Core.Mes.Client.Comm.Server;
using Core.Mes.Client.Comm.Control;
using Core.Mes.Client.Comm.Tool;
using System.Text.RegularExpressions;
using System.Drawing;
using Pur.Entity.ck;
using com.hnshituo.pur.ck.vo;
using Pur.Entity.configureEntity;
using com.hnshituo.pur.purplan.vo;
using NPOI.SS.Util;
using com.hnshituo.pur.vo;


namespace Pur.FrmTransceiver1
{
    public partial class FrmOrderReport1 : FrmPmsBase
    {
        public FrmOrderReport1()
        {
            InitializeComponent();
        }
        /// <summary>
        /// 树节点选中事件触发时，存储父节点id，防止当父节点选中项转移到其他焦点时，无法获取数据。
        /// </summary>
        private  string parentCode = "";
        private  string time1 = "";
        private  string time2 = "";
        private  string shift = ""; //合同号
        private  string group = "";  //物料名称
        private string keshi = ""; //业务科室


        //菜单按钮
        public override void ToolBar_Click(object sender, string ToolbarKey)//菜单按钮
        {
            switch (ToolbarKey)
            {
                case "Query"://刷新数据
                    doQuery();
                    break;

                case "doClose"://关闭
                    this.Close();
                    break;
                case "doExcel"://导出excel
                    doExcel();
                    break;
            }
        }

        private void doExcel()
        {
            try
            {
                this.Cursor = Cursors.WaitCursor;
                ArrayList alUltraGrid = new ArrayList();
                //ultraGrid3.DisplayLayout.Bands[0].Columns["CHK"].Hidden = true;
                alUltraGrid.Add(ultraGrid1);
               // alUltraGrid.Add(ultraGrid2);

                ArrayList alSheeft = new ArrayList();
                alSheeft.Add("合同报表(汇总)");
              //  alSheeft.Add("任务单行表");
                if (ultraGrid1.Rows.Count > 0)
                {
                    GridHelper.ulGridToExcel(alUltraGrid, alSheeft, "合同报表(汇总)");//导出excel
                }
            }
            catch (Exception e)
            {
                MessageUtil.ShowTips("导出失败" + e.Message);
            }
            finally
            {
                //ultraGrid2.DisplayLayout.Bands[0].Columns["CHK"].Hidden = false;
                this.Cursor = Cursors.Default;
            }
        }

        /// <summary>
        /// 查询采购计划主表
        /// </summary>
        /// <param name="PurPlanMEntity"></param>
        public void doQuery()
        {
            ultraGroupBox1.Refresh();
            #region
            //合同号
            if (txt_itemName.Text == null)
            {
                shift = "";
               
            }
            else
            {
                shift = this.txt_itemName.Text.ToString();
            }
            //业务科室
            if (unit.Text == null)
            {
                keshi = "";

            }
            else
            {
                keshi = this.unit.Text.ToString();
            }

        
            if (DateTime.Parse(RegStartTime.Value.ToString()) > DateTime.Parse(RegEndTime.Value.ToString()))
            {
                MessageUtil.ShowTips("选择时间区间错误,请重新选择!");
                return;
            }
            else
            {
                time1 = Convert.ToDateTime(RegStartTime.Value).ToString("yyyy-MM-dd");
                time2 = Convert.ToDateTime(RegEndTime.Value).ToString("yyyy-MM-dd");
            }
            //物料名称
            if (txt_itemCode.Text == null)
            {
                group = "";
            }
            else
            {
                group = this.txt_itemCode.Text.ToString();
            }
           
            #endregion
            OrderC plan1 = new OrderC();
            plan1.OrderId = shift;//合同号
            plan1.ItemName = group;//物料名称
            plan1.BuyerDeptDesc = keshi;//
            plan1.CreateTime = Convert.ToDateTime(time1);
            plan1.UpdateTime = Convert.ToDateTime(time2);
            DataTable dt = this.execute<DataTable>("com.hnshituo.pur.order.service.OrderMService", "getOrderReportTotal1", new object[] { plan1 });
            GridHelper.CopyDataToDatatable(ref dt, ref dataTable3, true);
            GridHelper.RefreshAndAutoSize(this.ultraGrid1);
        }

        private void FrmTransceiver1_Load(object sender, EventArgs e)
        {
            DateTime now = DateTime.Now;
            DateTime d1 = new DateTime(now.Year, now.Month, 1);
            //Convert.ToDateTime(RegStartTime.Value).ToString("yyyy-MM-dd");
            RegStartTime.Value = d1.ToString("yyyy-MM-dd");
            RegEndTime.Value = now.ToString("yyyy-MM-dd");
        }

        private void ultraGrid1_AfterRowActivate(object sender, EventArgs e)
        {
            UltraGridRow row = ultraGrid1.ActiveRow;
            if (row == null) return;
            string orderId = row.Cells["orderId"].Value.ToString();
            DataTable dt = this.execute<DataTable>("com.hnshituo.pur.order.service.OrderMService", "getOrderReport", new object[] { orderId });
            GridHelper.CopyDataToDatatable(ref dt, ref dataTable1, true);
            GridHelper.RefreshAndAutoSize(this.ultraGrid3);
        }

    }
}