/// <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() }); }