private void btnEdit_Click(object sender, EventArgs e)
{
try
{
DataGridViewRow dgr = dataGridView1.CurrentRow;
dgr.Cells["LicenseNumber"].Value = this.tbxCarLicenceNumber.Text;
dgr.Cells["CarType"].Value = this.tbxCarType.Text;
dgr.Cells["EngineNumber"].Value = this.tbxCarEngineNumber.Text;
dgr.Cells["CarcaseNumber"].Value = this.tbxCarcaseNumber.Text;
dgr.Cells["InsuranceDate"].Value = this.tbxCarInsuranceDate.Text;
dgr.Cells["RoadtollDate"].Value = this.tbxCarRoadtollDate.Text;
dgr.Cells["CheckDate"].Value = this.tbxCarCheckDate.Text;
DDCarInfo newCar = new DDCarInfo("CarID", Convert.ToInt32(dgr.Cells["CarID"].Value));
newCar.LicenseNumber = this.tbxCarLicenceNumber.Text;
newCar.CarType = this.tbxCarType.Text;
newCar.EngineNumber = this.tbxCarEngineNumber.Text;
newCar.CarcaseNumber = this.tbxCarcaseNumber.Text;
newCar.InsuranceDate = this.tbxCarInsuranceDate.Text;
newCar.RoadtollDate = this.tbxCarRoadtollDate.Text;
newCar.CheckDate = this.tbxCarCheckDate.Text;
newCar.Save();
MessageBox.Show("信息更新成功！", "提示信息");
}
catch
{
MessageBox.Show("信息更新错误，请检查数据库是否连接正确！", "提示信息");
}
}
public void Update(int CarID, string LicenseNumber, string CarType, string EngineNumber, string CarcaseNumber, string InsuranceDate, string RoadtollDate, string CheckDate, int?PawnageID)
{
DDCarInfo item = new DDCarInfo();
item.MarkOld();
item.IsLoaded = true;
item.CarID = CarID;
item.LicenseNumber = LicenseNumber;
item.CarType = CarType;
item.EngineNumber = EngineNumber;
item.CarcaseNumber = CarcaseNumber;
item.InsuranceDate = InsuranceDate;
item.RoadtollDate = RoadtollDate;
item.CheckDate = CheckDate;
item.PawnageID = PawnageID;
item.Save(UserName);
}
private void dataGridView1_CellClick(object sender, DataGridViewCellEventArgs e)
{
RowSelected = e.RowIndex;
if (e.RowIndex != -1)
{
if (dataGridView1.Rows[RowSelected].Cells["PhotoPath"].Value.ToString() != "")
{
btnShowPhoto.Enabled = true;
}
else
{
btnShowPhoto.Enabled = false;
}
if (dataGridView1.Rows[RowSelected].Cells["FirstClass"].Value.ToString() == "10")
{
gbxHouseInfo.Hide();
this.tbxCarCaseNumber.Text = "";
this.tbxCarCheckDate.Text = "";
this.tbxCarEngineNumber.Text = "";
this.tbxCarLicenseNumber.Text = "";
this.tbxCarRoadDate.Text = "";
this.tbxCarType.Text = "";
this.tbxCarInsuranceDate.Text = "";
DDCarInfo newCar = new DDCarInfo("PawnageID", dataGridView1.Rows[RowSelected].Cells["PawnageID"].Value.ToString());
this.tbxCarCaseNumber.Text = newCar.CarcaseNumber;
this.tbxCarCheckDate.Text = newCar.CheckDate;
this.tbxCarEngineNumber.Text = newCar.EngineNumber;
this.tbxCarInsuranceDate.Text = newCar.InsuranceDate;
this.tbxCarLicenseNumber.Text = newCar.LicenseNumber;
this.tbxCarRoadDate.Text = newCar.RoadtollDate;
this.tbxCarType.Text = newCar.CarType;
this.gbxCarInfo.Show();
}
else if (dataGridView1.Rows[RowSelected].Cells["FirstClass"].Value.ToString() == "11")
{
gbxCarInfo.Hide();
this.tbxHouseAddress.Text = "";
this.tbxHouseArea.Text = "";
this.tbxHouseCompactNumber.Text = "";
this.tbxHouseInsuranceDate.Text = "";
this.tbxHouseNotarizaDate.Text = "";
this.tbxHouseRegisterDate.Text = "";
DDHouseInfo newHouse = new DDHouseInfo("PawnageID", dataGridView1.Rows[RowSelected].Cells["PawnageID"].Value.ToString());
this.tbxHouseAddress.Text = newHouse.Address;
this.tbxHouseArea.Text = newHouse.Area;
this.tbxHouseCompactNumber.Text = newHouse.CompactNumber;
this.tbxHouseInsuranceDate.Text = newHouse.InsuranceDate;
this.tbxHouseNotarizaDate.Text = newHouse.NotarizationDate;
this.tbxHouseRegisterDate.Text = newHouse.RegisterDate;
this.gbxHouseInfo.Show();
}
else
{
this.gbxCarInfo.Hide();
this.gbxHouseInfo.Hide();
}
}
}
public bool Destroy(object CarID)
{
return(DDCarInfo.Destroy(CarID) == 1);
}
public bool Delete(object CarID)
{
return(DDCarInfo.Delete(CarID) == 1);
}
