MES_Client/TGMES/Core.StlMes.Client.Pms/Report/FrmInReportBalance.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;
using Pur.order;


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


        //菜单按钮
        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(ultraGrid3);
                ArrayList alSheeft = new ArrayList();
                alSheeft.Add("入库报表");
                if (ultraGrid3.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()
        {

            #region
            //合同号
            if (txt_itemName.Text == null)
            {
                shift = "";
            }
            else
            {
                shift = this.txt_itemName.Text.ToString();
            }
            //物料大类
            if (basename.Text == null)
            {
                itemname = "";
            }
            else
            {
                itemname = this.basename.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
            PurCkInBillEntity plan1 = new PurCkInBillEntity();
            plan1.OrderId = shift;//合同号
            plan1.ItemName = group;//物料名称
            plan1.ItemCode = itemname;//物料大类
            plan1.CreateTime = Convert.ToDateTime(time1);
            plan1.UpdateTime = Convert.ToDateTime(time2);
            DataTable dt = this.execute<DataTable>("com.hnshituo.pur.ck.service.CkInBillService", "getInReportBalance", new object[] { plan1 });
            GridHelper.CopyDataToDatatable(ref dt, ref dataTable2, 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");
            //获取
            PurCkInBillEntity CkInBillEntity = new PurCkInBillEntity();
            DataTable dt_GropByItem = this.execute<DataTable>("com.hnshituo.pur.ck.service.CkInBillService", "getbasename", new object[] { CkInBillEntity });
            comm.FilComboboxAdd(basename, dt_GropByItem, "basecode", "basename", "", true, "", "");
        }

        private void ultraGrid1_AfterRowActivate(object sender, EventArgs e)
        {
            if (ultraGrid1.ActiveRow == null)
                return;
            #region
            //合同号
            if (txt_itemName.Text == null)
            {
                shift = "";
            }
            else
            {
                shift = this.txt_itemName.Text.ToString();
            }
            //物料大类
            if (basename.Text == null)
            {
                itemname = "";
            }
            else
            {
                itemname = this.basename.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
            PurCkInBillEntity plan1 = new PurCkInBillEntity();
            plan1.OrderId = shift;//合同号
            plan1.ItemName = group;//物料名称
            plan1.ItemCode = itemname;//物料大类
            plan1.CreateTime = Convert.ToDateTime(time1);
            plan1.UpdateTime = Convert.ToDateTime(time2);
            plan1.Unit = ultraGrid1.ActiveRow.Cells["unit"].Text;
            DataTable dt = this.execute<DataTable>("com.hnshituo.pur.ck.service.CkInBillService", "getInReportBalanceDetail", new object[] { plan1 });
            GridHelper.CopyDataToDatatable(ref dt, ref dataTable1, true);
            GridHelper.RefreshAndAutoSize(this.ultraGrid3);
        }

    }
}