/// <summary>
/// 修改测试路线信息
/// </summary>
/// <param name="tr"></param>
public void Update(TestRoute tr)
{
//先修改测试路线基础信息
db.UpdateInto("TestRouteBaseInfo", new string[] {
"Idx", "TestRoutes", "LineMileage",
"Material", "Time", "Picture"
}, new string[] {
tr.TestRouteBase.Index.ToString(),
tr.TestRouteBase.TestRoutes.ToString(),
tr.TestRouteBase.LineMileage.ToString(),
tr.TestRouteBase.Material.ToString(),
tr.TestRouteBase.Time.ToString(),
tr.TestRouteBase.Picture.ToString(),
}, "Idx", tr.TestRouteBase.Index.ToString()
);
//删除测试路线对应的所有路面类型信息
DeleteAllPavementTypeInfo(tr.TestRouteBase.Index);
//再增加测试路线对应的所有路面类型信息
for (int i = 0; i < tr.PavementTypeInfo.Count(); i++)
{
db.InsertInto("PavementTypeInfo", new string[]
{ "Idx", "Name", "Length", "Percent", "Picture" },
new string[] {
tr.TestRouteBase.Index.ToString(),
tr.PavementTypeInfo[i].Name.ToString(),
tr.PavementTypeInfo[i].Length.ToString(),
tr.PavementTypeInfo[i].Percent.ToString(),
tr.PavementTypeInfo[i].Picture.ToString()
});
}
}
/// <summary>
/// 插入仪器信息 注意：时间插入时需要equ.TermOfValidity.ToString("s")后面加s
/// </summary>
/// <param name="equ"></param>
public void Insert(Equipment equ)
{
//不需要插入主键自增值
db.InsertInto(
"EquipmentInfo",
new string[] { "Name", "Code", "TermOfValidity", "Picture" },
new string[] { equ.Name.ToString(), equ.Code.ToString(), equ.TermOfValidity.ToString("s"), equ.Picture.ToString() });
}
/// <summary>
/// 增加用户信息
/// </summary>
/// <param name="tr"></param>
public void Insert(User user)
{
//增加用户信息
db.InsertInto("UserInfo", new string[]
{ "UserName", "PassWord",
"Type", "Picture" },
new string[] {
user.UserName.ToString(),
user.PassWord.ToString(),
user.Type.ToString(),
user.Picture.ToString(),
});
}
/// <summary>
/// 插入车辆信息 注意：时间插入时需要car.BuyingTime.ToString("s")后面加s
/// </summary>
/// <param name="car"></param>
public void Insert(Car car)
{
db.InsertInto(
"CarInfo",
new string[] { "Type", "CarNumber", "SeatNum", "CurbWeight", "FullRated",
"Displacement", "FrontSuspensionSystem", "RearSuspensionSystem", "DriveMethod",
"Gearbox", "Brake", "BuyingTime", "InitialOdometerReading", "Picture" },
new string[] {
car.Type.ToString(),
car.CarNumber.ToString(),
car.SeatNum.ToString(),
car.CurbWeight.ToString(),
car.FullRated.ToString(),
car.Displacement.ToString(),
car.FrontSuspensionSystem.ToString(),
car.RearSuspensionSystem.ToString(),
car.DriveMethod.ToString(), car.Gearbox.ToString(),
car.Brake.ToString(),
car.BuyingTime.ToString("s"),
car.InitialOdometerReading.ToString(),
car.Picture.ToString()
});
}
