//获取所有端口 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("添加失败"); } }