/// <summary> /// 新增单个数据 /// </summary> /// <param name="driverAbnormalNameList"></param> /// <returns></returns> public bool InsertObject(CarUseHisotry carUseHisotry) { string sql = "insert into TB_CarUseHisotry (GroupId,UserName,Telephone,DriverIdNumber,CarIdNumber,CreateTime) values(" + carUseHisotry.GroupId + ",'" + carUseHisotry.UserName + "','" + carUseHisotry.Telephone + "','" + carUseHisotry.DriverIdNumber + "','" + carUseHisotry.CarIdNumber + "','" + carUseHisotry.CreateTime + "' )"; return AccessHelper.SQLExecute(sql); }
public void InsertObject(CarUseHisotry carUseHisotry) { carUseHisotryDAL.InsertObject(carUseHisotry); }
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; } }