MES_Client/TGMES/Core.StlMes.Client.LgIntegrationQuery/FrmJJBSelect.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 FrmJJBSelect : frmStyleBase
    {
        string strLG_ZG = "LG"; //判断是炼钢还是轧钢
        Dictionary<string, string> dic = null;
        public string workShopNo="";
        private string str_bc = "";
        private string str_bb = "";
        public FrmJJBSelect()
        {
            InitializeComponent();
        }

        private void FrmJJBSelect_Load(object sender, EventArgs e)
        {
            this.workShopNo = this.CustomInfo;
            //判断是炼钢还是轧钢
            if (this.Key.IndexOf('@') > 0)
                strLG_ZG = this.Key.Substring(this.Key.IndexOf('@') + 1, 2);

            initPos();
            SetCombo();
            GetBCName();
            uce_GWCode.SelectedIndex = 0;
            QueryData();
        }

        // 初始化岗位
        /// <summary>
        /// 初始化岗位
        /// </summary>
        public void initPos()
        {
            uce_GWCode.Items.Clear();
            uce_GWCode.Items.Add("LG", "炼钢");
            uce_GWCode.Items.Add("HMP01", "1#脱硫站");
            uce_GWCode.Items.Add("HMP02", "2#脱硫站");//九钢
            uce_GWCode.Items.Add("BOF01", "1#转炉");
            uce_GWCode.Items.Add("BOF02", "2#转炉");
            uce_GWCode.Items.Add("BOF03", "3#转炉");
            uce_GWCode.Items.Add("BOF04", "4#转炉");
            //uce_GWCode.Items.Add("BOF05", "5#转炉");
            uce_GWCode.Items.Add("CAS01", "1#吹氩站");
            uce_GWCode.Items.Add("CAS02", "2#吹氩站");
            uce_GWCode.Items.Add("CAS03", "3#吹氩站");
            uce_GWCode.Items.Add("CAS04", "4#吹氩站");
            //uce_GWCode.Items.Add("CAS05", "5#吹氩站");
            uce_GWCode.Items.Add("LFS01", "1#精炼炉");
            uce_GWCode.Items.Add("LFS02", "2#精炼炉");
            //uce_GWCode.Items.Add("LFS03", "3#精炼炉");
            uce_GWCode.Items.Add("CCM01", "1#连铸机");
            uce_GWCode.Items.Add("CCM02", "2#连铸机");
            uce_GWCode.Items.Add("CCM03", "3#连铸机");
            uce_GWCode.Items.Add("CCM04", "4#连铸机");
            //uce_GWCode.Items.Add("CMM05", "5#连铸机");
            //if (workShopNo == "1")
            //{
            //    uce_GWCode.Items.Add("HMP01", "1#脱硫站");
            //    uce_GWCode.Items.Add("BOF01", "1#转炉");
            //    uce_GWCode.Items.Add("BOF02", "2#转炉");
            //    uce_GWCode.Items.Add("CAS01", "1#吹氩站");
            //    uce_GWCode.Items.Add("CAS02", "2#吹氩站");
            //    uce_GWCode.Items.Add("LFS01", "1#精炼炉");
            //    uce_GWCode.Items.Add("CCM01", "1#连铸机");
            //    uce_GWCode.Items.Add("CMM02", "2#连铸机");
            //}
            //else
            //{
            //    uce_GWCode.Items.Add("BOF03", "3#转炉");
            //    uce_GWCode.Items.Add("BOF04", "4#转炉");
            //    uce_GWCode.Items.Add("BOF05", "5#转炉");
            //    uce_GWCode.Items.Add("CAS03", "3#吹氩站");
            //    uce_GWCode.Items.Add("CAS04", "4#吹氩站");
            //    uce_GWCode.Items.Add("CAS05", "5#吹氩站");
            //    uce_GWCode.Items.Add("LFS02", "2#精炼炉");
            //    uce_GWCode.Items.Add("LFS03", "3#精炼炉");
            //    uce_GWCode.Items.Add("CCM03", "3#连铸机");
            //    uce_GWCode.Items.Add("CMM04", "4#连铸机");
            //    uce_GWCode.Items.Add("CMM05", "5#连铸机");
            //}
        }

        // 初始化班次班组的下拉列表
        /// <summary>
        /// 初始化班次班组的下拉列表
        /// </summary>
        private void SetCombo()
        {
            //班次
            cmb_BC.Items.Clear();
            cmb_BC.Items.Add("0", "全部");
            cmb_BC.Items.Add("1", "白班");
            cmb_BC.Items.Add("2", "小夜");
            cmb_BC.Items.Add("3", "大夜");
            cmb_BC.SelectedIndex = 0;
            //班组
            cmb_BB.Items.Clear();
            cmb_BB.Items.Add("0", "全部");
            cmb_BB.Items.Add("1", "甲班");
            cmb_BB.Items.Add("2", "乙班");
            cmb_BB.Items.Add("3", "丙班");
            cmb_BB.Items.Add("4", "丁班");
            cmb_BB.SelectedIndex = 0;
        }

        // 查询数据
        /// <summary>
        /// 查询数据
        /// </summary>
        private void QueryData()
        {
            string strStartTime = "";
            string strEndTime = "";
            string strStacode = "";
            string strPosition = "";

            if (Convert.ToDateTime(uldtBeginTime.Text.Trim()) > Convert.ToDateTime(uldtEndTime.Text.Trim()))
            {
                MessageBox.Show("选择的开始时间不能大于结束时间！", "提示", MessageBoxButtons.OK, MessageBoxIcon.Asterisk);
                return;
            }

            dataTable1.Clear();
            dataTable2.Clear();
            string szWhere = "";
            string str = "";

            szWhere += " ";

            if (Convert.ToDateTime(uldtBeginTime.Value) > Convert.ToDateTime(uldtEndTime.Value))
            {
                MessageBox.Show("时间条件的开始时间不能大于结束时间！", "提示", MessageBoxButtons.OK, MessageBoxIcon.Asterisk);
                return;
            }
            else
            {

                strStartTime = this.uldtBeginTime.DateTime.ToString("yyyy-MM-dd");
                strEndTime = this.uldtEndTime.DateTime.ToString("yyyy-MM-dd");
            }
            szWhere = "";

            if (ultraCheckEditor3.Checked == true)
            {
                strPosition = uce_GWCode.Value.ToString();
            }

            if (this.ultraCheckEditor1.Checked == true)
            {
                GetCombowhere();
            }


            //获取交接班信息
            string NowTime = DateTime.Now.ToString("yyyy-MM-dd");
            ArrayList arry = new ArrayList();
            arry.Add("FrmJJB_Query.select");
            arry.Add(strPosition);
            arry.Add(str_bc);
            arry.Add(str_bc);
            arry.Add(str_bb);
            arry.Add(str_bb);
            arry.Add(strStartTime == "" ? NowTime : strStartTime);
            arry.Add(strEndTime == "" ? NowTime : strEndTime);

            GetData1(arry);
        }

        // 查询数据1
        /// <summary>
        /// 查询数据1
        /// </summary>
        private void GetData1(ArrayList arry)
        {
            try
            {
                string strErr = "";
                string bcName = "";
                CommonClientToServer cctos = new CommonClientToServer();
                cctos.ob = this.ob;
                DataSet ds = cctos.ExecuteQueryFunctions("Core.LgMes.Server.Common.ComDBQuery",
                                            "doSimpleQuery", arry, out strErr);

                if (strErr == "" && ds != null)
                {
                    foreach (DataRow Dr in ds.Tables[0].Rows)
                    {
                        DataRow dr = dataSet1.Tables[0].NewRow();
                        dr["numid"] = Dr["numid"];
                        dr["DESCRIPTION"] = Dr["DESCRIPTION"];
                        
                        if (dic.ContainsKey(Dr["SHIFTCODE"].ToString()))
                        {
                            dic.TryGetValue(Dr["SHIFTCODE"].ToString(), out bcName);
                            dr["SHIFTCODE"] = bcName;
                        }
                        else
                        {
                            dr["SHIFTCODE"] = Dr["SHIFTCODE"];
                        }
                        
                        //  dr["XMCode"] = Dr["XMCode"];
                        dr["esdate"] = Dr["esdate"];
                        dr["ESNAME"] = Dr["ESNAME"];
                        dr["ITEMCODE"] = Dr["ITEMCODE"];
                        dr["abnormityflag"] = Dr["abnormityflag"];
                        dr["mastername"] = Dr["mastername"];
                        dr["monitor"] = Dr["monitor"];
                        dr["ESMEMO"] = Dr["ESMEMO"];

                        //dataTable1.Rows.Add(dr);
                        dataSet1.Tables[0].Rows.Add(dr);
                    }

                    dataTable1.AcceptChanges();
                    ultraGrid1.UpdateData();
               //     this.ultraGrid1.DisplayLayout.Bands[0].Columns["monitor"].Hidden = true;
                //    this.ultraGrid1.DisplayLayout.Bands[0].Columns["mastername"].Hidden = true;
                    this.ultraGrid1.DisplayLayout.Bands[0].Columns["numid"].Hidden = true;
                    PublicMethod.RefreshAndAutoSize(ultraGrid1);
                }

            }
            catch (System.Exception exp)
            {
                MessageBox.Show(exp.ToString());
            }
        }

        // 获取班次班别
        /// <summary>
        /// 获取班次班别
        /// </summary>
        private void GetCombowhere()
        {
            try
            {
                if (cmb_BC.Value.ToString() != "0")
                {
                    str_bc = cmb_BC.Value.ToString();
                }
                else
                {
                    str_bc = "";
                }
                if (cmb_BB.Value.ToString() != "0")
                {
                    str_bb = cmb_BB.Value.ToString();
                }
                else
                {
                    str_bb = "";
                }

            }
            catch (System.Exception exp)
            {
                MessageBox.Show(exp.ToString());
            }
        }

        // 显示grid的班次班组
        /// <summary>
        /// 显示grid的班次班组
        /// </summary>
        private void GetBCName()
        {
            dic = new Dictionary<string,string>();
            dic.Add("31", "晚-甲");
            dic.Add("32", "晚-乙");
            dic.Add("33", "晚-丙");
            dic.Add("34", "晚-丁");
            dic.Add("11", "白-甲");
            dic.Add("12", "白-乙");
            dic.Add("13", "白-丙");
            dic.Add("14", "白-丁");
            dic.Add("21", "中-甲");
            dic.Add("22", "中-乙");
            dic.Add("23", "中-丙");
            dic.Add("24", "中-丁");

        }

        // 获取项目详细信息
        /// <summary>
        /// 获取项目详细信息
        /// </summary>
        private void ultraGrid1_AfterRowActivate(object sender, EventArgs e)
        {
            try
            {
                if (this.ultraGrid1.DisplayLayout.ActiveRow != null)
                {
                    dataTable2.Clear();
                    string strNumid;
                    strNumid = this.ultraGrid1.DisplayLayout.ActiveRow.Cells["numid"].Value.ToString();

                    string strErr = "";

                    //获取交接班从表数据
                    string NowTime = DateTime.Now.ToString("yyyy-MM-dd");
                    ArrayList arry = new ArrayList();
                    arry.Add("FrmYCJJB_Detail.select");//此ID为XML文件ID
                    arry.Add(strNumid);

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


                    if (strErr == "" && ds != null)
                    {
                        foreach (DataRow Dr in ds.Tables[0].Rows)
                        {
                            DataRow dr = dataSet2.Tables[0].NewRow();
                            dr["ItemName"] = Dr["ItemName"].ToString();
                            //dr["XMName"] = Dr["ItemName"];
                            dr["ItemType"] = Dr["ItemType"];
                            dr["ItemVALUE"] = Dr["ItemVALUE"];
                            dr["ItemCode"] = Dr["ItemCode"];
                            dataSet2.Tables[0].Rows.Add(dr);
                        }
                        this.ultraGrid2.DisplayLayout.Bands[0].Columns["ItemCode"].Hidden = true;
                        ultraGrid2.UpdateData();
                        dataTable2.AcceptChanges();
                    }
                }
                ClsControlPack.SetRowEdit(ultraGrid2);
            }
            catch (System.Exception exp)
            {
                MessageBox.Show(exp.ToString());
            }

        }

        // 系统功能
        /// <summary>
        /// 系统功能
        /// </summary>
        public override void ToolBar_Click(object sender, string ToolbarKey)
        {
            switch (ToolbarKey)
            {
                case "Query":
                    QueryData();
                    break;
                case "Exit":
                    this.Close();
                    break;
                case "Manual":
                   // Core.StlMes.Client.LgJobMgt.frmCcmCutOff frm = new Core.StlMes.Client.LgJobMgt.frmCcmCutOff();
                   // frm.ShowDialog();
                    break;
                default:
                    break;
            }
        }

        /// <summary>
        /// 岗位条件选择
        /// </summary>
        private void ultraCheckEditor3_CheckedChanged(object sender, EventArgs e)
        {
            this.uce_GWCode.Enabled = ultraCheckEditor3.Checked;
        }

        // 初始化UltraDropDown控件(岗位) 弃用
        /// <summary>
        /// 初始化UltraDropDown控件(岗位)
        /// </summary>
        private void InitUltraDropDown()
        {
             string strErr = "";
             try
             {
                 //班次绑定
                 DataTable tb = new DataTable();
                 DataColumn cn = new DataColumn("BCCode", System.Type.GetType("System.String"));
                 DataColumn cn1 = new DataColumn("BCName", System.Type.GetType("System.String"));
                 tb.Columns.Add(cn);
                 tb.Columns.Add(cn1);
                 string[] szS = new string[2];
                 tb.Rows.Add(szS);
                 tb.Rows[0]["BCCode"] = "11";
                 tb.Rows[0]["BCName"] = "夜-甲";
                 tb.Rows.Add(szS);
                 tb.Rows[1]["BCCode"] = "12";
                 tb.Rows[1]["BCName"] = "夜-乙";
                 tb.Rows.Add(szS);
                 tb.Rows[2]["BCCode"] = "13";
                 tb.Rows[2]["BCName"] = "夜-丙";
                 tb.Rows.Add(szS);
                 tb.Rows[3]["BCCode"] = "14";
                 tb.Rows[3]["BCName"] = "夜-丁";
                 tb.Rows.Add(szS);
                 tb.Rows[4]["BCCode"] = "21";
                 tb.Rows[4]["BCName"] = "白-甲";
                 tb.Rows.Add(szS);
                 tb.Rows[5]["BCCode"] = "22";
                 tb.Rows[5]["BCName"] = "白-乙";
                 tb.Rows.Add(szS);
                 tb.Rows[6]["BCCode"] = "23";
                 tb.Rows[6]["BCName"] = "白-丙";
                 tb.Rows.Add(szS);
                 tb.Rows[7]["BCCode"] = "24";
                 tb.Rows[7]["BCName"] = "早-丁";
                 tb.Rows.Add(szS);
                 tb.Rows[8]["BCCode"] = "31";
                 tb.Rows[8]["BCName"] = "中-甲";
                 tb.Rows.Add(szS);
                 tb.Rows[9]["BCCode"] = "32";
                 tb.Rows[9]["BCName"] = "中-乙";
                 tb.Rows.Add(szS);
                 tb.Rows[10]["BCCode"] = "33";
                 tb.Rows[10]["BCName"] = "中-丙";
                 tb.Rows.Add(szS);
                 tb.Rows[11]["BCCode"] = "34";
                 tb.Rows[11]["BCName"] = "中-丁";

                 Infragistics.Win.UltraWinGrid.UltraDropDown ultraCombo = new Infragistics.Win.UltraWinGrid.UltraDropDown();
                 this.ultraGrid1.FindForm().Controls.Add(ultraCombo);
                 ultraCombo.DisplayMember = "BCName";
                 ultraCombo.ValueMember = "BCCode";
                 ultraCombo.Visible = false;
                 ultraCombo.DataSource = tb.DefaultView;
                 ultraGrid1.DisplayLayout.Bands[0].Columns["shiftcode"].ValueList = ultraCombo;
                 ultraCombo.DisplayLayout.Bands[0].Columns["BCCode"].Band.ColHeadersVisible = false;
                 int str = ultraGrid1.DisplayLayout.Bands[0].Columns["shiftcode"].Width;
                 ultraCombo.DisplayLayout.Bands[0].Columns["BCName"].Width = ultraGrid1.DisplayLayout.Bands[0].Columns["shiftcode"].Width;
                 ultraCombo.DisplayLayout.Bands[0].Columns["BCCode"].Hidden = true;

                 //获取岗位信息
                 ArrayList arry = new ArrayList();
                 arry.Add("FrmYCJJB_Process.select");//此ID为XML文件ID

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

                 if (strErr == "" && ds != null)
                 {
                     for (int i = 0; i < ds.Tables[0].Rows.Count; i++)
                     {
                         uce_GWCode.Items.Add(i);
                         uce_GWCode.Items[i].DisplayText = ds.Tables[0].Rows[i]["DESCRIPTION"].ToString();
                         uce_GWCode.Items[i].DataValue = ds.Tables[0].Rows[i]["NAME_"].ToString();
                     }
                 }
             }
             catch (Exception exp)
             {
                 //WriteLog("Core.StlMes.Client.LgIntegrationQuery.FrmYCJJB" + exp.Message);
             }
        }

        private void ultraCheckEditor1_CheckedChanged(object sender, EventArgs e)
        {
            cmb_BC.Enabled = cmb_BB.Enabled = ultraCheckEditor1.Checked;
        }

    }
}