MES_Client/TGMES/Core.StlMes.Client.YdmPipeManage/01.公共作业/FrmScrapOutList.cs

using com.steering.pss.ydm.entity;
using Core.Mes.Client.Comm.Control;
using Core.Mes.Client.Comm.Format;
using Core.Mes.Client.Comm.Server;
using Core.Mes.Client.Comm.Tool;
using Core.StlMes.Client.YdmPipeManage.Entity;
using Core.StlMes.Client.YdmPipeManage.Tool;
using CoreFS.CA06;
using Infragistics.Win;
using Infragistics.Win.UltraWinGrid;
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.YdmPipeManage
{
    public partial class FrmScrapOutList : FrmBase
    {
        public FrmScrapOutList()
        {
            InitializeComponent();
        }

        private void FrmScrapOutList_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);//当月最后一天
            this.StartTime.Value = DateTime.Parse(dt1.ToString("yyyy-MM-dd") + " 00:00:00");
            this.EndTime.Value = DateTime.Parse(dt2.ToString("yyyy-MM-dd") + " 23:59:59");
            EntityHelper.ShowGridCaption<MatZcMEntity>(ultraGrid1.DisplayLayout.Bands[0]);
            EntityHelper.ShowGridCaption<YdmZcOutlistEntity>(ultraGrid2.DisplayLayout.Bands[0]);
            initCloum();
        }
        /// <summary>
        /// 绑定列
        /// </summary>
        private void initCloum()
        {
            //材料状态
            this.ultraGrid1.DisplayLayout.ValueLists[0].ValueListItems.Add("80150101", "材料产出待判");
            this.ultraGrid1.DisplayLayout.ValueLists[0].ValueListItems.Add("80150102", "材料管理封锁");
            this.ultraGrid1.DisplayLayout.ValueLists[0].ValueListItems.Add("80150103", "材料质量封锁");
            this.ultraGrid1.DisplayLayout.ValueLists[0].ValueListItems.Add("80150104", "材料可编计划");
            this.ultraGrid1.DisplayLayout.ValueLists[0].ValueListItems.Add("80150105", "材料已编计划");
            this.ultraGrid1.DisplayLayout.ValueLists[0].ValueListItems.Add("80150106", "材料为余材");

            this.ultraGrid1.DisplayLayout.ValueLists[0].ValueListItems.Add("80150201", "材料产出等待（未综合判定）");
            this.ultraGrid1.DisplayLayout.ValueLists[0].ValueListItems.Add("80150202", "材料产出（已综合判定");
            this.ultraGrid1.DisplayLayout.ValueLists[0].ValueListItems.Add("80150203", "材料为余材（已综合判定）");
            this.ultraGrid1.DisplayLayout.ValueLists[0].ValueListItems.Add("80150204", "材料脱单余材(销售组织脱单)");
            this.ultraGrid1.DisplayLayout.ValueLists[0].ValueListItems.Add("80150205", "材料缴库余材(销售组织缴库)");

            this.ultraGrid1.DisplayLayout.ValueLists[0].ValueListItems.Add("80150301", "材料可编提单");
            this.ultraGrid1.DisplayLayout.ValueLists[0].ValueListItems.Add("80150302", "材料已编提单");
            this.ultraGrid1.DisplayLayout.ValueLists[0].ValueListItems.Add("80150303", "销售出厂");
            //材料类别
            this.ultraGrid1.DisplayLayout.ValueLists[1].ValueListItems.Add("801401", "在制品");
            this.ultraGrid1.DisplayLayout.ValueLists[1].ValueListItems.Add("801402", "成品");
            this.ultraGrid1.DisplayLayout.ValueLists[1].ValueListItems.Add("801403", "商品");

        }

        /// <summary>
        /// 重写基类方法
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="ToolbarKey"></param>
        public override void ToolBar_Click(object sender, string ToolbarKey)
        {
            switch (ToolbarKey)
            {
                case "DoQuery":
                    doQueryMat();
                    break;
                case"DoQueryOut":
                    doQueryOut();
                    break;
                case"scrapMat":
                    scrapMat();
                    break;
                case "PrintOut":
                    printOutList();
                    break;
                case "PrintSettle":
                    printSettle();
                    break;
                case"cancelScrapMat":
                    cancelScrapMat();
                    break;
                case"ExportExcel":
                    exportExcel();
                    break;
                case "Close":
                    this.Close();
                    break;
            }
        }
        /// <summary>
        /// 导出
        /// </summary>
        private void exportExcel()
        {
            GridHelper.ulGridToExcel(ultraGrid2, "回废出库汇总");
        }
        /// <summary>
        /// 打印结算单
        /// </summary>
        private void printSettle()
        {
            this.ultraGrid2.UpdateData();
            IQueryable<UltraGridRow> checkMagRows = this.ultraGrid2.Rows.AsQueryable().Where(" CHK = 'True'");
            string outDoc = "";
            if(checkMagRows.Count() == 0)
            {
                MessageUtil.ShowTips("请选择需要打印的出库单号");
                return;
            }
            foreach (UltraGridRow uRow in checkMagRows)
            {
                outDoc = uRow.Cells["OutstockDoc"].Value.ToString();
            }
            int m = checkMagRows.GroupBy(a => a.GetValue("OutstockDoc")).Count();
            if (m > 1)
            {
                MessageUtil.ShowTips("不是同一出库单号,不允许打印!");
                return;
            }

            string strurl = "http://172.54.10.42:8080/webroot/decision/view/report?viewlet=RepInvoiceTicketYM.cpt" + "&OUTSTOCK_DOC=" + outDoc;
            BillDocPrintExcel fBug = new BillDocPrintExcel(ob, strurl);

            fBug.AutoSize = true;
            fBug.MaximumSize = new Size(Screen.PrimaryScreen.WorkingArea.Width, Screen.PrimaryScreen.WorkingArea.Height);
            fBug.Text = "出库单打印";
            fBug.ShowDialog();
            fBug.StartPosition = FormStartPosition.CenterScreen;
        }
        /// <summary>
        /// 打印出库单
        /// </summary>
        private void printOutList()
        {
            this.ultraGrid2.UpdateData();
            IQueryable<UltraGridRow> checkMagRows = this.ultraGrid2.Rows.AsQueryable().Where(" CHK = 'True'");
            string outDoc = "";
            if (checkMagRows.Count() == 0)
            {
                MessageUtil.ShowTips("请选择需要打印的出库单号");
                return;
            }
            foreach (UltraGridRow uRow in checkMagRows)
            {
                outDoc = uRow.Cells["OutstockDoc"].Value.ToString();
            }
            int m = checkMagRows.GroupBy(a => a.GetValue("OutstockDoc")).Count();
            if (m > 1)
            {
                MessageUtil.ShowTips("不是同一出库单号,不允许打印!");
                return;
            }

            string strurl = "http://172.54.10.42:8080/webroot/decision/view/report?viewlet=RepYdmOutboundorderYM.cpt" + "&OUTSTOCK_DOC=" + outDoc;
            BillDocPrintExcel fBug = new BillDocPrintExcel(ob, strurl);

            fBug.AutoSize = true;
            fBug.MaximumSize = new Size(Screen.PrimaryScreen.WorkingArea.Width, Screen.PrimaryScreen.WorkingArea.Height);
            fBug.Text = "出库单打印";
            fBug.ShowDialog();
            fBug.StartPosition = FormStartPosition.CenterScreen;
        }
        /// <summary>
        /// 查询库存信息
        /// </summary>
        private void doQueryMat()
        {
            
            string intimeStart = "";     //缴库起始时间
            string intimeEnd = "";     //缴库结束时间
            string stoveno = "";      //炉号
            string supplyUnit = this.CustomInfo;
            if (this.chkTim.Checked)
            {
                intimeStart = StartTime.Value.ToString();
                intimeEnd = EndTime.Value.ToString();
            }
            if (this.chkJugeHeatNo.Checked)
            {
                if (this.txtJugeNo.Text.Trim() == "")
                {
                    MessageUtil.ShowTips("炉号不能为空，请选择！");
                    return;
                }
                stoveno = txtJugeNo.Text.Trim();
            }
            
            if (DateTime.Parse(StartTime.Value.ToString()) > DateTime.Parse(EndTime.Value.ToString()))
            {
                MessageUtil.ShowTips("开始时间不能大于结束时间！");
                return;
            }
            string[] arr = BaseMethod.InitPermissions(this.ValidDataPurviewIds, ob);
            List<MatZcMEntity> listSource = EntityHelper.GetData<MatZcMEntity>(
            "com.steering.pss.ydm.pipemanage.FrmScrapOutList.doQueryMat", new object[] { intimeStart, intimeEnd, stoveno, arr , supplyUnit }, this.ob);
            MatZcMEntitybindingSource.DataSource = listSource;

        }
        /// <summary>
        /// 查询作废出库信息
        /// </summary>
        private void doQueryOut()
        {
            string intimeStart = "";     //出库起始时间
            string intimeEnd = "";     //出库结束时间
            string stoveno = "";      //炉号
            string supplyUnit = this.CustomInfo;
            if (this.chkTim.Checked)
            {
                intimeStart = StartTime.Value.ToString();
                intimeEnd = EndTime.Value.ToString();
            }
            if (this.chkJugeHeatNo.Checked)
            {
                if (this.txtJugeNo.Text.Trim() == "")
                {
                    MessageUtil.ShowTips("炉号不能为空，请选择！");
                    return;
                }
                stoveno = txtJugeNo.Text.Trim();
            }

            if (DateTime.Parse(StartTime.Value.ToString()) > DateTime.Parse(EndTime.Value.ToString()))
            {
                MessageUtil.ShowTips("开始时间不能大于结束时间！");
                return;
            }
            string[] arr = BaseMethod.InitPermissions(this.ValidDataPurviewIds, ob);
            List<YdmZcOutlistEntity> listSource = EntityHelper.GetData<YdmZcOutlistEntity>(
            "com.steering.pss.ydm.pipemanage.FrmScrapOutList.doQueryOutList", new object[] { intimeStart, intimeEnd, stoveno, arr, supplyUnit }, this.ob);
            YdmZcOutlistEntitybindingSource.DataSource = listSource;
        }
        
        /// <summary>
        /// 剔废出库
        /// </summary>
        private void scrapMat()
        {
            this.ultraGrid1.UpdateData();
            string bathYear = DateTime.Now.ToString("yyyyMM");
            string userName = UserInfo.GetUserName();
            string createTim = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss");
            string mangamentNo = UserInfo.GetDeptid();
            string mangamentName = UserInfo.GetDepartment();
            string departMentNo = ClsBaseInfo.GetDepartIdBySectionId(this.UserInfo.GetDeptid(), this.ob);
            string departMentName = ClsBaseInfo.GetDepartBySectionId(this.UserInfo.GetDeptid(), this.ob);
            string supplyUnitCode = this.CustomInfo;
            string supplyUnit = "";
            string basecode = "1205";
            DataTable dt = ServerHelper.GetData("com.steering.pss.qcm.CoreBaseInfoNew.doQuery", new Object[] { basecode }, this.ob);
            foreach (DataRow dr in dt.Rows)
            {
                if (dr["BASECODE"].Equals(supplyUnitCode))
                {
                    supplyUnit = dr["BASENAME"].ToString2();
                }
            }
            IQueryable<UltraGridRow> checkMagRows = this.ultraGrid1.Rows.AsQueryable().Where(" CHK = 'True'");
            if (checkMagRows.Count() == 0)
            {
                MessageUtil.ShowTips("请选择需要剔废出库的库存信息!");
                return;
            }
            ArrayList parm = new ArrayList();
            foreach(UltraGridRow uRow in checkMagRows)
            {
                MatZcMEntity matZcM = (MatZcMEntity)uRow.ListObject;
                matZcM.CreateName = userName;
                matZcM.CreateTime = createTim;
                matZcM.ManagementNo = mangamentNo;
                matZcM.ManagementName = mangamentName;
                matZcM.DepartmentCode = departMentNo;
                matZcM.DepartmentDesc = departMentName;
                matZcM.BalYearMonth = bathYear;
                matZcM.SupplyUnit = supplyUnit;
                matZcM.SupplyUnitCode = supplyUnitCode;
                string matZcTity = JSONFormat.Format(matZcM);
                parm.Add(matZcTity);
            }
            if (MessageUtil.ShowYesNoAndQuestion("是否确认回废出库？") == DialogResult.No) return;
            CoreClientParam ccp = new CoreClientParam();
            ccp.ServerName = "com.steering.pss.ydm.pipemanage.FrmScrapOutList";
            ccp.MethodName = "scrapMat";
            ccp.ServerParams = new object[] { parm };
            ccp = ob.ExecuteNonQuery(ccp, CoreInvokeType.Internal);
            if (ccp.ReturnCode != -1)
            {
                if (ccp.ReturnInfo.Equals("回废成功!"))
                {
                    doQueryMat();
                    MessageUtil.ShowTips(ccp.ReturnInfo);
                }
                else
                {
                    MessageUtil.ShowTips(ccp.ReturnInfo);
                }
            }
            
        }
        
        /// <summary>
        /// 撤销剔废出库
        /// </summary>
        private void cancelScrapMat()
        {
            this.ultraGrid2.UpdateData();
            IQueryable<UltraGridRow> checkMagRows = this.ultraGrid2.Rows.AsQueryable().Where(" CHK = 'True'");
            if (checkMagRows.Count() == 0)
            {
                MessageUtil.ShowTips("请选择需要撤销回废的出库信息!");
                return;
            }
            ArrayList parm = new ArrayList();
            foreach(UltraGridRow row in checkMagRows)
            {
                YdmZcOutlistEntity ydmTity = (YdmZcOutlistEntity)row.ListObject;
                string ydmOutListEntity = JSONFormat.Format(ydmTity);
                parm.Add(ydmOutListEntity);
            }
            if (MessageUtil.ShowYesNoAndQuestion("是否确认撤销回废出库？") == DialogResult.No) return;
            CoreClientParam ccp = new CoreClientParam();
            ccp.ServerName = "com.steering.pss.ydm.pipemanage.FrmScrapOutList";
            ccp.MethodName = "cancelScrapMat";
            ccp.ServerParams = new object[] { parm };
            ccp = ob.ExecuteNonQuery(ccp, CoreInvokeType.Internal);
            if (ccp.ReturnCode != -1)
            {
                if (ccp.ReturnInfo.Equals("撤销成功!"))
                {

                    doQueryOut();
                    MessageUtil.ShowTips(ccp.ReturnInfo);
                }
                else
                {
                    MessageUtil.ShowTips(ccp.ReturnInfo);
                }
            }
        }

        private void chkTim_CheckedChanged(object sender, EventArgs e)
        {
            this.StartTime.Enabled = this.EndTime.Enabled = this.chkTim.Checked;
        }

        private void chkJugeHeatNo_CheckedChanged(object sender, EventArgs e)
        {
            this.txtJugeNo.Enabled = this.chkJugeHeatNo.Checked;
        }

        private void ultraTabControl1_SelectedTabChanged(object sender, Infragistics.Win.UltraWinTabControl.SelectedTabChangedEventArgs e)
        {
            if (toolMenu == null) return;
            if (ultraTabControl1.SelectedTab.Key == "0")
            {
                if (toolMenu.Toolbars[0].Tools.Exists("DoQueryOut"))
                {
                    toolMenu.Toolbars[0].Tools["DoQueryOut"].InstanceProps.Visible = DefaultableBoolean.False;
                }
                if (toolMenu.Toolbars[0].Tools.Exists("cancelScrapMat"))
                {
                    toolMenu.Toolbars[0].Tools["cancelScrapMat"].InstanceProps.Visible = DefaultableBoolean.False;
                }
                if (toolMenu.Toolbars[0].Tools.Exists("PrintOut"))
                {
                    toolMenu.Toolbars[0].Tools["PrintOut"].InstanceProps.Visible = DefaultableBoolean.False;
                }
                if (toolMenu.Toolbars[0].Tools.Exists("PrintSettle"))
                {
                    toolMenu.Toolbars[0].Tools["PrintSettle"].InstanceProps.Visible = DefaultableBoolean.False;
                }
                if (toolMenu.Toolbars[0].Tools.Exists("ExportExcel"))
                {
                    toolMenu.Toolbars[0].Tools["ExportExcel"].InstanceProps.Visible = DefaultableBoolean.False;
                }
                if (toolMenu.Toolbars[0].Tools.Exists("DoQuery"))
                {
                    toolMenu.Toolbars[0].Tools["DoQuery"].InstanceProps.Visible = DefaultableBoolean.True;
                }
                if (toolMenu.Toolbars[0].Tools.Exists("scrapMat"))
                {
                    toolMenu.Toolbars[0].Tools["scrapMat"].InstanceProps.Visible = DefaultableBoolean.True;
                }
                this.chkTim.Text = "入库日期";
            }
            else if (ultraTabControl1.SelectedTab.Key == "1")
            {
                if (toolMenu.Toolbars[0].Tools.Exists("DoQueryOut"))
                {
                    toolMenu.Toolbars[0].Tools["DoQueryOut"].InstanceProps.Visible = DefaultableBoolean.True;
                }
                if (toolMenu.Toolbars[0].Tools.Exists("cancelScrapMat"))
                {
                    toolMenu.Toolbars[0].Tools["cancelScrapMat"].InstanceProps.Visible = DefaultableBoolean.True;
                }
                if (toolMenu.Toolbars[0].Tools.Exists("PrintOut"))
                {
                    toolMenu.Toolbars[0].Tools["PrintOut"].InstanceProps.Visible = DefaultableBoolean.True;
                }
                if (toolMenu.Toolbars[0].Tools.Exists("PrintSettle"))
                {
                    toolMenu.Toolbars[0].Tools["PrintSettle"].InstanceProps.Visible = DefaultableBoolean.True;
                }
                if (toolMenu.Toolbars[0].Tools.Exists("ExportExcel"))
                {
                    toolMenu.Toolbars[0].Tools["ExportExcel"].InstanceProps.Visible = DefaultableBoolean.True;
                }
                if (toolMenu.Toolbars[0].Tools.Exists("DoQuery"))
                {
                    toolMenu.Toolbars[0].Tools["DoQuery"].InstanceProps.Visible = DefaultableBoolean.False;
                }
                if (toolMenu.Toolbars[0].Tools.Exists("scrapMat"))
                {
                    toolMenu.Toolbars[0].Tools["scrapMat"].InstanceProps.Visible = DefaultableBoolean.False;
                }
                this.chkTim.Text = "出库日期";
            }

        }

        private void FrmScrapOutList_Shown(object sender, EventArgs e)
        {
            if (toolMenu.Toolbars[0].Tools.Exists("DoQueryOut"))
            {
                toolMenu.Toolbars[0].Tools["DoQueryOut"].InstanceProps.Visible = DefaultableBoolean.False;
            }
            if (toolMenu.Toolbars[0].Tools.Exists("cancelScrapMat"))
            {
                toolMenu.Toolbars[0].Tools["cancelScrapMat"].InstanceProps.Visible = DefaultableBoolean.False;
            }
            if (toolMenu.Toolbars[0].Tools.Exists("PrintOut"))
            {
                toolMenu.Toolbars[0].Tools["PrintOut"].InstanceProps.Visible = DefaultableBoolean.False;
            }
            if (toolMenu.Toolbars[0].Tools.Exists("PrintSettle"))
            {
                toolMenu.Toolbars[0].Tools["PrintSettle"].InstanceProps.Visible = DefaultableBoolean.False;
            }
            if (toolMenu.Toolbars[0].Tools.Exists("ExportExcel"))
            {
                toolMenu.Toolbars[0].Tools["ExportExcel"].InstanceProps.Visible = DefaultableBoolean.False;
            }
        }

    }
}