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 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 = "";
}
}
}
}
