DTJA_WCS_PRODUCT/ControlMonitorClient_PRODUCT/FrmOutCountandHave14005.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;
using System.ServiceModel;

namespace wcfControlMonitorClient
{
    public partial class FrmOutCountandHave14005 : Form
    {
        DBFactory.DBOperator dbo = CStaticClass.dbo;
        DBFactory.DBOperator dboM = CStaticClass.dboM;
        public FrmOutCountandHave14005()
        {
            InitializeComponent();
        }

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


        private void button1_Click(object sender, EventArgs e)
        {
            int have = Convert.ToInt32(comboBox14005.SelectedIndex);
            StringBuilder sql=new StringBuilder();
            sql.Append("update  T_BASE_HORT set HAVE_FLAG  = ").Append(have.ToString()).Append("WHERE (F_DEVICE_INDEX = 16019)");
            dbo.ExceSQL(sql.ToString());
            CommonClassLib.CCarryConvert.WriteDarkCasket("手动设置14005有无货状态为：", "", "", Convert.ToString(comboBox14005.Text));
        }

        private void button2_Click(object sender, EventArgs e)//1号
        {
            if (this.tb1.Text.Trim() == "")
            {
                MessageBox.Show("请输入数量", "操作提示：", MessageBoxButtons.OK, MessageBoxIcon.Warning);
                this.tb1.Focus();
                return;
            }
            int have = Convert.ToInt32(tb1.Text);
            StringBuilder sql = new StringBuilder();
            sql.Append("update  T_BASE_HORT set HAVE_FLAG  = ").Append(have.ToString()).Append("WHERE (F_DEVICE_INDEX = 14080)");
            dbo.ExceSQL(sql.ToString());
            CommonClassLib.CCarryConvert.WriteDarkCasket("手动设置14080,1号出库任务数量为：", "", "", Convert.ToString(tb1.Text));
        }

        private void button3_Click(object sender, EventArgs e)//2号
        {
            if (this.tb2.Text.Trim() == "")
            {
                MessageBox.Show("请输入数量", "操作提示：", MessageBoxButtons.OK, MessageBoxIcon.Warning);
                this.tb2.Focus();
                return;
            }
            int have = Convert.ToInt32(tb2.Text);
            StringBuilder sql = new StringBuilder();
            sql.Append("update  T_BASE_HORT set HAVE_FLAG  = ").Append(have.ToString()).Append("WHERE (F_DEVICE_INDEX = 14079)");
            dbo.ExceSQL(sql.ToString());
            CommonClassLib.CCarryConvert.WriteDarkCasket("手动设置14079,2号出库任务数量为：", "", "", Convert.ToString(tb2.Text));
        }

        private void button4_Click(object sender, EventArgs e)//3
        {
            if (this.tb3.Text.Trim() == "")
            {
                MessageBox.Show("请输入数量", "操作提示：", MessageBoxButtons.OK, MessageBoxIcon.Warning);
                this.tb3.Focus();
                return;
            }
            int have = Convert.ToInt32(tb3.Text);
            StringBuilder sql = new StringBuilder();
            sql.Append("update  T_BASE_HORT set HAVE_FLAG  = ").Append(have.ToString()).Append("WHERE (F_DEVICE_INDEX = 14048)");
            dbo.ExceSQL(sql.ToString());
            CommonClassLib.CCarryConvert.WriteDarkCasket("手动设置14048,3号出库任务数量为：", "", "", Convert.ToString(tb3.Text));
        }

        private void button5_Click(object sender, EventArgs e)//4
        {
            if (this.tb4.Text.Trim() == "")
            {
                MessageBox.Show("请输入数量", "操作提示：", MessageBoxButtons.OK, MessageBoxIcon.Warning);
                this.tb4.Focus();
                return;
            }
            int have = Convert.ToInt32(tb4.Text);
            StringBuilder sql = new StringBuilder();
            sql.Append("update  T_BASE_HORT set HAVE_FLAG  = ").Append(have.ToString()).Append("WHERE (F_DEVICE_INDEX = 14047)");
            dbo.ExceSQL(sql.ToString());
            CommonClassLib.CCarryConvert.WriteDarkCasket("手动设置14047,4号出库任务数量为：", "", "", Convert.ToString(tb4.Text));
        }

        private void button6_Click(object sender, EventArgs e)//5
        {
            if (this.tb5.Text.Trim() == "")
            {
                MessageBox.Show("请输入数量", "操作提示：", MessageBoxButtons.OK, MessageBoxIcon.Warning);
                this.tb5.Focus();
                return;
            }
            int have = Convert.ToInt32(tb5.Text);
            StringBuilder sql = new StringBuilder();
            sql.Append("update  T_BASE_HORT set HAVE_FLAG  = ").Append(have.ToString()).Append("WHERE (F_DEVICE_INDEX = 14023)");
            dbo.ExceSQL(sql.ToString());
            CommonClassLib.CCarryConvert.WriteDarkCasket("手动设置14023,5号出库任务数量为：", "", "", Convert.ToString(tb5.Text));
        }

        private void button7_Click(object sender, EventArgs e)//6
        {
            if (this.tb6.Text.Trim() == "")
            {
                MessageBox.Show("请输入数量", "操作提示：", MessageBoxButtons.OK, MessageBoxIcon.Warning);
                this.tb6.Focus();
                return;
            }
            int have = Convert.ToInt32(tb6.Text);
            StringBuilder sql = new StringBuilder();
            sql.Append("update  T_BASE_HORT set HAVE_FLAG  = ").Append(have.ToString()).Append("WHERE (F_DEVICE_INDEX = 14022)");
            dbo.ExceSQL(sql.ToString());
            CommonClassLib.CCarryConvert.WriteDarkCasket("手动设置14022,6号出库任务数量为：", "", "", Convert.ToString(tb6.Text));
        }

        private void FrmOutCountandHave14005_Load(object sender, EventArgs e)
        {

        }

        private void button8_Click(object sender, EventArgs e)
        {
            DataView dvsp = new DataView();

            dvsp = dbo.ExceSQL(string.Format("select HAVE_FLAG  from T_BASE_HORT  order by ORDER_N ")).Tables[0].DefaultView;
            if (dvsp.Count >= 7)
            {
                tb6.Text = Convert.ToString(dvsp[0]["HAVE_FLAG"]);
                tb5.Text = Convert.ToString(dvsp[1]["HAVE_FLAG"]);
                tb4.Text = Convert.ToString(dvsp[2]["HAVE_FLAG"]);
                tb3.Text = Convert.ToString(dvsp[3]["HAVE_FLAG"]);
                tb2.Text = Convert.ToString(dvsp[4]["HAVE_FLAG"]);
                tb1.Text = Convert.ToString(dvsp[5]["HAVE_FLAG"]);

                if (Convert.ToString(dvsp[6]["HAVE_FLAG"]) == "0")
                {
                    comboBox14005.Text = "无货";
                }
                else
                {
                    comboBox14005.Text = "有货";
                }

                T13076.Text = Convert.ToString(dvsp[7]["HAVE_FLAG"]);
                T13063.Text = Convert.ToString(dvsp[8]["HAVE_FLAG"]);
                T13045.Text = Convert.ToString(dvsp[9]["HAVE_FLAG"]);
                TbOverTime.Text = Convert.ToString(dvsp[10]["HAVE_FLAG"]);
                TbOBTOverTime.Text = Convert.ToString(dvsp[11]["HAVE_FLAG"]);


            }


            DataView dvspMax = new DataView();


            dvsp = dbo.ExceSQL(string.Format("select MAXCOUNT,count  from T_DOUBLEGATE  order by lane ")).Tables[0].DefaultView;
            if (dvsp.Count >= 0)
            {
                tbmaxcount.Text = Convert.ToString(dvsp[0]["MAXCOUNT"]);

                tb18002sendcount.Text = Convert.ToString(dvsp[0]["count"]);
                tb18003sendcount.Text = Convert.ToString(dvsp[1]["count"]);
                tb18004sendcount.Text = Convert.ToString(dvsp[2]["count"]);
                tb18005sendcount.Text = Convert.ToString(dvsp[3]["count"]);
                tb18006sendcount.Text = Convert.ToString(dvsp[4]["count"]);
                tb18007sendcount.Text = Convert.ToString(dvsp[5]["count"]);
                tb18009sendcount.Text = Convert.ToString(dvsp[6]["count"]);
                tb18010sendcount.Text = Convert.ToString(dvsp[7]["count"]);
                tb18012sendcount.Text = Convert.ToString(dvsp[8]["count"]);
                tb18013sendcount.Text = Convert.ToString(dvsp[9]["count"]);
                tb18015sendcount.Text = Convert.ToString(dvsp[10]["count"]);
                tb18016sendcount.Text = Convert.ToString(dvsp[11]["count"]);

                tb11002.Text = Convert.ToString(dvsp[0]["maxcount"]);
                tb11003.Text = Convert.ToString(dvsp[2]["maxcount"]);
                tb11004.Text = Convert.ToString(dvsp[4]["maxcount"]);
                tb11006.Text = Convert.ToString(dvsp[6]["maxcount"]);
                tb11008.Text = Convert.ToString(dvsp[8]["maxcount"]);
                tb11010.Text = Convert.ToString(dvsp[10]["maxcount"]);
            }



            DataView dvspLANE = new DataView();
            dvspLANE = dboM.ExceSQL(string.Format("select LANEWAY,DEVICE  from IO_CONTROL_LANEWAY WHERE IS_DEVICE_IN = 1  order by LANEWAY ")).Tables[0].DefaultView;

            if (dvspLANE.Count > 0)
            {
                lB11002.Text = Convert.ToString(dvspLANE[1]["DEVICE"]);
                LANE11002.Text = Convert.ToString(dvspLANE[1]["LANEWAY"]);

                lB11003.Text = Convert.ToString(dvspLANE[2]["DEVICE"]);
                LANE11003.Text = Convert.ToString(dvspLANE[2]["LANEWAY"]);

                lB11004.Text = Convert.ToString(dvspLANE[3]["DEVICE"]);
                LANE11004.Text = Convert.ToString(dvspLANE[3]["LANEWAY"]);

                lB11006.Text = Convert.ToString(dvspLANE[5]["DEVICE"]);
                LANE11006.Text = Convert.ToString(dvspLANE[5]["LANEWAY"]);

                lB11008.Text = Convert.ToString(dvspLANE[7]["DEVICE"]);
                LANE11008.Text = Convert.ToString(dvspLANE[7]["LANEWAY"]);

                lB11010.Text = Convert.ToString(dvspLANE[9]["DEVICE"]);
                LANE11010.Text = Convert.ToString(dvspLANE[9]["LANEWAY"]);

            }
        }

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

        private void button9_Click(object sender, EventArgs e)
        {
            if (this.T13076.Text.Trim() == "")
            {
                MessageBox.Show("请输入数量", "操作提示：", MessageBoxButtons.OK, MessageBoxIcon.Warning);
                this.T13076.Focus();
                return;
            }
            int have = Convert.ToInt32(T13076.Text);
            StringBuilder sql = new StringBuilder();
            sql.Append("update  T_BASE_HORT set HAVE_FLAG  = ").Append(have.ToString()).Append("WHERE (F_DEVICE_INDEX = 13076)");
            dbo.ExceSQL(sql.ToString());
            CommonClassLib.CCarryConvert.WriteDarkCasket("手动设置13076,托盘垛出库任务数量为：", "", "", Convert.ToString(T13076.Text));
        }

        private void button10_Click(object sender, EventArgs e)
        {
            if (this.T13063.Text.Trim() == "")
            {
                MessageBox.Show("请输入数量", "操作提示：", MessageBoxButtons.OK, MessageBoxIcon.Warning);
                this.T13063.Focus();
                return;
            }
            int have = Convert.ToInt32(T13063.Text);
            StringBuilder sql = new StringBuilder();
            sql.Append("update  T_BASE_HORT set HAVE_FLAG  = ").Append(have.ToString()).Append("WHERE (F_DEVICE_INDEX = 13063)");
            dbo.ExceSQL(sql.ToString());
            CommonClassLib.CCarryConvert.WriteDarkCasket("手动设置13063,原料入口供空托盘垛任务数量为：", "", "", Convert.ToString(T13063.Text));
        }

        private void button11_Click(object sender, EventArgs e)
        {
            if (this.T13045.Text.Trim() == "")
            {
                MessageBox.Show("请输入数量", "操作提示：", MessageBoxButtons.OK, MessageBoxIcon.Warning);
                this.T13045.Focus();
                return;
            }
            int have = Convert.ToInt32(T13045.Text);
            StringBuilder sql = new StringBuilder();
            sql.Append("update  T_BASE_HORT set HAVE_FLAG  = ").Append(have.ToString()).Append("WHERE (F_DEVICE_INDEX = 13045)");
            dbo.ExceSQL(sql.ToString());
            CommonClassLib.CCarryConvert.WriteDarkCasket("手动设置13045,原料出口任务数量为：", "", "", Convert.ToString(T13045.Text));

        }

        private void btmaxcount_Click(object sender, EventArgs e)
        {
             if (this.tbmaxcount.Text.Trim() == "")
            {
                MessageBox.Show("请输入数量", "操作提示：", MessageBoxButtons.OK, MessageBoxIcon.Warning);
                this.tbmaxcount.Focus();
                return;
            }
             int maxcount = Convert.ToInt32(tbmaxcount.Text);
             StringBuilder sql = new StringBuilder();
             sql.Append("update  T_DOUBLEGATE set MAXCOUNT  = ").Append(maxcount.ToString());
             dbo.ExceSQL(sql.ToString());
             CommonClassLib.CCarryConvert.WriteDarkCasket("手动设置弯道垛机连续出库时单侧数量为：", "", "", Convert.ToString(tbmaxcount.Text));
        }

        private void bt11002_Click(object sender, EventArgs e)
        {
            if (this.tb11002.Text.Trim() == "")
            {
                MessageBox.Show("请输入数量", "操作提示：", MessageBoxButtons.OK, MessageBoxIcon.Warning);
                this.tb11002.Focus();
                return;
            }
            int maxcount = Convert.ToInt32(tb11002.Text);
            StringBuilder sql = new StringBuilder();
            sql.Append("update  T_DOUBLEGATE set MAXCOUNT  = ").Append(maxcount.ToString()).Append(" where device = 11002");
            dbo.ExceSQL(sql.ToString());
            CommonClassLib.CCarryConvert.WriteDarkCasket("手动设置弯道垛机连续出库时11002单侧数量为：", "", "", Convert.ToString(maxcount));
        }

        private void but11003_Click(object sender, EventArgs e)
        {
            if (this.tb11003.Text.Trim() == "")
            {
                MessageBox.Show("请输入数量", "操作提示：", MessageBoxButtons.OK, MessageBoxIcon.Warning);
                this.tb11003.Focus();
                return;
            }
            int maxcount = Convert.ToInt32(tb11003.Text);
            StringBuilder sql = new StringBuilder();
            sql.Append("update  T_DOUBLEGATE set MAXCOUNT  = ").Append(maxcount.ToString()).Append(" where device = 11003");
            dbo.ExceSQL(sql.ToString());
            CommonClassLib.CCarryConvert.WriteDarkCasket("手动设置弯道垛机连续出库时11003单侧数量为：", "", "", Convert.ToString(maxcount));
        }

        private void bt11004_Click(object sender, EventArgs e)
        {
            if (this.tb11004.Text.Trim() == "")
            {
                MessageBox.Show("请输入数量", "操作提示：", MessageBoxButtons.OK, MessageBoxIcon.Warning);
                this.tb11004.Focus();
                return;
            }
            int maxcount = Convert.ToInt32(tb11004.Text);
            StringBuilder sql = new StringBuilder();
            sql.Append("update  T_DOUBLEGATE set MAXCOUNT  = ").Append(maxcount.ToString()).Append(" where device = 11004");
            dbo.ExceSQL(sql.ToString());
            CommonClassLib.CCarryConvert.WriteDarkCasket("手动设置弯道垛机连续出库时11004单侧数量为：", "", "", Convert.ToString(maxcount));
        }

        private void bt11006_Click(object sender, EventArgs e)
        {
            if (this.tb11006.Text.Trim() == "")
            {
                MessageBox.Show("请输入数量", "操作提示：", MessageBoxButtons.OK, MessageBoxIcon.Warning);
                this.tb11006.Focus();
                return;
            }
            int maxcount = Convert.ToInt32(tb11006.Text);
            StringBuilder sql = new StringBuilder();
            sql.Append("update  T_DOUBLEGATE set MAXCOUNT  = ").Append(maxcount.ToString()).Append(" where device = 11006");
            dbo.ExceSQL(sql.ToString());
            CommonClassLib.CCarryConvert.WriteDarkCasket("手动设置弯道垛机连续出库时11006单侧数量为：", "", "", Convert.ToString(maxcount));
        }

        private void bt11008_Click(object sender, EventArgs e)
        {
            if (this.tb11008.Text.Trim() == "")
            {
                MessageBox.Show("请输入数量", "操作提示：", MessageBoxButtons.OK, MessageBoxIcon.Warning);
                this.tb11008.Focus();
                return;
            }
            int maxcount = Convert.ToInt32(tb11008.Text);
            StringBuilder sql = new StringBuilder();
            sql.Append("update  T_DOUBLEGATE set MAXCOUNT  = ").Append(maxcount.ToString()).Append(" where device = 11008 ");
            dbo.ExceSQL(sql.ToString());
            CommonClassLib.CCarryConvert.WriteDarkCasket("手动设置弯道垛机连续出库时11008单侧数量为：", "", "", Convert.ToString(maxcount));
        }

        private void bt11010_Click(object sender, EventArgs e)
        {
            if (this.tb11010.Text.Trim() == "")
            {
                MessageBox.Show("请输入数量", "操作提示：", MessageBoxButtons.OK, MessageBoxIcon.Warning);
                this.tb11010.Focus();
                return;
            }
            int maxcount = Convert.ToInt32(tb11010.Text);
            StringBuilder sql = new StringBuilder();
            sql.Append("update  T_DOUBLEGATE set MAXCOUNT  = ").Append(maxcount.ToString()).Append(" where device = 11010 ");
            dbo.ExceSQL(sql.ToString());
            CommonClassLib.CCarryConvert.WriteDarkCasket("手动设置弯道垛机连续出库时11010单侧数量为：", "", "", Convert.ToString(maxcount));
        }

        private void button12_Click(object sender, EventArgs e)
        {
            int timeover = Convert.ToInt32(TbOverTime.Text);

            StringBuilder sql = new StringBuilder();
            sql.Append("update  T_BASE_HORT set HAVE_FLAG  = ").Append(timeover.ToString()).Append(" where f_device_index = 22222 ");
            dbo.ExceSQL(sql.ToString());

        }

        private void button13_Click(object sender, EventArgs e)
        {
            int timeover = Convert.ToInt32(TbOBTOverTime.Text);

            StringBuilder sql = new StringBuilder();
            sql.Append("update  T_BASE_HORT set HAVE_FLAG  = ").Append(timeover.ToString()).Append(" where f_device_index = 33333 ");
            dbo.ExceSQL(sql.ToString());
        }
    }
}