XinYu_LG2MES/ClientSolution/Core.LgMes.Client.LgJobMgt/炼钢公共类/frmMaterialQuality.cs

using System;
using System.IO;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Diagnostics;
using System.Text;
using System.Windows.Forms;
using CoreFS.CA06;
namespace Core.LgMes.Client.LgJobMgt
{
    public partial class frmMaterialQuality : CoreFS.CA06.FrmBase
    {
        public bool blItemAdditives = false;

        public frmMaterialQuality()
        {
            InitializeComponent();
        }

        private void frmMaterialQuality_Load(object sender, EventArgs e)
        {
            //初始化时间
            uldtBeginTime.Value = DateTime.Today.ToString("yyyy-MM-dd") + " 00:00";
            uldtEndTime.Value = DateTime.Today.ToString("yyyy-MM-dd") + " 23:59"; ;

            udtUseBeginTime.Value = null;
            udtUseEndTime.Value = null;

            //获取过程添加料信息(主表)
            GetItemAdditives(); 

            ///初始化过程添加料信息(主表)
            Initialize_ulgriddAdditives();            
        }

        /// <summary>
        /// 获取过程添加料信息(主表)
        /// </summary>
        /// <param name="strWhere"></param>
        private void GetItemAdditives()
        {
            string strErr = "";
            string strWhere = "";
            
            if(ckbTime.Checked == true)
            {
                if (Convert.ToDateTime(uldtBeginTime.Value) > Convert.ToDateTime(uldtEndTime.Value))
                {
                    MessageBox.Show("时间条件的开始时间不能大于结束时间！", "提示", MessageBoxButtons.OK, MessageBoxIcon.Asterisk);
                    return;
                }
                else
                strWhere =" and constitime >=to_date('" + uldtBeginTime.Value.ToString() +
                                       "','yyyy-MM-dd HH24:mi:ss') and constitime <=to_date('" +
                                       uldtEndTime.Value.ToString() + "','yyyy-MM-dd HH24:mi:ss') " ;
            }
            if (ckbMaterialName.Checked == true)
            {
                strWhere += " and materielname like '%" + ulteMaterialName.Text + "%'";
            }

            DataSet dsItemAdditives = null;// (DataSet)ClientCommon._RemotingHelp.ExecuteMethod("lgJobMgt",
                                             //         "Core.LgMes.Server.lgJobMgt.classCommonModule",
                                               //       "GetItemAdditives", new object[] { strWhere }, out strErr);
            if (strErr == "" && dsItemAdditives != null)
            {
                ulgriddAdditives.DataSource = dsItemAdditives;
                ulgriddAdditives.DataBind();
            }
        }

        /// <summary>
        /// 获取过程添加料项目成分表(从表)
        /// </summary>
        /// <param name="MaterielCode">物料编码</param>
        /// <param name="MaterielType">物料类型</param>
        /// <param name="MaterielBno">物料批次号</param>
        /// <param name="MtrlcmpntCode">物料成分编码</param>
        /// <returns>返回过程添加料项目成分表记录集</returns>
        private void GetItemMtrlcmpnt(string strMaterielCode, string strMaterielType, string strMaterielBno)
        {
            string strErr = "";
            DataSet dsItemMtrlcmpnt = null;// (DataSet)ClientCommon._RemotingHelp.ExecuteMethod("lgJobMgt",
                                             //         "Core.LgMes.Server.lgJobMgt.classCommonModule",
                                               //       "GetItemMtrlcmpnt", new object[] {strMaterielCode,strMaterielType,strMaterielBno}, out strErr);
            if (strErr == "" && dsItemMtrlcmpnt != null)
            {
                ulgridMtrlcmpnt.DataSource = dsItemMtrlcmpnt;
                ulgridMtrlcmpnt.DataBind();
            }
        }

        /// <summary>
        /// 初始化过程添加料信息主表
        /// </summary>
        private void Initialize_ulgriddAdditives()
        {
            ulgriddAdditives.DisplayLayout.Bands[0].Columns["MATERIELBNO"].Header.Caption = "物料批次";
            ulgriddAdditives.DisplayLayout.Bands[0].Columns["MATERIELBNO"].Width = 90;
            ulgriddAdditives.DisplayLayout.Bands[0].Columns["MATERIELBNO"].CellActivation = Infragistics.Win.UltraWinGrid.Activation.NoEdit;
            ulgriddAdditives.DisplayLayout.Bands[0].Columns["MATERIELCODE"].Header.Caption = "物料编码";
            ulgriddAdditives.DisplayLayout.Bands[0].Columns["MATERIELCODE"].Width = 80;
            ulgriddAdditives.DisplayLayout.Bands[0].Columns["MATERIELCODE"].CellActivation = Infragistics.Win.UltraWinGrid.Activation.NoEdit;
            ulgriddAdditives.DisplayLayout.Bands[0].Columns["materielname"].Header.Caption = "物料名称";
            ulgriddAdditives.DisplayLayout.Bands[0].Columns["materielname"].Width = 80;
            ulgriddAdditives.DisplayLayout.Bands[0].Columns["materielname"].CellActivation = Infragistics.Win.UltraWinGrid.Activation.NoEdit;
            ulgriddAdditives.DisplayLayout.Bands[0].Columns["MATERIELTYPE"].Header.Caption = "物料类型";
            ulgriddAdditives.DisplayLayout.Bands[0].Columns["MATERIELTYPE"].Width = 80;
            ulgriddAdditives.DisplayLayout.Bands[0].Columns["MATERIELTYPE"].CellActivation = Infragistics.Win.UltraWinGrid.Activation.NoEdit;
            ulgriddAdditives.DisplayLayout.Bands[0].Columns["description"].Header.Caption = "岗位名称";
            ulgriddAdditives.DisplayLayout.Bands[0].Columns["description"].Width = 80;
            ulgriddAdditives.DisplayLayout.Bands[0].Columns["description"].CellActivation = Infragistics.Win.UltraWinGrid.Activation.NoEdit;
            ulgriddAdditives.DisplayLayout.Bands[0].Columns["description"].Hidden = true;
            ulgriddAdditives.DisplayLayout.Bands[0].Columns["MTRLCMPNTCODE"].Header.Caption = "成分编码";
            ulgriddAdditives.DisplayLayout.Bands[0].Columns["MTRLCMPNTCODE"].Width = 70;
            ulgriddAdditives.DisplayLayout.Bands[0].Columns["MTRLCMPNTCODE"].Hidden = true;
            ulgriddAdditives.DisplayLayout.Bands[0].Columns["MTRLCMPNTCODE"].CellActivation = Infragistics.Win.UltraWinGrid.Activation.NoEdit;

            ulgriddAdditives.DisplayLayout.Bands[0].Columns["FLAG"].Header.Caption = "使用情况";
            ulgriddAdditives.DisplayLayout.Bands[0].Columns["FLAG"].CellActivation = Infragistics.Win.UltraWinGrid.Activation.NoEdit;
            ulgriddAdditives.DisplayLayout.Bands[0].Columns["MTRLCMPNTCODE"].Width = 70;

            ulgriddAdditives.DisplayLayout.Bands[0].Columns["CONSTITUTOR"].Header.Caption = "制定人员";
            ulgriddAdditives.DisplayLayout.Bands[0].Columns["CONSTITUTOR"].Width = 70;
            ulgriddAdditives.DisplayLayout.Bands[0].Columns["CONSTITUTOR"].CellActivation = Infragistics.Win.UltraWinGrid.Activation.NoEdit;

            ulgriddAdditives.DisplayLayout.Bands[0].Columns["CONSTITIME"].Header.Caption = "制定时间";
            ulgriddAdditives.DisplayLayout.Bands[0].Columns["CONSTITIME"].Width = 150;
            ulgriddAdditives.DisplayLayout.Bands[0].Columns["CONSTITIME"].Format = string.Format("yyyy-MM-dd HH:mm:ss");
            ulgriddAdditives.DisplayLayout.Bands[0].Columns["CONSTITIME"].CellActivation = Infragistics.Win.UltraWinGrid.Activation.NoEdit;

            ulgriddAdditives.DisplayLayout.Bands[0].Columns["USEBEGINTIME"].Header.Caption = "使用开始";
            ulgriddAdditives.DisplayLayout.Bands[0].Columns["USEBEGINTIME"].Width = 150;
            ulgriddAdditives.DisplayLayout.Bands[0].Columns["USEBEGINTIME"].Format = string.Format("yyyy-MM-dd HH:mm:ss");
            ulgriddAdditives.DisplayLayout.Bands[0].Columns["USEBEGINTIME"].CellActivation = Infragistics.Win.UltraWinGrid.Activation.NoEdit;

            ulgriddAdditives.DisplayLayout.Bands[0].Columns["USEENDTIME"].Header.Caption = "使用结束";
            ulgriddAdditives.DisplayLayout.Bands[0].Columns["USEENDTIME"].Width = 150;
            ulgriddAdditives.DisplayLayout.Bands[0].Columns["USEENDTIME"].Format = string.Format("yyyy-MM-dd HH:mm:ss");
            ulgriddAdditives.DisplayLayout.Bands[0].Columns["USEENDTIME"].CellActivation = Infragistics.Win.UltraWinGrid.Activation.NoEdit;

            ulgriddAdditives.DisplayLayout.Bands[0].Columns["MEMO"].Header.Caption = "批次描述";
            ulgriddAdditives.DisplayLayout.Bands[0].Columns["MEMO"].Width = 200;
            ulgriddAdditives.DisplayLayout.Bands[0].Columns["MEMO"].CellActivation = Infragistics.Win.UltraWinGrid.Activation.NoEdit;

        }

        /// <summary>
        /// 初始化过程添加料项目成分表(从表)
        /// </summary>
        private void Initialize_ulgridMtrlcmpnt()
        {
            ulgridMtrlcmpnt.DisplayLayout.Bands[0].Columns["MATERIELCODE"].Header.Caption = "物料编码";
            ulgridMtrlcmpnt.DisplayLayout.Bands[0].Columns["MATERIELCODE"].Hidden = true;
            ulgridMtrlcmpnt.DisplayLayout.Bands[0].Columns["MATERIELCODE"].CellActivation = Infragistics.Win.UltraWinGrid.Activation.NoEdit;
            ulgridMtrlcmpnt.DisplayLayout.Bands[0].Columns["MATERIELTYPE"].Header.Caption = "物料类型";
            ulgridMtrlcmpnt.DisplayLayout.Bands[0].Columns["MATERIELTYPE"].Hidden = true;
            ulgridMtrlcmpnt.DisplayLayout.Bands[0].Columns["MATERIELTYPE"].CellActivation = Infragistics.Win.UltraWinGrid.Activation.NoEdit;
            ulgridMtrlcmpnt.DisplayLayout.Bands[0].Columns["MATERIELBNO"].Header.Caption = "物料批次号";
            ulgridMtrlcmpnt.DisplayLayout.Bands[0].Columns["MATERIELBNO"].Hidden = true;
            ulgridMtrlcmpnt.DisplayLayout.Bands[0].Columns["MATERIELBNO"].CellActivation = Infragistics.Win.UltraWinGrid.Activation.NoEdit;
            ulgridMtrlcmpnt.DisplayLayout.Bands[0].Columns["MTRLCMPNTCODE"].Header.Caption = "成分编码";
            ulgridMtrlcmpnt.DisplayLayout.Bands[0].Columns["MTRLCMPNTCODE"].Width = 80;
            ulgridMtrlcmpnt.DisplayLayout.Bands[0].Columns["MTRLCMPNTCODE"].CellActivation = Infragistics.Win.UltraWinGrid.Activation.NoEdit;
            ulgridMtrlcmpnt.DisplayLayout.Bands[0].Columns["MTRLCMPNTVALUE"].Header.Caption = "物料成分值";
            ulgridMtrlcmpnt.DisplayLayout.Bands[0].Columns["MTRLCMPNTVALUE"].Width = 100;
            //ulgridMtrlcmpnt.DisplayLayout.Bands[0].Columns["MTRLCMPNTVALUE"].Format = "#########.000";
            ulgridMtrlcmpnt.DisplayLayout.Bands[0].Columns["MTRLCMPNTVALUE"].CellActivation = Infragistics.Win.UltraWinGrid.Activation.NoEdit;
        }
       
        private void ckbTime_CheckedChanged(object sender, EventArgs e)
        {
            uldtBeginTime.Enabled = ckbTime.Checked;
            uldtEndTime.Enabled = ckbTime.Checked;
        }

        private void ckbMaterialName_CheckedChanged(object sender, EventArgs e)
        {
            ulteMaterialName.Enabled = ckbMaterialName.Checked;
        }

        /// <summary>
        /// 选择物料
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        private void ultxtMaterielCode_EditorButtonClick(object sender, Infragistics.Win.UltraWinEditors.EditorButtonEventArgs e)
        {
            string szMC = "";
            frmSetMaterialName frm = new frmSetMaterialName( szMC, "3");
            frm.ShowDialog();

            if (frm.bChange == true)
            {
               ultxtMaterielName.Text = frm.m_szWLMC;
               ultxtMaterielCode.Text = frm.m_szWLBM;
               ultxtMaterielType.Value = frm.m_szWLLX;
            }

        }

        private void ulgriddAdditives_Click(object sender, EventArgs e)
        {
            string strMaterielCode ="";  //物料编码
            string strMaterielType ="";  //物料类型名称
            string strMaterielBno ="";   //批次号
            string strMaterielTypeCode = "";  // 物料类型编码
            if(ulgriddAdditives.ActiveRow != null )
            {
                //查询值
                strMaterielBno = ulgriddAdditives.ActiveRow.Cells["MaterielBno"].Value.ToString();  //批次号
                strMaterielCode = ulgriddAdditives.ActiveRow.Cells["MaterielCode"].Value.ToString();//物料编码
                strMaterielType = ulgriddAdditives.ActiveRow.Cells["MaterielType"].Value.ToString();//物料类型
                strMaterielTypeCode = GetMaterielTypeCode(strMaterielType);                         //物料类型编码
    
                GetItemMtrlcmpnt(strMaterielCode, strMaterielTypeCode, strMaterielBno);  //获取过程添加料项目成分表
                Initialize_ulgridMtrlcmpnt();  //初始化过程添加料项目成分GRID

                ///设置编辑区数据
                ultxtMaterielbNo.Text = ulgriddAdditives.ActiveRow.Cells["MaterielBno"].Value.ToString();  // 批次号
                ultxtMemo.Text = ulgriddAdditives.ActiveRow.Cells["Memo"].Value.ToString();                //批次描述
                ultxtMaterielCode.Text = ulgriddAdditives.ActiveRow.Cells["MaterielCode"].Value.ToString();//物料编码
                ultxtMaterielName.Text = ulgriddAdditives.ActiveRow.Cells["MaterielName"].Value.ToString();//物料名称
                ultxtMaterielType.Value = strMaterielTypeCode;                                             //物料类型
                ultcboUser.Text = ulgriddAdditives.ActiveRow.Cells["FLAG"].Value.ToString();               //使用情况
                udtUseBeginTime.Value = ulgriddAdditives.ActiveRow.Cells["USEBEGINTIME"].Value.ToString(); //使用开始时间
                udtUseEndTime.Value = ulgriddAdditives.ActiveRow.Cells["USEENDTIME"].Value.ToString();     //使用结束时间
                ultxtMtrlcmpntCode.Text = "";                                                              //成分编码
                ultxtMtrlcmpntValue.Text = "";                                                             //成分值
            }
        }

        private void ultbrMain_ToolClick(object sender, Infragistics.Win.UltraWinToolbars.ToolClickEventArgs e)
        {
            switch (e.Tool.Key)
            {
                case "Add":
                    if (!string.IsNullOrEmpty(ultxtMaterielCode.Text) && !string.IsNullOrEmpty(ultxtMaterielbNo.Text))
                    {
                        AddItemAdditives();//增加过程添加料信息
                    }
                    else
                    {
                        MessageBox.Show("输入有效过程添加料信息。", "提示", MessageBoxButtons.OK, MessageBoxIcon.Asterisk);
                    }
                    break;
                case "Del":
                    DialogResult result;
                    if (!string.IsNullOrEmpty(ultxtMaterielbNo.Text.Trim()) && !string.IsNullOrEmpty(ultxtMaterielCode.Text.Trim()) &&
                        !string.IsNullOrEmpty(ultxtMaterielType.Text.Trim()))
                    {
                        result = MessageBox.Show("确认要删除 [批次号：" + ultxtMaterielbNo.Text + " 物料编码：" + ultxtMaterielCode.Text + " 物料名称：" + ultxtMaterielName.Text + " ] 的过程添加料信息？", "提示", MessageBoxButtons.YesNo, MessageBoxIcon.Question, MessageBoxDefaultButton.Button1);
                        if (result == DialogResult.Yes)
                        {
                            DeleteItemAdditives();
                        }
                    }
                    else
                        MessageBox.Show("没有选择要删除的过程添加料信息！", "提示", MessageBoxButtons.OK, MessageBoxIcon.Asterisk);
                    break;
                case "Modiy":
                    break;
                case "Select":                    
                    GetItemAdditives();
                    break;
                case "OutExcel":
                    if (ulgriddAdditives.Rows.Count > 0)
                    {
                        ExportExcel();
                    }
                    else
                        MessageBox.Show("没有过程添加料信息。", "提示", MessageBoxButtons.OK, MessageBoxIcon.Asterisk);
                    break;
                case "BeginUse":
                    if (ulgriddAdditives.Rows.Count > 0 && ulgriddAdditives.ActiveRow != null)
                    {
                        if (MessageBox.Show("确认要开始使用批次号[" + ulgriddAdditives.ActiveRow.Cells["MaterielbNo"].Value.ToString() + "]过程添加料？", "提示", MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.Yes)
                           ModfiyItemAdditives("1");
                    }
                    else
                        MessageBox.Show("没有选择要设置的过程添加料信息！", "提示", MessageBoxButtons.OK, MessageBoxIcon.Asterisk);
                    break;
                case "EndUse":
                    if (ulgriddAdditives.Rows.Count > 0 && ulgriddAdditives.ActiveRow != null)
                    {
                        if (MessageBox.Show("确认批次号[" + ulgriddAdditives.ActiveRow.Cells["MaterielbNo"].Value.ToString() + "]过程添加料已经用完？", "提示", MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.Yes)
                        {
                            if (!string.IsNullOrEmpty(ulgriddAdditives.ActiveRow.Cells["USEBEGINTIME"].Value.ToString()))
                                ModfiyItemAdditives("2");
                            else
                                MessageBox.Show("过程添加料没有使用不能结束使用！", "提示", MessageBoxButtons.OK, MessageBoxIcon.Asterisk);
                        }
                    }
                    else
                        MessageBox.Show("没有选择要设置的过程添加料信息！", "提示", MessageBoxButtons.OK, MessageBoxIcon.Asterisk);
                    break;
                case "NOUes":
                    if (ulgriddAdditives.Rows.Count > 0 && ulgriddAdditives.ActiveRow != null)
                    {
                        if (MessageBox.Show("确认批次号[" + ulgriddAdditives.ActiveRow.Cells["MaterielbNo"].Value.ToString() + "]过程添加料没有使用？", "提示", MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.Yes)
                            ModfiyItemAdditives("0");
                    }
                    else
                        MessageBox.Show("没有选择要设置的过程添加料信息！", "提示", MessageBoxButtons.OK, MessageBoxIcon.Asterisk);
                    break;
                case "Close":
                    this.Close();
                    break;
                default:
                    break;
            }
        }

        /// <summary>
        /// 修改物料使用情况
        /// </summary>
        /// <param name="strFlag">使用标致（0未使用、1使用、2使用完）</param>
        private void ModfiyItemAdditives(string strFlag)
        {
             string strMaterielCode = ""; 
            string strMaterielType = "";
            string strMaterielbNo = "";
            string strMaterielTypeCode = "";

            if (ulgriddAdditives.ActiveRow != null)
            {
                strMaterielCode = ulgriddAdditives.ActiveRow.Cells["MaterielCode"].Value.ToString();
                strMaterielType = ulgriddAdditives.ActiveRow.Cells["MaterielType"].Value.ToString();
                strMaterielbNo = ulgriddAdditives.ActiveRow.Cells["MaterielbNo"].Value.ToString();
                strMaterielTypeCode = GetMaterielTypeCode(strMaterielType);

                string strErr = "";
                //hengxing
                //ClientCommon._RemotingHelp.ExecuteMethod("lgJobMgt",
                //                                          "Core.LgMes.Server.lgJobMgt.classCommonModule",
                //                                          "ModfiyItemAdditives", new object[] { strMaterielCode, strMaterielTypeCode, 
                //                                          strMaterielbNo,strFlag}, out strErr);
                if (strErr != "")
                {
                    MessageBox.Show("过程添加料使用情况设置失败。", "提示", MessageBoxButtons.OK, MessageBoxIcon.Asterisk);
                }
                else
                {
                    MessageBox.Show("过程添加料使用情况设置成功！", "提示", MessageBoxButtons.OK, MessageBoxIcon.Asterisk);
                    GetItemAdditives();
                }
            }
            else
            {
                MessageBox.Show("没有选择要设置的过程添加料信息！", "提示", MessageBoxButtons.OK, MessageBoxIcon.Asterisk);
            }
        }

        /// <summary>
        /// 增加过程添加料信息
        /// </summary>
        private void AddItemAdditives()
        {
            string strMaterielCode = "";
            string strMaterielType = "";
            string strConstiTime = "";
            string strStationCode = "";
            string strMaterielbNo = "";
            string strMtrlcmpntCode = "";
            string strFlag = "";
            string strConstitutor = "";
            string strMemo = "";
           
            //物料编码
            strMaterielCode = ultxtMaterielCode.Text;  
            //物料类型
            strMaterielType = ultxtMaterielType.Value.ToString();
            //制定时间
            strConstiTime = DateTime.Now.ToString();
            //岗位编码
            strStationCode = "";
            //物料批次号
            strMaterielbNo = ultxtMaterielbNo.Text;
            //物料成分编码
            strMtrlcmpntCode = "";
            //有效标致
            strFlag = "0";
            //制定人员
            strConstitutor =this.UserInfo.GetUserName();
            
            //批次描述
            strMemo = ultxtMemo.Text;

            string strErr = "";
            //hengxing
            //ClientCommon._RemotingHelp.ExecuteMethod("lgJobMgt",
            //                                          "Core.LgMes.Server.lgJobMgt.classCommonModule",
            //                                          "AddItemAdditives", new object[] { strMaterielCode, strMaterielType, strConstiTime,
            //                                          strStationCode,strMaterielbNo,strMtrlcmpntCode,strFlag,strConstitutor,strMemo}, out strErr);
            if (strErr != "")
            {
                MessageBox.Show("保存失败！过程添加料信息已存在或输入的信息无效。", "提示", MessageBoxButtons.OK, MessageBoxIcon.Asterisk);
                blItemAdditives = true;
            }
            else
            {
                MessageBox.Show("过程添加料信息新增成功！", "提示", MessageBoxButtons.OK, MessageBoxIcon.Asterisk);
                GetItemAdditives();
                blItemAdditives = false;
            }

        }

        /// <summary>
        /// 删除过程添加料信息，并删除其从表过程添加料项目成分表
        /// </summary>
        private void DeleteItemAdditives()
        {
            string strMaterielCode = ""; 
            string strMaterielType = "";
            string strMaterielbNo = "";
            string strMaterielTypeCode = "";

            if (ulgriddAdditives.ActiveRow != null)
            {
                strMaterielCode = ulgriddAdditives.ActiveRow.Cells["MaterielCode"].Value.ToString();
                strMaterielType = ulgriddAdditives.ActiveRow.Cells["MaterielType"].Value.ToString();
                strMaterielbNo = ulgriddAdditives.ActiveRow.Cells["MaterielbNo"].Value.ToString();
                strMaterielTypeCode = GetMaterielTypeCode(strMaterielType);

                string strErr = "";
                //hengxing
                //ClientCommon._RemotingHelp.ExecuteMethod("lgJobMgt",
                //                                      "Core.LgMes.Server.lgJobMgt.classCommonModule",
                //                                      "DeleteItemAdditives", new object[] { strMaterielCode, strMaterielTypeCode, 
                //                                      strMaterielbNo}, out strErr);
                if (strErr != "")
                {
                    MessageBox.Show("删除失败！过程添加料信息不存在。", "提示", MessageBoxButtons.OK, MessageBoxIcon.Asterisk);                    
                }
                else
                {
                    MessageBox.Show("过程添加料信息删除成功！", "提示", MessageBoxButtons.OK, MessageBoxIcon.Asterisk);
                    GetItemAdditives();
                    ultxtMaterielbNo.Text = "";
                    ultxtMaterielCode.Text = "";
                    ultxtMaterielName.Text = "";
                    ultxtMaterielType.Text = "";
                    ultxtMemo.Text = "";
                    ultxtMtrlcmpntCode.Text = "";
                    ultxtMtrlcmpntValue.Text = "";
                    ultcboUser.SelectedIndex=-1;           //使用情况
                    udtUseBeginTime.Value = null; //使用开始时间
                    udtUseEndTime.Value = null;
                    GetItemMtrlcmpnt(strMaterielCode, strMaterielTypeCode, strMaterielbNo);
                }
            }
            else
            {
                MessageBox.Show("没有选择要删除的过程添加料信息！", "提示", MessageBoxButtons.OK, MessageBoxIcon.Asterisk);            
            }
        }

        /// <summary>
        /// 增加过程添加料项目成分表
        /// </summary>
        public void AddItemMtrlcmpnt()
        {
            string strMaterielCode = "";
            string strMaterielType = "";
            string strMaterielbNo = "";
            string strMtrlcmpntCode = "";
            string strMtrlcmpntValue = "";
            //物料编码
            strMaterielCode = ultxtMaterielCode.Text;
            //物料类型
            strMaterielType = ultxtMaterielType.Value.ToString();
            //物料批次号
            strMaterielbNo = ultxtMaterielbNo.Text;
            //物料成分编码
            strMtrlcmpntCode = ultxtMtrlcmpntCode.Text;
            //物料成分值
            strMtrlcmpntValue = ultxtMtrlcmpntValue.Text;

            string strErr = "";
            //hengxing
            //ClientCommon._RemotingHelp.ExecuteMethod("lgJobMgt",
            //                                          "Core.LgMes.Server.lgJobMgt.classCommonModule",
            //                                          "AddItemMtrlcmpnt", new object[] { strMaterielCode, strMaterielType, 
            //                                          strMaterielbNo,strMtrlcmpntCode,strMtrlcmpntValue}, out strErr);
            if (strErr != "")
            {
                MessageBox.Show("保存失败！过程添加料项目成分已存在或输入的信息无效。", "提示", MessageBoxButtons.OK, MessageBoxIcon.Asterisk);
            }
            else
            {
                MessageBox.Show("过程添加料信息新增成功！", "提示", MessageBoxButtons.OK, MessageBoxIcon.Asterisk);
                GetItemMtrlcmpnt(strMaterielCode, strMaterielType, strMaterielbNo);
                Initialize_ulgridMtrlcmpnt();
            }

        }

        /// <summary>
        /// 删除过程添加料项目成分表
        /// </summary>
        private void DeleteItemMtrlcmpnt()
        {
            string strMaterielCode = "";
            string strMaterielType = "";
            string strMaterielbNo = "";
            string strMtrlcmpntCode = "";
            
            strMaterielCode = ulgridMtrlcmpnt.ActiveRow.Cells["MaterielCode"].Value.ToString();
            strMaterielType = ulgridMtrlcmpnt.ActiveRow.Cells["MaterielType"].Value.ToString();
            strMaterielbNo = ulgridMtrlcmpnt.ActiveRow.Cells["MaterielbNo"].Value.ToString();
            strMtrlcmpntCode = ulgridMtrlcmpnt.ActiveRow.Cells["MtrlcmpntCode"].Value.ToString();
            
            string strErr = "";
            //hengxing
            //ClientCommon._RemotingHelp.ExecuteMethod("lgJobMgt",
            //                                      "Core.LgMes.Server.lgJobMgt.classCommonModule",
            //                                      "DeleteItemMtrlcmpnt", new object[] { strMaterielCode, strMaterielType, 
            //                                      strMaterielbNo,strMtrlcmpntCode}, out strErr);
            if (strErr != "")
            {
                MessageBox.Show("删除失败！过程添加料成分信息不存在。", "提示", MessageBoxButtons.OK, MessageBoxIcon.Asterisk);
            }
            else
            {
                MessageBox.Show("过程添加料成分信息删除成功！", "提示", MessageBoxButtons.OK, MessageBoxIcon.Asterisk);
                GetItemMtrlcmpnt(strMaterielCode, strMaterielType, strMaterielbNo);
            }

        }

        /// <summary>
        /// 增加过程添加料项目成分表
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        private void btnAdd_Click(object sender, EventArgs e)
         {
             blItemAdditives = false; //判断主表是否有记录
            if (!string.IsNullOrEmpty(ultxtMaterielCode.Text) && !string.IsNullOrEmpty(ultxtMaterielbNo.Text)
                && !string.IsNullOrEmpty(ultxtMtrlcmpntCode.Text) && !string.IsNullOrEmpty(ultxtMtrlcmpntValue.Text))
            {
                string strErr = "";
                string strWhere = " and t.MaterielCode='" + ultxtMaterielCode.Text + "' and  t.MaterielType='" +
                                  ultxtMaterielType.Value  + "' and t.MaterielbNo='" + ultxtMaterielbNo.Text + "'";
                DataSet dsItemAdditives = null;// (DataSet)ClientCommon._RemotingHelp.ExecuteMethod("lgJobMgt",
                                                 //      "Core.LgMes.Server.lgJobMgt.classCommonModule",
                                                   //    "GetItemAdditives", new object[] { strWhere }, out strErr);
                if (strErr == "" && dsItemAdditives != null)
                {
                    if (dsItemAdditives.Tables[0].Rows.Count == 0)
                    {
                        AddItemAdditives();  //增加过程添加料项目
                    }
                }
                if(blItemAdditives ==false)
                    AddItemMtrlcmpnt();  //增加过程添加料项目成分表
            }
            else
            {
                MessageBox.Show("输入有效过程添加料项目成分信息。", "提示", MessageBoxButtons.OK, MessageBoxIcon.Asterisk);
            }
        }

        /// <summary>
        /// 删除过程添加料项目成分表
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        private void btnDel_Click(object sender, EventArgs e)
        {
            DialogResult result;
            result = MessageBox.Show("确认要删除过程添加料成分信息？", "提示", MessageBoxButtons.YesNo, MessageBoxIcon.Question, MessageBoxDefaultButton.Button1);
            if (result == DialogResult.Yes)
            {
                DeleteItemMtrlcmpnt();
            }
        }
        
        /// <summary>
        /// 返回物料类型编码
        /// </summary>
        /// <param name="strMaterielType"></param>
        /// <returns></returns>
        private string GetMaterielTypeCode(string strMaterielType)
        {
            string strMaterielTypeCode = "";
            if (!string.IsNullOrEmpty(strMaterielType))
            {
                //转换成编码
                switch (strMaterielType)
                {
                    case "合金":
                        strMaterielTypeCode = "HJ";
                        break;
                    case "辅料":
                        strMaterielTypeCode = "FL";
                        break;
                    case "喂丝":
                        strMaterielTypeCode = "WS";
                        break;
                    default:
                        break;
                }
            }
            return strMaterielTypeCode;
        }

        private void ultxtMtrlcmpntValue_TextChanged(object sender, EventArgs e)
        {
            if (ultxtMtrlcmpntValue.Text != "")
                CStaticMethod.CheckNumValidate(ultxtMtrlcmpntValue.Text);
        }

        private void ulgridMtrlcmpnt_Click(object sender, EventArgs e)
        {
            if (ulgridMtrlcmpnt.ActiveRow != null)
            {
                ultxtMtrlcmpntCode.Text = ulgridMtrlcmpnt.ActiveRow.Cells["MtrlcmpntCode"].Value.ToString();
                ultxtMtrlcmpntValue.Text = ulgridMtrlcmpnt.ActiveRow.Cells["MtrlcmpntValue"].Value.ToString();
            }
        }

        private void ExportExcel()
        {
            try
            {
                string StrfileName = System.Windows.Forms.Application.StartupPath + "\\Report\\物料质量.xls";
                this.ultraGridExcelExporter1.Export(this.ulgriddAdditives, StrfileName);

                ProcessStartInfo p = new ProcessStartInfo(StrfileName);
                p.WindowStyle = System.Diagnostics.ProcessWindowStyle.Maximized;
                p.WorkingDirectory = Path.GetDirectoryName(StrfileName);
                Process.Start(p);
            }
            catch (Exception ex)
            {
                MessageBox.Show(ex.Message);
            }            
        }

        private void ultraDateTimeEditor2_ValueChanged(object sender, EventArgs e)
        {

        }
     }
}