SSWCS_PZHDS/ControlMonitorClient/39001status.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 Frm39001status : Form
    {
        public Frm39001status()
        {
            InitializeComponent();
        }

        private static Frm39001status _formInstance;

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

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

        private void comboBox1_SelectedIndexChanged(object sender, EventArgs e)
        {
            int deviceindex = 39001;
            int selectedStatus = Convert.ToInt32(comboBox1.SelectedItem.ToString());
            StringBuilder sql = new StringBuilder();
            sql.Remove(0, sql.Length);
            sql.Append("update T_Base_Device_Full_NotFull set Full_Flag=").Append(selectedStatus).Append(" where DeviceIndex=").Append(deviceindex);
           CStaticClass.dbo.ExceSQL(sql.ToString());


           //int deviceindex = 39001;
          // StringBuilder sql = new StringBuilder();
           sql.Remove(0, sql.Length);
           sql.Append("select Full_Flag from  T_Base_Device_Full_NotFull ").Append(" where DeviceIndex=").Append(deviceindex);
           DataTable tem = CStaticClass.dbo.ExceSQL(sql.ToString()).Tables[0];

           if (tem.Rows.Count > 0)
           {
               label2.Text = Convert.ToString(tem.Rows[0]["Full_Flag"]);
           }
        }

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

        private void Frm39001status_Load(object sender, EventArgs e)
        {
                    
            int deviceindex = 39001;
            StringBuilder sql = new StringBuilder();
            sql.Remove(0, sql.Length);
            sql.Append("select Full_Flag from  T_Base_Device_Full_NotFull ").Append(" where DeviceIndex=").Append(deviceindex);
            DataTable tem = CStaticClass.dbo.ExceSQL(sql.ToString()).Tables[0];
            
            if (tem.Rows.Count > 0)
            {
                label2.Text = Convert.ToString(tem.Rows[0]["Full_Flag"]);
            }
        }

        private void button1_Click(object sender, EventArgs e)
        {

            int deviceindex = 39001;
            StringBuilder sql = new StringBuilder();
            sql.Remove(0, sql.Length);
            sql.Append("select Full_Flag from  T_Base_Device_Full_NotFull ").Append(" where DeviceIndex=").Append(deviceindex);
            DataTable tem = CStaticClass.dbo.ExceSQL(sql.ToString()).Tables[0];

            if (tem.Rows.Count > 0)
            {
                label2.Text = Convert.ToString(tem.Rows[0]["Full_Flag"]);
            }
        }
    }
}