94 lines
3.1 KiB
C#
94 lines
3.1 KiB
C#
using FineUIPro;
|
|
using System.Collections.Generic;
|
|
using System.Linq;
|
|
|
|
namespace BLL
|
|
{
|
|
/// <summary>
|
|
/// 机具设备
|
|
/// </summary>
|
|
public static class VehicleService
|
|
{
|
|
public static Model.SGGLDB db = Funs.DB;
|
|
|
|
/// <summary>
|
|
/// 根据主键获取机具设备
|
|
/// </summary>
|
|
/// <param name="vehicleId"></param>
|
|
/// <returns></returns>
|
|
public static Model.HSSE_Vehicle GetVehicleById(string vehicleId)
|
|
{
|
|
return Funs.DB.HSSE_Vehicle.FirstOrDefault(e => e.VehicleId == vehicleId);
|
|
}
|
|
|
|
/// <summary>
|
|
/// 添加机具设备
|
|
/// </summary>
|
|
/// <param name="specialEquipment"></param>
|
|
public static void AddVehicle(Model.HSSE_Vehicle vehicle)
|
|
{
|
|
Model.SGGLDB db = Funs.DB;
|
|
Model.HSSE_Vehicle newVehicle = new Model.HSSE_Vehicle
|
|
{
|
|
VehicleId = vehicle.VehicleId,
|
|
VehType = vehicle.VehType,
|
|
OperatorName = vehicle. OperatorName,
|
|
Remark = vehicle.Remark,
|
|
CarNo = vehicle.CarNo,
|
|
Phone = vehicle.Phone,
|
|
BeginTime = vehicle.BeginTime,
|
|
EndTime = vehicle.EndTime,
|
|
ProjectId = vehicle.ProjectId,
|
|
UnitId = vehicle.UnitId,
|
|
CreateDate = vehicle.CreateDate,
|
|
CompileMan = vehicle.CompileMan,
|
|
};
|
|
db.HSSE_Vehicle.InsertOnSubmit(newVehicle);
|
|
db.SubmitChanges();
|
|
}
|
|
|
|
/// <summary>
|
|
/// 修改机具设备
|
|
/// </summary>
|
|
/// <param name="specialEquipment"></param>
|
|
public static void UpdateVehicle(Model.HSSE_Vehicle vehicle)
|
|
{
|
|
Model.SGGLDB db = Funs.DB;
|
|
Model.HSSE_Vehicle newVehicle = db.HSSE_Vehicle.FirstOrDefault(e => e.VehicleId == vehicle.VehicleId);
|
|
if (newVehicle != null)
|
|
{
|
|
newVehicle.Phone = vehicle.Phone;
|
|
newVehicle.OperatorName = vehicle.OperatorName;
|
|
newVehicle.UnitId = vehicle.UnitId;
|
|
newVehicle.VehType = vehicle.VehType;
|
|
newVehicle.CarNo = vehicle.CarNo;
|
|
newVehicle.BeginTime = vehicle.BeginTime;
|
|
newVehicle.EndTime = vehicle.EndTime;
|
|
newVehicle.ProjectId = vehicle.ProjectId;
|
|
newVehicle.Remark = vehicle.Remark;
|
|
newVehicle.CompileMan = vehicle.CompileMan;
|
|
newVehicle.CreateDate = newVehicle.CreateDate;
|
|
db.SubmitChanges();
|
|
}
|
|
}
|
|
|
|
/// <summary>
|
|
/// 根据主键删除机具设备
|
|
/// </summary>
|
|
/// <param name="specialEquipmentId"></param>
|
|
public static void DeleteVehicleById(string vehicleId)
|
|
{
|
|
Model.SGGLDB db = Funs.DB;
|
|
Model.HSSE_Vehicle vehicle = db.HSSE_Vehicle.FirstOrDefault(e => e.VehicleId == vehicleId);
|
|
if (vehicle != null)
|
|
{
|
|
db.HSSE_Vehicle.DeleteOnSubmit(vehicle);
|
|
db.SubmitChanges();
|
|
}
|
|
}
|
|
|
|
|
|
|
|
|
|
}
|
|
} |