XinYu_LG2MES/ClientSolution/Core.LgMes.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.Mes.Client.Common;
namespace Core.LgMes.Client.LgIntegrationQuery
{
    public partial class FrmJJBSelect : frmStyleBase
    {
        string strLG_ZG = "LG"; //判断是炼钢还是轧钢

        public FrmJJBSelect()
        {
            InitializeComponent();
        }

        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 (this.ckbTime.Checked == true && this.ultraCheckEditor1.Checked == true)
            {
                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");
                }

            }
            else if (this.ckbTime.Checked == true && this.ultraCheckEditor1.Checked == false)
            {
                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");
                }
            }
            else if (this.ckbTime.Checked == false && this.ultraCheckEditor1.Checked == true)
            {
                //string st = GetCombowhere();
                //szWhere = szWhere + st;
            }

            else
                szWhere = "";

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

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


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

            GetData1(arry);
        }

        private void GetData1(ArrayList arry)
        {
            try
            {
                string strErr = "";

                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"];
                        dr["SHIFTCODE"] = Dr["SHIFTCODE"];
                        //  dr["XMCode"] = Dr["XMCode"];
                        dr["esdate"] = Dr["esdate"];
                        dr["ESNAME"] = Dr["ESNAME"];
                        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;
                    //this.ultraGrid1.DisplayLayout.Bands[0].Columns["XMCode"].Hidden = true;
                    //this.ultraGrid2.DisplayLayout.Bands[0].Columns["XMCode"].Hidden = true;
                }

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

        private string GetCombowhere()
        {
            string szWhere = "";
            string str_BC = "";
            string strBCCode = "";
            try
            {

                if (Convert.ToString(cmb_BC.Value) != "" && Convert.ToString(cmb_BB.Value) != "")
                {
                    if (cmb_BC.Value.ToString() == "4")
                    {
                        if (cmb_BB.Value.ToString() == "5")
                            strBCCode = "";
                        else
                        {
                            strBCCode = cmb_BB.Value.ToString();
                        }
                    }
                    else
                    {
                        if (cmb_BB.Value.ToString() == "5")
                        {
                            strBCCode = cmb_BC.Value.ToString();
                        }
                        else
                        {
                            strBCCode = cmb_BC.Value.ToString() + cmb_BB.Value.ToString();
                        }
                    }
                }

                else if (Convert.ToString(cmb_BC.Value) != "" && Convert.ToString(cmb_BB.Value) == "")
                {
                    if (cmb_BC.Value.ToString() == "4")
                        strBCCode = "";
                    else
                    {
                        strBCCode = cmb_BC.Value.ToString();

                    }
                }


                else if (Convert.ToString(cmb_BC.Value) == "" && Convert.ToString(cmb_BB.Value) != "")
                {
                    if (cmb_BB.Value.ToString() == "5")
                        szWhere = "";
                    else
                    {
                        strBCCode = cmb_BB.Value.ToString();

                    }
                }
                else
                {
                    strBCCode = "";
                }
                return strBCCode;
            }



            catch (System.Exception exp)
            {

                MessageBox.Show(exp.ToString());
                return szWhere = "";
            }


        }
        #region "Dropdown"
        private void SetColumnMode1()
        {
            //岗位绑定
            string strErr = "";
            string strWhere = "";

            strWhere = " and substr(processcode,1,2)='LG' and LENGTH(processcode)=8";  //炼钢
            //获取岗位信息
            DataSet ds = null;

            if (strErr != "" || ds == null)
            {
                MessageBox.Show(strErr);
            }
            else
            {
                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]["processname"].ToString();
                }
            }

        }


        private void SetColumnMode2()
        {
            DataTable dt = new DataTable();
            dt.TableName = "JXZT";
            DataColumn dc = new DataColumn("BCCODE", Type.GetType("System.String"));
            dt.Columns.Add(dc);
            dc = new DataColumn("BCNAME", Type.GetType("System.String"));
            dt.Columns.Add(dc);
            DataRow dr = dt.NewRow();
            dr["BCCODE"] = "11";
            dr["BCNAME"] = "夜-甲";
            dt.Rows.Add(dr);
            dr = dt.NewRow();
            dr["BCCODE"] = "12";
            dr["BCNAME"] = "夜-乙";
            dt.Rows.Add(dr);
            dr = dt.NewRow();
            dr["BCCODE"] = "13";
            dr["BCNAME"] = "夜-丙";
            dt.Rows.Add(dr);
            dr = dt.NewRow();
            dr["BCCODE"] = "14";
            dr["BCNAME"] = "夜-丁";
            dt.Rows.Add(dr);
            dr = dt.NewRow();
            dr["BCCODE"] = "21";
            dr["BCNAME"] = "白-甲";
            dt.Rows.Add(dr); dr = dt.NewRow();
            dr["BCCODE"] = "22";
            dr["BCNAME"] = "白-乙";
            dt.Rows.Add(dr); dr = dt.NewRow();
            dr["BCCODE"] = "23";
            dr["BCNAME"] = "白-丙";
            dt.Rows.Add(dr);
            dr = dt.NewRow();
            dr["BCCODE"] = "24";
            dr["BCNAME"] = "白-丁";
            dt.Rows.Add(dr);
            dr = dt.NewRow();
            dr["BCCODE"] = "31";
            dr["BCNAME"] = "中-甲";
            dt.Rows.Add(dr);
            dr = dt.NewRow();
            dr["BCCODE"] = "32";
            dr["BCNAME"] = "中-乙";
            dt.Rows.Add(dr); dr = dt.NewRow();
            dr["BCCODE"] = "33";
            dr["BCNAME"] = "中-丙";
            dt.Rows.Add(dr); dr = dt.NewRow();
            dr["BCCODE"] = "34";
            dr["BCNAME"] = "中-丁";
            dt.Rows.Add(dr);

            JJBStaticFunction.SetGridDropDownList("BCCODE", "Table1", "班次", 90, ultraGrid1, dt, "BCCODE", "BCNAME");
        }

        private void SetColumnMode3()
        {
            DataTable dt = new DataTable();
            dt.TableName = "JXZT";
            DataColumn dc = new DataColumn("BCCODE", Type.GetType("System.String"));
            dt.Columns.Add(dc);
            dc = new DataColumn("BCNAME", Type.GetType("System.String"));
            dt.Columns.Add(dc);
            DataRow dr = dt.NewRow();
            dr["BCCODE"] = "1";
            dr["BCNAME"] = "已确认交班";
            dt.Rows.Add(dr);
            dr = dt.NewRow();
            dr["BCCODE"] = "0";
            dr["BCNAME"] = "未确认交班";
            dt.Rows.Add(dr);

            JJBStaticFunction.SetGridDropDownList("JJBQRFLAG", "Table1", "是否异常交班", 90, ultraGrid1, dt, "BCCODE", "BCNAME");
        }

        private void SetCombo()
        {
            DataTable dt = new DataTable();
            dt.TableName = "JXZT";
            DataColumn dc = new DataColumn("BCCODE", Type.GetType("System.String"));
            dt.Columns.Add(dc);
            dc = new DataColumn("BCNAME", Type.GetType("System.String"));
            dt.Columns.Add(dc);
            DataRow dr = dt.NewRow();
            dr["BCCODE"] = "1";
            dr["BCNAME"] = "夜班";
            dt.Rows.Add(dr);
            dr = dt.NewRow();
            dr["BCCODE"] = "2";
            dr["BCNAME"] = "白班";
            dt.Rows.Add(dr);
            dr = dt.NewRow();
            dr["BCCODE"] = "3";
            dr["BCNAME"] = "中班";
            dt.Rows.Add(dr);
            dr = dt.NewRow();
            dr["BCCODE"] = "4";
            dr["BCNAME"] = "全部";
            dt.Rows.Add(dr);
            dt.AcceptChanges();
            this.cmb_BC.DataSource = dt;
            this.cmb_BC.DisplayLayout.Bands[0].Columns["BCCODE"].Hidden = true;
            this.cmb_BC.DisplayLayout.Bands[0].Columns["BCNAME"].Width = 110;
            this.cmb_BC.DisplayLayout.Bands[0].Columns["BCNAME"].Header.Caption = "班次";
            this.cmb_BC.DisplayLayout.Bands[0].Columns["BCNAME"].Header.VisiblePosition = 0;
            this.cmb_BC.DisplayLayout.Bands[0].Columns["BCNAME"].Band.ColHeadersVisible = false;

            this.cmb_BC.ValueMember = "BCCODE";

            this.cmb_BC.DisplayMember = "BCNAME";


            DataTable dw = new DataTable();
            dw.TableName = "JXZT";
            DataColumn dco = new DataColumn("BCCODE", Type.GetType("System.String"));
            dw.Columns.Add(dco);
            dco = new DataColumn("BCNAME", Type.GetType("System.String"));
            dw.Columns.Add(dco);
            DataRow dro = dw.NewRow();
            dro["BCCODE"] = "1";
            dro["BCNAME"] = "甲";
            dw.Rows.Add(dro);
            dro = dw.NewRow();
            dro["BCCODE"] = "2";
            dro["BCNAME"] = "乙";
            dw.Rows.Add(dro);
            dro = dw.NewRow();
            dro["BCCODE"] = "3";
            dro["BCNAME"] = "丙";
            dw.Rows.Add(dro);
            dro = dw.NewRow();
            dro["BCCODE"] = "4";
            dro["BCNAME"] = "丁";
            dw.Rows.Add(dro);
            dro = dw.NewRow();
            dro["BCCODE"] = "5";
            dro["BCNAME"] = "全部";
            dw.Rows.Add(dro);
            dw.AcceptChanges();
            this.cmb_BB.DataSource = dw;
            this.cmb_BB.DisplayLayout.Bands[0].Columns["BCCODE"].Hidden = true;
            this.cmb_BB.DisplayLayout.Bands[0].Columns["BCNAME"].Width = 110;
            this.cmb_BB.DisplayLayout.Bands[0].Columns["BCNAME"].Header.Caption = "班次";
            this.cmb_BB.DisplayLayout.Bands[0].Columns["BCNAME"].Header.VisiblePosition = 0;
            this.cmb_BB.DisplayLayout.Bands[0].Columns["BCNAME"].Band.ColHeadersVisible = false;

            this.cmb_BB.ValueMember = "BCCODE";
            this.cmb_BB.DisplayMember = "BCNAME";

        }
        #endregion

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

            ckbTime.Checked = true;

            SetColumnMode2();
            SetCombo();
            SetColumnMode3();
            //初始化UltraDropDown控件
            //InitUltraDropDown();
            uce_GWCode.SelectedIndex = 0;
            QueryData();
        }


        private void ultraCheckEditor1_CheckedChanged(object sender, EventArgs e)
        {

            if (this.ultraCheckEditor1.Checked == true)
            {
                this.cmb_BC.Enabled = true;
                this.cmb_BB.Enabled = true;
                string bc = JJBStaticFunction.GetCurrentClass();
                string bb = JJBStaticFunction.GetCurrentClass_BC();
                if (!string.IsNullOrEmpty(bc))
                    cmb_BC.Value = bc.Substring(0, 1);
                if (!string.IsNullOrEmpty(bc))
                    cmb_BB.Value = bc.Substring(1, 1);
            }
            else
            {
                this.cmb_BC.Enabled = false;
                this.cmb_BB.Enabled = false;
            }
        }

        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();
                    }
                }
                JJBStaticFunction.SetRowEdit(ultraGrid2);
            }
            catch (System.Exception exp)
            {
                MessageBox.Show(exp.ToString());
            }

        }

        public override void ToolBar_Click(object sender, string ToolbarKey)
        {
            switch (ToolbarKey)
            {
                case "Query":
                    QueryData();
                    break;
                case "Exit":
                    this.Close();
                    break;
                default:
                    break;
            }
        }
        private void ckbTime_CheckedChanged(object sender, EventArgs e)
        {
            if (this.ckbTime.Checked == true)
            {

                this.uldtBeginTime.Enabled = true;
                this.uldtEndTime.Enabled = true;


            }
            else
            {
                this.uldtBeginTime.Enabled = false;
                this.uldtEndTime.Enabled = false;
            }
        }


        private void ultraCheckEditor3_CheckedChanged(object sender, EventArgs e)
        {
            this.uce_GWCode.Enabled = ultraCheckEditor3.Checked;
        }

        /// <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.LgMes.Client.LgIntegrationQuery.FrmYCJJB" + exp.Message);
             }
        }

        private void uce_GWCode_ValueChanged(object sender, EventArgs e)
        {
            QueryData();
        }

        private void cmb_BB_ValueChanged(object sender, EventArgs e)
        {
            QueryData();
        }


    }
}