MES_Client/TGMES/Core.StlMes.Client.YdmPipeReport/17库存履历表/FrmMatResume.cs

using Core.Mes.Client.Comm.Control;
using Core.Mes.Client.Comm.Server;
using Core.Mes.Client.Comm.Tool;
using Core.StlMes.Client.YdmPipeManage.Tool;
using Core.StlMes.Client.YdmPipeReport.Entity;
using Core.StlMes.Client.YdmPipeReport.Tool;
using CoreFS.CA06;
using System;
using System.Collections;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Linq;
using System.Text;
using System.Windows.Forms;

namespace Core.StlMes.Client.YdmPipeReport
{
    public partial class FrmMatResume : FrmBase
    {
        public FrmMatResume()
        {
            InitializeComponent();
        }

        private void FrmMatResume_Load(object sender, EventArgs e)
        {
            DateTime now = DateTime.Now;
            DateTime dt1 = new DateTime(now.Year, now.Month, 1);//当月第一天
            DateTime dt2 = dt1.AddMonths(1).AddDays(-1);//当月最后一天
            StartTime.Value = DateTime.Parse(dt1.ToString("yyyy-MM-dd") + " 00:00:00");
            EndTime.Value = DateTime.Parse(dt2.ToString("yyyy-MM-dd") + " 23:59:59");
            EntityHelper.ShowGridCaption<MatZcTrackEntity>(ultraGrid1.DisplayLayout.Bands[0]);
            //字段显示格式
            BaseHelper.setUltraGridColumnMaxInput(ultraGrid1, new string[] { "ACT_WEIGHT", "ACT_LEN" });
            BaseHelper.setUltraGridColumnCountInput(ultraGrid1, new string[] { "ACT_COUNT" });
            //材料类别
            DataTable dtProducFlag = ServerHelper.GetData("com.steering.pss.ydm.pipemanage.FrmPipeMagement.queryMaterialSTyle", new object[] { }, ob);
            if (dtProducFlag.Rows.Count > 0)
            {
                Object[] obj = new Object[] { "", "" };
                DataRow dr = dtProducFlag.NewRow();
                dr.ItemArray = obj;
                dtProducFlag.Rows.InsertAt(dr, 0);
            }
            BaseMethod.InitComboEditor(TxtProductFlag, dtProducFlag, "BASENAME", "BASECODE");
            BaseMethod.InitComboEditor(proFalg, dtProducFlag, "BASENAME", "BASECODE");
            BaseHelper.SetComboItemHeight(TxtProductFlag);
            //材料状态
            DataTable dtMagstatus = ServerHelper.GetData("com.steering.pss.ydm.Report.FrmMatResume.queryMaterialStatusflag", null, ob);
            if (dtMagstatus.Rows.Count > 0)
            {
                Object[] obj = new Object[] { "", "" };
                DataRow dr = dtMagstatus.NewRow();
                dr.ItemArray = obj;
                dtMagstatus.Rows.InsertAt(dr, 0);
            }
            BaseMethod.InitComboEditor(TxtMagstatus, dtMagstatus, "BASENAME", "BASECODE");
            BaseMethod.InitComboEditor(matFalg, dtMagstatus, "BASENAME", "BASECODE");
            BaseHelper.SetComboItemHeight(TxtMagstatus);
        }
        public override void ToolBar_Click(object sender, string ToolbarKey)
        {
            switch (ToolbarKey)
            {
                case "DoQuery":
                    DoQuery();
                    break;
                case "Export"://导出
                    GridHelper.ulGridToExcel(ultraGrid1, "库存履历报表");
                    break;
                case "DoClose":
                    this.Close();
                    break;
            }
        }
        /// <summary>
        /// 查询
        /// </summary>
        private void DoQuery()
        {
            if (!QueryValure()) return;
            string Start = "1900-01-01 00:00:00";
            string End = "9900-01-01 00:00:00";
            string ordNo = "";
            string juNo = "";
            string bejNo = "";
            string proFlag = "";
            string matFlag = "";
            string fillFlag = "";
            if (chkDate.Checked)
            {
                Start = StartTime.Value.ToString();
                End = EndTime.Value.ToString();
            }
            if (chkOrder.Checked) { ordNo = cmbOrder.Text.ToString(); }
            if (chkJudge.Checked) { juNo = cmbJudge.Text.ToString(); }
            if (chkDepartMent.Checked) { bejNo = cmbDepartMent.Value.ToString(); }
            if (chkProductFlag.Checked)
            {
                if (TxtProductFlag.Text != "")
                {
                    proFlag = TxtProductFlag.Value.ToString();
                }
            }
            if (chkMatstatus.Checked)
            {
                if (TxtMagstatus.Text != "")
                {
                    matFlag = TxtMagstatus.Value.ToString();
                }
            }
            if (chkFill.Checked) { fillFlag = cmbFillFalg.Value.ToString(); }

            ArrayList list = new ArrayList();
            list.Add(Start);
            list.Add(End);
            list.Add(ordNo);
            list.Add(juNo);
            list.Add(bejNo);
            list.Add(proFlag);
            list.Add(matFlag);
            list.Add(fillFlag);
            string supplyUnit = this.CustomInfo;
            List<MatZcTrackEntity> listSource = EntityHelper.GetData<MatZcTrackEntity>(
           "com.steering.pss.ydm.Report.FrmMatResume.doQuery", new object[] { list , supplyUnit }, this.ob);
            MatZcTrackEntitySource1.DataSource = listSource;
           // GridHelper.RefreshAndAutoSize(ultraGrid1);
        }

        private void TxtProductFlag_ValueChanged(object sender, EventArgs e)
        {
            if (TxtProductFlag.Text == "")
            {
                DataTable dtMagstatus = ServerHelper.GetData("com.steering.pss.ydm.Report.FrmMatResume.queryMaterialStatusflag", null, ob);
                if (dtMagstatus.Rows.Count > 0)
                {
                    Object[] obj = new Object[] { "", "" };
                    DataRow dr = dtMagstatus.NewRow();
                    dr.ItemArray = obj;
                    dtMagstatus.Rows.InsertAt(dr, 0);
                }
                BaseMethod.InitComboEditor(TxtMagstatus, dtMagstatus, "BASENAME", "BASECODE");
                BaseHelper.SetComboItemHeight(TxtMagstatus);
            }
            else
            {
                string value = TxtProductFlag.Value.ToString();
                DataTable dt = ServerHelper.GetData("com.steering.pss.ydm.pipemanage.FrmPipeInventoryIn.getmagStatus", new object[] { value }, this.ob);
                if (dt.Rows.Count > 0)
                {
                    Object[] obj = new Object[] { "", "" };
                    DataRow dr = dt.NewRow();
                    dr.ItemArray = obj;
                    dt.Rows.InsertAt(dr, 0);
                }
                BaseMethod.InitComboEditor(TxtMagstatus, dt, "BASENAME", "BASECODE");
                BaseHelper.SetComboItemHeight(TxtMagstatus);
            }

        }

        private void chkDate_CheckedChanged(object sender, EventArgs e)
        {
            if (chkDate.Checked) { StartTime.Enabled = true; EndTime.Enabled = true; } else { StartTime.Enabled = false; EndTime.Enabled = false; }
            if (chkOrder.Checked) { cmbOrder.Enabled = true; } else { cmbOrder.Enabled = false; }
            if (chkJudge.Checked) { cmbJudge.Enabled = true; } else { cmbJudge.Enabled = false; }
            if (chkDepartMent.Checked) { cmbDepartMent.Enabled = true; } else { cmbDepartMent.Enabled = false; }
            if (chkProductFlag.Checked) { TxtProductFlag.Enabled = true; } else { TxtProductFlag.Enabled = false; }
            if (chkMatstatus.Checked) { TxtMagstatus.Enabled = true; } else { TxtMagstatus.Enabled = false; }
            if (chkFill.Checked) { cmbFillFalg.Enabled = true; } else { cmbFillFalg.Enabled = false; }
           
        }
        private bool QueryValure()
        {
            if (DataTimeUtil.JudgeTime(DateTime.Parse(StartTime.Value.ToString()), DateTime.Parse(EndTime.Value.ToString())) == 0)
            {
                MessageUtil.ShowTips("您所选择的日期区域不对,请重新选择！");
                return false;
            }

            if (chkOrder.Checked && string.IsNullOrEmpty(cmbOrder.Text.Trim()))
            {
                MessageBox.Show("请输入合同号！", "提示", MessageBoxButtons.OK, MessageBoxIcon.Warning);
                return false;
            }
            if (chkJudge.Checked && string.IsNullOrEmpty(cmbJudge.Text.Trim()))
            {
                MessageBox.Show("请输入炉号！", "提示", MessageBoxButtons.OK, MessageBoxIcon.Warning);
                return false;
            }
            if (chkDepartMent.Checked && string.IsNullOrEmpty(cmbDepartMent.Text.Trim()))
            {
                MessageBox.Show("请选择销售组织！", "提示", MessageBoxButtons.OK, MessageBoxIcon.Warning);
                return false;
            }
            if (chkFill.Checked && string.IsNullOrEmpty(cmbFillFalg.Text.Trim()))
            {
                MessageBox.Show("请选择是否补量！", "提示", MessageBoxButtons.OK, MessageBoxIcon.Warning);
                return false;
            }
            return true;
        }
    }
}