SDSDYLH_WCS/ControlMonitorClient/FrmUpdateStatus.cs

using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Linq;
using System.Text;
using System.Windows.Forms;
using DBFactory;

namespace wcfControlMonitorClient
{
    public partial class FrmUpdateStatus : Form
    {

        string _manstatus = " F_Status=996 or F_Status=976 or F_Status=906 ";
        private static FrmUpdateStatus _formInstance;

        public static FrmUpdateStatus FormInstance
        {
            get
            {
                if (_formInstance == null)
                {
                    _formInstance = new FrmUpdateStatus();
                }
                return _formInstance;
            }
            set { _formInstance = value; }
        }

        Model.MDevice devinfo;
        DBOperator dbo = CStaticClass.dbo;
        DBOperator dboM = CStaticClass.dboM;
        public FrmUpdateStatus()
        {
            InitializeComponent();
            _formInstance = this;
        }


        private void TSMrefresh_Click()
        {

            this.interfaceGridView.DataSource = dbo.ExceSQL("select CONTROL_APPLY_ID,CONTROL_ID,CONTROL_APPLY_TYPE,STOCK_BARCODE,APPLY_TASK_STATUS,CREATE_TIME,CONTROL_APPLY_PARAMETER,CONTROL_APPLY_REMARK from IO_CONTROL_APPLY_HIS order by CREATE_TIME desc).Tables[0].DefaultView;");
            this.interfaceGridView.Columns["CONTROL_APPLY_ID"].HeaderText = "ID号";
            this.interfaceGridView.Columns["CONTROL_ID"].HeaderText = "WMS任务号";
            this.interfaceGridView.Columns["CONTROL_APPLY_TYPE"].HeaderText = "处理类型";
            this.interfaceGridView.Columns["STOCK_BARCODE"].HeaderText = "条码";
            this.interfaceGridView.Columns["APPLY_TASK_STATUS"].HeaderText = "处理状态";
            this.interfaceGridView.Columns["CREATE_TIME"].HeaderText = "创建时间";
            this.interfaceGridView.Columns["CONTROL_APPLY_PARAMETER"].HeaderText = "报警信息";
            this.interfaceGridView.Columns["CONTROL_APPLY_REMARK"].HeaderText = "异常信息";
        }

        private void Button1_Click(object sender, EventArgs e)
        {
            try
            {
                

                TSMrefresh_Click();
            }
            catch (Exception ex)
            {
                MessageBox.Show(ex.Message, "操作提示：", MessageBoxButtons.OK, MessageBoxIcon.Error);
            }
        }

        private void Button2_Click(object sender, EventArgs e)
        {
            _manstatus = " APPLY_TASK_STATUS=996 or APPLY_TASK_STATUS=976 or APPLY_TASK_STATUS=906 ";
        }

        private void FormUpdateStatus_Load(object sender, EventArgs e)
        {
            rbmanRun_Click(sender, e);
        }
        private void rbmanRun_Click(object sender, EventArgs e)
        {
            if (rbmanRun.Checked == true)
            {
                _manstatus = "  APPLY_TASK_STATUS=996 or APPLY_TASK_STATUS=976 ";
            }
            TSMrefresh_Click();
        }
        private void rbmanWait_Click(object sender, EventArgs e)
        {
            RadioButton rb = (RadioButton)sender;
            if (rb.Checked == true)
            {
                _manstatus = " APPLY_TASK_STATUS=906 ";
            }
            TSMrefresh_Click();
        }
        private void RbmanRun_CheckedChanged(object sender, EventArgs e)
        {

        }

        private void RbmanWait_CheckedChanged(object sender, EventArgs e)
        {

        }

        private void TSMmanagerOK_Click(object sender, EventArgs e) //接口再次调用
        {


            try
            {
                if (MessageBox.Show("您确认任务：“" + this.interfaceGridView.CurrentRow.Cells["CONTROL_ID"].Value.ToString() + "要重新调用接口吗？", "操作提示：", MessageBoxButtons.OKCancel, MessageBoxIcon.Question) != DialogResult.OK)
                {
                    return;
                }
                int status = -1;
                if (Convert.ToInt32(this.interfaceGridView.CurrentRow.Cells["CONTROL_APPLY_TYPE"].Value.ToString()) == 996)
                {
                    status = 999;
                }
                else if (Convert.ToInt32(this.interfaceGridView.CurrentRow.Cells["CONTROL_APPLY_TYPE"].Value.ToString()) == 976 || Convert.ToInt32(this.interfaceGridView.CurrentRow.Cells["CONTROL_APPLY_TYPE"].Value.ToString()) == 906)
                {
                    status = Convert.ToInt32(this.interfaceGridView.CurrentRow.Cells["CONTROL_APPLY_TYPE"].Value.ToString()) - 6;
                }

                    dbo.ExecuteSql(string.Format("UPDATE IO_CONTROL_APPLY set APPLY_TASK_STATUS = {1}, CONTROL_APPLY_TYPE ={1} WHERE (CONTROL_APPLY_ID = {0})", Convert.ToInt32(this.interfaceGridView.CurrentRow.Cells["CONTROL_APPLY_ID"].Value.ToString()),status));
                TSMrefresh_Click();
            }
            catch (Exception ex)
            {
                MessageBox.Show(ex.Message, "操作提示：", MessageBoxButtons.OK, MessageBoxIcon.Error);
            }


        }

        private void ToolStripMenuItem1_Click(object sender, EventArgs e) //接口异常删除
        {

            try
            {
                if (MessageBox.Show("您确认任务：“" + this.interfaceGridView.CurrentRow.Cells["CONTROL_ID"].Value.ToString() + "要删除接口异常信息吗？", "操作提示：", MessageBoxButtons.OKCancel, MessageBoxIcon.Question) != DialogResult.OK)
                {
                    return;
                }

                dbo.ExecuteSql(string.Format("DELETE FROM IO_CONTROL_APPLY WHERE (CONTROL_APPLY_ID = {0})", Convert.ToInt32(this.interfaceGridView.CurrentRow.Cells["CONTROL_APPLY_ID"].Value.ToString())));//民航二所 删除当前条 创建触发器删除时写入历史表
                
                TSMrefresh_Click();
            }
            catch (Exception ex)
            {
                MessageBox.Show(ex.Message, "操作提示：", MessageBoxButtons.OK, MessageBoxIcon.Error);
            }
           
        }

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

        private void RbmanRun_Click_1(object sender, EventArgs e)
        {
            if (rbmanRun.Checked == true)
            {
                _manstatus = "  APPLY_TASK_STATUS=996 or APPLY_TASK_STATUS=976 ";
            }
            TSMrefresh_Click();
        }

        private void RbmanWait_Click_1(object sender, EventArgs e)
        {
            RadioButton rb = (RadioButton)sender;
            if (rb.Checked == true)
            {
                _manstatus = " APPLY_TASK_STATUS=906 ";
            }
            TSMrefresh_Click();
        }

        private void RbmanAll_Click(object sender, EventArgs e)
        {
            RadioButton rb = (RadioButton)sender;
            if (rb.Checked == true)
            {
                _manstatus = "APPLY_TASK_STATUS=996 or APPLY_TASK_STATUS=976 or APPLY_TASK_STATUS=906  ";
            }
            TSMrefresh_Click();
        }

        private void CmManager_Opening(object sender, CancelEventArgs e)
        {
            if (this.interfaceGridView.CurrentRow == null)
            {
                TSMmanagerOK.Visible = false;
                
                toolStripSeparator1.Visible = false;
                ;
                toolStripMenuItem1.Visible = false;
                toolStripSeparator2.Visible = false;
                return;
            }
            if (Convert.ToInt32(this.interfaceGridView.CurrentRow.Cells["CONTROL_ID"].Value) > 0)
            {
                TSMmanagerOK.Visible = true;

              
                toolStripSeparator1.Visible = true;
                toolStripSeparator2.Visible = true;
                //TSMmanagerDisassemble.Visible = true;
                toolStripMenuItem1.Visible = true;
               


            }
        }

        private void InterfaceGridView_CellMouseDown(object sender, DataGridViewCellMouseEventArgs e)
        {
            if (e.Button == MouseButtons.Right)
            {
                if ((e.RowIndex >= 0) && (e.ColumnIndex >= 0))
                {
                    //若行已是选中状态就不再进行设置
                    if (interfaceGridView.Rows[e.RowIndex].Selected == false)
                    {
                        interfaceGridView.ClearSelection();
                        interfaceGridView.Rows[e.RowIndex].Selected = true;
                    }
                    //只选中一行时设置活动单元格
                    if (interfaceGridView.SelectedRows.Count == 1)
                    {
                        interfaceGridView.CurrentCell = interfaceGridView.Rows[e.RowIndex].Cells[e.ColumnIndex];
                    }
                    //弹出操作菜单
                    cmManager.Show(MousePosition.X, MousePosition.Y);
                }
            }
        }
    }
}