public bool UpdateVehicleAuditStatus(Guid carId, int status)
{
VehicleAuditInfoModel appeal = DalVehicleTypeCertificationAuditLog.GetVehicleAuthAppeal(carId);
using (var client = new VehicleClient())
{
var response = client.UpdateVehicleTypeCertificationStatus(new VehicleTypeCertificationRequest()
{
CarId = carId,
Status = status,
CarNo = appeal?.CarNumber,
Channel = appeal?.Channel,
EngineNo = appeal?.EngineNo,
Vehicle_license_img = appeal?.ImageUrl,
User_IdCard_img = appeal?.IdCardUrl,
VinCode = appeal?.VinCode,
Registrationtime = appeal?.car_Registrationtime
});
if (response.Success && status > 0)
{
using (var db = Tuhu.Component.Common.DbHelper.CreateDefaultDbHelper())
{
DalVehicleTypeCertificationAuditLog.UpdateVehicleAuditStatus(db, carId, status);
}
}
return(response.Success);
}
}
public static bool UpdateVehicleTypeCertificationInfo(BaseDbHelper db, VehicleAuditInfoModel request)
{
using (var cmd =
new SqlCommand(
@"Update Tuhu_Profiles..VehicleTypeCertificationInfo WITH(ROWLOCK) SET Vehicle_license_img=@Vehicle_license_img,User_IdCard_img=@User_IdCard_img where CarId=@CarId")
)
{
cmd.Parameters.AddWithValue("@Vehicle_license_img", request.ImageUrl);
cmd.Parameters.AddWithValue("@User_IdCard_img", request.IdCardUrl);
cmd.Parameters.AddWithValue("@CarId", request.CarId);
cmd.CommandType = CommandType.Text;
return(db.ExecuteNonQuery(cmd) > 0);
}
}
public static bool UpdateCarObject(BaseDbHelper db, VehicleAuditInfoModel request)
{
using (var cmd =
new SqlCommand(
@"Update Tuhu_Profiles..CarObject WITH(ROWLOCK) SET VinCode=@VinCode,ClassNo=@ClassNo,u_carno=@CarNo,Engineno=@EngineNo where CarId=@CarId")
)
{
cmd.Parameters.AddWithValue("@VinCode", request.VinCode);
cmd.Parameters.AddWithValue("@CarNo", request.CarNumber);
cmd.Parameters.AddWithValue("@CarId", request.CarId);
cmd.Parameters.AddWithValue("@ClassNo", request.VinCode);
cmd.Parameters.AddWithValue("@EngineNo", request.EngineNo);
cmd.CommandType = CommandType.Text;
return(db.ExecuteNonQuery(cmd) > 0);
}
}
