private void dgvSummary_CellContentClick(object sender, DataGridViewCellEventArgs e) { if (dgvSummary.Columns[e.ColumnIndex].Name == "删除") { ManageCarRequiredment manageCarRequiredment = new ManageCarRequiredment(); manageCarRequiredment.Id = Convert.ToInt32(dgvSummary.CurrentRow.Cells["managerId"].Value.ToString()); manageCarRequiredment.DriverId = Convert.ToInt32(dgvSummary.CurrentRow.Cells["driverId"].Value.ToString()); manageCarRequiredment.CarId = Convert.ToInt32(dgvSummary.CurrentRow.Cells["carId"].Value.ToString()); try { manageCarRequiredmentBLL.DeleteObject(manageCarRequiredment); driverWriteListBLL.UpdateIsUseStatus(manageCarRequiredment.DriverId, 0); carBll.UpdateIsUseStatus(manageCarRequiredment.CarId, 0); MessageBox.Show("删除成功"); // DataTable carList = manageCarRequiredmentBLL.FindAll_infos(getblacklistsql); // dgvSummary.DataSource = carList; } catch (Exception ex) { MessageBox.Show("删除失败" + ex.Message); } } }
private void btnSaveManageCar_Click(object sender, EventArgs e) { if (txtdriverNameManage.Text == "") { MessageBox.Show("请配置司机"); return; } if (txtCarManage.Text == "") { MessageBox.Show("请配置车辆"); return; } CarUseHisotry carUseHisotry = new CarUseHisotry(); if (dgvCustomerInfor.CurrentRow == null) { MessageBox.Show("请选择人员进行配置"); return; } int currentDriverListIndex = dgvWriteDriverList.CurrentRow.Index; int driverId = Convert.ToInt32(dgvWriteDriverList.Rows[currentDriverListIndex].Cells["DriverId"].Value); carUseHisotry.DriverIdNumber = dgvWriteDriverList.Rows[currentDriverListIndex].Cells["身份证件号码"].Value.ToString(); int currentCarListIndex = dgvCarList.CurrentRow.Index; int carId = Convert.ToInt32(dgvCarList.Rows[currentCarListIndex].Cells["CarId"].Value); carUseHisotry.CarIdNumber = dgvCarList.Rows[currentCarListIndex].Cells["车牌号"].Value.ToString(); int currentUserListIndex = dgvCustomerInfor.CurrentRow.Index; int userId = Convert.ToInt32(dgvCustomerInfor.Rows[currentUserListIndex].Cells["Id"].Value); int groupId = dgvGroupList1.CurrentRow.Index; carUseHisotry.GroupId = Convert.ToInt32(dgvGroupList1.Rows[groupId].Cells["GroupId"].Value); int currentCustomerListIndex = dgvCustomerInfor.CurrentRow.Index; string currentCustomerUserName = dgvCustomerInfor.Rows[currentCustomerListIndex].Cells["用户名"].Value.ToString(); carUseHisotry.UserName = dgvCustomerInfor.Rows[currentCustomerListIndex].Cells["用户名"].Value.ToString(); carUseHisotry.Telephone = dgvCustomerInfor.Rows[currentCustomerListIndex].Cells["联系方式"].Value.ToString(); carUseHisotry.CreateTime = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss.fff"); int currentCarReuirmentIndex = dgvCarReuirment.CurrentRow.Index; string CarYaoqiu = dgvCarReuirment.Rows[currentCarReuirmentIndex].Cells["CarYaoqiu"].Value.ToString(); string CarYongtu = dgvCarReuirment.Rows[currentCarReuirmentIndex].Cells["CarYongtu"].Value.ToString(); string Other = dgvCarReuirment.Rows[currentCarReuirmentIndex].Cells["Other"].Value.ToString(); //userBLL.UpdateIsUseStatus(userId); //User user = new User(); //user.Id = carId; //dgvCustomerInfor.DataSource = userBLL.SelectbyUser(user); ManageCarRequiredment manageCarRequiredment = new ManageCarRequiredment(); manageCarRequiredment.GroupId = Convert.ToInt32(dgvGroupList1.Rows[groupId].Cells["GroupId"].Value); manageCarRequiredment.UserName = currentCustomerUserName; manageCarRequiredment.DriverId = driverId; manageCarRequiredment.CarId = carId; manageCarRequiredment.CarYaoqiu = CarYaoqiu; manageCarRequiredment.CarYongtu = CarYaoqiu; manageCarRequiredment.Other = CarYaoqiu; manageCarRequiredment.CreateTime = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss.fff"); try { manageCarRequiredmentBLL.InsertObject(manageCarRequiredment); } catch (Exception ex) { MessageBox.Show("编辑信息错误"); } driverWriteListBLL.UpdateIsUseStatus(driverId, 1); calBll.UpdateIsUseStatus(carId, 1); dgvWriteDriverList.DataSource = driverWriteListBLL.FindAllInfo(); dgvCarList.DataSource = calBll.FindAllInfo(); dgvManagedInfo.DataSource = manageCarRequiredmentBLL.FindAllInfo(); MessageBox.Show("编辑成功!"); try { carUseHisotryBLL.InsertObject(carUseHisotry); } catch (Exception ex) { MessageBox.Show("插入历史数据表错误"); return; } }