//获取所有端口
public List <XmPortModel> GetPorts()
{
try
{
List <XmPortModel> xmPorts = new List <XmPortModel>();
string sql = string.Format("select * from xmport order by port");
DataTable dt = SqlHelper.GetTable(sql);
for (int i = 0; i < dt.Rows.Count; i++)
{
XmPortModel xmport = new XmPortModel()
{
port = int.Parse(dt.Rows[i]["port"].ToString()),
xmno = int.Parse(dt.Rows[i]["xmno"].ToString()),
dataType = dt.Rows[i]["dataType"].ToString()
};
xmPorts.Add(xmport);
}
return(xmPorts);
}
catch (Exception ex)
{
FileOperation.WriteAppenFile("获取端口数据出错 " + ex.Message);
throw ex;
}
}
//更新端口对应的项目编号
public bool ChangeXmno(XmPortModel model)
{
try
{
string sql = string.Format("update xmport set xmno = {0} where port = {1}", model.xmno, model.port);
return(SqlHelper.ExecuteNoQuery(sql));
}
catch (Exception ex)
{
FileOperation.WriteAppenFile(string.Format("更新端口{0}对应的项目编号出错 {1}", model.port.ToString(), ex.Message));
throw ex;
}
}
public bool AddXmPort(XmPortModel model)
{
try
{
string sql = string.Format("insert into xmport(port, xmno, dataType) values({0}, {1}, '{2}')", model.port, model.xmno, model.dataType);
bool res = SqlHelper.ExecuteNoQuery(sql);
return(res);
}
catch (Exception ex)
{
FileOperation.WriteAppenFile("添加端口" + model.port.ToString() + "出错 " + ex.Message);
throw ex;
}
}
//获取数据类型与端口的对应关系
public void GetXmPort()
{
xmPorts = new List <XmPortModel>();
string sql = string.Format("select * from xmport order by port");
DataTable dt = SqlHelper.GetTable(sql);
for (int i = 0; i < dt.Rows.Count; i++)
{
XmPortModel xmport = new XmPortModel()
{
port = int.Parse(dt.Rows[i]["port"].ToString()),
xmno = int.Parse(dt.Rows[i]["xmno"].ToString()),
dataType = dt.Rows[i]["dataType"].ToString()
};
xmPorts.Add(xmport);
}
}
//修改表格内容
private void dataGridView1_CellEndEdit(object sender, DataGridViewCellEventArgs e)
{
//获取当前列
int columnIndex = dataGridView1.CurrentCell.ColumnIndex;
if (columnIndex != 2)
{
return;
}
//获取当前行
int rowIndex = dataGridView1.CurrentCell.RowIndex;
string port = GetPort(rowIndex);
string xmno = GetXmno(rowIndex);
if (xmno == "")
{
Show("请输入项目编号");
return;
}
XmPortBLL bll = new XmPortBLL();
if (bll.GetXmno(int.Parse(port)) == int.Parse(xmno))
{
return;
}
XmPortModel model = new XmPortModel()
{
port = int.Parse(port),
xmno = int.Parse(xmno)
};
if (bll.ChangeXmno(model))
{
Show("修改成功");
}
else
{
Show("修改失败");
}
}
//添加端口
private void button1_Click(object sender, EventArgs e)
{
string port = textBox1.Text;
string xmno = textBox2.Text;
if (port == "" || xmno == "")
{
Show("请输入端口号和项目编号");
return;
}
if (isNumber(port) == false || isNumber(xmno) == false)
{
Show("请输入正确的端口号");
return;
}
XmPortBLL bll = new XmPortBLL();
if (bll.PortIsExist(int.Parse(port)) == true)
{
Show("该端口已存在");
return;
}
XmPortModel model = new XmPortModel()
{
port = int.Parse(port),
xmno = int.Parse(xmno)
};
if (bll.AddXmPort(model))
{
Show("添加端口成功");
textBox1.Text = "";
textBox2.Text = "";
}
else
{
Show("添加失败");
}
}
