JLART_WCS/ControlMonitorClient/FrmSeeManage.cs

using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Text;
using System.Windows.Forms;
using System.ServiceModel;
using DBFactory;
using System.Net.Sockets;
using System.Threading;
using System.Net;
using Microsoft.VisualBasic;


namespace wcfControlMonitorClient
{
    /// <summary>
    /// Creator:Richard.liu
    /// µ÷¶ÈÈÎÎñ¹ÜÀí
    /// </summary>
    public partial class FrmSeeManage : Form
    {
        string _manstatus= " F_Status>=-1 ";
        private static FrmSeeManage _formInstance;

        public static FrmSeeManage FormInstance
        {
            get
            {
                if (_formInstance == null)
                {
                    _formInstance = new FrmSeeManage();
                }
                return _formInstance;
            }
            set { _formInstance = value; }
        }
        
        Model.MDevice devinfo;
        DBOperator dbo = CStaticClass.dbo;
        DBOperator dboM = CStaticClass.dboM;
        public FrmSeeManage()
        {
            InitializeComponent();
            _formInstance = this;
        }

        private void rbmanAll_CheckedChanged(object sender, EventArgs e)
        {

            RadioButton rb = (RadioButton)sender;
            if (rb.Checked == true)
            {
                _manstatus = " F_Status>=-1 ";
            }
            TSMrefresh_Click();
        }

        private void TSMrefresh_Click()
        {
           
            this.dgvManager.DataSource = dbo.ExceSQL("select * from V_Manage_Task with(nolock) where " + _manstatus).Tables[0].DefaultView;
        }

        private void rbmanRun_CheckedChanged(object sender, EventArgs e)
        {
            if (rbmanRun.Checked == true)
            {
                _manstatus = " F_Status>=1 ";
            }
            TSMrefresh_Click();
        }

        private void rbmanWait_CheckedChanged(object sender, EventArgs e)
        {
            RadioButton rb = (RadioButton)sender;
            if (rb.Checked == true)
            {
                _manstatus = " F_Status=0 ";
            }
            TSMrefresh_Click();
        }

        private void button1_Click(object sender, EventArgs e)
        {
            try
            {
                if (this.textBox1.Text.Trim().Length == 0) return;
                if (this.comboBox1.Text == "ÌõÂë")
                {
                    //20091016
                    _manstatus = " ÌõÂë like '%" + this.textBox1.Text.Trim() + "%' ";
                }

                if (this.comboBox1.Text == "µ÷¶ÈÈÎÎñË÷Òý")
                {
                    _manstatus = " µ÷¶ÈÈÎÎñË÷Òý='" + this.textBox1.Text.Trim() + "' ";
                }
                TSMrefresh_Click();
            }
            catch (Exception ex)
            {
                MessageBox.Show(ex.Message, "²Ù×÷Ìáʾ£º", MessageBoxButtons.OK, MessageBoxIcon.Error);
            }
        }

        private void button2_Click(object sender, EventArgs e)
        {
            _manstatus = " F_Status>=-1 ";

            TSMrefresh_Click();
        }

        private void dgvManager_DataSourceChanged(object sender, EventArgs e)
        {
            dgvManager.Columns["F_Status"].Visible = false;
        }

      

        private void FrmModifyManage_Load(object sender, EventArgs e)
        {
            rbmanRun_CheckedChanged(sender, e);
        }

       
       
        int GetDeviceKindIdx(int devIdx)
        {
            try
            {
                devinfo = Model.CGetInfo.GetDeviceInfo(devIdx);
                return devinfo.DeviceKind;

            }
            catch (Exception ex)
            {
                throw ex;
            }
        }
        int GetManageTaskIndexfromMonitor(int monitorIdx)
        {
            DataView dv = dbo.ExceSQL("SELECT F_ManageTaskIndex FROM T_Monitor_Task WHERE (F_MonitorIndex = " + monitorIdx + ")").Tables[0].DefaultView;
            if (dv.Count > 0)
            {
                return Convert.ToInt32(dv[0]["F_ManageTaskIndex"]);
            }
            else
            {
                return -1;
            }
        }
        int GetManageTaskKindIndexFromMonitor(int monitorIdx)
        {
            DataView dv = dbo.ExceSQL("SELECT F_ManageTaskKindIndex FROM T_Monitor_Task WHERE (F_MonitorIndex = " + monitorIdx + ")").Tables[0].DefaultView;
            if (dv.Count > 0)
            {
                return Convert.ToInt32(dv[0]["F_ManageTaskKindIndex"]);
            }
            else
            {
                return -1;
            }
        }
        int GetDeviceOrderFromMonitor(int MonitorIndex)
        {
            try
            {
                string sql = "select F_DeviceCommandIndex from T_Monitor_Task where (F_DeviceCommandIndex IS NOT NULL) and F_MonitorIndex=" + MonitorIndex;
                DataView dv = dbo.ExceSQL(sql).Tables[0].DefaultView;
                if (dv.Count > 0)
                {
                    return Convert.ToInt32(dv[0]["F_DeviceCommandIndex"]);
                }
                else
                {
                    return -1;
                }
            }
            catch (Exception ex)
            {
                throw ex;
            }
        }

        private void comboBox1_SelectedIndexChanged(object sender, EventArgs e)
        {
            try
            {
                string df = "";

                switch (this.comboBox1.Text)
                {
                    case "ÌõÂë":
                        df = "ÌõÂë";
                        break;
                    case "µ÷¶ÈÈÎÎñË÷Òý":
                        df = "µ÷¶ÈÈÎÎñË÷Òý";
                        break;
                    


                    default:
                        return;
                }
                //20100208
                string sql = "select distinct " + df + " from V_Manage_Task with(nolock) ";
                DataView dv = dbo.ExceSQL(sql).Tables[0].DefaultView;
                if (dv.Count > 0)
                {
                    this.textBox1.DataSource = null;
                    this.textBox1.DisplayMember = df;
                    this.textBox1.ValueMember = df;
                    this.textBox1.DataSource = dv;
                }
            }
            catch (Exception ex)
            {
                throw ex;
            }
        }

        private void dgvManager_CellMouseDown(object sender, DataGridViewCellMouseEventArgs e)
        {
            if ((e.ColumnIndex >= 0) && (e.RowIndex >= 0) && (e.Button == MouseButtons.Right))//20110309
            {
                dgvManager.ClearSelection();
                dgvManager.Rows[e.RowIndex].Selected = true;
                dgvManager.CurrentCell = dgvManager.Rows[e.RowIndex].Cells[e.ColumnIndex];

            }
        }
        void ModifyManageTaskCallBack(IAsyncResult ar)
        {
            string errtext=string.Empty;
            
            if (CStaticClass.WcfControl.EndModifyManageTask(out errtext, ar) == false)
            {
                MessageBox.Show(errtext, "²Ù×÷Ìáʾ£º", MessageBoxButtons.OK, MessageBoxIcon.Error);
            }
            if (this.IsDisposed == true) return;
            this.BeginInvoke(new MethodInvoker (delegate()
                {
                    TSMrefresh_Click();
                }
            ));
            
        }
        void ModifyManageTask1CallBack(IAsyncResult ar)
        {
            string errtext = string.Empty;

            if (CStaticClass.WcfControl.EndModifyManageTask1(out errtext, ar) == false)
            {
                MessageBox.Show(errtext, "²Ù×÷Ìáʾ£º", MessageBoxButtons.OK, MessageBoxIcon.Error);
            }
            if (this.IsDisposed == true) return;
            this.BeginInvoke(new MethodInvoker(delegate()
            {
                TSMrefresh_Click();
            }
            ));

        }

        private void FrmModifyManage_FormClosing(object sender, FormClosingEventArgs e)
        {
            _formInstance = null;
        }

        private void dgvManager_CellDoubleClick(object sender, DataGridViewCellEventArgs e)
        {
            if ((e.ColumnIndex >= 0) && (e.RowIndex >= 0))
            {
                dgvManager.ClearSelection();
                dgvManager.Rows[e.RowIndex].Selected = true;
                dgvManager.CurrentCell = dgvManager.Rows[e.RowIndex].Cells[e.ColumnIndex];
                FrmModifyMonitor.FormInstance.comboBox1.Text = "ÌõÂë";
                FrmModifyMonitor.FormInstance.textBox1.Text = dgvManager.CurrentRow.Cells["ÌõÂë"].Value.ToString();
                FrmModifyMonitor.FormInstance.Show();
                FrmModifyMonitor.FormInstance.button1_Click(sender, e);
                this.Visible = false;
            }
        }

       
       

        private void radioButton1_CheckedChanged(object sender, EventArgs e)
        {
            RadioButton rb = (RadioButton)sender;
            if (rb.Checked == true)
            {
                _manstatus = " ÌõÂë like '%PAT%' ";
            }
            TSMrefresh_Click();
        }

        private void radioButton2_CheckedChanged(object sender, EventArgs e)
        {
            RadioButton rb = (RadioButton)sender;
            if (rb.Checked == true)
            {
                _manstatus = " ÌõÂë like '%BOX%' ";
            }
            TSMrefresh_Click();
        }

        private void radioButton4_CheckedChanged(object sender, EventArgs e)
        {
            RadioButton rb = (RadioButton)sender;
            if (rb.Checked == true)
            {
                _manstatus = " ÌõÂë like '%PAT%' and F_Status>=1";
            }
            TSMrefresh_Click();
        }

        private void radioButton3_CheckedChanged(object sender, EventArgs e)
        {
            RadioButton rb = (RadioButton)sender;
            if (rb.Checked == true)
            {
                _manstatus = " ÌõÂë like '%BOX%' and F_Status>=1";
            }
            TSMrefresh_Click();
        }
    }
}