1321 lines
61 KiB
C#
1321 lines
61 KiB
C#
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;
|
||
|
||
namespace AGVSystem
|
||
{
|
||
public partial class SetControl : Form
|
||
{
|
||
private ClsDBConn_sql db = new ClsDBConn_sql();
|
||
private System.Data.DataSet ds = new System.Data.DataSet();
|
||
private string str_sql = "";
|
||
public SetControl(int w, int h)
|
||
{
|
||
InitializeComponent();
|
||
panel3.Enabled = false;
|
||
panel4.Enabled = false;
|
||
panel5.Enabled = false;
|
||
panel6.Enabled = false;
|
||
panel7.Enabled = false;
|
||
panel8.Enabled = false;
|
||
panel9.Enabled = false;
|
||
panel10.Enabled = false;
|
||
panel11.Enabled = false;
|
||
panel12.Enabled = false;
|
||
panel13.Enabled = false;
|
||
panel14.Enabled = false;
|
||
this.Width = w;
|
||
this.Height = h;
|
||
ds = db.connDt("select CONVERT( VARCHAR(10),id)+' . '+ line_name as info from Assembly_Line order by id");
|
||
if (ds.Tables.Count > 0)
|
||
{
|
||
if (ds.Tables[0].Rows.Count > 0)
|
||
{
|
||
foreach (DataRow dr in ds.Tables[0].Rows)
|
||
{
|
||
cmb_standard_line.Items.Add(dr[0].ToString());
|
||
cmb_line1.Items.Add(dr[0].ToString());
|
||
cmb_line2.Items.Add(dr[0].ToString());
|
||
cmb_line3.Items.Add(dr[0].ToString());
|
||
cmb_line4.Items.Add(dr[0].ToString());
|
||
cmb_line5.Items.Add(dr[0].ToString());
|
||
cmb_line6.Items.Add(dr[0].ToString());
|
||
cmb_line7.Items.Add(dr[0].ToString());
|
||
cmb_line8.Items.Add(dr[0].ToString());
|
||
cmb_line9.Items.Add(dr[0].ToString());
|
||
cmb_line10.Items.Add(dr[0].ToString());
|
||
cmb_line11.Items.Add(dr[0].ToString());
|
||
cmb_line12.Items.Add(dr[0].ToString());
|
||
}
|
||
cmb_standard_line.Items.Add("");
|
||
cmb_line1.Items.Add("");
|
||
cmb_line2.Items.Add("");
|
||
cmb_line3.Items.Add("");
|
||
cmb_line4.Items.Add("");
|
||
cmb_line5.Items.Add("");
|
||
cmb_line6.Items.Add("");
|
||
cmb_line7.Items.Add("");
|
||
cmb_line8.Items.Add("");
|
||
cmb_line9.Items.Add("");
|
||
cmb_line10.Items.Add("");
|
||
cmb_line11.Items.Add("");
|
||
cmb_line12.Items.Add("");
|
||
}
|
||
}
|
||
}
|
||
|
||
|
||
|
||
private void btn_Click()
|
||
{
|
||
if (Cls.Param.UserName_temp == "")
|
||
{
|
||
MessageBox.Show("请登录管理员权限！", "AGV调度管理系统", MessageBoxButtons.OK, MessageBoxIcon.Information);
|
||
return;
|
||
}
|
||
//if ((cmb_standard_line.Text != "" || cmb_point_id.Text != "" )&& btn.Text == "查询")
|
||
//{
|
||
// if(ds !=null)ds.Tables.Clear();
|
||
// if (cmb_standard_line.Text != "" && cmb_point_id.Text != "")
|
||
// {
|
||
// ds = db.connDt("SELECT CONVERT( VARCHAR(10),name1.id) +' . '+ name1.line_name as 线体名称, Crossing_LandMark.LandMark_ID as 位置编号, " +
|
||
// " CONVERT( VARCHAR(10),name2.id) +' . '+ name2.line_name as 参考线体, Crossing_LandMark.LandMark_ID2 as 参考位置编号,"+
|
||
// " reset_mode as 复位模式 ,Crossing_LandMark.agv_no AS 当前路口AGV " +
|
||
// " FROM Crossing_LandMark, Assembly_Line as name1 , Assembly_Line as name2 " +
|
||
// " where name1.id = Crossing_LandMark.Assembly_ID and " +
|
||
// " name2.id = Crossing_LandMark.Assembly_ID2 and " +
|
||
// " Crossing_LandMark.LandMark_ID= " + cmb_point_id.Text.Split('.')[0] +" and "+
|
||
// " Crossing_LandMark.Assembly_id= " + cmb_standard_line.Text.Split('.')[0]);
|
||
// }
|
||
// else
|
||
// {
|
||
// ds = db.connDt("SELECT CONVERT( VARCHAR(10),name1.id) +' . '+ name1.line_name as 线体名称, Crossing_LandMark.LandMark_ID as 位置编号, " +
|
||
// " CONVERT( VARCHAR(10),name2.id) +' . '+ name2.line_name as 参考线体, Crossing_LandMark.LandMark_ID2 as 参考位置编号, "+
|
||
// " reset_mode as 复位模式 ,Crossing_LandMark.agv_no AS 当前路口AGV " +
|
||
// " FROM Crossing_LandMark, Assembly_Line as name1 , Assembly_Line as name2 " +
|
||
// " where name1.id = Crossing_LandMark.Assembly_ID and " +
|
||
// " name2.id = Crossing_LandMark.Assembly_ID2 and " +
|
||
// " Crossing_LandMark.Assembly_id= " + cmb_standard_line.Text.Split('.')[0]);
|
||
// }
|
||
// if (ds == null) return;
|
||
// if (ds.Tables.Count > 0)
|
||
// {
|
||
// dataGridView1.DataSource = ds.Tables[0];
|
||
// }
|
||
// return;
|
||
//}
|
||
if (cmb_standard_line.Text == "" || cmb_point_id.Text == "")
|
||
{
|
||
MessageBox.Show("请设置线体名称和管控点编号！");
|
||
return;
|
||
}
|
||
if (cmb_line1.Text != "")
|
||
{
|
||
if (db.Command("insert into Crossing_LandMark ( Assembly_ID, LandMark_ID, Assembly_ID2, LandMark_ID2, agv_no , Reset_Mode ) values ("+
|
||
cmb_standard_line.Text.Split('.')[0] + ","+
|
||
cmb_point_id.Text +","+
|
||
cmb_line1.Text.Split('.')[0] +","+
|
||
cmb_value1.Text+",0,"+cmb_rst1.SelectedIndex+")")=="1")
|
||
{
|
||
lab_st1.Text = "√";
|
||
}
|
||
else
|
||
{
|
||
lab_st1.Text = "×";
|
||
}
|
||
}
|
||
if (cmb_line2.Text != "")
|
||
{
|
||
if (db.Command("insert into Crossing_LandMark ( Assembly_ID, LandMark_ID, Assembly_ID2, LandMark_ID2, agv_no , Reset_Mode ) values (" +
|
||
cmb_standard_line.Text.Split('.')[0] + "," +
|
||
cmb_point_id.Text + "," +
|
||
cmb_line2.Text.Split('.')[0] + "," +
|
||
cmb_value2.Text + ",0," + cmb_rst2.SelectedIndex + ")") == "1")
|
||
{
|
||
lab_st2.Text = "√";
|
||
}
|
||
else
|
||
{
|
||
lab_st2.Text = "×";
|
||
}
|
||
}
|
||
if (cmb_line3.Text != "")
|
||
{
|
||
if (db.Command("insert into Crossing_LandMark ( Assembly_ID, LandMark_ID, Assembly_ID2, LandMark_ID2, agv_no , Reset_Mode ) values (" +
|
||
cmb_standard_line.Text.Split('.')[0] + "," +
|
||
cmb_point_id.Text + "," +
|
||
cmb_line3.Text.Split('.')[0] + "," +
|
||
cmb_value3.Text + ",0,"+cmb_rst3.SelectedIndex+")") == "1")
|
||
{
|
||
lab_st3.Text = "√";
|
||
}
|
||
else
|
||
{
|
||
lab_st3.Text = "×";
|
||
}
|
||
}
|
||
if (cmb_line4.Text != "")
|
||
{
|
||
if (db.Command("insert into Crossing_LandMark ( Assembly_ID, LandMark_ID, Assembly_ID2, LandMark_ID2, agv_no , Reset_Mode ) values (" +
|
||
cmb_standard_line.Text.Split('.')[0] + "," +
|
||
cmb_point_id.Text + "," +
|
||
cmb_line4.Text.Split('.')[0] + "," +
|
||
cmb_value4.Text + ",0,"+ cmb_rst4.SelectedIndex +")") == "1")
|
||
{
|
||
lab_st4.Text = "√";
|
||
}
|
||
else
|
||
{
|
||
lab_st4.Text = "×";
|
||
}
|
||
}
|
||
if (cmb_line5.Text != "")
|
||
{
|
||
if (db.Command("insert into Crossing_LandMark ( Assembly_ID, LandMark_ID, Assembly_ID2, LandMark_ID2, agv_no , Reset_Mode) values (" +
|
||
cmb_standard_line.Text.Split('.')[0] + "," +
|
||
cmb_point_id.Text + "," +
|
||
cmb_line5.Text.Split('.')[0] + "," +
|
||
cmb_value5.Text + ",0,"+cmb_rst5.SelectedIndex+")") == "1")
|
||
{
|
||
lab_st5.Text = "√";
|
||
}
|
||
else
|
||
{
|
||
lab_st5.Text = "×";
|
||
}
|
||
}
|
||
if (cmb_line6.Text != "")
|
||
{
|
||
if (db.Command("insert into Crossing_LandMark ( Assembly_ID, LandMark_ID, Assembly_ID2, LandMark_ID2, agv_no , Reset_Mode ) values (" +
|
||
cmb_standard_line.Text.Split('.')[0] + "," +
|
||
cmb_point_id.Text + "," +
|
||
cmb_line6.Text.Split('.')[0] + "," +
|
||
cmb_value6.Text + ",0,"+cmb_rst6.SelectedIndex+")") == "1")
|
||
{
|
||
lab_st6.Text = "√";
|
||
}
|
||
else
|
||
{
|
||
lab_st6.Text = "×";
|
||
}
|
||
}
|
||
if (cmb_line7.Text != "")
|
||
{
|
||
if (db.Command("insert into Crossing_LandMark ( Assembly_ID, LandMark_ID, Assembly_ID2, LandMark_ID2, agv_no , Reset_Mode ) values (" +
|
||
cmb_standard_line.Text.Split('.')[0] + "," +
|
||
cmb_point_id.Text + "," +
|
||
cmb_line7.Text.Split('.')[0] + "," +
|
||
cmb_value7.Text + ",0,"+ cmb_rst7.SelectedIndex +")") == "1")
|
||
{
|
||
lab_st7.Text = "√";
|
||
}
|
||
else
|
||
{
|
||
lab_st7.Text = "×";
|
||
}
|
||
}
|
||
if (cmb_line8.Text != "")
|
||
{
|
||
if (db.Command("insert into Crossing_LandMark ( Assembly_ID, LandMark_ID, Assembly_ID2, LandMark_ID2, agv_no , Reset_Mode ) values (" +
|
||
cmb_standard_line.Text.Split('.')[0] + "," +
|
||
cmb_point_id.Text + "," +
|
||
cmb_line8.Text.Split('.')[0] + "," +
|
||
cmb_value8.Text + ",0,"+cmb_rst8.SelectedIndex+")") == "1")
|
||
{
|
||
lab_st8.Text = "√";
|
||
}
|
||
else
|
||
{
|
||
lab_st8.Text = "×";
|
||
}
|
||
}
|
||
if (cmb_line9.Text != "")
|
||
{
|
||
if (db.Command("insert into Crossing_LandMark ( Assembly_ID, LandMark_ID, Assembly_ID2, LandMark_ID2, agv_no , Reset_Mode ) values (" +
|
||
cmb_standard_line.Text.Split('.')[0] + "," +
|
||
cmb_point_id.Text + "," +
|
||
cmb_line9.Text.Split('.')[0] + "," +
|
||
cmb_value9.Text + ",0,"+cmb_rst9.SelectedIndex+")") == "1")
|
||
{
|
||
lab_st9.Text = "√";
|
||
}
|
||
else
|
||
{
|
||
lab_st9.Text = "×";
|
||
}
|
||
}
|
||
if (cmb_line10.Text != "")
|
||
{
|
||
if (db.Command("insert into Crossing_LandMark ( Assembly_ID, LandMark_ID, Assembly_ID2, LandMark_ID2, agv_no , Reset_Mode ) values (" +
|
||
cmb_standard_line.Text.Split('.')[0] + "," +
|
||
cmb_point_id.Text + "," +
|
||
cmb_line10.Text.Split('.')[0] + "," +
|
||
cmb_value10.Text + ",0," + cmb_rst10.SelectedIndex + ")") == "1")
|
||
{
|
||
lab_st10.Text = "√";
|
||
}
|
||
else
|
||
{
|
||
lab_st10.Text = "×";
|
||
}
|
||
}
|
||
if (cmb_line11.Text != "")
|
||
{
|
||
if (db.Command("insert into Crossing_LandMark ( Assembly_ID, LandMark_ID, Assembly_ID2, LandMark_ID2, agv_no , Reset_Mode ) values (" +
|
||
cmb_standard_line.Text.Split('.')[0] + "," +
|
||
cmb_point_id.Text + "," +
|
||
cmb_line11.Text.Split('.')[0] + "," +
|
||
cmb_value11.Text + ",0,"+cmb_rst11.SelectedIndex+")") == "1")
|
||
{
|
||
lab_st11.Text = "√";
|
||
}
|
||
else
|
||
{
|
||
lab_st11.Text = "×";
|
||
}
|
||
}
|
||
if (cmb_line12.Text != "")
|
||
{
|
||
if (db.Command("insert into Crossing_LandMark ( Assembly_ID, LandMark_ID, Assembly_ID2, LandMark_ID2, agv_no , Reset_Mode ) values (" +
|
||
cmb_standard_line.Text.Split('.')[0] + "," +
|
||
cmb_point_id.Text + "," +
|
||
cmb_line12.Text.Split('.')[0] + "," +
|
||
cmb_value12.Text + ",0,"+cmb_rst12.SelectedIndex+")") == "1")
|
||
{
|
||
lab_st12.Text = "√";
|
||
}
|
||
else
|
||
{
|
||
lab_st12.Text = "×";
|
||
}
|
||
}
|
||
ds.Tables.Clear();
|
||
str_sql = "SELECT CONVERT( VARCHAR(10),name1.id) +' . '+ name1.line_name as 线体名称, Crossing_LandMark.LandMark_ID as 位置编号, " +
|
||
" CONVERT( VARCHAR(10),name2.id) +' . '+ name2.line_name as 参考线体, Crossing_LandMark.LandMark_ID2 as 参考位置编号, "+
|
||
" reset_mode as 复位模式 ,Crossing_LandMark.agv_no AS 当前路口AGV " +
|
||
" FROM Crossing_LandMark, Assembly_Line as name1 , Assembly_Line as name2 " +
|
||
" where name1.id = Crossing_LandMark.Assembly_ID and " +
|
||
" name2.id = Crossing_LandMark.Assembly_ID2 and " +
|
||
" Crossing_LandMark.Assembly_id= " + cmb_standard_line.Text.Split('.')[0] + " and " +
|
||
" Crossing_LandMark.landmark_id= " + cmb_point_id.Text.Split('.')[0];
|
||
|
||
ds = db.connDt(str_sql);
|
||
if (ds.Tables.Count > 0)
|
||
{
|
||
dataGridView1.DataSource = ds.Tables[0];
|
||
}
|
||
}
|
||
|
||
private void cmb_standard_line_TextChanged(object sender, EventArgs e)
|
||
{
|
||
cmb_point_id.Items.Clear();
|
||
comboBox1.Items.Clear();
|
||
ds.Tables.Clear();
|
||
lab_plc_value.Text = "";
|
||
if (cmb_standard_line.Text == "") return;
|
||
ds = db.connDt("SELECT distinct [Loc_ID] ,[Flag_Value] FROM [LandMarkInfo] where [Assembly_Line] = " + cmb_standard_line.Text.Split('.')[0] + " and Assembly_ID <>0");
|
||
if (ds.Tables.Count > 0)
|
||
{
|
||
if (ds.Tables[0].Rows.Count > 0)
|
||
{
|
||
foreach (DataRow dr in ds.Tables[0].Rows)
|
||
{
|
||
cmb_point_id.Items.Add(dr[0].ToString());
|
||
comboBox1.Items.Add(dr[1].ToString());
|
||
}
|
||
}
|
||
}
|
||
cmb_point_id_TextChanged(null,null);
|
||
}
|
||
|
||
private void cmb_point_id_SelectedIndexChanged(object sender, EventArgs e)
|
||
{
|
||
lab_plc_value.Text = comboBox1.Items[cmb_point_id.SelectedIndex].ToString();
|
||
}
|
||
|
||
private void cmb_line1_TextChanged(object sender, EventArgs e)
|
||
{
|
||
cmb_value1.Items.Clear();
|
||
cmb_plc1.Items.Clear();
|
||
cmb_plc1.Text = "";
|
||
cmb_value1.Text = "";
|
||
cmb_rst1.SelectedIndex = 1;
|
||
lab_st1.Text = "";
|
||
if (cmb_line1.Text == "") return;
|
||
|
||
ds = db.connDt("SELECT distinct [Loc_ID] ,[Flag_Value] FROM [LandMarkInfo] where [Assembly_Line] = " + cmb_line1.Text.Split('.')[0] + " and Assembly_ID <>0");
|
||
if (ds.Tables.Count > 0)
|
||
{
|
||
if (ds.Tables[0].Rows.Count > 0)
|
||
{
|
||
foreach (DataRow dr in ds.Tables[0].Rows)
|
||
{
|
||
cmb_value1.Items.Add(dr[0].ToString());
|
||
cmb_plc1.Items.Add(dr[1].ToString());
|
||
}
|
||
}
|
||
}
|
||
}
|
||
|
||
private void cmb_line2_TextChanged(object sender, EventArgs e)
|
||
{
|
||
cmb_value2.Items.Clear();
|
||
cmb_plc2.Items.Clear();
|
||
cmb_plc2.Text = "";
|
||
cmb_value2.Text = "";
|
||
lab_st2.Text = "";
|
||
cmb_rst2.SelectedIndex = 1;
|
||
if (cmb_line2.Text == "") return;
|
||
|
||
ds = db.connDt("SELECT distinct [Loc_ID] ,[Flag_Value] FROM [LandMarkInfo] where [Assembly_Line] = " + cmb_line2.Text.Split('.')[0] + " and Assembly_ID <>0");
|
||
if (ds.Tables.Count > 0)
|
||
{
|
||
if (ds.Tables[0].Rows.Count > 0)
|
||
{
|
||
foreach (DataRow dr in ds.Tables[0].Rows)
|
||
{
|
||
cmb_value2.Items.Add(dr[0].ToString());
|
||
cmb_plc2.Items.Add(dr[1].ToString());
|
||
}
|
||
}
|
||
}
|
||
}
|
||
|
||
private void cmb_line3_TextChanged(object sender, EventArgs e)
|
||
{
|
||
cmb_value3.Items.Clear();
|
||
cmb_plc3.Items.Clear();
|
||
cmb_plc3.Text = "";
|
||
cmb_value3.Text = "";
|
||
lab_st3.Text = "";
|
||
cmb_rst3.SelectedIndex = 1;
|
||
if (cmb_line3.Text == "") return;
|
||
|
||
ds = db.connDt("SELECT distinct [Loc_ID] ,[Flag_Value] FROM [LandMarkInfo] where [Assembly_Line] = " + cmb_line3.Text.Split('.')[0] + " and Assembly_ID <>0");
|
||
if (ds.Tables.Count > 0)
|
||
{
|
||
if (ds.Tables[0].Rows.Count > 0)
|
||
{
|
||
foreach (DataRow dr in ds.Tables[0].Rows)
|
||
{
|
||
cmb_value3.Items.Add(dr[0].ToString());
|
||
cmb_plc3.Items.Add(dr[1].ToString());
|
||
}
|
||
}
|
||
}
|
||
}
|
||
|
||
private void cmb_line4_TextChanged(object sender, EventArgs e)
|
||
{
|
||
cmb_value4.Items.Clear();
|
||
cmb_plc4.Items.Clear();
|
||
cmb_plc4.Text = "";
|
||
cmb_value4.Text = "";
|
||
lab_st4.Text = "";
|
||
cmb_rst4.SelectedIndex = 1;
|
||
if (cmb_line4.Text == "") return;
|
||
|
||
ds = db.connDt("SELECT distinct [Loc_ID] ,[Flag_Value] FROM [LandMarkInfo] where [Assembly_Line] = " + cmb_line4.Text.Split('.')[0] + " and Assembly_ID <>0");
|
||
if (ds.Tables.Count > 0)
|
||
{
|
||
if (ds.Tables[0].Rows.Count > 0)
|
||
{
|
||
foreach (DataRow dr in ds.Tables[0].Rows)
|
||
{
|
||
cmb_value4.Items.Add(dr[0].ToString());
|
||
cmb_plc4.Items.Add(dr[1].ToString());
|
||
}
|
||
}
|
||
}
|
||
}
|
||
|
||
private void cmb_line5_TextChanged(object sender, EventArgs e)
|
||
{
|
||
cmb_value5.Items.Clear();
|
||
cmb_plc5.Items.Clear();
|
||
cmb_plc5.Text = "";
|
||
cmb_value5.Text = "";
|
||
lab_st5.Text = "";
|
||
cmb_rst5.SelectedIndex = 1;
|
||
if (cmb_line5.Text == "") return;
|
||
|
||
ds = db.connDt("SELECT distinct [Loc_ID] ,[Flag_Value] FROM [LandMarkInfo] where [Assembly_Line] = " + cmb_line5.Text.Split('.')[0] + " and Assembly_ID <>0");
|
||
if (ds.Tables.Count > 0)
|
||
{
|
||
if (ds.Tables[0].Rows.Count > 0)
|
||
{
|
||
foreach (DataRow dr in ds.Tables[0].Rows)
|
||
{
|
||
cmb_value5.Items.Add(dr[0].ToString());
|
||
cmb_plc5.Items.Add(dr[1].ToString());
|
||
}
|
||
}
|
||
}
|
||
}
|
||
|
||
private void cmb_line6_TextChanged(object sender, EventArgs e)
|
||
{
|
||
cmb_value6.Items.Clear();
|
||
cmb_plc6.Items.Clear();
|
||
cmb_plc6.Text = "";
|
||
cmb_value6.Text = "";
|
||
lab_st6.Text = "";
|
||
cmb_rst6.SelectedIndex = 1;
|
||
if (cmb_line6.Text == "") return;
|
||
|
||
ds = db.connDt("SELECT distinct [Loc_ID] ,[Flag_Value] FROM [LandMarkInfo] where [Assembly_Line] = " + cmb_line6.Text.Split('.')[0] + " and Assembly_ID <>0");
|
||
if (ds.Tables.Count > 0)
|
||
{
|
||
if (ds.Tables[0].Rows.Count > 0)
|
||
{
|
||
foreach (DataRow dr in ds.Tables[0].Rows)
|
||
{
|
||
cmb_value6.Items.Add(dr[0].ToString());
|
||
cmb_plc6.Items.Add(dr[1].ToString());
|
||
}
|
||
}
|
||
}
|
||
}
|
||
|
||
private void cmb_value1_SelectedIndexChanged(object sender, EventArgs e)
|
||
{
|
||
cmb_plc1.Text = cmb_plc1.Items[cmb_value1.SelectedIndex].ToString();
|
||
}
|
||
|
||
private void cmb_value2_SelectedIndexChanged(object sender, EventArgs e)
|
||
{
|
||
cmb_plc2.Text = cmb_plc2.Items[cmb_value2.SelectedIndex].ToString();
|
||
}
|
||
|
||
private void cmb_value3_SelectedIndexChanged(object sender, EventArgs e)
|
||
{
|
||
cmb_plc3.Text = cmb_plc3.Items[cmb_value3.SelectedIndex].ToString();
|
||
}
|
||
|
||
private void cmb_value4_SelectedIndexChanged(object sender, EventArgs e)
|
||
{
|
||
cmb_plc4.Text = cmb_plc4.Items[cmb_value4.SelectedIndex].ToString();
|
||
}
|
||
|
||
private void cmb_value5_SelectedIndexChanged(object sender, EventArgs e)
|
||
{
|
||
cmb_plc5.Text = cmb_plc5.Items[cmb_value5.SelectedIndex].ToString();
|
||
}
|
||
|
||
private void cmb_value6_SelectedIndexChanged(object sender, EventArgs e)
|
||
{
|
||
cmb_plc6.Text = cmb_plc6.Items[cmb_value6.SelectedIndex].ToString();
|
||
}
|
||
|
||
private void cmb_point_id_TextChanged(object sender, EventArgs e)
|
||
{
|
||
cmb_line1.Text = "";
|
||
cmb_line2.Text = "";
|
||
cmb_line3.Text = "";
|
||
cmb_line4.Text = "";
|
||
cmb_line5.Text = "";
|
||
cmb_line6.Text = "";
|
||
cmb_line7.Text = "";
|
||
cmb_line8.Text = "";
|
||
cmb_line9.Text = "";
|
||
cmb_line10.Text = "";
|
||
cmb_line11.Text = "";
|
||
cmb_line12.Text = "";
|
||
//if (cmb_point_id.Text == "") return;
|
||
ds.Tables.Clear();
|
||
str_sql = "SELECT CONVERT( VARCHAR(10),name1.ID) +' . '+ name1.line_name as 线体名称, Crossing_LandMark.LandMark_ID as 位置编号, " +
|
||
" CONVERT( VARCHAR(10),name2.id) +' . '+ name2.line_name as 参考线体, Crossing_LandMark.LandMark_ID2 as 参考位置编号, "+
|
||
" reset_mode as 复位模式 ,Crossing_LandMark.agv_no AS 当前路口AGV " +
|
||
" FROM Crossing_LandMark, Assembly_Line as name1 , Assembly_Line as name2 " +
|
||
" where name1.id = Crossing_LandMark.Assembly_ID and " +
|
||
" name2.id = Crossing_LandMark.Assembly_ID2 ";
|
||
if (cmb_standard_line.Text.Split('.')[0] != null && cmb_standard_line.Text.Split('.')[0]!="")
|
||
str_sql = str_sql + " and Crossing_LandMark.Assembly_id= " + cmb_standard_line.Text.Split('.')[0];
|
||
if (cmb_point_id.Text.Split('.')[0] != null && cmb_point_id.Text.Split('.')[0] !="")
|
||
str_sql = str_sql + " and Crossing_LandMark.landmark_id= " + cmb_point_id.Text.Split('.')[0];
|
||
ds = db.connDt(str_sql);
|
||
if (ds.Tables.Count > 0)
|
||
{
|
||
dataGridView1.DataSource = ds.Tables[0];
|
||
}
|
||
}
|
||
|
||
private void dataGridView1_DoubleClick(object sender, EventArgs e)
|
||
{
|
||
if (dataGridView1.RowCount > 0)
|
||
{
|
||
string line_name = dataGridView1.Rows[dataGridView1.CurrentRow.Index].Cells["线体名称"].Value.ToString();
|
||
string loc_id = dataGridView1.Rows[dataGridView1.CurrentRow.Index].Cells["位置编号"].Value.ToString();
|
||
cmb_line1.Text = "";
|
||
cmb_line2.Text = "";
|
||
cmb_line3.Text = "";
|
||
cmb_line4.Text = "";
|
||
cmb_line5.Text = "";
|
||
cmb_line6.Text = "";
|
||
cmb_line7.Text = "";
|
||
cmb_line8.Text = "";
|
||
cmb_line9.Text = "";
|
||
cmb_line10.Text = "";
|
||
cmb_line11.Text = "";
|
||
cmb_line12.Text = "";
|
||
for (int i = 0; i < dataGridView1.RowCount; i++)
|
||
{
|
||
if (dataGridView1.Rows[i].Cells["线体名称"].Value.ToString() == line_name && dataGridView1.Rows[i].Cells["位置编号"].Value.ToString() == loc_id)
|
||
{
|
||
if (cmb_line1.Text == "")
|
||
{
|
||
cmb_line1.Text = dataGridView1.Rows[i].Cells["参考线体"].Value.ToString();
|
||
cmb_value1.Text = dataGridView1.Rows[i].Cells["参考位置编号"].Value.ToString();
|
||
cmb_rst1.SelectedIndex = Convert.ToInt16(dataGridView1.Rows[i].Cells["复位模式"].Value.ToString());
|
||
|
||
}
|
||
else if (cmb_line2.Text == "")
|
||
{
|
||
cmb_line2.Text = dataGridView1.Rows[i].Cells["参考线体"].Value.ToString();
|
||
cmb_value2.Text = dataGridView1.Rows[i].Cells["参考位置编号"].Value.ToString();
|
||
cmb_rst2.SelectedIndex = Convert.ToInt16(dataGridView1.Rows[i].Cells["复位模式"].Value.ToString());
|
||
}
|
||
else if (cmb_line3.Text == "")
|
||
{
|
||
cmb_line3.Text = dataGridView1.Rows[i].Cells["参考线体"].Value.ToString();
|
||
cmb_value3.Text = dataGridView1.Rows[i].Cells["参考位置编号"].Value.ToString();
|
||
cmb_rst3.SelectedIndex = Convert.ToInt16(dataGridView1.Rows[i].Cells["复位模式"].Value.ToString());
|
||
}
|
||
else if (cmb_line4.Text == "")
|
||
{
|
||
cmb_line4.Text = dataGridView1.Rows[i].Cells["参考线体"].Value.ToString();
|
||
cmb_value4.Text = dataGridView1.Rows[i].Cells["参考位置编号"].Value.ToString();
|
||
cmb_rst4.SelectedIndex = Convert.ToInt16(dataGridView1.Rows[i].Cells["复位模式"].Value.ToString());
|
||
}
|
||
else if (cmb_line5.Text == "")
|
||
{
|
||
cmb_line5.Text = dataGridView1.Rows[i].Cells["参考线体"].Value.ToString();
|
||
cmb_value5.Text = dataGridView1.Rows[i].Cells["参考位置编号"].Value.ToString();
|
||
cmb_rst5.SelectedIndex = Convert.ToInt16(dataGridView1.Rows[i].Cells["复位模式"].Value.ToString());
|
||
}
|
||
else if (cmb_line6.Text == "")
|
||
{
|
||
cmb_line6.Text = dataGridView1.Rows[i].Cells["参考线体"].Value.ToString();
|
||
cmb_value6.Text = dataGridView1.Rows[i].Cells["参考位置编号"].Value.ToString();
|
||
cmb_rst6.SelectedIndex = Convert.ToInt16(dataGridView1.Rows[i].Cells["复位模式"].Value.ToString());
|
||
}
|
||
else if (cmb_line7.Text == "")
|
||
{
|
||
cmb_line7.Text = dataGridView1.Rows[i].Cells["参考线体"].Value.ToString();
|
||
cmb_value7.Text = dataGridView1.Rows[i].Cells["参考位置编号"].Value.ToString();
|
||
cmb_rst7.SelectedIndex = Convert.ToInt16(dataGridView1.Rows[i].Cells["复位模式"].Value.ToString());
|
||
}
|
||
else if (cmb_line8.Text == "")
|
||
{
|
||
cmb_line8.Text = dataGridView1.Rows[i].Cells["参考线体"].Value.ToString();
|
||
cmb_value8.Text = dataGridView1.Rows[i].Cells["参考位置编号"].Value.ToString();
|
||
cmb_rst8.SelectedIndex = Convert.ToInt16(dataGridView1.Rows[i].Cells["复位模式"].Value.ToString());
|
||
}
|
||
else if (cmb_line9.Text == "")
|
||
{
|
||
cmb_line9.Text = dataGridView1.Rows[i].Cells["参考线体"].Value.ToString();
|
||
cmb_value9.Text = dataGridView1.Rows[i].Cells["参考位置编号"].Value.ToString();
|
||
cmb_rst9.SelectedIndex = Convert.ToInt16(dataGridView1.Rows[i].Cells["复位模式"].Value.ToString());
|
||
}
|
||
else if (cmb_line10.Text == "")
|
||
{
|
||
cmb_line10.Text = dataGridView1.Rows[i].Cells["参考线体"].Value.ToString();
|
||
cmb_value10.Text = dataGridView1.Rows[i].Cells["参考位置编号"].Value.ToString();
|
||
cmb_rst10.SelectedIndex = Convert.ToInt16(dataGridView1.Rows[i].Cells["复位模式"].Value.ToString());
|
||
}
|
||
else if (cmb_line11.Text == "")
|
||
{
|
||
cmb_line11.Text = dataGridView1.Rows[i].Cells["参考线体"].Value.ToString();
|
||
cmb_value11.Text = dataGridView1.Rows[i].Cells["参考位置编号"].Value.ToString();
|
||
cmb_rst11.SelectedIndex = Convert.ToInt16(dataGridView1.Rows[i].Cells["复位模式"].Value.ToString());
|
||
}
|
||
else if (cmb_line12.Text == "")
|
||
{
|
||
cmb_line12.Text = dataGridView1.Rows[i].Cells["参考线体"].Value.ToString();
|
||
cmb_value12.Text = dataGridView1.Rows[i].Cells["参考位置编号"].Value.ToString();
|
||
cmb_rst12.SelectedIndex = Convert.ToInt16(dataGridView1.Rows[i].Cells["复位模式"].Value.ToString());
|
||
}
|
||
panel3.Enabled = false;
|
||
panel4.Enabled = false;
|
||
panel5.Enabled = false;
|
||
panel6.Enabled = false;
|
||
panel7.Enabled = false;
|
||
panel8.Enabled = false;
|
||
panel9.Enabled = false;
|
||
panel10.Enabled = false;
|
||
panel11.Enabled = false;
|
||
panel12.Enabled = false;
|
||
panel13.Enabled = false;
|
||
panel14.Enabled = false;
|
||
}
|
||
}
|
||
}
|
||
}
|
||
|
||
private void btn_del1_Click(object sender, EventArgs e)
|
||
{
|
||
if (Cls.Param.UserName_temp == "")
|
||
{
|
||
MessageBox.Show("请登录管理员权限！", "AGV调度管理系统", MessageBoxButtons.OK, MessageBoxIcon.Information);
|
||
return;
|
||
}
|
||
if (db.Command("delete from Crossing_LandMark where assembly_id = " + cmb_standard_line.Text.Split('.')[0] +
|
||
" and landmark_id = " + cmb_point_id.Text +
|
||
" and assembly_id2 = " + cmb_line1.Text.Split('.')[0] +
|
||
" and landmark_id2 = " + cmb_value1.Text) == "1")
|
||
{
|
||
lab_st1.Text = "√";
|
||
cmb_line1.Text = "";
|
||
cmb_value1.Text = "";
|
||
}
|
||
else
|
||
{
|
||
lab_st1.Text = "×";
|
||
}
|
||
ds.Tables.Clear();
|
||
ds = db.connDt("SELECT CONVERT( VARCHAR(10),name1.id) +' . '+ name1.line_name as 线体名称, Crossing_LandMark.LandMark_ID as 位置编号, " +
|
||
" CONVERT( VARCHAR(10),name2.id) +' . '+ name2.line_name as 参考线体, Crossing_LandMark.LandMark_ID2 as 参考位置编号, "+
|
||
" reset_mode as 复位模式 ,Crossing_LandMark.agv_no AS 当前路口AGV " +
|
||
" FROM Crossing_LandMark, Assembly_Line as name1 , Assembly_Line as name2 " +
|
||
" where name1.id = Crossing_LandMark.Assembly_ID and " +
|
||
" name2.id = Crossing_LandMark.Assembly_ID2 and " +
|
||
" Crossing_LandMark.Assembly_id= " + cmb_standard_line.Text.Split('.')[0] + " and " +
|
||
" Crossing_LandMark.landmark_id= " + cmb_point_id.Text.Split('.')[0]);
|
||
if (ds.Tables.Count > 0)
|
||
{
|
||
dataGridView1.DataSource = ds.Tables[0];
|
||
}
|
||
}
|
||
|
||
private void btn_del2_Click(object sender, EventArgs e)
|
||
{
|
||
if (Cls.Param.UserName_temp == "")
|
||
{
|
||
MessageBox.Show("请登录管理员权限！", "AGV调度管理系统", MessageBoxButtons.OK, MessageBoxIcon.Information);
|
||
return;
|
||
}
|
||
if (db.Command("delete from Crossing_LandMark where assembly_id = " + cmb_standard_line.Text.Split('.')[0] +
|
||
" and landmark_id = " + cmb_point_id.Text +
|
||
" and assembly_id2 = " + cmb_line2.Text.Split('.')[0] +
|
||
" and landmark_id2 = " + cmb_value2.Text) == "1")
|
||
{
|
||
lab_st2.Text = "√";
|
||
cmb_line2.Text = "";
|
||
cmb_value2.Text = "";
|
||
}
|
||
else
|
||
{
|
||
lab_st2.Text = "×";
|
||
}
|
||
ds.Tables.Clear();
|
||
ds = db.connDt("SELECT CONVERT( VARCHAR(10),name1.id) +' . '+ name1.line_name as 线体名称, Crossing_LandMark.LandMark_ID as 位置编号, " +
|
||
" CONVERT( VARCHAR(10),name2.id) +' . '+ name2.line_name as 参考线体, Crossing_LandMark.LandMark_ID2 as 参考位置编号, "+
|
||
" reset_mode as 复位模式 ,Crossing_LandMark.agv_no AS 当前路口AGV " +
|
||
" FROM Crossing_LandMark, Assembly_Line as name1 , Assembly_Line as name2 " +
|
||
" where name1.id = Crossing_LandMark.Assembly_ID and " +
|
||
" name2.id = Crossing_LandMark.Assembly_ID2 and " +
|
||
" Crossing_LandMark.Assembly_id= " + cmb_standard_line.Text.Split('.')[0] + " and " +
|
||
" Crossing_LandMark.landmark_id= " + cmb_point_id.Text.Split('.')[0]);
|
||
if (ds.Tables.Count > 0)
|
||
{
|
||
dataGridView1.DataSource = ds.Tables[0];
|
||
}
|
||
}
|
||
|
||
private void btn_del3_Click(object sender, EventArgs e)
|
||
{
|
||
if (Cls.Param.UserName_temp == "")
|
||
{
|
||
MessageBox.Show("请登录管理员权限！", "AGV调度管理系统", MessageBoxButtons.OK, MessageBoxIcon.Information);
|
||
return;
|
||
}
|
||
if (db.Command("delete from Crossing_LandMark where assembly_id = " + cmb_standard_line.Text.Split('.')[0] +
|
||
" and landmark_id = " + cmb_point_id.Text +
|
||
" and assembly_id2 = " + cmb_line3.Text.Split('.')[0] +
|
||
" and landmark_id2 = " + cmb_value3.Text) == "1")
|
||
{
|
||
lab_st3.Text = "√";
|
||
cmb_line3.Text = "";
|
||
cmb_value3.Text = "";
|
||
}
|
||
else
|
||
{
|
||
lab_st3.Text = "×";
|
||
}
|
||
ds.Tables.Clear();
|
||
ds = db.connDt("SELECT CONVERT( VARCHAR(10),name1.id) +' . '+ name1.line_name as 线体名称, Crossing_LandMark.LandMark_ID as 位置编号, " +
|
||
" CONVERT( VARCHAR(10),name2.id) +' . '+ name2.line_name as 参考线体, Crossing_LandMark.LandMark_ID2 as 参考位置编号, "+
|
||
" reset_mode as 复位模式 ,Crossing_LandMark.agv_no AS 当前路口AGV " +
|
||
" FROM Crossing_LandMark, Assembly_Line as name1 , Assembly_Line as name2 " +
|
||
" where name1.id = Crossing_LandMark.Assembly_ID and " +
|
||
" name2.id = Crossing_LandMark.Assembly_ID2 and " +
|
||
" Crossing_LandMark.Assembly_id= " + cmb_standard_line.Text.Split('.')[0] + " and " +
|
||
" Crossing_LandMark.landmark_id= " + cmb_point_id.Text.Split('.')[0]);
|
||
if (ds.Tables.Count > 0)
|
||
{
|
||
dataGridView1.DataSource = ds.Tables[0];
|
||
}
|
||
}
|
||
|
||
private void btn_del4_Click(object sender, EventArgs e)
|
||
{
|
||
if (Cls.Param.UserName_temp == "")
|
||
{
|
||
MessageBox.Show("请登录管理员权限！", "AGV调度管理系统", MessageBoxButtons.OK, MessageBoxIcon.Information);
|
||
return;
|
||
}
|
||
if (db.Command("delete from Crossing_LandMark where assembly_id = " + cmb_standard_line.Text.Split('.')[0] +
|
||
" and landmark_id = " + cmb_point_id.Text +
|
||
" and assembly_id2 = " + cmb_line4.Text.Split('.')[0] +
|
||
" and landmark_id2 = " + cmb_value4.Text) == "1")
|
||
{
|
||
lab_st4.Text = "√";
|
||
cmb_line4.Text = "";
|
||
cmb_value4.Text = "";
|
||
}
|
||
else
|
||
{
|
||
lab_st4.Text = "×";
|
||
}
|
||
ds.Tables.Clear();
|
||
ds = db.connDt("SELECT CONVERT( VARCHAR(10),name1.id) +' . '+ name1.line_name as 线体名称, Crossing_LandMark.LandMark_ID as 位置编号, " +
|
||
" CONVERT( VARCHAR(10),name2.id) +' . '+ name2.line_name as 参考线体, Crossing_LandMark.LandMark_ID2 as 参考位置编号, "+
|
||
" reset_mode as 复位模式 ,Crossing_LandMark.agv_no AS 当前路口AGV " +
|
||
" FROM Crossing_LandMark, Assembly_Line as name1 , Assembly_Line as name2 " +
|
||
" where name1.id = Crossing_LandMark.Assembly_ID and " +
|
||
" name2.id = Crossing_LandMark.Assembly_ID2 and " +
|
||
" Crossing_LandMark.Assembly_id= " + cmb_standard_line.Text.Split('.')[0] + " and " +
|
||
" Crossing_LandMark.landmark_id= " + cmb_point_id.Text.Split('.')[0]);
|
||
if (ds.Tables.Count > 0)
|
||
{
|
||
dataGridView1.DataSource = ds.Tables[0];
|
||
}
|
||
}
|
||
|
||
private void btn_del5_Click(object sender, EventArgs e)
|
||
{
|
||
if (Cls.Param.UserName_temp == "")
|
||
{
|
||
MessageBox.Show("请登录管理员权限！", "AGV调度管理系统", MessageBoxButtons.OK, MessageBoxIcon.Information);
|
||
return;
|
||
}
|
||
if (db.Command("delete from Crossing_LandMark where assembly_id = " + cmb_standard_line.Text.Split('.')[0] +
|
||
" and landmark_id = " + cmb_point_id.Text +
|
||
" and assembly_id2 = " + cmb_line5.Text.Split('.')[0] +
|
||
" and landmark_id2 = " + cmb_value5.Text) == "1")
|
||
{
|
||
lab_st5.Text = "√";
|
||
cmb_line5.Text = "";
|
||
cmb_value5.Text = "";
|
||
}
|
||
else
|
||
{
|
||
lab_st5.Text = "×";
|
||
}
|
||
ds.Tables.Clear();
|
||
ds = db.connDt("SELECT CONVERT( VARCHAR(10),name1.id) +' . '+ name1.line_name as 线体名称, Crossing_LandMark.LandMark_ID as 位置编号, " +
|
||
" CONVERT( VARCHAR(10),name2.id) +' . '+ name2.line_name as 参考线体, Crossing_LandMark.LandMark_ID2 as 参考位置编号, "+
|
||
" reset_mode as 复位模式 ,Crossing_LandMark.agv_no AS 当前路口AGV " +
|
||
" FROM Crossing_LandMark, Assembly_Line as name1 , Assembly_Line as name2 " +
|
||
" where name1.id = Crossing_LandMark.Assembly_ID and " +
|
||
" name2.id = Crossing_LandMark.Assembly_ID2 and " +
|
||
" Crossing_LandMark.Assembly_id= " + cmb_standard_line.Text.Split('.')[0] + " and " +
|
||
" Crossing_LandMark.landmark_id= " + cmb_point_id.Text.Split('.')[0]);
|
||
if (ds.Tables.Count > 0)
|
||
{
|
||
dataGridView1.DataSource = ds.Tables[0];
|
||
}
|
||
}
|
||
|
||
private void btn_del6_Click(object sender, EventArgs e)
|
||
{
|
||
if (Cls.Param.UserName_temp == "")
|
||
{
|
||
MessageBox.Show("请登录管理员权限！", "AGV调度管理系统", MessageBoxButtons.OK, MessageBoxIcon.Information);
|
||
return;
|
||
}
|
||
if (db.Command("delete from Crossing_LandMark where assembly_id = " + cmb_standard_line.Text.Split('.')[0] +
|
||
" and landmark_id = " + cmb_point_id.Text +
|
||
" and assembly_id2 = " + cmb_line6.Text.Split('.')[0] +
|
||
" and landmark_id2 = " + cmb_value6.Text) == "1")
|
||
{
|
||
lab_st6.Text = "√";
|
||
cmb_line6.Text = "";
|
||
cmb_value6.Text = "";
|
||
}
|
||
else
|
||
{
|
||
lab_st6.Text = "×";
|
||
}
|
||
ds.Tables.Clear();
|
||
ds = db.connDt("SELECT CONVERT( VARCHAR(10),name1.id) +' . '+ name1.line_name as 线体名称, Crossing_LandMark.LandMark_ID as 位置编号, " +
|
||
" CONVERT( VARCHAR(10),name2.id) +' . '+ name2.line_name as 参考线体, Crossing_LandMark.LandMark_ID2 as 参考位置编号, "+
|
||
" reset_mode as 复位模式 ,Crossing_LandMark.agv_no AS 当前路口AGV " +
|
||
" FROM Crossing_LandMark, Assembly_Line as name1 , Assembly_Line as name2 " +
|
||
" where name1.id = Crossing_LandMark.Assembly_ID and " +
|
||
" name2.id = Crossing_LandMark.Assembly_ID2 and " +
|
||
" Crossing_LandMark.Assembly_id= " + cmb_standard_line.Text.Split('.')[0] + " and " +
|
||
" Crossing_LandMark.landmark_id= " + cmb_point_id.Text.Split('.')[0]);
|
||
if (ds.Tables.Count > 0)
|
||
{
|
||
dataGridView1.DataSource = ds.Tables[0];
|
||
}
|
||
}
|
||
|
||
private void groupBox2_Enter(object sender, EventArgs e)
|
||
{
|
||
|
||
}
|
||
|
||
private void cmb_line7_TextChanged(object sender, EventArgs e)
|
||
{
|
||
cmb_value7.Items.Clear();
|
||
cmb_plc7.Items.Clear();
|
||
cmb_plc7.Text = "";
|
||
cmb_value7.Text = "";
|
||
lab_st7.Text = "";
|
||
cmb_rst7.SelectedIndex = 1;
|
||
if (cmb_line7.Text == "") return;
|
||
|
||
ds = db.connDt("SELECT distinct [Loc_ID] ,[Flag_Value] FROM [LandMarkInfo] where [Assembly_Line] = " + cmb_line7.Text.Split('.')[0] + " and Assembly_ID <>0");
|
||
if (ds.Tables.Count > 0)
|
||
{
|
||
if (ds.Tables[0].Rows.Count > 0)
|
||
{
|
||
foreach (DataRow dr in ds.Tables[0].Rows)
|
||
{
|
||
cmb_value7.Items.Add(dr[0].ToString());
|
||
cmb_plc7.Items.Add(dr[1].ToString());
|
||
}
|
||
}
|
||
}
|
||
}
|
||
|
||
private void cmb_line8_TextChanged(object sender, EventArgs e)
|
||
{
|
||
cmb_value8.Items.Clear();
|
||
cmb_plc8.Items.Clear();
|
||
cmb_plc8.Text = "";
|
||
cmb_value8.Text = "";
|
||
lab_st8.Text = "";
|
||
cmb_rst8.SelectedIndex = 1;
|
||
if (cmb_line8.Text == "") return;
|
||
|
||
ds = db.connDt("SELECT distinct [Loc_ID] ,[Flag_Value] FROM [LandMarkInfo] where [Assembly_Line] = " + cmb_line8.Text.Split('.')[0] + " and Assembly_ID <>0");
|
||
if (ds.Tables.Count > 0)
|
||
{
|
||
if (ds.Tables[0].Rows.Count > 0)
|
||
{
|
||
foreach (DataRow dr in ds.Tables[0].Rows)
|
||
{
|
||
cmb_value8.Items.Add(dr[0].ToString());
|
||
cmb_plc8.Items.Add(dr[1].ToString());
|
||
}
|
||
}
|
||
}
|
||
}
|
||
|
||
private void cmb_line9_TextChanged(object sender, EventArgs e)
|
||
{
|
||
cmb_value9.Items.Clear();
|
||
cmb_plc9.Items.Clear();
|
||
cmb_plc9.Text = "";
|
||
cmb_value9.Text = "";
|
||
lab_st9.Text = "";
|
||
cmb_rst9.SelectedIndex = 1;
|
||
if (cmb_line9.Text == "") return;
|
||
|
||
ds = db.connDt("SELECT distinct [Loc_ID] ,[Flag_Value] FROM [LandMarkInfo] where [Assembly_Line] = " + cmb_line9.Text.Split('.')[0] + " and Assembly_ID <>0");
|
||
if (ds.Tables.Count > 0)
|
||
{
|
||
if (ds.Tables[0].Rows.Count > 0)
|
||
{
|
||
foreach (DataRow dr in ds.Tables[0].Rows)
|
||
{
|
||
cmb_value9.Items.Add(dr[0].ToString());
|
||
cmb_plc9.Items.Add(dr[1].ToString());
|
||
}
|
||
}
|
||
}
|
||
}
|
||
|
||
private void cmb_line10_TextChanged(object sender, EventArgs e)
|
||
{
|
||
cmb_value10.Items.Clear();
|
||
cmb_plc10.Items.Clear();
|
||
cmb_plc10.Text = "";
|
||
cmb_value10.Text = "";
|
||
lab_st10.Text = "";
|
||
cmb_rst10.SelectedIndex = 1;
|
||
if (cmb_line10.Text == "") return;
|
||
|
||
ds = db.connDt("SELECT distinct [Loc_ID] ,[Flag_Value] FROM [LandMarkInfo] where [Assembly_Line] = " + cmb_line10.Text.Split('.')[0] + " and Assembly_ID <>0");
|
||
if (ds.Tables.Count > 0)
|
||
{
|
||
if (ds.Tables[0].Rows.Count > 0)
|
||
{
|
||
foreach (DataRow dr in ds.Tables[0].Rows)
|
||
{
|
||
cmb_value10.Items.Add(dr[0].ToString());
|
||
cmb_plc10.Items.Add(dr[1].ToString());
|
||
}
|
||
}
|
||
}
|
||
}
|
||
|
||
private void cmb_line11_TextChanged(object sender, EventArgs e)
|
||
{
|
||
cmb_value11.Items.Clear();
|
||
cmb_plc11.Items.Clear();
|
||
cmb_plc11.Text = "";
|
||
cmb_value11.Text = "";
|
||
lab_st11.Text = "";
|
||
cmb_rst11.SelectedIndex = 1;
|
||
if (cmb_line11.Text == "") return;
|
||
|
||
ds = db.connDt("SELECT distinct [Loc_ID] ,[Flag_Value] FROM [LandMarkInfo] where [Assembly_Line] = " + cmb_line11.Text.Split('.')[0] + " and Assembly_ID <>0");
|
||
if (ds.Tables.Count > 0)
|
||
{
|
||
if (ds.Tables[0].Rows.Count > 0)
|
||
{
|
||
foreach (DataRow dr in ds.Tables[0].Rows)
|
||
{
|
||
cmb_value11.Items.Add(dr[0].ToString());
|
||
cmb_plc11.Items.Add(dr[1].ToString());
|
||
}
|
||
}
|
||
}
|
||
}
|
||
|
||
private void cmb_line12_TextChanged(object sender, EventArgs e)
|
||
{
|
||
cmb_value12.Items.Clear();
|
||
cmb_plc12.Items.Clear();
|
||
cmb_plc12.Text = "";
|
||
cmb_value12.Text = "";
|
||
lab_st12.Text = "";
|
||
cmb_rst12.SelectedIndex = 1;
|
||
if (cmb_line12.Text == "") return;
|
||
|
||
ds = db.connDt("SELECT distinct [Loc_ID] ,[Flag_Value] FROM [LandMarkInfo] where [Assembly_Line] = " + cmb_line12.Text.Split('.')[0] + " and Assembly_ID <>0");
|
||
if (ds.Tables.Count > 0)
|
||
{
|
||
if (ds.Tables[0].Rows.Count > 0)
|
||
{
|
||
foreach (DataRow dr in ds.Tables[0].Rows)
|
||
{
|
||
cmb_value12.Items.Add(dr[0].ToString());
|
||
cmb_plc12.Items.Add(dr[1].ToString());
|
||
}
|
||
}
|
||
}
|
||
}
|
||
|
||
private void cmb_value7_SelectedIndexChanged(object sender, EventArgs e)
|
||
{
|
||
cmb_plc7.Text = cmb_plc7.Items[cmb_value7.SelectedIndex].ToString();
|
||
}
|
||
|
||
private void cmb_value8_SelectedIndexChanged(object sender, EventArgs e)
|
||
{
|
||
cmb_plc8.Text = cmb_plc8.Items[cmb_value8.SelectedIndex].ToString();
|
||
}
|
||
|
||
private void cmb_value9_SelectedIndexChanged(object sender, EventArgs e)
|
||
{
|
||
cmb_plc9.Text = cmb_plc9.Items[cmb_value9.SelectedIndex].ToString();
|
||
}
|
||
|
||
private void cmb_value10_SelectedIndexChanged(object sender, EventArgs e)
|
||
{
|
||
cmb_plc10.Text = cmb_plc10.Items[cmb_value10.SelectedIndex].ToString();
|
||
}
|
||
|
||
private void cmb_value11_SelectedIndexChanged(object sender, EventArgs e)
|
||
{
|
||
cmb_plc11.Text = cmb_plc11.Items[cmb_value11.SelectedIndex].ToString();
|
||
}
|
||
|
||
private void cmb_value12_SelectedIndexChanged(object sender, EventArgs e)
|
||
{
|
||
cmb_plc12.Text = cmb_plc12.Items[cmb_value12.SelectedIndex].ToString();
|
||
}
|
||
|
||
private void btn_del7_Click(object sender, EventArgs e)
|
||
{
|
||
if (Cls.Param.UserName_temp == "")
|
||
{
|
||
MessageBox.Show("请登录管理员权限！", "AGV调度管理系统", MessageBoxButtons.OK, MessageBoxIcon.Information);
|
||
return;
|
||
}
|
||
if (db.Command("delete from Crossing_LandMark where assembly_id = " + cmb_standard_line.Text.Split('.')[0] +
|
||
" and landmark_id = " + cmb_point_id.Text +
|
||
" and assembly_id2 = " + cmb_line7.Text.Split('.')[0] +
|
||
" and landmark_id2 = " + cmb_value7.Text) == "1")
|
||
{
|
||
lab_st7.Text = "√";
|
||
cmb_line7.Text = "";
|
||
cmb_value7.Text = "";
|
||
}
|
||
else
|
||
{
|
||
lab_st7.Text = "×";
|
||
}
|
||
ds.Tables.Clear();
|
||
ds = db.connDt("SELECT CONVERT( VARCHAR(10),name1.id) +' . '+ name1.line_name as 线体名称, Crossing_LandMark.LandMark_ID as 位置编号, " +
|
||
" CONVERT( VARCHAR(10),name2.id) +' . '+ name2.line_name as 参考线体, Crossing_LandMark.LandMark_ID2 as 参考位置编号, "+
|
||
" reset_mode as 复位模式 ,Crossing_LandMark.agv_no AS 当前路口AGV " +
|
||
" FROM Crossing_LandMark, Assembly_Line as name1 , Assembly_Line as name2 " +
|
||
" where name1.id = Crossing_LandMark.Assembly_ID and " +
|
||
" name2.id = Crossing_LandMark.Assembly_ID2 and " +
|
||
" Crossing_LandMark.Assembly_id= " + cmb_standard_line.Text.Split('.')[0] + " and " +
|
||
" Crossing_LandMark.landmark_id= " + cmb_point_id.Text.Split('.')[0]);
|
||
if (ds.Tables.Count > 0)
|
||
{
|
||
dataGridView1.DataSource = ds.Tables[0];
|
||
}
|
||
}
|
||
|
||
private void btn_del8_Click(object sender, EventArgs e)
|
||
{
|
||
if (Cls.Param.UserName_temp == "")
|
||
{
|
||
MessageBox.Show("请登录管理员权限！", "AGV调度管理系统", MessageBoxButtons.OK, MessageBoxIcon.Information);
|
||
return;
|
||
}
|
||
if (db.Command("delete from Crossing_LandMark where assembly_id = " + cmb_standard_line.Text.Split('.')[0] +
|
||
" and landmark_id = " + cmb_point_id.Text +
|
||
" and assembly_id2 = " + cmb_line8.Text.Split('.')[0] +
|
||
" and landmark_id2 = " + cmb_value8.Text) == "1")
|
||
{
|
||
lab_st8.Text = "√";
|
||
cmb_line8.Text = "";
|
||
cmb_value8.Text = "";
|
||
}
|
||
else
|
||
{
|
||
lab_st8.Text = "×";
|
||
}
|
||
ds.Tables.Clear();
|
||
ds = db.connDt("SELECT CONVERT( VARCHAR(10),name1.id) +' . '+ name1.line_name as 线体名称, Crossing_LandMark.LandMark_ID as 位置编号, " +
|
||
" CONVERT( VARCHAR(10),name2.id) +' . '+ name2.line_name as 参考线体, Crossing_LandMark.LandMark_ID2 as 参考位置编号, "+
|
||
" reset_mode as 复位模式 ,Crossing_LandMark.agv_no AS 当前路口AGV " +
|
||
" FROM Crossing_LandMark, Assembly_Line as name1 , Assembly_Line as name2 " +
|
||
" where name1.id = Crossing_LandMark.Assembly_ID and " +
|
||
" name2.id = Crossing_LandMark.Assembly_ID2 and " +
|
||
" Crossing_LandMark.Assembly_id= " + cmb_standard_line.Text.Split('.')[0] + " and " +
|
||
" Crossing_LandMark.landmark_id= " + cmb_point_id.Text.Split('.')[0]);
|
||
if (ds.Tables.Count > 0)
|
||
{
|
||
dataGridView1.DataSource = ds.Tables[0];
|
||
}
|
||
}
|
||
|
||
private void btn_del9_Click(object sender, EventArgs e)
|
||
{
|
||
if (Cls.Param.UserName_temp == "")
|
||
{
|
||
MessageBox.Show("请登录管理员权限！", "AGV调度管理系统", MessageBoxButtons.OK, MessageBoxIcon.Information);
|
||
return;
|
||
}
|
||
if (db.Command("delete from Crossing_LandMark where assembly_id = " + cmb_standard_line.Text.Split('.')[0] +
|
||
" and landmark_id = " + cmb_point_id.Text +
|
||
" and assembly_id2 = " + cmb_line9.Text.Split('.')[0] +
|
||
" and landmark_id2 = " + cmb_value9.Text) == "1")
|
||
{
|
||
lab_st9.Text = "√";
|
||
cmb_line9.Text = "";
|
||
cmb_value9.Text = "";
|
||
}
|
||
else
|
||
{
|
||
lab_st9.Text = "×";
|
||
}
|
||
ds.Tables.Clear();
|
||
ds = db.connDt("SELECT CONVERT( VARCHAR(10),name1.id) +' . '+ name1.line_name as 线体名称, Crossing_LandMark.LandMark_ID as 位置编号, " +
|
||
" CONVERT( VARCHAR(10),name2.id) +' . '+ name2.line_name as 参考线体, Crossing_LandMark.LandMark_ID2 as 参考位置编号, "+
|
||
" reset_mode as 复位模式 ,Crossing_LandMark.agv_no AS 当前路口AGV " +
|
||
" FROM Crossing_LandMark, Assembly_Line as name1 , Assembly_Line as name2 " +
|
||
" where name1.id = Crossing_LandMark.Assembly_ID and " +
|
||
" name2.id = Crossing_LandMark.Assembly_ID2 and " +
|
||
" Crossing_LandMark.Assembly_id= " + cmb_standard_line.Text.Split('.')[0] + " and " +
|
||
" Crossing_LandMark.landmark_id= " + cmb_point_id.Text.Split('.')[0]);
|
||
if (ds.Tables.Count > 0)
|
||
{
|
||
dataGridView1.DataSource = ds.Tables[0];
|
||
}
|
||
}
|
||
|
||
private void btn_del10_Click(object sender, EventArgs e)
|
||
{
|
||
if (Cls.Param.UserName_temp == "")
|
||
{
|
||
MessageBox.Show("请登录管理员权限！", "AGV调度管理系统", MessageBoxButtons.OK, MessageBoxIcon.Information);
|
||
return;
|
||
}
|
||
if (db.Command("delete from Crossing_LandMark where assembly_id = " + cmb_standard_line.Text.Split('.')[0] +
|
||
" and landmark_id = " + cmb_point_id.Text +
|
||
" and assembly_id2 = " + cmb_line10.Text.Split('.')[0] +
|
||
" and landmark_id2 = " + cmb_value10.Text) == "1")
|
||
{
|
||
lab_st10.Text = "√";
|
||
cmb_line10.Text = "";
|
||
cmb_value10.Text = "";
|
||
}
|
||
else
|
||
{
|
||
lab_st10.Text = "×";
|
||
}
|
||
ds.Tables.Clear();
|
||
ds = db.connDt("SELECT CONVERT( VARCHAR(10),name1.id) +' . '+ name1.line_name as 线体名称, Crossing_LandMark.LandMark_ID as 位置编号, " +
|
||
" CONVERT( VARCHAR(10),name2.id) +' . '+ name2.line_name as 参考线体, Crossing_LandMark.LandMark_ID2 as 参考位置编号,"+
|
||
" reset_mode as 复位模式 ,Crossing_LandMark.agv_no AS 当前路口AGV " +
|
||
" FROM Crossing_LandMark, Assembly_Line as name1 , Assembly_Line as name2 " +
|
||
" where name1.id = Crossing_LandMark.Assembly_ID and " +
|
||
" name2.id = Crossing_LandMark.Assembly_ID2 and " +
|
||
" Crossing_LandMark.Assembly_id= " + cmb_standard_line.Text.Split('.')[0] + " and " +
|
||
" Crossing_LandMark.landmark_id= " + cmb_point_id.Text.Split('.')[0]);
|
||
if (ds.Tables.Count > 0)
|
||
{
|
||
dataGridView1.DataSource = ds.Tables[0];
|
||
}
|
||
}
|
||
|
||
private void btn_del11_Click(object sender, EventArgs e)
|
||
{
|
||
if (Cls.Param.UserName_temp == "")
|
||
{
|
||
MessageBox.Show("请登录管理员权限！", "AGV调度管理系统", MessageBoxButtons.OK, MessageBoxIcon.Information);
|
||
return;
|
||
}
|
||
if (db.Command("delete from Crossing_LandMark where assembly_id = " + cmb_standard_line.Text.Split('.')[0] +
|
||
" and landmark_id = " + cmb_point_id.Text +
|
||
" and assembly_id2 = " + cmb_line11.Text.Split('.')[0] +
|
||
" and landmark_id2 = " + cmb_value11.Text) == "1")
|
||
{
|
||
lab_st11.Text = "√";
|
||
cmb_line11.Text = "";
|
||
cmb_value11.Text = "";
|
||
}
|
||
else
|
||
{
|
||
lab_st11.Text = "×";
|
||
}
|
||
ds.Tables.Clear();
|
||
ds = db.connDt("SELECT CONVERT( VARCHAR(10),name1.id) +' . '+ name1.line_name as 线体名称, Crossing_LandMark.LandMark_ID as 位置编号, " +
|
||
" CONVERT( VARCHAR(10),name2.id) +' . '+ name2.line_name as 参考线体, Crossing_LandMark.LandMark_ID2 as 参考位置编号, "+
|
||
" reset_mode as 复位模式 ,Crossing_LandMark.agv_no AS 当前路口AGV " +
|
||
" FROM Crossing_LandMark, Assembly_Line as name1 , Assembly_Line as name2 " +
|
||
" where name1.id = Crossing_LandMark.Assembly_ID and " +
|
||
" name2.id = Crossing_LandMark.Assembly_ID2 and " +
|
||
" Crossing_LandMark.Assembly_id= " + cmb_standard_line.Text.Split('.')[0] + " and " +
|
||
" Crossing_LandMark.landmark_id= " + cmb_point_id.Text.Split('.')[0]);
|
||
if (ds.Tables.Count > 0)
|
||
{
|
||
dataGridView1.DataSource = ds.Tables[0];
|
||
}
|
||
}
|
||
|
||
private void btn_del12_Click(object sender, EventArgs e)
|
||
{
|
||
if (Cls.Param.UserName_temp == "")
|
||
{
|
||
MessageBox.Show("请登录管理员权限！", "AGV调度管理系统", MessageBoxButtons.OK, MessageBoxIcon.Information);
|
||
return;
|
||
}
|
||
if (db.Command("delete from Crossing_LandMark where assembly_id = " + cmb_standard_line.Text.Split('.')[0] +
|
||
" and landmark_id = " + cmb_point_id.Text +
|
||
" and assembly_id2 = " + cmb_line12.Text.Split('.')[0] +
|
||
" and landmark_id2 = " + cmb_value12.Text) == "1")
|
||
{
|
||
lab_st12.Text = "√";
|
||
cmb_line12.Text = "";
|
||
cmb_value12.Text = "";
|
||
}
|
||
else
|
||
{
|
||
lab_st12.Text = "×";
|
||
}
|
||
ds.Tables.Clear();
|
||
ds = db.connDt("SELECT CONVERT( VARCHAR(10),name1.id) +' . '+ name1.line_name as 线体名称, Crossing_LandMark.LandMark_ID as 位置编号, " +
|
||
" CONVERT( VARCHAR(10),name2.id) +' . '+ name2.line_name as 参考线体, Crossing_LandMark.LandMark_ID2 as 参考位置编号, "+
|
||
" reset_mode as 复位模式 ,Crossing_LandMark.agv_no AS 当前路口AGV " +
|
||
" FROM Crossing_LandMark, Assembly_Line as name1 , Assembly_Line as name2 " +
|
||
" where name1.id = Crossing_LandMark.Assembly_ID and " +
|
||
" name2.id = Crossing_LandMark.Assembly_ID2 and " +
|
||
" Crossing_LandMark.Assembly_id= " + cmb_standard_line.Text.Split('.')[0] + " and " +
|
||
" Crossing_LandMark.landmark_id= " + cmb_point_id.Text.Split('.')[0]);
|
||
if (ds.Tables.Count > 0)
|
||
{
|
||
dataGridView1.DataSource = ds.Tables[0];
|
||
}
|
||
}
|
||
|
||
private void toolStrip1_ItemClicked(object sender, ToolStripItemClickedEventArgs e)
|
||
{
|
||
|
||
}
|
||
|
||
private void toolStripButton5_Click(object sender, EventArgs e)
|
||
{
|
||
if (Cls.Param.UserName_temp == "")
|
||
{
|
||
MessageBox.Show("请登录管理员权限！", "AGV调度管理系统", MessageBoxButtons.OK, MessageBoxIcon.Information);
|
||
return;
|
||
}
|
||
panel3.Enabled = true;
|
||
panel4.Enabled = true;
|
||
panel5.Enabled = true;
|
||
panel6.Enabled = true;
|
||
panel7.Enabled = true;
|
||
panel8.Enabled = true;
|
||
panel9.Enabled = true;
|
||
panel10.Enabled = true;
|
||
panel11.Enabled = true;
|
||
panel12.Enabled = true;
|
||
panel13.Enabled = true;
|
||
panel14.Enabled = true;
|
||
|
||
}
|
||
|
||
private void toolStripButton6_Click(object sender, EventArgs e)
|
||
{
|
||
if (Cls.Param.UserName_temp == "")
|
||
{
|
||
MessageBox.Show("请登录管理员权限！", "AGV调度管理系统", MessageBoxButtons.OK, MessageBoxIcon.Information);
|
||
return;
|
||
}
|
||
btn_Click();
|
||
panel3.Enabled = false;
|
||
panel4.Enabled = false;
|
||
panel5.Enabled = false;
|
||
panel6.Enabled = false;
|
||
panel7.Enabled = false;
|
||
panel8.Enabled = false;
|
||
panel9.Enabled = false;
|
||
panel10.Enabled = false;
|
||
panel11.Enabled = false;
|
||
panel12.Enabled = false;
|
||
panel13.Enabled = false;
|
||
panel14.Enabled = false;
|
||
}
|
||
|
||
private void splitContainer1_Panel1_Paint(object sender, PaintEventArgs e)
|
||
{
|
||
|
||
}
|
||
|
||
private void toolStripButton4_Click(object sender, EventArgs e)
|
||
{
|
||
|
||
}
|
||
|
||
|
||
}
|
||
}
|