private void dataGridView1_CellContentClick(object sender, DataGridViewCellEventArgs e) { try { if (e.ColumnIndex == dataGridView1.Columns["btnsave"].Index) { int index = e.RowIndex; if (dataGridView1.Rows[index].Cells[1].Value.ToString() == "admin") { MessageBox.Show("禁止修改管理员用户", "系统提示"); return; } qzj_vehicle model = new qzj_vehicle(); model.VEHICLENAME = dataGridView1.Rows[index].Cells[0].Value.ToString(); model.LEFTTURNLEFT = double.Parse(dataGridView1.Rows[index].Cells[1].Value.ToString()); model.LEFTTURNRIGHT = double.Parse(dataGridView1.Rows[index].Cells[2].Value.ToString()); model.RIGHTTURNLEFT = double.Parse(dataGridView1.Rows[index].Cells[3].Value.ToString()); model.RIGHTTURNRIGHT = double.Parse(dataGridView1.Rows[index].Cells[4].Value.ToString()); model.LEFTTURNLEFTWC = double.Parse(dataGridView1.Rows[index].Cells[5].Value.ToString()); model.LEFTTURNRIGHTWC = double.Parse(dataGridView1.Rows[index].Cells[6].Value.ToString()); model.RIGHTTURNLEFTWC = double.Parse(dataGridView1.Rows[index].Cells[7].Value.ToString()); model.RIGHTTURNRIGHTWC = double.Parse(dataGridView1.Rows[index].Cells[8].Value.ToString()); if (SqlControl.updateVehicle(model)) { MessageBox.Show("更改成功", "系统提示"); } else { MessageBox.Show("未知原因导致信息更改失败", "系统提示"); } } else if (e.ColumnIndex == dataGridView1.Columns["btndelete"].Index) { int index = e.RowIndex; if (dataGridView1.Rows[index].Cells[0].Value.ToString() == "DEFAULT") { MessageBox.Show("禁止删除DEFAULT车型信息", "系统提示"); } else { SqlControl.deleteVehicle(dataGridView1.Rows[index].Cells[0].Value.ToString()); MessageBox.Show("删除成功", "系统提示"); ref_Staff(); } } } catch (Exception er) { MessageBox.Show("操作失败:" + er.Message, "系统提示"); } }
public static bool getVehicleXz(string vehiclename, out qzj_vehicle model) { model = new qzj_vehicle(); bool result = false; try { OleDbConnection adoConn = new OleDbConnection(); adoConn.ConnectionString = strConn; adoConn.Open(); OleDbCommand cmd = adoConn.CreateCommand(); OleDbTransaction Trans = adoConn.BeginTransaction(); cmd.Transaction = Trans; Trans.Rollback(); try { logControl.saveLogInf("连接数据库成功"); string checksql = "select * from QZJ_VEHICLE where VEHICLENAME='" + vehiclename + "'"; OleDbCommand datacheck = new OleDbCommand(checksql, adoConn); OleDbDataReader reader = datacheck.ExecuteReader(); if (reader.HasRows) { reader.Read(); model.VEHICLENAME = reader["VEHICLENAME"].ToString(); model.LEFTTURNLEFT = double.Parse(reader["LEFTTURNLEFT"].ToString()); model.LEFTTURNRIGHT = double.Parse(reader["LEFTTURNRIGHT"].ToString()); model.RIGHTTURNLEFT = double.Parse(reader["RIGHTTURNLEFT"].ToString()); model.RIGHTTURNRIGHT = double.Parse(reader["RIGHTTURNRIGHT"].ToString()); model.LEFTTURNLEFTWC = double.Parse(reader["LEFTTURNLEFTWC"].ToString()); model.LEFTTURNRIGHTWC = double.Parse(reader["LEFTTURNRIGHTWC"].ToString()); model.RIGHTTURNLEFTWC = double.Parse(reader["RIGHTTURNLEFTWC"].ToString()); model.RIGHTTURNRIGHTWC = double.Parse(reader["RIGHTTURNRIGHTWC"].ToString()); result = true; //return dt; } } catch (Exception er) { logControl.saveLogInf("查询数据发生异常:" + er.Message); Trans.Rollback(); } adoConn.Close(); } catch (Exception er) { logControl.saveLogInf("链接到驰达数据库失败:" + er.Message); } return(result); }
public static bool updateVehicle(qzj_vehicle model) { bool result; try { OleDbConnection adoConn = new OleDbConnection(); adoConn.ConnectionString = strConn; adoConn.Open(); OleDbCommand cmd = adoConn.CreateCommand(); OleDbTransaction Trans = adoConn.BeginTransaction(); cmd.Transaction = Trans; Trans.Rollback(); try { logControl.saveLogInf("连接数据库成功"); string updatesql = SqlBuilderHelper.UpdateSql <qzj_vehicle>(model, "QZJ_VEHICLE", "VEHICLENAME='" + model.VEHICLENAME + "'"); OleDbDataAdapter dataAdapter = new OleDbDataAdapter(); dataAdapter.InsertCommand = new OleDbCommand(updatesql, adoConn); dataAdapter.InsertCommand.CommandText = updatesql; if (dataAdapter.InsertCommand.ExecuteNonQuery() > 0) { result = true; logControl.saveLogInf("插入数据成功"); } else { result = false; logControl.saveLogInf("插入数据失败"); } dataAdapter.Dispose(); } catch (Exception er) { result = false; logControl.saveLogInf("更新数据发生异常:" + er.Message); Trans.Rollback(); } adoConn.Close(); } catch (Exception er) { result = false; logControl.saveLogInf("链接到数据库失败:" + er.Message); } return(result); }
private void button1_Click(object sender, EventArgs e) { try { qzj_vehicle model = new qzj_vehicle(); model.VEHICLENAME = textBoxVehicleName.Text; model.LEFTTURNLEFT = double.Parse(textBoxll.Text); model.LEFTTURNRIGHT = double.Parse(textBoxlr.Text); model.RIGHTTURNLEFT = double.Parse(textBoxrl.Text); model.RIGHTTURNRIGHT = double.Parse(textBoxrr.Text); model.LEFTTURNLEFTWC = double.Parse(textBoxllwc.Text); model.LEFTTURNRIGHTWC = double.Parse(textBoxlrwc.Text); model.RIGHTTURNLEFTWC = double.Parse(textBoxrlwc.Text); model.RIGHTTURNRIGHTWC = double.Parse(textBoxrrwc.Text); if (model.VEHICLENAME.Trim() == "") { MessageBox.Show("请先填写车型名称", "系统提示"); return; } if (SqlControl.checkVehicleIsAlive(model.VEHICLENAME)) { MessageBox.Show("此车型信息已存在,请勿重复添加", "系统提示"); } else if (SqlControl.insertVehicle(model)) { MessageBox.Show("添加成功", "系统提示"); } else { MessageBox.Show("添加失败", "系统提示"); } ref_Staff(); } catch { MessageBox.Show("数据格式有误", "系统提示"); } }