public bool insertPositionInfo(DAL.DAO.PositionDao dao) { string sql = "insert into t_position(position,positiontype,positiondirection) values " + " ('" + dao.Position + "','" + dao.Positiontype + "'," + dao.Positiondirection + ") "; return(this.InsertQuery(sql)); }
private void btn_Channel_ADD_Click(object sender, EventArgs e) { if (this.txb_ParkChannelName.Text != "" && this.cmb_ParkChannelDirection.Text != "") { DAL.DAL_Position positiondal = new DAL.DAL_Position(); DAL.DAO.PositionDao positiondao = new DAL.DAO.PositionDao(); positiondao.Position = this.txb_ParkChannelName.Text; positiondao.Positiontype = "2"; if (this.cmb_ParkChannelDirection.Text == "入口") { positiondao.Positiondirection = "0"; } else if (this.cmb_ParkChannelDirection.Text == "出口") { positiondao.Positiondirection = "1"; } if (positiondal.insertPositionInfo(positiondao)) { MessageBox.Show("添加成功!"); ParkPositionTreeView_Init(); } else { MessageBox.Show("添加失败!"); } this.txb_ParkChannelName.Text = ""; } else { MessageBox.Show("道口信息填写不正确"); } }
private void btn_DoorChannel_ADD_Click(object sender, EventArgs e) { if (this.txb_DoorChannelName.Text != "") { DAL.DAL_Position positiondal = new DAL.DAL_Position(); DAL.DAO.PositionDao positiondao = new DAL.DAO.PositionDao(); positiondao.Position = this.txb_DoorChannelName.Text; positiondao.Positiontype = "1"; if (positiondal.insertPositionInfo(positiondao)) { MessageBox.Show("添加成功!"); } else { MessageBox.Show("添加失败!"); } this.txb_DoorChannelName.Text = ""; } }