SDSDYLH_WCS/ControlMonitorClient/FrmDemoSet.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 FrmDemoSet : Form
    {
        private static FrmDemoSet _formInstance;
        public static FrmDemoSet FormInstance
        {
            get
            {
                if (_formInstance == null)
                {
                    _formInstance = new FrmDemoSet();
                }
                return _formInstance;
            }
            set { _formInstance = value; }
        }
        StringBuilder sql = new StringBuilder();      
        DBOperator dbo = new DBOperator();       
        DataView dv = new DataView();
        
        
        public FrmDemoSet()
        {
            InitializeComponent();
        }


        private void FrmDemoSet_Load(object sender, EventArgs e)
        {

            string warehouseType = string.Empty;
            sql.Remove(0, sql.Length);
            sql.Append("select * from T_WareHouse_DemoSet");
            dv = dbo.ExceSQL(sql.ToString()).Tables[0].DefaultView;
            for (int i = 0; i < dv.Count; i++)
            {
                try
                {


                    warehouseType = dv[i]["FWarehouseType"].ToString();

                    switch (warehouseType)
                    {
                        case "B":


                            if (Convert.ToInt32(dv[i]["F_Lifter"]) == 1)
                            {
                                liaoxiang_Demo_Yes.Checked = true;
                                liaoxiang_Demo_No.Checked = false;
                            }
                            else if (Convert.ToInt32(dv[i]["F_Lifter"]) == 0)
                            {
                                liaoxiang_Demo_Yes.Checked = false;
                                liaoxiang_Demo_No.Checked = true;
                            }

                            break;
                      

                    }
                }
                catch (Exception ee) { }
            }
        }


        private void liaoxiang_save_Click(object sender, EventArgs e)
        {
            try
            {
                int flag = 0;
                string mode = string.Empty;
                if (liaoxiang_Demo_Yes.Checked == true)
                {
                    if (MessageBox.Show("您确定要切换为出库提升机吗？", "操作提示：", MessageBoxButtons.OKCancel, MessageBoxIcon.Question) != DialogResult.OK)
                    {
                        return;
                    }


                    flag = 1;
                }
                else
                if (liaoxiang_Demo_No.Checked == true)
                {
                    if (MessageBox.Show("您确定要切换为入库提升机吗？", "操作提示：", MessageBoxButtons.OKCancel, MessageBoxIcon.Question) != DialogResult.OK)
                    {
                        return;
                    }
                 
                    flag = 0;
                }

                sql.Remove(0, sql.Length);
                sql.Append("update T_WareHouse_DemoSet set F_Lifter=").Append(flag).Append(" where FWarehouseType='B'");

                int aa = dbo.ExecuteSql(sql.ToString());
                if(flag==1)
                {
                    mode="使用出库提升机";

                }
                else if (flag == 0) 
                {
                    mode = "使用入库提升机";

                }
                CommonClassLib.CCarryConvert.WriteDarkCasket("提升机设置", "sql语句影响行数："+aa.ToString(), "提升机模式设置："+flag.ToString(), "-----------");
                MessageBox.Show(""+mode+"设置成功", "操作提示", MessageBoxButtons.OK, MessageBoxIcon.Warning);
            }
            catch (Exception ex)
            {
                throw ex;
            }
        }

        private void tuopan_save_Click(object sender, EventArgs e)
        {

            try
            {
                int tflag = 0;
                string tmode = string.Empty;
                Model.MDevice devicee;
                Model.MDevice deviceee;
                DataView dv6;
                

                sql.Remove(0, sql.Length);
                sql.Append("update T_WareHouse_DemoSet set FDemoFlag=").Append(tflag).Append(" where FWarehouseType='T'");

                int taa = dbo.ExecuteSql(sql.ToString());
                if(tflag==1)
                {
                    tmode="演示模式开启";

                }
                else if (tflag == 0) 
                {
                    tmode = "演示模式关闭";

                }
                CommonClassLib.CCarryConvert.WriteDarkCasket("托盘库", "sql语句影响行数："+taa.ToString(), "托盘库演示模式设置："+tflag.ToString(), "-----------");
                MessageBox.Show("托盘库"+tmode+"成功", "操作提示", MessageBoxButtons.OK, MessageBoxIcon.Warning);
            }
            catch (Exception ex)
            {
                throw ex;
            }
        }

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

      
    }
}