/// <summary>
///获取所有车辆 分页
/// </summary>
/// <param name="vehicle"></param>
/// <param name="PageIndex"></param>
/// <param name="PageSize"></param>
/// <param name="RowCount"></param>
/// <returns></returns>
public IEnumerable <CRMVehicle> GetAllVehicle(CRMVehicle Vehicle, string vehicle, int PageIndex, int PageSize, out int RowCount)
{
string Where = SqlWhere(vehicle);
int tempRowCount = 0;
DbParam[] dbParams = new DbParam[] {
new DbParam("@Where", DbType.String, Where, ParameterDirection.Input),
new DbParam("@PageIndex", DbType.Int32, PageIndex, ParameterDirection.Input),
new DbParam("@PageSize", DbType.Int32, PageSize, ParameterDirection.Input),
new DbParam("@RowCount", DbType.Int32, tempRowCount, ParameterDirection.Output)
};
DataTable dt = this.ExecuteDataTable("Proc_GetAllVehicle", dbParams);
RowCount = (int)dbParams[3].Value;
return(dt.ConvertToEntityCollection <CRMVehicle>());
}
public CRMVehicleToDb(CRMVehicle vehicle)
: base(s_metadata)
{
SetSqlInt64(0, vehicle.ID);
SetSqlString(1, vehicle.CarNo);
SetSqlString(2, vehicle.RunNo);
SetSqlString(3, vehicle.CarTypeNo);
SetSqlString(4, vehicle.CarVin);
SetSqlString(5, vehicle.SecurityContactNum);
SetSqlString(6, vehicle.LogisticCompany);
SetSqlDouble(7, vehicle.DrivedJourney);
SetSqlString(8, vehicle.Qualify);
SetSqlDateTime(9, vehicle.BoardlotDate);
SetSqlInt32(10, vehicle.CarAge);
SetSqlString(11, vehicle.CarNumType);
SetSqlString(12, vehicle.FuelType);
SetSqlString(13, vehicle.CarBodyColor);
SetSqlString(14, vehicle.Manufacturer);
SetSqlDateTime(15, vehicle.NextYearCheckDate);
SetSqlString(16, vehicle.Velocity_transducers);
SetSqlDateTime(17, vehicle.StartServiceDate);
SetSqlDateTime(18, vehicle.InsuranceEndDate);
SetSqlDouble(19, vehicle.EntireCarWeight);
SetSqlString(20, vehicle.MainRoute);
SetSqlDouble(21, vehicle.LoadWeight);
SetSqlInt32(22, vehicle.LoadPerson);
SetSqlString(23, vehicle.Size);
SetSqlDouble(24, vehicle.TotalWeight);
SetSqlDouble(25, vehicle.TractionWeight);
SetSqlInt32(26, vehicle.SafetyBeltAmount);
SetSqlBoolean(27, vehicle.BackUpBuzze);
SetSqlBoolean(28, vehicle.TheTankerOilSpillProtectionDevice);
SetSqlBoolean(29, vehicle.OilSpillPreventiontools);
SetSqlBoolean(30, vehicle.ReflectBar);
SetSqlBoolean(31, vehicle.HighSideStopLamps);
SetSqlBoolean(32, vehicle.DangerousMark);
SetSqlBoolean(33, vehicle.BackProtection);
SetSqlBoolean(34, vehicle.ThreePointBelt);
SetSqlBoolean(35, vehicle.RolloverProtect);
SetSqlBoolean(36, vehicle.ABS);
SetSqlInt32(37, vehicle.AirbagAmount);
SetSqlBoolean(38, vehicle.CarriageScope);
SetSqlString(39, vehicle.CarType);
SetSqlString(40, vehicle.TrailerNo);
SetSqlDouble(41, vehicle.TrailerLoadWeight);
SetSqlString(42, vehicle.TrailerSize);
SetSqlDouble(43, vehicle.TrailerTotalWeight);
SetSqlDouble(44, vehicle.TrailerEntireWeight);
SetSqlString(45, vehicle.TrailerTypeNo);
SetSqlDateTime(46, vehicle.TrailerBoardlotDate ?? SqlTypes.SqlDateTime.Null);
SetSqlString(47, vehicle.TrailerVin);
SetSqlDateTime(48, vehicle.TrailerNextYearCheckDate ?? SqlTypes.SqlDateTime.Null);
SetSqlDateTime(49, vehicle.CreateTime ?? SqlTypes.SqlDateTime.Null);
SetSqlDateTime(50, vehicle.UpdateTime ?? SqlTypes.SqlDateTime.Null);
SetSqlString(51, vehicle.CreateUser);
SetSqlString(52, vehicle.UpdateUser);
SetSqlString(53, vehicle.Str1);
SetSqlString(54, vehicle.Str2);
SetSqlString(55, vehicle.Str3);
SetSqlString(56, vehicle.Str4);
SetSqlString(57, vehicle.Str5);
SetSqlString(58, vehicle.Str6);
SetSqlString(59, vehicle.Str7);
SetSqlString(60, vehicle.Str8);
SetSqlString(61, vehicle.Str9);
SetSqlString(62, vehicle.Str10);
SetSqlString(63, vehicle.Str11);
SetSqlString(64, vehicle.Str12);
SetSqlString(65, vehicle.Str13);
SetSqlString(66, vehicle.Str14);
SetSqlString(67, vehicle.Str15);
SetSqlString(68, vehicle.Str16);
SetSqlString(69, vehicle.Str17);
SetSqlString(70, vehicle.Str18);
SetSqlString(71, vehicle.Str19);
SetSqlString(72, vehicle.Str20);
SetSqlDateTime(73, vehicle.Datetime1 ?? SqlTypes.SqlDateTime.Null);
SetSqlDateTime(74, vehicle.Datetime2 ?? SqlTypes.SqlDateTime.Null);
SetSqlDateTime(75, vehicle.Datetime3 ?? SqlTypes.SqlDateTime.Null);
SetSqlDateTime(76, vehicle.Datetime4 ?? SqlTypes.SqlDateTime.Null);
SetSqlDateTime(77, vehicle.Datetime5 ?? SqlTypes.SqlDateTime.Null);
SetSqlBoolean(78, vehicle.Bit1);
SetSqlBoolean(79, vehicle.Bit2);
SetSqlBoolean(80, vehicle.Bit3);
SetSqlString(81, vehicle.CarBodyPhoto);
SetSqlString(82, vehicle.CarFrontPhoto);
SetSqlString(83, vehicle.CarBackPhoto);
SetSqlString(84, vehicle.CarFloorPhoto);
}
