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()); } } }