MES_Client/TGMES/Core.StlMes.Client.LgIntegrationQuery/FrmStoresProject.cs

using System;
using System.Collections.Generic;
using System.Collections;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Text;
using System.Windows.Forms;
using CoreFS.CA06;
using Core.StlMes.Client.LgCommon;

namespace Core.StlMes.Client.LgIntegrationQuery
{
    public partial class FrmStoresProject : frmStyleBase
    {
        string strMess = "";
        string MaterielCode = "";
        string MaterielName = "";
        string MaterielforShort = "";
        string MaterielType = "";
        string MaterielUnits="";
        string JmType = "";

        public FrmStoresProject()
        {
            InitializeComponent();
        }

        #region "Function"
        private void QueryData()
        {
            dataTable1.Clear();

            string szWhere = "";
            if (this.radHJ.Checked == true)
            {
                szWhere =  radHJ.Tag.ToString();
            }
            else if (this.radFL.Checked == true)
            {
                szWhere =  radFL.Tag.ToString();
            }

            else if (this.radWS.Checked == true)
            {
                szWhere =  radWS.Tag.ToString();
            }
            else if (this.radBHZ.Checked == true)
            {
                szWhere =  radBHZ.Tag.ToString();
            }
            else if (this.radGT.Checked == true)
            {
                szWhere = radGT.Tag.ToString();
            }
            else if (this.radAllType.Checked == true)
            {
                szWhere = "";
            }

            GetDataSource(szWhere);

            ClsControlPack.SetRowEdit(ultraGrid1);
            ultraGrid1.DisplayLayout.Bands[0].Columns["ERPITEMCODE"].Header.VisiblePosition = 1;
            
        }

        /// <summary>
        /// 加料过程类型
        /// </summary>
        private void SetColumnMode1()
        {
            DataTable dt = new DataTable();
            dt.TableName = "JIALIAO";
            DataColumn dc = new DataColumn("BCBM", Type.GetType("System.String"));
            dt.Columns.Add(dc);
            dc = new DataColumn("BCNA", Type.GetType("System.String"));
            dt.Columns.Add(dc);
            DataRow dr = dt.NewRow();
            dr["BCBM"] = "YLGC";
            dr["BCNA"] = "冶炼过程添加料";
            dt.Rows.Add(dr);
            dr = dt.NewRow();
            dr["BCBM"] = "CGGC";
            dr["BCNA"] = "出钢过程添加料";
            dt.Rows.Add(dr);


            ClsControlPack.SetGridDropDownList("JMTYPE", "Table1", "加料过程类型", 90, ultraGrid1, dt, "BCBM", "BCNA");
        }

        /// <summary>
        /// 物料单位
        /// </summary>
        private void SetColumnMode2()
        {
            DataTable dt = new DataTable();
            dt.TableName = "DANWEI";
            DataColumn dc = new DataColumn("BCBM", Type.GetType("System.String"));
            dt.Columns.Add(dc);
            dc = new DataColumn("BCNA", Type.GetType("System.String"));
            dt.Columns.Add(dc);
            DataRow dr = dt.NewRow();
            dr["BCBM"] = "KG";
            dr["BCNA"] = "千克";
            dt.Rows.Add(dr);
            dr = dt.NewRow();
            dr["BCBM"] = "T";
            dr["BCNA"] = "吨";
            dt.Rows.Add(dr);
            dr = dt.NewRow();
            dr["BCBM"] = "D";
            dr["BCNA"] = "袋";
            dt.Rows.Add(dr);
            dr = dt.NewRow();
            dr["BCBM"] = "M";
            dr["BCNA"] = "米";
            dt.Rows.Add(dr);

            ClsControlPack.SetGridDropDownList("MATERIELUNITS", "Table1", "物料单位", 90, ultraGrid1, dt, "BCBM", "BCNA");
        }

        /// <summary>
        /// 物料类型名称
        /// </summary>
        private void SetColumnMode3()
        {
            DataTable dt = new DataTable();
            dt.TableName = "WLLX";
            DataColumn dc = new DataColumn("BCBM", Type.GetType("System.String"));
            dt.Columns.Add(dc);
            dc = new DataColumn("BCNA", Type.GetType("System.String"));
            dt.Columns.Add(dc);
            DataRow dr = dt.NewRow();
            dr["BCBM"] = "HJ";
            dr["BCNA"] = "合金";
            dt.Rows.Add(dr);
            dr = dt.NewRow();
            dr["BCBM"] = "FL";
            dr["BCNA"] = "辅料";
            dt.Rows.Add(dr);
            dr = dt.NewRow();
            dr["BCBM"] = "WS";
            dr["BCNA"] = "喂线";
            dt.Rows.Add(dr);
            dr = dt.NewRow();
            dr["BCBM"] = "BH";
            dr["BCNA"] = "保护渣";
            dt.Rows.Add(dr);
            dr = dt.NewRow();
            dr["BCBM"] = "GT";
            dr["BCNA"] = "钢铁料";
            dt.Rows.Add(dr);


            ClsControlPack.SetGridDropDownList("MATERIELTYPE", "Table1", "物料类型名称", 90, ultraGrid1, dt, "BCBM", "BCNA");
        }

        /// <summary>
        /// 保存物料信息
        /// </summary>
        private void SaveData()
        {
            try
            {
                ultraGrid1.UpdateData();
                
                if (dataTable1.Rows.Count >0)
                {
                    string strErr = "";
                    ArrayList arry = new ArrayList();

                    if (strMess == "物料信息保存成功！")
                    {
                        arry.Add("frmStoresProject_Save.select");
                        MaterielCode= ultraGrid1.ActiveRow.Cells["MaterielCode"].Text;
                        MaterielName = ultraGrid1.ActiveRow.Cells["MaterielName"].Text;
                        MaterielforShort = ultraGrid1.ActiveRow.Cells["MaterielforShort"].Text;
                        MaterielType = ultraGrid1.ActiveRow.Cells["MaterielType"].Value.ToString();
                        MaterielUnits = ultraGrid1.ActiveRow.Cells["MaterielUnits"].Value.ToString();
                        JmType = ultraGrid1.ActiveRow.Cells["JmType"].Text;

                        arry.Add(MaterielCode);
                        arry.Add(MaterielType);
                        arry.Add(MaterielName);
                        arry.Add(MaterielforShort);
                        arry.Add(MaterielUnits);
                        arry.Add(JmType);
                    }
                    if (strMess == "物料信息修改成功！")
                    {
                        arry.Add("frmStoresProject_Update.select");

                        string strMCode = ultraGrid1.ActiveRow.Cells["MaterielCode"].Text.Trim();
                        string strMType = ultraGrid1.ActiveRow.Cells["MaterielType"].Text.Trim();
                        string strMShort = ultraGrid1.ActiveRow.Cells["MaterielforShort"].Value.ToString();

                        arry.Add(strMType);
                        arry.Add(strMShort);
                        arry.Add(strMCode);
                    }

                    CommonClientToServer cctos = new CommonClientToServer();
                    cctos.ob = this.ob;
                    DataSet ds = cctos.ExecuteQueryFunctions("Core.LgMes.Server.Common.ComDBSave",
                                                "doSimpleSave", arry, out strErr);

                    if (strErr == "" && ds != null)
                    {
                        dataTable1.AcceptChanges();
                        ClsControlPack.SetRowEdit(ultraGrid1);
                        if (!string.IsNullOrEmpty(strMess))
                            MessageBox.Show(strMess, "提示", MessageBoxButtons.OK, MessageBoxIcon.Asterisk);
                    }
                    else
                    {
                        MessageBox.Show("保存失败！输入物料已经存在或数据无效。", "错误");
                    }
                    if (ultraGrid1.ActiveCell != null)
                        ultraGrid1.ActiveCell.Activated = false;
                }
            }
            catch (System.Exception ex)
            {
                Console.WriteLine(ex.ToString());
            }

        }

        #endregion

        /// <summary>
        /// 删除物料信息
        /// </summary>
        private void DelData(string strMCode)
        {

            string strErr = "";
            if (dataTable1.GetChanges() != null)
            {
                ArrayList arry = new ArrayList();

                arry.Add("frmStoresProject_Del.select");
                arry.Add(strMCode);

                CommonClientToServer cctos = new CommonClientToServer();
                cctos.ob = this.ob;
                DataSet ds = cctos.ExecuteQueryFunctions("Core.LgMes.Server.Common.ComDBSave",
                                            "doSimpleSave", arry, out strErr);

                if (strErr != "" && ds != null)
                {
                    MessageBox.Show(strErr);
                }
                else
                {
                    MessageBox.Show("物料信息删除成功！", "提示", MessageBoxButtons.OK, MessageBoxIcon.Asterisk);
                }
            }
        }

        private void FrmStoresProject_Load(object sender, EventArgs e)
        {

            QueryData();

            SetColumnMode1();
            SetColumnMode2();
            SetColumnMode3();

        }

        /// <summary>
        /// 获取物料信息
        /// </summary>
        private void GetDataSource(string strMType)
        {
            string strErr = "";
            DataSet ds = null;

            //定义一个ArrayList集合存储变量[参数]值

            ArrayList arry = new ArrayList();
            arry.Add("frmStoresProject.select");
            arry.Add(strMType);

            CommonClientToServer cctos = new CommonClientToServer();
            cctos.ob = this.ob;
            ds = cctos.ExecuteQueryFunctions("Core.LgMes.Server.Common.ComDBQuery",
                                        "doSimpleQuery", arry, out strErr);

            if (strErr == "" && ds != null)
            {
                int i;

                for (i = 0; i < ds.Tables[0].Rows.Count; i++)
                {
                    DataRow dr = dataTable1.NewRow();

                    dr["MaterielCode"] = ds.Tables[0].Rows[i]["MaterielCode"];
                    dr["MaterielName"] = ds.Tables[0].Rows[i]["MaterielName"];
                    dr["MaterielforShort"] = ds.Tables[0].Rows[i]["MaterielforShort"];
                    dr["MaterielType"] = ds.Tables[0].Rows[i]["MaterielType"];
                    dr["MaterielUnits"] = ds.Tables[0].Rows[i]["MaterielUnits"];
                    dr["JmType"] = ds.Tables[0].Rows[i]["JmType"];
                    dataTable1.Rows.Add(dr);
                }
                ultraGrid1.UpdateData();
                dataTable1.AcceptChanges();
            }
        }

        #region 选项改变事件

        private void radHJ_CheckedChanged(object sender, EventArgs e)
        {
            if (this.radHJ.Checked == true)
            {
                this.radAllType.Checked = false;
                this.radFL.Checked = false;
                this.radWS.Checked = false;
                this.radBHZ.Checked = false;
                this.radGT.Checked = false;
            }
            string szWhere = radHJ.Tag.ToString();
            QueryData();

        }

        private void radFL_CheckedChanged(object sender, EventArgs e)
        {
            if (this.radFL.Checked == true)
            {
                this.radHJ.Checked = false;
                this.radAllType.Checked = false;
                this.radWS.Checked = false;
                this.radBHZ.Checked = false;
                this.radGT.Checked = false;

            }
            string szWhere = radFL.Tag.ToString();
            QueryData();
        }

        private void radWS_CheckedChanged(object sender, EventArgs e)
        {
            if (this.radWS.Checked == true)
            {
                this.radHJ.Checked = false;
                this.radFL.Checked = false;
                this.radAllType.Checked = false;
                this.radBHZ.Checked = false;
                this.radGT.Checked = false;
            }
            string szWhere = radWS.Tag.ToString();
            QueryData();

        }

        private void radAllType_CheckedChanged(object sender, EventArgs e)
        {
            if (this.radAllType.Checked == true)
            {
                this.radHJ.Checked = false;
                this.radFL.Checked = false;
                this.radWS.Checked = false;
                this.radBHZ.Checked = false;
                this.radGT.Checked = false;
            }
            QueryData();

        }

        private void radBHZ_CheckedChanged(object sender, EventArgs e)
        {
            if (this.radBHZ.Checked == true)
            {
                this.radHJ.Checked = false;
                this.radFL.Checked = false;
                this.radWS.Checked = false;
                this.radGT.Checked = false;
                this.radAllType.Checked = false;
            }

            QueryData();
        }

        private void radGT_CheckedChanged(object sender, EventArgs e)
        {
            if (this.radGT.Checked == true)
            {
                this.radHJ.Checked = false;
                this.radFL.Checked = false;
                this.radWS.Checked = false;
                this.radBHZ.Checked = false;
                this.radAllType.Checked = false;
            }

            QueryData();
        }

        #endregion

        /// <summary>
        /// 功能按钮
        /// </summary>
        public override void ToolBar_Click(object sender, string ToolbarKey)
        {
            switch (ToolbarKey)
            {
                case "Add":
                    ClsControlPack.Add(ultraGrid1);
                    strMess = "物料信息保存成功！";
                    ultraGrid1.ActiveRow = ultraGrid1.Rows[ultraGrid1.Rows.Count-2];
                    break;

                case "Update":
                    if (ultraGrid1.ActiveRow == null || ultraGrid1.ActiveRow.Cells["MaterielCode"].Text.Length<1||ultraGrid1.ActiveRow.Cells["MaterielType"].Text.Length<1)
                    {
                        MessageBox.Show("您修改的行不能为空！");
                        return;
                    }
                    ClsControlPack.Update(ultraGrid1);
                    strMess = "物料信息修改成功！";
                    if (ultraGrid1.ActiveRow != null)
                    {
                        ultraGrid1.ActiveRow.Cells["MaterielCode"].Activation = Infragistics.Win.UltraWinGrid.Activation.NoEdit;
                        ultraGrid1.ActiveRow.Cells["MATERIELNAME"].Activation = Infragistics.Win.UltraWinGrid.Activation.NoEdit;
                        ultraGrid1.ActiveRow.Cells["MATERIELUNITS"].Activation = Infragistics.Win.UltraWinGrid.Activation.NoEdit;

                    }
                    else
                        MessageBox.Show("请选择需要修改的数据行！", "提示", MessageBoxButtons.OK, MessageBoxIcon.Asterisk);
                    break;

                case "Delete":
                    strMess = "物料信息删除成功！";
                    if (ultraGrid1.ActiveRow != null)
                    {
                        string strMCode = ultraGrid1.ActiveRow.Cells["MaterielCode"].Text.Trim();
                        ClsControlPack.Delete(ultraGrid1);

                        DelData(strMCode);
                    }
                    else
                        MessageBox.Show("请选择需要删除的数据行！", "提示", MessageBoxButtons.OK, MessageBoxIcon.Asterisk);
                    break;

                case "Save":
                    ultraGrid1.UpdateData();
                    if (dataTable1.GetChanges() != null)
                    {
                        int j = dataTable1.GetChanges().Rows.Count;
                        if (strMess != "物料信息删除成功！")
                        {
                            for (int i = 0; i < j; i++)
                            {

                                if (dataTable1.GetChanges().Rows[i]["MaterielCode"].ToString() == "")
                                {
                                    MessageBox.Show("保存失败!请确认'物料编码'信息输入完整!", "提示", System.Windows.Forms.MessageBoxButtons.OK);
                                    return;
                                }
                            }
                        }
                    }
                    SaveData();
                    break;

                case "Rollback"://cancel
                    ClsControlPack.dataCancel(ultraGrid1, dataTable1);
                    break;
                case "Exit":
                    this.Close();
                    break;
                default:
                    break;
            }           
        }

        private void ultraToolbarsManager1_ToolClick(object sender, Infragistics.Win.UltraWinToolbars.ToolClickEventArgs e)
        {
            switch (e.Tool.Key)
            {
                default:
                    break;
            }
        }

    }
}