MES_Client/TGMES/Core.StlMes.Client.YdmPipeManage/半成品作业管理/FrmSemiFinish.cs

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.YdmBase;
using Core.StlMes.Client.YdmPipeManage.Dialog;
using Core.StlMes.Client.YdmPipeManage.Entity;
using Core.StlMes.Client.YdmPipeManage.Tool;
using CoreFS.CA06;
using Infragistics.Win.UltraWinGrid;
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;

namespace Core.StlMes.Client.YdmPipeManage
{
    public partial class FrmSemiFinish : FrmBase
    {
        private PlnOrderZgSEntity plnOrdZgStity;
        public FrmSemiFinish()
        {
            InitializeComponent();
        }

        private string proPlanId = "";//轧管排产订单号
        private string gxPlanNo = "";//工序生产序号
        private void FrmSemiFinish_Load(object sender, EventArgs e)
        {
            this.RegStartTime.Value = DateTime.Parse(new DateTime(DateTime.Now.Year, DateTime.Now.Month, 1).ToString());
            DateTime d1 = new DateTime(DateTime.Now.Year, DateTime.Now.Month, 1);
            this.RegEndTime.Value = DateTime.Parse(d1.AddMonths(1).AddDays(-1).ToString("yyyy-MM-dd") + " 23:59:59");
            EntityHelper.ShowGridCaption<YdmZcInlistEntity>(this.ultraGrid1.DisplayLayout.Bands[0]);
            InitBase();
            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", "销售出厂");
        }
        /// <summary>
        /// 加载基础信息
        /// </summary>
        private void InitBase()
        {
            YdmBaseClass.InitComboEditor(TxtStorage, "com.steering.pss.ydm.pipemanage.CorePipeInTemp.getStorageDetail", "STORAGE_NO", this.ob, false);
            //BaseMethod.InitPline(TxtPline, this.ob);
            BaseMethod.InitProcduce(TxtProduc, this.ob);//品名
            BaseMethod.InitStdStyle(TxtStdStyle, this.ob);//标准类别
            BaseMethod.InitMaterial(TxtMaterial, this.ob);//物料码
            BaseMethod.InitStdName(TxtStdName, this.ob);//标准
            //BaseMethod.InitProducFlagCom(TxtProductFlag, this.ob);
            BaseMethod.InitSourse(TxtSourse, this.ob, "2010");
            BaseMethod.InitMapStatusCom(TxtMagstatus, this.ob);
            BaseMethod.InitGrade(TxtGrade, this.ob);
            BaseMethod.InitSpec(TxtSpcName, this.ob);
            BaseMethod.InitModel(TxtModel, this.ob);

            this.TxtProductFlag.SelectedIndex = 0;
            this.TxtMagstatus.SelectedIndex = 0;
            //this.TxtBelongCode.SelectedIndex = 0;
            //this.TxtSourse.SelectedIndex = 0;

            if (this.CustomInfo.ToString2().Contains("120504"))
            {
                this.TxtBelongCode.SelectedIndex = 1;
                this.TxtPline.SelectedIndex = 2;
            }
            else
            {
                this.TxtBelongCode.SelectedIndex = 0;
                this.TxtPline.SelectedIndex = 0;
            }
        }
        /// <summary>
        /// 重写基类方法
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="ToolbarKey"></param>
        public override void ToolBar_Click(object sender, string ToolbarKey)
        {
            switch (ToolbarKey)
            {
                case "Query":
                    QueryInListData();
                    break;
                case "Add":
                    addInListData();
                    break;
                case "canceAdd":
                    canceAddData();
                    break;
                case "Export":
                    exportData();
                    break;
                case "Close":
                    this.Close();
                    break;
            }
        }
        /// <summary>
        /// 查询外购管手工入库信息
        /// </summary>
        private void QueryInListData()
        {
            string jugeNo = "";
            string regStartTim = "";
            string regEndTim = "";
            if(this.chkRegTime.Checked)
            {
                regStartTim = this.RegStartTime.Value.ToString("yyyy-MM-dd HH:mm:ss");
                regEndTim = this.RegEndTime.Value.ToString("yyyy-MM-dd HH:mm:ss");
            }
            if (this.chkFurnace.Checked)
            {
                if (this.txtFurnace.Text.Trim() == "")
                {
                    MessageUtil.ShowTips("炉号不能为空!");
                    return;
                }
                else
                {
                    jugeNo = this.txtFurnace.Text.Trim();
                }
            }
            List<YdmZcInlistEntity> listSource = EntityHelper.GetData<YdmZcInlistEntity>(
         "com.steering.pss.ydm.pipemanage.FrmSemiFinish.doQueryInListWg", new object[] { regStartTim, regEndTim, jugeNo }, ob);
            YdmZcInlistEntitybindingSource.DataSource = listSource;
        }
        /// <summary>
        /// 新增外购管入库信息
        /// </summary>
        private void addInListData()
        {
            YdmZcInlistEntity ydmEntity = GetAddData();
            string errMessage = CheckData(ydmEntity);
            if (errMessage.Length > 0)
            {
                MessageUtil.ShowWarning(errMessage);
                return;
            }
            string ydmTity = JSONFormat.Format(ydmEntity);
            string plnOrdZgEntity = JSONFormat.Format(plnOrdZgStity);
            if (MessageUtil.ShowYesNoAndQuestion("是否进行手工入库?") == DialogResult.No)
            {
                return;
            }
            CoreClientParam ccp = new CoreClientParam();
            ccp.ServerName = "com.steering.pss.ydm.pipemanage.FrmSemiFinish";
            ccp.MethodName = "doAddInListData";
            ccp.ServerParams = new object[] { ydmTity, plnOrdZgEntity };
            ccp = this.ExecuteNonQuery(ccp, CoreInvokeType.Internal);
            if (ccp.ReturnCode != -1)
            {
                if (ccp.ReturnInfo.Equals("入库成功!"))
                {
                    QueryInListData();
                    MessageUtil.ShowTips(ccp.ReturnInfo);
                }
                else
                {
                    MessageUtil.ShowTips(ccp.ReturnInfo);
                }
            }
        }
        /// <summary>
        /// 撤销手工入库
        /// </summary>
        private void canceAddData()
        {
            this.ultraGrid1.UpdateData();
            UltraGridRow uRow = this.ultraGrid1.ActiveRow;
            if (uRow == null) return;
            YdmZcInlistEntity ydmZcinListTity = (YdmZcInlistEntity)uRow.ListObject;
            string ydmZcEntity = JSONFormat.Format(ydmZcinListTity);
            if (MessageUtil.ShowYesNoAndQuestion("是否确认撤销?") == DialogResult.No) return;
            CoreClientParam ccp = new CoreClientParam();
            ccp.ServerName = "com.steering.pss.ydm.pipemanage.FrmSemiFinish";
            ccp.MethodName = "doCancelInList";
            ccp.ServerParams = new object[] { ydmZcEntity };
            ccp = ob.ExecuteNonQuery(ccp, CoreInvokeType.Internal);
            if (ccp.ReturnCode != -1)
            {
                if (ccp.ReturnInfo.Equals("撤销成功!"))
                {
                    QueryInListData();
                    MessageUtil.ShowTips(ccp.ReturnInfo);
                }
                else
                {
                    MessageUtil.ShowTips(ccp.ReturnInfo);
                }
            }
        }
        /// <summary>
        /// 导出
        /// </summary>
        private void exportData()
        {
            GridHelper.ulGridToExcel(this.ultraGrid1, "外购管手工缴库实绩");
        }


        private YdmZcInlistEntity GetAddData()
        {
            YdmZcInlistEntity entity = new YdmZcInlistEntity();
            entity.InstockTypeCode = "800701";
            entity.InstockTypeName = "产出入库";
            entity.LotNo = txtLotNo.Text.Trim();
            entity.JudgeStoveNo = txtJudgeStoveNo.Text.Trim();
            entity.StoveNo = txtStoveNo.Text.Trim() == "" ? txtJudgeStoveNo.Text.Trim() : txtStoveNo.Text.Trim();
            entity.FlagStoveNoZg = txtFlagStoveNoZg.Text.Trim() == "" ? txtJudgeStoveNo.Text.Trim() : txtFlagStoveNoZg.Text.Trim();
            entity.BatchNo = TxtBathNo.Text.Trim();
            //entity.BatchGroudNo = "1";
            entity.MaterialNo = TxtMaterial.Value == null ? "" : TxtMaterial.Value.ToString();
            entity.MaterialName = TxtMaterial.Text;
            entity.Produccode = TxtProduc.Value == null ? "" : TxtProduc.Value.ToString();
            entity.Producname = TxtProduc.Text;
            entity.StdCode = TxtStdName.Value == null ? "" : TxtStdName.Value.ToString();
            entity.StdName = TxtStdName.Text;
            entity.Steelcode = TxtSteelCode.Tag == null ? "" : TxtSteelCode.Tag.ToString();
            entity.Steelname = TxtSteelCode.Text;
            entity.StdStyle = TxtStdStyle.Value == null ? "" : TxtStdStyle.Value.ToString();
            entity.StdStyleDesc = TxtStdStyle.Text;
            entity.SpecCode = TxtSpcName.Value == null ? "" : TxtSpcName.Value.ToString();
            entity.SpecName = TxtSpcName.Text;
            entity.ModelCode = TxtModel.Value == null ? "" : TxtModel.Value.ToString();
            entity.ModelDesc = TxtModel.Text;
            entity.PlineCode = TxtPline.Value == null ? "" : TxtPline.Value.ToString();
            entity.PlineName = TxtPline.Text;
            //if (decimal.Parse(TxtSpcName.Text.Trim().ToString3()) > 0)
            //{
                entity.ActDimater = decimal.Parse(TxtSpcName.Value == null?"0":TxtSpcName.Text.Trim().ToString3().Substring(0, TxtSpcName.Text.IndexOf("x")));
                entity.ActHeight = decimal.Parse(TxtSpcName.Value == null?"0":TxtSpcName.Text.Trim().Substring(TxtSpcName.Text.IndexOf("x") + 1));
            //}
            entity.ActLenMax = decimal.Parse(TxtMax.Value == null ? "" : TxtMax.Value.ToString());
            entity.ActLenMin = decimal.Parse(TxtMin.Value == null ? "" : TxtMin.Value.ToString());
            entity.ActCount = decimal.Parse(TxtNum.Text.Trim());
            entity.ActWeight = decimal.Parse(TxtActWgt.Value == null ? "" : TxtActWgt.Value.ToString());
            entity.ActLen = decimal.Parse(TxtActLen.Value == null ? "" : TxtActLen.Value.ToString());
            //entity.ActTheoryWeight = TxtWgt.Value == null ? "" : TxtWgt.Value.ToString();
            entity.BelongCode = TxtBelongCode.Value == null ? "" : TxtBelongCode.Value.ToString();
            entity.BelongName = TxtBelongCode.Text;
            entity.StorageNo = TxtStorage.Value == null ? "" : TxtStorage.Value.ToString();
            entity.StorageName = TxtStorage.Text;
            entity.LocationNo = TxtLocation.Value == null ? "" : TxtLocation.Value.ToString();
            entity.CreateName = UserInfo.GetUserName();
            entity.Memo = ultraTextEditor1.Text.Trim();
            entity.MatOriginCode = TxtSourse.Value == null ? "" : TxtSourse.Value.ToString();
            entity.MatOriginName = TxtSourse.Text;
            entity.MatStatus = TxtMagstatus.Value == null ? "" : TxtMagstatus.Value.ToString();
            entity.ProductFlag = TxtProductFlag.Value == null ? "" : TxtProductFlag.Value.ToString();
            entity.Gradecode = TxtGrade.Value == null?"":TxtGrade.Value.ToString();
            entity.Gradename = TxtGrade.Text;
            entity.BalYearMonth = DateTime.Now.ToString("yyyyMM");
            entity.SoureCode = TxtPline.Value == null ? "" : TxtPline.Value.ToString();
            entity.SoureName = TxtPline.Text;
            entity.Target = txtTarget.Text;
            return entity;

        }


        /// <summary>
        /// 验证数据
        /// </summary>
        /// <returns></returns>
        private string CheckData(YdmZcInlistEntity entity)
        {
            if (this.TxtProduc.Text == "")
            {
                return "品名不能为空!";
            }
            if (this.TxtSteelCode.Text == "")
            {
                return "钢级不能为空!";
            }
            if (this.TxtStdName.Text == "")
            {
                
                return "标准名称不能为空!";
            }
            if (this.TxtSpcName.SelectedItem == null)
            {
                
                return "规格不能为空!";
            }
            if (this.TxtGrade.SelectedItem == null)
            {
                
                return "钢种不能为空!";
            }
            if (this.TxtModel.SelectedItem == null)
            {
                
                return "扣型不能为空!";
            }
            
            if (this.TxtProductFlag.Text == "")
            {
                
                return "材料类别不能为空!";
            }
            if (this.TxtMagstatus.Text == "")
            {
                
                return "材料状态不能为空!";
            }
            if (this.TxtMax.Text == "")
            {

                return "长度上限不能为空!";
            }
            if (this.TxtMin.Text == "")
            {
                
                return "长度下限不能为空!";
            }
            if (this.TxtSourse.Text == "")
            {
               
                return "材料来源不能为空!";
            }
            if (this.TxtNum.Text.Trim() == "0")
            {
                
                return "支数不能为0!";
            }
            if (this.TxtActWgt.Text.Trim() == "0.000")
            {
                
                return "重量不能为0!";
            }
            if (this.TxtBelongCode.Text == "")
            {
                return "产权单位不能为空!";
            }

            if (this.txtJudgeStoveNo.Text == "")
            {
                return "炉号不能为空!";
            }
            if (this.TxtBathNo.Text == "")
            {
                
                return "批号不能为空!";
            }
            if (this.TxtStorage.Text == "")
            {
                
                return "仓库名称不能为空!";
            }
            if (this.TxtPline.Text == "")
            {
                MessageUtil.ShowTips("产线不能为空!");
                return "产线不能为空!";
            }
            return "";
        }
        private void chkRegTime_CheckedChanged(object sender, EventArgs e)
        {
            this.RegStartTime.Enabled = this.RegEndTime.Enabled = this.chkRegTime.Checked;
        }

        private void chkFurnace_CheckedChanged(object sender, EventArgs e)
        {
            this.txtFurnace.Enabled = this.chkFurnace.Checked;
        }

        private void TxtProductFlag_ValueChanged(object sender, EventArgs e)
        {
            string flag = "";
            if (this.TxtProductFlag.Value.ToString() == "801401")
            {
                flag = "801501";
            }
            else if (this.TxtProductFlag.Value.ToString() == "801402")
            {
                flag = "801502";
            }
            else if (this.TxtProductFlag.Value.ToString() == "801403")
            {
                flag = "801503";
            }
            BaseMethod.InitMapStatusCom(TxtMagstatus, ob, flag);
        }

        private void button1_Click(object sender, EventArgs e)
        {
            FrmPlnOrdZgS frmMaterialDialog = new FrmPlnOrdZgS(this.ob);
            frmMaterialDialog.ShowDialog();
            PlnOrderZgSEntity pscEntity = frmMaterialDialog.PlnOrderZgTity;
            if (pscEntity == null)
            {
                return;
            }
            TxtMaterial.Tag = pscEntity.OutwlId.ToString();
            TxtMaterial.Text = pscEntity.OutwlDesc.ToString();
            TxtSteelCode.Tag = pscEntity.Steelcode.ToString();
            TxtSteelCode.Text = pscEntity.Steelname.ToString();
            this.TxtGrade.Tag = pscEntity.Gradecode.ToString();
            TxtGrade.Text = pscEntity.Gradename.ToString();


            TxtProduc.Tag = pscEntity.Produccode.ToString2();
            TxtProduc.Text = pscEntity.Producname.ToString2();
            TxtStdStyle.Tag = pscEntity.StdStyle.ToString();
            TxtStdStyle.Text = pscEntity.StdStyleDesc.ToString();
            TxtSpcName.Tag = pscEntity.SpecCode.ToString();
            TxtSpcName.Text = pscEntity.SpecName.ToString();
            TxtModel.Tag = pscEntity.ModelCode.ToString();
            TxtModel.Text = pscEntity.ModelDesc.ToString();
            TxtStdName.Tag = pscEntity.StdCode.ToString();
            TxtStdName.Text = pscEntity.StdName.ToString();
            TxtPline.Tag = pscEntity.PlineCode.ToString();
            TxtPline.Text = pscEntity.PlineName.ToString();
            txtTarget.Text = pscEntity.Decision.ToString();
            //proPlanId = pscEntity.ProPlanId.ToString();
            //gxPlanNo = pscEntity.GxPlanNo.ToString();
            plnOrdZgStity = pscEntity;
        }

        private void TxtPline_ValueChanged(object sender, EventArgs e)
        {
            if (this.TxtPline.Value.ToString() == "C065")
            {
                this.txtTarget.Text = "B";
            }
            else if (this.TxtPline.Value.ToString() == "C066")
            {
                this.txtTarget.Text = "C";
            }
            else if (this.TxtPline.Value.ToString() == "C098")
            {
                this.TxtBelongCode.Value = "002023005";
                this.txtTarget.Text = "B";
            }
            else if (this.TxtPline.Value.ToString() == "C099")
            {
                this.TxtBelongCode.Value = "002023005";
                this.txtTarget.Text = "C";
            }
        }

        private void txtTarget_ValueChanged(object sender, EventArgs e)
        {
            if (this.txtTarget.Value.ToString2() == "B")
            {
                this.TxtPline.Value = "002001001".Equals(this.TxtBelongCode.Value.ToString2()) ? "C065" : "C098";
            }
            else if (this.txtTarget.Value.ToString2() == "C")
            {
                this.TxtPline.Value = "002001001".Equals(this.TxtBelongCode.Value.ToString2()) ? "C066" : "C099"; 
            }
        }

        private void TxtStorage_ValueChanged(object sender, EventArgs e)
        {
            DataTable dt = ServerHelper.GetData("com.steering.pss.ydm.base.CoreLocationDefine.doQuery", new Object[] { false, TxtStorage.SelectedItem.DataValue }, this.ob);
            if (dt != null && dt.Rows.Count > 0)
            {
                if (false)
                {
                    Object[] obj = new Object[] { "", "" };
                    DataRow dr = dt.NewRow();
                    dr.ItemArray = obj;
                    dt.Rows.InsertAt(dr, 0);
                }
                TxtLocation.DataSource = dt;
                TxtLocation.ValueMember = "LOCATION_NO";
                TxtLocation.DisplayMember = "LOCATION_NAME";
                YdmBaseClass.SetComboItemHeight(TxtLocation);
            }
        }
    }
}