private void btn_gx_Click(object sender, EventArgs e) { string sql = ""; if (CheckInput(txb_msg) == false) { label10.Text = "只能输入中文字符,标点符号,英文,数字,下划线。但不能输入@,#,$,%,^,&,* 等特殊字符"; label10.Visible = true; return; } else { //cmb_zl.Text != "" ? cmb_zl.SelectedValue : null if (txt_id.Text == "") { MessageBox.Show("你未选择任何行,请先双击需要更新的行!", "提示!", MessageBoxButtons.OK, MessageBoxIcon.Information); return; } else { // MessageBox.Show(cmb_sb.Text == "空" ? null : Int32.Parse(cmb_sb.SelectedValue.ToString()).ToString()); sql = "update b_devices_msg t set t.addtype_id='" + Getcmb(cmb_wz) + "',t.devices_id='" + Getcmb(cmb_sb) + "',t.release_time=sysdate,"; sql += " t.start_time=to_date('" + dtp_ks.Text + "','yyyy-mm-dd hh24:mi:ss'),t.end_time=to_date('" + dtp_js.Text + "','yyyy-mm-dd hh24:mi:ss'),"; sql += " t.description='" + txb_msg.Text + "',t.tru_id='" + Getcmb(cmb_zl) + "',t.ter_id='" + Getcmb(cmb_hzl) + "' "; sql += " where t.id=" + Int32.Parse(txt_id.Text) + ""; try { ora.ExecuteSql(sql); MessageBox.Show("ID为" + txt_id.Text + "消息已经成功更新!", "提示!", MessageBoxButtons.OK, MessageBoxIcon.Information); BindData(); } catch (Exception ex) { MessageBox.Show(ex.ToString(), "错误!", MessageBoxButtons.OK, MessageBoxIcon.Error); } } } }
private void button1_Click(object sender, EventArgs e) { if (CheckInput(txtname) == false) { MessageBox.Show("只能输入数字,中文或者字母,请不要非法输入!", "警告", MessageBoxButtons.OK, MessageBoxIcon.Error); return; } else { ora = new OracleHelper(constr); DataTable dt = ora.GetDt("select distinct t.pos_tc from b_devices t where t.pos_tc is not null"); //string path = System.Environment.CurrentDirectory + "//config//Position.txt"; //读取Position文件中显示层 if (txtname.Text == "" || txtname.Text == null) { MessageBox.Show("请输入图层名称!", "警告", MessageBoxButtons.OK, MessageBoxIcon.Error); return; } if (dt.Rows.Count > 0) { //string str = File.ReadAllText(path); // string[] line = File.ReadAllLines(path, Encoding.Default); for (int i = 0; i < dt.Rows.Count; i++) { if (dt.Rows[i]["pos_tc"].ToString() == txtname.Text.ToString().Trim()) { MessageBox.Show("图层名称已经存在,请重新输入!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information); return; } } } if (openFileDialog1.ShowDialog() == DialogResult.OK) { string oldName = openFileDialog1.FileName; string[] splitName = oldName.Split('.'); string ext = splitName[splitName.Length - 1]; string dbName = "\\images\\" + txtname.Text.ToString().Trim() + "." + ext; string newName = System.Environment.CurrentDirectory + dbName; File.Copy(oldName, newName, true); //File.AppendAllText(path, txtname.Text.ToString().Trim() + "\r\n"); ora.ExecuteSql("insert into b_devices_addtype values (SEQ_B_DEVICES_ADDTYPE.NEXTVAL,'','" + txtname.Text.Trim() + "','LGH','')"); string paths = System.Environment.CurrentDirectory + "//config//" + txtname.Text.ToString().Trim() + ".txt"; if (File.Exists(paths) == false) { File.CreateText(paths); } MessageBox.Show("图层已经成功添加!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information); txtname.Text = ""; } } }
public void Connect() { ora = new OracleHelper(constr); try { ora.ExecuteSql("select * from B_DEVICES t"); } catch (Exception e) { throw new Exception(e.Message); } }
private void btnfb_Click(object sender, EventArgs e) { if (CheckInput(txtnr) == false) { label5.Text = "只能输入中文字符,标点符号,英文,数字,下划线。但不能输入@,#,$,%,^,&,* 等特殊字符"; label5.Visible = true; return; } if (CheckDTP(dtpks, dtpjs) == false) { MessageBox.Show("结束时间必须大于开始时间,请重新选择时间!", "警告", MessageBoxButtons.OK, MessageBoxIcon.Error); return; } else { try { if (cmbgn.Text == "空") { ora.ExecuteSql("insert into b_devices_msg (id,addtype_id,start_time,end_time,description,release_time,ter_id) values (SEQ_B_DEVICES_MSG.NEXTVAL,null,to_date('" + dtpks.Text + "','yyyy-mm-dd hh24:mi:ss'),to_date('" + dtpjs.Text + "','yyyy-mm-dd hh24:mi:ss'),'" + txtnr.Text.Trim() + "',sysdate,1)"); //1代表T1航站楼 MessageBox.Show("消息发布成功!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information); Reflesh(); } else { ora.ExecuteSql("insert into b_devices_msg (id,addtype_id,start_time,end_time,description,release_time,ter_id) values (SEQ_B_DEVICES_MSG.NEXTVAL," + cmbgn.SelectedValue + ",to_date('" + dtpks.Text + "','yyyy-mm-dd hh24:mi:ss'),to_date('" + dtpjs.Text + "','yyyy-mm-dd hh24:mi:ss'),'" + txtnr.Text.Trim() + "',sysdate,1)"); //1代表T1航站楼 MessageBox.Show("消息发布成功!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information); Reflesh(); } } catch (Exception ex) { MessageBox.Show(ex.ToString(), "警告", MessageBoxButtons.OK, MessageBoxIcon.Error); return; } } }
private void button1_Click(object sender, EventArgs e) { CheckTxtbox(); try { if (Ishave(txtipaddr) == false) { ora.ExecuteSql("update b_devices t set t.sip='" + txtipaddr.Text + "',t.resource_name='" + txtname.Text + "',t.pos_tc='" + comboBox1.SelectedValue.ToString() + "' where t.sip='" + Ip + "' and t.resource_name='" + Hostname + "'"); MessageBox.Show("此点位信息已经更新成功!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information); //string path = System.Environment.CurrentDirectory + "//config//" + Flag + ".txt"; //string[] lines = System.IO.File.ReadAllLines(path); ////转换 //List<string> list = new List<string>(); //list.AddRange(lines); //for (int i = 0; i < list.Count; i++) //{ // if (list[i].ToString().Contains(Hostname + "," + Ip)) // { // list[i] = txtname.Text + "," + txtipaddr.Text + "," + txtX.Text + "," + txtY.Text; // } //} //lines = list.ToArray(); ////保存 //File.WriteAllLines(path, lines, Encoding.UTF8); //File.w // MessageBox.Show(lines.ToString()); //MessageBox.Show("此点位信息已经更新成功!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information); //this.Close(); Anj_Jk frm = (Anj_Jk)this.Owner; frm.DeleteButton(); frm.AddbuttonInfo("images/" + Flag + ".jpg"); } else { MessageBox.Show(txtipaddr.Text + "已经存在,请不要重复更新!", "警告", MessageBoxButtons.OK, MessageBoxIcon.Error); return; } } catch (Exception ex) { MessageBox.Show(ex.ToString(), "警告", MessageBoxButtons.OK, MessageBoxIcon.Error); } }
private void btnfb_Click(object sender, EventArgs e) { if (CheckInput(txtnr) == false) { label5.Text = "只能输入中文字符,标点符号,英文,数字,下划线。但不能输入@,#,$,%,^,&,* 等特殊字符"; label5.Visible = true; return; } if (CheckDTP(dtpks, dtpjs) == false) { MessageBox.Show("结束时间必须大于开始时间,请重新选择时间!", "警告", MessageBoxButtons.OK, MessageBoxIcon.Error); return; } else { try { DataTable dt = ora.GetDt("select t.id from B_DEVICES t where t.sip='" + Ip + "' "); if (dt.Rows.Count > 0) { int d_id = Int32.Parse(dt.Rows[0]["id"].ToString()); ora.ExecuteSql("insert into b_devices_msg (id,devices_id,start_time,end_time,description,release_time,ter_id) values (SEQ_B_DEVICES_MSG.NEXTVAL," + d_id + ",to_date('" + dtpks.Text + "','yyyy-mm-dd hh24:mi:ss'),to_date('" + dtpjs.Text + "','yyyy-mm-dd hh24:mi:ss'),'" + txtnr.Text.Trim() + "',sysdate,1)"); //1代表T1航站楼 MessageBox.Show("消息发布成功!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information); } else { MessageBox.Show("没有找到IP为" + Ip + "的相关数据,请先检查数据库!", "警告", MessageBoxButtons.OK, MessageBoxIcon.Error); return; } } catch (Exception ex) { MessageBox.Show(ex.ToString(), "警告", MessageBoxButtons.OK, MessageBoxIcon.Error); return; } } }
public void AddbuttonInfo(string picPath) { try { string paths = System.Environment.CurrentDirectory + "//config//Size.txt"; //读取Size文件中button的size值(宽和高) FileStream fss = new FileStream(paths, FileMode.Open); StreamReader srr = new StreamReader(fss, Encoding.Default); string lines = srr.ReadToEnd(); srr.Close(); fss.Close(); string[] size = lines.Split(new char[] { ',' }, StringSplitOptions.RemoveEmptyEntries); DataTable dt = ora.GetDt("select t.id, t.resource_name,t.sip,t.pos_x,t.pos_y,t.pos_tc from B_DEVICES t"); //string path = System.Environment.CurrentDirectory + configPath; pictureBox1.Image = Image.FromFile(picPath); // MessageBox.Show(path); if (dt.Rows.Count > 0) { //FileStream fs = new FileStream(path, FileMode.Open); //读取出港大厅配置文件详细信息 // StreamReader sr = new StreamReader(fs, Encoding.Default); // string line = sr.ReadToEnd(); //sr.Close(); // fs.Close(); // string[] str = line.Split(new string[] { "\r\n" }, StringSplitOptions.RemoveEmptyEntries); //Button[] btn = new Button[str.Length]; for (int i = 0; i < dt.Rows.Count; i++) { if (dt.Rows[i]["pos_tc"].ToString() == "") { ora.ExecuteSql("update b_devices t set t.pos_x='1024',t.pos_y='768',t.pos_tc='" + Name + "' where t.id=" + Int32.Parse(dt.Rows[i]["id"].ToString()) + ""); } } } dt = ora.GetDt("select t.id, t.resource_name,t.sip,t.pos_x,t.pos_y,t.pos_tc from B_DEVICES t"); if (dt.Rows.Count > 0) { for (int i = 0; i < dt.Rows.Count; i++) { if (dt.Rows[i]["pos_tc"].ToString() == Name) { if (list.Contains(dt.Rows[i]["resource_name"].ToString() + "," + dt.Rows[i]["sip"].ToString()) == false) { list.Add(dt.Rows[i]["resource_name"].ToString() + "," + dt.Rows[i]["sip"].ToString()); } Button btn = new Button(); //动态添加button按钮 btn.Parent = this.pictureBox1; btn.ContextMenuStrip = contextMenuStrip1; //btn.Top = 25 * i; btn.Name = dt.Rows[i]["resource_name"].ToString(); btn.Text = dt.Rows[i]["sip"].ToString(); // btn.ContextMenuStrip = btn.Size = new System.Drawing.Size(Int32.Parse(size[0]), Int32.Parse(size[1])); // btn.BackColor = Color.Red; btn.Image = Image.FromFile("png/断开.png"); btn.Font = new System.Drawing.Font(btn.Font.FontFamily, 1, btn.Font.Style); //btn.Left = Int32.Parse(Math.Round(((rect.Width) * float.Parse(info[2]))).ToString()); //btn.Top = Int32.Parse(Math.Round(((rect.Height) * float.Parse(info[3]))).ToString()); btn.Location = new Point(Int32.Parse(dt.Rows[i]["pos_x"].ToString()), Int32.Parse(dt.Rows[i]["pos_y"].ToString())); ShowInfo(btn, dt.Rows[i]["resource_name"].ToString(), dt.Rows[i]["sip"].ToString()); // Setposition_button(btn,float.Parse(info[2]),float.) // btn.Click += new EventHandler(btn_Click); btn.MouseMove += new System.Windows.Forms.MouseEventHandler(btn_MouseMove); btn.MouseDown += new System.Windows.Forms.MouseEventHandler(btn_MouseDown); btn.MouseUp += new System.Windows.Forms.MouseEventHandler(btn_MouseUp); this.pictureBox1.Controls.Add(btn); // this.Controls.Add(btn); } } BindMenu(); } //MessageBox.Show(list.Count.ToString()); // MessageBox.Show(line); else { MessageBox.Show("数据库无数据,请检查!", "警告", MessageBoxButtons.OK, MessageBoxIcon.Error); } } catch (Exception ex) { MessageBox.Show(ex.ToString(), "警告", MessageBoxButtons.OK, MessageBoxIcon.Error); } }
private void button1_Click(object sender, EventArgs e) { // string path = System.Environment.CurrentDirectory + "//config//" + Flag + ".txt"; //if(File.Exists(path)) //{ // string[] line = File.ReadAllLines(path, Encoding.UTF8); //foreach(string str in line) //{ // if (str.Contains(txtname.Text + "," + txtipaddr.Text) || str.Contains(txtname.Text) || str.Contains(txtipaddr.Text)) // { // MessageBox.Show("此点位已经存在,请重新添加!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information); // return; // } //} //StreamWriter sw = new StreamWriter(path, true); //sw.WriteLine(txtname.Text+","+txtipaddr.Text+","+txtX.Text+","+txtY.Text); //sw.Close(); if (checkBox1.Checked == false) { if (CheckTxtbox() == false) { return; } try { if (Ishave(txtipaddr) == false) { ora.ExecuteSql("insert into b_devices (id,sip,resource_name,pos_x,pos_y,pos_tc) values (SEQ_B_DEVICES.NEXTVAL,'" + txtipaddr.Text + "','" + txtname.Text + "','" + txtX.Text + "','" + txtY.Text + "','" + comboBox1.Text + "')"); Anj_Jk frm = (Anj_Jk)this.Owner; frm.DeleteButton(); frm.AddbuttonInfo("images/" + Flag + ".jpg"); } else { MessageBox.Show("此点位已经存在,请重新添加!", "警告", MessageBoxButtons.OK, MessageBoxIcon.Error); } } catch (Exception ex) { MessageBox.Show(ex.ToString(), "警告", MessageBoxButtons.OK, MessageBoxIcon.Error); } } else { if (CheckTxtbox() == false) { return; } if (CheckInput(txttc) == false) { txtname.BackColor = Color.Red; return; } else { ora = new OracleHelper(constr); DataTable dt = ora.GetDt("select distinct t.pos_tc from b_devices t where t.pos_tc is not null"); //string path = System.Environment.CurrentDirectory + "//config//Position.txt"; //读取Position文件中显示层 if (txtname.Text == "" || txtname.Text == null) { MessageBox.Show("请输入图层名称!", "警告", MessageBoxButtons.OK, MessageBoxIcon.Error); return; } if (dt.Rows.Count > 0) { //string str = File.ReadAllText(path); // string[] line = File.ReadAllLines(path, Encoding.Default); for (int i = 0; i < dt.Rows.Count; i++) { if (dt.Rows[i]["pos_tc"].ToString() == txtname.Text.ToString().Trim()) { MessageBox.Show("图层名称已经存在,请重新输入!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information); return; } } } if (openFileDialog1.ShowDialog() == DialogResult.OK) { string oldName = openFileDialog1.FileName; string[] splitName = oldName.Split('.'); string ext = splitName[splitName.Length - 1]; string dbName = "\\images\\" + txttc.Text.ToString().Trim() + "." + ext; string newName = System.Environment.CurrentDirectory + dbName; File.Copy(oldName, newName, true); //File.AppendAllText(path, txtname.Text.ToString().Trim() + "\r\n"); ora.ExecuteSql("insert into b_devices (id,sip,resource_name,pos_x,pos_y,pos_tc) values (SEQ_B_DEVICES.NEXTVAL,'" + txtipaddr.Text + "','" + txtname.Text + "','" + txtX.Text + "','" + txtY.Text + "','" + txttc.Text.Trim() + "')"); string paths = System.Environment.CurrentDirectory + "//config//" + txtname.Text.ToString().Trim() + ".txt"; if (File.Exists(paths) == false) { File.CreateText(paths); } MessageBox.Show("图层已经成功添加!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information); txtname.Text = ""; } } } }